Schema for Pig Chain - Pig (Nov. 2009 (SGSC Sscrofa9.2/susScr2)) Chained Alignments
Database: hg19
Primary Table: chainSusScr2
Row Count: 5,579,263
Format description: Summary info about a chain of alignments
| field | example | SQL type | description |
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| score | 551182 | double | score of chain |
| tName | chr1 | varchar(255) | Target sequence name |
| tSize | 249250621 | int(10) unsigned | Target sequence size |
| tStart | 11707 | int(10) unsigned | Alignment start position in target |
| tEnd | 36884 | int(10) unsigned | Alignment end position in target |
| qName | chr5 | varchar(255) | Query sequence name |
| qSize | 100516970 | int(10) unsigned | Query sequence size |
| qStrand | + | char(1) | Query strand |
| qStart | 63220996 | int(10) unsigned | Alignment start position in query |
| qEnd | 63248923 | int(10) unsigned | Alignment end position in query |
| id | 7774 | int(10) unsigned | chain id |
Connected Tables and Joining Fields
Sample Rows
| bin | score | tName | tSize | tStart | tEnd | qName | qSize | qStrand | qStart | qEnd | id |
|---|
| 585 | 551182 | chr1 | 249250621 | 11707 | 36884 | chr5 | 100516970 | + | 63220996 | 63248923 | 7774 |
| 585 | 15380 | chr1 | 249250621 | 14443 | 15884 | chr14 | 148510138 | + | 10904380 | 10905195 | 1333630 |
| 585 | 38911 | chr1 | 249250621 | 27574 | 28603 | chr11 | 79814395 | - | 20362913 | 20364075 | 141648 |
| 585 | 4718 | chr1 | 249250621 | 34128 | 34252 | chr1 | 295529705 | - | 194356270 | 194356394 | 4600679 |
| 585 | 734204 | chr1 | 249250621 | 40735 | 77642 | chr7 | 136409062 | - | 50613878 | 50652949 | 6026 |
| 585 | 829802 | chr1 | 249250621 | 42119 | 77642 | chr7 | 136409062 | + | 86018277 | 86056178 | 5338 |
| 585 | 112692 | chr1 | 249250621 | 47291 | 51497 | chr7 | 136409062 | + | 134597968 | 134600805 | 26639 |
| 585 | 10899 | chr1 | 249250621 | 47489 | 48019 | chr7 | 136409062 | + | 86042168 | 86042748 | 2378237 |
| 585 | 11335 | chr1 | 249250621 | 47489 | 48019 | chr7 | 136409062 | - | 1832833 | 1833413 | 2259605 |
| 585 | 3679 | chr1 | 249250621 | 47613 | 47682 | chr7 | 136409062 | - | 50639047 | 50639116 | 5208563 |
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.