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

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

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

CREATE TABLE `ALDOLASE` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(40) NOT NULL default '',
  `HELIX` int(4) NOT NULL default '0',
  `SHEET` int(4) NOT NULL default '0',
  `S-S BONDS` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `ALDOLASE` VALUES ('1W37', 'ESCHERICHIA COLI;', 65, 4, 4);

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

-- 
-- 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 ('1W37', 'CHERICHIA COLI;', 1176, 264, 576, 160, 176);

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

-- 
-- 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 ('1W37', 'CHERICHIA COLI;', 48, 0, 0, 0, 17, 0, 0, 0, 0, 0);

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

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

CREATE TABLE `HYDROLASE` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(40) 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 ('1DK4', 'METHANOCOCCUS JANNASCHII;', '16', '6', '0');
INSERT INTO `HYDROLASE` VALUES ('1GOW', 'SULFOLOBUS SOLFATARICUS;', '44', '10', '0');
INSERT INTO `HYDROLASE` VALUES ('1MWO', 'PYROCOCCUS WOESEI;', '18', '6', '2');
INSERT INTO `HYDROLASE` VALUES ('1V3Z', 'PYROCOCCUS HORIKOSHII;', '4', '1', '0');
INSERT INTO `HYDROLASE` VALUES ('1VFF', 'PYROCOCCUS HORIKOSHII;', '18', '5', '0');
INSERT INTO `HYDROLASE` VALUES ('2DBT', 'STREPTOMYCES GRISEUS;', '33', '0', '6');
INSERT INTO `HYDROLASE` VALUES ('2G3M', 'SULFOLOBUS SOLFATARICUS;', '114', '61', '0');
INSERT INTO `HYDROLASE` VALUES ('2NYV', 'AQUIFEX AEOLICUS;', '14', '3', '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 ('1DK4', 'METHANOCOCCUS JANNASCHII;', 504, 112, 248, 76, 68);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1GOW', 'SULFOLOBUS SOLFATARICUS;', 978, 256, 462, 124, 136);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1MWO', 'PYROCOCCUS WOESEI;', 435, 107, 227, 56, 45);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1V3Z', 'PYROCOCCUS HORIKOSHII;', 182, 20, 106, 22, 34);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1VFF', 'PYROCOCCUS HORIKOSHII;', 423, 89, 210, 53, 71);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('2DBT', 'STREPTOMYCES GRISEUS;', 795, 294, 387, 54, 60);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('2G3M', 'SULFOLOBUS SOLFATARICUS;', 4158, 942, 2022, 600, 594);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('2NYV', 'AQUIFEX AEOLICUS;', 222, 39, 109, 36, 36);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('2NYV', 'AQUIFEX AEOLICUS;', 222, 39, 109, 36, 36);

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

