Macromolecular database

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.sql
        

Then, to import the tables: start psql program and run

        \copy "TABLE_NAME" from TABLE_NAME.csv csv header
        

for each TABLE_NAME you are interested in.

Directory of the files:

• http://www.bmrb.wisc.edu/ftp/pub/bmrb/relational_tables/nmr-star3.1/
• or by FTP: ftp://ftp.bmrb.wisc.edu/pub/bmrb/relational_tables/nmr-star3.1/

Metabolomics database

The metabolomics database is structured exactly like the macromolecular database. See the Macromolecular database section above for details.

Directory of CSV files:

• http://www.bmrb.wisc.edu/ftp/pub/bmrb/relational_tables/metabolomics/
• or by FTP: ftp://ftp.bmrb.wisc.edu/pub/bmrb/relational_tables/metabolomics/

NMR-STAR 2.1 database

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:

• http://www.bmrb.wisc.edu/ftp/pub/bmrb/relational_tables/nmr-star2.1/
• or by FTP: ftp://ftp.bmrb.wisc.edu/pub/bmrb/relational_tables/nmr-star2.1/