Schema for SNAP - SNAP Gene Predictions
|
|
Database: DyakCAF1 Primary Table: snap Row Count: 16,899   Data last updated: 2022-10-20
field | example | SQL type | info |
bin | 585 | smallint(5) unsigned | range |
name | chr2L-snap.1 | varchar(255) | values |
chrom | chr2L | varchar(255) | values |
strand | - | char(1) | values |
txStart | 10264 | int(10) unsigned | range |
txEnd | 13753 | int(10) unsigned | range |
cdsStart | 10264 | int(10) unsigned | range |
cdsEnd | 13753 | int(10) unsigned | range |
exonCount | 2 | int(10) unsigned | range |
exonStarts | 10264,13736, | longblob | |
exonEnds | 10427,13753, | longblob | |
score | 0 | int(11) | range |
name2 | gene.chr2L-snap.1 | varchar(255) | values |
cdsStartStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
cdsEndStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
exonFrames | 2,0, | longblob | |
|
| |
|
|
Sample Rows
|
|
bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
---|
585 | chr2L-snap.1 | chr2L | - | 10264 | 13753 | 10264 | 13753 | 2 | 10264,13736, | 10427,13753, | 0 | gene.chr2L-snap.1 | unk | unk | 2,0, |
585 | chr2L-snap.2 | chr2L | - | 16689 | 29753 | 16689 | 29753 | 15 | 16689,17541,17769,18264,18549,21194,21490,22503,22955,23238,23487,27440,28097,28211,29414, | 17214,17711,17865,18438,18649,21393,21928,22700,23134,23432,23574,27815,28144,28634,29753, | 0 | gene.chr2L-snap.2 | unk | unk | 0,1,1,1,0,2,2,0,1,2,2,2,0,0,0, |
585 | chr2L-snap.3 | chr2L | - | 29805 | 31479 | 29805 | 31479 | 1 | 29805, | 31479, | 0 | gene.chr2L-snap.3 | unk | unk | 0, |
585 | chr2L-snap.4 | chr2L | - | 32036 | 50207 | 32036 | 50207 | 4 | 32036,32502,47635,50176, | 32237,33059,47737,50207, | 0 | gene.chr2L-snap.4 | unk | unk | 0,1,1,0, |
585 | chr2L-snap.5 | chr2L | + | 56139 | 61113 | 56139 | 61113 | 5 | 56139,56602,57548,59103,61082, | 56277,57200,59046,59322,61113, | 0 | gene.chr2L-snap.5 | unk | unk | 0,0,1,2,2, |
585 | chr2L-snap.6 | chr2L | - | 64561 | 69701 | 64561 | 69701 | 3 | 64561,67782,69577, | 64651,67790,69701, | 0 | gene.chr2L-snap.6 | unk | unk | 0,1,0, |
585 | chr2L-snap.7 | chr2L | - | 72463 | 76318 | 72463 | 76318 | 2 | 72463,76311, | 73485,76318, | 0 | gene.chr2L-snap.7 | unk | unk | 1,0, |
585 | chr2L-snap.8 | chr2L | + | 84208 | 87299 | 84208 | 87299 | 5 | 84208,84461,84788,86463,87227, | 84249,84650,85866,86544,87299, | 0 | gene.chr2L-snap.8 | unk | unk | 0,2,2,0,0, |
585 | chr2L-snap.9 | chr2L | + | 89604 | 91342 | 89604 | 91342 | 5 | 89604,90361,90594,90868,91299, | 89650,90540,90724,90965,91342, | 0 | gene.chr2L-snap.9 | unk | unk | 0,1,0,1,2, |
585 | chr2L-snap.10 | chr2L | + | 91798 | 93127 | 91798 | 93127 | 3 | 91798,92369,92879, | 92246,92798,93127, | 0 | gene.chr2L-snap.10 | unk | unk | 0,1,1, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
SNAP (snap) Track Description
|
|
|