-- 
-- 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 ('1DK4', 'METHANOCOCCUS JANNASCHII;', 14, 0, 0, 0, 2, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1GOW', 'SULFOLOBUS SOLFATARICUS;', 28, 0, 0, 0, 16, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1MWO', 'PYROCOCCUS WOESEI;', 12, 0, 0, 0, 6, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1V3Z', 'PYROCOCCUS HORIKOSHII;', 4, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1VFF', 'PYROCOCCUS HORIKOSHII;', 14, 0, 0, 0, 4, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('2DBT', 'STREPTOMYCES GRISEUS;', 28, 0, 0, 0, 5, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('2G3M', 'SULFOLOBUS SOLFATARICUS;', 73, 0, 0, 0, 41, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('2NYV', 'AQUIFEX AEOLICUS;', 8, 0, 0, 0, 6, 0, 0, 0, 0, 0);

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

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

CREATE TABLE `LIGASE` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(40) NOT NULL default '',
  `HELIX` int(4) NOT NULL default '0',
  `SHEET` int(4) NOT NULL default '0',
  `S-S BONDS` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `LIGASE` VALUES ('1ULZ', 'AQUIFEX AEOLICUS;', 18, 5, 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 ('1ULZ', 'AQUIFEX AEOLICUS;', 451, 85, 230, 68, 68);

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

-- 
-- 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 ('1ULZ', 'AQUIFEX AEOLICUS;', 15, 0, 0, 0, 3, 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 ('1B7G', 'SULFOLOBUS SOLFATARICUS;', '30', '6', '2');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1H2B', 'AEROPYRUM PERNIX;', '30', '8', '2');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1VJ0', 'THERMOTOGA MARITIMA;', '55', '20', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1WW8', 'PYROCOCCUS HORIKOSHII;', '49', '5', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1XGV', 'AEROPYRUM PERNIX;', '37', '5', '2');
INSERT INTO `OXIDOREDUCTASE` VALUES ('2CD9', 'CHERICHIA COLI;', '34', '10', '2');

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

-- 
-- 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 ('1B7G', 'SULFOLOBUS SOLFATARICUS;', 680, 160, 338, 82, 100);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1H2B', 'AEROPYRUM PERNIX;', 718, 108, 398, 104, 108);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1VJ0', 'THERMOTOGA MARITIMA;', 1520, 292, 796, 196, 236);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1WW8', 'PYROCOCCUS HORIKOSHII;', 878, 140, 488, 118, 120);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1XGV', 'AEROPYRUM PERNIX;', 870, 160, 482, 110, 118);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('2CD9', 'CHERICHIA COLI;', 732, 158, 370, 96, 108);

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

-- 
-- 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 ('1B7G', 'SULFOLOBUS SOLFATARICUS;', 23, 0, 0, 0, 7, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1H2B', 'AEROPYRUM PERNIX;', 24, 0, 0, 0, 6, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1VJ0', 'THERMOTOGA MARITIMA;', 48, 0, 0, 0, 7, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1WW8', 'PYROCOCCUS HORIKOSHII;', 39, 0, 0, 0, 10, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1XGV', 'AEROPYRUM PERNIX;', 29, 0, 0, 0, 8, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('2CD9', 'CHERICHIA COLI;', 22, 0, 0, 0, 12, 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 ('1K1X', 'THERMOCOCCUS LITORALIS;', '58', '13', '0');
INSERT INTO `TRANSFERASE` VALUES ('1L2L', 'PYROCOCCUS HORIKOSHII;', '22', '4', '0');
INSERT INTO `TRANSFERASE` VALUES ('1S4E', 'PYROCOCCUS FURIOSUS;', '105', '30', '0');
INSERT INTO `TRANSFERASE` VALUES ('1U9Y', 'METHANOCALDOCOCCUS JANNASCHII;', '40', '12', '0');
INSERT INTO `TRANSFERASE` VALUES ('1W4J', 'CHERICHIA COLI;', '2', '0', '0');
INSERT INTO `TRANSFERASE` VALUES ('2D5D', 'PYROCOCCUS HORIKOSHII;', '0', '4', '0');
INSERT INTO `TRANSFERASE` VALUES ('2IE8', 'THERMUS CALDOPHILUS;', '23', '3', '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 ('1K1X', 'THERMOCOCCUS LITORALIS;', 1318, 236, 652, 222, 208);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1L2L', 'PYROCOCCUS HORIKOSHII;', 457, 74, 235, 72, 76);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1S4E', 'PYROCOCCUS FURIOSUS;', 3168, 648, 1575, 441, 468);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1U9Y', 'METHANOCALDOCOCCUS JANNASCHII;', 1136, 248, 572, 164, 152);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1W4J', 'CHERICHIA COLI;', 51, 6, 29, 7, 9);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('2D5D', 'PYROCOCCUS HORIKOSHII;', 148, 16, 92, 20, 20);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('2IE8', 'THERMUS CALDOPHILUS;', 390, 42, 240, 55, 53);

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

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

CREATE TABLE `TRANSFERASEHELIX` (
  `PDBID` varchar(4) NOT NULL default '',
  `SOURCE` varchar(44) NOT NULL default '',
  `R-@` char(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-@` char(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 ('1K1X', 'THERMOCOCCUS LITORALIS;', '40', 0, 0, 0, 18, '0', 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1S4E', 'PYROCOCCUS FURIOSUS;', '90', 0, 0, 0, 15, '0', 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1U9Y', 'METHANOCALDOCOCCUS JANNASCHII;', '32', 0, 0, 0, 8, '0', 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1W4J', 'CHERICHIA COLI;', '2', 0, 0, 0, 0, '0', 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('2D5D', 'PYROCOCCUS HORIKOSHII;', '0', 0, 0, 0, 0, '0', 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('2IE8', 'THERMUS CALDOPHILUS;', '13', 0, 0, 0, 10, '0', 0, 0, 0, 0);
-- 
-- 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);
-- 
-- Database: `PSYCHROPHILES`
-- 
CREATE DATABASE `PSYCHROPHILES` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE PSYCHROPHILES;

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

-- 
-- 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 ('1KFW', 'ARTHROBACTER SP.;', '17', '5', '1');
INSERT INTO `HYDROLASE` VALUES ('1TVN', 'PSEUDOALTEROMONAS HALOPLANKTIS;', '22', '4', '0');
INSERT INTO `HYDROLASE` VALUES ('2HDO', 'LACTOBACILLUS PLANTARUM;', '16', '2', '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 ('1KFW', 'ARTHROBACTER SP.;', 435, 116, 228, 44, 47);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1TVN', 'PSEUDOALTEROMONAS HALOPLANKTIS;', 586, 176, 292, 68, 50);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('2HDO', 'LACTOBACILLUS PLANTARUM;', 209, 54, 97, 27, 20);

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

-- 
-- 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-@` char(2) NOT NULL default '',
  `L-omg` char(2) NOT NULL default '',
  `L-gma` char(2) NOT NULL default '',
  `27ribn` char(2) NOT NULL default '',
  `plypro` char(2) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `HYDROLASEHELIX` VALUES ('1KFW', 'ARTHROBACTER SP.;', 11, 0, 0, 0, 6, '0', '0', '0', '0', '0');
INSERT INTO `HYDROLASEHELIX` VALUES ('1TVN', 'PSEUDOALTEROMONAS HALOPLANKTIS;', 18, 0, 0, 0, 4, '0', '0', '0', '0', '0');
INSERT INTO `HYDROLASEHELIX` VALUES ('2HDO', 'LACTOBACILLUS PLANTARUM;', 8, 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 ('1GCO', 'BACILLUS MEGATERIUM;', '74', '4', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1Y0P', 'SHEWANELLA FRIGIDIMARINA;', '25', '6', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1Y9D', 'LACTOBACILLUS PLANTARUM;', '109', '19', '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 ('1GCO', 'BACILLUS MEGATERIUM;', 1044, 236, 560, 136, 112);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1LLC', '', 375, 72, 170, 43, 40);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1Y0P', 'SHEWANELLA FRIGIDIMARINA;', 571, 136, 287, 69, 79);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1Y9D', 'LACTOBACILLUS PLANTARUM;', 2412, 584, 1288, 276, 264);

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

-- 
-- 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-@` char(2) NOT NULL default '',
  `L-omg` char(2) NOT NULL default '',
  `L-gma` char(2) NOT NULL default '',
  `27ribn` char(2) NOT NULL default '',
  `plypro` char(2) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1GCO', 'BACILLUS MEGATERIUM;', 36, 0, 0, 0, 38, '0', '0', '0', '0', '0');
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1LLC', '', 9, 0, 0, 0, 1, '0', '0', '0', '0', '0');
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1Y0P', 'SHEWANELLA FRIGIDIMARINA;', 18, 0, 0, 0, 7, '0', '0', '0', '0', '0');
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1Y9D', 'LACTOBACILLUS PLANTARUM;', 84, 0, 0, 0, 25, '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 ('1NRZ', 'KLEBSIELLA PNEUMONIAE;', '32', '8', '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 ('1BOI', 'BOS TAURUS;', 296, 61, 153, 37, 44);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1NRZ', 'KLEBSIELLA PNEUMONIAE;', 656, 160, 332, 76, 88);

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

-- 
-- 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-@` char(2) NOT NULL default '',
  `L-omg` char(2) NOT NULL default '',
  `L-gma` char(2) NOT NULL default '',
  `27ribn` char(2) NOT NULL default '',
  `plypro` char(2) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `TRANSFERASEHELIX` VALUES ('1BOI', 'BOS TAURUS;', 9, 0, 0, 0, 4, '0', '0', '0', '0', '0');
INSERT INTO `TRANSFERASEHELIX` VALUES ('1NRZ', 'KLEBSIELLA PNEUMONIAE;', 28, 0, 0, 0, 4, '0', '0', '0', '0', '0');
-- 
-- Database: `THERMOPHILES`
-- 
CREATE DATABASE `THERMOPHILES` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE THERMOPHILES;

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

-- 
-- 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 ('1BLI', 'BACILLUS LICHENIFORMIS;', '14', '4', '0');
INSERT INTO `HYDROLASE` VALUES ('1J5X', 'THERMOTOGA MARITIMA;', '17', '2', '0');
INSERT INTO `HYDROLASE` VALUES ('1KWG', 'THERMUS THERMOPHILUS;', '25', '5', '0');
INSERT INTO `HYDROLASE` VALUES ('1LBV', 'ARCHAEOGLOBUS FULGIDUS;', '17', '5', '0');
INSERT INTO `HYDROLASE` VALUES ('1O12', 'THERMOTOGA MARITIMA;', '21', '10', '0');
INSERT INTO `HYDROLASE` VALUES ('1OBB', 'THERMOTOGA MARITIMA;', '52', '6', '0');
INSERT INTO `HYDROLASE` VALUES ('1OD0', 'THERMOTOGA MARITIMA;', '44', '6', '0');
INSERT INTO `HYDROLASE` VALUES ('1OLP', 'CLOSTRIDIUM ABSONUM;', '63', '9', '0');
INSERT INTO `HYDROLASE` VALUES ('1PX8', 'THERMOANAEROBACTERIUM SACCHAROLYTICUM;', '40', '14', '0');
INSERT INTO `HYDROLASE` VALUES ('1RQ5', 'CLOSTRIDIUM THERMOCELLUM;', '18', '5', '0');
INSERT INTO `HYDROLASE` VALUES ('1UHV', 'THERMOANAEROBACTERIUM SACCHAROLYTICUM;', '74', '28', '0');
INSERT INTO `HYDROLASE` VALUES ('1UMG', 'SULFOLOBUS TOKODAII;', '14', '4', '0');
INSERT INTO `HYDROLASE` VALUES ('1Y9O', 'SULFOLOBUS SOLFATARICUS;', '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 ('1BLI', 'BACILLUS LICHENIFORMIS;', 483, 127, 222, 61, 73);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1J5X', 'THERMOTOGA MARITIMA;', 342, 73, 156, 49, 55);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1KWG', 'THERMUS THERMOPHILUS;', 645, 102, 377, 81, 85);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1LBV', 'ARCHAEOGLOBUS FULGIDUS;', 504, 90, 256, 86, 72);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1O12', 'THERMOTOGA MARITIMA;', 752, 136, 352, 116, 128);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1OBB', 'THERMOTOGA MARITIMA;', 960, 184, 474, 150, 150);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1OD0', 'THERMOTOGA MARITIMA;', 936, 194, 474, 126, 142);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1OLP', 'CLOSTRIDIUM ABSONUM;', 1480, 448, 576, 240, 216);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1PX8', 'THERMOANAEROBACTERIUM SACCHAROLYTICUM;', 1000, 230, 468, 160, 142);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1RQ5', 'CLOSTRIDIUM THERMOCELLUM;', 610, 161, 302, 81, 66);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1UHV', 'THERMOANAEROBACTERIUM SACCHAROLYTICUM;', 2000, 460, 936, 320, 284);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1UMG', 'SULFOLOBUS TOKODAII;', 362, 60, 204, 47, 51);
INSERT INTO `HYDROLASECOMPOSITION` VALUES ('1Y9O', 'SULFOLOBUS SOLFATARICUS;', 103, 19, 51, 17, 16);

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

