|
|---|
| |
Database: latCha1 Primary Table: xenoMrna Row Count: 6,584,745 Data last updated: 2020-08-19
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 | 345 | int(10) unsigned | Number of bases that match that aren't repeats |
| misMatches | 108 | 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 | 1 | int(10) unsigned | Number of inserts in query |
| qBaseInsert | 24 | int(10) unsigned | Number of bases inserted in query |
| tNumInsert | 1 | int(10) unsigned | Number of inserts in target |
| tBaseInsert | 24 | int(10) unsigned | Number of bases inserted in target |
| strand | ++ | char(2) | + or - for strand. First character query, second target (optional) |
| qName | LE085559 | varchar(255) | Query sequence name |
| qSize | 1774 | int(10) unsigned | Query sequence size |
| qStart | 1275 | int(10) unsigned | Alignment start position in query |
| qEnd | 1752 | int(10) unsigned | Alignment end position in query |
| tName | AFYH01266222 | varchar(255) | Target sequence name |
| tSize | 36089 | int(10) unsigned | Target sequence size |
| tStart | 8187 | int(10) unsigned | Alignment start position in target |
| tEnd | 8664 | int(10) unsigned | Alignment end position in target |
| blockCount | 2 | int(10) unsigned | Number of blocks in alignment |
| blockSizes | 201,252, | longblob | Size of each block |
| qStarts | 1275,1500, | longblob | Start of each block in query. |
| tStarts | 8187,8412, | 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 | 345 | 108 | 0 | 0 | 1 | 24 | 1 | 24 | ++ | LE085559 | 1774 | 1275 | 1752 | AFYH01266222 | 36089 | 8187 | 8664 | 2 | 201,252, | 1275,1500, | 8187,8412, |
| 585 | 397 | 143 | 0 | 0 | 0 | 0 | 1 | 1049 | ++ | JR869255 | 3922 | 3339 | 3879 | AFYH01266222 | 36089 | 8187 | 9776 | 2 | 475,65, | 3339,3814, | 8187,9711, |
| 585 | 263 | 66 | 0 | 0 | 0 | 0 | 0 | 0 | +- | JW419090 | 965 | 1 | 330 | AFYH01266222 | 36089 | 8190 | 8519 | 1 | 329, | 1, | 27570, |
| 585 | 98 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | +- | AK018094 | 1406 | 11 | 127 | AFYH01266222 | 36089 | 8193 | 8309 | 1 | 116, | 11, | 27780, |
| 585 | 252 | 74 | 0 | 0 | 0 | 0 | 0 | 0 | +- | BC067217 | 1627 | 0 | 326 | AFYH01266222 | 36089 | 8196 | 8522 | 1 | 326, | 0, | 27567, |
| 585 | 583 | 287 | 0 | 0 | 2 | 9 | 3 | 1060 | +- | JT650470 | 1557 | 12 | 891 | AFYH01266222 | 36089 | 8199 | 10129 | 4 | 210,199,318,143, | 12,230,429,748, | 25960,26179,27426,27747, |
| 585 | 210 | 78 | 0 | 0 | 1 | 1 | 1 | 51 | +- | JT761488 | 375 | 0 | 289 | AFYH01266222 | 36089 | 8207 | 8546 | 2 | 177,111, | 0,178, | 27543,27771, |
| 585 | 198 | 81 | 0 | 0 | 0 | 0 | 0 | 0 | +- | JW640646 | 280 | 1 | 280 | AFYH01266222 | 36089 | 8231 | 8510 | 1 | 279, | 1, | 27579, |
| 585 | 362 | 181 | 0 | 0 | 0 | 0 | 1 | 1049 | ++ | JO523935 | 586 | 20 | 563 | AFYH01266222 | 36089 | 8319 | 9911 | 2 | 343,200, | 20,363, | 8319,9711, |
| 585 | 181 | 113 | 0 | 0 | 2 | 27 | 2 | 129 | +- | JT761487 | 366 | 29 | 350 | AFYH01266222 | 36089 | 9706 | 10129 | 3 | 48,192,54, | 29,87,296, | 25960,26104,26329, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server