Schema for chainPanTro2Link
Database: hg19    Primary Table: chainPanTro2Link    Row Count: 12,998,449
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 10917int(10) unsigned Alignment start position in target
tEnd 10941int(10) unsigned Alignment end position in target
qStart 13606int(10) unsigned start in query
chainId 1404int(10) unsigned chain id in chain table
Connected Tables and Joining Fields
      hg19.chainPanTro2.id (via chainPanTro2Link.chainId)
      hg19.netPanTro2.chainId (via chainPanTro2Link.chainId)
Sample Rows
bintNametStarttEndqStartchainId
585chr11091710941136061404
585chr11094710972136301404
585chr11097310998136551404
585chr11099911025136801404
585chr11102611067137061404
585chr11107211386137471404
585chr11144811463140611404
585chr11146311868140771404
585chr11187312191144821404
585chr11219112612148121404

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