Schema for chainOryLat2Link
  Database: mm10    Primary Table: chainOryLat2Link    Row Count: 4,804,714   Data last updated: 2012-04-03
Format description: alignment block in chain
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 609smallint(5) unsigned Indexing field to speed chromosome range queries.
tName chr1varchar(255) Target sequence name
tStart 3215975int(10) unsigned Alignment start position in target
tEnd 3216009int(10) unsigned Alignment end position in target
qStart 26958418int(10) unsigned start in query
chainId 28642int(10) unsigned chain id in chain table

Connected Tables and Joining Fields
        mm10.chainOryLat2.id (via chainOryLat2Link.chainId)
      mm10.netOryLat2.chainId (via chainOryLat2Link.chainId)

Sample Rows
 
bintNametStarttEndqStartchainId
609chr1321597532160092695841828642
609chr1321600932160572695845328642
609chr1321605932160712695850128642
609chr1321607132160882695851828642
609chr1321608832162042695853828642
609chr1321620432162322695866428642
609chr1321623232162932695870028642
609chr1321629532163232695876128642
609chr1321632332163552695879428642
609chr1321635532163792695884128642

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.