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

[ICO]NameLast modifiedSizeDescription

[DIR]Parent Directory  -
[   ]assignchemicashift.csv.gz13-Sep-2013 22:45 194K
[   ]biolfunclist.csv.gz13-Sep-2013 22:45 226
[   ]biolfuncmolsystem.csv.gz13-Sep-2013 22:45 296
[   ]biolmoldblinks.csv.gz13-Sep-2013 22:45 186
[   ]biopolymresidmlabe.csv.gz13-Sep-2013 22:45 9.8K
[   ]biopolymresidsynon.csv.gz13-Sep-2013 22:45 464
[   ]chemicalshifts.csv.gz13-Sep-2013 22:45 58M
[   ]chemshiftambglinks.csv.gz13-Sep-2013 22:45 21K
[   ]chemshiftexptlist.csv.gz13-Sep-2013 22:45 143K
[   ]chemshiftrefdescr.csv.gz13-Sep-2013 22:45 71K
[   ]chemshiftreferences.csv.gz13-Sep-2013 22:45 142K
[   ]chemshiftsamplist.csv.gz13-Sep-2013 22:45 90K
[   ]chemshiftsoftlist.csv.gz13-Sep-2013 22:45 19K
[   ]citation.csv.gz13-Sep-2013 22:45 124K
[   ]citauthors.csv.gz13-Sep-2013 22:45 23K
[   ]citkeyword.csv.gz13-Sep-2013 22:45 4.0K
[   ]contactperson.csv.gz13-Sep-2013 22:45 237
[   ]contactpersoncat.csv.gz13-Sep-2013 22:45 76
[   ]crosslinkbondlist.csv.gz13-Sep-2013 22:45 75K
[   ]crosslinkbonds.csv.gz13-Sep-2013 22:45 11K
[   ]deletedatomlist.csv.gz13-Sep-2013 22:45 8.1K
[   ]depsindb.csv.gz13-Sep-2013 22:45 26K
[   ]dictionary.sql06-Nov-2008 12:37 118K
[DIR]doc/12-Dec-2008 15:07 -
[   ]dump.sql13-Sep-2013 22:45 8.4K
[   ]entryauthors.csv.gz13-Sep-2013 22:45 429K
[   ]entrycitation.csv.gz13-Sep-2013 22:45 553K
[   ]entrycitauthors.csv.gz13-Sep-2013 22:45 514K
[   ]entryciteditors.csv.gz13-Sep-2013 22:45 98
[   ]entrycitkeywords.csv.gz13-Sep-2013 22:45 115K
[   ]entryinfodatacat.csv.gz13-Sep-2013 22:45 63K
[   ]entryinfodatatype.csv.gz13-Sep-2013 22:45 139K
[   ]entryinforelbmrbid.csv.gz13-Sep-2013 22:45 83K
[   ]entryinforevisions.csv.gz13-Sep-2013 22:45 97K
[   ]entryinformation.csv.gz13-Sep-2013 22:45 439K
[   ]experimentalsource.csv.gz13-Sep-2013 22:45 185K
[   ]exptsourcesfc.csv.gz13-Sep-2013 22:45 53K
[   ]jconstantdescr.csv.gz13-Sep-2013 22:45 12K
[   ]jconstantexptlist.csv.gz13-Sep-2013 22:45 2.2K
[   ]jconstants.csv.gz13-Sep-2013 22:45 314K
[   ]jconstantsamplist.csv.gz13-Sep-2013 22:45 3.2K
[   ]jconstantsoftlist.csv.gz13-Sep-2013 22:45 510
[   ]ligand.csv.gz13-Sep-2013 22:45 35K
[   ]ligandatomlist.csv.gz13-Sep-2013 22:45 136K
[   ]ligandbondlist.csv.gz13-Sep-2013 22:45 149K
[   ]ligandsynonym.csv.gz13-Sep-2013 22:45 1.2K
[   ]magequivsystemcomp.csv.gz13-Sep-2013 22:45 8.6K
[   ]molpuritydescr.csv.gz13-Sep-2013 22:45 541
[   ]molsystemcomp.csv.gz13-Sep-2013 22:45 188K
[   ]naturalsource.csv.gz13-Sep-2013 22:45 199K
[   ]naturalsourcesfc.csv.gz13-Sep-2013 22:45 53K
[   ]nmrexperimental.csv.gz13-Sep-2013 22:45 529K
[   ]nmrexptcit.csv.gz13-Sep-2013 22:45 82
[   ]nmrspecacqpar.csv.gz13-Sep-2013 22:45 1.1K
[   ]nmrspecprocpar.csv.gz13-Sep-2013 22:45 460
[   ]nmrspectrometer.csv.gz13-Sep-2013 22:45 112K
[   ]polymerbiofunc.csv.gz13-Sep-2013 22:45 32K
[   ]polymerdblinks.csv.gz13-Sep-2013 22:45 1.8M
[   ]polymerdescr.csv.gz13-Sep-2013 22:45 807K
[   ]polymersyn.csv.gz13-Sep-2013 22:45 1.0K
[   ]residueatomlist.csv.gz13-Sep-2013 22:45 102K
[   ]residuebondlist.csv.gz13-Sep-2013 22:45 103K
[   ]residuedescr.csv.gz13-Sep-2013 22:45 31K
[   ]residuesequence.csv.gz13-Sep-2013 22:45 4.7M
[   ]sampleconddescr.csv.gz13-Sep-2013 22:45 87K
[   ]sampleconditions.csv.gz13-Sep-2013 22:45 173K
[   ]samplecontents.csv.gz13-Sep-2013 22:45 423K
[   ]sampledescr.csv.gz13-Sep-2013 22:45 150K
[   ]samplepuritydescr.csv.gz13-Sep-2013 22:45 786
[   ]schema.sql11-Dec-2009 17:09 81K
[   ]softplatformvendor.csv.gz13-Sep-2013 22:45 504
[   ]software.csv.gz13-Sep-2013 22:45 214K
[   ]softwaretask.csv.gz13-Sep-2013 22:45 180K
[   ]softwarevendor.csv.gz13-Sep-2013 22:45 155K
[   ]system.csv.gz13-Sep-2013 22:45 213K
[   ]systembiolfunc.csv.gz13-Sep-2013 22:45 38K
[   ]systemdblinks.csv.gz13-Sep-2013 22:45 43K


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