|
|---|
| |
Database: hg17 Primary Table: xenoEst Row Count: 43,792,878 Data last updated: 2020-08-21
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory
| field | example | SQL type | description |
|---|
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| matches | 41 | int(10) unsigned | Number of bases that match that aren't repeats |
| misMatches | 10 | int(10) unsigned | Number of bases that don't match |
| repMatches | 0 | int(10) unsigned | Number of bases that match but are part of repeats |
| nCount | 0 | int(10) unsigned | Number of 'N' bases |
| qNumInsert | 0 | int(10) unsigned | Number of inserts in query |
| qBaseInsert | 0 | int(10) unsigned | Number of bases inserted in query |
| tNumInsert | 0 | int(10) unsigned | Number of inserts in target |
| tBaseInsert | 0 | int(10) unsigned | Number of bases inserted in target |
| strand | -+ | char(2) | + or - for strand. First character query, second target (optional) |
| qName | AA542579 | varchar(255) | Query sequence name |
| qSize | 418 | int(10) unsigned | Query sequence size |
| qStart | 367 | int(10) unsigned | Alignment start position in query |
| qEnd | 418 | int(10) unsigned | Alignment end position in query |
| tName | chr1 | varchar(255) | Target sequence name |
| tSize | 245522847 | int(10) unsigned | Target sequence size |
| tStart | 2866 | int(10) unsigned | Alignment start position in target |
| tEnd | 2917 | int(10) unsigned | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | Number of blocks in alignment |
| blockSizes | 51, | longblob | Size of each block |
| qStarts | 0, | longblob | Start of each block in query. |
| tStarts | 2866, | longblob | Start of each block in target. |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|
|
Sample Rows
|
|---|
| |
| bin | matches | misMatches | repMatches | nCount | qNumInsert | qBaseInsert | tNumInsert | tBaseInsert | strand | qName | qSize | qStart | qEnd | tName | tSize | tStart | tEnd | blockCount | blockSizes | qStarts | tStarts |
|---|
| 585 | 41 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | -+ | AA542579 | 418 | 367 | 418 | chr1 | 245522847 | 2866 | 2917 | 1 | 51, | 0, | 2866, |
| 585 | 399 | 60 | 0 | 0 | 1 | 48 | 4 | 6784 | +- | AA388728 | 507 | 0 | 507 | chr1 | 245522847 | 7488 | 14731 | 5 | 88,44,63,147,117, | 0,88,180,243,390, | 245508116,245508205,245514654,245514923,245515242, |
| 585 | 401 | 62 | 0 | 0 | 1 | 44 | 4 | 6780 | -+ | AA388728 | 507 | 0 | 507 | chr1 | 245522847 | 7488 | 14731 | 5 | 117,147,69,40,90, | 0,117,264,377,417, | 7488,7777,8130,14600,14641, |
| 585 | 345 | 55 | 0 | 0 | 1 | 31 | 3 | 6768 | +- | AA866967 | 449 | 15 | 446 | chr1 | 245522847 | 7575 | 14743 | 4 | 145,78,147,30, | 15,191,269,416, | 245508104,245514639,245514923,245515242, |
| 585 | 344 | 55 | 0 | 0 | 1 | 31 | 3 | 6768 | -+ | AA866967 | 449 | 15 | 445 | chr1 | 245522847 | 7576 | 14743 | 4 | 29,147,79,144, | 4,33,180,290, | 7576,7777,8130,14599, |
| 588 | 67 | 21 | 0 | 0 | 1 | 254 | 1 | 499 | -+ | AA162589 | 546 | 181 | 523 | chr1 | 245522847 | 411252 | 411839 | 2 | 31,57, | 23,308, | 411252,411782, |
| 588 | 209 | 33 | 0 | 0 | 0 | 0 | 1 | 2 | ++ | AA413278 | 378 | 13 | 255 | chr1 | 245522847 | 510782 | 511026 | 2 | 90,152, | 13,103, | 510782,510874, |
| 588 | 206 | 31 | 0 | 0 | 1 | 3 | 1 | 5 | -- | AA413278 | 378 | 14 | 254 | chr1 | 245522847 | 510783 | 511025 | 2 | 150,87, | 124,277, | 245011822,245011977, |
| 589 | 49 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | -- | AA028833 | 447 | 51 | 102 | chr1 | 245522847 | 604814 | 604865 | 1 | 51, | 345, | 244917982, |
| 589 | 49 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | -- | AA637466 | 399 | 60 | 111 | chr1 | 245522847 | 604814 | 604865 | 1 | 51, | 288, | 244917982, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server