Schema for SNAP - SNAP Gene Predictions
|
|
Database: DsuzGB1 Primary Table: snap Row Count: 21,370   Data last updated: 2022-10-20
field | example | SQL type | info |
bin | 585 | smallint(5) unsigned | range |
name | AWUT01013449-snap.1 | varchar(255) | values |
chrom | AWUT01013449 | varchar(255) | values |
strand | + | char(1) | values |
txStart | 64458 | int(10) unsigned | range |
txEnd | 69705 | int(10) unsigned | range |
cdsStart | 64458 | int(10) unsigned | range |
cdsEnd | 69705 | int(10) unsigned | range |
exonCount | 5 | int(10) unsigned | range |
exonStarts | 64458,64743,68518,69015,69648, | longblob | |
exonEnds | 64494,64833,68665,69141,69705, | longblob | |
score | 0 | int(11) | range |
name2 | gene.AWUT01013449-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,0,0, | longblob | |
|
| |
|
|
Sample Rows
|
|
bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
---|
585 | AWUT01013449-snap.1 | AWUT01013449 | + | 64458 | 69705 | 64458 | 69705 | 5 | 64458,64743,68518,69015,69648, | 64494,64833,68665,69141,69705, | 0 | gene.AWUT01013449-snap.1 | unk | unk | 0,0,0,0,0, |
585 | AWUT01014064-snap.1 | AWUT01014064 | + | 3676 | 4162 | 3676 | 4162 | 1 | 3676, | 4162, | 0 | gene.AWUT01014064-snap.1 | unk | unk | 0, |
585 | AWUT01014064-snap.2 | AWUT01014064 | - | 17849 | 28161 | 17849 | 28161 | 4 | 17849,20056,20402,28149, | 17885,20341,20513,28161, | 0 | gene.AWUT01014064-snap.2 | unk | unk | 0,0,0,0, |
585 | AWUT01014734-snap.1 | AWUT01014734 | + | 13067 | 19765 | 13067 | 19765 | 6 | 13067,16352,17219,17480,17725,18686, | 13073,16460,17454,17659,17885,19765, | 0 | gene.AWUT01014734-snap.1 | unk | unk | 0,0,0,1,0,1, |
585 | AWUT01014734-snap.2 | AWUT01014734 | - | 25556 | 30264 | 25556 | 30264 | 2 | 25556,29783, | 27736,30264, | 0 | gene.AWUT01014734-snap.2 | unk | unk | 1,0, |
585 | AWUT01015089-snap.1 | AWUT01015089 | + | 4149 | 4365 | 4149 | 4365 | 1 | 4149, | 4365, | 0 | gene.AWUT01015089-snap.1 | unk | unk | 0, |
585 | AWUT01015096-snap.1 | AWUT01015096 | + | 18709 | 19015 | 18709 | 19015 | 1 | 18709, | 19015, | 0 | gene.AWUT01015096-snap.1 | unk | unk | 0, |
585 | AWUT01015145-snap.1 | AWUT01015145 | - | 1105 | 8432 | 1105 | 8432 | 3 | 1105,3636,8385, | 1267,3655,8432, | 0 | gene.AWUT01015145-snap.1 | unk | unk | 0,2,0, |
585 | AWUT01015145-snap.2 | AWUT01015145 | + | 6534 | 19302 | 6534 | 19302 | 6 | 6534,9012,9514,11978,18225,19234, | 6569,9238,9637,11987,18271,19302, | 0 | gene.AWUT01015145-snap.2 | unk | unk | 0,2,0,0,0,1, |
585 | AWUT01015145-snap.3 | AWUT01015145 | + | 26555 | 28319 | 26555 | 28319 | 2 | 26555,27299, | 27197,28319, | 0 | gene.AWUT01015145-snap.3 | unk | unk | 0,0, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
SNAP (snap) Track Description
|
|
|