1 \N schema_type variation 2 \N schema_version 113 3 \N patch patch_90_91_a.sql|schema version 4 \N patch patch_90_91_b.sql|extend the characters supported in the publication.authors column 5 \N patch patch_90_91_c.sql|Add new column zygosity in the table structural_variation_sample 6 1 species.production_name ovis_aries_rambouillet 7 1 ploidy 2 8 1 web_config source#Sequence variants (dbSNP and all other sources)#All sequence variants#variation_feature_variation#variants 9 1 web_config source#dbSNP variants#dbSNP#variation_feature_variation_dbSNP#variants 10 1 web_config menu#Sequence variants##variants# 11 1 web_config menu#Failed variants##failed# 12 1 web_config set#All variants on genotyping chips#All genotyping chips#variation_set_all_chips#var_other 13 1 web_config menu#Arrays and other##var_other# 14 1 web_config set#IlluminaOvineSNP50#IlluminaOvineSNP50#variation_set_OvineSNP50#var_other 15 1 web_config set#IlluminaOvineHDSNP#IlluminaOvineHDSNP#variation_set_OvineHDSNP#var_other 16 1 sift_version sift6.2.1 18 1 sift_protein_db_version UniRef90 2014_11 85 1 TranscriptEffect_run_date 2022-09-26 20 1 EquivalentAlleles_run_date 2017-10-23 21 1 HGVS_version 15.11 22 \N patch patch_91_92_a.sql|schema version 23 \N patch patch_91_92_b.sql|Add index on feature_stable_id in regulatory_feature_variation and motif_feature_variation 24 \N patch patch_91_92_c.sql|Change the column zygosity in the table structural_variation_sample 25 1 EPMC_citation_update 2018-2-5 26 1 UCSC_citation_update 2018-2-5 27 \N patch patch_91_92_d.sql|create table to store names of submitters to ClinVar etc 28 \N patch patch_92_93_a.sql|schema version 29 \N patch patch_92_93_b.sql|Extend phenotype_ontology_accession mapped_by_attrib predefined set 30 \N patch patch_92_93_c.sql|Add new evidence attribs to the variation and variation_feature tables 31 1 pairwise_ld.default_population 132 32 \N patch patch_93_94_a.sql|schema version 33 \N patch patch_94_95_a.sql|schema version 34 \N patch patch_94_95_b.sql|create table to store allele synonyms 35 \N patch patch_95_96_a.sql|schema version 36 \N patch patch_95_96_b.sql|modify index on variation_synonym 37 \N patch patch_95_96_c.sql|add new entries to the failed_description table 38 \N patch patch_95_96_d.sql|create table to store failed variation features 39 \N patch patch_95_96_e.sql|Rename motif_name to binding_matrix_stable_id. 40 \N patch patch_96_97_a.sql|schema version 41 \N patch patch_96_97_b.sql|move ancestral allele column to variation_feature 42 \N patch patch_96_97_c.sql|add an unique index on the name column 43 1 variation_source.database 1 44 1 variation_source.vcf 0 45 \N patch patch_97_98_a.sql|schema version 46 1 EPMC_citation_update 2019-07-16 47 1 UCSC_citation_update 2019-07-16 48 \N patch patch_98_99_a.sql|schema version 49 \N patch patch_98_99_b.sql|Add the column data_source_attrib in the table variation_citation 50 \N patch patch_98_99_c.sql|Increase the size of the title and doi columns in the publication table 51 \N patch patch_98_99_d.sql|add key data_source_attrib 52 \N patch patch_98_99_e.sql|Fix attrib ids in table variation_citation 53 1 PhenotypeAnnotation_run_date_OMIA 2019-10-25 54 \N patch patch_99_100_a.sql|schema version 55 \N patch patch_99_100_b.sql|add frequency to structural variation 56 \N patch patch_99_100_c.sql|add class_attrib_id column to phenotype 57 1 PhenotypeAnnotation_run_date_OMIA 2020-01-22 58 1 PhenotypeAnnotation_run_date_AnimalQTLdb 2020-01-23 59 \N patch patch_100_101_a.sql|schema version 60 \N patch patch_100_101_b.sql|Add new data_source_attrib to variation_citation 61 1 PhenotypeAnnotation_run_date_OMIA 2020-04-24 62 \N patch patch_101_102_a.sql|schema version 63 \N patch patch_101_102_b.sql|Add new clinical_significance to variation, variation_feature and structural_variation 64 1 TranscriptEffect_run_date 2020-07-13 65 1 VariationClass_run_date 2020-07-13 66 1 PhenotypeAnnotation_run_date_OMIA 2020-07-22 67 \N patch patch_102_103_a.sql|schema version 68 \N patch patch_103_104_a.sql|schema version 69 1 PhenotypeAnnotation_run_date_OMIA 2021-01-25 70 1 PhenotypeAnnotation_run_date_AnimalQTLdb 2021-01-27 71 1 species.division EnsemblVertebrates 72 \N patch patch_104_105_a.sql|schema version 73 \N patch patch_104_105_b.sql|Increase publication title size 74 1 PhenotypeAnnotation_run_date_OMIA 2021-08-03 75 \N patch patch_105_106_a.sql|schema version 76 1 PhenotypeAnnotation_run_date_OMIA 2021-10-21 77 \N patch patch_106_107_a.sql|schema version 78 \N patch patch_106_107_b.sql|consequences update 79 \N patch patch_106_107_c.sql|remove regulatory and TFBS consequences from consequence_types in transcript_variation 80 1 PhenotypeAnnotation_run_date_OMIA 2022-03-24 81 \N patch patch_107_108_a.sql|schema version 82 \N patch patch_107_108_b.sql|fix SAS population description 83 1 PhenotypeAnnotation_run_date_OMIA 2022-07-15 84 \N patch patch_108_109_a.sql|schema version 86 1 PhenotypeAnnotation_run_date_OMIA 2022-10-18 87 1 PhenotypeAnnotation_run_date_AnimalQTLdb 2022-10-18 88 \N patch patch_109_110_a.sql|schema version 89 \N patch patch_109_110_b.sql|Add DDG2P data_source_attrib to variation_citation 90 \N patch patch_109_110_c.sql|Add new clinical_significance values to variation, variation_feature and structural_variation 91 1 PhenotypeAnnotation_run_date_OMIA 2023-03-05 92 1 PhenotypeAnnotation_run_date_AnimalQTLdb 2023-03-05 93 \N patch patch_110_111_a.sql|schema version 100 1 PhenotypeAnnotation_run_date_OMIA 2023-07-25 96 1 EquivalentAlleles_run_date 2023-07-17 94 \N patch patch_110_111_b.sql|Update transcript_variation primary key 98 1 TranscriptEffect_run_date 2023-07-18 99 1 VariationClass_run_date 2023-07-19 101 1 PhenotypeAnnotation_run_date_AnimalQTLdb 2023-07-25 102 \N patch patch_111_112_a.sql|schema version 103 1 PhenotypeAnnotation_run_date_OMIA 2023-11-24 104 1 PhenotypeAnnotation_run_date_AnimalQTLdb 2023-11-24 105 \N patch patch_112_113_a.sql|schema version 106 \N patch patch_112_113_b.sql|Update meta_key length 107 1 EquivalentAlleles_run_date 2024-05-24 108 1 TranscriptEffect_run_date 2024-05-29 109 1 PhenotypeAnnotation_run_date_OMIA 2024-06-18 110 1 PhenotypeAnnotation_run_date_OMIA 2024-06-19 111 1 PhenotypeAnnotation_run_date_AnimalQTLdb 2024-06-19