|
|---|
| |
Database: gadMor1 Primary Table: all_mrna Row Count: 77,837 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 | info | description |
|---|
| bin | 585 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 269 | int(10) unsigned | range | Number of bases that match that aren't repeats |
| misMatches | 2 | int(10) unsigned | range | Number of bases that don't match |
| repMatches | 13 | 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 | 1 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 456 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | JW177192 | varchar(255) | values | Query sequence name |
| qSize | 1401 | int(10) unsigned | range | Query sequence size |
| qStart | 316 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 600 | int(10) unsigned | range | Alignment end position in query |
| tName | CAEA01000002 | varchar(255) | values | Target sequence name |
| tSize | 1070 | int(10) unsigned | range | Target sequence size |
| tStart | 23 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 763 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 2 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 33,251, | longblob | | Size of each block |
| qStarts | 801,834, | longblob | | Start of each block in query. |
| tStarts | 23,512, | 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 | 269 | 2 | 13 | 0 | 0 | 0 | 1 | 456 | - | JW177192 | 1401 | 316 | 600 | CAEA01000002 | 1070 | 23 | 763 | 2 | 33,251, | 801,834, | 23,512, |
| 585 | 171 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | - | JW212217 | 333 | 55 | 226 | CAEA01000016 | 172 | 0 | 172 | 2 | 144,27, | 107,251, | 0,145, |
| 585 | 362 | 1 | 1 | 0 | 0 | 0 | 2 | 103 | - | JW188899 | 469 | 0 | 364 | CAEA01000019 | 518 | 0 | 467 | 3 | 142,205,17, | 105,247,452, | 0,244,450, |
| 585 | 144 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | + | JW192848 | 3424 | 1415 | 1581 | CAEA01000071 | 2572 | 2268 | 2434 | 1 | 166, | 1415, | 2268, |
| 585 | 258 | 5 | 28 | 0 | 0 | 0 | 1 | 1 | - | JW192927 | 1191 | 900 | 1191 | CAEA01000084 | 507 | 47 | 339 | 2 | 260,31, | 0,260, | 47,308, |
| 585 | 68 | 1 | 32 | 0 | 0 | 0 | 0 | 0 | + | JW176862 | 464 | 0 | 101 | CAEA01000098 | 1290 | 896 | 997 | 1 | 101, | 0, | 896, |
| 585 | 231 | 13 | 40 | 0 | 0 | 0 | 0 | 0 | - | JW182155 | 861 | 479 | 763 | CAEA01000102 | 291 | 3 | 287 | 1 | 284, | 98, | 3, |
| 585 | 281 | 0 | 19 | 0 | 0 | 0 | 0 | 0 | - | JW200245 | 379 | 0 | 300 | CAEA01000152 | 1212 | 877 | 1177 | 1 | 300, | 79, | 877, |
| 585 | 252 | 0 | 0 | 0 | 0 | 0 | 1 | 126 | - | JW179182 | 566 | 135 | 387 | CAEA01000167 | 378 | 0 | 378 | 2 | 22,230, | 179,201, | 0,148, |
| 585 | 164 | 1 | 24 | 0 | 0 | 0 | 0 | 0 | + | JW179722 | 1289 | 249 | 438 | CAEA01000172 | 505 | 209 | 398 | 1 | 189, | 249, | 209, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server