Supported search terms for finding samples

Categorical features

Our search is 'contains' search, meaning the term you enter can be at the beginning, end or in the middle of a matched term. Our search is case-independent. An example is


will match 'Stage IIIA' and 'Stage IIA'. To specify a specific string, use quotes

"Stage IIA"

Numerical and Continuous features

You can specify a certain column and mathematical expression such as


which will find all values greater than 2 in the first column. We support the following operators

  • = (equal)

  • >= (less than or equal)

  • >= (greater than or equal)

  • < (less than)

  • > (greater than)

  • != (not equal)

Mutation data

You can search any annotation on a mutation, such as the functional impact, protein position, or gene name itself

To find all samples with mutations with the protein change, enter:


To find all samples where the functional impact has the text 'frame' or 'nonsense' in it:

frame OR nonsense

To find all samples that have a mutation, search the gene annotation:


To find all samples that do not have a mutation, use the negation of the gene annotation:


No data or 'null'

To find all samples that do not have data in one or more columns, use:


and choose 'Remove samples'. To find all samples that do not have data for just one column, use:


Sample IDs

Enter a sample ID to find a sample of interest. An example:


If you are searching for multiple sample IDs, you will need to separate each by an 'OR'. You can copy and paste a list of sample IDs into the search bar as long as they are separated by a space, tab, or return (new line).


Use 'alt-click' to freeze for copying a sample ID from the tooltip.

Search a specific column

To make it easy to search a specific column, we use shorthand to annotate the first column as 'A:', the second as 'B:', etc. An example is


This will search ONLY the first column for the word 'YES'. Note that we will retain your original search if you move the columns around.

Boolean operators: OR, AND, and !=

You can enter multiple search terms and we will match all of them with an implicit 'AND'. We also support 'OR'.

Use parentheses to group search terms. For example:

"Stage II" (B:Negative OR C:Negative)

will search for samples that match 'Stage II' in any column and are 'Negative' for either the second or third column.

You can also use '!=' to negate a term such as:


which will match all samples that have data across all columns.

Last updated