MIQL 2.5
The Molecular Interactions Query Language (MIQL) defines a way to allow more powerful and flexible queries by using a specific syntax when doing searches. If we have a common way to access the data (PSICQUIC), we need a common way to write the search queries. In most cases, searches are done for a specific identifier or group of identifiers. However, the service is not limited to these. For instance, there are ways to search for specific organisms, interaction detection methods or publication identifiers. The MIQL defines how these kind of queries can be done.
MIQL is a consensus between the different databases, so you should be able to use the same query across different repositories. It is based on the PSIMITAB 2.5 format and allows to search for data in specific columns, by using the fields explained in the next section.
The MIQL syntax is based on Lucene's syntax. A query is broken into terms and operators:
- Terms: single words or phrases (group of words surrounded by quotes). E.g.
brca2or"pull down" - Fields: used to search in a specific column. See the next section for the specific field names. E.g.
species:human - Term modifiers: wildcard searches, fuzzy searches, proximity and range searches. E.g.
brc* - Operands: OR (or space), AND, NOT, +, -. E.g.
brca2 AND rpa1orbrca2 NOT mouseor+brca2 –mouse - Grouping and field grouping:
brca2 AND ( mouse "in vitro" )
IMPORTANT: When using parenthesis in your queries, please add a space after and opening parenthesis and before a closing one, since some PSICQUIC implementations need it for correct parenthesis recognition.
Fields
The following table shows the available standard fields that can be used in PSICQUIC searches:
| Field Name | Searches on | MITAB 2.5 Columns | Example |
|---|---|---|---|
| idA | Identifier A | 1 | idA:P74565 |
| idB | Identifier B | 2 | idB:P74565 |
| id | Identifiers (A or B) | 1..4 | id:P74565 |
| alias | Aliases (A or B) | 5, 6 | alias:( KHDRBS1 OR HCK ) |
| identifier | Identifiers (A or B) or Aliases (A or B) | 1..6 | identifier:P74565 |
| pubauth | Publication 1st author(s) | 8 | pubauth:scott |
| pubid | Publication Identifier(s) | 9 | pubid:( 10837477 OR 12029088 ) |
| taxidA | Tax ID interactor A: be it the tax ID or the species name | 10 | taxidA:mouse |
| taxidB | Tax ID interactor B: be it the tax ID or species name | 11 | taxidB:9606 |
| species | Species. Tax ID A and Tax ID B | 10, 11 | species:human |
| type | Interaction type(s) | 12 | type:"physical association" |
| detmethod | Interaction Detection method(s) | 7 | detmethod:"two hybrid*" |
| source | Interaction source(s) | 13 | psi-mi:"MI:0469"(intact) |
| interaction_id | Interaction identifier(s) | 14 | interaction_id:EBI-761050 |