| 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 | 10917 | int(10) unsigned | Start position in chromosome (forward strand) |
| chromEnd | 11396 | int(10) unsigned | End position in chromosome |
| extFile | 2386996 | int(10) unsigned | ID of associated external file |
| offset | 34 | bigint(20) | Offset in external file |
| score | 0.85738 | double | Overall score |
| bin | chrom | chromStart | chromEnd | extFile | offset | score |
|---|---|---|---|---|---|---|
| 585 | chr1 | 10917 | 11396 | 2386996 | 34 | 0.85738 |
| 585 | chr1 | 11396 | 11489 | 2386996 | 1116 | 0.485341 |
| 585 | chr1 | 11489 | 11570 | 2386996 | 1633 | 0.631527 |
| 585 | chr1 | 11570 | 11625 | 2386996 | 2619 | 0.590915 |
| 585 | chr1 | 11625 | 11804 | 2386996 | 3386 | 0.630984 |
| 585 | chr1 | 11804 | 11857 | 2386996 | 5570 | 0.565192 |
| 585 | chr1 | 11857 | 12072 | 2386996 | 6585 | 0.626202 |
| 585 | chr1 | 12072 | 12110 | 2386996 | 9148 | 0.767157 |
| 585 | chr1 | 12110 | 12176 | 2386996 | 10097 | 0.502963 |
| 585 | chr1 | 12176 | 12249 | 2386996 | 11282 | 0.652791 |
Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.