Schema for chainGalGal3
Database: hg19    Primary Table: chainGalGal3    Row Count: 858,742
Format description: Summary info about a chain of alignments
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
score 78445double score of chain
tName chr1varchar(255) Target sequence name
tSize 249250621int(10) unsigned Target sequence size
tStart 12178int(10) unsigned Alignment start position in target
tEnd 18381int(10) unsigned Alignment end position in target
qName chr1varchar(255) Query sequence name
qSize 200994015int(10) unsigned Query sequence size
qStrand +char(1) Query strand
qStart 62069088int(10) unsigned Alignment start position in query
qEnd 62081481int(10) unsigned Alignment end position in query
id 5655int(10) unsigned chain id
Connected Tables and Joining Fields
      hg19.chainGalGal3Link.chainId (via chainGalGal3.id)
      hg19.netGalGal3.chainId (via chainGalGal3.id)
Sample Rows
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
58578445chr12492506211217818381chr1200994015+62069088620814815655
58529607chr12492506215239564077chr1022556432+17537418363560710
58536778chr12492506215244369983chr562238931+1055287107317433238
58532628chr12492506215248263880chr274841970-4829520483506146351
58540983chr12492506215251370120chrUn_random63870806-275737672759457025293
58535198chr12492506215251769987chr562238931+12096115247037453
58516014chr12492506215256663873chrUn_random63870806+5080116650813290317325
58518051chr12492506215256663877chrUn_random63870806-1682300616829957243654
58524460chr12492506215256669971chrUn_random63870806-3100920831039202102231
58519494chr12492506215262063864chrUn_random63870806-2898649928990588198197

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