Schema for SNAP - SNAP Gene Predictions
|
|
Database: DsimGB2 Primary Table: snap Row Count: 16,416   Data last updated: 2022-10-20
field | example | SQL type | info |
bin | 585 | smallint(5) unsigned | range |
name | CM002910-snap.1 | varchar(255) | values |
chrom | CM002910 | varchar(255) | values |
strand | - | char(1) | values |
txStart | 5400 | int(10) unsigned | range |
txEnd | 8146 | int(10) unsigned | range |
cdsStart | 5400 | int(10) unsigned | range |
cdsEnd | 8146 | int(10) unsigned | range |
exonCount | 3 | int(10) unsigned | range |
exonStarts | 5400,7621,8038, | longblob | |
exonEnds | 5424,7687,8146, | longblob | |
score | 0 | int(11) | range |
name2 | gene.CM002910-snap.1 | varchar(255) | values |
cdsStartStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
cdsEndStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
exonFrames | 0,0,0, | longblob | |
|
| |
|
|
Sample Rows
|
|
bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
---|
585 | CM002910-snap.1 | CM002910 | - | 5400 | 8146 | 5400 | 8146 | 3 | 5400,7621,8038, | 5424,7687,8146, | 0 | gene.CM002910-snap.1 | unk | unk | 0,0,0, |
585 | CM002910-snap.2 | CM002910 | - | 11109 | 13647 | 11109 | 13647 | 4 | 11109,11309,11793,13169, | 11117,11331,11801,13647, | 0 | gene.CM002910-snap.2 | unk | unk | 1,0,1,0, |
585 | CM002910-snap.3 | CM002910 | - | 13983 | 14731 | 13983 | 14731 | 3 | 13983,14238,14724, | 14180,14334,14731, | 0 | gene.CM002910-snap.3 | unk | unk | 1,1,0, |
585 | CM002910-snap.4 | CM002910 | - | 18256 | 19654 | 18256 | 19654 | 2 | 18256,19463, | 18698,19654, | 0 | gene.CM002910-snap.4 | unk | unk | 2,0, |
585 | CM002910-snap.5 | CM002910 | - | 25228 | 29504 | 25228 | 29504 | 5 | 25228,26058,26228,27443,29360, | 25775,26105,26660,29318,29504, | 0 | gene.CM002910-snap.5 | unk | unk | 2,0,0,0,0, |
585 | CM002910-snap.6 | CM002910 | - | 30030 | 36966 | 30030 | 36966 | 3 | 30030,30754,36920, | 30231,31311,36966, | 0 | gene.CM002910-snap.6 | unk | unk | 0,1,0, |
585 | CM002910-snap.7 | CM002910 | + | 54291 | 56624 | 54291 | 56624 | 3 | 54291,55231,56587, | 54367,56360,56624, | 0 | gene.CM002910-snap.7 | unk | unk | 0,1,2, |
585 | CM002910-snap.8 | CM002910 | + | 58365 | 58885 | 58365 | 58885 | 2 | 58365,58870, | 58740,58885, | 0 | gene.CM002910-snap.8 | unk | unk | 0,0, |
585 | CM002910-snap.9 | CM002910 | + | 59555 | 60278 | 59555 | 60278 | 2 | 59555,60218, | 59678,60278, | 0 | gene.CM002910-snap.9 | unk | unk | 0,0, |
585 | CM002910-snap.10 | CM002910 | - | 69413 | 73189 | 69413 | 73189 | 3 | 69413,70069,73182, | 69790,70423,73189, | 0 | gene.CM002910-snap.10 | unk | unk | 1,1,0, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
SNAP (snap) Track Description
|
|
|