|
0
|
1 -- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64)
|
|
|
2 --
|
|
|
3 -- Host: localhost Database: taxonomy
|
|
|
4 -- ------------------------------------------------------
|
|
|
5 -- Server version 5.5.31-0ubuntu0.12.04.2
|
|
|
6
|
|
|
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
|
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
|
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
|
10 /*!40101 SET NAMES utf8 */;
|
|
|
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
|
12 /*!40103 SET TIME_ZONE='+00:00' */;
|
|
|
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
|
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
|
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
|
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
17
|
|
|
18 --
|
|
|
19 -- Table structure for table `gi_taxid_nucl`
|
|
|
20 --
|
|
|
21 PRAGMA encoding = "UTF-8";
|
|
|
22 PRAGMA default_synchronous = OFF;
|
|
|
23 CREATE TABLE `gi_taxid_nucl` (
|
|
|
24 `gi` double NOT NULL,
|
|
|
25 `tax_id` double NOT NULL,
|
|
|
26 PRIMARY KEY (`gi`)
|
|
|
27 ) ;
|
|
|
28 /*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
29
|
|
|
30 --
|
|
|
31 -- Table structure for table `gi_taxid_prot`
|
|
|
32 --
|
|
|
33
|
|
|
34
|
|
|
35 CREATE TABLE `gi_taxid_prot` (
|
|
|
36 `gi` double NOT NULL,
|
|
|
37 `tax_id` double NOT NULL,
|
|
|
38 PRIMARY KEY (`gi`)
|
|
|
39 ) ;
|
|
|
40 /*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
41
|
|
|
42 --
|
|
|
43 -- Table structure for table `names`
|
|
|
44 --
|
|
|
45
|
|
|
46
|
|
|
47 CREATE TABLE `names` (
|
|
|
48 `tax_id` int unsigned NOT NULL DEFAULT '0',
|
|
|
49 `name_txt` varchar(255) NOT NULL DEFAULT '',
|
|
|
50 `unique_name` varchar(255) DEFAULT NULL,
|
|
|
51 `name_class` varchar(32) NOT NULL DEFAULT ''
|
|
|
52 ) ;
|
|
|
53 /*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
54
|
|
|
55
|
|
|
56 --
|
|
|
57 -- Table structure for table `nodes`
|
|
|
58 --
|
|
|
59
|
|
|
60
|
|
|
61 CREATE TABLE `nodes` (
|
|
|
62 `tax_id` int unsigned NOT NULL DEFAULT '0',
|
|
|
63 `parent_tax_id` int unsigned NOT NULL DEFAULT '0',
|
|
|
64 `rank` varchar(32) DEFAULT NULL,
|
|
|
65 `embl_code` varchar(16) DEFAULT NULL,
|
|
|
66 `division_id` int NOT NULL DEFAULT '0',
|
|
|
67 `inherited_div_flag` int NOT NULL DEFAULT '0',
|
|
|
68 `genetic_code_id` int NOT NULL DEFAULT '0',
|
|
|
69 `inherited_GC_flag` int NOT NULL DEFAULT '0',
|
|
|
70 `mitochondrial_genetic_code_id` int NOT NULL DEFAULT '0',
|
|
|
71 `inherited_MGC_flag` int NOT NULL DEFAULT '0',
|
|
|
72 `GenBank_hidden_flag` int NOT NULL DEFAULT '0',
|
|
|
73 `hidden_subtree_root_flag` int NOT NULL DEFAULT '0',
|
|
|
74 `comments` varchar(255) DEFAULT NULL,
|
|
|
75 PRIMARY KEY (`tax_id`)
|
|
|
76 ) ;
|
|
|
77
|
|
|
78
|
|
|
79 /*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
80 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
81
|
|
|
82 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
|
83 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
|
84 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
|
85 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
|
86 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
|
87 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
|
88 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
89
|
|
|
90 -- Dump completed on 2013-07-02 10:17:11
|
