# Upload Assertions

Previous interpretations can be uploaded to My Knowledge Base at any time (e.g., during onboarding) so you can immediately start prioritizing variants and reporting based on information from your lab.

## Upload Assertions

1. Navigate to the app selector (grid icon) in the top-right of the screen.
2. Select **My Knowledge Base**.
3. In My Knowledge Base screen, select **Add Assertions** in the top-righ&#x74;**.**
4. Select **attached template** to download the upload CSV template.
5. Edit the template by adding values to the columns. After editing, save the file.
6. Upload the template file. The maximum upload file size is 10 MB.
7. The file will begin processing. To view the processing status, select **View Past Uploads** icon in the top-right of the My Knowledge Base screen.
8. If a file has issues, download the file and view the issues in a new error column provided in the download. Issues can be resolved in the file and re-uploaded.

{% hint style="warning" %}
If using Excel, make sure that no auto-formatting has occurred.
{% endhint %}

## Editing the CSV Template

Depending on the type of assertion you want to upload, only certain columns are required.

### Required Assertion Columns

| Assertion Type   | Required Columns                                                                                                                                                                                                                                                                                     |
| ---------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Biological       | <ul><li>type = Biological</li><li>classificationName</li><li>classificationOrder</li><li>classificationBackgroundColor</li><li>summary</li><li>diseaseName</li><li>diseaseOntology</li><li>diseaseOntologyId</li><li><a href="#biomarker-columns">biomarker columns</a></li></ul>                    |
| Diagnostic       | <ul><li>type = Diagnostic</li><li>classificationName</li><li>classificationOrder</li><li>classificationBackgroundColor</li><li>summary</li><li>diseaseName</li><li>diseaseOntology</li><li>diseaseOntologyId</li><li><a href="#biomarker-columns">biomarker columns</a></li></ul>                    |
| Prognostic       | <ul><li>type = Prognostic</li><li>classificationName</li><li>classificationOrder</li><li>classificationBackgroundColor</li><li>summary</li><li>diseaseName</li><li>diseaseOntology</li><li>diseaseOntologyId</li><li>direction</li><li><a href="#biomarker-columns">biomarker columns</a></li></ul>  |
| Therapeutic      | <ul><li>type = Therapeutic</li><li>classificationName</li><li>classificationOrder</li><li>classificationBackgroundColor</li><li>summary</li><li>diseaseName</li><li>diseaseOntology</li><li>diseaseOntologyId</li><li>direction</li><li><a href="#biomarker-columns">biomarker columns</a></li></ul> |
| Gene Description | <ul><li>type = Gene Information</li><li>geneRoles</li><li>summary</li><li><a href="#biomarker-columns">biomarker columns</a> (use Small Variant, Gene Level below)</li></ul>                                                                                                                         |

### Required Biomarker Columns

Depending on the type of biomarker the assertion is about, only certain columns are required.

