| field | example | SQL type | info | description |
|---|
| bin | 611 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| name | NM_001305453 | varchar(255) | values | Name of gene (usually transcript_id from GTF) |
| chrom | KN264753v1 | varchar(255) | values | Reference sequence chromosome or scaffold |
| strand | - | char(1) | values | + or - for strand |
| txStart | 3441604 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
| txEnd | 3443783 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
| cdsStart | 3442204 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
| cdsEnd | 3443620 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
| exonCount | 1 | int(10) unsigned | range | Number of exons |
| exonStarts | 3441604, | longblob | | Exon start positions (or end positions for minus strand item) |
| exonEnds | 3443783, | longblob | | Exon end positions (or start positions for minus strand item) |
| score | 0 | int(11) | range | score |
| name2 | RUM1 | varchar(255) | values | Alternate name (e.g. gene_id from GTF) |
| cdsStartStat | cmpl | enum('none', 'unk', 'incmpl', 'cmpl') | values | Status of CDS start annotation (none, unknown, incomplete, or complete) |
| cdsEndStat | cmpl | enum('none', 'unk', 'incmpl', 'cmpl') | values | Status of CDS end annotation (none, unknown, incomplete, or complete) |
| exonFrames | 0, | longblob | | Reading frame of the start of the CDS region of the exon, in the direction of transcription (0,1,2), or -1 if there is no CDS region. |
US Server