Index of /ftp/pub/bmrb/relational_tables/nmr-star2.1

[ICO]NameLast modifiedSizeDescription

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