Schema for chainOryLat2Link
Database: hg19    Primary Table: chainOryLat2Link    Row Count: 6,775,178
Format description: alignment block in chain
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
tName chr1varchar(255) Target sequence name
tStart 12176int(10) unsigned Alignment start position in target
tEnd 12245int(10) unsigned Alignment end position in target
qStart 12382409int(10) unsigned start in query
chainId 10168int(10) unsigned chain id in chain table
Connected Tables and Joining Fields
      hg19.chainOryLat2.id (via chainOryLat2Link.chainId)
      hg19.netOryLat2.chainId (via chainOryLat2Link.chainId)
Sample Rows
bintNametStarttEndqStartchainId
585chr112176122451238240910168
585chr112609127031238253310168
585chr113256133791238271610168
585chr114697147311238363310168
585chr114740147821238366710168
585chr114782148031238371810168
585chr114803148461238374810168
585chr114846148541238379310168
585chr114865148731238380110168
585chr114875149191238380910168

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