-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 30, 2008 at 12:06 PM
-- Server version: 4.1.20
-- PHP Version: 4.3.9
-- 
-- Database: `MESOPHILES`
-- 
CREATE DATABASE `MESOPHILES` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE MESOPHILES;

-- --------------------------------------------------------

-- 
-- Table structure for table `ALDOLASE`
-- 

CREATE TABLE `ALDOLASE` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `HELIX` varchar(4) NOT NULL default '',
  `SHEET` varchar(4) NOT NULL default '',
  `SS BOND` varchar(4) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `ALDOLASE`
-- 

INSERT INTO `ALDOLASE` VALUES ('1DXE', 'ESCHERICHIA COLI', '26', '2', '0');

-- --------------------------------------------------------

-- 
-- Table structure for table `ALDOLASECOMPOSITION`
-- 

CREATE TABLE `ALDOLASECOMPOSITION` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `RES-NO` int(4) NOT NULL default '0',
  `POLAR` int(4) NOT NULL default '0',
  `NONPOLAR` int(4) NOT NULL default '0',
  `ACIDIC` int(4) NOT NULL default '0',
  `BASIC` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `ALDOLASECOMPOSITION`
-- 

INSERT INTO `ALDOLASECOMPOSITION` VALUES ('1DXE', 'ESCHERICHIA COLI', 512, 112, 294, 52, 54);

-- --------------------------------------------------------

-- 
-- Table structure for table `ALDOLASEHELIX`
-- 

CREATE TABLE `ALDOLASEHELIX` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `R-@` int(2) NOT NULL default '0',
  `R-omg` int(2) NOT NULL default '0',
  `RT- pi` int(2) NOT NULL default '0',
  `R-gamma` int(2) NOT NULL default '0',
  `RT 3/10` int(2) NOT NULL default '0',
  `L-@` int(2) NOT NULL default '0',
  `L-omg` int(2) NOT NULL default '0',
  `L-gma` int(2) NOT NULL default '0',
  `27ribn` int(2) NOT NULL default '0',
  `plypro` int(2) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `ALDOLASEHELIX`
-- 

INSERT INTO `ALDOLASEHELIX` VALUES ('1DXE', 'ESCHERICHIA COLI', 24, 0, 0, 0, 2, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `HYDROLASE`
-- 

CREATE TABLE `HYDROLASE` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `HELIX` varchar(4) NOT NULL default '',
  `SHEET` varchar(4) NOT NULL default '',
  `SS BOND` varchar(4) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `HYDROLASE`
-- 

INSERT INTO `HYDROLASE` VALUES ('1A3H', 'BACILLUS AGARADHERANS;', '12', '4', '0');
INSERT INTO `HYDROLASE` VALUES ('1AH7', 'BACILLUS CEREUS', '9', '0', '0');
INSERT INTO `HYDROLASE` VALUES ('1CTW', 'BACTERIOPHAGE T4;', '11', '1', '0');
INSERT INTO `HYDROLASE` VALUES ('1EXP', 'CELLULOMONAS FIMI;', '15', '3', '2');
INSERT INTO `HYDROLASE` VALUES ('1UA7', 'BACILLUS SUBTILIS;', '20', '5', '0');
INSERT INTO `HYDROLASE` VALUES ('1Y7B', 'CLOSTRIDIUM ACETOBUTYLICUM ATCC 824;', '4', '47', '0');
INSERT INTO `HYDROLASE` VALUES ('1YIF', 'BACILLUS SUBTILIS;', '4', '51', '0');
INSERT INTO `HYDROLASE` VALUES ('2BKV', 'CHERICHIA COLI;', '28', '4', '0');
INSERT INTO `HYDROLASE` VALUES ('2FHM', 'BACILLUS SUBTILIS;', '2', '1', '0');

-- --------------------------------------------------------

-- 
-- Table structure for table `HYDROLASECOMPOSITION`
-- 

CREATE TABLE `HYDROLASECOMPOSITION` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `RES-NO` int(4) NOT NULL default '0',
  `POLAR` int(4) NOT NULL default '0',
  `NONPOLAR` int(4) NOT NULL default '0',
  `ACIDIC` int(4) NOT NULL default '0',
  `BASIC` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `HYDROLASECOMPOSITION`
-- 

INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1A3H', 'BACILLUS AGARADHERANS;', 300, 78, 146, 50, 26);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1AH7', 'BACILLUS CEREUS', 245, 73, 105, 32, 35);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1BGL', 'ESCHERICHIA COLI                        1BGL', 9448, 2144, 4072, 1008, 960);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1BGL', 'ESCHERICHIA COLI                        1BGL', 9448, 2144, 4072, 1008, 960);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1CTW', 'BACTERIOPHAGE T4;', 164, 41, 78, 18, 27);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1EXP', 'CELLULOMONAS FIMI;', 312, 74, 161, 40, 37);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1PBG', 'LACTOCOCCUS LACTIS;                     1PBG', 1080, 212, 436, 154, 134);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1UA7', 'BACILLUS SUBTILIS;', 422, 142, 187, 48, 45);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1Y7B', 'CLOSTRIDIUM ACETOBUTYLICUM ATCC 824;', 2168, 636, 944, 276, 312);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1YIF', 'BACILLUS SUBTILIS;', 2132, 584, 972, 288, 288);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('2BKV', 'CHERICHIA COLI;', 484, 138, 214, 64, 68);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('2FHM', 'BACILLUS SUBTILIS;', 91, 20, 44, 12, 15);

