V2 av_gene
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | GENEID | — | — | 240001191 240001203 240001209 240001210 240001216 +5 more | — |
| 2 | TUMOURID | — | — | 11444836 11462240 10019243 11989233 10527904 +5 more | — |
| 3 | PATIENTID | — | — | 240001189 240001192 240001197 240001207 240001214 +5 more | — |
| 4 | GENE_DESC | — | — | EGFR NRAS ERBB2 (HER2 / NEU) MPL TP53 +5 more | — |
| 5 | GENE | — | — | 26 2744 24 51 2779 +5 more | — |
| 6 | COUNT_TESTS | — | — | 4 18 9 22 10 +5 more | — |
| 7 | COUNT_RESULTS | — | — | 4 18 9 22 8 +5 more | — |
| 8 | COUNT_DATE | — | — | 4 18 9 5 3 +5 more | — |
| 9 | ALL_TESTSTATUSES | — | — | b:normal a:abnormal,a:abnormal,a:abnormal a:abnormal,a:abnormal,b:normal,a:abnormal b:normal,b:normal,a:abnormal,b:normal c:borderline,c:borderline +5 more | — |
| 10 | OVERALL_TS | — | — | g:unknown/null b:normal f:not_tested c:borderline a:abnormal +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 a:abnormal_methyl b:normal_epi c:borderline_a_methyl | — |
| 14 | EXP_GAT | — | — | b:normal_exp n:not_applicable_null ab:abnormal_over_exp aa:abnormal_under_exp cb:borderline_a_over_exp +1 more | — |
| 15 | COPYNO_GAT | — | — | b:normal_copy_no cb:borderline_a_copy_no_gain n:not_applicable_null ab:abnormal_copy_no_gain aa:abnormal_copy_no_loss | — |
| 16 | FUS_TRANS_GAT | — | — | a:abnormal_fusion/trans n:not_applicable_null b:normal_fusion/trans c:borderline_a_fusion/trans | — |
| 17 | ABNORMAL_GAT | — | — | copy_no_gain multiple under_exp fus_trans copy_no_loss +3 more | — |
| 18 | NO_OF_SEQ_VARS | — | — | 3 5 0 1 2 +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.1798_1799delinsAG c.1799T>A c.2573T>G multiple c.1391G>T +5 more | — |
| 21 | DATE_OVERALL_TS | — | — | 2017-09-04 2018-07-27 2016-12-15 2017-02-21 2016-11-21 +5 more | — |
| 22 | BEST_DATE_SOURCE_OVERALL_TS | — | — | 2)requesteddate 4)collecteddate 1)authoriseddate 3)receiveddate | — |
| 23 | MIN_DATE | — | — | 2018-02-04 2018-08-14 2019-10-27 2017-07-02 2016-07-05 +5 more | — |
| 24 | MAX_DATE | — | — | 2019-12-09 2017-08-19 2016-07-05 2018-02-27 2018-04-19 +5 more | — |
| 25 | ALL_PRO_IMPS | — | — | p.(Gly13Cys) p.(L858R),p.(Leu858Arg) p.(Arg132His) p.L858R p.(E746_A750del) +5 more | — |
| 26 | NO_OF_PRO_IMPS | — | — | 3 5 0 1 2 +1 more | — |
| 27 | PRO_IMP | — | — | p.Val600Glu p.(Thr41Ala) p.V600X p.(Tyr234Cys) p.Val561Asp +5 more | — |
| 28 | METHODS | — | — | Pyrosequencing SSCP FISH - Specific Probe DNA methylation / imprinting / epigenetic analysis Roche COBAS,Sequencing, Dideoxy/Sanger +5 more | — |
| 29 | LAB_NAME | — | — | Leeds (molecular lab) Birmingham (molecular lab),Unknown Liverpool (molecular lab),Pathology lab Royal Marsden (molecular lab) Bristol (molecular lab) +5 more | — |