Schema for SNAP - SNAP Gene Predictions
|
|
Database: DgriCAF1 Primary Table: snap Row Count: 16,002   Data last updated: 2022-10-20
field | example | SQL type | info |
bin | 585 | smallint(5) unsigned | range |
name | scaffold_10012-snap.1 | varchar(255) | values |
chrom | scaffold_10012 | varchar(255) | values |
strand | + | char(1) | values |
txStart | 66 | int(10) unsigned | range |
txEnd | 933 | int(10) unsigned | range |
cdsStart | 66 | int(10) unsigned | range |
cdsEnd | 933 | int(10) unsigned | range |
exonCount | 2 | int(10) unsigned | range |
exonStarts | 66,801, | longblob | |
exonEnds | 375,933, | longblob | |
score | 0 | int(11) | range |
name2 | gene.scaffold_10012-snap.1 | varchar(255) | values |
cdsStartStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
cdsEndStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
exonFrames | 0,0, | longblob | |
|
| |
|
|
Sample Rows
|
|
bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
---|
585 | scaffold_10012-snap.1 | scaffold_10012 | + | 66 | 933 | 66 | 933 | 2 | 66,801, | 375,933, | 0 | gene.scaffold_10012-snap.1 | unk | unk | 0,0, |
585 | scaffold_10016-snap.1 | scaffold_10016 | + | 2 | 385 | 2 | 385 | 2 | 2,240, | 178,385, | 0 | gene.scaffold_10016-snap.1 | unk | unk | 0,2, |
585 | scaffold_10024-snap.1 | scaffold_10024 | + | 886 | 1311 | 886 | 1311 | 2 | 886,1086, | 1034,1311, | 0 | gene.scaffold_10024-snap.1 | unk | unk | 0,1, |
585 | scaffold_10027-snap.1 | scaffold_10027 | + | 158 | 969 | 158 | 969 | 5 | 158,485,625,806,949, | 421,560,725,894,969, | 0 | gene.scaffold_10027-snap.1 | unk | unk | 0,2,2,0,1, |
585 | scaffold_10030-snap.1 | scaffold_10030 | - | 475 | 1182 | 475 | 1182 | 4 | 475,557,851,1175, | 503,610,1003,1182, | 0 | gene.scaffold_10030-snap.1 | unk | unk | 2,0,1,0, |
585 | scaffold_10033-snap.1 | scaffold_10033 | + | 659 | 884 | 659 | 884 | 1 | 659, | 884, | 0 | gene.scaffold_10033-snap.1 | unk | unk | 0, |
585 | scaffold_10058-snap.1 | scaffold_10058 | + | 166 | 862 | 166 | 862 | 2 | 166,853, | 470,862, | 0 | gene.scaffold_10058-snap.1 | unk | unk | 2,0, |
585 | scaffold_10059-snap.1 | scaffold_10059 | - | 320 | 1943 | 320 | 1943 | 3 | 320,1474,1685, | 377,1621,1943, | 0 | gene.scaffold_10059-snap.1 | unk | unk | 0,0,0, |
585 | scaffold_10066-snap.1 | scaffold_10066 | + | 310 | 660 | 310 | 660 | 2 | 310,502, | 442,660, | 0 | gene.scaffold_10066-snap.1 | unk | unk | 0,0, |
585 | scaffold_10076-snap.1 | scaffold_10076 | + | 814 | 1081 | 814 | 1081 | 1 | 814, | 1081, | 0 | gene.scaffold_10076-snap.1 | unk | unk | 0, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
SNAP (snap) Track Description
|
|
|