-- --------------------------------------------------------

-- 
-- Table structure for table `HYDROLASEHELIX`
-- 

CREATE TABLE `HYDROLASEHELIX` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `R-@` int(2) NOT NULL default '0',
  `R-omg` int(2) NOT NULL default '0',
  `RT- pi` int(2) NOT NULL default '0',
  `R-gamma` int(2) NOT NULL default '0',
  `RT 3/10` int(2) NOT NULL default '0',
  `L-@` int(2) NOT NULL default '0',
  `L-omg` int(2) NOT NULL default '0',
  `L-gma` int(2) NOT NULL default '0',
  `27ribn` int(2) NOT NULL default '0',
  `plypro` int(2) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `HYDROLASEHELIX`
-- 

INSERT INTO `HYDROLASEHELIX` VALUES ('1A3H', 'BACILLUS AGARADHERANS;', 10, 0, 0, 0, 2, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1AH7', 'BACILLUS CEREUS', 9, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1BGL', 'ESCHERICHIA COLI                        1BGL', 95, 0, 0, 0, 86, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1CTW', 'BACTERIOPHAGE T4;', 10, 0, 0, 0, 1, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1EXP', 'CELLULOMONAS FIMI;', 12, 0, 0, 0, 3, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1PBG', 'LACTOCOCCUS LACTIS;                     1PBG', 28, 0, 0, 0, 6, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1UA7', 'BACILLUS SUBTILIS;', 13, 0, 0, 0, 7, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1Y7B', 'CLOSTRIDIUM ACETOBUTYLICUM ATCC 824;', 0, 0, 0, 0, 4, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1YIF', 'BACILLUS SUBTILIS;', 0, 0, 0, 0, 4, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('2BKV', 'CHERICHIA COLI;', 14, 0, 0, 0, 14, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('2FHM', 'BACILLUS SUBTILIS;', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('2FHM', 'BACILLUS SUBTILIS;', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `LIGASE`
-- 

CREATE TABLE `LIGASE` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `HELIX` varchar(4) NOT NULL default '',
  `SHEET` varchar(4) NOT NULL default '',
  `SS BOND` varchar(4) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `LIGASE`
-- 

INSERT INTO `LIGASE` VALUES ('2GPS', 'ESCHERICHIA COLI;', '34', '12', '0');
INSERT INTO `LIGASE` VALUES ('1CQJ', 'ESCHERICHIA COLI;', '52', '16', '0');
INSERT INTO `LIGASE` VALUES ('1CQI', 'ESCHERICHIA COLI;', '53', '17', '0');

-- --------------------------------------------------------

-- 
-- Table structure for table `LIGASECOMPOSITION`
-- 

CREATE TABLE `LIGASECOMPOSITION` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `RES-NO` int(4) NOT NULL default '0',
  `POLAR` int(4) NOT NULL default '0',
  `NONPOLAR` int(4) NOT NULL default '0',
  `ACIDIC` int(4) NOT NULL default '0',
  `BASIC` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `LIGASECOMPOSITION`
-- 

INSERT INTO `LIGASECOMPOSITION` VALUES ('1CQI', 'ESCHERICHIA COLI;', 1342, 254, 780, 154, 154);
INSERT INTO `LIGASECOMPOSITION` VALUES ('1CQJ', 'ESCHERICHIA COLI;', 1342, 254, 780, 154, 154);
INSERT INTO `LIGASECOMPOSITION` VALUES ('2GPS', 'ESCHERICHIA COLI;', 938, 186, 492, 110, 150);

-- --------------------------------------------------------

-- 
-- Table structure for table `LIGASEHELIX`
-- 

CREATE TABLE `LIGASEHELIX` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `R-@` int(2) NOT NULL default '0',
  `R-omg` int(2) NOT NULL default '0',
  `RT- pi` int(2) NOT NULL default '0',
  `R-gamma` int(2) NOT NULL default '0',
  `RT 3/10` int(2) NOT NULL default '0',
  `L-@` int(2) NOT NULL default '0',
  `L-omg` int(2) NOT NULL default '0',
  `L-gma` int(2) NOT NULL default '0',
  `27ribn` int(2) NOT NULL default '0',
  `plypro` int(2) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `LIGASEHELIX`
-- 

INSERT INTO `LIGASEHELIX` VALUES ('2GPS', 'ESCHERICHIA COLI;', 30, 0, 0, 0, 4, 0, 0, 0, 0, 0);
INSERT INTO `LIGASEHELIX` VALUES ('1CQI', 'ESCHERICHIA COLI;', 44, 0, 0, 0, 9, 0, 0, 0, 0, 0);
INSERT INTO `LIGASEHELIX` VALUES ('1CQJ', 'ESCHERICHIA COLI;', 44, 0, 0, 0, 8, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `OXIDOREDUCTASE`
-- 

CREATE TABLE `OXIDOREDUCTASE` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `HELIX` varchar(4) NOT NULL default '',
  `SHEET` varchar(4) NOT NULL default '',
  `SS BOND` varchar(4) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `OXIDOREDUCTASE`
-- 

INSERT INTO `OXIDOREDUCTASE` VALUES ('1E7P', 'WOLINELLA SUCCINOGENES;', '176', '20', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1EZ4', 'LACTOBACILLUS PENTOSUS;', '60', '16', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1HQS', 'BACILLUS SUBTILIS;', '40', '9', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1HSK', 'STAPHYLOCOCCUS AUREUS;', '12', '6', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1L8A', 'ESCHERICHIA COLI;', '85', '7', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1PED', 'CLOSTRIDIUM BEIJERINCKII;', '60', '18', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1V5E', 'AEROCOCCUS VIRIDANS;', '31', '4', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('2B5W', 'HALOFERAX MEDITERRANEI;', '15', '5', '0');

-- --------------------------------------------------------

-- 
-- Table structure for table `OXIDOREDUCTASECOMPOSITION`
-- 

CREATE TABLE `OXIDOREDUCTASECOMPOSITION` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `RES-NO` int(4) NOT NULL default '0',
  `POLAR` int(4) NOT NULL default '0',
  `NONPOLAR` int(4) NOT NULL default '0',
  `ACIDIC` int(4) NOT NULL default '0',
  `BASIC` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `OXIDOREDUCTASECOMPOSITION`
-- 

INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1GAD', 'ESCHERICHIA COLI;                       1GAD', 764, 152, 338, 80, 90);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1HQS', 'BACILLUS SUBTILIS;', 846, 180, 440, 122, 102);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1HSK', 'STAPHYLOCOCCUS AUREUS;', 326, 83, 155, 42, 46);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1L8A', 'ESCHERICHIA COLI;', 1772, 424, 862, 246, 240);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1LPF', '', 1102, 172, 548, 108, 126);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1PED', 'CLOSTRIDIUM BEIJERINCKII;', 1404, 236, 828, 152, 188);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1TRE', '', 590, 98, 288, 60, 64);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1V5E', 'AEROCOCCUS VIRIDANS;', 590, 137, 306, 82, 65);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('2B5W', 'HALOFERAX MEDITERRANEI;', 357, 63, 190, 63, 41);

-- --------------------------------------------------------

-- 
-- Table structure for table `OXIDOREDUCTASEHELIX`
-- 

CREATE TABLE `OXIDOREDUCTASEHELIX` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `R-@` int(2) NOT NULL default '0',
  `R-omg` int(2) NOT NULL default '0',
  `RT pi` int(2) NOT NULL default '0',
  `R-gamma` int(2) NOT NULL default '0',
  `RT 3/10` int(2) NOT NULL default '0',
  `L-@` int(2) NOT NULL default '0',
  `L-omg` int(2) NOT NULL default '0',
  `L-gma` int(2) NOT NULL default '0',
  `27ribn` int(2) NOT NULL default '0',
  `plypro` int(2) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `OXIDOREDUCTASEHELIX`
-- 

INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1E7P', 'WOLINELLA SUCCINOGENES;', 144, 0, 0, 0, 32, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1EMD', '', 9, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1EZ4', 'LACTOBACILLUS PENTOSUS;', 36, 0, 0, 0, 24, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1GAD', 'ESCHERICHIA COLI;                       1GAD', 14, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1HQS', 'BACILLUS SUBTILIS;', 30, 0, 0, 0, 10, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1HSK', 'STAPHYLOCOCCUS AUREUS;', 9, 0, 0, 0, 3, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1L8A', 'ESCHERICHIA COLI;', 65, 0, 0, 0, 20, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1LPF', '', 22, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1PED', 'CLOSTRIDIUM BEIJERINCKII;', 36, 0, 0, 0, 24, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1TRE', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1V5E', 'AEROCOCCUS VIRIDANS;', 21, 0, 0, 0, 10, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('2B5W', 'HALOFERAX MEDITERRANEI;', 10, 0, 0, 0, 5, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `TRANSFERASE`
-- 

CREATE TABLE `TRANSFERASE` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `HELIX` varchar(4) NOT NULL default '',
  `SHEET` varchar(4) NOT NULL default '',
  `SS BOND` varchar(4) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `TRANSFERASE`
-- 

INSERT INTO `TRANSFERASE` VALUES ('1DCZ', 'PROPIONIBACTERIUM FREUDENREICHII', '0', '2', '0');
INSERT INTO `TRANSFERASE` VALUES ('1DKR', 'BACILLUS SUBTILIS;', '20', '7', '0');
INSERT INTO `TRANSFERASE` VALUES ('1G0R', 'PSEUDOMONAS AERUGINOSA;', '133', '35', '0');
INSERT INTO `TRANSFERASE` VALUES ('1KZH', 'BORRELIA BURGDORFERI;', '51', '7', '0');
INSERT INTO `TRANSFERASE` VALUES ('1MOS', 'ESCHERICHIA COLI;', '16', '2', '0');
INSERT INTO `TRANSFERASE` VALUES ('1PIE', 'LACTOCOCCUS LACTIS;', '14', '3', '0');
INSERT INTO `TRANSFERASE` VALUES ('1Q18', 'ESCHERICHIA COLI;', '36', '6', '0');
INSERT INTO `TRANSFERASE` VALUES ('1R5J', 'STREPTOCOCCUS PYOGENES;', '28', '4', '0');
INSERT INTO `TRANSFERASE` VALUES ('1TO6', 'NEISSERIA MENINGITIDIS (SEROGROUP A);', '34', '8', '0');
INSERT INTO `TRANSFERASE` VALUES ('1ZMR', 'ESCHERICHIA COLI;', '21', '4', '0');
INSERT INTO `TRANSFERASE` VALUES ('2H12', 'ACETOBACTER ACETI;', '135', '9', '0');
INSERT INTO `TRANSFERASE` VALUES ('2JG5', 'CHERICHIA COLI;', '24', '7', '0');

-- --------------------------------------------------------

-- 
-- Table structure for table `TRANSFERASECOMPOSITION`
-- 

CREATE TABLE `TRANSFERASECOMPOSITION` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `RES-NO` int(4) NOT NULL default '0',
  `POLAR` int(4) NOT NULL default '0',
  `NONPOLAR` int(4) NOT NULL default '0',
  `ACIDIC` int(4) NOT NULL default '0',
  `BASIC` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `TRANSFERASECOMPOSITION`
-- 

INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1KZH', 'BORRELIA BURGDORFERI;', 1110, 268, 550, 142, 150);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1MOS', 'ESCHERICHIA COLI;', 368, 85, 189, 48, 46);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1PIE', 'LACTOCOCCUS LACTIS;', 419, 97, 207, 61, 54);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1Q18', 'ESCHERICHIA COLI;', 664, 116, 364, 74, 98);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1R5J', 'STREPTOCOCCUS PYOGENES;', 674, 136, 352, 90, 76);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1TO6', 'NEISSERIA MENINGITIDIS (SEROGROUP A);', 742, 164, 404, 96, 78);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1ZMR', 'ESCHERICHIA COLI;', 387, 69, 215, 55, 48);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('2H12', 'ACETOBACTER ACETI;', 2616, 606, 1422, 258, 330);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('2JG5', 'CHERICHIA COLI;', 612, 168, 314, 76, 54);

