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: