|
|---|
| |
Database: apiMel1 Primary Table: all_mrna Row Count: 132,241 Data last updated: 2020-08-20
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory
| field | example | SQL type | info | description |
|---|
| bin | 585 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 243 | int(10) unsigned | range | Number of bases that match that aren't repeats |
| misMatches | 0 | int(10) unsigned | range | Number of bases that don't match |
| repMatches | 0 | int(10) unsigned | range | Number of bases that match but are part of repeats |
| nCount | 0 | int(10) unsigned | range | Number of 'N' bases |
| qNumInsert | 0 | int(10) unsigned | range | Number of inserts in query |
| qBaseInsert | 0 | int(10) unsigned | range | Number of bases inserted in query |
| tNumInsert | 0 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 0 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | HP476752 | varchar(255) | values | Query sequence name |
| qSize | 1273 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 243 | int(10) unsigned | range | Alignment end position in query |
| tName | Group1.1 | varchar(255) | values | Target sequence name |
| tSize | 88047 | int(10) unsigned | range | Target sequence size |
| tStart | 94 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 337 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 243, | longblob | | Size of each block |
| qStarts | 1030, | longblob | | Start of each block in query. |
| tStarts | 94, | 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 | 243 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | HP476752 | 1273 | 0 | 243 | Group1.1 | 88047 | 94 | 337 | 1 | 243, | 1030, | 94, |
| 585 | 243 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | HP476753 | 1201 | 0 | 243 | Group1.1 | 88047 | 94 | 337 | 1 | 243, | 958, | 94, |
| 585 | 243 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | HP476754 | 1269 | 0 | 243 | Group1.1 | 88047 | 94 | 337 | 1 | 243, | 1026, | 94, |
| 585 | 243 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | HP476755 | 1197 | 0 | 243 | Group1.1 | 88047 | 94 | 337 | 1 | 243, | 954, | 94, |
| 585 | 224 | 1 | 14 | 0 | 0 | 0 | 1 | 141 | - | HP537936 | 1193 | 0 | 239 | Group1.1 | 88047 | 94 | 474 | 2 | 132,107, | 954,1086, | 94,367, |
| 585 | 470 | 1 | 56 | 0 | 0 | 0 | 0 | 0 | + | HP461323 | 877 | 348 | 875 | Group1.1 | 88047 | 94 | 621 | 1 | 527, | 348, | 94, |
| 585 | 329 | 1 | 56 | 0 | 0 | 0 | 1 | 141 | + | HP461324 | 736 | 348 | 734 | Group1.1 | 88047 | 94 | 621 | 2 | 132,254, | 348,480, | 94,367, |
| 585 | 472 | 0 | 56 | 0 | 0 | 0 | 0 | 0 | - | HP560958 | 1557 | 0 | 528 | Group1.1 | 88047 | 94 | 622 | 1 | 528, | 1029, | 94, |
| 585 | 407 | 0 | 28 | 0 | 0 | 0 | 1 | 93 | - | HP560959 | 1464 | 0 | 435 | Group1.1 | 88047 | 94 | 622 | 2 | 325,110, | 1029,1354, | 94,512, |
| 585 | 574 | 0 | 56 | 0 | 0 | 0 | 0 | 0 | + | HP546347 | 1586 | 956 | 1586 | Group1.1 | 88047 | 94 | 724 | 1 | 630, | 956, | 94, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server