|
|---|
| |
Database: rheMac2 Primary Table: all_est Row Count: 68,329 Data last updated: 2012-11-03
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory
| field | example | SQL type | info | description |
|---|
| bin | 1106 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 301 | 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 | 3 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 13566 | int(10) unsigned | range | Number of bases inserted in target |
| strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | AB471888 | varchar(255) | values | Query sequence name |
| qSize | 301 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 301 | int(10) unsigned | range | Alignment end position in query |
| tName | chr1 | varchar(255) | values | Target sequence name |
| tSize | 228252215 | int(10) unsigned | range | Target sequence size |
| tStart | 68393641 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 68407508 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 4 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 46,106,76,73, | longblob | | Size of each block |
| qStarts | 0,46,152,228, | longblob | | Start of each block in query. |
| tStarts | 68393641,68395012,68396531,... | 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 |
|---|
| 1106 | 301 | 0 | 0 | 0 | 0 | 0 | 3 | 13566 | + | AB471888 | 301 | 0 | 301 | chr1 | 228252215 | 68393641 | 68407508 | 4 | 46,106,76,73, | 0,46,152,228, | 68393641,68395012,68396531,68407435, |
| 1106 | 301 | 1 | 92 | 0 | 0 | 0 | 4 | 13473 | + | AB471889 | 394 | 0 | 394 | chr1 | 228252215 | 68393641 | 68407508 | 5 | 46,106,76,93,73, | 0,46,152,228,321, | 68393641,68395012,68396531,68400326,68407435, |
| 1426 | 219 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | - | AF159450 | 222 | 0 | 222 | chr1 | 228252215 | 110333161 | 110333383 | 1 | 222, | 0, | 110333161, |
| 684 | 132 | 1 | 27 | 0 | 0 | 0 | 0 | 0 | + | AF075126 | 165 | 0 | 160 | chr11 | 134511895 | 12996696 | 12996856 | 1 | 160, | 0, | 12996696, |
| 781 | 257 | 1 | 21 | 0 | 0 | 0 | 0 | 0 | + | AF139027 | 279 | 0 | 279 | chr12 | 106505843 | 25756298 | 25756577 | 1 | 279, | 0, | 25756298, |
| 986 | 253 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | + | AF148885 | 253 | 0 | 253 | chr12 | 106505843 | 52620059 | 52620312 | 1 | 253, | 0, | 52620059, |
| 986 | 380 | 2 | 0 | 0 | 0 | 0 | 2 | 180 | - | AF140287 | 382 | 0 | 382 | chr12 | 106505843 | 52653030 | 52653592 | 3 | 248,127,7, | 0,248,375, | 52653030,52653282,52653585, |
| 1255 | 481 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | + | AF140292 | 483 | 0 | 483 | chr12 | 106505843 | 87855336 | 87855818 | 2 | 334,148, | 0,335, | 87855336,87855670, |
| 1510 | 197 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | - | AF159161 | 198 | 0 | 198 | chr14 | 133002572 | 121322539 | 121322737 | 1 | 198, | 0, | 121322539, |
| 854 | 116 | 4 | 260 | 0 | 0 | 0 | 0 | 0 | + | AF075123 | 386 | 0 | 380 | chr15 | 110119387 | 35347106 | 35347486 | 1 | 380, | 0, | 35347106, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server