Schema for chainHg38
  Database: rheMac10    Primary Table: chainHg38    Row Count: 1,082,340   Data last updated: 2019-07-04
Format description: Summary info about a chain of alignments
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
score 112696double score of chain
tName chr1varchar(255) Target sequence name
tSize 223616942int(10) unsigned Target sequence size
tStart 0int(10) unsigned Alignment start position in target
tEnd 3927int(10) unsigned Alignment end position in target
qName chr5varchar(255) Query sequence name
qSize 181538259int(10) unsigned Query sequence size
qStrand +char(1) Query strand
qStart 21180int(10) unsigned Alignment start position in query
qEnd 25339int(10) unsigned Alignment end position in query
id 40435int(10) unsigned chain id

Connected Tables and Joining Fields
        rheMac10.chainHg38Link.chainId (via chainHg38.id)
      rheMac10.netHg38.chainId (via chainHg38.id)

Sample Rows
 
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
585112696chr122361694203927chr5181538259+211802533940435
585116913chr122361694203927chr2242193529+181832062939036
585118689chr122361694203927chr13114364328-237042586138542
585121331chr122361694203927chr4190214555+286323277337819
585389016chr1223616942023834chr6170805979+15669216562014088
11191484301chr1223616942020368075chr1248956422-308652034167749
585118963chr122361694233927chrUn_KI270744v1168472-2935707438459
5855030chr1223616942708788chr13114364328-24317243971078101
5855030chr1223616942708788chr6170805979+1573231574031078229
5855270chr1223616942858929chr6170805979+1573231573941046534

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