-- MySQL dump 10.13  Distrib 8.0.32, for Linux (x86_64)
--
-- Host: mysql-ens-sta-1-b    Database: snp_mart_113
-- ------------------------------------------------------
-- Server version	5.6.36

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `btaurus_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `btaurus_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btaurus_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `btaurus_snp__variation__main`
--

DROP TABLE IF EXISTS `btaurus_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btaurus_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `btaurus_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `btaurus_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btaurus_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `btaurus_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `btaurus_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btaurus_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `btaurus_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `btaurus_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btaurus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `btaurus_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `btaurus_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btaurus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `btaurus_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `btaurus_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btaurus_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `btaurus_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `btaurus_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btaurus_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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),
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11),
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11),
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4),
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `btaurus_structvar__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `btaurus_structvar__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btaurus_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(255),
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11),
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11),
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4),
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chircus_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `chircus_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chircus_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chircus_snp__variation__main`
--

DROP TABLE IF EXISTS `chircus_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chircus_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chircus_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `chircus_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chircus_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chircus_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `chircus_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chircus_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chircus_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `chircus_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chircus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chircus_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `chircus_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chircus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clfamiliaris_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `clfamiliaris_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clfamiliaris_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clfamiliaris_snp__variation__main`
--

DROP TABLE IF EXISTS `clfamiliaris_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clfamiliaris_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clfamiliaris_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `clfamiliaris_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clfamiliaris_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clfamiliaris_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `clfamiliaris_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clfamiliaris_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clfamiliaris_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `clfamiliaris_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clfamiliaris_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clfamiliaris_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `clfamiliaris_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clfamiliaris_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clfamiliaris_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `clfamiliaris_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clfamiliaris_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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),
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11),
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11),
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4),
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clfamiliaris_structvar__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `clfamiliaris_structvar__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clfamiliaris_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(255),
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11),
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11),
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4),
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `dataset_names`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `drerio_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `drerio_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drerio_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `drerio_snp__variation__main`
--

DROP TABLE IF EXISTS `drerio_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drerio_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `drerio_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `drerio_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drerio_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `drerio_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `drerio_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drerio_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `drerio_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `drerio_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drerio_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `drerio_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `drerio_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drerio_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `drerio_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `drerio_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drerio_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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),
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11),
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11),
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4),
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `drerio_structvar__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `drerio_structvar__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drerio_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(255),
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11),
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11),
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4),
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecaballus_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `ecaballus_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecaballus_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecaballus_snp__variation__main`
--

DROP TABLE IF EXISTS `ecaballus_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecaballus_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecaballus_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `ecaballus_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecaballus_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecaballus_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `ecaballus_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecaballus_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecaballus_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `ecaballus_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecaballus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecaballus_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `ecaballus_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecaballus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecaballus_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `ecaballus_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecaballus_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecaballus_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `ecaballus_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecaballus_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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),
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11),
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11),
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4),
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecaballus_structvar__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `ecaballus_structvar__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecaballus_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(255),
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11),
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11),
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4),
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fcatus_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `fcatus_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fcatus_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fcatus_snp__variation__main`
--

