|
|---|
| |
Database: hg18 Primary Table: xenoEst Row Count: 41,801,735 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 | 247249719 | 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 | 247249719 | 2866 | 2917 | 1 | 51, | 0, | 2866, |
| 585 | 399 | 60 | 0 | 0 | 1 | 48 | 4 | 6784 | +- | AA388728 | 507 | 0 | 507 | chr1 | 247249719 | 7488 | 14731 | 5 | 88,44,63,147,117, | 0,88,180,243,390, | 247234988,247235077,247241526,247241795,247242114, |
| 585 | 401 | 62 | 0 | 0 | 1 | 44 | 4 | 6780 | -+ | AA388728 | 507 | 0 | 507 | chr1 | 247249719 | 7488 | 14731 | 5 | 117,147,69,40,90, | 0,117,264,377,417, | 7488,7777,8130,14600,14641, |
| 587 | 107 | 8 | 0 | 0 | 2 | 216 | 4 | 400 | +- | AA222500 | 507 | 146 | 477 | chr1 | 247249719 | 361114 | 361629 | 5 | 21,20,38,12,24, | 146,310,330,368,453, | 246888090,246888447,246888468,246888507,246888581, |
| 587 | 107 | 8 | 0 | 0 | 2 | 216 | 4 | 400 | +- | AA789948 | 448 | 111 | 442 | chr1 | 247249719 | 361114 | 361629 | 5 | 21,20,38,12,24, | 111,275,295,333,418, | 246888090,246888447,246888468,246888507,246888581, |
| 587 | 72 | 7 | 0 | 0 | 1 | 143 | 2 | 337 | +- | AA241090 | 499 | 216 | 438 | chr1 | 247249719 | 361213 | 361629 | 3 | 21,20,38, | 216,380,400, | 246888090,246888447,246888468, |
| 587 | 72 | 7 | 0 | 0 | 1 | 143 | 2 | 337 | +- | AA414142 | 414 | 90 | 312 | chr1 | 247249719 | 361213 | 361629 | 3 | 21,20,38, | 90,254,274, | 246888090,246888447,246888468, |
| 588 | 206 | 31 | 0 | 0 | 1 | 3 | 1 | 5 | -- | AA413278 | 378 | 14 | 254 | chr1 | 247249719 | 460783 | 461025 | 2 | 150,87, | 124,277, | 246788694,246788849, |
| 589 | 79 | 24 | 0 | 0 | 1 | 1 | 0 | 0 | -- | AA222468 | 196 | 10 | 114 | chr1 | 247249719 | 554840 | 554943 | 2 | 79,24, | 82,162, | 246694776,246694855, |
| 589 | 58 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | AA647694 | 145 | 64 | 142 | chr1 | 247249719 | 554969 | 555047 | 1 | 78, | 64, | 554969, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server