V2 av_gene
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | GENEID | — | — | 240001188 240001194 240001204 240001212 240001217 +5 more | — |
| 2 | TUMOURID | — | — | 11444836 11327505 11462240 11360168 11280858 +5 more | — |
| 3 | PATIENTID | — | — | 240001188 240001194 240001204 240001212 240001217 +5 more | — |
| 4 | GENE_DESC | — | — | BCL2 MPL NPM1 SDHB MYD88 +5 more | — |
| 5 | GENE | — | — | 26 2744 24 51 2779 +5 more | — |
| 6 | COUNT_TESTS | — | — | 1 2 7 20 13 +5 more | — |
| 7 | COUNT_RESULTS | — | — | 4 18 9 22 8 +5 more | — |
| 8 | COUNT_DATE | — | — | 1 2 7 20 13 +5 more | — |
| 9 | ALL_TESTSTATUSES | — | — | b:normal,b:normal a:abnormal,b:normal g:unknown/null b:normal,b:normal,b:normal f:not_tested,f:not_tested +5 more | — |
| 10 | OVERALL_TS | — | — | b:normal g:unknown/null a:abnormal e:failed d:antibody_staining +2 more | — |
| 11 | NO_OF_AB_GATS | — | — | 3 0 1 2 | — |
| 12 | DNASEQ_GAT | — | — | c:borderline_a_dna_sq n:not_applicable_null a:abnormal_dna_sq b:normal_dna_sq | — |
| 13 | METHYL_GAT | — | — | n:not_applicable_null b:normal_epi c:borderline_a_methyl a:abnormal_methyl | — |
| 14 | EXP_GAT | — | — | b:normal_exp n:not_applicable_null ca:borderline_a_under_exp cb:borderline_a_over_exp ab:abnormal_over_exp +1 more | — |
| 15 | COPYNO_GAT | — | — | n:not_applicable_null ab:abnormal_copy_no_gain aa:abnormal_copy_no_loss b:normal_copy_no cb:borderline_a_copy_no_gain | — |
| 16 | FUS_TRANS_GAT | — | — | a:abnormal_fusion/trans n:not_applicable_null b:normal_fusion/trans c:borderline_a_fusion/trans | — |
| 17 | ABNORMAL_GAT | — | — | under_exp fus_trans copy_no_gain copy_no_loss multiple +3 more | — |
| 18 | NO_OF_SEQ_VARS | — | — | 2 4 0 1 3 +1 more | — |
| 19 | ALL_SEQ_VARS | — | — | c.1799T>A c.1666_1695dup c.1682T>A c.1698_1712del c.1676T>A +5 more | — |
| 20 | SEQ_VAR | — | — | c.1544G>T c.427G>A c.133T>C c.2528_2539del12 c.578A>G +5 more | — |
| 21 | DATE_OVERALL_TS | — | — | 2018-05-03 2017-02-22 2018-12-25 2016-06-20 2016-10-18 +5 more | — |
| 22 | BEST_DATE_SOURCE_OVERALL_TS | — | — | 1)authoriseddate 3)receiveddate 4)collecteddate 2)requesteddate | — |
| 23 | MIN_DATE | — | — | 2017-05-18 2018-05-01 2019-04-03 2019-11-16 2016-06-19 +5 more | — |
| 24 | MAX_DATE | — | — | 2016-05-04 2019-11-16 2016-05-06 2017-05-19 2018-02-11 +5 more | — |
| 25 | ALL_PRO_IMPS | — | — | p.(Ile195Thr) p.(Asp842Val) p.Asp842Val p.(Trp515Leu) p.(Arg140Gln) +5 more | — |
| 26 | NO_OF_PRO_IMPS | — | — | 3 5 4 2 0 +1 more | — |
| 27 | PRO_IMP | — | — | p.(Val600Glu) p.(Leu858Arg) p.(Gly12Val) p.(Gly13Asp) p.Gly12Asp +5 more | — |
| 28 | METHODS | — | — | Fragment length analysis Mass Spectrometry Genotyping / MALDI-TOF Sequencing, Dideoxy/Sanger Gene Expression testing / RT-PCR Gene Expression testing / RT-PCR,Sequencing, Next Generation (NGS) +5 more | — |
| 29 | LAB_NAME | — | — | Birmingham (molecular lab),Unknown Leeds (molecular lab) Liverpool (molecular lab),Pathology lab Unknown Cambridge (molecular lab) +5 more | — |