|
|---|
| |
Database: vicPac1 Primary Table: all_est Row Count: 1,339 Data last updated: 2016-04-24
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 | 112 | int(10) unsigned | range | Number of bases that match that aren't repeats |
| misMatches | 1 | 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 | 3 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | EH218995 | varchar(255) | values | Query sequence name |
| qSize | 146 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 113 | int(10) unsigned | range | Alignment end position in query |
| tName | scaffold_1745 | varchar(255) | values | Target sequence name |
| tSize | 332506 | int(10) unsigned | range | Target sequence size |
| tStart | 74433 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 74549 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 2 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 80,33, | longblob | | Size of each block |
| qStarts | 33,113, | longblob | | Start of each block in query. |
| tStarts | 74433,74516, | 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 | 112 | 1 | 0 | 0 | 0 | 0 | 1 | 3 | - | EH218995 | 146 | 0 | 113 | scaffold_1745 | 332506 | 74433 | 74549 | 2 | 80,33, | 33,113, | 74433,74516, |
| 585 | 518 | 4 | 0 | 0 | 0 | 0 | 5 | 1155 | + | EH219024 | 580 | 21 | 543 | scaffold_18749 | 7426 | 3732 | 5409 | 6 | 55,41,135,99,74,118, | 21,76,117,252,351,425, | 3732,3868,4404,4786,5216,5291, |
| 585 | 638 | 10 | 24 | 0 | 1 | 1 | 2 | 352 | + | EH218999 | 1016 | 320 | 993 | scaffold_190307 | 1179 | 79 | 1103 | 4 | 27,73,131,441, | 320,348,421,552, | 79,106,455,662, |
| 585 | 18 | 3 | 70 | 0 | 1 | 2 | 1 | 8 | - | EH219010 | 113 | 0 | 93 | scaffold_19285 | 7583 | 1048 | 1147 | 2 | 9,82, | 20,31, | 1048,1065, |
| 585 | 25 | 5 | 75 | 0 | 0 | 0 | 1 | 21 | - | EH219010 | 113 | 3 | 108 | scaffold_206 | 1058667 | 92355 | 92481 | 2 | 11,94, | 5,16, | 92355,92387, |
| 585 | 67 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | - | EH218980 | 188 | 90 | 158 | scaffold_218739 | 1062 | 121 | 189 | 1 | 68, | 30, | 121, |
| 586 | 520 | 2 | 0 | 0 | 0 | 0 | 4 | 1156 | + | EH219024 | 580 | 21 | 543 | scaffold_2340 | 197646 | 190019 | 191697 | 5 | 55,41,135,99,192, | 21,76,117,252,351, | 190019,190155,190691,191075,191505, |
| 585 | 89 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | + | EH218999 | 1016 | 231 | 321 | scaffold_24031 | 9732 | 5252 | 5342 | 1 | 90, | 231, | 5252, |
| 586 | 65 | 4 | 0 | 0 | 0 | 0 | 1 | 2 | - | EH219014 | 95 | 7 | 76 | scaffold_2413 | 373744 | 242339 | 242410 | 2 | 5,64, | 19,24, | 242339,242346, |
| 585 | 166 | 10 | 0 | 0 | 2 | 12 | 1 | 3 | - | EH218998 | 219 | 10 | 198 | scaffold_266619 | 849 | 489 | 668 | 3 | 128,10,38, | 21,151,171, | 489,617,630, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server