Schema for SNAP - SNAP Gene Predictions |
|---|
| |
Database: DeugGB2 Primary Table: snap Row Count: 20,093 Data last updated: 2022-10-20
| field | example | SQL type | info |
|---|
| bin | 585 | smallint(5) unsigned | range |
| name | AFPQ02000009-snap.1 | varchar(255) | values |
| chrom | AFPQ02000009 | varchar(255) | values |
| strand | - | char(1) | values |
| txStart | 820 | int(10) unsigned | range |
| txEnd | 1012 | int(10) unsigned | range |
| cdsStart | 820 | int(10) unsigned | range |
| cdsEnd | 1012 | int(10) unsigned | range |
| exonCount | 1 | int(10) unsigned | range |
| exonStarts | 820, | longblob | |
| exonEnds | 1012, | longblob | |
| score | 0 | int(11) | range |
| name2 | gene.AFPQ02000009-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 | AFPQ02000009-snap.1 | AFPQ02000009 | - | 820 | 1012 | 820 | 1012 | 1 | 820, | 1012, | 0 | gene.AFPQ02000009-snap.1 | unk | unk | 0, |
| 585 | AFPQ02000020-snap.1 | AFPQ02000020 | + | 81 | 1264 | 81 | 1264 | 2 | 81,961, | 176,1264, | 0 | gene.AFPQ02000020-snap.1 | unk | unk | 0,2, |
| 585 | AFPQ02000021-snap.1 | AFPQ02000021 | + | 47 | 1031 | 47 | 1031 | 2 | 47,759, | 225,1031, | 0 | gene.AFPQ02000021-snap.1 | unk | unk | 0,1, |
| 585 | AFPQ02000027-snap.1 | AFPQ02000027 | - | 728 | 963 | 728 | 963 | 2 | 728,786, | 739,963, | 0 | gene.AFPQ02000027-snap.1 | unk | unk | 1,1, |
| 585 | AFPQ02000031-snap.1 | AFPQ02000031 | + | 18278 | 23768 | 18278 | 23768 | 9 | 18278,18398,18699,18893,19491,21267,23092,23490,23657, | 18298,18558,18837,19388,19917,21538,23167,23600,23768, | 0 | gene.AFPQ02000031-snap.1 | unk | unk | 0,2,0,0,0,0,1,1,0, |
| 585 | AFPQ02000049-snap.1 | AFPQ02000049 | - | 703 | 1074 | 703 | 1074 | 1 | 703, | 1074, | 0 | gene.AFPQ02000049-snap.1 | unk | unk | 0, |
| 585 | AFPQ02000066-snap.1 | AFPQ02000066 | + | 62 | 294 | 62 | 294 | 1 | 62, | 294, | 0 | gene.AFPQ02000066-snap.1 | unk | unk | 1, |
| 585 | AFPQ02000078-snap.1 | AFPQ02000078 | - | 45 | 252 | 45 | 252 | 1 | 45, | 252, | 0 | gene.AFPQ02000078-snap.1 | unk | unk | 2, |
| 585 | AFPQ02000096-snap.1 | AFPQ02000096 | - | 1499 | 1679 | 1499 | 1679 | 1 | 1499, | 1679, | 0 | gene.AFPQ02000096-snap.1 | unk | unk | 0, |
| 585 | AFPQ02000100-snap.1 | AFPQ02000100 | + | 515 | 1277 | 515 | 1277 | 1 | 515, | 1277, | 0 | gene.AFPQ02000100-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
|
|
|