| Name | Last modified | Size | Description | |
|---|---|---|---|---|
| Parent Directory | - | |||
| assignchemicashift.csv.gz | 10-Aug-2013 22:45 | 192K | ||
| biolfunclist.csv.gz | 10-Aug-2013 22:45 | 226 | ||
| biolfuncmolsystem.csv.gz | 10-Aug-2013 22:45 | 296 | ||
| biolmoldblinks.csv.gz | 10-Aug-2013 22:45 | 186 | ||
| biopolymresidmlabe.csv.gz | 10-Aug-2013 22:45 | 9.8K | ||
| biopolymresidsynon.csv.gz | 10-Aug-2013 22:45 | 464 | ||
| chemicalshifts.csv.gz | 10-Aug-2013 22:45 | 57M | ||
| chemshiftambglinks.csv.gz | 10-Aug-2013 22:45 | 21K | ||
| chemshiftexptlist.csv.gz | 10-Aug-2013 22:45 | 141K | ||
| chemshiftrefdescr.csv.gz | 10-Aug-2013 22:45 | 70K | ||
| chemshiftreferences.csv.gz | 10-Aug-2013 22:45 | 140K | ||
| chemshiftsamplist.csv.gz | 10-Aug-2013 22:45 | 90K | ||
| chemshiftsoftlist.csv.gz | 10-Aug-2013 22:45 | 19K | ||
| citation.csv.gz | 10-Aug-2013 22:45 | 123K | ||
| citauthors.csv.gz | 10-Aug-2013 22:45 | 23K | ||
| citkeyword.csv.gz | 10-Aug-2013 22:45 | 4.0K | ||
| contactperson.csv.gz | 10-Aug-2013 22:45 | 237 | ||
| contactpersoncat.csv.gz | 10-Aug-2013 22:45 | 76 | ||
| crosslinkbondlist.csv.gz | 10-Aug-2013 22:45 | 76K | ||
| crosslinkbonds.csv.gz | 10-Aug-2013 22:45 | 11K | ||
| deletedatomlist.csv.gz | 10-Aug-2013 22:45 | 8.1K | ||
| depsindb.csv.gz | 10-Aug-2013 22:45 | 25K | ||
| dictionary.sql | 06-Nov-2008 12:37 | 118K | ||
| doc/ | 12-Dec-2008 15:07 | - | ||
| dump.sql | 10-Aug-2013 22:45 | 8.4K | ||
| entryauthors.csv.gz | 10-Aug-2013 22:45 | 424K | ||
| entrycitation.csv.gz | 10-Aug-2013 22:45 | 548K | ||
| entrycitauthors.csv.gz | 10-Aug-2013 22:45 | 508K | ||
| entryciteditors.csv.gz | 10-Aug-2013 22:45 | 98 | ||
| entrycitkeywords.csv.gz | 10-Aug-2013 22:45 | 115K | ||
| entryinfodatacat.csv.gz | 10-Aug-2013 22:45 | 62K | ||
| entryinfodatatype.csv.gz | 10-Aug-2013 22:45 | 138K | ||
| entryinforelbmrbid.csv.gz | 10-Aug-2013 22:45 | 82K | ||
| entryinforevisions.csv.gz | 10-Aug-2013 22:45 | 96K | ||
| entryinformation.csv.gz | 10-Aug-2013 22:45 | 435K | ||
| experimentalsource.csv.gz | 10-Aug-2013 22:45 | 183K | ||
| exptsourcesfc.csv.gz | 10-Aug-2013 22:45 | 52K | ||
| jconstantdescr.csv.gz | 10-Aug-2013 22:45 | 12K | ||
| jconstantexptlist.csv.gz | 10-Aug-2013 22:45 | 2.2K | ||
| jconstants.csv.gz | 10-Aug-2013 22:45 | 312K | ||
| jconstantsamplist.csv.gz | 10-Aug-2013 22:45 | 3.2K | ||
| jconstantsoftlist.csv.gz | 10-Aug-2013 22:45 | 510 | ||
| ligand.csv.gz | 10-Aug-2013 22:45 | 35K | ||
| ligandatomlist.csv.gz | 10-Aug-2013 22:45 | 134K | ||
| ligandbondlist.csv.gz | 10-Aug-2013 22:45 | 146K | ||
| ligandsynonym.csv.gz | 10-Aug-2013 22:45 | 1.2K | ||
| magequivsystemcomp.csv.gz | 10-Aug-2013 22:45 | 8.6K | ||
| molpuritydescr.csv.gz | 10-Aug-2013 22:45 | 541 | ||
| molsystemcomp.csv.gz | 10-Aug-2013 22:45 | 186K | ||
| naturalsource.csv.gz | 10-Aug-2013 22:45 | 197K | ||
| naturalsourcesfc.csv.gz | 10-Aug-2013 22:45 | 52K | ||
| nmrexperimental.csv.gz | 10-Aug-2013 22:45 | 520K | ||
| nmrexptcit.csv.gz | 10-Aug-2013 22:45 | 82 | ||
| nmrspecacqpar.csv.gz | 10-Aug-2013 22:45 | 1.1K | ||
| nmrspecprocpar.csv.gz | 10-Aug-2013 22:45 | 460 | ||
| nmrspectrometer.csv.gz | 10-Aug-2013 22:45 | 111K | ||
| polymerbiofunc.csv.gz | 10-Aug-2013 22:45 | 32K | ||
| polymerdblinks.csv.gz | 10-Aug-2013 22:45 | 1.8M | ||
| polymerdescr.csv.gz | 10-Aug-2013 22:45 | 799K | ||
| polymersyn.csv.gz | 10-Aug-2013 22:45 | 1.0K | ||
| residueatomlist.csv.gz | 10-Aug-2013 22:45 | 101K | ||
| residuebondlist.csv.gz | 10-Aug-2013 22:45 | 101K | ||
| residuedescr.csv.gz | 10-Aug-2013 22:45 | 30K | ||
| residuesequence.csv.gz | 10-Aug-2013 22:45 | 4.7M | ||
| sampleconddescr.csv.gz | 10-Aug-2013 22:45 | 86K | ||
| sampleconditions.csv.gz | 10-Aug-2013 22:45 | 172K | ||
| samplecontents.csv.gz | 10-Aug-2013 22:45 | 417K | ||
| sampledescr.csv.gz | 10-Aug-2013 22:45 | 149K | ||
| samplepuritydescr.csv.gz | 10-Aug-2013 22:45 | 786 | ||
| schema.sql | 11-Dec-2009 17:09 | 81K | ||
| softplatformvendor.csv.gz | 10-Aug-2013 22:45 | 504 | ||
| software.csv.gz | 10-Aug-2013 22:45 | 211K | ||
| softwaretask.csv.gz | 10-Aug-2013 22:45 | 178K | ||
| softwarevendor.csv.gz | 10-Aug-2013 22:45 | 153K | ||
| system.csv.gz | 10-Aug-2013 22:45 | 211K | ||
| systembiolfunc.csv.gz | 10-Aug-2013 22:45 | 38K | ||
| systemdblinks.csv.gz | 10-Aug-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