| Biomarker Type      | Level              | Example                       | Required Columns                                                                                                                     |
| ------------------- | ------------------ | ----------------------------- | ------------------------------------------------------------------------------------------------------------------------------------ |
| Small Variant       | Nucleotide         | 11:108115594 C > T            | <ul><li>genomeBuild</li><li>chromosome</li><li>position</li><li>ref</li><li>alt</li><li>geneSymbol</li></ul>                         |
|                     | Amino Acid         | BRAF p.(Val600Glu)            | <ul><li>genomeBuild</li><li>transcriptId</li><li>hgvsp</li><li>geneSymbol</li></ul>                                                  |
|                     | Codon              | BRAF p.(Val600)               | <ul><li>genomeBuild</li><li>transcriptId</li><li>codon</li><li>geneSymbol</li></ul>                                                  |
|                     | Exon               | EGFR exon 19 deletion         | <ul><li>genomeBuild</li><li>transcriptId</li><li>exon</li><li>geneSymbol</li><li>consequences (recommended)</li></ul>                |
|                     | Gene               | ASXL1 oncogenic variant       | <ul><li>genomeBuild</li><li>geneSymbol</li><li>consequences (recommended)</li></ul>                                                  |
| Copy Number Variant | Annotation Overlap | 17:37844990-37884569 gain     | <ul><li>variantType</li><li>genomeBuild</li><li>chromosome</li><li>position</li><li>end</li><li>consequences (recommended)</li></ul> |
|                     | Exon               | BRCA1 2-11 copy number gain   | <ul><li>genomeBuild</li><li>transcriptId</li><li>exon</li><li>geneSymbol</li><li>consequences (recommended)</li></ul>                |
|                     | Gene               | TP53 copy number loss         | <ul><li>variantType</li><li>genomeBuild</li><li>geneSymbol</li><li>consequences (recommended)</li></ul>                              |
| Structural Variant  | Annotation Overlap | 17:37844990-37884569 deletion | <ul><li>variantType</li><li>genomeBuild</li><li>chromosome</li><li>position</li><li>end</li><li>consequences (recommended)</li></ul> |
|                     | Partial fusion     | ALK fusion                    | <ul><li>genomeBuild</li><li>geneSymbol</li></ul>                                                                                     |
|                     | Exact fusion       | EML4::ALK fusion              | <ul><li>genomeBuild</li><li>geneSymbol</li><li>fusionGeneSymbol</li><li>fusionPosition</li></ul>                                     |
| RNA Splice Variant  | Exon               | MET exon 14 skipping          | <ul><li>genomeBuild</li><li>transcriptId</li><li>exon</li><li>geneSymbol</li><li>consequences (recommended)</li></ul>                |
| RNA Fusion Variant  | Partial Fusion     | ALK fusion                    | <ul><li>genomeBuild</li><li>geneSymbol</li></ul>                                                                                     |
|                     | Exact Fusion       | EML4::ALK fusion              | <ul><li>genomeBuild</li><li>geneSymbol</li><li>fusionGeneSymbol</li><li>fusionPosition</li></ul>                                     |
| Genomic Analysis    | TMB                | TMB high                      | <ul><li>status</li></ul>                                                                                                             |
|                     | MSI                | MSI high                      | <ul><li>status</li></ul>                                                                                                             |
|                     | GIS                | GIS high                      | <ul><li>status</li></ul>                                                                                                             |

### Acceptable Column Values

