| field | example | SQL type | info | description |
|---|---|---|---|---|
| bin | 73 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| chrom | chr1 | varchar(255) | values | Reference sequence chromosome or scaffold |
| chromStart | 10514 | int(10) unsigned | range | Start position in chromosome |
| chromEnd | 177417 | int(10) unsigned | range | End position in chromosome |
| name | HIT000385367 | varchar(255) | values | Name of item |
| score | 0 | int(10) unsigned | range | Score from 0-1000 |
| strand | + | char(1) | values | + or - |
| thickStart | 65840 | int(10) unsigned | range | Start of where display should be thick (start codon) |
| thickEnd | 65998 | int(10) unsigned | range | End of where display should be thick (stop codon) |
| reserved | 0 | int(10) unsigned | range | Used as itemRgb as of 2004-11-22 |
| blockCount | 1 | int(10) unsigned | range | Number of blocks |
| blockSizes | 166903, | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73 | chr1 | 10514 | 177417 | HIT000385367 | 0 | + | 65840 | 65998 | 0 | 1 | 166903, | 0, |
| 585 | chr1 | 11874 | 14361 | HIT000500255_01 | 0 | + | 12623 | 13639 | 0 | 3 | 353,126,958, | 0,721,1529, |
| 585 | chr1 | 11874 | 14362 | HIT000500253_01 | 0 | + | 12623 | 13259 | 0 | 3 | 353,108,1141, | 0,739,1347, |
| 585 | chr1 | 11874 | 14362 | HIT000500252_01 | 0 | + | 13548 | 13819 | 0 | 3 | 353,51,1141, | 0,772,1347, |
| 585 | chr1 | 11874 | 14361 | HIT000500251_01 | 0 | + | 12623 | 13259 | 0 | 3 | 353,108,1140, | 0,739,1347, |
| 585 | chr1 | 11874 | 14409 | HIT000500246 | 0 | + | 12190 | 13259 | 0 | 3 | 353,108,1188, | 0,739,1347, |
| 585 | chr1 | 11874 | 14409 | HIT000500245 | 0 | + | 12190 | 13259 | 0 | 3 | 353,108,1188, | 0,739,1347, |
| 585 | chr1 | 11874 | 14443 | HIT000092612_05 | 0 | + | 12190 | 13259 | 0 | 3 | 353,108,1222, | 0,739,1347, |
| 585 | chr1 | 12613 | 14362 | HIT000500247_01 | 0 | + | 13548 | 13819 | 0 | 2 | 108,1141, | 0,608, |
| 585 | chr1 | 14332 | 19236 | HIT000261011_03 | 0 | - | 16745 | 17310 | 0 | 10 | 497,68,151,158,197,509,146,101,53,323, | 0,638,1464,2275,2526,2901,3583,3936,4169,4581, |
Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.