-- 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: `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', 'CHERICHIA 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', 'ESCHERICHIA 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', 'ESCHERICHIA 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', 'ESCHERICHIA 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', 'ESCHERICHIA 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', 'ESCHERICHIA 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', 'ESCHERICHIA 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', 'ESCHERICHIA 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);
