![[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 | - | ||
| assignchemicashift.csv.gz | 15-May-2012 22:45 | 164K | |
| biolfunclist.csv.gz | 15-May-2012 22:45 | 227 | |
| biolfuncmolsystem.csv.gz | 15-May-2012 22:45 | 295 | |
| biolmoldblinks.csv.gz | 15-May-2012 22:45 | 186 | |
| biopolymresidmlabe.csv.gz | 15-May-2012 22:45 | 11K | |
| biopolymresidsynon.csv.gz | 15-May-2012 22:45 | 462 | |
| chemicalshifts.csv.gz | 15-May-2012 22:45 | 49M | |
| chemshiftambglinks.csv.gz | 15-May-2012 22:45 | 19K | |
| chemshiftexptlist.csv.gz | 15-May-2012 22:45 | 97K | |
| chemshiftrefdescr.csv.gz | 15-May-2012 22:45 | 59K | |
| chemshiftreferences.csv.gz | 15-May-2012 22:45 | 115K | |
| chemshiftsamplist.csv.gz | 15-May-2012 22:45 | 75K | |
| chemshiftsoftlist.csv.gz | 15-May-2012 22:45 | 18K | |
| citation.csv.gz | 15-May-2012 22:45 | 107K | |
| citauthors.csv.gz | 15-May-2012 22:45 | 19K | |
| citkeyword.csv.gz | 15-May-2012 22:45 | 3.9K | |
| contactperson.csv.gz | 15-May-2012 22:45 | 237 | |
| contactpersoncat.csv.gz | 15-May-2012 22:45 | 76 | |
| crosslinkbondlist.csv.gz | 15-May-2012 22:45 | 67K | |
| crosslinkbonds.csv.gz | 15-May-2012 22:45 | 9.9K | |
| deletedatomlist.csv.gz | 15-May-2012 22:45 | 8.3K | |
| depsindb.csv.gz | 15-May-2012 22:45 | 20K | |
| dictionary.sql | 06-Nov-2008 12:37 | 118K | |
| doc/ | 12-Dec-2008 15:07 | - | |
| dump.sql | 15-May-2012 22:45 | 8.4K | |
| entryauthors.csv.gz | 15-May-2012 22:45 | 365K | |
| entrycitation.csv.gz | 15-May-2012 22:45 | 484K | |
| entrycitauthors.csv.gz | 15-May-2012 22:45 | 430K | |
| entryciteditors.csv.gz | 15-May-2012 22:45 | 98 | |
| entrycitkeywords.csv.gz | 15-May-2012 22:45 | 107K | |
| entryinfodatacat.csv.gz | 15-May-2012 22:45 | 53K | |
| entryinfodatatype.csv.gz | 15-May-2012 22:45 | 118K | |
| entryinforelbmrbid.csv.gz | 15-May-2012 22:45 | 63K | |
| entryinforevisions.csv.gz | 15-May-2012 22:45 | 77K | |
| entryinformation.csv.gz | 15-May-2012 22:45 | 373K | |
| experimentalsource.csv.gz | 15-May-2012 22:45 | 154K | |
| exptsourcesfc.csv.gz | 15-May-2012 22:45 | 44K | |
| jconstantdescr.csv.gz | 15-May-2012 22:45 | 11K | |
| jconstantexptlist.csv.gz | 15-May-2012 22:45 | 2.1K | |
| jconstants.csv.gz | 15-May-2012 22:45 | 312K | |
| jconstantsamplist.csv.gz | 15-May-2012 22:45 | 3.3K | |
| jconstantsoftlist.csv.gz | 15-May-2012 22:45 | 498 | |
| ligand.csv.gz | 15-May-2012 22:45 | 29K | |
| ligandatomlist.csv.gz | 15-May-2012 22:45 | 113K | |
| ligandbondlist.csv.gz | 15-May-2012 22:45 | 122K | |
| ligandsynonym.csv.gz | 15-May-2012 22:45 | 1.2K | |
| magequivsystemcomp.csv.gz | 15-May-2012 22:45 | 8.3K | |
| molpuritydescr.csv.gz | 15-May-2012 22:45 | 533 | |
| molsystemcomp.csv.gz | 15-May-2012 22:45 | 158K | |
| naturalsource.csv.gz | 15-May-2012 22:45 | 168K | |
| naturalsourcesfc.csv.gz | 15-May-2012 22:45 | 44K | |
| nmrexperimental.csv.gz | 15-May-2012 22:45 | 406K | |
| nmrexptcit.csv.gz | 15-May-2012 22:45 | 82 | |
| nmrspecacqpar.csv.gz | 15-May-2012 22:45 | 1.3K | |
| nmrspecprocpar.csv.gz | 15-May-2012 22:45 | 596 | |
| nmrspectrometer.csv.gz | 15-May-2012 22:45 | 90K | |
| polymerbiofunc.csv.gz | 15-May-2012 22:45 | 26K | |
| polymerdblinks.csv.gz | 15-May-2012 22:45 | 1.8M | |
| polymerdescr.csv.gz | 15-May-2012 22:45 | 690K | |
| polymersyn.csv.gz | 15-May-2012 22:45 | 1.2K | |
| residueatomlist.csv.gz | 15-May-2012 22:45 | 84K | |
| residuebondlist.csv.gz | 15-May-2012 22:45 | 85K | |
| residuedescr.csv.gz | 15-May-2012 22:45 | 25K | |
| residuesequence.csv.gz | 15-May-2012 22:45 | 4.0M | |
| sampleconddescr.csv.gz | 15-May-2012 22:45 | 73K | |
| sampleconditions.csv.gz | 15-May-2012 22:45 | 143K | |
| samplecontents.csv.gz | 15-May-2012 22:45 | 341K | |
| sampledescr.csv.gz | 15-May-2012 22:45 | 122K | |
| samplepuritydescr.csv.gz | 15-May-2012 22:45 | 788 | |
| schema.sql | 11-Dec-2009 17:09 | 81K | |
| softplatformvendor.csv.gz | 15-May-2012 22:45 | 565 | |
| software.csv.gz | 15-May-2012 22:45 | 174K | |
| softwaretask.csv.gz | 15-May-2012 22:45 | 142K | |
| softwarevendor.csv.gz | 15-May-2012 22:45 | 115K | |
| system.csv.gz | 15-May-2012 22:45 | 185K | |
| systembiolfunc.csv.gz | 15-May-2012 22:45 | 36K | |
| systemdblinks.csv.gz | 15-May-2012 22:45 | 46K | |
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