Schema for Rat Chain - Rat (Nov. 2004 (Baylor 3.4/rn4)) Chained Alignments
Database: hg19
Primary Table: chainRn4
Row Count: 2,563,762
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 | 132776 | double | score of chain |
| tName | chr1 | varchar(255) | Target sequence name |
| tSize | 249250621 | int(10) unsigned | Target sequence size |
| tStart | 11678 | int(10) unsigned | Alignment start position in target |
| tEnd | 28604 | int(10) unsigned | Alignment end position in target |
| qName | chr4 | varchar(255) | Query sequence name |
| qSize | 187126005 | int(10) unsigned | Query sequence size |
| qStrand | - | char(1) | Query strand |
| qStart | 29160230 | int(10) unsigned | Alignment start position in query |
| qEnd | 29188771 | int(10) unsigned | Alignment end position in query |
| id | 4219 | 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 | 132776 | chr1 | 249250621 | 11678 | 28604 | chr4 | 187126005 | - | 29160230 | 29188771 | 4219 |
| 585 | 29698 | chr1 | 249250621 | 11796 | 13467 | chr9 | 113440463 | + | 105026173 | 105029435 | 229529 |
| 585 | 66064 | chr1 | 249250621 | 12995 | 17313 | chr9 | 113440463 | + | 105206336 | 105210264 | 34368 |
| 585 | 124447 | chr1 | 249250621 | 12995 | 28574 | chr9 | 113440463 | - | 8542842 | 8554277 | 5022 |
| 585 | 62333 | chr1 | 249250621 | 14669 | 17460 | chr9 | 113440463 | + | 105278444 | 105281084 | 41332 |
| 585 | 12031 | chr1 | 249250621 | 17158 | 17597 | chr9 | 113440463 | - | 8441156 | 8441581 | 1196758 |
| 585 | 16798 | chr1 | 249250621 | 24628 | 28084 | chr9 | 113440463 | - | 8453197 | 8454270 | 632234 |
| 585 | 3571 | chr1 | 249250621 | 32308 | 32417 | chr4 | 187126005 | - | 29188777 | 29188884 | 2495396 |
| 585 | 21460 | chr1 | 249250621 | 35977 | 36830 | chr4 | 187126005 | - | 29198165 | 29199026 | 416736 |
| 585 | 15090 | chr1 | 249250621 | 52317 | 53311 | chr3 | 171063335 | + | 97302239 | 97303247 | 776593 |
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.