Schema for Cat Chain - Cat (Mar. 2006 (Broad/felCat3)) Chained Alignments
Database: hg19    Primary Table: chainFelCat3    Row Count: 1,621,811
Format description: Summary info about a chain of alignments
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
score 757877double score of chain
tName chr1varchar(255) Target sequence name
tSize 249250621int(10) unsigned Target sequence size
tStart 11756int(10) unsigned Alignment start position in target
tEnd 38258int(10) unsigned Alignment end position in target
qName scaffold_212598varchar(255) Query sequence name
qSize 286020int(10) unsigned Query sequence size
qStrand +char(1) Query strand
qStart 68566int(10) unsigned Alignment start position in query
qEnd 100790int(10) unsigned Alignment end position in query
id 8684int(10) unsigned chain id
Connected Tables and Joining Fields
      hg19.chainFelCat3Link.chainId (via chainFelCat3.id)
      hg19.netFelCat3.chainId (via chainFelCat3.id)
Sample Rows
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
585757877chr12492506211175638258scaffold_212598286020+685661007908684
58511314chr12492506211441414799scaffold_195532201504+149106149437797680
5854322chr12492506214116041292scaffold_21313977798+520153371484367
5855085chr12492506214120341350scaffold_208471159088-1578051579881377488
58510071chr12492506214121841913scaffold_18520873300-4625746870888364
58511858chr12492506214270543125scaffold_759744234+0376759174
58511469chr12492506214279743125scaffold_11543735805-130451786535
585106998chr12492506214777153725scaffold_107315748-0379659700
58541351chr12492506214799050217scaffold_651271019+01013180588
58534282chr12492506215017451256scaffold_52417914-0913226969

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