|
|---|
| |
Database: eriEur1 Primary Table: ensGene Row Count: 50,330 Data last updated: 2019-01-11
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 | ENSEEUT00000023921.1 | varchar(255) | values | Name of gene (usually transcript_id from GTF) |
| chrom | chrM | varchar(255) | values | Reference sequence chromosome or scaffold |
| strand | + | char(1) | values | + or - for strand |
| txStart | 0 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
| txEnd | 66 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
| cdsStart | 66 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
| cdsEnd | 66 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
| exonCount | 1 | int(10) unsigned | range | Number of exons |
| exonStarts | 0, | longblob | | Exon start positions (or end positions for minus strand item) |
| exonEnds | 66, | longblob | | Exon end positions (or start positions for minus strand item) |
| score | 0 | int(11) | range | score |
| name2 | ENSEEUG00000023917.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 | ENSEEUT00000023921.1 | chrM | + | 0 | 66 | 66 | 66 | 1 | 0, | 66, | 0 | ENSEEUG00000023917.1 | none | none | -1, |
| 585 | ENSEEUT00000023922.1 | chrM | + | 66 | 1037 | 1037 | 1037 | 1 | 66, | 1037, | 0 | ENSEEUG00000023918.1 | none | none | -1, |
| 585 | ENSEEUT00000023923.1 | chrM | + | 1037 | 1105 | 1105 | 1105 | 1 | 1037, | 1105, | 0 | ENSEEUG00000023919.1 | none | none | -1, |
| 585 | ENSEEUT00000023924.1 | chrM | + | 1105 | 2668 | 2668 | 2668 | 1 | 1105, | 2668, | 0 | ENSEEUG00000023920.1 | none | none | -1, |
| 585 | ENSEEUT00000023925.1 | chrM | + | 2668 | 2743 | 2743 | 2743 | 1 | 2668, | 2743, | 0 | ENSEEUG00000023921.1 | none | none | -1, |
| 585 | ENSEEUT00000023926.1 | chrM | + | 2744 | 3698 | 2744 | 3698 | 1 | 2744, | 3698, | 0 | ENSEEUG00000023922.1 | cmpl | cmpl | 0, |
| 585 | ENSEEUT00000023927.1 | chrM | + | 3698 | 3767 | 3767 | 3767 | 1 | 3698, | 3767, | 0 | ENSEEUG00000023923.1 | none | none | -1, |
| 585 | ENSEEUT00000023928.1 | chrM | - | 3764 | 3837 | 3837 | 3837 | 1 | 3764, | 3837, | 0 | ENSEEUG00000023924.1 | none | none | -1, |
| 585 | ENSEEUT00000023929.1 | chrM | + | 3836 | 3905 | 3905 | 3905 | 1 | 3836, | 3905, | 0 | ENSEEUG00000023925.1 | none | none | -1, |
| 585 | ENSEEUT00000023930.1 | chrM | + | 3908 | 4952 | 3908 | 4952 | 1 | 3908, | 4952, | 0 | ENSEEUG00000023926.1 | cmpl | cmpl | 0, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server