Filter Syntax
When browsing curated data within the tables of the IMS, you can choose to filter the results in order to distil large datasets down to manageable sets. For example, when browsing a set of curated Protein-Protein interactions, you might want limit the data to only a single bait and single experimental system. This is accomplished via our smart search filter field shown below:
If you type a simple phrase into the smart search filter field (shown above), and then click on the Filter button to the right of it, you will be performing a search across all fields for the displayed records. This includes all visible fields (such as Bait, Prey, State, etc shown above) and hidden fields (those shown only via popup in the attributes column). This is a very simple search, designed for quick use to limit the number of records displayed.
Example: Typing in: "Rescue" as a basic filtering option would return records with an experimental system of Synthetic Rescue, records with notes containing the word rescue, and even ontology term mappings with rescue in their name such as "partial rescue".
Curated records may also be filtered using a more advanced syntax, allowing you to target your searches to individual columns and data fields. In square brackets in the header of the table, you will see terms such as [#B] or [@ES] or [@ATB] or [#S] to name a few. These are known as search tags and they can be used to limit your search to a field in the data records. Search tags that begin with a hash (#) are direct fields and participant fields while those that begin with an at-symbol (@) are references to attributes. These can be combined in any way you choose to filter your results into a more manageable set. So for instance, an entry of #B:MRM1 would filter the table to show only Baits named MRM1. If you want to search on a term with multiple words, you need to wrap the entire search term in quotes such as "@ES:Synthetic Lethal"
The following are some examples of advanced searches:
- "@ES:Two-Hybrid" "@ES:Affinity Capture-MS"
- #B:CDC42 #P:STE11
- #SUB:NP_011786 @RES-LOC:285
- "@NOTE:double mutant"
- "@TT:Low Throughput" "@ES:Synthetic Lethal"
- #S:error
- @P:viability
- @P:APO:0000106
- @SAINT:0.999
A few filtering options do not pertain to specific fields or are variations on existing fields. For example, the @ATB field will search all attributes in a non-exact based search. This means you will search all @ fields simultaneously such as ontology terms, notes, tags, external database references, etc. By non-exact, it also means it will search for individual words. So for example, if you type in "@ATB:double mutant" it will return records with notes like: "This is a double mutant" and also those with the phrase "This is double the number of mutants". Basically, any term containing both double and mutant. If you use the search term @ATBX it searches the same as mentioned above, but you would need to use an exact term, not individual words. So, using the same example as before, to pull out records with "This is a double mutant" using @ATBX you would need to type in "@ATBX:This is a double mutant".
Similar to above, but only searching the NOTES field, you can use @NOTE and @NOTEX to do both non-exact and exact searching as described above.
The following is a partial list of available search tags. Not all tags are available for all data types, as it varies depending on the data being shown and the information recorded in the database for that record.
- #B - Search participants with the role of bait only
- #P - Search participants with the role of prey only
- #BO - Search organism names for participants with the role of bait only
- #PO - Search organism names for participants with the role of prey only
- #U - Search by history user name
- #S - Search by current record state
- #SUB - Search participants with the role of substrate only
- #ENZ - Search participants with the role of enzyme only
- #O - Search organism names for all participants
- #PS - Search all participants
- #CT - Search all participants with the role of Chemical Target
- #CH - Search all participants with the role of Chemical
- @ES - Search the attribute Experimental System
- @ACTN - Search the attribute Chemical Action
- @ATB - Search all attributes in non-exact fashion
- @ATBX - Search all attributes in exact fashion
- @NOTE - Search notes in non-exact fashion
- @NOTEX - Search all attributes in exact fashion
- @PTM - Search post-translational modification types
- @RES-LOC - Search PTM residue location
- @TT - Search Throughput Tags
- @P - Search Phenotypes
- @CL - Search Cell Lines
- @PW - Search Pathways
- @TS - Search Tissue Specificity
- @CT - Search Cell Type
- @CH - Search Ontology Term Chemicals
- @CLO - Search Cellular Location
- @DS - Search Disease Association
- @DV - Search Development
- @EV - Search Environmental
- @SD - Search Source Database
- @SGA - Search SGA Scores
- @C-SCORE - Search Confidence Scores
- @P-VAL - Search P-Values
- @S-VAL - Search S-Values
- @SAINT - Search SAINT Scores
- @DENO-SCORE - Search Denoised Score
- @COMPASS - Search Compass Scores
- @P-TYPE - Search Phenotype Type
