Here we highlight general properties of table result views in GNPS.

Filtering Tables

Filtering Rows for Substring

If you want to find rows that include a substring that you are interested in, simply enter the value in the box and hit enter. For example, to find all the identifications that include the substring "mycin": link.

Filtering Rows with a single column AND operator

If you want to filter a table in GNPS on a single column and the value in a given column must contain ALL of the substrings you define, you can use the "&&" between substrings you want to search. For example, for a molecular network, if you want to find all the nodes that are from G1 AND G2, you can use the following syntax: G1&&G2. See this link for an example.

If you want to use negation, e.g. G1 AND not G2, you can use the carrot ^ like in this example G1&&^G2.

Filtering Rows with a single column OR operator

If you want to filter a table in GNPS on a single column and the value in a given column must contain at least one of the substrings you define, you can use the "||" between substrings you want to search. For example, for a molecular network, if you want to find all the nodes that are from G1 AND G2, you can use the following syntax: G1||G2. See this link for an example.

Downloading Table Results

In order to download the data for a result table in GNPS that you are currently viewing, click the download button: