|
|---|
| |
Database: droEre1 Primary Table: xenoMrna Row Count: 4,149,730 Data last updated: 2020-08-18
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 | 130 | int(10) unsigned | Number of bases that match that aren't repeats |
| misMatches | 8 | 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 | JV210741 | varchar(255) | Query sequence name |
| qSize | 454 | int(10) unsigned | Query sequence size |
| qStart | 187 | int(10) unsigned | Alignment start position in query |
| qEnd | 325 | int(10) unsigned | Alignment end position in query |
| tName | scaffold_1009 | varchar(255) | Target sequence name |
| tSize | 1529 | int(10) unsigned | Target sequence size |
| tStart | 119 | int(10) unsigned | Alignment start position in target |
| tEnd | 257 | int(10) unsigned | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | Number of blocks in alignment |
| blockSizes | 138, | longblob | Size of each block |
| qStarts | 187, | longblob | Start of each block in query. |
| tStarts | 1272, | 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 | 130 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | +- | JV210741 | 454 | 187 | 325 | scaffold_1009 | 1529 | 119 | 257 | 1 | 138, | 187, | 1272, |
| 585 | 231 | 60 | 0 | 0 | 0 | 0 | 2 | 1073 | +- | BC074158 | 728 | 185 | 476 | scaffold_1026 | 1396 | 31 | 1395 | 3 | 261,4,26, | 185,446,450, | 1,318,1339, |
| 585 | 202 | 46 | 0 | 0 | 4 | 46 | 2 | 65 | +- | JU074545 | 308 | 2 | 296 | scaffold_1026 | 1396 | 1064 | 1377 | 5 | 69,45,78,36,20, | 2,72,124,203,276, | 19,88,139,217,312, |
| 585 | 226 | 56 | 0 | 0 | 3 | 26 | 1 | 47 | +- | JI028093 | 343 | 24 | 332 | scaffold_1026 | 1396 | 1066 | 1395 | 4 | 51,165,48,18, | 24,76,242,314, | 1,52,217,312, |
| 585 | 227 | 55 | 0 | 0 | 1 | 24 | 1 | 47 | +- | JI088119 | 373 | 23 | 329 | scaffold_1026 | 1396 | 1066 | 1395 | 2 | 264,18, | 23,311, | 1,312, |
| 585 | 226 | 56 | 0 | 0 | 1 | 24 | 1 | 47 | +- | JL718793 | 451 | 1 | 307 | scaffold_1026 | 1396 | 1066 | 1395 | 2 | 264,18, | 1,289, | 1,312, |
| 585 | 226 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | JP814626 | 342 | 46 | 342 | scaffold_1026 | 1396 | 1099 | 1395 | 1 | 296, | 46, | 1099, |
| 585 | 202 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | +- | HE735280 | 365 | 47 | 329 | scaffold_1026 | 1396 | 1113 | 1395 | 1 | 282, | 47, | 1, |
| 585 | 77 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | EZ267654 | 438 | 328 | 430 | scaffold_1026 | 1396 | 1119 | 1221 | 1 | 102, | 328, | 1119, |
| 585 | 206 | 64 | 0 | 0 | 0 | 0 | 0 | 0 | +- | CU227968 | 615 | 12 | 282 | scaffold_1026 | 1396 | 1125 | 1395 | 1 | 270, | 12, | 1, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server