Schema for chainAilMel1Link
  Database: mm10    Primary Table: chainAilMel1Link    Row Count: 46,248,882   Data last updated: 2012-03-20
Format description: alignment block in chain
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 607smallint(5) unsigned Indexing field to speed chromosome range queries.
tName chr1varchar(255) Target sequence name
tStart 3007027int(10) unsigned Alignment start position in target
tEnd 3007041int(10) unsigned Alignment end position in target
qStart 2581439int(10) unsigned start in query
chainId 337764int(10) unsigned chain id in chain table

Connected Tables and Joining Fields
        mm10.chainAilMel1.id (via chainAilMel1Link.chainId)
      mm10.netAilMel1.chainId (via chainAilMel1Link.chainId)

Sample Rows
 
bintNametStarttEndqStartchainId
607chr1300702730070412581439337764
607chr1300704130070702581454337764
607chr1300707030070812581486337764
607chr1300708530070942581497337764
607chr1300709430071212581514337764
607chr1300712130071382581542337764
607chr1300713830071582581564337764
607chr1300715830071812581586337764
607chr1300718130072252581611337764
607chr1300722530072392581721337764

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