-- phpMyAdmin SQL Dump
-- version 3.4.3.1
-- http://www.phpmyadmin.net
--
-- Host: funspec.ccbr.utoronto.ca
-- Generation Time: Apr 27, 2015 at 10:52 AM
-- Server version: 5.1.73
-- PHP Version: 5.3.2-1ubuntu4.30

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cisbp_1.02`
--

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

--
-- Table structure for table `stats_by_dbd`
--

CREATE TABLE IF NOT EXISTS `stats_by_dbd` (
  `StatsDBD_ID` varchar(11) NOT NULL,
  `Family_Name` varchar(30) DEFAULT NULL,
  `Num_motifs` int(11) DEFAULT NULL,
  `Total_direct` int(11) DEFAULT NULL,
  `Total_indirect` int(11) DEFAULT NULL,
  `Total_TFs` int(11) DEFAULT NULL,
  `Pct_TFs` float DEFAULT NULL,
  `Pfam_ID` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`StatsDBD_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stats_by_dbd`
--

INSERT INTO `stats_by_dbd` (`StatsDBD_ID`, `Family_Name`, `Num_motifs`, `Total_direct`, `Total_indirect`, `Total_TFs`, `Pct_TFs`, `Pfam_ID`) VALUES
('SD01_1.02', 'ABF1', 2, 2, 0, 268, 0.7, 'BAF1_ABF1'),
('SD02_1.02', 'AFT', 9, 2, 7, 142, 6.3, 'AFT'),
('SD03_1.02', 'AP2', 2698, 121, 2577, 4148, 65, 'AP2'),
('SD04_1.02', 'AP-2', 207, 8, 199, 369, 56.1, 'TF_AP-2'),
('SD05_1.02', 'APSES', 114, 11, 103, 1871, 6.1, 'KilA-N'),
('SD06_1.02', 'ARID/BRIGHT', 289, 19, 270, 1404, 20.6, 'ARID'),
('SD07_1.02', 'AT hook', 364, 31, 333, 404, 90.1, 'AT_hook'),
('SD08_1.02', 'B3', 246, 5, 241, 2032, 12.1, 'B3'),
('SD09_1.02', 'BBR', 3, 2, 1, 219, 1.4, 'GAGA_bind'),
('SD10_1.02', 'BED ZF', 1, 1, 0, 1, 100, 'zf-BED'),
('SD11_1.02', 'bHLH', 6774, 224, 6550, 10780, 62.8, 'HLH'),
('SD12_1.02', 'Brinker', 16, 2, 14, 173, 9.2, 'BrkDBD'),
('SD13_1.02', 'bZIP', 3878, 211, 3667, 9326, 41.6, 'bZIP_1'),
('SD14_1.02', 'C2H2 ZF', 7695, 432, 7263, 37331, 20.6, 'zf-C2H2'),
('SD15_1.02', 'C2HC ZF', 14, 1, 13, 421, 3.3, 'zf-C2HC'),
('SD16_1.02', 'CBF/NF-Y', 190, 2, 188, 447, 42.5, 'CBFB_NFYA'),
('SD17_1.02', 'CCCH ZF', 1, 1, 0, 1, 100, 'zf-CCCH'),
('SD18_1.02', 'CENPB', 60, 5, 55, 715, 8.4, 'CENP-B_N'),
('SD19_1.02', 'CG-1', 54, 4, 50, 264, 20.5, 'CG-1'),
('SD20_1.02', 'Copper fist', 43, 4, 39, 211, 20.4, 'Copper-fist'),
('SD21_1.02', 'CSD', 231, 3, 228, 1008, 22.9, 'CSD'),
('SD22_1.02', 'CSL', 82, 2, 80, 232, 35.3, 'LAG1-DNAbind'),
('SD23_1.02', 'CUT', 3, 1, 2, 135, 2.2, 'CUT'),
('SD24_1.02', 'CUT+Homeodomain', 272, 11, 261, 392, 69.4, 'CUT,Homeobox'),
('SD25_1.02', 'CxC', 115, 16, 99, 529, 21.7, 'CXC'),
('SD26_1.02', 'CxxC', 133, 18, 115, 613, 21.7, 'zf-CXXC'),
('SD27_1.02', 'DM', 286, 29, 257, 494, 57.9, 'DM'),
('SD28_1.02', 'Dof', 33, 23, 10, 754, 4.4, 'zf-Dof'),
('SD29_1.02', 'DP', 0, 0, 0, 25, 0, 'DP'),
('SD30_1.02', 'E2F', 365, 24, 341, 800, 45.6, 'E2F_TDP'),
('SD31_1.02', 'EIN3', 143, 7, 136, 193, 74.1, 'EIN3'),
('SD32_1.02', 'Ets', 1540, 60, 1480, 1713, 89.9, 'Ets'),
('SD33_1.02', 'FAR1', 11, 1, 10, 1433, 0.8, 'FAR1'),
('SD34_1.02', 'Forkhead', 2702, 90, 2612, 3143, 86, 'Fork_head'),
('SD35_1.02', 'GATA', 1269, 60, 1209, 2715, 46.7, 'GATA'),
('SD36_1.02', 'GCM', 133, 11, 122, 159, 83.6, 'GCM'),
('SD37_1.02', 'GCR1', 33, 4, 29, 252, 13.1, 'GCR1_C'),
('SD38_1.02', 'Grainyhead', 148, 7, 141, 490, 30.2, 'CP2'),
('SD39_1.02', 'GRAS', 15, 1, 14, 1321, 1.1, 'GRAS'),
('SD40_1.02', 'GTF2I-like', 54, 2, 52, 129, 41.9, 'GTF2I'),
('SD41_1.02', 'Homeodomain', 11260, 605, 10655, 15244, 73.9, 'Homeobox'),
('SD42_1.02', 'HSF', 250, 14, 236, 1886, 13.3, 'HSF_DNA-bind'),
('SD43_1.02', 'IBD', 6, 3, 3, 116, 5.2, 'IBD'),
('SD44_1.02', 'IRF', 94, 22, 72, 469, 20, 'IRF'),
('SD45_1.02', 'Leafy', 2, 1, 1, 103, 1.9, 'FLO_LFY'),
('SD46_1.02', 'LOB', 139, 2, 137, 984, 14.1, 'DUF260'),
('SD47_1.02', 'MADF', 319, 40, 279, 1881, 17, 'MADF_DNA_bdg'),
('SD48_1.02', 'MADS box', 1463, 120, 1343, 2377, 61.5, 'SRF-TF'),
('SD49_1.02', 'MATalpha1', 7, 1, 6, 61, 11.5, 'MAT_Alpha1'),
('SD50_1.02', 'MATalpha1+HMG box', 0, 0, 0, 1, 0, 'MAT_Alpha1,HMG_box'),
('SD51_1.02', 'MBD', 104, 4, 100, 859, 12.1, 'MBD'),
('SD52_1.02', 'mTERF', 26, 1, 25, 1222, 2.1, 'mTERF'),
('SD53_1.02', 'Myb/SANT', 1847, 131, 1716, 12358, 14.9, 'Myb_DNA-binding'),
('SD54_1.02', 'NAC/NAM', 886, 22, 864, 2481, 35.7, 'NAM'),
('SD55_1.02', 'Ndt80/PhoG', 68, 5, 63, 327, 20.8, 'NDT80_PhoG'),
('SD56_1.02', 'NFX', 0, 0, 0, 369, 0, 'zf-NF-X1'),
('SD57_1.02', 'Nuclear receptor', 2684, 135, 2549, 4443, 60.4, 'zf-C4'),
('SD58_1.02', 'p53', 96, 5, 91, 223, 43, 'P53'),
('SD59_1.02', 'Paired box', 282, 12, 270, 612, 46.1, 'PAX'),
('SD60_1.02', 'Pipsqueak', 112, 16, 96, 1033, 10.8, 'HTH_psq'),
('SD61_1.02', 'PLATZ', 0, 0, 0, 338, 0, 'PLATZ'),
('SD62_1.02', 'POU', 12, 0, 12, 45, 26.7, 'Pou'),
('SD63_1.02', 'Prospero', 17, 2, 15, 220, 7.7, 'Prox1'),
('SD64_1.02', 'Rap1', 6, 2, 4, 88, 6.8, 'Rap1-DNA-bind'),
('SD65_1.02', 'Rel', 457, 17, 440, 573, 79.8, 'RHD'),
('SD66_1.02', 'RFX', 540, 21, 519, 622, 86.8, 'RFX_DNA_binding'),
('SD67_1.02', 'RRM', 1, 1, 0, 1, 100, 'RRM_1'),
('SD68_1.02', 'Runt', 163, 6, 157, 278, 58.6, 'Runt'),
('SD69_1.02', 'RWP-RK', 0, 0, 0, 460, 0, 'RWP-RK'),
('SD70_1.02', 'S1FA', 0, 0, 0, 92, 0, 'S1FA'),
('SD71_1.02', 'SAND', 129, 20, 109, 403, 32, 'SAND'),
('SD72_1.02', 'SART-1', 0, 0, 0, 380, 0, 'SART-1'),
('SD73_1.02', 'SBP', 378, 16, 362, 542, 69.7, 'SBP'),
('SD74_1.02', 'Sigma 70', 0, 0, 0, 279, 0, 'Sigma70_r2'),
('SD75_1.02', 'SMAD', 653, 22, 631, 857, 76.2, 'MH1'),
('SD76_1.02', 'Sox', 1125, 73, 1052, 5786, 19.4, 'HMG_box'),
('SD77_1.02', 'STAT', 250, 11, 239, 418, 59.8, 'STAT_bind'),
('SD78_1.02', 'STE', 1, 1, 0, 1, 100, 'STE'),
('SD79_1.02', 'Storekeeper', 17, 4, 13, 272, 6.2, 'DUF573'),
('SD80_1.02', 'T-box', 843, 36, 807, 1398, 60.3, 'T-box'),
('SD81_1.02', 'TBP', 305, 3, 302, 649, 47, 'TBP'),
('SD82_1.02', 'TCP', 485, 26, 459, 545, 89, 'TCP'),
('SD83_1.02', 'TEA', 66, 7, 59, 381, 17.3, 'TEA'),
('SD84_1.02', 'THAP finger', 37, 7, 30, 1711, 2.2, 'THAP'),
('SD85_1.02', 'Unknown', 122, 122, 0, 130, 93.8, 'UNKNOWN'),
('SD86_1.02', 'VHR1', 19, 2, 17, 40, 47.5, 'Vhr1'),
('SD87_1.02', 'Whirly', 0, 0, 0, 77, 0, 'Whirly'),
('SD88_1.02', 'WRC', 1, 1, 0, 1, 100, 'WRC'),
('SD89_1.02', 'WRKY', 1722, 30, 1692, 1898, 90.7, 'WRKY'),
('SD90_1.02', 'Zinc cluster', 1389, 112, 1277, 11275, 12.3, 'Zn_clus');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
