![[ICO]](/icons/blank.gif){kind=icon}
![[DIR]](/icons/back.gif){kind=icon}
![[ ]](/icons/compressed.gif){kind=icon}
![[ ]](/icons/unknown.gif){kind=icon}
![[DIR]](/icons/folder.gif){kind=icon}
| Name | Last modified | Size | Description |
|---|---|---|---|---|
| Parent Directory | - | ||
| systemdblinks.csv.gz | 20-Oct-2014 12:45 | 43K | |
| systembiolfunc.csv.gz | 20-Oct-2014 12:45 | 38K | |
| system.csv.gz | 20-Oct-2014 12:45 | 224K | |
| softwarevendor.csv.gz | 20-Oct-2014 12:45 | 168K | |
| softwaretask.csv.gz | 20-Oct-2014 12:45 | 192K | |
| software.csv.gz | 20-Oct-2014 12:45 | 225K | |
| softplatformvendor.csv.gz | 20-Oct-2014 12:45 | 504 | |
| schema.sql | 12-Dec-2009 08:09 | 81K | |
| samplepuritydescr.csv.gz | 20-Oct-2014 12:45 | 786 | |
| sampledescr.csv.gz | 20-Oct-2014 12:45 | 160K | |
| samplecontents.csv.gz | 20-Oct-2014 12:45 | 451K | |
| sampleconditions.csv.gz | 20-Oct-2014 12:45 | 183K | |
| sampleconddescr.csv.gz | 20-Oct-2014 12:45 | 91K | |
| residuesequence.csv.gz | 20-Oct-2014 12:45 | 5.0M | |
| residuedescr.csv.gz | 20-Oct-2014 12:45 | 32K | |
| residuebondlist.csv.gz | 20-Oct-2014 12:45 | 110K | |
| residueatomlist.csv.gz | 20-Oct-2014 12:45 | 110K | |
| polymersyn.csv.gz | 20-Oct-2014 12:45 | 1.0K | |
| polymerdescr.csv.gz | 20-Oct-2014 12:45 | 852K | |
| polymerdblinks.csv.gz | 20-Oct-2014 12:45 | 1.7M | |
| polymerbiofunc.csv.gz | 20-Oct-2014 12:45 | 34K | |
| nmrspectrometer.csv.gz | 20-Oct-2014 12:45 | 119K | |
| nmrspecprocpar.csv.gz | 20-Oct-2014 12:45 | 460 | |
| nmrspecacqpar.csv.gz | 20-Oct-2014 12:45 | 1.1K | |
| nmrexptcit.csv.gz | 20-Oct-2014 12:45 | 82 | |
| nmrexperimental.csv.gz | 20-Oct-2014 12:45 | 567K | |
| naturalsourcesfc.csv.gz | 20-Oct-2014 12:45 | 55K | |
| naturalsource.csv.gz | 20-Oct-2014 12:45 | 211K | |
| molsystemcomp.csv.gz | 20-Oct-2014 12:45 | 198K | |
| molpuritydescr.csv.gz | 20-Oct-2014 12:45 | 541 | |
| magequivsystemcomp.csv.gz | 20-Oct-2014 12:45 | 8.7K | |
| ligandsynonym.csv.gz | 20-Oct-2014 12:45 | 1.2K | |
| ligandbondlist.csv.gz | 20-Oct-2014 12:45 | 161K | |
| ligandatomlist.csv.gz | 20-Oct-2014 12:45 | 147K | |
| ligand.csv.gz | 20-Oct-2014 12:45 | 37K | |
| jconstantsoftlist.csv.gz | 20-Oct-2014 12:45 | 514 | |
| jconstantsamplist.csv.gz | 20-Oct-2014 12:45 | 3.2K | |
| jconstants.csv.gz | 20-Oct-2014 12:45 | 318K | |
| jconstantexptlist.csv.gz | 20-Oct-2014 12:45 | 2.3K | |
| jconstantdescr.csv.gz | 20-Oct-2014 12:45 | 12K | |
| exptsourcesfc.csv.gz | 20-Oct-2014 12:45 | 55K | |
| experimentalsource.csv.gz | 20-Oct-2014 12:45 | 196K | |
| entryinformation.csv.gz | 20-Oct-2014 12:45 | 464K | |
| entryinforevisions.csv.gz | 20-Oct-2014 12:45 | 105K | |
| entryinforelbmrbid.csv.gz | 20-Oct-2014 12:45 | 89K | |
| entryinfodatatype.csv.gz | 20-Oct-2014 12:45 | 146K | |
| entryinfodatacat.csv.gz | 20-Oct-2014 12:45 | 66K | |
| entrycitkeywords.csv.gz | 20-Oct-2014 12:45 | 119K | |
| entryciteditors.csv.gz | 20-Oct-2014 12:45 | 190 | |
| entrycitauthors.csv.gz | 20-Oct-2014 12:45 | 545K | |
| entrycitation.csv.gz | 20-Oct-2014 12:45 | 580K | |
| entryauthors.csv.gz | 20-Oct-2014 12:45 | 452K | |
| dump.sql | 20-Oct-2014 12:45 | 8.4K | |
| doc/ | 13-Dec-2008 06:07 | - | |
| dictionary.sql | 07-Nov-2008 03:37 | 118K | |
| depsindb.csv.gz | 20-Oct-2014 12:45 | 27K | |
| deletedatomlist.csv.gz | 20-Oct-2014 12:45 | 8.0K | |
| crosslinkbonds.csv.gz | 20-Oct-2014 12:45 | 11K | |
| crosslinkbondlist.csv.gz | 20-Oct-2014 12:45 | 74K | |
| contactpersoncat.csv.gz | 20-Oct-2014 12:45 | 76 | |
| contactperson.csv.gz | 20-Oct-2014 12:45 | 237 | |
| citkeyword.csv.gz | 20-Oct-2014 12:45 | 4.0K | |
| citauthors.csv.gz | 20-Oct-2014 12:45 | 24K | |
| citation.csv.gz | 20-Oct-2014 12:45 | 126K | |
| chemshiftsoftlist.csv.gz | 20-Oct-2014 12:45 | 19K | |
| chemshiftsamplist.csv.gz | 20-Oct-2014 12:45 | 96K | |
| chemshiftreferences.csv.gz | 20-Oct-2014 12:45 | 150K | |
| chemshiftrefdescr.csv.gz | 20-Oct-2014 12:45 | 74K | |
| chemshiftexptlist.csv.gz | 20-Oct-2014 12:45 | 159K | |
| chemshiftambglinks.csv.gz | 20-Oct-2014 12:45 | 21K | |
| chemicalshifts.csv.gz | 20-Oct-2014 12:45 | 61M | |
| biopolymresidsynon.csv.gz | 20-Oct-2014 12:45 | 431 | |
| biopolymresidmlabe.csv.gz | 20-Oct-2014 12:45 | 9.4K | |
| biolmoldblinks.csv.gz | 20-Oct-2014 12:45 | 186 | |
| biolfuncmolsystem.csv.gz | 20-Oct-2014 12:45 | 296 | |
| biolfunclist.csv.gz | 20-Oct-2014 12:45 | 226 | |
| assignchemicashift.csv.gz | 20-Oct-2014 12:45 | 207K | |
*************************************************************
* *
* NOTE: NMR-STAR 2.1 database is obsolete and unmaintained. *
* Use NMR-STAR 3.1 database files in the nmr-star3.1 *
* directory instead. *
* *
*************************************************************
Files in this directory:
schema.psql : PostgreSQL database schema
(generated with "pg_dump -s -x -O")
dictionary.sql : NMR-STAR 2.1 dictionary table, as series of SQL INSERT statements.
*.csv.gz : gzipped PostgreSQL table dumps in CSV format
(generated with "psql -c \copy $TABLE to $TABLE.csv csv")
dump.sql : psql script for dumping tables into .csv files
doc/ : documentation describing dictionary table and layout of
data tables
Loading the database into PostgreSQL:
-------------------------------------
create a database (e.g. BMRB)
run schema.psql script (psql -d BMRB -f schema.psql)
load data from CSV files: for each $TABLE.csv.gz,
gunzip $TABLE.csv.gz
psql -d BMRB -c \copy $NAME from $TABLE.csv csv
Opening CSV files in spreadsheet programs
-----------------------------------------
Some of these files contain multi-line fields, not all spreadsheet
programs can handle those.
OpenOffice Calc will import these files correctly, Microsoft Excel will not.
--
Thu 06 Nov 2008 12:30:45 PM CST