
-- DROP SCHEMA IF EXISTS `interaction` ;
-- CREATE SCHEMA IF NOT EXISTS `interaction` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `interaction` ;

-- -----------------------------------------------------
-- Table `interaction`.`Species`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Species` (
  `species_id` INT NOT NULL AUTO_INCREMENT ,
  `species` VARCHAR(45) NOT NULL ,
  `NCBI_taxonomy_id` VARCHAR(45) NULL ,
  `accession_info_url` VARCHAR(45) NULL ,
  PRIMARY KEY (`species_id`) ,
  UNIQUE INDEX `species_UNIQUE` (`species` ASC) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Object_type`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Object_type` (
  `object_type_id` INT NOT NULL AUTO_INCREMENT ,
  `object_type` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`object_type_id`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Object`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Object` (
  `object_id` INT NOT NULL AUTO_INCREMENT ,
  `object_accession` VARCHAR(45) NOT NULL ,
  `species_id` INT NOT NULL ,
  `object_full_name` VARCHAR(45) NULL ,
  `object_abbreviation` VARCHAR(45) NULL ,
  `object_type_id` INT NULL ,
  PRIMARY KEY (`object_id`) ,
  UNIQUE INDEX `gene_id_UNIQUE` (`object_accession` ASC) ,
  INDEX `fk_Gene_1` (`species_id` ASC) ,
  INDEX `fk_Object_1` (`object_type_id` ASC) ,
  CONSTRAINT `fk_Gene_1`
    FOREIGN KEY (`species_id` )
    REFERENCES `interaction`.`Species` (`species_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Object_1`
    FOREIGN KEY (`object_type_id` )
    REFERENCES `interaction`.`Object_type` (`object_type_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Interaction_type`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Interaction_type` (
  `interaction_type_id` INT NOT NULL AUTO_INCREMENT ,
  `interaction_type` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`interaction_type_id`) ,
  UNIQUE INDEX `interaction_type_UNIQUE` (`interaction_type` ASC) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Experiment`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Experiment` (
  `experiment_id` INT NOT NULL AUTO_INCREMENT ,
  `experiment_name` VARCHAR(55) NOT NULL ,
  PRIMARY KEY (`experiment_id`) ,
  UNIQUE INDEX `experiment_UNIQUE` (`experiment_name` ASC) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Evidence`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Evidence` (
  `evidence_id` INT NOT NULL AUTO_INCREMENT ,
  `source_name` VARCHAR(45) NOT NULL ,
  `source_id` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`evidence_id`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Interactor_type`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Interactor_type` (
  `interactor_type_id` INT NOT NULL AUTO_INCREMENT ,
  `interactor_type` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`interactor_type_id`) ,
  UNIQUE INDEX `interactor_type_1_UNIQUE` (`interactor_type` ASC) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Evidence_code`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Evidence_code` (
  `evidence_code_id` INT NOT NULL  AUTO_INCREMENT ,
  `evidence_code` VARCHAR(45) NOT NULL ,
  `evidence_name` VARCHAR(55) NOT NULL ,
  PRIMARY KEY (`evidence_code_id`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Curator`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Curator` (
  `curator_id` INT NOT NULL AUTO_INCREMENT ,
  `lab_name` VARCHAR(45) NOT NULL ,
  `user_name` VARCHAR(45) NULL ,
  PRIMARY KEY (`curator_id`),
  UNIQUE INDEX `user_name_UNIQUE` (`user_name` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Mode_of_action`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Mode_of_action` (
  `mode_of_action_id` INT NOT NULL AUTO_INCREMENT ,
  `mode_of_action` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`mode_of_action_id`) ,
  UNIQUE INDEX `mode_of_action_UNIQUE` (`mode_of_action` ASC) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Interaction`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Interaction` (
  `interaction_id` INT NOT NULL AUTO_INCREMENT ,
  `object_id_left` INT NOT NULL ,
  `object_id_right` INT NOT NULL ,
  `interaction_type_id` INT NULL ,
  `mode_of_action_id` INT NULL ,
  `interactor_type_id_left` INT NULL ,
  `Interactor_type_id_right` INT NULL ,
  `evidence_id` INT NULL ,
  `evidence_code_id` INT NULL ,
  `experiment_id` INT NULL ,
  `comments` VARCHAR(255) NULL ,
  `curator_id` INT NULL ,
  `date` VARCHAR(10) NULL ,
  PRIMARY KEY (`interaction_id`) ,
  INDEX `fk_Interactions_1` (`object_id_left` ASC) ,
  INDEX `fk_Interactions_2` (`object_id_right` ASC) ,
  INDEX `fk_Interactions_3` (`interaction_type_id` ASC) ,
  INDEX `fk_Interactions_5` (`experiment_id` ASC) ,
  INDEX `fk_Interactions_6` (`evidence_code_id` ASC) ,
  INDEX `fk_Interactions_7` (`interactor_type_id_left` ASC) ,
  INDEX `fk_Interactions_8` (`Interactor_type_id_right` ASC) ,
  INDEX `fk_Interaction_9` (`evidence_id` ASC) ,
  INDEX `fk_Interaction_10` (`curator_id` ASC) ,
  INDEX `fk_Interaction_11` (`mode_of_action_id` ASC) ,
  CONSTRAINT `fk_Interactions_1`
    FOREIGN KEY (`object_id_left` )
    REFERENCES `interaction`.`Object` (`object_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Interactions_2`
    FOREIGN KEY (`object_id_right` )
    REFERENCES `interaction`.`Object` (`object_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Interactions_3`
    FOREIGN KEY (`interaction_type_id` )
    REFERENCES `interaction`.`Interaction_type` (`interaction_type_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Interactions_5`
    FOREIGN KEY (`experiment_id` )
    REFERENCES `interaction`.`Experiment` (`experiment_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Interactions_6`
    FOREIGN KEY (`evidence_code_id` )
    REFERENCES `interaction`.`Evidence_code` (`evidence_code_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Interactions_7`
    FOREIGN KEY (`interactor_type_id_left` )
    REFERENCES `interaction`.`Interactor_type` (`interactor_type_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Interactions_8`
    FOREIGN KEY (`Interactor_type_id_right` )
    REFERENCES `interaction`.`Interactor_type` (`interactor_type_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Interaction_9`
    FOREIGN KEY (`evidence_id` )
    REFERENCES `interaction`.`Evidence` (`evidence_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Interaction_10`
    FOREIGN KEY (`curator_id` )
    REFERENCES `interaction`.`Curator` (`curator_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Interaction_11`
    FOREIGN KEY (`mode_of_action_id` )
    REFERENCES `interaction`.`Mode_of_action` (`mode_of_action_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Homology_type`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Homology_type` (
  `homology_type_id` INT NOT NULL AUTO_INCREMENT COMMENT '	' ,
  `homology_type` VARCHAR(10) NOT NULL ,
  PRIMARY KEY (`homology_type_id`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Homology`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Homology` (
  `homology_id` INT NOT NULL AUTO_INCREMENT ,
  `object_id_source` INT NOT NULL ,
  `object_id_projection` INT NOT NULL ,
  `score` INT NOT NULL ,
  `homology_type_id` INT NOT NULL ,
  PRIMARY KEY (`homology_id`) ,
  INDEX `fk_Homology_1` (`object_id_source` ASC) ,
  INDEX `fk_Homology_2` (`object_id_projection` ASC) ,
  INDEX `fk_Homology_3` (`homology_type_id` ASC) ,
  CONSTRAINT `fk_Homology_1`
    FOREIGN KEY (`object_id_source` )
    REFERENCES `interaction`.`Object` (`object_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Homology_2`
    FOREIGN KEY (`object_id_projection` )
    REFERENCES `interaction`.`Object` (`object_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Homology_3`
    FOREIGN KEY (`homology_type_id` )
    REFERENCES `interaction`.`Homology_type` (`homology_type_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Synonym`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Synonym` (
  `synonym_id` INT NOT NULL AUTO_INCREMENT ,
  `synonym` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`synonym_id`) ,
  UNIQUE INDEX `synonym_UNIQUE` (`synonym` ASC) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `interaction`.`Object_synonym`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `interaction`.`Object_synonym` (
  `object_synonym_id` INT NOT NULL AUTO_INCREMENT ,
  `object_id` INT NOT NULL ,
  `synonym_id` INT NOT NULL ,
  PRIMARY KEY (`object_synonym_id`) ,
  INDEX `fk_Gene_synonym_1` (`object_id` ASC) ,
  INDEX `fk_Gene_synonym_2` (`synonym_id` ASC) ,
  CONSTRAINT `fk_Gene_synonym_1`
    FOREIGN KEY (`object_id` )
    REFERENCES `interaction`.`Object` (`object_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Gene_synonym_2`
    FOREIGN KEY (`synonym_id` )
    REFERENCES `interaction`.`Synonym` (`synonym_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Populate `interaction`.`Object_type` with known values
-- -----------------------------------------------------

INSERT INTO `Object_type`(`object_type`) VALUE('gene');
INSERT INTO `Object_type`(`object_type`) VALUE('metabolite');


-- -----------------------------------------------------
-- Populate `interaction`.`Homology_type` with known values
-- -----------------------------------------------------

INSERT INTO `Homology_type`(`homology_type`) VALUE('ortholog');
INSERT INTO `Homology_type`(`homology_type`) VALUE('paralog');


-- -----------------------------------------------------
-- Populate `interaction`.`Interactor_type` with known values
-- -----------------------------------------------------

INSERT INTO `Interactor_type`(`interactor_type`) VALUE('DNA');
INSERT INTO `Interactor_type`(`interactor_type`) VALUE('RNA');
INSERT INTO `Interactor_type`(`interactor_type`) VALUE('protein');
INSERT INTO `Interactor_type`(`interactor_type`) VALUE('metabolite');
INSERT INTO `Interactor_type`(`interactor_type`) VALUE('gene');
INSERT INTO `Interactor_type`(`interactor_type`) VALUE('NA');


-- -----------------------------------------------------
-- Populate `interaction`.`Interaction_type` with known values
-- -----------------------------------------------------

INSERT INTO `Interaction_type`(`interaction_type`) VALUE('protein-protein binding');
INSERT INTO `Interaction_type`(`interaction_type`) VALUE('up regulation');
INSERT INTO `Interaction_type`(`interaction_type`) VALUE('down regulation');
INSERT INTO `Interaction_type`(`interaction_type`) VALUE('co-expression');

-- -----------------------------------------------------
-- Populate `interaction`.`Experiment` with known values
-- -----------------------------------------------------

INSERT INTO `Experiment`(`experiment_name`) VALUE('Co-immunoprecipiation (CoIP)');
INSERT INTO `Experiment`(`experiment_name`) VALUE('bimolecular fluorescence complementation (BiFC)');
INSERT INTO `Experiment`(`experiment_name`) VALUE('yeast two-hybrid analysis (Y2H)');
INSERT INTO `Experiment`(`experiment_name`) VALUE('affinity chromatography');
INSERT INTO `Experiment`(`experiment_name`) VALUE('transcriptome (microarray)');
INSERT INTO `Experiment`(`experiment_name`) VALUE('transcriptome (RNA-Seq)');
INSERT INTO `Experiment`(`experiment_name`) VALUE('proteomics');
INSERT INTO `Experiment`(`experiment_name`) VALUE('yeast one-hybrid analysis (Y1H)');
INSERT INTO `Experiment`(`experiment_name`) VALUE('yeast three-hybrid analysis (Y3H)');
INSERT INTO `Experiment`(`experiment_name`) VALUE('protein 2D gel');
INSERT INTO `Experiment`(`experiment_name`) VALUE('mobility shift gel assay');
INSERT INTO `Experiment`(`experiment_name`) VALUE('sequence homology');
INSERT INTO `Experiment`(`experiment_name`) VALUE('network modeling');
INSERT INTO `Experiment`(`experiment_name`) VALUE('NA (not available)');


-- -----------------------------------------------------
-- Populate `interaction`.`Evidence_code` with known values
-- -----------------------------------------------------

INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('EXP','Inferred from Experiment');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IDA','Inferred from Direct Assay');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IPI','Inferred from Physical Interaction');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IMP','Inferred from Mutant Phenotype');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IGI','Inferred from Genetic Interaction');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IEP','Inferred from Expression Pattern');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IAGP','Inferred by association of genotype from phenotype');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ISS','Inferred from Sequence or Structural Similarity');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ISO','Inferred from Sequence Orthology');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ISA','Inferred from Sequence Alignment');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ISM','Inferred from Sequence Model');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IGC','Inferred from Genomic Context');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IBA','Inferred from Biological aspect of Ancestor');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IBD','Inferred from Biological aspect of Descendant');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IKR','Inferred from Key Residues');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IRD','Inferred from Rapid Divergence');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('RCA','inferred from Reviewed Computational Analysis');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('TAS','Traceable Author Statement');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('NAS','Non-traceable Author Statement');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IC','Inferred by Curator');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ND','No biological Data available');
INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IEA','Inferred from Electronic Annotation');



-- -----------------------------------------------------
-- Populate `interaction`.`Mode_of_action` with known values
-- -----------------------------------------------------

INSERT INTO `Mode_of_action`(`mode_of_action`) VALUE('binds');
INSERT INTO `Mode_of_action`(`mode_of_action`) VALUE('co-expresses');
INSERT INTO `Mode_of_action`(`mode_of_action`) VALUE('up regulates');
INSERT INTO `Mode_of_action`(`mode_of_action`) VALUE('down regulates');


-- -----------------------------------------------------
-- Populate `interaction`.`Species` with known values
-- -----------------------------------------------------
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('59689','Arabidopsis lyrata','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3702','Arabidopsis thaliana','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('15368','Brachypodium distachyon','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('6239','Caenorhabditis elegans','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3649','Carica papaya','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3055','Chlamydomonas reinhardtii','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('85681','Citrus clementina','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('2711','Citrus sinensis','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3659','Cucumis sativus','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('7955','Danio rerio','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('7227','Drosophila melanogaster','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('2880','Ectocarpus siliculosus','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('562','Escherichia coli','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('71139','Eucalyptus grandis','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('57918','Fragaria vesca','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('5507','Fusarium oxysporum','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3847','Glycine max','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('9606','Homo sapiens','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('180498','Jatropha curcas','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('29883','Laccaria bicolor','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3983','Manihot esculenta','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3880','Medicago truncatula','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('4155','Mimulus guttatus','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('10090','Mus musculus','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('140110','Nectria haematococca','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('5141','Neurospora crassa','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('272131','Nostoc punctiforme','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('4530','Oryza sativa','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('121225','Pediculus humanus','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('42345','Phoenix dactylifera','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3218','Physcomitrella patens','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3694','Populus trichocarpa','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3760','Prunus persica','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('10116','Rattus norvegicus','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('64495','Rhizopus oryzae','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3988','Ricinus communis','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('4932','Saccharomyces cerevisiae','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('4896','Schizosaccharomyces pombe','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('88036','Selaginella moellendorffii','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('4113','Solanum tuberosum','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('4558','Sorghum bicolor','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('3641','Theobroma cacao','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('29910','Tolypocladium inflatum','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('63577','Trichoderma atroviride','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('1206','Trichodesmium erythraeum','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('29760','Vitis vinifera','gramene');
INSERT INTO `Species`(`NCBI_taxonomy_id`,`species`,`accession_info_url`)  VALUES('4577','Zea mays','gramene');

