|
|---|
| |
Database: micMur2 Primary Table: ensGene Row Count: 46,298 Data last updated: 2017-10-10
Format description: A gene prediction with some additional info.
On download server: MariaDB table dump directory
| field | example | SQL type | info | description |
|---|
| bin | 585 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| name | ENSMICT00000030746.1 | varchar(255) | values | Name of gene (usually transcript_id from GTF) |
| chrom | ABDC02000622v1 | varchar(255) | values | Reference sequence chromosome or scaffold |
| strand | + | char(1) | values | + or - for strand |
| txStart | 843 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
| txEnd | 981 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
| cdsStart | 981 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
| cdsEnd | 981 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
| exonCount | 1 | int(10) unsigned | range | Number of exons |
| exonStarts | 843, | longblob | | Exon start positions (or end positions for minus strand item) |
| exonEnds | 981, | longblob | | Exon end positions (or start positions for minus strand item) |
| score | 0 | int(11) | range | score |
| name2 | ENSMICG00000029111.1 | varchar(255) | values | Alternate name (e.g. gene_id from GTF) |
| cdsStartStat | none | enum('none', 'unk', 'incmpl', 'cmpl') | values | Status of CDS start annotation (none, unknown, incomplete, or complete) |
| cdsEndStat | none | enum('none', 'unk', 'incmpl', 'cmpl') | values | Status of CDS end annotation (none, unknown, incomplete, or complete) |
| exonFrames | -1, | 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. |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|
|
Sample Rows
|
|---|
| |
| bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
|---|
| 585 | ENSMICT00000030746.1 | ABDC02000622v1 | + | 843 | 981 | 981 | 981 | 1 | 843, | 981, | 0 | ENSMICG00000029111.1 | none | none | -1, |
| 585 | ENSMICT00000046291.1 | ABDC02000692v1 | - | 2233 | 2358 | 2358 | 2358 | 1 | 2233, | 2358, | 0 | ENSMICG00000026767.1 | none | none | -1, |
| 585 | ENSMICT00000026662.1 | ABDC02000698v1 | + | 963 | 1119 | 963 | 1119 | 1 | 963, | 1119, | 0 | ENSMICG00000030101.1 | cmpl | cmpl | 0, |
| 585 | ENSMICT00000055700.1 | ABDC02000723v1 | - | 20 | 2104 | 2104 | 2104 | 2 | 20,2077, | 93,2104, | 0 | ENSMICG00000038797.1 | none | none | -1,-1, |
| 585 | ENSMICT00000034377.1 | ABDC02000877v1 | - | 1494 | 2504 | 1494 | 2504 | 5 | 1494,1739,1848,1902,2495, | 1712,1809,1871,2239,2504, | 0 | ENSMICG00000034227.1 | cmpl | incmpl | 1,0,1,0,0, |
| 585 | ENSMICT00000030950.1 | ABDC02000900v1 | - | 0 | 1302 | 0 | 1302 | 1 | 0, | 1302, | 0 | ENSMICG00000031913.1 | incmpl | cmpl | 0, |
| 585 | ENSMICT00000024824.2 | ABDC02000945v1 | - | 667 | 764 | 764 | 764 | 1 | 667, | 764, | 0 | ENSMICG00000032168.1 | none | none | -1, |
| 585 | ENSMICT00000038952.1 | ABDC02001172v1 | - | 389 | 488 | 488 | 488 | 1 | 389, | 488, | 0 | ENSMICG00000036678.1 | none | none | -1, |
| 585 | ENSMICT00000037324.1 | ABDC02001203v1 | - | 22097 | 42324 | 22631 | 42147 | 7 | 22097,24552,27193,28498,32016,35255,42084, | 22845,24650,27313,28597,32090,35361,42324, | 0 | ENSMICG00000032922.1 | cmpl | incmpl | 2,0,0,0,1,0,0, |
| 585 | ENSMICT00000056901.1 | ABDC02001207v1 | - | 20 | 2854 | 2854 | 2854 | 2 | 20,1843, | 1749,2854, | 0 | ENSMICG00000041051.1 | none | none | -1,-1, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server