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 | — | — | 11444836 11327505 11462240 11360168 11280858 +5 more | — |
| 3 | PATIENTID | — | — | 240001192 240001197 240001207 240001233 240001244 +5 more | — |
| 4 | GENE_DESC | — | — | MDM2 ALK PMS2 ROS1 SS18 +5 more | — |
| 5 | GENE | — | — | 60 79 4954 2804 30 +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 1 2 +5 more | — |
| 9 | ALL_TESTSTATUSES | — | — | a:abnormal a:abnormal,a:abnormal e:failed e:failed,b:normal g:unknown/null,g:unknown/null +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 | — | — | b:normal_epi c:borderline_a_methyl n:not_applicable_null a:abnormal_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 ab:abnormal_copy_no_gain aa:abnormal_copy_no_loss n:not_applicable_null | — |
| 16 | FUS_TRANS_GAT | — | — | n:not_applicable_null b:normal_fusion/trans c:borderline_a_fusion/trans a:abnormal_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 2 4 0 +1 more | — |
| 19 | ALL_SEQ_VARS | — | — | c.38G>A c.34G>T c.182A>T c.37G>T c.1655C>T +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 | — | — | 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 | — | — | 2016-08-13 2016-05-02 2019-12-09 2016-10-19 2016-02-04 +5 more | — |
| 24 | MAX_DATE | — | — | 2016-01-29 2018-07-06 2016-08-29 2019-12-23 2019-03-24 +5 more | — |
| 25 | ALL_PRO_IMPS | — | — | p.(Val600Lys) p.V600X p.(Gln61His) p.(Gly12Asp) p.(Arg175His) +5 more | — |
| 26 | NO_OF_PRO_IMPS | — | — | 3 5 0 1 4 +1 more | — |
| 27 | PRO_IMP | — | — | p.Val600Glu p.(Thr41Ala) p.V600X p.(Tyr234Cys) p.Val561Asp +5 more | — |
| 28 | METHODS | — | — | Mass Spectrometry Genotyping / MALDI-TOF Sequencing, Dideoxy/Sanger High Resolution Melt (HRM) / Melting curve analysis Immunochemistry,Unknown Immunochemistry,Sequencing, Next Generation (NGS) +5 more | — |
| 29 | LAB_NAME | — | — | Birmingham (molecular lab),Unknown Leeds (molecular lab) Liverpool (molecular lab),Pathology lab Birmingham (molecular lab) Birmingham (molecular lab),Pathology lab +5 more | — |