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

	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