| field | example | SQL type | description |
|---|---|---|---|
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| tName | chr1 | varchar(255) | Target sequence name |
| tStart | 11679 | int(10) unsigned | Alignment start position in target |
| tEnd | 11692 | int(10) unsigned | Alignment end position in target |
| qStart | 28036581 | int(10) unsigned | start in query |
| chainId | 2086 | int(10) unsigned | chain id in chain table |
| bin | tName | tStart | tEnd | qStart | chainId |
|---|---|---|---|---|---|
| 585 | chr1 | 11679 | 11692 | 28036581 | 2086 |
| 585 | chr1 | 11692 | 11713 | 28036595 | 2086 |
| 585 | chr1 | 11713 | 11733 | 28036617 | 2086 |
| 585 | chr1 | 11733 | 11782 | 28036638 | 2086 |
| 585 | chr1 | 11782 | 11793 | 28036688 | 2086 |
| 585 | chr1 | 11794 | 11809 | 28036699 | 2086 |
| 585 | chr1 | 11822 | 11855 | 28036714 | 2086 |
| 585 | chr1 | 11855 | 11871 | 28036793 | 2086 |
| 585 | chr1 | 11871 | 11890 | 28036956 | 2086 |
| 585 | chr1 | 11891 | 11942 | 28036975 | 2086 |
Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.