Schema for SNAP - SNAP Gene Predictions
|
|
Database: DkikGB2 Primary Table: snap Row Count: 22,304   Data last updated: 2022-10-20
field | example | SQL type | info |
bin | 585 | smallint(5) unsigned | range |
name | AFFH02000049-snap.1 | varchar(255) | values |
chrom | AFFH02000049 | varchar(255) | values |
strand | + | char(1) | values |
txStart | 2345 | int(10) unsigned | range |
txEnd | 2602 | int(10) unsigned | range |
cdsStart | 2345 | int(10) unsigned | range |
cdsEnd | 2602 | int(10) unsigned | range |
exonCount | 1 | int(10) unsigned | range |
exonStarts | 2345, | longblob | |
exonEnds | 2602, | longblob | |
score | 0 | int(11) | range |
name2 | gene.AFFH02000049-snap.1 | varchar(255) | values |
cdsStartStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
cdsEndStat | unk | enum('none', 'unk', 'incmpl', 'cmpl') | values |
exonFrames | 2, | longblob | |
|
| |
|
|
Sample Rows
|
|
bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | score | name2 | cdsStartStat | cdsEndStat | exonFrames |
---|
585 | AFFH02000049-snap.1 | AFFH02000049 | + | 2345 | 2602 | 2345 | 2602 | 1 | 2345, | 2602, | 0 | gene.AFFH02000049-snap.1 | unk | unk | 2, |
585 | AFFH02000063-snap.1 | AFFH02000063 | + | 28 | 1539 | 28 | 1539 | 2 | 28,1210, | 152,1539, | 0 | gene.AFFH02000063-snap.1 | unk | unk | 0,1, |
585 | AFFH02000086-snap.1 | AFFH02000086 | + | 1678 | 1941 | 1678 | 1941 | 1 | 1678, | 1941, | 0 | gene.AFFH02000086-snap.1 | unk | unk | 0, |
585 | AFFH02000093-snap.1 | AFFH02000093 | - | 421 | 637 | 421 | 637 | 1 | 421, | 637, | 0 | gene.AFFH02000093-snap.1 | unk | unk | 0, |
585 | AFFH02000114-snap.1 | AFFH02000114 | - | 951 | 1167 | 951 | 1167 | 1 | 951, | 1167, | 0 | gene.AFFH02000114-snap.1 | unk | unk | 0, |
585 | AFFH02000165-snap.1 | AFFH02000165 | - | 23809 | 24205 | 23809 | 24205 | 1 | 23809, | 24205, | 0 | gene.AFFH02000165-snap.1 | unk | unk | 0, |
585 | AFFH02000165-snap.2 | AFFH02000165 | + | 25783 | 32402 | 25783 | 32402 | 4 | 25783,27341,30879,31110, | 25949,27904,31087,32402, | 0 | gene.AFFH02000165-snap.2 | unk | unk | 0,1,0,1, |
585 | AFFH02000165-snap.3 | AFFH02000165 | + | 32542 | 33043 | 32542 | 33043 | 1 | 32542, | 33043, | 0 | gene.AFFH02000165-snap.3 | unk | unk | 0, |
585 | AFFH02000183-snap.1 | AFFH02000183 | + | 862 | 1273 | 862 | 1273 | 1 | 862, | 1273, | 0 | gene.AFFH02000183-snap.1 | unk | unk | 1, |
585 | AFFH02000236-snap.1 | AFFH02000236 | - | 51 | 405 | 51 | 405 | 1 | 51, | 405, | 0 | gene.AFFH02000236-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
|
|
|