DROP TABLE IF EXISTS `fcatus_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fcatus_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fcatus_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `fcatus_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fcatus_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fcatus_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `fcatus_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fcatus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ggallus_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `ggallus_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ggallus_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ggallus_snp__regulatory_feature_variation__dm`
--

DROP TABLE IF EXISTS `ggallus_snp__regulatory_feature_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ggallus_snp__regulatory_feature_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `feature_stable_id_20126` varchar(128) DEFAULT NULL,
  `allele_string_20126` text,
  `consequence_types_20126` set('regulatory_region_variant','regulatory_region_ablation','regulatory_region_fusion','regulatory_region_amplification','regulatory_region_translocation') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `feature_stable_id_20126` (`feature_stable_id_20126`),
  KEY `consequence_types_20126` (`consequence_types_20126`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ggallus_snp__variation__main`
--

DROP TABLE IF EXISTS `ggallus_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ggallus_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ggallus_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `ggallus_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ggallus_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ggallus_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `ggallus_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ggallus_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ggallus_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `ggallus_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ggallus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ggallus_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `ggallus_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ggallus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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,
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp__motif_feature_variation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp__motif_feature_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp__motif_feature_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `feature_stable_id_20125` varchar(128) DEFAULT NULL,
  `allele_string_20125` text,
  `motif_name_20125` varchar(60) DEFAULT NULL,
  `motif_start_20125` int(11) unsigned DEFAULT NULL,
  `motif_score_delta_20125` float DEFAULT NULL,
  `consequence_types_20125` set('TF_binding_site_variant','TFBS_ablation','TFBS_fusion','TFBS_amplification','TFBS_translocation') DEFAULT NULL,
  `in_informative_position_20125` tinyint(1) DEFAULT '0',
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `motif_name_20125` (`motif_name_20125`),
  KEY `consequence_types_20125` (`consequence_types_20125`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp__regulatory_feature_variation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp__regulatory_feature_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp__regulatory_feature_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `feature_stable_id_20126` varchar(128) DEFAULT NULL,
  `allele_string_20126` text,
  `consequence_types_20126` set('regulatory_region_variant','regulatory_region_ablation','regulatory_region_fusion','regulatory_region_amplification','regulatory_region_translocation') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `feature_stable_id_20126` (`feature_stable_id_20126`),
  KEY `consequence_types_20126` (`consequence_types_20126`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp__variation__main`
--

DROP TABLE IF EXISTS `hsapiens_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp__variation_annotation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp__variation_annotation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_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 `name_20100` (`name_20100`),
  KEY `description_2033` (`description_2033`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `hsapiens_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp_som__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp_som__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp_som__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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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,
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp_som__regulatory_feature_variation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp_som__regulatory_feature_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp_som__regulatory_feature_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `feature_stable_id_20126` varchar(128) DEFAULT NULL,
  `allele_string_20126` text,
  `consequence_types_20126` set('regulatory_region_variant','regulatory_region_ablation','regulatory_region_fusion','regulatory_region_amplification','regulatory_region_translocation') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `feature_stable_id_20126` (`feature_stable_id_20126`),
  KEY `consequence_types_20126` (`consequence_types_20126`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp_som__variation__main`
--

DROP TABLE IF EXISTS `hsapiens_snp_som__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp_som__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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 `idx_vfc` (`variation_feature_count`),
  KEY `idx_vcb` (`variation_citation_bool`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp_som__variation_annotation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp_som__variation_annotation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp_som__variation_annotation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `description_2033` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `name_2021` (`name_2021`),
  KEY `description_2033` (`description_2033`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp_som__variation_feature__main`
--

DROP TABLE IF EXISTS `hsapiens_snp_som__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp_som__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2025` varchar(255) DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp_som__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp_som__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp_som__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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_snp_som__variation_synonym__dm`
--

DROP TABLE IF EXISTS `hsapiens_snp_som__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_snp_som__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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_structvar__phenotype__dm`
--

DROP TABLE IF EXISTS `hsapiens_structvar__phenotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_structvar__phenotype__dm` (
  `structural_variation_id_2072_key` int(10) unsigned NOT NULL DEFAULT '0',
  `phenotype_name` varchar(255) DEFAULT NULL,
  `phenotype_source` varchar(24),
  KEY `phenotype_name` (`phenotype_name`),
  KEY `phenotype_source` (`phenotype_source`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `hsapiens_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `hsapiens_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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),
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11),
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11),
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4),
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_structvar__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `hsapiens_structvar__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_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(255),
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11),
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11),
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4),
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_structvar__variation_set_structural_variation__dm`
--

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

--
-- Table structure for table `hsapiens_structvar_som__phenotype__dm`
--

DROP TABLE IF EXISTS `hsapiens_structvar_som__phenotype__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_structvar_som__phenotype__dm` (
  `structural_variation_id_2072_key` int(10) unsigned NOT NULL DEFAULT '0',
  `phenotype_name` varchar(255) DEFAULT NULL,
  `phenotype_source` varchar(24),
  KEY `structural_variation_id_2072_key` (`structural_variation_id_2072_key`),
  KEY `phenotype_name` (`phenotype_name`),
  KEY `phenotype_source` (`phenotype_source`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_structvar_som__structural_variation__main`
--

DROP TABLE IF EXISTS `hsapiens_structvar_som__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_structvar_som__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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_structvar_som__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `hsapiens_structvar_som__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_structvar_som__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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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),
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11),
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11),
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4),
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hsapiens_structvar_som__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `hsapiens_structvar_som__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hsapiens_structvar_som__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(255),
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11),
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11),
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4),
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mdomestica_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `mdomestica_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdomestica_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mdomestica_snp__variation__main`
--

DROP TABLE IF EXISTS `mdomestica_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdomestica_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mdomestica_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `mdomestica_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdomestica_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mdomestica_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `mdomestica_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdomestica_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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `meta_conf__dataset__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `meta_conf__interface__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `meta_conf__user__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `meta_conf__xml__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

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

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

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

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

