Relational Database Tables exported in CSV format

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:

Metabolomics database

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

Directory of CSV files: