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