-- 
-- 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 ('1BLI', 'BACILLUS LICHENIFORMIS;', 10, 0, 0, 0, 4, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1J5X', 'THERMOTOGA MARITIMA;', 11, 0, 0, 0, 6, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1KWG', 'THERMUS THERMOPHILUS;', 18, 0, 0, 0, 7, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1LBV', 'ARCHAEOGLOBUS FULGIDUS;', 14, 0, 0, 0, 3, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1O12', 'THERMOTOGA MARITIMA;', 18, 0, 0, 0, 3, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1OBB', 'THERMOTOGA MARITIMA;', 36, 0, 0, 0, 16, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1OD0', 'THERMOTOGA MARITIMA;', 32, 0, 0, 0, 12, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1OLP', 'CLOSTRIDIUM ABSONUM;', 44, 0, 0, 0, 19, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1PX8', 'THERMOANAEROBACTERIUM SACCHAROLYTICUM;', 22, 0, 0, 0, 18, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1RQ5', 'CLOSTRIDIUM THERMOCELLUM;', 13, 0, 0, 0, 5, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1UHV', 'THERMOANAEROBACTERIUM SACCHAROLYTICUM;', 44, 0, 0, 0, 30, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1UMG', 'SULFOLOBUS TOKODAII;', 8, 0, 0, 0, 6, 0, 0, 0, 0, 0);
INSERT INTO `HYDROLASEHELIX` VALUES ('1Y9O', 'SULFOLOBUS SOLFATARICUS;', 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 ('1VRG', 'THERMOTOGA MARITIMA MSB8;', '181', '21', '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 ('1VRG', 'THERMOTOGA MARITIMA MSB8;', 3162, 570, 1620, 426, 462);

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

-- 
-- 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 ('1VRG', 'THERMOTOGA MARITIMA MSB8;', 120, 0, 0, 0, 61, 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 ('1CF2', 'METHANOTHERMUS FERVIDUS;', '61', '15', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1J49', 'LACTOBACILLUS DELBRUECKII SUBSP.', '34', '4', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1R37', 'SULFOLOBUS SOLFATARICUS;', '32', '12', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1VL6', 'THERMOTOGA MARITIMA MSB8;', '78', '10', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1VL8', 'THERMOTOGA MARITIMA MSB8;', '31', '2', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1W85', 'CHERICHIA COLI;', '145', '23', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1W88', 'CHERICHIA COLI;', '134', '22', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1Y6J', 'CLOSTRIDIUM THERMOCELLUM;', '9', '5', '0');
INSERT INTO `OXIDOREDUCTASE` VALUES ('1YKF', 'THERMOANAEROBIUM BROCKII;', '56', '18', '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 ('1BMD', '', 758, 108, 382, 84, 80);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1CF2', 'METHANOTHERMUS FERVIDUS;', 1348, 284, 660, 216, 188);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1J49', 'LACTOBACILLUS DELBRUECKII SUBSP.', 666, 120, 350, 108, 88);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1ODO', 'STREPTOMYCES COELICOLOR;', 408, 65, 231, 58, 54);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1R37', 'SULFOLOBUS SOLFATARICUS;', 694, 134, 386, 80, 94);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1VL6', 'THERMOTOGA MARITIMA MSB8;', 1552, 276, 816, 212, 220);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1VL8', 'THERMOTOGA MARITIMA MSB8;', 534, 108, 278, 70, 78);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1W85', 'CHERICHIA COLI;', 2866, 560, 1552, 394, 360);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1W88', 'CHERICHIA COLI;', 2866, 568, 1552, 386, 360);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1Y6J', 'CLOSTRIDIUM THERMOCELLUM;', 318, 78, 163, 38, 39);
INSERT INTO `OXIDOREDUCTASECOMPOSITION` VALUES ('1YKF', 'THERMOANAEROBIUM BROCKII;', 1408, 180, 872, 164, 192);

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

-- 
-- 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 ('1BMD', '', 22, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1BMD', '', 22, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1BMD', '', 22, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1CF2', 'METHANOTHERMUS FERVIDUS;', 48, 0, 0, 0, 13, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1J49', 'LACTOBACILLUS DELBRUECKII SUBSP.', 25, 0, 0, 0, 9, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1ODO', 'STREPTOMYCES COELICOLOR;', 18, 0, 0, 0, 4, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1R37', 'SULFOLOBUS SOLFATARICUS;', 22, 0, 0, 0, 10, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1VL6', 'THERMOTOGA MARITIMA MSB8;', 62, 0, 0, 0, 16, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1VL8', 'THERMOTOGA MARITIMA MSB8;', 18, 0, 0, 0, 13, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1W85', 'CHERICHIA COLI;', 104, 0, 0, 0, 41, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1W88', 'CHERICHIA COLI;', 102, 0, 0, 0, 32, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1Y6J', 'CLOSTRIDIUM THERMOCELLUM;', 8, 0, 0, 0, 1, 0, 0, 0, 0, 0);
INSERT INTO `OXIDOREDUCTASEHELIX` VALUES ('1YKF', 'THERMOANAEROBIUM BROCKII;', 36, 0, 0, 0, 20, 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 ('1CWY', 'THERMUS AQUATICUS;', '27', '2', '0');
INSERT INTO `TRANSFERASE` VALUES ('1J3B', 'THERMUS THERMOPHILUS;', '40', '16', '0');
INSERT INTO `TRANSFERASE` VALUES ('1LVW', 'METHANOBACTERIUM THERMOAUTOTROPHICUM;', '56', '20', '0');
INSERT INTO `TRANSFERASE` VALUES ('1QZT', 'METHANOSARCINA THERMOPHILA;', '56', '8', '0');
INSERT INTO `TRANSFERASE` VALUES ('1VGM', 'SULFOLOBUS TOKODAII;', '41', '5', '0');
INSERT INTO `TRANSFERASE` VALUES ('1VM7', 'THERMOTOGA MARITIMA MSB8;', '28', '4', '0');
INSERT INTO `TRANSFERASE` VALUES ('1WX0', 'THERMUS THERMOPHILUS HB8;', '110', '10', '0');
INSERT INTO `TRANSFERASE` VALUES ('1ZXX', 'LACTOBACILLUS DELBRUECKII SUBSP.', '14', '3', '0');
INSERT INTO `TRANSFERASE` VALUES ('2ABQ', 'BACILLUS HALODURANS;', '24', '7', '0');
INSERT INTO `TRANSFERASE` VALUES ('2B8N', 'THERMOTOGA MARITIMA MSB8;', '36', '4', '0');
INSERT INTO `TRANSFERASE` VALUES ('2FGC', 'THERMOTOGA MARITIMA MSB8;', '6', '3', '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 ('1CWY', 'THERMUS AQUATICUS;', 500, 66, 293, 70, 71);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1J3B', 'THERMUS THERMOPHILUS;', 1058, 208, 574, 130, 146);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1LVW', 'METHANOBACTERIUM THERMOAUTOTROPHICUM;', 1180, 228, 620, 172, 160);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1QZT', 'METHANOSARCINA THERMOPHILA;', 1332, 276, 728, 176, 152);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1VGM', 'SULFOLOBUS TOKODAII;', 756, 178, 382, 92, 104);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1VM7', 'THERMOTOGA MARITIMA MSB8;', 622, 126, 328, 86, 82);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1WX0', 'THERMUS THERMOPHILUS HB8;', 2230, 340, 1310, 290, 290);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1WX0', 'THERMUS THERMOPHILUS HB8;', 2230, 340, 1310, 290, 290);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('1ZXX', 'LACTOBACILLUS DELBRUECKII SUBSP.', 319, 59, 176, 44, 40);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('2ABQ', 'BACILLUS HALODURANS;', 612, 130, 316, 80, 78);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('2ABQ', 'BACILLUS HALODURANS;', 612, 130, 316, 80, 78);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('2B8N', 'THERMOTOGA MARITIMA MSB8;', 858, 164, 436, 118, 130);
INSERT INTO `TRANSFERASECOMPOSITION` VALUES ('2FGC', 'THERMOTOGA MARITIMA MSB8;', 193, 36, 87, 27, 36);

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