-- --------------------------------------------------------

-- 
-- Table structure for table `TRANSFERASEHELIX`
-- 

CREATE TABLE `TRANSFERASEHELIX` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `R-@` int(2) NOT NULL default '0',
  `R-omg` int(2) NOT NULL default '0',
  `RT pi` int(2) NOT NULL default '0',
  `R-gamma` int(2) NOT NULL default '0',
  `RT 3/10` int(2) NOT NULL default '0',
  `L-@` int(2) NOT NULL default '0',
  `L-omg` int(2) NOT NULL default '0',
  `L-gma` int(2) NOT NULL default '0',
  `27ribn` int(2) NOT NULL default '0',
  `plypro` int(2) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `TRANSFERASEHELIX`
-- 

INSERT INTO `TRANSFERASEHELIX` VALUES ('1DCZ', 'PROPIONIBACTERIUM FREUDENREICHII', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1DKR', 'BACILLUS SUBTILIS;', 16, 0, 0, 0, 4, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1G0R', 'PSEUDOMONAS AERUGINOSA;', 91, 0, 0, 0, 42, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1KZH', 'BORRELIA BURGDORFERI;', 43, 0, 0, 0, 8, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1MOS', 'ESCHERICHIA COLI;', 10, 0, 0, 0, 6, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1PIE', 'LACTOCOCCUS LACTIS;', 11, 0, 0, 0, 3, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1Q18', 'ESCHERICHIA COLI;', 22, 0, 0, 0, 14, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1R5J', 'STREPTOCOCCUS PYOGENES;', 26, 0, 0, 0, 2, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1TO6', 'NEISSERIA MENINGITIDIS (SEROGROUP A);', 24, 0, 0, 0, 10, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1ZMR', 'ESCHERICHIA COLI;', 13, 0, 0, 0, 8, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('2H12', 'ACETOBACTER ACETI;', 108, 0, 0, 0, 27, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('2JG5', 'CHERICHIA COLI;', 20, 0, 0, 0, 4, 0, 0, 0, 0, 0);
