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

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