|
|---|
| |
Database: petMar2 Primary Table: ensGene Row Count: 14,141 Data last updated: 2021-05-25
Format description: A gene prediction with some additional info.
On download server: MariaDB table dump directory
| field | example | SQL type | info | description |
|---|
| bin | 586 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| name | ENSPMAT00000011401.1 | varchar(255) | values | Name of gene (usually transcript_id from GTF) |
| chrom | GL476328 | varchar(255) | values | Reference sequence chromosome or scaffold |
| strand | + | char(1) | values | + or - for strand |
| txStart | 168845 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
| txEnd | 169475 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
| cdsStart | 168845 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
| cdsEnd | 169475 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
| exonCount | 1 | int(10) unsigned | range | Number of exons |
| exonStarts | 168845, | longblob | | Exon start positions (or end positions for minus strand item) |
| exonEnds | 169475, | longblob | | Exon end positions (or start positions for minus strand item) |
| score | 0 | int(11) | range | score |
| name2 | ENSPMAG00000010374.1 | varchar(255) | values | Alternate name (e.g. gene_id from GTF) |
| cdsStartStat | incmpl | enum('none', 'unk', 'incmpl', 'cmpl') | values | Status of CDS start annotation (none, unknown, incomplete, or complete) |
| cdsEndStat | incmpl | 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 |
|---|
| 586 | ENSPMAT00000011401.1 | GL476328 | + | 168845 | 169475 | 168845 | 169475 | 1 | 168845, | 169475, | 0 | ENSPMAG00000010374.1 | incmpl | incmpl | 0, |
| 586 | ENSPMAT00000008660.1 | GL476328 | - | 235292 | 235777 | 235292 | 235777 | 3 | 235292,235660,235733, | 235655,235718,235777, | 0 | ENSPMAG00000007839.1 | incmpl | incmpl | 0,2,0, |
| 73 | ENSPMAT00000008667.1 | GL476328 | - | 385444 | 414942 | 385444 | 414942 | 15 | 385444,385722,386990,390148,391854,404936,407069,407255,407526,408431,409234,411840,413172,414069,414815, | 385515,385763,387088,390224,391864,405202,407125,407268,407585,408527,409345,411975,413269,414148,414942, | 0 | ENSPMAG00000007846.1 | incmpl | incmpl | 1,2,0,2,1,2,0,2,0,0,0,0,2,1,0, |
| 73 | ENSPMAT00000008716.1 | GL476328 | - | 595485 | 663084 | 595485 | 663084 | 66 | 595485,597187,597561,597920,598251,598504,599253,599720,600150,600493,601035,607583,609237,610095,610963,615104,615418,616595,61 ... | 595627,597305,597604,598091,598338,598704,599431,599752,600251,600563,601217,607815,609421,610349,611141,615142,615538,616623,61 ... | 0 | ENSPMAG00000007851.1 | incmpl | incmpl | 2,1,0,0,0,1,0,1,2,1,2,1,0,1,0,1,1,0,0,1,0,0,2,0,1,0,1,0,2,2,0,1,2,1,0,2,1,1,0,0,0,0,2,1,2,0,1,2,1,0,1,1,1,0,2,0,0,2,1,1,1,1,1,0, ... |
| 590 | ENSPMAT00000008773.1 | GL476328 | + | 703640 | 749596 | 703640 | 749252 | 46 | 703640,705000,705612,705865,707090,707850,708598,709424,710182,710469,711532,712280,713111,715495,718725,719445,719620,719884,72 ... | 703870,705118,705697,705975,707294,707989,708716,709563,710287,710539,711670,712445,713206,715622,718981,719495,719721,720036,72 ... | 0 | ENSPMAG00000007891.1 | incmpl | cmpl | 0,2,0,1,0,0,1,2,0,0,1,1,1,0,1,2,1,0,2,0,0,0,0,1,1,2,1,0,1,0,0,1,2,1,2,2,1,0,1,1,0,0,0,0,1,2, |
| 591 | ENSPMAT00000008792.1 | GL476328 | - | 786909 | 803806 | 787047 | 803806 | 7 | 786909,788083,792001,795631,800614,802991,803779, | 787116,788167,792136,795733,800689,803222,803806, | 0 | ENSPMAG00000007943.1 | cmpl | incmpl | 0,0,0,0,0,0,0, |
| 591 | ENSPMAT00000008818.1 | GL476328 | - | 860626 | 871187 | 860626 | 871187 | 7 | 860626,864610,866651,868395,869273,870177,871100, | 860683,864697,866810,868500,869348,870369,871187, | 0 | ENSPMAG00000007963.1 | incmpl | incmpl | 0,0,0,0,0,0,0, |
| 73 | ENSPMAT00000008824.1 | GL476328 | - | 911528 | 928959 | 911528 | 928536 | 8 | 911528,912256,913339,919253,921145,924356,925225,928458, | 911678,912352,913430,919396,921153,924527,925337,928959, | 0 | ENSPMAG00000007987.1 | incmpl | cmpl | 0,0,2,0,1,1,0,0, |
| 73 | ENSPMAT00000008825.1 | GL476328 | - | 913279 | 928959 | 913279 | 928599 | 6 | 913279,919253,924199,924356,925225,928458, | 913430,919396,924207,924527,925337,928959, | 0 | ENSPMAG00000007987.1 | incmpl | cmpl | 2,0,1,1,0,0, |
| 592 | ENSPMAT00000008845.1 | GL476328 | + | 950906 | 998973 | 950906 | 998973 | 15 | 950906,951718,966305,968487,979651,980157,981705,982943,984636,984862,989435,990900,995453,998752,998964, | 950973,951825,966404,968559,979776,980221,981831,983072,984710,985065,989547,990982,995549,998866,998973, | 0 | ENSPMAG00000007993.1 | incmpl | incmpl | 0,1,0,0,0,2,0,0,0,2,1,2,0,0,0, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server