Schema for SNAP - SNAP Gene Predictions
|
|
Database: DvirCAF1 Primary Table: snap Row Count: 15,242   Data last updated: 2022-10-20
field | example | SQL type | info |
bin | 585 | smallint(5) unsigned | range |
name | scaffold_10024-snap.1 | varchar(255) | values |
chrom | scaffold_10024 | varchar(255) | values |
strand | + | char(1) | values |
txStart | 385 | int(10) unsigned | range |
txEnd | 3890 | int(10) unsigned | range |
cdsStart | 385 | int(10) unsigned | range |
cdsEnd | 3890 | int(10) unsigned | range |
exonCount | 2 | int(10) unsigned | range |
exonStarts | 385,3192, | longblob | |
exonEnds | 1447,3890, | longblob | |
score | 0 | int(11) | range |
name2 | gene.scaffold_10024-snap.1 | varchar(255) | values |
cdsStartStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
cdsEndStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
exonFrames | 1,1, | longblob | |
|
| |
|
|
Sample Rows
|
|
bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
---|
585 | scaffold_10024-snap.1 | scaffold_10024 | + | 385 | 3890 | 385 | 3890 | 2 | 385,3192, | 1447,3890, | 0 | gene.scaffold_10024-snap.1 | unk | unk | 1,1, |
585 | scaffold_10051-snap.1 | scaffold_10051 | - | 50 | 951 | 50 | 951 | 3 | 50,576,935, | 478,864,951, | 0 | gene.scaffold_10051-snap.1 | unk | unk | 1,1,0, |
585 | scaffold_10055-snap.1 | scaffold_10055 | + | 706 | 1272 | 706 | 1272 | 2 | 706,1236, | 946,1272, | 0 | gene.scaffold_10055-snap.1 | unk | unk | 0,0, |
585 | scaffold_10060-snap.1 | scaffold_10060 | + | 56 | 793 | 56 | 793 | 1 | 56, | 793, | 0 | gene.scaffold_10060-snap.1 | unk | unk | 1, |
585 | scaffold_10191-snap.1 | scaffold_10191 | + | 6 | 573 | 6 | 573 | 2 | 6,491, | 386,573, | 0 | gene.scaffold_10191-snap.1 | unk | unk | 0,2, |
585 | scaffold_10221-snap.1 | scaffold_10221 | - | 877 | 1166 | 877 | 1166 | 1 | 877, | 1166, | 0 | gene.scaffold_10221-snap.1 | unk | unk | 0, |
585 | scaffold_10322-snap.1 | scaffold_10322 | + | 45909 | 55184 | 45909 | 55184 | 5 | 45909,46999,53242,53452,55161, | 45913,47143,53396,53601,55184, | 0 | gene.scaffold_10322-snap.1 | unk | unk | 0,1,1,2,1, |
585 | scaffold_10322-snap.2 | scaffold_10322 | + | 57956 | 58668 | 57956 | 58668 | 3 | 57956,58224,58359, | 58058,58266,58668, | 0 | gene.scaffold_10322-snap.2 | unk | unk | 0,0,0, |
585 | scaffold_10322-snap.3 | scaffold_10322 | - | 59026 | 61517 | 59026 | 61517 | 3 | 59026,59213,61397, | 59108,61321,61517, | 0 | gene.scaffold_10322-snap.3 | unk | unk | 2,0,0, |
585 | scaffold_10322-snap.4 | scaffold_10322 | - | 62227 | 63856 | 62227 | 63856 | 5 | 62227,62491,62670,63414,63710, | 62432,62607,62887,63642,63856, | 0 | gene.scaffold_10322-snap.4 | unk | unk | 2,0,2,2,0, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
SNAP (snap) Track Description
|
|
|