| field | example | SQL type | description |
|---|
| geneId | ENSG00000004059.12_10 | varchar(255) | Gene identifier |
| geneName | ARF5 | varchar(255) | Gene name |
| geneType | protein_coding | varchar(255) | BioType of gene |
| geneStatus | | varchar(255) | Status of gene (obsolete) |
| transcriptId | ENST00000000233.10_4 | varchar(255) | Transcript identifier |
| transcriptName | ARF5-201 | varchar(255) | Transcript name |
| transcriptType | protein_coding | varchar(255) | BioType of transcript |
| transcriptStatus | | varchar(255) | Status of transcript (obsolete) |
| havanaGeneId | OTTHUMG00000023246.7_10 | varchar(255) | HAVANA identifier if gene is in HAVANA |
| havanaTranscriptId | OTTHUMT00000059567.3_4 | varchar(255) | HAVANA identifier if transcript is in HAVANA |
| ccdsId | CCDS34745.1 | varchar(255) | CCDS identifier if transcript is in CCDS |
| level | 2 | int(11) | GENCODE level: 1 = experimental confirmed, 2 = manual, 3 = automated |
| transcriptClass | coding | varchar(255) | high level type of transcript |
| proteinId | ENSP00000000233.5 | varchar(255) | Protein identifier (not loaded on many older versions of GENCODE) |
| transcriptRank | 0 | int(11) | Rank of transcript within the gene, smaller is more preferred |