V2 av_gene
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | GENEID | — | — | 240001189 240001192 240001197 240001207 240001214 +5 more | — |
| 2 | TUMOURID | — | — | 11285425 11700563 10722020 10359971 11912474 +5 more | — |
| 3 | PATIENTID | — | — | 240001189 240001192 240001197 240001207 240001214 +5 more | — |
| 4 | GENE_DESC | — | — | NRAS ERBB2 (HER2 / NEU) TP53 SDHB EGFR +5 more | — |
| 5 | GENE | — | — | 3394 24 26 51 2744 +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 c:borderline f:not_tested 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 | — | — | b:normal_epi c:borderline_a_methyl a:abnormal_methyl n:not_applicable_null | — |
| 14 | EXP_GAT | — | — | b:normal_exp n:not_applicable_null ca:borderline_a_under_exp ab:abnormal_over_exp aa:abnormal_under_exp +1 more | — |
| 15 | COPYNO_GAT | — | — | n:not_applicable_null b:normal_copy_no cb:borderline_a_copy_no_gain ab:abnormal_copy_no_gain aa:abnormal_copy_no_loss | — |
| 16 | FUS_TRANS_GAT | — | — | n:not_applicable_null b:normal_fusion/trans c:borderline_a_fusion/trans a:abnormal_fusion/trans | — |
| 17 | ABNORMAL_GAT | — | — | dna_sq copy_no_gain fus_trans multiple under_exp +3 more | — |
| 18 | NO_OF_SEQ_VARS | — | — | 3 5 0 1 2 +1 more | — |
| 19 | ALL_SEQ_VARS | — | — | c.1798_1799delinsAG c.1799T>A c.2573T>G c.1391G>T c.2235del15 +5 more | — |
| 20 | SEQ_VAR | — | — | c.1798_1799delinsAG c.1799T>A c.2573T>G multiple c.1391G>T +5 more | — |
| 21 | DATE_OVERALL_TS | — | — | 2016-05-04 2019-11-16 2016-05-06 2017-05-19 2018-02-11 +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.(Gly13Cys) p.(L858R),p.(Leu858Arg) p.(Arg132His) p.L858R p.(E746_A750del) +5 more | — |
| 26 | NO_OF_PRO_IMPS | — | — | 0 1 3 5 2 +1 more | — |
| 27 | PRO_IMP | — | — | p.(Gly13Cys) multiple p.(Arg132His) p.L858R p.(E746_A750del) +5 more | — |
| 28 | METHODS | — | — | FISH - Specific Probe SSCP Pyrosequencing 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 Cambridge (molecular lab) Nottingham (molecular lab) +5 more | — |