-- 
-- 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 ('1CWY', 'THERMUS AQUATICUS;', 18, 0, 0, 0, 9, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1J3B', 'THERMUS THERMOPHILUS;', 24, 0, 0, 0, 16, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1LVW', 'METHANOBACTERIUM THERMOAUTOTROPHICUM;', 44, 0, 0, 0, 12, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1QZT', 'METHANOSARCINA THERMOPHILA;', 52, 0, 0, 0, 4, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1VGM', 'SULFOLOBUS TOKODAII;', 32, 0, 0, 0, 9, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1VM7', 'THERMOTOGA MARITIMA MSB8;', 18, 0, 0, 0, 10, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1WX0', 'THERMUS THERMOPHILUS HB8;', 110, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('1ZXX', 'LACTOBACILLUS DELBRUECKII SUBSP.', 11, 0, 0, 0, 3, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('2ABQ', 'BACILLUS HALODURANS;', 21, 0, 0, 0, 3, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('2B8N', 'THERMOTOGA MARITIMA MSB8;', 34, 0, 0, 0, 2, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('2FGC', 'THERMOTOGA MARITIMA MSB8;', 4, 0, 0, 0, 2, 0, 0, 0, 0, 0);
INSERT INTO `TRANSFERASEHELIX` VALUES ('', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
