|
|---|
| |
Database: cavPor3 Primary Table: ensGene Row Count: 34,846 Data last updated: 2021-05-25
Format description: Ensembl gene predictions.
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 | ENSCPOT00000017553.1 | varchar(255) | values | Ensembl transcript ID |
| 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 | 65 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
| cdsStart | 65 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
| cdsEnd | 65 | 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 | 65, | longblob | | Exon end positions (or start positions for minus strand item) |
| score | 0 | int(11) | range | always 0 for Ensembl genes |
| name2 | ENSCPOG00000017398.2 | varchar(255) | values | Ensembl gene ID |
| 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 | | Exon frame {0,1,2}, or -1 if no frame for exon |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|
|
Sample Rows
|
|---|
| |
| bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
|---|
| 585 | ENSCPOT00000017553.1 | chrM | + | 0 | 65 | 65 | 65 | 1 | 0, | 65, | 0 | ENSCPOG00000017398.2 | none | none | -1, |
| 585 | ENSCPOT00000017554.1 | chrM | + | 65 | 1008 | 1008 | 1008 | 1 | 65, | 1008, | 0 | ENSCPOG00000017399.2 | none | none | -1, |
| 585 | ENSCPOT00000017555.1 | chrM | + | 1008 | 1077 | 1077 | 1077 | 1 | 1008, | 1077, | 0 | ENSCPOG00000017400.2 | none | none | -1, |
| 585 | ENSCPOT00000017556.1 | chrM | + | 1077 | 2642 | 2642 | 2642 | 1 | 1077, | 2642, | 0 | ENSCPOG00000017401.2 | none | none | -1, |
| 585 | ENSCPOT00000017557.1 | chrM | + | 2642 | 2716 | 2716 | 2716 | 1 | 2642, | 2716, | 0 | ENSCPOG00000017402.2 | none | none | -1, |
| 585 | ENSCPOT00000017558.1 | chrM | + | 2720 | 3680 | 2720 | 3680 | 1 | 2720, | 3680, | 0 | ENSCPOG00000017403.2 | cmpl | cmpl | 0, |
| 585 | ENSCPOT00000017559.1 | chrM | + | 3678 | 3747 | 3747 | 3747 | 1 | 3678, | 3747, | 0 | ENSCPOG00000017404.2 | none | none | -1, |
| 585 | ENSCPOT00000017560.1 | chrM | - | 3744 | 3815 | 3815 | 3815 | 1 | 3744, | 3815, | 0 | ENSCPOG00000017405.2 | none | none | -1, |
| 585 | ENSCPOT00000017561.1 | chrM | + | 3817 | 3886 | 3886 | 3886 | 1 | 3817, | 3886, | 0 | ENSCPOG00000017406.2 | none | none | -1, |
| 585 | ENSCPOT00000017562.2 | chrM | + | 3886 | 4930 | 3886 | 4930 | 1 | 3886, | 4930, | 0 | ENSCPOG00000017407.3 | cmpl | cmpl | 0, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server