--
-- Table structure for table `mmusculus_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `mmusculus_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_snp__motif_feature_variation__dm`
--

DROP TABLE IF EXISTS `mmusculus_snp__motif_feature_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_snp__motif_feature_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `feature_stable_id_20125` varchar(128) DEFAULT NULL,
  `allele_string_20125` text,
  `motif_name_20125` varchar(60) DEFAULT NULL,
  `motif_start_20125` int(11) unsigned DEFAULT NULL,
  `motif_score_delta_20125` float DEFAULT NULL,
  `consequence_types_20125` set('TF_binding_site_variant','TFBS_ablation','TFBS_fusion','TFBS_amplification','TFBS_translocation') DEFAULT NULL,
  `in_informative_position_20125` tinyint(1) DEFAULT '0',
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `motif_name_20125` (`motif_name_20125`),
  KEY `consequence_types_20125` (`consequence_types_20125`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_snp__regulatory_feature_variation__dm`
--

DROP TABLE IF EXISTS `mmusculus_snp__regulatory_feature_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_snp__regulatory_feature_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `feature_stable_id_20126` varchar(128) DEFAULT NULL,
  `allele_string_20126` text,
  `consequence_types_20126` set('regulatory_region_variant','regulatory_region_ablation','regulatory_region_fusion','regulatory_region_amplification','regulatory_region_translocation') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `feature_stable_id_20126` (`feature_stable_id_20126`),
  KEY `consequence_types_20126` (`consequence_types_20126`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_snp__variation__main`
--

DROP TABLE IF EXISTS `mmusculus_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `mmusculus_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `mmusculus_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `mmusculus_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `mmusculus_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `mmusculus_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_structvar__structural_variation_annotation__dm`
--

DROP TABLE IF EXISTS `mmusculus_structvar__structural_variation_annotation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_structvar__structural_variation_annotation__dm` (
  `structural_variation_id_2072_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_2019` varchar(255) DEFAULT NULL,
  `description_2019` text,
  KEY `structural_variation_id_2072_key` (`structural_variation_id_2072_key`),
  KEY `name_2019` (`name_2019`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `mmusculus_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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),
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11),
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11),
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4),
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mmusculus_structvar__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `mmusculus_structvar__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mmusculus_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(255),
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11),
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11),
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4),
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oanatinus_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `oanatinus_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oanatinus_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oanatinus_snp__variation__main`
--

DROP TABLE IF EXISTS `oanatinus_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oanatinus_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oanatinus_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `oanatinus_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oanatinus_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oanatinus_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `oanatinus_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oanatinus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oarambouillet_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `oarambouillet_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oarambouillet_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oarambouillet_snp__variation__main`
--

DROP TABLE IF EXISTS `oarambouillet_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oarambouillet_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oarambouillet_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `oarambouillet_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oarambouillet_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oarambouillet_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `oarambouillet_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oarambouillet_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oarambouillet_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `oarambouillet_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oarambouillet_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oarambouillet_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `oarambouillet_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oarambouillet_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oarambouillet_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `oarambouillet_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oarambouillet_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oarambouillet_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `oarambouillet_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oarambouillet_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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),
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11),
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11),
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4),
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oarambouillet_structvar__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `oarambouillet_structvar__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oarambouillet_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(255),
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11),
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11),
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4),
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rnorvegicus_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `rnorvegicus_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rnorvegicus_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rnorvegicus_snp__variation__main`
--

DROP TABLE IF EXISTS `rnorvegicus_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rnorvegicus_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rnorvegicus_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `rnorvegicus_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rnorvegicus_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rnorvegicus_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `rnorvegicus_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rnorvegicus_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rnorvegicus_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `rnorvegicus_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rnorvegicus_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `scerevisiae_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `scerevisiae_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `scerevisiae_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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,
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `scerevisiae_snp__variation__main`
--

DROP TABLE IF EXISTS `scerevisiae_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `scerevisiae_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `scerevisiae_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `scerevisiae_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `scerevisiae_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `sscrofa_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_5th_base_variant','splice_donor_region_variant','splice_donor_variant','splice_polypyrimidine_tract_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_snp__regulatory_feature_variation__dm`
--

DROP TABLE IF EXISTS `sscrofa_snp__regulatory_feature_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_snp__regulatory_feature_variation__dm` (
  `variation_feature_id_2026_key` int(10) unsigned NOT NULL DEFAULT '0',
  `feature_stable_id_20126` varchar(128) DEFAULT NULL,
  `allele_string_20126` text,
  `consequence_types_20126` set('regulatory_region_variant','regulatory_region_ablation','regulatory_region_fusion','regulatory_region_amplification','regulatory_region_translocation') DEFAULT NULL,
  KEY `variation_feature_id_2026_key` (`variation_feature_id_2026_key`),
  KEY `feature_stable_id_20126` (`feature_stable_id_20126`),
  KEY `consequence_types_20126` (`consequence_types_20126`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_snp__variation__main`
