1 \N schema_version 113 2 \N patch patch_53_54_a.sql|schema_version 3 \N patch patch_53_54_b.sql|widen_columns 4 \N patch patch_53_54_c.sql|identity_object_analysis_move 5 1 assembly.mapping supercontig:loxAfr3|contig 92 \N patch patch_54_55_a.sql|schema_version 93 \N patch patch_54_55_b.sql|add_go_xrefs_types 94 \N patch patch_54_55_c.sql|add_splicing_event_tables 95 \N patch patch_54_55_d.sql|add_dependent_xref_table 311 1 genebuild.method full_genebuild 97 \N patch patch_54_55_e.sql|add_is_constitutive_column 98 \N patch patch_54_55_f.sql|coord_system.version_null 99 \N patch patch_54_55_g.sql|analysis_description.display_label_NOT_NULL 100 \N patch patch_54_55_h.sql|gene_archive.allow_for_NULLs 289 1 assembly.name Loxafr3.0 290 1 assembly.date 2009-07 291 1 genebuild.start_date 2009-07-Ensembl 7612 1 repeat.analysis repeatmask 7611 1 repeat.analysis dust 294 1 genebuild.initial_release_date 2010-03 295 1 genebuild.last_geneset_update 2011-12 296 1 genebuild.id 31 433 \N patch patch_58_59_a.sql|schema_version 298 1 assembly.coverage_depth high 7524 1 species.stable_id_prefix ENSLAF 300 1 assembly.default loxAfr3 7914 1 xref.timestamp 2024-06-30 11:52:12 313 \N patch patch_56_57_a.sql|schema_version 314 \N patch patch_55_56_c.sql|drop_oligo_tables_and_xrefs 315 \N patch patch_55_56_d.sql|add_index_to_splicing_event_feature 316 \N patch patch_56_57_b.sql|unmapped_object.typ_enum_tidy 317 \N patch patch_56_57_c.sql|external_db_type_enum 569 1 genebuild.level toplevel 570 1 transcriptbuild.level toplevel 571 1 exonbuild.level toplevel 572 1 repeat_featurebuild.level toplevel 573 1 dna_align_featurebuild.level toplevel 574 1 protein_align_featurebuild.level toplevel 575 1 simple_featurebuild.level toplevel 576 1 prediction_transcriptbuild.level toplevel 577 1 prediction_exonbuild.level toplevel 354 \N patch patch_56_57_d.sql|allow_meta_null 355 \N patch patch_56_57_e.sql|canonical_translations 356 \N patch patch_56_57_f.sql|simple_feature.display_label 394 \N patch patch_57_58_a.sql|schema_version 7857 1 species.production_name loxodonta_africana 434 \N patch patch_58_59_b.sql|assembly_exception_exc_type_enum 435 \N patch patch_58_59_c.sql|splicing_event_attrib_type_id 436 \N patch patch_58_59_d.sql|object_xref_extend_index 437 \N schema_type core 438 \N patch patch_58_59_e.sql|meta_schema_type 7892 1 species.scientific_name Loxodonta africana 953 1 assembly.web_accession_source NCBI 450 \N patch patch_59_60_a.sql|schema_version 451 \N patch patch_59_60_b.sql|rename_go_xref_table 452 \N patch patch_59_60_c.sql|QC_fixes 491 \N patch patch_60_61_a.sql|schema_version 492 \N patch patch_60_61_b.sql|create_seq_region_synonym_table 493 \N patch patch_60_61_c.sql|rejig_object_xref_indexes 531 \N patch patch_61_62_a.sql|schema_version 532 \N patch patch_61_62_b.sql|synonym_field_extension 533 \N patch patch_61_62_d.sql|remove_display_label_linkable 534 \N patch patch_61_62_c.sql|db_name_db_release_idx 537 \N patch patch_61_62_e.sql|seq_region_synonym_seq_region_idx 538 \N patch patch_62_63_a.sql|schema_version 539 \N patch patch_62_63_b.sql|indexing_changes 540 \N patch patch_62_63_c.sql|remove_dbprimary_acc_linkable 7526 1 species.common_name African savanna elephant 580 \N patch patch_63_64_a.sql|schema_version 581 \N patch patch_63_64_b.sql|add_operons 582 \N patch patch_63_64_c.sql|is_ref_added_to_alt_allele 585 \N patch patch_63_64_d.sql|linkage_type change in ontology_xref 586 \N patch patch_55_56_a.sql|schema_version 587 \N patch patch_55_56_b.sql|add_index_names 588 \N patch patch_64_65_a.sql|schema_version 589 \N patch patch_64_65_b.sql|merge_stable_id_with_object 590 \N patch patch_64_65_c.sql|add_data_file 591 \N patch patch_64_65_d.sql|add_checksum_info_type 593 \N patch patch_65_66_a.sql|schema_version 594 \N patch patch_65_66_b.sql|fix_external_db_id 595 \N patch patch_65_66_c.sql|reorder_unmapped_obj_index 596 \N patch patch_65_66_d.sql|add_index_to_ontology_xref_table 597 \N patch patch_65_66_e.sql|fix_external_db_id_in_xref 598 \N patch patch_65_66_f.sql|drop_default_values 7858 1 species.taxonomy_id 9785 684 \N patch patch_66_67_a.sql|schema_version 685 \N patch patch_66_67_b.sql|drop_stable_id_views 686 \N patch patch_66_67_c.sql|adding_intron_supporting_evidence 687 \N patch patch_66_67_d.sql|adding_gene_transcript_annotated 688 \N patch patch_66_67_e.sql|index_canonical_transcript_id 7891 1 species.display_name Elephant 7856 1 species.url Loxodonta_africana 954 1 assembly.web_accession_type GenBank Assembly ID 955 1 assembly.accession GCA_000001905.1 956 \N patch patch_67_68_a.sql|schema_version 957 \N patch patch_67_68_b.sql|xref_uniqueness 958 \N patch patch_67_68_c.sql|altering_intron_supporting_evidence 959 \N patch patch_67_68_d.sql|add_is_splice_canonical_and_seq_index 1000 \N patch patch_67_68_e.sql|fix_67_68_e_xref_index 1001 \N patch patch_68_69_a.sql|schema_version 1042 \N patch patch_69_70_a.sql|schema_version 1043 \N patch patch_69_70_b.sql|add_mapping_set_history 1044 \N patch patch_69_70_c.sql|column_datatype_consistency 1045 \N patch patch_69_70_d.sql|data_file_id_auto_increment 1047 \N patch patch_69_70_e.sql|protein_feature_hit_description 1088 \N patch patch_70_71_a.sql|schema_version 1089 \N patch patch_70_71_b.sql|mapping_set_index 1129 \N patch patch_71_72_a.sql|schema_version 1130 \N patch patch_71_72_b.sql|associated_xref 1169 \N patch patch_72_73_a.sql|schema_version 1209 \N patch patch_72_73_b.sql|alt_allele_type 1210 \N patch patch_72_73_c.sql|add_object_type_marker 1211 \N patch patch_73_74_a.sql|schema_version 1212 \N patch patch_73_74_b.sql|remove_dnac 1213 \N patch patch_73_74_c.sql|remove_unconventional_transcript_association 1214 \N patch patch_73_74_d.sql|remove_qtl 1215 \N patch patch_73_74_e.sql|remove_canonical_annotation 1216 \N patch patch_73_74_f.sql|remove_pair_dna_align 1217 \N patch patch_73_74_g.sql|add_transcript_idx_tise 1297 \N patch patch_73_74_h.sql|alt_allele_unique_gene_idx 1298 \N patch patch_74_75_a.sql|schema_version 1299 \N patch patch_74_75_b.sql|transcript_source 1300 \N patch patch_74_75_c.sql|add_genome_statistics 1340 \N patch patch_74_75_d.sql|default_transcript_source 1341 \N patch patch_74_75_e.sql|unique_attrib_key 1342 \N patch patch_74_75_f.sql|longer_code 1343 \N patch patch_75_76_a.sql|schema_version 1344 \N patch patch_75_76_b.sql|allow_null_karyotype 1345 \N patch patch_75_76_c.sql|remove_alternative_splicing 1385 \N patch patch_76_77_a.sql|schema_version 1425 \N patch patch_77_78_a.sql|schema_version 1426 \N patch patch_77_78_b.sql|source_column_increase 1466 1 assembly.ucsc_alias loxAfr3 1467 \N patch patch_77_78_c.sql|Change unmapped_reason_id from smallint to int 1468 \N patch patch_78_79_a.sql|schema_version 1509 \N patch patch_78_79_b.sql|bamcov support 1510 \N patch patch_79_80_a.sql|schema_version 1511 \N patch patch_79_80_b.sql|xref_dbprimary_acc_longer 1512 \N patch patch_79_80_c.sql|seq_region_synonym_longer 1552 \N patch patch_79_80_d.sql|genome_statistics_value_longer 1553 \N patch patch_80_81_a.sql|schema_version 1593 \N patch patch_81_82_a.sql|schema_version 1594 \N patch patch_81_82_b.sql|xref_width 1595 \N patch patch_81_82_c.sql|seq_synonym_key 7552 1 species.division EnsemblVertebrates 1636 \N patch patch_82_83_a.sql|schema_version 1676 \N patch patch_83_84_a.sql|schema_version 1677 \N patch patch_83_84_b.sql|xref.version_default 1678 \N patch patch_83_84_c.sql|protein_feature_unique 1679 \N patch patch_83_84_d.sql|longer_synonym 1720 \N patch patch_83_84_e.sql|nullable_versions 1721 \N patch patch_84_85_a.sql|schema_version 1722 \N patch patch_84_85_b.sql|remove_duplicated_key 1762 \N patch patch_85_86_a.sql|schema_version 1802 \N patch patch_85_86_b.sql|add dna_align_feature_attrib table 1803 \N patch patch_85_86_c.sql|meta_case_insensitive 1804 \N patch patch_86_87_a.sql|schema_version 1805 \N patch patch_86_87_b.sql|meta_value_NOT_NULL 1806 \N patch patch_86_87_c.sql|datetime_default_NULL 1847 \N patch patch_87_88_a.sql|schema_version 1848 \N patch patch_87_88_b.sql|seq_region_name_255 1889 \N patch patch_87_88_c.sql|protein_featue_uniqueness 2650 \N patch patch_88_89_a.sql|schema_version 3612 \N patch patch_89_90_a.sql|schema_version 3613 \N patch patch_89_90_b.sql|remove_status 4374 1 annotation.provider_name Ensembl 4375 1 annotation.provider_url www.ensembl.org 5016 \N patch patch_89_90_c.sql|pf_hit_name_case_sensitive 5537 \N patch patch_90_91_a.sql|schema_version 5538 \N patch patch_90_91_b.sql|align_type 5539 \N patch patch_90_91_c.sql|protein_align_type 5540 \N patch patch_90_91_d.sql|remove_external_data 7879 1 species.classification Metazoa 7873 1 species.classification Vertebrata 7381 \N patch patch_91_92_a.sql|schema_version 7382 \N patch patch_91_92_b.sql|add_cigar_line_align_type 7886 1 species.alias lafr 7868 1 species.classification Dipnotetrapodomorpha 7464 \N patch patch_92_93_a.sql|schema_version 7465 \N patch patch_92_93_b.sql|biotype_table 7466 \N patch patch_92_93_c.sql|collate_index_interpro 7468 \N patch patch_93_94_a.sql|schema_version 7469 \N patch patch_93_94_b.sql|nullable_ox_analysis 7470 \N patch patch_93_94_c.sql|default_aln_type 7885 1 species.alias elephant 7512 \N patch patch_94_95_a.sql|schema_version 7513 \N patch patch_94_95_b.sql|vertebrate_division_rename 7887 1 species.alias lafricana 7878 1 species.classification Eumetazoa 7874 1 species.classification Craniata 7875 1 species.classification Chordata 7555 \N patch patch_95_96_a.sql|schema_version 7557 \N patch patch_96_97_a.sql|schema_version 7558 \N patch patch_96_97_b.sql|biotype_so_term 7559 \N patch patch_96_97_c.sql|rnaproduct_tables 7560 \N patch patch_96_97_d.sql|add_object_type_rnaproduct 7561 \N patch patch_96_97_e.sql|add_stable_id_event_type_rnaproduct 7884 1 species.alias african_elephant 7859 1 species.classification Loxodonta africana 7866 1 species.classification Amniota 7867 1 species.classification Tetrapoda 7600 \N patch patch_97_98_a.sql|schema_version 7602 \N patch patch_98_99_a.sql|schema_version 7939 1 sample.location_param scaffold_29:13374943-13478967 7940 1 sample.location_text scaffold_29:13374943-13478967 7935 1 sample.gene_param ENSLAFG00000003204 7936 1 sample.gene_text ZMYM5 7937 1 sample.transcript_param ENSLAFT00000015005 7938 1 sample.transcript_text S100-A4 7941 1 sample.search_text caspase 7613 1 repeat.analysis trf 7614 \N patch patch_80_81_b.sql|xref_width 7615 \N patch patch_99_100_a.sql|schema_version 7616 \N patch patch_99_100_b.sql|alter_externaldb_type_notnull 7617 \N patch patch_99_100_c.sql|alter_mapping_session_assembly_length 7618 \N patch patch_100_101_a.sql|schema_version 7619 1 assembly.provider_name 7620 1 assembly.provider_url 7621 \N patch patch_101_102_a.sql|schema_version 7622 \N patch patch_102_103_a.sql|schema_version 7623 \N patch patch_103_104_a.sql|schema_version 7624 \N patch patch_104_105_a.sql|schema_version 7943 1 sample.vep_hgvs ENSLAFT00000013517.3:c.4G>A\\nENSLAFT00000016261.3:c.117+16G>T\\nENSLAFT00000025320.1:c.6del 7944 1 sample.vep_vcf scaffold_0 2146514 . G A . . .\\nscaffold_1 1643720 . G T . . .\\nscaffold_2 916039 . GG G . . . 7634 1 sample.vep_spdi NW_003573420.1:2146513:G:A\\nNW_003573421.1:1643719:G:T\\nNW_003573422.1:916039:G: 7942 1 sample.vep_ensembl scaffold_0 2146514 2146514 G/A 1\\nscaffold_1 1643720 1643720 G/T 1\\nscaffold_2 916040 916040 G/- 1 7636 \N patch patch_105_106_a.sql|schema_version 7888 1 species.alias loxafr 7872 1 species.classification Gnathostomata 7865 1 species.classification Mammalia 7871 1 species.classification Teleostomi 7684 \N patch patch_106_107_a.sql|schema_version 7685 \N patch patch_106_107_b.sql|Added index for seq_region_mapping 7696 \N patch patch_107_108_a.sql|schema_version 7862 1 species.classification Afrotheria 7744 \N patch patch_108_109_a.sql|schema_version 7745 \N patch patch_108_109_b.sql|Added xref source GeneCards into external_db 7756 \N patch patch_109_110_a.sql|schema_version 7757 \N patch patch_109_110_b.sql|Add IS_PAR relationship to link X- and Y-PAR genes 7758 \N patch patch_109_110_c.sql|Allow gene id to belong to multiple alt allele groups 7769 \N patch patch_110_111_a.sql|schema_version 7889 1 species.alias loxodonta africana 7890 1 species.alias loxodonta_africana 7877 1 species.classification Bilateria 7863 1 species.classification Eutheria 7864 1 species.classification Theria 7860 1 species.classification Elephantidae 7861 1 species.classification Proboscidea 7817 \N patch patch_111_112_a.sql|schema_version 7818 \N patch patch_111_112_b.sql|Allow meta_value to be null 7883 1 species.alias african savanna elephant 7882 1 species.alias 9785 7876 1 species.classification Deuterostomia 7870 1 species.classification Euteleostomi 7869 1 species.classification Sarcopterygii 7880 1 species.classification Opisthokonta 7881 1 species.classification Eukaryota