| field | example | SQL type | description |
|---|---|---|---|
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| chrom | chr1 | varchar(255) | Reference sequence chromosome or scaffold |
| chromStart | 16095 | int(10) unsigned | Start position in chromosome |
| chromEnd | 16127 | int(10) unsigned | End position in chromosome |
| name | GSM325478_heart_HCT170_hg18... | varchar(255) | Name of item |
| score | 1000 | int(10) unsigned | Score from 0-1000 |
| strand | + | char(1) | + or - |
| thickStart | 0 | int(10) unsigned | Start of where display should be thick (start codon) |
| thickEnd | 0 | int(10) unsigned | End of where display should be thick (stop codon) |
| reserved | 0 | int(10) unsigned | Used as itemRgb as of 2004-11-22 |
| blockCount | 1 | int(10) unsigned | Number of blocks |
| blockSizes | 32, | longblob | Comma separated list of block sizes |
| chromStarts | 0, | longblob | Start positions relative to chromStart |
| bin | chrom | chromStart | chromEnd | name | score | strand | thickStart | thickEnd | reserved | blockCount | blockSizes | chromStarts |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 585 | chr1 | 16095 | 16127 | GSM325478_heart_HCT170_hg18_980012_chr1_16096_16127 | 1000 | + | 0 | 0 | 0 | 1 | 32, | 0, |
| 586 | chr1 | 136701 | 136733 | GSM325478_heart_HCT170_hg18_6590929_chr1_136702_136733 | 1000 | + | 0 | 0 | 0 | 1 | 32, | 0, |
| 586 | chr1 | 137794 | 137826 | GSM325478_heart_HCT170_hg18_3929904_chr1_137795_137826 | 1000 | + | 0 | 0 | 0 | 1 | 32, | 0, |
| 589 | chr1 | 532434 | 532466 | GSM325478_heart_HCT170_hg18_9463490_chr1_532435_532466 | 1000 | - | 0 | 0 | 0 | 1 | 32, | 0, |
| 589 | chr1 | 564566 | 564598 | GSM325478_heart_HCT170_hg18_2071789_chr1_564567_564598 | 1000 | + | 0 | 0 | 0 | 1 | 32, | 0, |
| 589 | chr1 | 564566 | 564598 | GSM325478_heart_HCT170_hg18_2956118_chr1_564567_564598 | 1000 | + | 0 | 0 | 0 | 1 | 32, | 0, |
| 589 | chr1 | 564566 | 564598 | GSM325478_heart_HCT170_hg18_4613272_chr1_564567_564598 | 1000 | + | 0 | 0 | 0 | 1 | 32, | 0, |
| 589 | chr1 | 564566 | 564598 | GSM325478_heart_HCT170_hg18_5047477_chr1_564567_564598 | 1000 | + | 0 | 0 | 0 | 1 | 32, | 0, |
| 589 | chr1 | 564566 | 564598 | GSM325478_heart_HCT170_hg18_8359074_chr1_564567_564598 | 1000 | + | 0 | 0 | 0 | 1 | 32, | 0, |
| 589 | chr1 | 564566 | 564598 | GSM325478_heart_HCT170_hg18_9607838_chr1_564567_564598 | 1000 | - | 0 | 0 | 0 | 1 | 32, | 0, |
Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.