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 | — | — | 10825224 10292991 10648032 10431811 11697264 +5 more | — |
| 3 | PATIENTID | — | — | 240001189 240001214 240001251 240001264 240001280 +5 more | — |
| 4 | GENE_DESC | — | — | MDM2 ALK PMS2 ROS1 SS18 +5 more | — |
| 5 | GENE | — | — | 60 79 76 2804 4953 +5 more | — |
| 6 | COUNT_TESTS | — | — | 1 2 7 20 13 +5 more | — |
| 7 | COUNT_RESULTS | — | — | 2 1 7 13 4 +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 | — | — | n:not_applicable_null a:abnormal_dna_sq b:normal_dna_sq c:borderline_a_dna_sq | — |
| 13 | METHYL_GAT | — | — | b:normal_epi c:borderline_a_methyl n:not_applicable_null a:abnormal_methyl | — |
| 14 | EXP_GAT | — | — | b:normal_exp ca:borderline_a_under_exp cb:borderline_a_over_exp ab:abnormal_over_exp aa:abnormal_under_exp +1 more | — |
| 15 | COPYNO_GAT | — | — | b:normal_copy_no cb:borderline_a_copy_no_gain ab:abnormal_copy_no_gain aa:abnormal_copy_no_loss n:not_applicable_null | — |
| 16 | FUS_TRANS_GAT | — | — | a:abnormal_fusion/trans c:borderline_a_fusion/trans n:not_applicable_null b:normal_fusion/trans | — |
| 17 | ABNORMAL_GAT | — | — | dna_sq methyl over_exp copy_no_gain multiple +3 more | — |
| 18 | NO_OF_SEQ_VARS | — | — | 3 5 2 4 0 +1 more | — |
| 19 | ALL_SEQ_VARS | — | — | c.34G>T c.182A>G c.1397G>T,c.35G>T c.182A>T c.183A>C +5 more | — |
| 20 | SEQ_VAR | — | — | c.38G>A c.34G>T c.182A>T c.37G>T c.1655C>T +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 | — | — | 2)requesteddate 4)collecteddate 1)authoriseddate 3)receiveddate | — |
| 23 | MIN_DATE | — | — | 2017-05-18 2018-05-01 2019-04-03 2019-11-16 2016-06-19 +5 more | — |
| 24 | MAX_DATE | — | — | 2018-05-03 2017-02-22 2018-12-25 2016-06-20 2016-10-18 +5 more | — |
| 25 | ALL_PRO_IMPS | — | — | p.Val600Glu p.(Thr41Ala) p.V600X p.(Tyr234Cys) p.(Arg139Gln),p.(Arg166Gln),p.(Trp106Leu),p.(Trp79Leu) +5 more | — |
| 26 | NO_OF_PRO_IMPS | — | — | 0 1 4 2 3 +1 more | — |
| 27 | PRO_IMP | — | — | p.(Val600Lys) p.V600X p.(Gln61His) p.(Gly12Asp) p.(Arg175His) +5 more | — |
| 28 | METHODS | — | — | Pyrosequencing SSCP FISH - Specific Probe DNA methylation / imprinting / epigenetic analysis Roche COBAS,Sequencing, Next Generation (NGS) +5 more | — |
| 29 | LAB_NAME | — | — | Newcastle (molecular lab) Pathology lab Sheffield (molecular lab) Birmingham (molecular lab),Pathology lab,Unknown Manchester (molecular lab),Sheffield (molecular lab) +5 more | — |