-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 30, 2008 at 12:07 PM
-- Server version: 4.1.20
-- PHP Version: 4.3.9
-- 
-- 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');
