![[ICO]](/icons/blank.gif){kind=icon}
![[DIR]](/icons/back.gif){kind=icon}
![[ ]](/icons/unknown.gif){kind=icon}
![[TXT]](/icons/text.gif){kind=icon}
![[ ]](/icons/script.gif){kind=icon}
| Name | Last modified | Size | Description |
|---|---|---|---|---|
| Parent Directory | - | ||
| Ambiguous_atom_chem_shift.csv | 15-May-2012 22:40 | 144K | |
| Assembly.csv | 15-May-2012 22:40 | 126K | |
| Assigned_chem_shift_list.csv | 15-May-2012 22:40 | 192K | |
| Assigned_peak_chem_shift.csv | 15-May-2012 22:40 | 3.5M | |
| Atom_chem_shift.csv | 15-May-2012 22:40 | 2.4M | |
| Atom_nomenclature.csv | 15-May-2012 22:40 | 1.3M | |
| Atom_site.csv | 15-May-2012 22:40 | 510K | |
| Chem_comp.csv | 15-May-2012 22:40 | 577K | |
| Chem_comp_SMILES.csv | 15-May-2012 22:40 | 173K | |
| Chem_comp_atom.csv | 15-May-2012 22:40 | 3.1M | |
| Chem_comp_bond.csv | 15-May-2012 22:40 | 2.1M | |
| Chem_comp_citation.csv | 15-May-2012 22:40 | 45K | |
| Chem_comp_common_name.csv | 15-May-2012 22:40 | 848K | |
| Chem_comp_db_link.csv | 15-May-2012 22:40 | 1.3M | |
| Chem_comp_systematic_name.csv | 15-May-2012 22:40 | 474K | |
| Chem_shift_experiment.csv | 15-May-2012 22:40 | 289K | |
| Chem_shift_ref.csv | 15-May-2012 22:40 | 395K | |
| Chem_shift_reference.csv | 15-May-2012 22:40 | 130K | |
| Chem_shift_software.csv | 15-May-2012 22:40 | 51K | |
| Chem_shifts_calc_software.csv | 15-May-2012 22:40 | 7.3K | |
| Chem_shifts_calc_type.csv | 15-May-2012 22:40 | 702K | |
| Citation.csv | 15-May-2012 22:40 | 324K | |
| Citation_author.csv | 15-May-2012 22:40 | 1.3M | |
| Conformer_family_coord_set.csv | 15-May-2012 22:40 | 24K | |
| Conformer_family_software.csv | 15-May-2012 22:40 | 7.3K | |
| Data_set.csv | 15-May-2012 22:40 | 52K | |
| Datum.csv | 15-May-2012 22:40 | 92K | |
| Entity.csv | 15-May-2012 22:40 | 190K | |
| Entity_assembly.csv | 15-May-2012 22:40 | 113K | |
| Entity_comp_index.csv | 15-May-2012 22:40 | 51K | |
| Entity_experimental_src.csv | 15-May-2012 22:40 | 110K | |
| Entity_experimental_src_list.csv | 15-May-2012 22:40 | 72K | |
| Entity_natural_src.csv | 15-May-2012 22:40 | 165K | |
| Entity_natural_src_list.csv | 15-May-2012 22:40 | 59K | |
| Entry.csv | 15-May-2012 22:40 | 322K | |
| Entry_author.csv | 15-May-2012 22:40 | 165K | |
| Entry_src.csv | 15-May-2012 22:40 | 123K | |
| Experiment.csv | 15-May-2012 22:40 | 1.0M | |
| Experiment_file.csv | 15-May-2012 22:40 | 1.7M | |
| Experiment_list.csv | 15-May-2012 22:40 | 63K | |
| NMR_probe.csv | 15-May-2012 22:40 | 1.4K | |
| NMR_spectrometer.csv | 15-May-2012 22:40 | 82K | |
| NMR_spectrometer_probe.csv | 15-May-2012 22:40 | 5.3K | |
| Peak.csv | 15-May-2012 22:40 | 553K | |
| Peak_char.csv | 15-May-2012 22:40 | 1.4M | |
| Peak_general_char.csv | 15-May-2012 22:40 | 403K | |
| Release.csv | 15-May-2012 22:40 | 1.6M | |
| Sample.csv | 15-May-2012 22:40 | 132K | |
| Sample_component.csv | 15-May-2012 22:40 | 530K | |
| Sample_condition_list.csv | 15-May-2012 22:40 | 73K | |
| Sample_condition_variable.csv | 15-May-2012 22:40 | 85K | |
| Software.csv | 15-May-2012 22:40 | 166K | |
| Spectral_dim.csv | 15-May-2012 22:40 | 247K | |
| Spectral_peak_list.csv | 15-May-2012 22:40 | 422K | |
| Spectral_peak_software.csv | 15-May-2012 22:40 | 183K | |
| Spectral_transition.csv | 15-May-2012 22:40 | 460K | |
| Spectral_transition_char.csv | 15-May-2012 22:40 | 813K | |
| Spectral_transition_general_char.csv | 15-May-2012 22:40 | 712K | |
| Task.csv | 15-May-2012 22:40 | 230K | |
| Theoretical_chem_shift.csv | 15-May-2012 22:40 | 280K | |
| Theoretical_chem_shift_list.csv | 15-May-2012 22:40 | 35K | |
| Vendor.csv | 15-May-2012 22:40 | 168K | |
| dict.cat_grp.csv | 15-May-2012 22:40 | 2.9K | |
| dict.comments.csv | 15-May-2012 22:40 | 8.6K | |
| dict.ddltypes.csv | 15-May-2012 22:40 | 3.4K | |
| dict.tag_cats.csv | 15-May-2012 22:40 | 3.0K | |
| dict.val_enums.csv | 15-May-2012 22:40 | 82K | |
| dict.val_item_tbl.csv | 15-May-2012 22:40 | 836K | |
| dict.val_overrides.csv | 15-May-2012 22:40 | 8.1K | |
| entry_saveframes.csv | 15-May-2012 22:40 | 1.3M | |
| load.sh | 27-Apr-2012 15:40 | 838 | |
| schema.sql | 16-Sep-2011 12:48 | 218K | |
Files in this directory:
schema.sql : PostgreSQL database schema
(generated with "pg_dump -s -x -O")
dict.*.csv : PostgreSQL table dumps in CSV format
*.csv : PostgreSQL table dumps in CSV format
(generated with "psql -c \copy $TABLE to $TABLE.csv csv")
dict.*.csv : table dumps of NMR-STAR dictionary tables in the "dict" schema
load.sh : shell script for loading the files into PostgreSQL database
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,
psql -d BMRB -c \copy $TABLE from $TABLE.csv csv header
- or create a database and run load.sh
Mirror sites: also load dictionary tables:
for each dict.$TABLE.csv
psql -d BMRB -c \copy dict.$TABLE from dict.$TABLE.csv csv header
Opening CSV files in spreadsheet programs
-----------------------------------------
Some of these files contain multi-line fields, not all spreadsheet
programs can handle those.
E.g. OpenOffice Calc will import these files correctly, Microsoft Excel will not.
--
Wed 20 Apr 2011 01:04:20 PM CDT