T3DB Logo

Text Search

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:

T3DB text query also supports a high-level search interface allowing you to narrow your search to specific compound fields. To use this interface, simply enter the field name followed by a semi-colon and your query term. For example, to search for compounds where the brand name mixtures contains "dextromethorphan" you would search for mixtures:dextromethorphan. You can also combine different fields in a given search, for example, to find all compounds where the brand mixtures contain both "dextromethorphan" and "doxylamine" you would search for
mixtures:dextromethorphan AND mixtures:doxylamine. Currently, only the following compound fields are searchable using this method:

Field Title/Description
appearance Appearance
cas CAS Number
common_name Name
compoundtype Compound Type
description Description
mechanism_of_action Mechanism of Action
pubchem PubChem Compound ID
synonyms Synonyms
title T3DB ID

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.