-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `athaliana_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `athaliana_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `athaliana_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 18:59:28
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `athaliana_eg_snp__poly__dm`
--

DROP TABLE IF EXISTS `athaliana_eg_snp__poly__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `athaliana_eg_snp__poly__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` varchar(3) DEFAULT NULL,
  KEY `idx_1` (`variation_id_2025_key`),
  KEY `idx_2` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:01:40
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `athaliana_eg_snp__variation_annotation__dm`
--

DROP TABLE IF EXISTS `athaliana_eg_snp__variation_annotation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `athaliana_eg_snp__variation_annotation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `variation_names_2035` varchar(255) DEFAULT NULL,
  `associated_gene_2035` varchar(255) DEFAULT NULL,
  `associated_variant_risk_allele_2035` varchar(255) DEFAULT NULL,
  `p_value_2035` varchar(255) DEFAULT NULL,
  `description_2033` varchar(255) DEFAULT NULL,
  `name_2033` varchar(50) DEFAULT NULL,
  `external_reference_20100` varchar(255) DEFAULT NULL,
  `study_type_20100` varchar(255) DEFAULT NULL,
  `name_20100` varchar(255) DEFAULT NULL,
  `description_20100` text,
  `name_2021` varchar(24) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `study_type_20100` (`study_type_20100`),
  KEY `name_2021` (`name_2021`),
  KEY `description_2033` (`description_2033`),
  KEY `name_20100` (`name_20100`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:02:49
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `athaliana_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `athaliana_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `athaliana_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:02:59
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `athaliana_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `athaliana_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `athaliana_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:02:30
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `athaliana_eg_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `athaliana_eg_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `athaliana_eg_snp__variation_set_variation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2077` varchar(255) DEFAULT NULL,
  `description_2077` text,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2077` (`name_2077`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:03:38
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `athaliana_eg_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `athaliana_eg_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `athaliana_eg_snp__variation_synonym__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2030` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2030` (`name_2030`),
  KEY `name_2021` (`name_2021`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:04:46
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `athaliana_eg_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `athaliana_eg_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `athaliana_eg_structvar__structural_variation_feature__main` (
  `structural_variation_feature_id_20104_key` int(10) unsigned DEFAULT '0',
  `structural_variation_id_2072_key` int(10) unsigned NOT NULL DEFAULT '0',
  `variation_name_2072` varchar(255) DEFAULT NULL,
  `validation_status_2072` enum('validated','not validated','high quality') DEFAULT NULL,
  `clinical_significance_2072` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `value_2092` text,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `name_20100` varchar(255) DEFAULT NULL,
  `description_20100` text,
  `external_reference_20100` varchar(255) DEFAULT NULL,
  `structural_variation_feature_count` int(11) DEFAULT '0',
  `name_2034` varchar(255) DEFAULT NULL,
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11) DEFAULT NULL,
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11) DEFAULT NULL,
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4) DEFAULT NULL,
  `allele_string_20104` longtext,
  `breakpoint_order_20104` tinyint(4) DEFAULT NULL,
  KEY `structural_variation_id_2072_key` (`structural_variation_id_2072_key`),
  KEY `structural_variation_feature_id_20104_key` (`structural_variation_feature_id_20104_key`),
  KEY `name_2034` (`name_2034`),
  KEY `seq_region_start_20104` (`seq_region_start_20104`),
  KEY `name_20100` (`name_20100`),
  KEY `clinical_significance_2072` (`clinical_significance_2072`),
  KEY `variation_name_2072` (`variation_name_2072`),
  KEY `name_2021` (`name_2021`),
  KEY `structural_variation_feature_count` (`structural_variation_feature_count`),
  KEY `seq_region_idx` (`name_2034`,`seq_region_start_20104`,`seq_region_end_20104`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:04:51
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `athaliana_eg_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `athaliana_eg_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `athaliana_eg_structvar__structural_variation__main` (
  `structural_variation_id_2072_key` int(10) unsigned NOT NULL DEFAULT '0',
  `variation_name_2072` varchar(255) DEFAULT NULL,
  `validation_status_2072` enum('validated','not validated','high quality') DEFAULT NULL,
  `clinical_significance_2072` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `value_2092` text,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `name_20100` varchar(255) DEFAULT NULL,
  `description_20100` text,
  `external_reference_20100` varchar(255) DEFAULT NULL,
  `structural_variation_feature_count` int(11) DEFAULT '0',
  KEY `structural_variation_id_2072_key` (`structural_variation_id_2072_key`),
  KEY `name_2021` (`name_2021`),
  KEY `variation_name_2072` (`variation_name_2072`),
  KEY `name_20100` (`name_20100`),
  KEY `clinical_significance_2072` (`clinical_significance_2072`),
  KEY `idx_svfc` (`structural_variation_feature_count`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:04:51
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bdistachyon_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `bdistachyon_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bdistachyon_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:04:51
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bdistachyon_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `bdistachyon_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bdistachyon_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:04:54
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bdistachyon_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `bdistachyon_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bdistachyon_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:04:53
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bdistachyon_eg_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `bdistachyon_eg_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bdistachyon_eg_snp__variation_synonym__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2030` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2030` (`name_2030`),
  KEY `name_2021` (`name_2021`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:04:55
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `dataset_names`
--

DROP TABLE IF EXISTS `dataset_names`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dataset_names` (
  `name` varchar(100) DEFAULT NULL,
  `src_dataset` varchar(100) DEFAULT NULL,
  `src_db` varchar(100) DEFAULT NULL,
  `species_id` varchar(100) DEFAULT NULL,
  `tax_id` int(10) DEFAULT NULL,
  `species_name` varchar(100) DEFAULT NULL,
  `sql_name` varchar(100) DEFAULT NULL,
  `assembly` varchar(100) DEFAULT NULL,
  `genebuild` varchar(100) DEFAULT NULL,
  `collection` varchar(100) DEFAULT NULL,
  `has_chromosomes` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:04:55
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `hvulgare_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `hvulgare_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hvulgare_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_score_2090` float DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:04:55
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `hvulgare_eg_snp__poly__dm`
--

DROP TABLE IF EXISTS `hvulgare_eg_snp__poly__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hvulgare_eg_snp__poly__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` varchar(3) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:05:29
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `hvulgare_eg_snp__population_genotype__dm`
--

DROP TABLE IF EXISTS `hvulgare_eg_snp__population_genotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hvulgare_eg_snp__population_genotype__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` text,
  `size_2019` int(10) DEFAULT NULL,
  `frequency_2016` float DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:05:42
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `hvulgare_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `hvulgare_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hvulgare_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:06:44
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `hvulgare_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `hvulgare_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hvulgare_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:06:22
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `hvulgare_eg_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `hvulgare_eg_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hvulgare_eg_snp__variation_set_variation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2077` varchar(255) DEFAULT NULL,
  `description_2077` text,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2077` (`name_2077`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:07:23
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `hvulgare_eg_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `hvulgare_eg_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hvulgare_eg_snp__variation_synonym__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2030` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2030` (`name_2030`),
  KEY `name_2021` (`name_2021`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:07:54
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `meta_conf__dataset__main`
--

DROP TABLE IF EXISTS `meta_conf__dataset__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meta_conf__dataset__main` (
  `dataset_id_key` int(11) NOT NULL,
  `dataset` varchar(100) DEFAULT NULL,
  `display_name` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `visible` int(1) unsigned DEFAULT NULL,
  `version` varchar(128) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `dataset_id_key` (`dataset_id_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:08:11
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `meta_conf__interface__dm`
--

DROP TABLE IF EXISTS `meta_conf__interface__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meta_conf__interface__dm` (
  `dataset_id_key` int(11) DEFAULT NULL,
  `interface` varchar(100) DEFAULT NULL,
  UNIQUE KEY `dataset_id_key` (`dataset_id_key`,`interface`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:08:11
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `meta_conf__user__dm`
--

DROP TABLE IF EXISTS `meta_conf__user__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meta_conf__user__dm` (
  `dataset_id_key` int(11) DEFAULT NULL,
  `mart_user` varchar(100) DEFAULT NULL,
  UNIQUE KEY `dataset_id_key` (`dataset_id_key`,`mart_user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:08:11
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `meta_conf__xml__dm`
--

DROP TABLE IF EXISTS `meta_conf__xml__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meta_conf__xml__dm` (
  `dataset_id_key` int(11) NOT NULL,
  `xml` longblob,
  `compressed_xml` longblob,
  `message_digest` blob,
  UNIQUE KEY `dataset_id_key` (`dataset_id_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:08:11
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `meta_template__template__main`
--

DROP TABLE IF EXISTS `meta_template__template__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meta_template__template__main` (
  `dataset_id_key` int(11) NOT NULL,
  `template` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:08:11
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `meta_template__xml__dm`
--

DROP TABLE IF EXISTS `meta_template__xml__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meta_template__xml__dm` (
  `template` varchar(100) DEFAULT NULL,
  `compressed_xml` longblob,
  UNIQUE KEY `template` (`template`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:08:11
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `meta_version__version__main`
--

DROP TABLE IF EXISTS `meta_version__version__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meta_version__version__main` (
  `version` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:08:11
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglaberrima_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `oglaberrima_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglaberrima_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:08:11
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglaberrima_eg_snp__poly__dm`
--

DROP TABLE IF EXISTS `oglaberrima_eg_snp__poly__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglaberrima_eg_snp__poly__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` varchar(3) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:08:46
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglaberrima_eg_snp__population_genotype__dm`
--

DROP TABLE IF EXISTS `oglaberrima_eg_snp__population_genotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglaberrima_eg_snp__population_genotype__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` text,
  `size_2019` int(10) DEFAULT NULL,
  `frequency_2016` float DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:10:11
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglaberrima_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `oglaberrima_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglaberrima_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:10:40
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglaberrima_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `oglaberrima_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglaberrima_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:10:32
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglumaepatula_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `oglumaepatula_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglumaepatula_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:10:53
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglumaepatula_eg_snp__poly__dm`
--

DROP TABLE IF EXISTS `oglumaepatula_eg_snp__poly__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglumaepatula_eg_snp__poly__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` varchar(3) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:11:06
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglumaepatula_eg_snp__population_genotype__dm`
--

DROP TABLE IF EXISTS `oglumaepatula_eg_snp__population_genotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglumaepatula_eg_snp__population_genotype__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` text,
  `size_2019` int(10) DEFAULT NULL,
  `frequency_2016` float DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:11:18
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglumaepatula_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `oglumaepatula_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglumaepatula_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:11:37
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oglumaepatula_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `oglumaepatula_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oglumaepatula_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:11:24
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oindica_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `oindica_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oindica_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:11:51
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oindica_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `oindica_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oindica_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:12:07
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oindica_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `oindica_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oindica_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:12:01
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `oindica_eg_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `oindica_eg_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oindica_eg_snp__variation_synonym__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2030` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2030` (`name_2030`),
  KEY `name_2021` (`name_2021`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:12:19
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `osativa_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `osativa_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `osativa_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:12:24
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `osativa_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `osativa_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `osativa_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:15:59
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `osativa_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `osativa_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `osativa_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:15:01
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `osativa_eg_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `osativa_eg_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `osativa_eg_snp__variation_set_variation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2077` varchar(255) DEFAULT NULL,
  `description_2077` text,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2077` (`name_2077`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:17:21
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `osativa_eg_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `osativa_eg_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `osativa_eg_snp__variation_synonym__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2030` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2030` (`name_2030`),
  KEY `name_2021` (`name_2021`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:18:04
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `sbicolor_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `sbicolor_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sbicolor_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:18:21
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `sbicolor_eg_snp__poly__dm`
--

DROP TABLE IF EXISTS `sbicolor_eg_snp__poly__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sbicolor_eg_snp__poly__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` varchar(3) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:18:31
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `sbicolor_eg_snp__population_genotype__dm`
--

DROP TABLE IF EXISTS `sbicolor_eg_snp__population_genotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sbicolor_eg_snp__population_genotype__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` text,
  `size_2019` int(10) DEFAULT NULL,
  `frequency_2016` float DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:24:32
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `sbicolor_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `sbicolor_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sbicolor_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:25:19
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `sbicolor_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `sbicolor_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sbicolor_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:25:05
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `sbicolor_eg_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `sbicolor_eg_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sbicolor_eg_structvar__structural_variation_feature__main` (
  `structural_variation_feature_id_20104_key` int(10) unsigned DEFAULT '0',
  `structural_variation_id_2072_key` int(10) unsigned NOT NULL DEFAULT '0',
  `variation_name_2072` varchar(255) DEFAULT NULL,
  `validation_status_2072` enum('validated','not validated','high quality') DEFAULT NULL,
  `clinical_significance_2072` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `value_2092` text,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `name_20100` varchar(255) DEFAULT NULL,
  `description_20100` text,
  `external_reference_20100` varchar(255) DEFAULT NULL,
  `structural_variation_feature_count` int(11) DEFAULT '0',
  `name_2034` varchar(40) DEFAULT NULL,
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11) DEFAULT NULL,
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11) DEFAULT NULL,
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4) DEFAULT NULL,
  `allele_string_20104` longtext,
  `breakpoint_order_20104` tinyint(4) DEFAULT NULL,
  KEY `structural_variation_id_2072_key` (`structural_variation_id_2072_key`),
  KEY `structural_variation_feature_id_20104_key` (`structural_variation_feature_id_20104_key`),
  KEY `name_2034` (`name_2034`),
  KEY `seq_region_start_20104` (`seq_region_start_20104`),
  KEY `name_20100` (`name_20100`),
  KEY `clinical_significance_2072` (`clinical_significance_2072`),
  KEY `variation_name_2072` (`variation_name_2072`),
  KEY `name_2021` (`name_2021`),
  KEY `structural_variation_feature_count` (`structural_variation_feature_count`),
  KEY `seq_region_idx` (`name_2034`,`seq_region_start_20104`,`seq_region_end_20104`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:25:40
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `sbicolor_eg_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `sbicolor_eg_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sbicolor_eg_structvar__structural_variation__main` (
  `structural_variation_id_2072_key` int(10) unsigned NOT NULL DEFAULT '0',
  `variation_name_2072` varchar(255) DEFAULT NULL,
  `validation_status_2072` enum('validated','not validated','high quality') DEFAULT NULL,
  `clinical_significance_2072` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `value_2092` text,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `name_20100` varchar(255) DEFAULT NULL,
  `description_20100` text,
  `external_reference_20100` varchar(255) DEFAULT NULL,
  `structural_variation_feature_count` int(11) DEFAULT '0',
  KEY `structural_variation_id_2072_key` (`structural_variation_id_2072_key`),
  KEY `name_2021` (`name_2021`),
  KEY `variation_name_2072` (`variation_name_2072`),
  KEY `name_20100` (`name_20100`),
  KEY `clinical_significance_2072` (`clinical_significance_2072`),
  KEY `idx_svfc` (`structural_variation_feature_count`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:25:40
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `sbicolor_eg_structvar__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `sbicolor_eg_structvar__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sbicolor_eg_structvar__supporting_structural_variation__dm` (
  `structural_variation_id_2072_key` int(10) unsigned NOT NULL DEFAULT '0',
  `supporting_structural_variation_id_20116` int(10) unsigned DEFAULT NULL,
  `variation_name_20116` varchar(255) DEFAULT NULL,
  `class_name_20116` text,
  `seq_region_name_20116` varchar(40) DEFAULT NULL,
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11) DEFAULT NULL,
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11) DEFAULT NULL,
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4) DEFAULT NULL,
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `strain_name_20116` varchar(255) DEFAULT NULL,
  `copy_number_20116` tinyint(2) DEFAULT NULL,
  `sample_name_20116` varchar(255) DEFAULT NULL,
  KEY `structural_variation_id_2072_key` (`structural_variation_id_2072_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:25:40
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `slycopersicum_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `slycopersicum_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slycopersicum_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:25:40
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `slycopersicum_eg_snp__poly__dm`
--

DROP TABLE IF EXISTS `slycopersicum_eg_snp__poly__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slycopersicum_eg_snp__poly__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` varchar(3) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:28:09
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `slycopersicum_eg_snp__population_genotype__dm`
--

DROP TABLE IF EXISTS `slycopersicum_eg_snp__population_genotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slycopersicum_eg_snp__population_genotype__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` text,
  `size_2019` int(10) DEFAULT NULL,
  `frequency_2016` float DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:29:54
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `slycopersicum_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `slycopersicum_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slycopersicum_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:35:19
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `slycopersicum_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `slycopersicum_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slycopersicum_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:31:07
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `taestivum_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `taestivum_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taestivum_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_score_2090` float DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:40:27
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `taestivum_eg_snp__poly__dm`
--

DROP TABLE IF EXISTS `taestivum_eg_snp__poly__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taestivum_eg_snp__poly__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` varchar(3) DEFAULT NULL,
  KEY `idx_1` (`variation_id_2025_key`),
  KEY `idx_2` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:41:19
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `taestivum_eg_snp__population_genotype__dm`
--

DROP TABLE IF EXISTS `taestivum_eg_snp__population_genotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taestivum_eg_snp__population_genotype__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` text,
  `size_2019` int(10) DEFAULT NULL,
  `frequency_2016` float DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:41:28
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `taestivum_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `taestivum_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taestivum_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:42:01
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `taestivum_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `taestivum_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taestivum_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:41:33
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `taestivum_eg_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `taestivum_eg_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taestivum_eg_snp__variation_set_variation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2077` varchar(255) DEFAULT NULL,
  `description_2077` text,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2077` (`name_2077`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:42:42
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `taestivum_eg_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `taestivum_eg_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taestivum_eg_snp__variation_synonym__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2030` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2030` (`name_2030`),
  KEY `name_2021` (`name_2021`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:42:48
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `vvinifera_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `vvinifera_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vvinifera_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_prediction_2090` enum('unknown','benign','possibly damaging','probably damaging') DEFAULT NULL,
  `sift_prediction_2090` enum('tolerated','deleterious','tolerated - low confidence','deleterious - low confidence') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`),
  KEY `polyphen_prediction_2090` (`polyphen_prediction_2090`),
  KEY `sift_prediction_2090` (`sift_prediction_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:42:51
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `vvinifera_eg_snp__poly__dm`
--

DROP TABLE IF EXISTS `vvinifera_eg_snp__poly__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vvinifera_eg_snp__poly__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` varchar(3) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:43:00
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `vvinifera_eg_snp__population_genotype__dm`
--

DROP TABLE IF EXISTS `vvinifera_eg_snp__population_genotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vvinifera_eg_snp__population_genotype__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` text,
  `size_2019` int(10) DEFAULT NULL,
  `frequency_2016` float DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:43:01
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `vvinifera_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `vvinifera_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vvinifera_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:43:03
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `vvinifera_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `vvinifera_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vvinifera_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:43:03
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `vvinifera_eg_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `vvinifera_eg_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vvinifera_eg_snp__variation_set_variation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2077` varchar(255) DEFAULT NULL,
  `description_2077` text,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2077` (`name_2077`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:43:05
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `zmays_eg_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `zmays_eg_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zmays_eg_snp__mart_transcript_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `stable_id_1023` varchar(128) DEFAULT NULL,
  `stable_id_1066` varchar(128) DEFAULT NULL,
  `biotype_1064` varchar(40) DEFAULT NULL,
  `seq_region_strand_1064` tinyint(2) DEFAULT NULL,
  `cdna_start_2090` int(11) unsigned DEFAULT NULL,
  `cdna_end_2090` int(11) unsigned DEFAULT NULL,
  `cds_start_2090` int(11) unsigned DEFAULT NULL,
  `cds_end_2090` int(11) unsigned DEFAULT NULL,
  `translation_start_2090` int(11) unsigned DEFAULT NULL,
  `translation_end_2090` int(11) unsigned DEFAULT NULL,
  `consequence_types_2090` set('3_prime_UTR_variant','5_prime_UTR_variant','coding_sequence_variant','downstream_gene_variant','feature_elongation','feature_truncation','frameshift_variant','incomplete_terminal_codon_variant','inframe_deletion','inframe_insertion','intron_variant','mature_miRNA_variant','missense_variant','NMD_transcript_variant','non_coding_transcript_exon_variant','non_coding_transcript_variant','protein_altering_variant','regulatory_region_ablation','regulatory_region_amplification','regulatory_region_fusion','regulatory_region_translocation','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','TFBS_ablation','TFBS_amplification','TFBS_fusion','TFBS_translocation','transcript_ablation','transcript_amplification','transcript_fusion','transcript_translocation','upstream_gene_variant') DEFAULT NULL,
  `distance_to_transcript_2090` int(11) unsigned DEFAULT NULL,
  `allele_string_2090` text,
  `pep_allele_string_2090` text,
  `polyphen_score_2090` float DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `stable_id_1023` (`stable_id_1023`),
  KEY `stable_id_1066` (`stable_id_1066`),
  KEY `cdna_start_2090` (`cdna_start_2090`),
  KEY `translation_start_2090` (`translation_start_2090`),
  KEY `consequence_types_2090` (`consequence_types_2090`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:43:06
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `zmays_eg_snp__poly__dm`
--

DROP TABLE IF EXISTS `zmays_eg_snp__poly__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zmays_eg_snp__poly__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` varchar(3) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:46:46
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `zmays_eg_snp__population_genotype__dm`
--

DROP TABLE IF EXISTS `zmays_eg_snp__population_genotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zmays_eg_snp__population_genotype__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `allele` text,
  `size_2019` int(10) DEFAULT NULL,
  `frequency_2016` float DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:47:21
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `zmays_eg_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `zmays_eg_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zmays_eg_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_feature_id_2026_key` int(10) unsigned DEFAULT '0',
  `variation_name_2026` varchar(255) DEFAULT NULL,
  `name_1059` varchar(255) DEFAULT NULL,
  `seq_region_start_2026` int(11) DEFAULT NULL,
  `seq_region_end_2026` int(11) DEFAULT NULL,
  `seq_region_strand_2026` tinyint(4) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_1059` (`name_1059`),
  KEY `seq_region_start_2026` (`seq_region_start_2026`),
  KEY `seq_region_idx` (`name_1059`,`seq_region_start_2026`,`seq_region_end_2026`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:50:14
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `zmays_eg_snp__variation__main`
--

DROP TABLE IF EXISTS `zmays_eg_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zmays_eg_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `ancestral_allele_2025` varchar(255) DEFAULT NULL,
  `minor_allele_2025` varchar(50) DEFAULT NULL,
  `minor_allele_count_2025` int(10) unsigned DEFAULT NULL,
  `minor_allele_freq_2025` float DEFAULT NULL,
  `clinical_significance_2025` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','HapMap','Multiple_observations','Phenotype_or_Disease','WTSI_MGP') DEFAULT NULL,
  `variation_feature_count` int(11) DEFAULT '0',
  `variation_citation_bool` int(11) DEFAULT '0',
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2025` (`name_2025`),
  KEY `name_2021` (`name_2021`),
  KEY `evidence_2025` (`evidence_2025`),
  KEY `clinical_significance_2025` (`clinical_significance_2025`),
  KEY `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:49:17
-- MySQL dump 10.13  Distrib 5.6.17, for linux-glibc2.5 (x86_64)
--
-- Host: localhost    Database: plants_snp_mart_53
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `zmays_eg_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `zmays_eg_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zmays_eg_snp__variation_synonym__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2030` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2030` (`name_2030`),
  KEY `name_2021` (`name_2021`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 2017-05-01 19:51:44
