|
|---|
| |
Database: echTel1 Primary Table: ensGene Row Count: 54,935 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 | ENSETET00000011481.1 | varchar(255) | values | Name of gene (usually transcript_id from GTF) |
| chrom | scaffold_100007 | varchar(255) | values | Reference sequence chromosome or scaffold |
| strand | + | char(1) | values | + or - for strand |
| txStart | 4029 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
| txEnd | 4260 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
| cdsStart | 4029 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
| cdsEnd | 4260 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
| exonCount | 1 | int(10) unsigned | range | Number of exons |
| exonStarts | 4029, | longblob | | Exon start positions (or end positions for minus strand item) |
| exonEnds | 4260, | longblob | | Exon end positions (or start positions for minus strand item) |
| score | 0 | int(11) | range | score |
| name2 | ENSETEG00000011481.1 | 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. |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|
|
Sample Rows
|
|---|
| |
| bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
|---|
| 585 | ENSETET00000011481.1 | scaffold_100007 | + | 4029 | 4260 | 4029 | 4260 | 1 | 4029, | 4260, | 0 | ENSETEG00000011481.1 | cmpl | cmpl | 0, |
| 585 | ENSETET00000014606.1 | scaffold_100008 | + | 3377 | 3524 | 3377 | 3524 | 1 | 3377, | 3524, | 0 | ENSETEG00000014606.1 | cmpl | incmpl | 0, |
| 585 | ENSETET00000010225.1 | scaffold_100024 | - | 1422 | 2022 | 1422 | 2022 | 3 | 1422,1575,1985, | 1434,1898,2022, | 0 | ENSETEG00000010228.1 | incmpl | cmpl | 0,1,0, |
| 585 | ENSETET00000010200.1 | scaffold_100033 | - | 1075 | 1242 | 1075 | 1242 | 1 | 1075, | 1242, | 0 | ENSETEG00000010200.1 | cmpl | incmpl | 0, |
| 585 | ENSETET00000003293.1 | scaffold_100036 | + | 1647 | 3472 | 1647 | 3472 | 4 | 1647,3280,3356,3390, | 1794,3352,3388,3472, | 0 | ENSETEG00000003277.1 | cmpl | incmpl | 1,1,1,0, |
| 585 | ENSETET00000017293.1 | scaffold_100057 | - | 4997 | 5066 | 4997 | 5066 | 2 | 4997,5045, | 5038,5066, | 0 | ENSETEG00000017293.1 | cmpl | cmpl | 1,1, |
| 585 | ENSETET00000007102.1 | scaffold_100066 | + | 1735 | 1830 | 1735 | 1830 | 1 | 1735, | 1830, | 0 | ENSETEG00000007099.1 | cmpl | cmpl | 1, |
| 585 | ENSETET00000004599.1 | scaffold_100068 | - | 443 | 6726 | 443 | 6726 | 3 | 443,5817,6605, | 525,5953,6726, | 0 | ENSETEG00000004602.1 | incmpl | incmpl | 2,1,0, |
| 585 | ENSETET00000000562.1 | scaffold_100070 | - | 1598 | 1728 | 1598 | 1728 | 3 | 1598,1631,1665, | 1630,1664,1728, | 0 | ENSETEG00000000562.1 | cmpl | incmpl | 1,1,1, |
| 585 | ENSETET00000001181.1 | scaffold_100076 | - | 1086 | 2887 | 1086 | 2887 | 6 | 1086,1291,1539,1612,2535,2791, | 1185,1446,1611,1643,2639,2887, | 0 | ENSETEG00000001180.1 | cmpl | incmpl | 2,0,0,2,0,0, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server