Schema for chainTaeGut1
Database: hg19    Primary Table: chainTaeGut1    Row Count: 226,028
Format description: Summary info about a chain of alignments
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
score 91904double range score of chain
tName chr1varchar(255) values Target sequence name
tSize 249250621int(10) unsigned range Target sequence size
tStart 12178int(10) unsigned range Alignment start position in target
tEnd 18492int(10) unsigned range Alignment end position in target
qName chr1Avarchar(255) values Query sequence name
qSize 73657157int(10) unsigned range Query sequence size
qStrand -char(1) values Query strand
qStart 1352203int(10) unsigned range Alignment start position in query
qEnd 1365641int(10) unsigned range Alignment end position in query
id 3029int(10) unsigned range chain id
Connected Tables and Joining Fields
      hg19.chainTaeGut1Link.chainId (via chainTaeGut1.id)
      hg19.netTaeGut1.chainId (via chainTaeGut1.id)
Sample Rows
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
58591904chr12492506211217818492chr1A73657157-135220313656413029
58554153chr12492506211295917379chrUn175225315+1654175761654222237862
58523712chr12492506215244963739chr562374962-559403955594728142098
58534750chr12492506216293869859chr562374962-559403875594728017831
58512364chr12492506216294963843chrUn175225315+124077813124078711144044
58513989chr12492506216902069614chr562374962-5593568355936261120567
58514624chr12492506216905570035chr274618897-13378741338849112146
58522494chr12492506216905570038chr562374962-559403835594136347273
58511760chr12492506216910269950chr1B1083483-139166140029152933
58613500chr1249250621131467131848chrUn175225315-3147125531471619127447

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