Schema for chainCalJac3
Database: hg19    Primary Table: chainCalJac3    Row Count: 619,213
Format description: Summary info about a chain of alignments
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
score 1197579double score of chain
tName chr1varchar(255) Target sequence name
tSize 249250621int(10) unsigned Target sequence size
tStart 11498int(10) unsigned Alignment start position in target
tEnd 39621int(10) unsigned Alignment end position in target
qName chr9varchar(255) Query sequence name
qSize 124281992int(10) unsigned Query sequence size
qStrand -char(1) Query strand
qStart 112497778int(10) unsigned Alignment start position in query
qEnd 112550590int(10) unsigned Alignment end position in query
id 1131int(10) unsigned chain id
Connected Tables and Joining Fields
      hg19.chainCalJac3Link.chainId (via chainCalJac3.id)
      hg19.netCalJac3.chainId (via chainCalJac3.id)
Sample Rows
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
5851197579chr12492506211149839621chr9124281992-1124977781125505901131
585109763chr12492506211157914250chr9124281992-10992139110992602126823
585211631chr12492506211159132508chr9124281992-10484184910485552910917
58540102chr12492506211259613721chrUn_ACFV0117779429867+2848529643127810
58558375chr12492506211260524797chr14108792865+2375611238213577585
58592565chr12492506211260829901chr10132174527-517555565176198834932
58510983chr12492506211346913721chr14108792865+23790692379319436359
58519710chr12492506211379414455chr14108792865+23793822380059287424
58532366chr12492506211445515055chr9124281992-112523406112523979167151
5855676chr12492506211506215211chr9124281992-112523979112524124591322

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