Name | Last modified | Size | Description | |
---|---|---|---|---|
Parent Directory | - | |||
dictionary.sql | 07-Nov-2008 03:37 | 118K | ||
doc/ | 13-Dec-2008 06:07 | - | ||
schema.sql | 12-Dec-2009 08:09 | 81K | ||
dump.sql | 20-Oct-2014 12:45 | 8.4K | ||
assignchemicashift.csv.gz | 20-Oct-2014 12:45 | 207K | ||
biolfunclist.csv.gz | 20-Oct-2014 12:45 | 226 | ||
biolfuncmolsystem.csv.gz | 20-Oct-2014 12:45 | 296 | ||
biolmoldblinks.csv.gz | 20-Oct-2014 12:45 | 186 | ||
biopolymresidmlabe.csv.gz | 20-Oct-2014 12:45 | 9.4K | ||
biopolymresidsynon.csv.gz | 20-Oct-2014 12:45 | 431 | ||
chemicalshifts.csv.gz | 20-Oct-2014 12:45 | 61M | ||
chemshiftambglinks.csv.gz | 20-Oct-2014 12:45 | 21K | ||
chemshiftexptlist.csv.gz | 20-Oct-2014 12:45 | 159K | ||
chemshiftrefdescr.csv.gz | 20-Oct-2014 12:45 | 74K | ||
chemshiftreferences.csv.gz | 20-Oct-2014 12:45 | 150K | ||
chemshiftsamplist.csv.gz | 20-Oct-2014 12:45 | 96K | ||
chemshiftsoftlist.csv.gz | 20-Oct-2014 12:45 | 19K | ||
citation.csv.gz | 20-Oct-2014 12:45 | 126K | ||
citauthors.csv.gz | 20-Oct-2014 12:45 | 24K | ||
citkeyword.csv.gz | 20-Oct-2014 12:45 | 4.0K | ||
contactperson.csv.gz | 20-Oct-2014 12:45 | 237 | ||
contactpersoncat.csv.gz | 20-Oct-2014 12:45 | 76 | ||
crosslinkbondlist.csv.gz | 20-Oct-2014 12:45 | 74K | ||
crosslinkbonds.csv.gz | 20-Oct-2014 12:45 | 11K | ||
deletedatomlist.csv.gz | 20-Oct-2014 12:45 | 8.0K | ||
entryauthors.csv.gz | 20-Oct-2014 12:45 | 452K | ||
entrycitation.csv.gz | 20-Oct-2014 12:45 | 580K | ||
entrycitauthors.csv.gz | 20-Oct-2014 12:45 | 545K | ||
entryciteditors.csv.gz | 20-Oct-2014 12:45 | 190 | ||
entrycitkeywords.csv.gz | 20-Oct-2014 12:45 | 119K | ||
entryinfodatacat.csv.gz | 20-Oct-2014 12:45 | 66K | ||
entryinfodatatype.csv.gz | 20-Oct-2014 12:45 | 146K | ||
entryinforelbmrbid.csv.gz | 20-Oct-2014 12:45 | 89K | ||
entryinforevisions.csv.gz | 20-Oct-2014 12:45 | 105K | ||
entryinformation.csv.gz | 20-Oct-2014 12:45 | 464K | ||
experimentalsource.csv.gz | 20-Oct-2014 12:45 | 196K | ||
exptsourcesfc.csv.gz | 20-Oct-2014 12:45 | 55K | ||
jconstantdescr.csv.gz | 20-Oct-2014 12:45 | 12K | ||
jconstantexptlist.csv.gz | 20-Oct-2014 12:45 | 2.3K | ||
jconstants.csv.gz | 20-Oct-2014 12:45 | 318K | ||
jconstantsamplist.csv.gz | 20-Oct-2014 12:45 | 3.2K | ||
jconstantsoftlist.csv.gz | 20-Oct-2014 12:45 | 514 | ||
ligand.csv.gz | 20-Oct-2014 12:45 | 37K | ||
ligandatomlist.csv.gz | 20-Oct-2014 12:45 | 147K | ||
ligandbondlist.csv.gz | 20-Oct-2014 12:45 | 161K | ||
ligandsynonym.csv.gz | 20-Oct-2014 12:45 | 1.2K | ||
magequivsystemcomp.csv.gz | 20-Oct-2014 12:45 | 8.7K | ||
molpuritydescr.csv.gz | 20-Oct-2014 12:45 | 541 | ||
molsystemcomp.csv.gz | 20-Oct-2014 12:45 | 198K | ||
naturalsource.csv.gz | 20-Oct-2014 12:45 | 211K | ||
naturalsourcesfc.csv.gz | 20-Oct-2014 12:45 | 55K | ||
nmrexperimental.csv.gz | 20-Oct-2014 12:45 | 567K | ||
nmrexptcit.csv.gz | 20-Oct-2014 12:45 | 82 | ||
nmrspecacqpar.csv.gz | 20-Oct-2014 12:45 | 1.1K | ||
nmrspecprocpar.csv.gz | 20-Oct-2014 12:45 | 460 | ||
nmrspectrometer.csv.gz | 20-Oct-2014 12:45 | 119K | ||
polymerbiofunc.csv.gz | 20-Oct-2014 12:45 | 34K | ||
polymerdblinks.csv.gz | 20-Oct-2014 12:45 | 1.7M | ||
polymerdescr.csv.gz | 20-Oct-2014 12:45 | 852K | ||
polymersyn.csv.gz | 20-Oct-2014 12:45 | 1.0K | ||
residueatomlist.csv.gz | 20-Oct-2014 12:45 | 110K | ||
residuebondlist.csv.gz | 20-Oct-2014 12:45 | 110K | ||
residuedescr.csv.gz | 20-Oct-2014 12:45 | 32K | ||
residuesequence.csv.gz | 20-Oct-2014 12:45 | 5.0M | ||
sampleconddescr.csv.gz | 20-Oct-2014 12:45 | 91K | ||
sampleconditions.csv.gz | 20-Oct-2014 12:45 | 183K | ||
depsindb.csv.gz | 20-Oct-2014 12:45 | 27K | ||
samplecontents.csv.gz | 20-Oct-2014 12:45 | 451K | ||
sampledescr.csv.gz | 20-Oct-2014 12:45 | 160K | ||
samplepuritydescr.csv.gz | 20-Oct-2014 12:45 | 786 | ||
softplatformvendor.csv.gz | 20-Oct-2014 12:45 | 504 | ||
software.csv.gz | 20-Oct-2014 12:45 | 225K | ||
softwaretask.csv.gz | 20-Oct-2014 12:45 | 192K | ||
softwarevendor.csv.gz | 20-Oct-2014 12:45 | 168K | ||
system.csv.gz | 20-Oct-2014 12:45 | 224K | ||
systembiolfunc.csv.gz | 20-Oct-2014 12:45 | 38K | ||
systemdblinks.csv.gz | 20-Oct-2014 12:45 | 43K | ||
************************************************************* * * * 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