Schema for Ribo-seq SmProt ATG - SmProt genes with ATG startcodon from ribosome profiling
|
|
Database: hg38 Primary Table: smprot_ribo_HSA_ATG Row Count: 90,369   Data last updated: 2020-08-13
field | example | SQL type | info |
bin | 586 | smallint(5) unsigned | range |
chrom | chr1 | varchar(255) | values |
chromStart | 169203 | int(10) unsigned | range |
chromEnd | 173859 | int(10) unsigned | range |
name | SPROHSA159551 | varchar(255) | values |
score | 0 | int(10) unsigned | range |
strand | - | char(1) | values |
thickStart | 169203 | int(10) unsigned | range |
thickEnd | 173859 | int(10) unsigned | range |
reserved | 255 | int(10) unsigned | range |
blockCount | 3 | int(10) unsigned | range |
blockSizes | 61,132,107 | longblob | |
chromStarts | 0,3353,4549 | longblob | |
|
| |
|
|
Sample Rows
|
|
bin | chrom | chromStart | chromEnd | name | score | strand | thickStart | thickEnd | reserved | blockCount | blockSizes | chromStarts |
---|
586 | chr1 | 169203 | 173859 | SPROHSA159551 | 0 | - | 169203 | 173859 | 255 | 3 | 61,132,107 | 0,3353,4549 |
586 | chr1 | 185216 | 186365 | SPROHSA142358 | 0 | - | 185216 | 186365 | 255 | 3 | 134,69,49 | 0,274,1100 |
589 | chr1 | 629288 | 629432 | SPROHSA144904 | 0 | + | 629288 | 629432 | 255 | 1 | 144 | 0 |
589 | chr1 | 629747 | 629891 | SPROHSA173901 | 0 | + | 629747 | 629891 | 255 | 1 | 144 | 0 |
589 | chr1 | 631144 | 631222 | SPROHSA153340 | 0 | + | 631144 | 631222 | 255 | 1 | 78 | 0 |
589 | chr1 | 631346 | 631382 | SPROHSA197877 | 0 | + | 631346 | 631382 | 255 | 1 | 36 | 0 |
589 | chr1 | 631902 | 631938 | SPROHSA157026 | 0 | + | 631902 | 631938 | 255 | 1 | 36 | 0 |
589 | chr1 | 632420 | 632615 | SPROHSA137965 | 0 | + | 632420 | 632615 | 255 | 1 | 195 | 0 |
589 | chr1 | 632756 | 632951 | SPROHSA191436 | 0 | + | 632756 | 632951 | 255 | 1 | 195 | 0 |
589 | chr1 | 633372 | 633438 | SPROHSA167634 | 0 | + | 633372 | 633438 | 255 | 1 | 66 | 0 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|