|
|---|
| |
Database: hg38 Primary Table: xenoEst Row Count: 49,226,383 Data last updated: 2020-08-17
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 | 248956422 | int(10) unsigned | Target sequence size |
| tStart | 13003 | int(10) unsigned | Alignment start position in target |
| tEnd | 13054 | 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 | 13003, | 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 | 248956422 | 13003 | 13054 | 1 | 51, | 0, | 13003, |
| 585 | 332 | 44 | 0 | 0 | 1 | 43 | 3 | 6778 | -+ | AA388728 | 507 | 88 | 507 | chr1 | 248956422 | 17625 | 24779 | 4 | 117,147,69,43, | 0,117,264,376, | 17625,17914,18267,24736, |
| 73 | 403 | 61 | 0 | 0 | 1 | 43 | 4 | 177304 | +- | AA388728 | 507 | 0 | 507 | chr1 | 248956422 | 17625 | 195393 | 5 | 88,44,68,147,117, | 0,88,175,243,390, | 248761029,248761118,248938087,248938361,248938680, |
| 586 | 41 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | -+ | AA542579 | 418 | 367 | 418 | chr1 | 248956422 | 183522 | 183573 | 1 | 51, | 0, | 183522, |
| 586 | 400 | 58 | 0 | 0 | 2 | 44 | 4 | 6781 | -+ | AA388728 | 507 | 5 | 507 | chr1 | 248956422 | 188149 | 195388 | 6 | 117,48,98,69,42,84, | 0,117,166,264,376,418, | 188149,188438,188486,188790,195261,195304, |
| 586 | 102 | 44 | 0 | 0 | 0 | 0 | 0 | 0 | -+ | AA978407 | 761 | 584 | 730 | chr1 | 248956422 | 258655 | 258801 | 1 | 146, | 31, | 258655, |
| 586 | 54 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | -+ | AA803699 | 632 | 528 | 593 | chr1 | 248956422 | 258736 | 258801 | 1 | 65, | 39, | 258736, |
| 73 | 54 | 4 | 0 | 0 | 0 | 0 | 1 | 234977 | ++ | AA241090 | 499 | 380 | 438 | chr1 | 248956422 | 447927 | 682962 | 2 | 20,38, | 380,400, | 447927,682924, |
| 73 | 86 | 5 | 0 | 0 | 1 | 69 | 3 | 235036 | ++ | AA414142 | 414 | 254 | 414 | chr1 | 248956422 | 447927 | 683054 | 4 | 20,38,12,21, | 254,274,312,393, | 447927,682924,682963,683033, |
| 73 | 92 | 6 | 0 | 0 | 1 | 69 | 3 | 235036 | ++ | AA222500 | 507 | 310 | 477 | chr1 | 248956422 | 447927 | 683061 | 4 | 20,38,12,28, | 310,330,368,449, | 447927,682924,682963,683033, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server