-- MySQL dump 10.11 -- -- Host: mysql-dev.ncbi.nlm.nih.gov Database: ecrbase -- ------------------------------------------------------ -- Server version 5.0.45-community-log /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `synteny` -- DROP TABLE IF EXISTS `synteny`; CREATE TABLE `synteny` ( `gm1` varchar(245) NOT NULL default '', `gm2` varchar(245) NOT NULL default '', `timeStamp` varchar(20) NOT NULL default '', `nBlocks` int(10) unsigned NOT NULL default '0', `fileSize` int(12) unsigned NOT NULL default '0', PRIMARY KEY (`gm1`,`gm2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `synteny` -- LOCK TABLES `synteny` WRITE; /*!40000 ALTER TABLE `synteny` DISABLE KEYS */; INSERT INTO `synteny` VALUES ('bosTau3','fr2','20080110',1960,165932),('bosTau3','galGal3','20080110',808,68884),('bosTau3','hg18','20080218',1231,107094),('bosTau3','monDom4','20080227',1886,165199),('bosTau3','rheMac2','20080229',1113,97165),('bosTau3','xenTro2','20080110',1970,172538),('canFam2','galGal3','20080110',456,39006),('canFam2','hg18','20080226',280,24797),('canFam2','mm9','20080110',378,33392),('canFam2','monDom4','20080224',697,60963),('canFam2','panTro2','20080110',299,26550),('canFam2','rheMac2','20080110',269,23822),('canFam2','rn4','20080111',393,34616),('danRer5','fr2','20080111',1588,136107),('danRer5','galGal3','20080111',1566,130242),('danRer5','hg18','20080207',2534,213163),('danRer5','mm9','20080227',2438,206184),('danRer5','monDom4','20080227',2513,213355),('danRer5','rheMac2','20080304',2456,206014),('danRer5','xenTro2','20080111',2048,178921),('fr2','bosTau3','20080111',1886,160094),('fr2','danRer5','20080111',2235,190363),('fr2','galGal3','20080111',1215,102710),('fr2','hg18','20080111',1925,164481),('fr2','mm9','20080111',1855,159273),('fr2','monDom4','20080227',1853,159477),('fr2','panTro2','20080111',1898,162305),('fr2','rheMac2','20080111',1826,155848),('fr2','rn4','20080111',1851,158523),('fr2','tetNig1','20080111',375,32370),('fr2','xenTro2','20080111',1569,138936),('galGal3','bosTau3','20080108',824,70376),('galGal3','canFam2','20080108',421,36063),('galGal3','danRer5','20080108',1713,141640),('galGal3','fr2','20080108',1271,107215),('galGal3','hg18','20080108',643,55527),('galGal3','mm9','20080108',765,65931),('galGal3','monDom4','20080224',914,78991),('galGal3','panTro2','20080108',639,55274),('galGal3','rheMac2','20080108',609,52482),('galGal3','rn4','20080108',823,70821),('galGal3','tetNig1','20080108',830,67662),('galGal3','xenTro2','20080108',1250,109110),('hg18','bosTau3','20080218',1104,96768),('hg18','canFam2','20080226',0,0),('hg18','danRer5','20080207',2518,210224),('hg18','fr2','20080107',1848,157990),('hg18','galGal3','20080107',619,53472),('hg18','mm9','20080108',396,35033),('hg18','monDom4','20080224',662,58054),('hg18','panTro2','20080324',1241,106011),('hg18','rheMac2','20080225',241,20790),('hg18','rn4','20080108',406,35863),('hg18','tetNig1','20080212',1711,146413),('hg18','xenTro2','20080108',1846,162974),('mm9','canFam2','20080108',374,33071),('mm9','danRer5','20080205',2364,200122),('mm9','fr2','20080108',1599,138449),('mm9','galGal3','20080108',765,66062),('mm9','hg18','20080108',364,32285),('mm9','monDom4','20080224',885,77745),('mm9','panTro2','20080108',387,34476),('mm9','rheMac2','20080108',354,31398),('mm9','rn4','20080204',257,22402),('mm9','xenTro2','20080109',1858,164291),('monDom4','bosTau3','20080222',1648,144095),('monDom4','canFam2','20080222',678,59522),('monDom4','danRer5','20080222',2356,199463),('monDom4','fr2','20080221',1700,147177),('monDom4','galGal3','20080222',888,76897),('monDom4','hg18','20080221',698,61288),('monDom4','mm9','20080224',839,73888),('monDom4','panTro2','20080224',752,66164),('monDom4','rheMac2','20080224',688,60499),('monDom4','rn4','20080224',890,78146),('monDom4','tetNig1','20080222',1507,131069),('monDom4','xenTro2','20080222',2121,188693),('panTro2','canFam2','20080111',0,0),('panTro2','fr2','20080111',1870,159803),('panTro2','galGal3','20080111',640,55405),('panTro2','hg18','20080326',962,82676),('panTro2','mm9','20080205',428,38123),('panTro2','monDom4','20080224',713,62705),('panTro2','rn4','20080205',437,38736),('panTro2','xenTro2','20080112',1673,147781),('rheMac2','bosTau3','20080229',977,85585),('rheMac2','canFam2','20080212',224,19872),('rheMac2','danRer5','20080304',2352,195729),('rheMac2','fr2','20080212',1848,157703),('rheMac2','galGal3','20080212',600,51749),('rheMac2','hg18','20080226',141,12283),('rheMac2','mm9','20080212',344,30534),('rheMac2','monDom4','20080224',659,57779),('rheMac2','rn4','20080212',394,34836),('rheMac2','tetNig1','20080304',1710,146203),('rheMac2','xenTro2','20080212',1849,163033),('rn4','canFam2','20080109',389,34296),('rn4','fr2','20080109',1600,138668),('rn4','galGal3','20080109',821,70755),('rn4','hg18','20080109',395,34944),('rn4','mm9','20080211',267,23290),('rn4','monDom4','20080224',978,85725),('rn4','panTro2','20080206',411,36533),('rn4','rheMac2','20080228',384,34085),('rn4','xenTro2','20080109',1920,169630),('tetNig1','fr2','20080112',453,38871),('tetNig1','galGal3','20080112',798,65182),('tetNig1','hg18','20080212',1819,155171),('tetNig1','monDom4','20080227',1851,158851),('tetNig1','rheMac2','20080304',1798,153169),('tetNig1','xenTro2','20080112',1060,90343),('xenTro2','bosTau3','20080109',1971,172619),('xenTro2','danRer5','20080109',2350,203377),('xenTro2','fr2','20080109',1714,151365),('xenTro2','galGal3','20080109',1259,109749),('xenTro2','hg18','20080109',1867,164811),('xenTro2','mm9','20080109',1930,170407),('xenTro2','monDom4','20080227',2212,196353),('xenTro2','panTro2','20080109',1888,166932),('xenTro2','rheMac2','20080109',1856,163587),('xenTro2','rn4','20080109',1922,169619),('xenTro2','tetNig1','20080109',1062,90555); /*!40000 ALTER TABLE `synteny` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-04-02 17:43:36