# CocoaMySQL dump
# Version 0.5
# http://cocoamysql.sourceforge.net
#
# Host: localhost (MySQL 4.0.18-standard)
# Database: imid
# Generation Time: 2004-07-29 14:58:17 -0400
# ************************************************************

# Dump of table pathogen_category
# ------------------------------------------------------------

CREATE TABLE `pathogen_category` (
  `id` int(11) default NULL,
  `name` text,
  `phylogeny` text,
  `morphology` text
) TYPE=MyISAM;

INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("1","Staphylococcus aureus","Eubacteria","Gram positive cocci in clusters");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("2","Staphylococcus epidermidis","Eubacteria","Gram positive cocci in clusters");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("3","Streptococcus pyogenes","Eubacteria","Gram positive cocci in chains");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("4","Streptococcus agalactiae","Eubacteria","Gram positive cocci in chains");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("5","Streptococcus pneumoniae","Eubacteria","Gram positive diplococci, lancet-shaped");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("6","Enterococcus","Eubacteria","Gram positive cocci");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("7","Clostridium perfringens","Eubacteria","Gram positive rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("8","Clostridium botulinum","Eubacteria","Gram positive rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("9","Clostridium tetani","Eubacteria","Gram positive rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("10","Clostridium difficile","Eubacteria","Gram positive rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("11","Escherichia coli","Eubacteria","Gram negative rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("12","Shigella","Eubacteria","Gram negative rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("13","Salmonella","Eubacteria","Gram negative rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("14","Klebsiella","Eubacteria","Gram negative rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("16","Haemophilus influenzae","Eubacteria","Gram negative coccobacilli");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("17","Pseudomonas aeruginosa","Eubacteria","Gram negative rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("18","Neisseria meningitidis","Eubacteria","Gram negative diplococci, kidney-shaped");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("19","Neisseria gonorrhea","Eubacteria","Gram negative diplococci, kidney-shaped");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("20","Bordatella pertussis","Eubacteria","Gram negative rods, small");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("21","Legionella pneumophila","Eubacteria","Gram negative rods, small");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("22","Bacteroides fragilis","Eubacteria","Gram negative rods, thin");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("23","Yersinia pestis","Eubacteria","Gram negative rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("24","Helicobacter pylori","Eubacteria","Gram negative rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("25","Vibrio cholera","Eubacteria","Gram negative rods, helical");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("26","Treponema pallidum","Eubacteria","spirochete");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("27","Borrelia burgorferi","Eubacteria","spirochete");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("28","Chlamydia trachomatis","Eubacteria","intracellular inclusion bodies");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("29","Rickettsia rickettsiae","Eubacteria","intracellular");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("32","Mycobacterium tuberculosis","Eubacteria","acid-fast rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("31","Mycobacterium leprae","Eubacteria","acid-fast rods");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("33","Poliovirus","Virus","non-enveloped, icosahedral virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("30","Mycoplasma","Eubacteria","wall-less intracellular organisms");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("34","Rhinovirus","Virus","non-enveloped, icosahedral virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("35","Hepatitis A virus","Virus","non-enveloped, icosahedral virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("36","Yellow Fever virus","Virus","enveloped, icosahedral capsid");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("37","Hepatitis C virus","Virus","enveloped, icosahedral capsid");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("38","Rabies virus","Virus","enveloped, bullet-shaped virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("39","Measles virus","Virus","enveloped, irregular virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("40","Influenza virus","Virus","enveloped, irregular virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("41","enveloped, icosahedral virion","Virus","enveloped, icosahedral capsid");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("42","HIV","Virus","enveloped, conical capsid");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("43","Hepatitis B virus","Virus","enveloped, icosahedral capsid");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("44","Parvovirus","Virus","non-enveloped, icosahedral virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("45","JC virus","Virus","non-enveloped, icosahedral virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("46","Papilloma virus","Virus","non-enveloped, icosahedral virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("47","Adenovirus","Virus","non-enveloped, icosahedral virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("48","Herpes Simplex virus","Virus","enveloped, icosahedral capsid");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("49","Cytomegalovirus","Virus","enveloped, icosahedral capsid");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("50","Epstein-Barr virus","Virus","enveloped, icosahedral capsid");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("51","Smallpox virus","Virus","enveloped, complex brick-shaped virion");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("52","Candida albicans","Fungi","budding yeast, dimorphic");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("53","Coccidiodies imitans","Fungi","budding yeast");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("54","Cryptococcus neoformans","Fungi","budding yeast");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("55","Aspergillus fumigatus","Fungi","filamentous fungi");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("56","Pneumocystis carinii","Fungi","polymorphic");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("57","Toxoplasma gondii","Fungi","polymorphic");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("58","Plasmodium falciparum","Protozoa","polymorphic");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("59","Entamoeba histolytica","Protozoa","amoeba");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("60","Trypanosoma brucei","Protozoa","flagellate trypanosome");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("61","Giardia lamblia","Protozoa","flagellate, binucleate");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("62","Schistosoma mansoni","Metazoa","helminth");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("63","Onchocerca volvulus","Metazoa","filarial worm");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("64","Taenia solium","Metazoa","flatworm");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("65","Dracunculis medinensis","Metazoa","flatworm");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("66","Stsrongyloides stercoralis","Metazoa","helminth");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("67","Ascaris lumbroides","Metazoa","roundworm");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("68","lice","Metazoa","arthropod");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("69","miaisis","Metazoa","arthropod");
INSERT INTO `pathogen_category` (`id`,`name`,`phylogeny`,`morphology`) VALUES ("70","Ebola virus","Virus","enveloped, filamentous");


# Dump of table pathogen_names
# ------------------------------------------------------------

CREATE TABLE `pathogen_names` (
  `id` int(11) default NULL,
  `name` text
) TYPE=MyISAM;

INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("1","Staphylococcus aureus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("2","Staphylococcus epidermidis");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("3","Streptococcus pyogenes");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("4","Streptococcus agalactiae");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("5","Streptococcus pneumoniae");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("6","Enterococcus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("7","Clostridium perfringens");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("8","Clostridium botulinum");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("9","Clostridium tetani");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("10","Clostridium difficile");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("11","Escherichia coli");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("12","Shigella");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("13","Salmonella");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("14","Klebsiella");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("15","Bordatella");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("16","Haemophilus influenzae");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("17","Pseudomonas aeruginosa");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("18","Neisseria meningitidis");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("19","Neisseria gonorrhea");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("20","Bordatella pertussis");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("21","Legionella pneumophila");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("22","Bacteroides fragilis");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("24","Helicobacter pylori");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("26","Treponema pallidum");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("27","Borrelia burgorferi");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("28","Chlamydia trachomatis");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("33","Mycoplasma");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("29","Rickettsia rickettsiae");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("30","Mycobacterium tuberculosis");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("31","Mycobacterium leprae");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("32","Poliovirus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("34","Rhinovirus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("36","Yellow Fever virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("37","Hepatitis C virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("39","Measles virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("35","Hepatitis A virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("40","Influenza virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("38","Rabies virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("41","Rotavirus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("42","HIV");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("44","Parvovirus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("45","JC virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("43","Hepatitis B virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("25","Vibrio cholera");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("46","Papilloma virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("47","Adenovirus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("48","Herpes Simplex virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("49","Cytomegalovirus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("50","Epstein-Barr virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("52","Candida albicans");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("53","Coccidiodies imitans");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("54","Cryptococcus neoformans");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("55","Aspergillus fumigatus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("57","Toxoplasma gondii");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("58","Plasmodium falciparum");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("59","Entamoeba histolytica");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("60","Trypanosoma brucei");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("62","Schistosoma mansoni");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("23","Yersinia pestis");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("51","Smallpox virus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("61","Giardia lamblia");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("56","Pneumocystis carinii");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("63","Onchocerca volvulus");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("64","Taenia solium");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("65","Dracunculis medinensis");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("66","Stsrongyloides stercoralis");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("67","Ascaris lumbroides");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("68","lice");
INSERT INTO `pathogen_names` (`id`,`name`) VALUES ("69","miaisis");


# Dump of table pathogen_resources
# ------------------------------------------------------------

CREATE TABLE `pathogen_resources` (
  `id` int(11) default NULL,
  `pathogen_name` text,
  `resource_type` int(11) default NULL,
  `resource_id` int(11) default NULL
) TYPE=MyISAM;



# Dump of table pathogen_table1
# ------------------------------------------------------------

CREATE TABLE `pathogen_table1` (
  `id` int(11) default NULL,
  `name` text,
  `phylogeny` text,
  `morphology` text,
  `ecology` text,
  `pathophysiology` text,
  `diseases` text,
  `oth_dis` text,
  `comment` text
) TYPE=MyISAM;



# Dump of table pathogen_table2
# ------------------------------------------------------------

CREATE TABLE `pathogen_table2` (
  `id` int(11) default NULL,
  `name` text,
  `phylogeny` text,
  `morphology` text,
  `ecology` text
) TYPE=MyISAM;

INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1101","Staphylococcus aureus","Eubacteria","Gram positive cocci in clusters","comensual");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1102","Staphylococcus epidermidis","Eubacteria","Gram positive cocci in clusters","comensual");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1103","Streptococcus pyogenes","Eubacteria","Gram positive cocci in chains","comensual");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1104","Streptococcus agalactiae","Eubacteria","Gram positive cocci in chains","comensual");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1105","Streptococcus pneumoniae","Eubacteria","Gram positive diplococci, lancet-shaped","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1106","Enterococcus","Eubacteria","Gram positive cocci","comensual");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1201","Clostridium perfringens","Eubacteria","Gram positive rods","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1202","Clostridium botulinum","Eubacteria","Gram positive rods","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1203","Clostridium tetani","Eubacteria","Gram positive rods","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1204","Clostridium difficile","Eubacteria","Gram positive rods","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1301","Escherichia coli","Eubacteria","Gram negative rods","comensual");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1302","Shigella","Eubacteria","Gram negative rods","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1303","Salmonella","Eubacteria","Gram negative rods","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1304","Klebsiella","Eubacteria","Gram negative rods","comensual");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1305","Haemophilus influenzae","Eubacteria","Gram negative coccobacilli","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1306","Pseudomonas aeruginosa","Eubacteria","Gram negative rods","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1307","Neisseria meningitidis","Eubacteria","Gram negative diplococci, kidney-shaped","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1308","Neisseria gonorrhea","Eubacteria","Gram negative diplococci, kidney-shaped","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1309","Bordatella pertussis","Eubacteria","Gram negative rods, small","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1310","Legionella pneumophila","Eubacteria","Gram negative rods, small","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1311","Bacteroides fragilis","Eubacteria","Gram negative rods, thin","comensual");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1312","Yersinia pestis","Eubacteria","Gram negative rods","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1313","Helicobacter pylori","Eubacteria","Gram negative rods","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1314","Vibrio cholera","Eubacteria","Gram negative rods, helical","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1401","Treponema pallidum","Eubacteria","spirochete","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1402","Borrelia burgorferi","Eubacteria","spirochete","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1501","Chlamydia trachomatis","Eubacteria","intracellular inclusion bodies","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1502","Rickettsia rickettsiae","Eubacteria","intracellular","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1601","Mycobacterium tuberculosis","Eubacteria","acid-fast rods","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1602","Mycobacterium leprae","Eubacteria","acid-fast rods","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2101","Poliovirus","Virus","non-enveloped, icosahedral virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("1503","Mycoplasma","Eubacteria","wall-less intracellular organisms","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2102","Rhinovirus","Virus","non-enveloped, icosahedral virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2103","Hepatitis A virus","Virus","non-enveloped, icosahedral virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2104","Yellow Fever virus","Virus","enveloped, icosahedral capsid","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2105","Hepatitis C virus","Virus","enveloped, icosahedral capsid","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2201","Rabies virus","Virus","enveloped, bullet-shaped virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2202","Measles virus","Virus","enveloped, irregular virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2203","Influenza virus","Virus","enveloped, irregular virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2301","Rotavirus","Virus","enveloped, icosahedral capsid","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2401","HIV","Virus","enveloped, conical capsid","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2402","Hepatitis B virus","Virus","enveloped, icosahedral capsid","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2501","Parvovirus","Virus","non-enveloped, icosahedral virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2502","JC virus","Virus","non-enveloped, icosahedral virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2503","Papilloma virus","Virus","non-enveloped, icosahedral virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2504","Adenovirus","Virus","non-enveloped, icosahedral virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2601","Herpes Simplex virus","Virus","enveloped, icosahedral capsid","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2602","Cytomegalovirus","Virus","enveloped, icosahedral capsid","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2603","Epstein-Barr virus","Virus","enveloped, icosahedral capsid","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2604","Smallpox virus","Virus","enveloped, complex brick-shaped virion","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("3101","Candida albicans","Fungi","budding yeast, dimorphic","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("3102","Coccidiodies imitans","Fungi","budding yeast","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("3103","Cryptococcus neoformans","Fungi","budding yeast","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("3201","Aspergillus fumigatus","Fungi","filamentous fungi","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("3301","Pneumocystis carinii","Fungi","polymorphic","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("4101","Toxoplasma gondii","Protozoa","polymorphic","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("4102","Plasmodium falciparum","Protozoa","polymorphic","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("4201","Entamoeba histolytica","Protozoa","amoeba","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("4301","Trypanosoma brucei","Protozoa","flagellate trypanosome","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("4401","Giardia lamblia","Protozoa","flagellate, binucleate","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("5101","Schistosoma mansoni","Metazoa","helminth","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("5102","Onchocerca volvulus","Metazoa","filarial worm","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("5301","Taenia solium","Metazoa","flatworm","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("5302","Dracunculis medinensis","Metazoa","flatworm","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("5201","Stsrongyloides stercoralis","Metazoa","helminth","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("5202","Ascaris lumbroides","Metazoa","roundworm","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("5401","lice","Metazoa","arthropod","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("5402","miaisis","Metazoa","arthropod","opportunist");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2204","Ebola virus","Virus","enveloped, filamentous","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2106","Coronavirus","Virus","enveloped, icosahedral capsid","parasite");
INSERT INTO `pathogen_table2` (`id`,`name`,`phylogeny`,`morphology`,`ecology`) VALUES ("2205","Hepatitis Delta virus","Virus","enveloped, icosahedral capsid","parasite");


# Dump of table pathogen_table3
# ------------------------------------------------------------

CREATE TABLE `pathogen_table3` (
  `id` int(11) default NULL,
  `name` text,
  `disease` text,
  `phylogeny` text,
  `morphology` text,
  `ecology` text,
  `pathology` text
) TYPE=MyISAM;

INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1101","Staphylococcus aureus","soft tissue infection","Eubacteria","Gram positive cocci in clusters","comensual","abscess formation, toxin secretion");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1102","Staphylococcus epidermidis","soft tissue infection, prosthetic material related infections","Eubacteria","Gram positive cocci in clusters","comensual","biofilm creation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1103","Streptococcus pyogenes","soft tissue infection, skin infection","Eubacteria","Gram positive cocci in chains","comensual","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1104","Streptococcus agalactiae","neonatal sepsis","Eubacteria","Gram positive cocci in chains","comensual","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1105","Streptococcus pneumoniae","pneumonia","Eubacteria","Gram positive diplococci, lancet-shaped","parasitic","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1106","Enterococcus","urinary tract infection","Eubacteria","Gram positive cocci","comensual","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1201","Clostridium perfringens","soft tissue infection, gangrene","Eubacteria","Gram positive rods","opportunist","tissue necrosis, gas production");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1202","Clostridium botulinum","GI, botulism","Eubacteria","Gram positive rods","opportunist","toxin-mediated");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1203","Clostridium tetani","systemic illness, tetanus","Eubacteria","Gram positive rods","opportunist","toxin-mediated");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1204","Clostridium difficile","GI, diarrheal illness","Eubacteria","Gram positive rods","opportunist","toxin-mediated");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1301","Escherichia coli","urinary tract infection, diarrheal illness","Eubacteria","Gram negative rods","comensual","inflammation, toxin production");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1302","Shigella","GI, diarrheal illness","Eubacteria","Gram negative rods","parasitic","toxin-mediated");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1303","Salmonella","systemic illness, typhoid fever, GI illness","Eubacteria","Gram negative rods","parasitic","intracellular replication");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1304","Klebsiella","pneumonia, alcoholic","Eubacteria","Gram negative rods","comensual","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1305","Haemophilus influenzae","upper respiratory tract infection","Eubacteria","Gram negative coccobacilli","parasitic","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1306","Pseudomonas aeruginosa","pneumonia, nosocomial","Eubacteria","Gram negative rods","opportunist","toxin-mediated, adhesins, biofilm generation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1307","Neisseria meningitidis","meningitis","Eubacteria","Gram negative diplococci, kidney-shaped","parasitic","inflammation, meningeal");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1308","Neisseria gonorrhea","sexually transmitted disease","Eubacteria","Gram negative diplococci, kidney-shaped","parasitic","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1309","Bordatella pertussis","pneumonia, atypical","Eubacteria","Gram negative rods, small","parasitic","toxin-mediated");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1310","Legionella pneumophila","pneumonia, atypical","Eubacteria","Gram negative rods, small","parasitic","unknown");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1311","Bacteroides fragilis","GI, diverticulits","Eubacteria","Gram negative rods, thin","comensual","inflammation, abscess formation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1312","Yersinia pestis","systemic illness, Plague","Eubacteria","Gram negative rods","parasitic","replication within lymph nodes");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1313","Helicobacter pylori","GI, diarrheal illness","Eubacteria","Gram negative rods","parasitic","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1314","Vibrio cholera","GI, diarrheal illness","Eubacteria","Gram negative rods, helical","parasitic","toxin-mediated");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1401","Treponema pallidum","sexually transmitted disease","Eubacteria","spirochete","parasitic","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1402","Borrelia burgorferi","systemic illness, lyme disease","Eubacteria","spirochete","parasitic","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1501","Chlamydia trachomatis","pneumonia, atypical","Eubacteria","intracellular inclusion bodies","parasitic","cell lysis->inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1502","Rickettsia rickettsiae","systemic illness, Rocky Mountain Spotted Fever","Eubacteria","intracellular","parasitic","vascular injury");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1601","Mycobacterium tuberculosis","pneumonia","Eubacteria","acid-fast rods","parasitic","inflammation, chronic, granuloma formation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1602","Mycobacterium leprae","systemic illness, leprosy","Eubacteria","acid-fast rods","parasitic","inflammation, immune suppression, sensory loss->tissue injury");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2101","Poliovirus","systemic illness, paralytic polio","Virus","non-enveloped, icosahedral virion","parasitic","tissue destruction, neuronal");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("1503","Mycoplasma","pneumonia, atypical","Eubacteria","wall-less intracellular organisms","parasitic","tissue injury->inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2102","Rhinovirus","upper respiratory tract infection","Virus","non-enveloped, icosahedral virion","parasitic","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2103","Hepatitis A virus","Hepatitis","Virus","non-enveloped, icosahedral virion","parasitic","tissue injury, hepatic");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2104","Yellow Fever virus","systemic illness, hepatitis, Yellow Fever","Virus","enveloped, icosahedral capsid","parasitic","tissue injury, hepatic");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2105","Hepatitis C virus","Hepatitis","Virus","enveloped, icosahedral capsid","parasitic","tissue injury, hepatic");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2201","Rabies virus","CNS disease, rabies","Virus","enveloped, bullet-shaped virion","parasitic","tissue destruction, neuronal");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2202","Measles virus","upper respiratory tract infection","Virus","enveloped, irregular virion","parasitic","inflammation, immune suppression");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2203","Influenza virus","pneumonia","Virus","enveloped, irregular virion","parasitic","tissue destruction, respiratory epithelium");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2301","Rotavirus","GI, diarrheal illness","Virus","enveloped, icosahedral capsid","parasitic","tissue injury, intestinal epithelium");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2401","HIV","systemic illness, AIDS","Virus","enveloped, conical capsid","parasitic","cell lysis, T-cell->immune suppression");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2402","Hepatitis B virus","Hepatitis","Virus","enveloped, icosahedral capsid","parasitic","inflammation, hepatic");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2501","Parvovirus","systemic illness, intrauterine infection, Fifth disease","Virus","non-enveloped, icosahedral virion","parasitic","cell lysis, erythroid precursors");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2502","JC virus","CNS disease, PML, immunocompromised hosts","Virus","non-enveloped, icosahedral virion","parasitic","tissue destruction, neuronal");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2503","Papilloma virus","epithelial disease, Warts","Virus","non-enveloped, icosahedral virion","parasitic","neoplastic transformation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2504","Adenovirus","upper respiratory tract infection","Virus","non-enveloped, icosahedral virion","parasitic","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2601","Herpes Simplex virus","epithelial disease, cold sores, CNS disease","Virus","enveloped, icosahedral capsid","parasitic","tissue injury, epithelial, inflammation, neuronal");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2602","Cytomegalovirus","systemic illness, intrauterine infection, immunocompromised hosts","Virus","enveloped, icosahedral capsid","parasitic","multiple, depending on host and organ system");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2603","Epstein-Barr virus","systemic illness","Virus","enveloped, icosahedral capsid","parasitic","cytokine-mediated, neoplastic transformation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2604","Smallpox virus","systemic illness","Virus","enveloped, complex brick-shaped virion","parasitic","tissue injury, epithelial, inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("3101","Candida albicans","epithelial disease, sepsis in debilitated hosts","Fungi","budding yeast, dimorphic","opportunist","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("3102","Coccidiodies imitans","pneumonia, atypical","Fungi","budding yeast","opportunist","inflammation, pulmonary");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("3103","Cryptococcus neoformans","CNS disease, meningitis, immunocompromised hosts","Fungi","budding yeast","opportunist","inflammation, meningeal");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("3201","Aspergillus fumigatus","pneumonia, immunocompromised","Fungi","filamentous fungi","opportunist","tissue destruction, vascular invasion");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("3301","Pneumocystis carinii","pneumonia, immunocompromised","Fungi","polymorphic","opportunist","tissue injury, alveolar");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("4101","Toxoplasma gondii","systemic illness, intrauterine infection, CNS disease in immunocompromised hosts","Protozoa","polymorphic","parasitic","inflammation, systemic, CNS tissue injury in immunocompromised host");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("4102","Plasmodium falciparum","systemic illness, malaria","Protozoa","polymorphic","parasitic","cell lysis, red cells ->inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("4201","Entamoeba histolytica","GI, diarrheal illness","Protozoa","amoeba","parasitic","tissue injury, intestinal epithelium");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("4301","Trypanosoma brucei","systemic illness, Sleeping Sickness","Protozoa","flagellate trypanosome","parasitic","inflammation, CNS");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("4401","Giardia lamblia","GI illness","Protozoa","flagellate, binucleate","parasitic","tissue injury, intestinal epithelium");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("5101","Schistosoma mansoni","Mesenteric vein infestation","Metazoa","helminth","parasitic","inflammation, granuloma formation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("5102","Onchocerca volvulus","systemic illness, River Blindness, subcutaneous nodules","Metazoa","filarial worm","parasitic","tissue injury, ocular");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("5301","Taenia solium","GI illness","Metazoa","flatworm","parasitic","tissue injury, intestinal epithelium");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("5302","Dracunculis medinensis","soft tissue infestation","Metazoa","flatworm","parasitic","inflammation, local soft tissue, secondary infection");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("5201","Strongyloides stercoralis","GI illness","Metazoa","helminth","parasitic","tissue injury, intestinal epithelium");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("5202","Ascaris lumbroides","GI illness","Metazoa","roundworm","parasitic","tissue injury, intestinal epithelium");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("5401","Pediculus humanus","ectoparasite louse infestation","Metazoa","arthropod","parasitic","inflammation, superficial");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("5402","Dermatobia hominis","soft tissue infection, myiasis","Metazoa","arthropod","opportunist","inflammation, superficial");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2204","Ebola virus","systemic illness, hemorrhagic fever","Virus","enveloped, filamentous","parasitic","coagulopathy");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2106","Coronavirus urbanii","pneumonia, SARS","Virus","enveloped, icosahedral capsid","parasitic","inflammation");
INSERT INTO `pathogen_table3` (`id`,`name`,`disease`,`phylogeny`,`morphology`,`ecology`,`pathology`) VALUES ("2205","Hepatitis Delta virus","Hepatitis","Virus","enveloped, icosahedral capsid","parasitic","tissue injury, hepatic");


# Dump of table viral_pathogens
# ------------------------------------------------------------

CREATE TABLE `viral_pathogens` (
  `id` int(11) default NULL,
  `name` text,
  `RNA/DNA` text,
  `ss/ds` text,
  `+/-/both` text,
  `segmented?` text,
  `enveloped?` text,
  `capsid` text,
  `nuclear/cyto` text
) TYPE=MyISAM;

INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2101","Poliovirus","RNA","ss","+","no","no","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2102","Rhinovirus","RNA","ss","+","no","no","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2103","Hepatitis A virus","RNA","ss","+","no","no","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2104","Yellow Fever virus","RNA","ss","+","no","yes","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2105","Hepatitis C virus","RNA","ss","+","no","yes","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2201","Rabies virus","RNA","ss","-","no","yes","bullet-shaped",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2202","Measles virus","RNA","ss","-","no","yes","irrelgular",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2203","Influenza virus","RNA","ss","-","yes","yes","irregular",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2301","Rotavirus","RNA","ds","+","yes","yes","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2401","HIV","RNA->DNA","ss","+","diploid","yes","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2402","Hepatitis B virus","RNA->DNA","ss","+","no","yes","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2501","Parvovirus","DNA","ss","+","no","no","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2502","JC virus","DNA","ds","+","no","no","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2503","Papilloma virus","DNA","ds","+","no","no","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2504","Adenovirus","DNA","ds","both","no","no","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2601","Herpes Simplex virus","DNA","ds","both","no","yes","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2602","Cytomegalovirus","DNA","ds","both","no","yes","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2603","Epstein-Barr virus","DNA","ds","both","no","yes","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2604","Smallpox virus","DNA","ds","both","no","yes","complex","brick-shaped");
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2204","Ebola virus","DNA","ss","-","no","yes","filamentous",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2106","Coronavirus","RNA","ss","+","no","yes","icosahedral",NULL);
INSERT INTO `viral_pathogens` (`id`,`name`,`RNA/DNA`,`ss/ds`,`+/-/both`,`segmented?`,`enveloped?`,`capsid`,`nuclear/cyto`) VALUES ("2205","Hepatitis Delta virus","RNA","ss","-","no","yes","icosahedral",NULL);


# Dump of table virus_table
# ------------------------------------------------------------

CREATE TABLE `virus_table` (
  `id` int(11) default NULL,
  `name` text,
  `nucleotide_type` text,
  `ss_ds` text,
  `segmented` text,
  `genome_size` text,
  `coding_sense` text,
  `capsid_shape` text,
  `cell_location` text,
  `enveloped` text,
  `prevalence` int(11) default NULL,
  `virulence` int(11) default NULL,
  `image` text
) TYPE=MyISAM;

INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2101","Poliovirus","RNA","ss","no","small","+","cytoplasmic","icosahedral","no","1","3",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2102","Rhinovirus","RNA","ss","no","small","+","cytoplasmic","icosahedral","no","5","1",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2103","Hepatitis A virus","RNA","ss","no","small","+","cytoplasmic","icosahedral","no","3","3",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2104","Yellow Fever virus","RNA","ss","no","small","+","cytoplasmic","icosahedral","yes","2","4",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2105","Hepatitis C virus","RNA","ss","no","small","+","cytoplasmic","icosahedral","yes","3","3",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2106","Coronavirus","RNA","ss","no","medium","+","cytoplasmic","icosahedral","yes","4","2",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2201","Rabies virus","RNA","ss","no","small","-","cytoplasmic","bullet-shaped","yes","2","5",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2202","Measles virus","RNA","ss","no","small","-","cytoplasmic","pleomorphic","yes","3","4",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2203","Influenza virus","RNA","ss","yes","small","-","nuclear","pleomorphic","yes","5","4",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2204","Ebola virus","DNA","ss","no","small","-","cytoplasmic","filamentous","yes","1","5",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2205","Hepatitis Delta virus","RNA","ss","no","small","-","cytoplasmic","icosahedral","yes","1","4",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2301","Rotavirus","RNA","ds","yes","medium","+","cytoplasmic","icosahedral","no","5","3",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2401","HIV","RNA->DNA","ss","diploid","small","+","nuclear","conical","yes","3","5",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2402","Hepatitis B virus","RNA->DNA","ss","no","small","+","nuclear","icosahedral","yes","4","4",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2501","Parvovirus","DNA","ss","no","small","+","nuclear","icosahedral","no","2","3",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2502","JC virus","DNA","ds","no","small","+","nuclear","icosahedral","no","1","3",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2503","Papilloma virus","DNA","ds","no","small","+","nuclear","icosahedral","no","5","3",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2504","Adenovirus","DNA","ds","no","medium","both","nuclear","icosahedral","no","4","2",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2601","Herpes Simplex virus","DNA","ds","no","large","both","nuclear","icosahedral","yes","5","3",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2602","Cytomegalovirus","DNA","ds","no","large","both","nuclear","icosahedral","yes","5","2",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2603","Epstein-Barr virus","DNA","ds","no","large","both","nuclear","icosahedral","yes","4","2",NULL);
INSERT INTO `virus_table` (`id`,`name`,`nucleotide_type`,`ss_ds`,`segmented`,`genome_size`,`coding_sense`,`capsid_shape`,`cell_location`,`enveloped`,`prevalence`,`virulence`,`image`) VALUES ("2604","Smallpox virus","DNA","ds","no","large","both","cytoplasmic","complex","yes","1","4",NULL);


# Dump of table virus_table2
# ------------------------------------------------------------

CREATE TABLE `virus_table2` (
  `id` int(11) default NULL,
  `name` text,
  `nucleotide_type` text,
  `ss/ds` text,
  `segmented` text,
  `genome_size` text,
  `coding_sense` text,
  `cell_location` text,
  `capsid_shape` text,
  `enveloped` text
) TYPE=MyISAM;

INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2101","Poliovirus","RNA","ss","no","small","+","cytoplasmic","icosahedral","no");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2102","Rhinovirus","RNA","ss","no","small","+","cytoplasmic","icosahedral","no");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2103","Hepatitis A virus","RNA","ss","no","small","+","cytoplasmic","icosahedral","no");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2104","Yellow Fever virus","RNA","ss","no","small","+","cytoplasmic","icosahedral","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2105","Hepatitis C virus","RNA","ss","no","small","+","cytoplasmic","icosahedral","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2106","Coronavirus","RNA","ss","no","medium","+","cytoplasmic","icosahedral","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2201","Rabies virus","RNA","ss","no","small","-","cytoplasmic","bullet-shaped","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2202","Measles virus","RNA","ss","no","small","-","cytoplasmic","pleomorphoc","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2203","Influenza virus","RNA","ss","yes","small","-","nuclear","pleomorphic","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2204","Ebola virus","DNA","ss","no","small","-","cytoplasmic","filamentous","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2205","Hepatitis Delta virus","RNA","ss","no","small","-","cytoplasmic","icosahedral","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2301","Rotavirus","RNA","ds","yes","medium","+","cytoplasmic","icosahedral","no");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2401","HIV","RNA->DNA","ss","diploid","small","+","nuclear","conical","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2402","Hepatitis B virus","RNA->DNA","ss","no","small","+","nuclear","icosahedral","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2501","Parvovirus","DNA","ss","no","small","+","nuclear","icosahedral","no");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2502","JC virus","DNA","ds","no","small","+","nuclear","icosahedral","no");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2503","Papilloma virus","DNA","ds","no","small","+","nuclear","icosahedral","no");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2504","Adenovirus","DNA","ds","no","medium","both","nuclear","icosahedral","no");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2601","Herpes Simplex virus","DNA","ds","no","large","both","nuclear","icosahedral","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2602","Cytomegalovirus","DNA","ds","no","large","both","nuclear","icosahedral","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2603","Epstein-Barr virus","DNA","ds","no","large","both","nuclear","icosahedral","yes");
INSERT INTO `virus_table2` (`id`,`name`,`nucleotide_type`,`ss/ds`,`segmented`,`genome_size`,`coding_sense`,`cell_location`,`capsid_shape`,`enveloped`) VALUES ("2604","Smallpox virus","DNA","ds","no","large","both","cytoplasmic","complex","yes");


