SMPDB Banner

TextQuery

Text search supports boolean logic (AND, OR, NOT operations). To match a string exactly, place quotes around your search term (for example "acetic acid" will only match the acetic followed by acid, it will not match acetic or acid alone). In addition, text search supports parenthetical groupings, and prepended +plus and -minus operators.

Examples:

SMPDB text query also supports a high-level search interface allowing you to narrow your search to specific fields. To use this interface, simply enter the field name followed by a semi-colon and your query term. For example, to search for pathways which involve the metabolite sarcosine you would search for metabolite_names:sarcosine. Currently, only the following fields are searchable using this method:

Field Title/Description
smpdb_id SMPDB ID
name Pathway Name
kegg_id KEGG Pathway Map ID
type Pathway Type
description Pathway Description
drugbank_ids DrugBank IDs
hmdb_ids HMDB IDs
drug_names Drug Names
metabolite_names Metabolite Names

This project is supported by Genome Alberta & Genome Canada, a not-for-profit organization that is leading Canada's national genomics strategy with $600 million in funding from the federal government.