The mapping between NMR-STAR 3.1 tags and relational database tables is straightforward: Tag categories correspond to database tables, tags in a category correspond to the columns in that table. See NMR-STAR 3.1 dictionary for more information.
Every database table is exported weekly into a comma-delimited file TABLE_NAME.csv. First line of the file contains column (tag) names, the rest is data. Note that some fields contain multi-line values; not all spreadsheet programs read those correctly.
In addition to CSV files, the file schema.sql is an SQL script for creating the NMR-STAR 3.1 database tables in PostgreSQL (v.8.4 as of the time of this writing).
The database can be recreated locally by downloading the files, creating a PostgreSQL database (e.g. BMRB) and running (in terminal/shell)
psql -d BMRB -f schema.sqlThen, to import the tables: start psql program and run
\copy "TABLE_NAME" from TABLE_NAME.csv csv headerfor each TABLE_NAME you are interested in.
Directory of the files:
The metabolomics database is structured exactly like the macromolecular database. See the Macromolecular database section above for details.
Directory of CSV files:
The macromolecular database in the old NMR-STAR 2.1 format is obsolete and no longer maintained. The files are out of date but still available: