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

[ICO]NameLast modifiedSizeDescription

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