<table data-full-width="false"><thead><tr><th width="278">Column</th><th>Acceptable Values</th></tr></thead><tbody><tr><td>externalid</td><td>A free text value that can be used to trace the assertion back to the originating system.</td></tr><tr><td>type</td><td>• Biological<br>• Therapeutic<br>• Prognostic<br>• Diagnostic<br>• Gene Information</td></tr><tr><td>classificationName</td><td><p>We recommend using the same classifications specified in the <a href="configuration/c-custom-actionability-classification">Configuration</a> screen.</p><p>Examples are as follows:<br></p><p>For Biological:<br>• Oncogenic</p><p>• Likely Oncogenic<br>• Uncertain Significance<br>• Likely Benign<br>• Benign<br></p><p>For Therapeutic, Prognostic, Diagnostic:<br>• Tier 1A<br>• Tier 1B<br>• Tier 2C</p><p>• Tier 2D<br>• Tier 3<br>• Tier 4</p></td></tr><tr><td>classificationOrder</td><td><p>We recommend using the same classifications specified in the <a href="configuration/c-custom-actionability-classification">Configuration</a> screen.</p><p>Examples are as follows:<br></p><p>For Biological:<br>• For Oncogenic, 1.0<br>• For Likely Oncogenic, 2.0<br>• For Uncertain Significance, 3.0<br>• For Likely Benign, 4.0<br>• For Benign, 5.0<br></p><p>For Therapeutic, Prognostic, Diagnostic:<br>• For Tier 1A, 1.0<br>• For Tier 1B, 2.0<br>• For Tier 2C, 3.0<br>• For Tier 2D, 4.0<br>• For Tier 3, 5.0<br>• For Tier 4, 6.0<br></p><p>When multiple classifications map to the same AMP/ASCO/CAP tier, increment the tenths value. For example, if Level 1 and Level 2 both map to Tier 1A, the classificationOrder is as follows:<br>• Level 1, 1.0<br>• Level 2, 1.1</p></td></tr><tr><td>classificationBackgroundColor</td><td><p>We recommend using the same classification specified in the <a href="configuration/c-custom-actionability-classification">Configuration</a> screen.<br></p><p>Examples are as follows:<br></p><p>For Biological:<br>• For Pathogenic, red<br>• For Likely Pathogenic, pink<br>• For Uncertain Significance, yellow<br>• For Likely Benign, light green<br>• For Benign, green<br></p><p>For Therapeutic, Prognostic, Diagnostic:<br>• For Tier 1A, red<br>• For Tier 1B, red<br>• For Tier 2C, violet<br>• For Tier 2D, violet<br>• For Tier 3, blue<br>• For Tier 4, green</p></td></tr><tr><td>direction</td><td><p>For Therapeutic:<br>• Responsive<br>• Non-responsive<br>• Contraindicated<br></p><p>For Prognostic:<br>• Favorable<br>• Unfavorable</p></td></tr><tr><td>status</td><td>For TMB:<br>• High<br>• Low<br><br>For MSI:<br>• High<br>• Stable<br><br>For GIS:<br>• High<br>• Low</td></tr><tr><td>hrd</td><td><p>• Undetermined<br>• Positive<br>• Negative<br></p><p>When interpreting biomarkers in a case, this information is visible for BRCA1/2 variants and GIS.</p></td></tr><tr><td>geneRoles</td><td>• Oncogene<br>• Tumor Suppressor<br>• Oncogene / Tumor Suppressor</td></tr><tr><td>summary</td><td>You can specify up to 30,000 characters. This information is included in PDF reports.</td></tr><tr><td>notes</td><td>You can specify up to 30,000 characters. This information is not included in PDF reports.</td></tr><tr><td>diseaseName</td><td>This can be found by searching for the disease using <a href="https://browser.ihtsdotools.org/">SNOMED International SNOMED CT Browser website</a>.</td></tr><tr><td>diseaseOntology</td><td>A required field that specifies the disease ontology. We currently recommend using SNOMEDCT.</td></tr><tr><td>diseaseOntologyID</td><td>This can be found by searching for the disease using <a href="https://browser.ihtsdotools.org/">SNOMED International SNOMED CT Browser website</a>.</td></tr><tr><td>therapy</td><td>Drug name. Multiple drug names can be specified by separating them with a pipe |.</td></tr><tr><td>biomarkerType</td><td>• Small variant<br>• Copy number variant<br>• Structural variant<br>• RNA splice variant<br>• RNA fusion variant<br>• Genomic analysis (i.e., TMB, MSI, GIS)</td></tr><tr><td>variantType</td><td><p>For Copy Number Variant:<br>• Copy number variation<br>• Copy number loss<br>• Copy number gain<br>• Copy number neutral</p><p>For Structural Variant:<br>• Tandem duplication<br>• Insertion<br>• Deletion<br>• Inversion<br>• Translocation</p></td></tr><tr><td>level</td><td><p>For Small variants:<br>• Nucleotide<br>• Amino Acid<br>• Codon<br>• Exon<br>• Gene<br></p><p>For Copy number variants:<br>• Annotation overlap<br>• Gene<br></p><p>For Structural variants:<br>• Annotation overlap, if variant type is not Translocation<br>• Partial fusion<br>• Exact fusion<br></p><p>For RNA splice variants:<br>• Annotation overlap<br>• Exon<br></p><p>For RNA fusion variants:<br>• Partial fusion<br>• Exact fusion<br></p><p>For Genomic analysis:<br>• TMB<br>• MSI<br>• GIS</p></td></tr><tr><td>genomeBuild</td><td>• 37<br>• 38</td></tr><tr><td>chromosome</td><td>• 1–22<br>• X<br>• Y<br>• MT</td></tr><tr><td>position</td><td>The VCF position. Acceptable values are within the chromosome range.</td></tr><tr><td>end</td><td>The VCF position. Acceptable values are within the chromosome range.</td></tr><tr><td>ref</td><td>The VCF reference allele. Acceptable values are combinations of A, T, C, G.</td></tr><tr><td>alt</td><td>The VCF alternate allele. Acceptable values are combinations of A, T, C, G.</td></tr><tr><td>transcriptId</td><td>Acceptable values are RefSeq and Ensembl transcript IDs, with or without the version.</td></tr><tr><td>codon</td><td>Acceptable values are a three-letter hgvsp abbreviation, including prefix “p.(“ and suffix “)” and without the amino acid change, such as p.(Val600).</td></tr><tr><td>hgvs</td><td>Acceptable values are a three-letter hgvsp abbreviation, including prefix “p.(“ and suffix “)”, such as p.(Val600Glu).</td></tr><tr><td>exon</td><td>Exon #</td></tr><tr><td>geneSymbol</td><td>NCBI gene symbol (e.g., BRAF)</td></tr><tr><td>ncbiGeneId</td><td>NCBI gene ID (e.g., 673)</td></tr><tr><td>fusionGeneSymbol</td><td>Fusion NCBI gene symbol (e.g., ALK)</td></tr><tr><td>fusionNcbiGeneID</td><td>Fusion NCBI gene ID (e.g., 238)</td></tr><tr><td>fusionPosition</td><td>Acceptable values are 0 and 1.<br>• Without a value, the fusion directionality is unspecified, such as EML4/ALK.<br>• If 0 is provided, the fusion is at position 0, such as [fusion gene]-[gene].<br>• If 1 is provided, the fusion is at position 1, such as [gene]-[fusion gene].</td></tr><tr><td>consequence</td><td><p>When a consequence is specified, the assertion only matches to a case variant that has the consequence specified, such as EGFR exon 19 inframe deletion.</p><p><br>For small variant, exon level:<br>• 3_prime_UTR_variant<br>• 5_prime_UTR_variant<br>• coding_sequence_variant<br>• downstream_gene_variant<br>• frameshift_variant<br>• inframe_deletion<br>• inframe_insertion<br>• intron_variant<br>• mature_miRNA_variant<br>• missense_variant<br>• NMD_transcript_variant<br>• non-coding_transcript_exon_variant<br>• non-coding_transcript_variant<br>• protein_altering_variant<br>• splice_acceptor_variant<br>• splice_donor_variant<br>• splice_region_variant<br>• stop_retained_variant<br>• synonymous_variant<br>• upstream_gene_variant<br></p><p>For small variant, gene level:<br>• start_lost<br>• stop_gained<br>• stop_lost<br>• incomplete_terminal_codon_variant<br>• feature_elongation<br>• feature_truncation<br>• splice_donor_variant<br>• splice_acceptor_varian<br>• splice_region_variant<br>• frameshift_variant<br>• inframe_deletion<br>• inframe_insertion<br>• missense_variant<br>• protein_altering_variant<br>• coding_sequence_variant<br>• upstream_gene_variant<br>• downstream_gene_variant<br>• intron_variant<br>• 5_prime_UTR_variant<br>• 3_prime_UTR_variant<br>• non-coding_transcript_exon_variant<br>• non-coding_transcript_variant<br>• synonymous_variant<br>• start_retained_variant<br>• stop_retained_variant<br>• mature_miRNA_variant<br>• NMD_transcript_variant<br>• regulatory_region_ablation<br>• regulatory_region_amplification<br>• regulatory_region_variation<br></p><p>For copy number variant, gene level:<br>• copy_number_decrease<br>• copy_number_increase<br>• copy_number_change<br></p><p>For RNA splice variant, exon level:<br>• exon_loss_variant</p></td></tr></tbody></table>
