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