CREATE TABLE IF NOT EXISTS ExpInfo (
	expId INT(10) unsigned NOT NULL AUTO_INCREMENT,
	chipId INT(10) unsigned NOT NULL,
	sampleTaxId INT(10) NOT NULL,
	condition VARCHAR(255) NOT NULL,
	controlInfo TEXT NOT NULL,
	treatmentInfo TEXT NOT NULL,
	pubMedId VARCHAR(255), # papers may not have a pubmed id yet
	citation VARCHAR(255), # experiment may not be published yet
	contact VARCHAR(255) NOT NULL,
	email VARCHAR(255) NOT NULL,
	comment TEXT NOT NULL,
        PRIMARY KEY (expId),
	FOREIGN KEY (chipId) REFERENCES ChipInfo (chipId),
  	FOREIGN KEY (sampleTaxId) REFERENCES Taxonomy (taxonomyId)
 );
