|
|
Database: petMar2 Primary Table: all_est Row Count: 105,529   Data last updated: 2012-10-17
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 587 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
matches | 231 | 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 | 5 | int(10) unsigned | range | Number of 'N' bases |
qNumInsert | 3 | int(10) unsigned | range | Number of inserts in query |
qBaseInsert | 13 | int(10) unsigned | range | Number of bases inserted in query |
tNumInsert | 4 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 5307 | int(10) unsigned | range | Number of bases inserted in target |
strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | AA618656 | varchar(255) | values | Query sequence name |
qSize | 360 | int(10) unsigned | range | Query sequence size |
qStart | 65 | int(10) unsigned | range | Alignment start position in query |
qEnd | 315 | int(10) unsigned | range | Alignment end position in query |
tName | GL476425 | varchar(255) | values | Target sequence name |
tSize | 407004 | int(10) unsigned | range | Target sequence size |
tStart | 386771 | int(10) unsigned | range | Alignment start position in target |
tEnd | 392315 | int(10) unsigned | range | Alignment end position in target |
blockCount | 6 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 7,83,80,25,5,37, | longblob | | Size of each block |
qStarts | 65,73,156,236,271,278, | longblob | | Start of each block in query. |
tStarts | 386771,386780,388940,392240... | 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 |
---|
587 | 231 | 1 | 0 | 5 | 3 | 13 | 4 | 5307 | + | AA618656 | 360 | 65 | 315 | GL476425 | 407004 | 386771 | 392315 | 6 | 7,83,80,25,5,37, | 65,73,156,236,271,278, | 386771,386780,388940,392240,392273,392278, |
585 | 216 | 0 | 18 | 4 | 3 | 11 | 7 | 504 | + | AA618648 | 285 | 4 | 253 | GL476492 | 852800 | 34290 | 35032 | 8 | 14,8,8,5,20,63,109,11, | 4,18,26,34,40,61,124,242, | 34290,34305,34314,34323,34330,34352,34904,35021, |
585 | 163 | 0 | 0 | 1 | 1 | 1 | 3 | 120 | + | AA618647 | 251 | 45 | 210 | GL476492 | 852800 | 70338 | 70622 | 5 | 7,8,66,50,33, | 45,52,60,126,177, | 70338,70346,70355,70539,70589, |
585 | 163 | 0 | 0 | 1 | 1 | 1 | 3 | 119 | + | AA618647 | 251 | 45 | 210 | GL476492 | 852800 | 81042 | 81325 | 5 | 7,8,66,50,33, | 45,52,60,126,177, | 81042,81050,81059,81242,81292, |
586 | 124 | 1 | 0 | 2 | 0 | 0 | 4 | 176 | + | AA618645 | 228 | 83 | 210 | GL476492 | 852800 | 149380 | 149683 | 5 | 13,9,11,68,26, | 83,96,105,116,184, | 149380,149395,149405,149417,149657, |
585 | 265 | 5 | 20 | 7 | 3 | 3 | 2 | 2 | - | AA618652 | 346 | 2 | 302 | GL477379 | 80794 | 17383 | 17682 | 6 | 11,78,35,150,17,6, | 44,56,135,171,321,338, | 17383,17394,17472,17507,17658,17676, |
585 | 206 | 8 | 69 | 12 | 6 | 7 | 2 | 2 | - | AA618653 | 344 | 7 | 309 | GL477407 | 99292 | 71672 | 71969 | 8 | 8,7,50,130,52,14,19,15, | 35,44,53,104,235,288,303,322, | 71672,71680,71688,71738,71868,71920,71934,71954, |
586 | 286 | 1 | 44 | 0 | 6 | 7 | 0 | 0 | + | AA618651 | 359 | 0 | 338 | GL477467 | 234004 | 196107 | 196438 | 7 | 113,138,43,21,4,4,8, | 0,114,253,297,319,325,330, | 196107,196220,196358,196401,196422,196426,196430, |
585 | 245 | 1 | 0 | 3 | 4 | 5 | 5 | 2285 | - | AA618649 | 291 | 0 | 254 | GL478327 | 50856 | 30585 | 33119 | 9 | 5,24,42,100,37,13,11,7,10, | 37,44,69,112,212,250,263,274,281, | 30585,30590,30614,30656,33036,33075,33089,33101,33109, |
585 | 270 | 2 | 0 | 3 | 0 | 0 | 2 | 2 | - | AA618655 | 317 | 9 | 284 | GL480037 | 29499 | 8607 | 8884 | 3 | 252,18,5, | 33,285,303, | 8607,8860,8879, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|