Schema for SNAP - SNAP Gene Predictions
|
|
Database: DbiaGB2 Primary Table: snap Row Count: 19,965   Data last updated: 2022-10-20
field | example | SQL type | info |
bin | 585 | smallint(5) unsigned | range |
name | AFFD02000035-snap.1 | varchar(255) | values |
chrom | AFFD02000035 | varchar(255) | values |
strand | - | char(1) | values |
txStart | 703 | int(10) unsigned | range |
txEnd | 943 | int(10) unsigned | range |
cdsStart | 703 | int(10) unsigned | range |
cdsEnd | 943 | int(10) unsigned | range |
exonCount | 1 | int(10) unsigned | range |
exonStarts | 703, | longblob | |
exonEnds | 943, | longblob | |
score | 0 | int(11) | range |
name2 | gene.AFFD02000035-snap.1 | varchar(255) | values |
cdsStartStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
cdsEndStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
exonFrames | 0, | longblob | |
|
| |
|
|
Sample Rows
|
|
bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
---|
585 | AFFD02000035-snap.1 | AFFD02000035 | - | 703 | 943 | 703 | 943 | 1 | 703, | 943, | 0 | gene.AFFD02000035-snap.1 | unk | unk | 0, |
585 | AFFD02000037-snap.1 | AFFD02000037 | + | 2935 | 3990 | 2935 | 3990 | 4 | 2935,3051,3441,3906, | 2990,3188,3846,3990, | 0 | gene.AFFD02000037-snap.1 | unk | unk | 0,1,0,0, |
585 | AFFD02000037-snap.2 | AFFD02000037 | + | 5296 | 7468 | 5296 | 7468 | 3 | 5296,6079,6627, | 6022,6162,7468, | 0 | gene.AFFD02000037-snap.2 | unk | unk | 0,0,2, |
585 | AFFD02000037-snap.3 | AFFD02000037 | + | 9164 | 15215 | 9164 | 15215 | 11 | 9164,9460,10784,11264,12565,13046,13492,13650,14015,14363,15008, | 9402,9668,11106,12474,12912,13445,13591,13961,14298,14528,15215, | 0 | gene.AFFD02000037-snap.3 | unk | unk | 0,1,2,0,1,0,0,0,2,0,0, |
585 | AFFD02000037-snap.4 | AFFD02000037 | - | 19758 | 21645 | 19758 | 21645 | 1 | 19758, | 21645, | 0 | gene.AFFD02000037-snap.4 | unk | unk | 0, |
585 | AFFD02000041-snap.1 | AFFD02000041 | - | 1084 | 1296 | 1084 | 1296 | 1 | 1084, | 1296, | 0 | gene.AFFD02000041-snap.1 | unk | unk | 1, |
585 | AFFD02000056-snap.1 | AFFD02000056 | - | 175 | 356 | 175 | 356 | 1 | 175, | 356, | 0 | gene.AFFD02000056-snap.1 | unk | unk | 2, |
585 | AFFD02000057-snap.1 | AFFD02000057 | - | 21 | 233 | 21 | 233 | 1 | 21, | 233, | 0 | gene.AFFD02000057-snap.1 | unk | unk | 0, |
585 | AFFD02000064-snap.1 | AFFD02000064 | - | 385 | 589 | 385 | 589 | 1 | 385, | 589, | 0 | gene.AFFD02000064-snap.1 | unk | unk | 0, |
585 | AFFD02000073-snap.1 | AFFD02000073 | + | 3294 | 3498 | 3294 | 3498 | 1 | 3294, | 3498, | 0 | gene.AFFD02000073-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
|
|
|