|
|---|
| |
Database: gadMor1 Primary Table: intronEst Row Count: 97,126 Data last updated: 2016-03-30
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 | 208 | 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 | 1 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 487 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | CO541553 | varchar(255) | values | Query sequence name |
| qSize | 713 | int(10) unsigned | range | Query sequence size |
| qStart | 1 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 209 | int(10) unsigned | range | Alignment end position in query |
| tName | CAEA01005662 | varchar(255) | values | Target sequence name |
| tSize | 2384 | int(10) unsigned | range | Target sequence size |
| tStart | 158 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 853 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 2 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 164,44, | longblob | | Size of each block |
| qStarts | 504,668, | longblob | | Start of each block in query. |
| tStarts | 158,809, | 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 | 208 | 0 | 0 | 0 | 0 | 0 | 1 | 487 | - | CO541553 | 713 | 1 | 209 | CAEA01005662 | 2384 | 158 | 853 | 2 | 164,44, | 504,668, | 158,809, |
| 585 | 190 | 6 | 42 | 0 | 0 | 0 | 1 | 831 | + | CO541767 | 841 | 0 | 238 | CAEA01007478 | 1308 | 159 | 1228 | 2 | 48,190, | 0,48, | 159,1038, |
| 585 | 339 | 0 | 27 | 0 | 0 | 0 | 3 | 580 | - | CO542061 | 841 | 1 | 367 | CAEA01008787 | 1401 | 91 | 1037 | 4 | 68,94,76,128, | 474,542,636,712, | 91,531,741,909, |
| 585 | 114 | 2 | 0 | 0 | 0 | 0 | 2 | 239 | + | CO541629 | 728 | 499 | 615 | CAEA01014821 | 639 | 194 | 549 | 3 | 40,41,35, | 499,539,580, | 194,335,514, |
| 585 | 187 | 0 | 0 | 0 | 0 | 0 | 1 | 490 | - | CO541569 | 612 | 1 | 188 | CAEA01015974 | 1052 | 215 | 892 | 2 | 134,53, | 424,558, | 215,839, |
| 585 | 357 | 1 | 7 | 0 | 0 | 0 | 1 | 127 | + | CO541631 | 746 | 1 | 366 | CAEA01020446 | 1174 | 522 | 1014 | 2 | 114,251, | 1,115, | 522,763, |
| 585 | 355 | 1 | 7 | 0 | 0 | 0 | 1 | 127 | + | CO542355 | 772 | 1 | 364 | CAEA01020446 | 1174 | 524 | 1014 | 2 | 112,251, | 1,113, | 524,763, |
| 585 | 477 | 1 | 27 | 5 | 0 | 0 | 1 | 79 | - | CO541465 | 650 | 70 | 580 | CAEA01046317 | 654 | 0 | 589 | 2 | 448,62, | 70,518, | 0,527, |
| 585 | 473 | 2 | 28 | 0 | 0 | 0 | 1 | 79 | - | CO542014 | 854 | 73 | 576 | CAEA01046317 | 654 | 7 | 589 | 2 | 441,62, | 278,719, | 7,527, |
| 585 | 167 | 1 | 9 | 0 | 0 | 0 | 1 | 289 | - | CO541496 | 592 | 222 | 399 | CAEA01052283 | 715 | 169 | 635 | 2 | 82,95, | 193,275, | 169,540, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server