|
|---|
| |
Database: sacCer3 Primary Table: all_mrna Row Count: 1,664 Data last updated: 2020-05-07
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory
| field | example | SQL type | info | description |
|---|
| bin | 586 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 1736 | int(10) unsigned | range | Number of bases that match that aren't repeats |
| misMatches | 3 | 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 | 0 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 0 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | GQ871187 | varchar(255) | values | Query sequence name |
| qSize | 1739 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 1739 | int(10) unsigned | range | Alignment end position in query |
| tName | chrI | varchar(255) | values | Target sequence name |
| tSize | 230218 | int(10) unsigned | range | Target sequence size |
| tStart | 139677 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 141416 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 1739, | longblob | | Size of each block |
| qStarts | 0, | longblob | | Start of each block in query. |
| tStarts | 139677, | 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 |
|---|
| 586 | 1736 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | - | GQ871187 | 1739 | 0 | 1739 | chrI | 230218 | 139677 | 141416 | 1 | 1739, | 0, | 139677, |
| 586 | 127 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | K00948 | 127 | 0 | 127 | chrI | 230218 | 160274 | 160401 | 1 | 127, | 0, | 160274, |
| 586 | 125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | K00952 | 125 | 0 | 125 | chrI | 230218 | 160276 | 160401 | 1 | 125, | 0, | 160276, |
| 586 | 127 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | K00948 | 127 | 0 | 127 | chrI | 230218 | 165862 | 165989 | 1 | 127, | 0, | 165862, |
| 586 | 125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | K00952 | 125 | 0 | 125 | chrI | 230218 | 165864 | 165989 | 1 | 125, | 0, | 165864, |
| 589 | 72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | + | K00171 | 75 | 0 | 72 | chrIV | 1531933 | 568963 | 569035 | 1 | 72, | 0, | 568963, |
| 589 | 72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | + | M25168 | 75 | 0 | 72 | chrIV | 1531933 | 568963 | 569035 | 1 | 72, | 0, | 568963, |
| 585 | 4185 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | - | M32491 | 4193 | 0 | 4193 | chrII | 813184 | 14065 | 18258 | 1 | 4193, | 0, | 14065, |
| 585 | 259 | 0 | 0 | 0 | 0 | 0 | 1 | 333 | + | EF123124 | 259 | 0 | 259 | chrII | 813184 | 45612 | 46204 | 2 | 32,227, | 0,32, | 45612,45977, |
| 586 | 747 | 0 | 0 | 0 | 0 | 0 | 1 | 384 | + | D17338 | 747 | 0 | 747 | chrII | 813184 | 168414 | 169545 | 2 | 10,737, | 0,10, | 168414,168808, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server