Search BMRB

BMRB database search interface

Please note that this interface is experimental and work in progress. Report any problems and/or suggestions to [email protected].

NMR-STAR dictionary page for the lists and descriptions of categories and tags in NMR-STAR 3.1.

NMR-STAR 3.1 tags map to database tables and columns as _Table.Column, e.g. value of _Entry.ID is stored in ID column in the Entry table. In order to search for an _Entry.ID, select top-level Entry information tab (section), then middle-level Entry information tab (group), then Entry tab at the third level.

For each searchable tag there is a "search term" text box and a "display" checkbox.

Select "display" to include the tag in the search result table. Tags to display do not have to be the same ones you search on, they needn't be in the same tables either. If no tags are selected for display, the result will be the count of matching database rows.

At the moment, all fields are treated as case-insensitive text and are searchable using POSIX regular expressions supported by PostgreSQL database engine (see the link for details).
For example, when looking for Entry.ID (and Entry.ID is selected for display):

Search term	Result
.*	list of all BMRB IDs in the database (entries that have anything in ID tag)
15.*	list of BMRB IDs with "15" anywhere in the ID
^15.$	list of BMRB IDs between 150 and 159
^15[0-3]$	list of BMRB IDs between 150 and 153

All search terms are AND'ed together.

Please note that the limitations of this interface include

no support for numeric comparisons or range searches,
no OR searches,
an SQL JOIN is perfomed on the tables to search in and the tables to display. This may affect the results as JOIN may exclude some rows.
Some regular expressions supported by PostgreSQL don't work, for example, "advanced" REs starting with ***:(?options).

If you have a query you would like to run on the BMRB database that is not supported by this interface, contact [email protected].

Search results are returned either as a webpage (in a separate window/tab) or a comma-delimited file.

BMRB metabolomics archive is maintained as a separate database, you can search in either macromolecule or metabolomics database (but not both at the same time).