1 \N schema_version 113 2 \N patch patch_46_47_a.sql|schema_version 3 \N patch patch_46_47_b.sql|new_align_columns 4 \N patch patch_46_47_c.sql|extend_db_release 10319 \N patch patch_105_106_a.sql|schema_version 6 1 assembly.mapping ultracontig:TETRAODON8|contig 7 1 assembly.mapping chromosome:TETRAODON8|contig 6252 1 genebuild.level toplevel 6253 1 transcriptbuild.level toplevel 6254 1 exonbuild.level toplevel 6203 1 genebuild.last_otherfeatures_update 2008-07 6255 1 dna_align_featurebuild.level toplevel 395 1 assembly.date 2007-03 396 1 genebuild.id 6 397 1 assembly.default TETRAODON8 399 1 assembly.name TETRAODON 8.0 404 \N patch patch_49_50_a.sql|schema_version 405 \N patch patch_49_50_b.sql|coord_system_version_default 406 \N patch patch_49_50_d.sql|seq_region_indices 407 \N patch patch_47_48_a.sql|schema_version 408 \N patch patch_48_49_a.sql|schema_version 409 \N patch patch_48_49_b.sql|new_canonical_transcript_column 410 \N patch patch_48_49_c.sql|regulatory_support_removal 411 \N patch patch_48_49_d.sql|new_info_type_enum 412 \N patch patch_48_49_e.sql|ensembl_object_type_not_null 413 \N patch patch_49_50_c.sql|canonical_transcript 450 \N patch patch_49_50_e.sql|mapping_seq_region 451 \N patch patch_50_51_a.sql|schema_version 452 \N patch patch_50_51_b.sql|protein_feature_hit_name 453 \N patch patch_50_51_c.sql|meta_coord_index 454 \N patch patch_50_51_d.sql|multispecies 455 \N patch patch_50_51_e.sql|feature_external_data 456 \N patch patch_50_51_f.sql|meta_species_id_values 457 \N patch patch_50_51_g.sql|protein_feature_score 481 \N patch patch_50_51_h.sql|external_db_db_name 482 \N patch patch_50_51_i.sql|meta_value_binary 495 \N patch patch_51_52_a.sql|schema_version 496 \N patch patch_51_52_b.sql|widen_columns 497 \N patch patch_51_52_c.sql|pair_dna_align_feature_id 498 \N patch patch_51_52_d.sql|external_db_description 508 \N patch patch_52_53_a.sql|schema_version 509 \N patch patch_52_53_b.sql|external_db_type_enum 510 \N patch patch_52_53_c.sql|identity_xref_rename 511 \N patch patch_52_53_d.sql|drop_go_xref_index 562 1 assembly.coverage_depth high 976 \N patch patch_58_59_a.sql|schema_version 564 \N patch patch_53_54_a.sql|schema_version 565 \N patch patch_53_54_b.sql|widen_columns 566 \N patch patch_53_54_c.sql|identity_object_analysis_move 617 \N patch patch_54_55_a.sql|schema_version 618 \N patch patch_54_55_b.sql|add_go_xrefs_types 619 \N patch patch_54_55_c.sql|add_splicing_event_tables 620 \N patch patch_54_55_d.sql|add_dependent_xref_table 621 \N patch patch_54_55_e.sql|add_is_constitutive_column 622 \N patch patch_54_55_f.sql|coord_system.version_null 10592 1 species.taxonomy_id 99883 677 \N patch patch_54_55_g.sql|analysis_description.display_label_NOT_NULL 678 \N patch patch_54_55_h.sql|gene_archive.allow_for_NULLs 10218 1 species.stable_id_prefix ENSTNI 680 \N patch patch_55_56_a.sql|schema_version 681 \N patch patch_55_56_b.sql|add_index_names 682 \N patch patch_55_56_c.sql|drop_oligo_tables_and_xrefs 683 \N patch patch_55_56_d.sql|add_index_to_splicing_event_feature 831 \N patch patch_56_57_a.sql|schema_version 832 \N patch patch_56_57_b.sql|unmapped_object.typ_enum_tidy 833 \N patch patch_56_57_c.sql|external_db_type_enum 873 \N patch patch_56_57_d.sql|allow_meta_null 874 \N patch patch_56_57_e.sql|canonical_translations 875 \N patch patch_56_57_f.sql|simple_feature.display_label 925 \N patch patch_57_58_a.sql|schema_version 10593 1 species.production_name tetraodon_nigroviridis 977 \N patch patch_58_59_b.sql|assembly_exception_exc_type_enum 978 \N patch patch_58_59_c.sql|splicing_event_attrib_type_id 979 \N patch patch_58_59_d.sql|object_xref_extend_index 980 \N schema_type core 981 \N patch patch_58_59_e.sql|meta_schema_type 10591 1 species.scientific_name Tetraodon nigroviridis 993 \N patch patch_59_60_a.sql|schema_version 994 \N patch patch_59_60_b.sql|rename_go_xref_table 995 \N patch patch_59_60_c.sql|QC_fixes 1046 \N patch patch_60_61_a.sql|schema_version 1047 \N patch patch_60_61_b.sql|create_seq_region_synonym_table 1048 \N patch patch_60_61_c.sql|rejig_object_xref_indexes 1098 \N patch patch_61_62_a.sql|schema_version 1099 \N patch patch_61_62_b.sql|synonym_field_extension 1100 \N patch patch_61_62_c.sql|db_name_db_release_idx 1101 \N patch patch_61_62_d.sql|remove_display_label_linkable 1104 \N patch patch_61_62_e.sql|seq_region_synonym_seq_region_idx 1105 \N patch patch_62_63_a.sql|schema_version 1106 \N patch patch_62_63_b.sql|indexing_changes 1107 \N patch patch_62_63_c.sql|remove_dbprimary_acc_linkable 1160 \N patch patch_63_64_a.sql|schema_version 1161 \N patch patch_63_64_b.sql|add_operons 1162 \N patch patch_63_64_c.sql|is_ref_added_to_alt_allele 1164 \N patch patch_63_64_d.sql|linkage_type change in ontology_xref 1165 \N patch patch_64_65_a.sql|schema_version 1166 \N patch patch_64_65_b.sql|merge_stable_id_with_object 1167 \N patch patch_64_65_c.sql|add_data_file 1168 \N patch patch_64_65_d.sql|add_checksum_info_type 1171 \N patch patch_65_66_a.sql|schema_version 1172 \N patch patch_65_66_b.sql|fix_external_db_id 1173 \N patch patch_65_66_c.sql|reorder_unmapped_obj_index 1174 \N patch patch_65_66_d.sql|add_index_to_ontology_xref_table 1175 \N patch patch_65_66_e.sql|fix_external_db_id_in_xref 1176 \N patch patch_65_66_f.sql|drop_default_values 10220 1 species.common_name spotted green pufferfish 1262 \N patch patch_66_67_a.sql|schema_version 1263 \N patch patch_66_67_b.sql|drop_stable_id_views 1264 \N patch patch_66_67_c.sql|adding_intron_supporting_evidence 1265 \N patch patch_66_67_d.sql|adding_gene_transcript_annotated 1266 \N patch patch_66_67_e.sql|index_canonical_transcript_id 10558 1 species.display_name Tetraodon 10559 1 species.url Tetraodon_nigroviridis 1586 \N patch patch_67_68_a.sql|schema_version 1587 \N patch patch_67_68_b.sql|xref_uniqueness 1588 \N patch patch_67_68_c.sql|altering_intron_supporting_evidence 1589 \N patch patch_67_68_d.sql|add_is_splice_canonical_and_seq_index 1642 \N patch patch_67_68_e.sql|fix_67_68_e_xref_index 1643 \N patch patch_68_69_a.sql|schema_version 1700 \N patch patch_69_70_a.sql|schema_version 1701 \N patch patch_69_70_b.sql|add_mapping_set_history 1702 \N patch patch_69_70_c.sql|column_datatype_consistency 1703 \N patch patch_69_70_d.sql|data_file_id_auto_increment 1705 \N patch patch_69_70_e.sql|protein_feature_hit_description 1758 \N patch patch_70_71_a.sql|schema_version 1759 \N patch patch_70_71_b.sql|mapping_set_index 1811 \N patch patch_71_72_a.sql|schema_version 1812 \N patch patch_71_72_b.sql|associated_xref 1863 \N patch patch_72_73_a.sql|schema_version 1914 \N patch patch_72_73_b.sql|alt_allele_type 1915 \N patch patch_72_73_c.sql|add_object_type_marker 1916 \N patch patch_73_74_a.sql|schema_version 1917 \N patch patch_73_74_b.sql|remove_dnac 1918 \N patch patch_73_74_c.sql|remove_unconventional_transcript_association 1919 \N patch patch_73_74_d.sql|remove_qtl 1920 \N patch patch_73_74_e.sql|remove_canonical_annotation 1921 \N patch patch_73_74_f.sql|remove_pair_dna_align 1922 \N patch patch_73_74_g.sql|add_transcript_idx_tise 2024 \N patch patch_73_74_h.sql|alt_allele_unique_gene_idx 2025 \N patch patch_74_75_a.sql|schema_version 2026 \N patch patch_74_75_b.sql|transcript_source 2027 \N patch patch_74_75_c.sql|add_genome_statistics 2078 \N patch patch_74_75_d.sql|default_transcript_source 2079 \N patch patch_74_75_e.sql|unique_attrib_key 2080 \N patch patch_74_75_f.sql|longer_code 2090 \N patch patch_75_76_a.sql|schema_version 2091 \N patch patch_75_76_b.sql|allow_null_karyotype 2092 \N patch patch_75_76_c.sql|remove_alternative_splicing 2140 \N patch patch_76_77_a.sql|schema_version 2188 \N patch patch_77_78_a.sql|schema_version 2189 \N patch patch_77_78_b.sql|source_column_increase 2238 1 assembly.ucsc_alias tetNig2 2239 \N patch patch_77_78_c.sql|Change unmapped_reason_id from smallint to int 2240 \N patch patch_78_79_a.sql|schema_version 2288 \N patch patch_78_79_b.sql|bamcov support 2289 \N patch patch_79_80_a.sql|schema_version 2290 \N patch patch_79_80_b.sql|xref_dbprimary_acc_longer 2291 \N patch patch_79_80_c.sql|seq_region_synonym_longer 2339 \N patch patch_79_80_d.sql|genome_statistics_value_longer 2340 \N patch patch_80_81_a.sql|schema_version 2388 \N patch patch_81_82_a.sql|schema_version 2389 \N patch patch_81_82_b.sql|xref_width 2390 \N patch patch_81_82_c.sql|seq_synonym_key 10254 1 species.division EnsemblVertebrates 2441 \N patch patch_82_83_a.sql|schema_version 2489 \N patch patch_83_84_a.sql|schema_version 2490 \N patch patch_83_84_b.sql|xref.version_default 2491 \N patch patch_83_84_c.sql|protein_feature_unique 2492 \N patch patch_83_84_d.sql|longer_synonym 2540 \N patch patch_83_84_e.sql|nullable_versions 2541 \N patch patch_84_85_a.sql|schema_version 2542 \N patch patch_84_85_b.sql|remove_duplicated_key 2590 \N patch patch_85_86_a.sql|schema_version 2638 \N patch patch_85_86_b.sql|add dna_align_feature_attrib table 2639 \N patch patch_85_86_c.sql|meta_case_insensitive 2640 \N patch patch_86_87_a.sql|schema_version 2641 \N patch patch_86_87_b.sql|meta_value_NOT_NULL 2642 \N patch patch_86_87_c.sql|datetime_default_NULL 2692 \N patch patch_87_88_a.sql|schema_version 2693 \N patch patch_87_88_b.sql|seq_region_name_255 2742 \N patch patch_87_88_c.sql|protein_featue_uniqueness 3655 \N patch patch_88_89_a.sql|schema_version 5480 \N patch patch_89_90_a.sql|schema_version 5481 \N patch patch_89_90_b.sql|remove_status 6256 1 prediction_transcriptbuild.level toplevel 6257 1 prediction_exonbuild.level toplevel 7170 \N patch patch_89_90_c.sql|pf_hit_name_case_sensitive 7795 \N patch patch_90_91_a.sql|schema_version 7796 \N patch patch_90_91_b.sql|align_type 7797 \N patch patch_90_91_c.sql|protein_align_type 7798 \N patch patch_90_91_d.sql|remove_external_data 10598 1 species.alias tetraodon 10007 \N patch patch_91_92_a.sql|schema_version 10008 \N patch patch_91_92_b.sql|add_cigar_line_align_type 10573 1 species.classification Clupeocephala 10574 1 species.classification Osteoglossocephalai 10571 1 species.classification Neoteleostei 10572 1 species.classification Euteleosteomorpha 10153 \N patch patch_92_93_a.sql|schema_version 10154 \N patch patch_92_93_b.sql|biotype_table 10155 \N patch patch_92_93_c.sql|collate_index_interpro 10156 \N patch patch_93_94_a.sql|schema_version 10157 \N patch patch_93_94_b.sql|nullable_ox_analysis 10158 \N patch patch_93_94_c.sql|default_aln_type 10585 1 species.classification Deuterostomia 10577 1 species.classification Actinopteri 10207 \N patch patch_94_95_a.sql|schema_version 10208 \N patch patch_94_95_b.sql|vertebrate_division_rename 10575 1 species.classification Teleostei 10576 1 species.classification Neopterygii 10257 \N patch patch_95_96_a.sql|schema_version 10258 \N patch patch_96_97_a.sql|schema_version 10259 \N patch patch_96_97_b.sql|biotype_so_term 10260 \N patch patch_96_97_c.sql|rnaproduct_tables 10261 \N patch patch_96_97_d.sql|add_object_type_rnaproduct 10262 \N patch patch_96_97_e.sql|add_stable_id_event_type_rnaproduct 10599 1 species.alias tetraodon nigroviridis 10586 1 species.classification Bilateria 10584 1 species.classification Chordata 10308 \N patch patch_97_98_a.sql|schema_version 10309 \N patch patch_98_99_a.sql|schema_version 10310 \N patch patch_99_100_a.sql|schema_version 10311 \N patch patch_99_100_b.sql|alter_externaldb_type_notnull 10312 \N patch patch_99_100_c.sql|alter_mapping_session_assembly_length 10313 \N patch patch_100_101_a.sql|schema_version 10314 \N patch patch_101_102_a.sql|schema_version 10315 \N patch patch_102_103_a.sql|schema_version 10316 \N patch patch_103_104_a.sql|schema_version 10317 \N patch patch_104_105_a.sql|schema_version 10318 \N patch patch_80_81_b.sql|xref_width 10597 1 species.alias tetnig 10587 1 species.classification Eumetazoa 10588 1 species.classification Metazoa 10365 \N patch patch_106_107_a.sql|schema_version 10366 \N patch patch_106_107_b.sql|Added index for seq_region_mapping 10367 \N patch patch_107_108_a.sql|schema_version 10600 1 species.alias tetraodon_nigroviridis 10413 \N patch patch_108_109_a.sql|schema_version 10414 \N patch patch_108_109_b.sql|Added xref source GeneCards into external_db 10415 \N patch patch_109_110_a.sql|schema_version 10416 \N patch patch_109_110_b.sql|Add IS_PAR relationship to link X- and Y-PAR genes 10417 \N patch patch_109_110_c.sql|Allow gene id to belong to multiple alt allele groups 10418 \N patch patch_110_111_a.sql|schema_version 10596 1 species.alias spotted green pufferfish 10581 1 species.classification Gnathostomata 10570 1 species.classification Eurypterygia 10566 1 species.classification Percomorphaceae 10567 1 species.classification Euacanthomorphacea 10568 1 species.classification Acanthomorphata 10569 1 species.classification Ctenosquamata 10464 \N patch patch_111_112_a.sql|schema_version 10465 \N patch patch_111_112_b.sql|Allow meta_value to be null 10601 1 species.alias tnig 10582 1 species.classification Vertebrata 10583 1 species.classification Craniata 10580 1 species.classification Teleostomi 10578 1 species.classification Actinopterygii 10579 1 species.classification Euteleostomi 10511 \N patch patch_112_113_a.sql|schema_version 10512 \N patch patch_112_113_b.sql|Ensure meta_value is not null 10560 1 species.classification Tetraodon nigroviridis 10561 1 species.classification Tetraodontidae 10562 1 species.classification Tetradontoidea 10563 1 species.classification Tetraodontoidei 10564 1 species.classification Tetraodontiformes 10565 1 species.classification Eupercaria 10595 1 species.alias fresh water pufferfish 10594 1 species.alias 99883 10589 1 species.classification Opisthokonta 10590 1 species.classification Eukaryota 10602 1 species.alias tnigroviridis 10603 \N patch patch_111_112_c.sql|Extend meta_key length to 64