--

DROP TABLE IF EXISTS `sscrofa_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_snp__variation_citation__dm`
--

DROP TABLE IF EXISTS `sscrofa_snp__variation_citation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_snp__variation_citation__dm` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `authors_20137` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `year_20137` int(10) unsigned DEFAULT NULL,
  `pub_short_ref` varchar(275) CHARACTER SET utf8 DEFAULT NULL,
  `title_20137` varchar(400) DEFAULT NULL,
  `pmid_20137` int(10) DEFAULT NULL,
  `pmcid_20137` varchar(255) DEFAULT NULL,
  `ucsc_id_20137` varchar(50) DEFAULT NULL,
  `doi_20137` varchar(80) DEFAULT NULL,
  KEY `variation_id_2025_key` (`variation_id_2025_key`),
  KEY `pub_short_ref` (`pub_short_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `sscrofa_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_snp__variation_set_variation__dm`
--

DROP TABLE IF EXISTS `sscrofa_snp__variation_set_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `sscrofa_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_structvar__structural_variation__main`
--

DROP TABLE IF EXISTS `sscrofa_structvar__structural_variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_structvar__structural_variation_feature__main`
--

DROP TABLE IF EXISTS `sscrofa_structvar__structural_variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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),
  `outer_start_20104` int(11) DEFAULT NULL,
  `seq_region_start_20104` int(11),
  `inner_start_20104` int(11) DEFAULT NULL,
  `inner_end_20104` int(11) DEFAULT NULL,
  `seq_region_end_20104` int(11),
  `outer_end_20104` int(11) DEFAULT NULL,
  `seq_region_strand_20104` tinyint(4),
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sscrofa_structvar__supporting_structural_variation__dm`
--

DROP TABLE IF EXISTS `sscrofa_structvar__supporting_structural_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sscrofa_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(255),
  `outer_start_20116` int(11) DEFAULT NULL,
  `seq_region_start_20116` int(11),
  `inner_start_20116` int(11) DEFAULT NULL,
  `inner_end_20116` int(11) DEFAULT NULL,
  `seq_region_end_20116` int(11),
  `outer_end_20116` int(11) DEFAULT NULL,
  `seq_region_strand_20116` tinyint(4),
  `clinical_significance_20116` set('uncertain significance','not provided','benign','likely benign','likely pathogenic','pathogenic','drug response','histocompatibility','other','confers sensitivity','risk factor','association','protective','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tnigroviridis_snp__mart_transcript_variation__dm`
--

DROP TABLE IF EXISTS `tnigroviridis_snp__mart_transcript_variation__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnigroviridis_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),
  `seq_region_strand_1064` tinyint(2),
  `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','splice_acceptor_variant','splice_donor_variant','splice_region_variant','start_lost','start_retained_variant','stop_gained','stop_lost','stop_retained_variant','synonymous_variant','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tnigroviridis_snp__variation__main`
--

DROP TABLE IF EXISTS `tnigroviridis_snp__variation__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnigroviridis_snp__variation__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tnigroviridis_snp__variation_feature__main`
--

DROP TABLE IF EXISTS `tnigroviridis_snp__variation_feature__main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnigroviridis_snp__variation_feature__main` (
  `variation_id_2025_key` int(10) unsigned NOT NULL DEFAULT '0',
  `name_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','affects','likely pathogenic low penetrance','pathogenic low penetrance','uncertain risk allele','likely risk allele','established risk allele') DEFAULT NULL,
  `name_2021` varchar(24) DEFAULT NULL,
  `description_2021` varchar(400) DEFAULT NULL,
  `evidence_2025` set('1000Bull_Genomes','1000Genomes','Cited','ESP','ExAC','Frequency','gnomAD','HapMap','Multiple_observations','Phenotype_or_Disease','TOPMed','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),
  `seq_region_start_2026` int(11),
  `seq_region_end_2026` int(11),
  `seq_region_strand_2026` tinyint(4),
  `ancestral_allele_2025` varchar(50) DEFAULT NULL,
  `allele_string_2026` varchar(50000) DEFAULT NULL,
  `map_weight_2026` int(11),
  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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tnigroviridis_snp__variation_synonym__dm`
--

DROP TABLE IF EXISTS `tnigroviridis_snp__variation_synonym__dm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnigroviridis_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;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-09-23 21:37:19
