1 \N schema_version 113 2 1 assembly.default CSAV2.0 212 \N patch patch_39_40_a.sql|rationalise_key_columns 113 1 genebuild.id 2 116 1 assembly.mapping reftig:CSAV2.0|chunk:CSAV2.0 117 \N patch patch_38_39_a.sql|status_enum 118 \N patch patch_38_39_b.sql|unique_assembly 119 \N patch patch_38_39_c.sql|multiversion_objects 120 \N patch patch_38_39_d.sql|schema_version 213 \N patch patch_39_40_b.sql|xref_unique_constraint 143 \N patch patch_38_39_e.sql|unknown_status_enum 214 \N patch patch_39_40_c.sql|xref_version 215 \N patch patch_39_40_d.sql|stable_id_event_score_column 216 \N patch patch_39_40_e.sql|is_current_not_null 217 \N patch patch_39_40_f.sql|remove_all_latest 218 \N patch patch_39_40_g.sql|add_ditag_tables 219 \N patch patch_39_40_h.sql|oligo_feature_analysis_id_type 220 \N patch patch_39_40_i.sql|schema_version 232 \N patch patch_39_40_j.sql|marker_synonym_name 244 \N patch patch_40_41_a.sql|analysis_description_displayable 245 \N patch patch_40_41_b.sql|info_type_enum 246 \N patch patch_40_41_c.sql|xref_priority 247 \N patch patch_40_41_d.sql|ditag_primary_key_type 248 \N patch patch_40_41_e.sql|schema_version 263 \N patch patch_40_41_f.sql|attrib_indices 280 1 assembly.name CSAV 2.0 281 1 assembly.date 2005-10 282 \N patch patch_41_42_a.sql|remove_xref_priority 283 \N patch patch_41_42_b.sql|unconventional_transcripts 284 \N patch patch_41_42_c.sql|analysis_description_unique 285 \N patch patch_41_42_d.sql|schema_version 286 \N patch patch_41_42_e.sql|ditag_autoincrement 287 \N patch patch_41_42_f.sql|analysis_description_web_data 299 \N patch patch_41_42_g.sql|genebuild_version_format_change 4031 1 genebuild.level toplevel 4032 1 transcriptbuild.level toplevel 4033 1 exonbuild.level toplevel 304 \N patch patch_42_43_a.sql|unmapped_object.parent 305 \N patch patch_42_43_b.sql|unmapped_object_probe2transcript 306 \N patch patch_42_43_c.sql|info_type_probe_unmapped 307 \N patch patch_42_43_d.sql|unmapped_object_external_db_id 308 \N patch patch_42_43_e.sql|gene_archive.peptide_archive_id.index 309 \N patch patch_42_43_f.sql|schema_version 329 \N patch patch_43_44_a.sql|rationalise_key_columns 330 \N patch patch_43_44_b.sql|optimise_ditag_tables 331 \N patch patch_43_44_c.sql|external_db_type 332 \N patch patch_43_44_d.sql|translation_stable_id_unique 333 \N patch patch_43_44_e.sql|schema_version 345 \N patch patch_43_44_f.sql|external_db_type_syn 350 \N patch patch_44_45_a.sql|schema_version 351 \N patch patch_44_45_b.sql|marker_index 352 \N patch patch_44_45_c.sql|db_release_not_null 366 \N patch patch_45_46_a.sql|schema_version 367 \N patch patch_45_46_b.sql|go_xref.source_xref_id 368 \N patch patch_45_46_c.sql|unmapped_object.external_db_id 369 \N patch patch_45_46_d.sql|meta_unique_key 370 \N patch patch_45_46_e.sql|object_xref_linkage_annotation 371 \N patch patch_45_46_f.sql|stable_id_event.uni_idx 398 \N patch patch_46_47_a.sql|schema_version 399 \N patch patch_46_47_b.sql|new_align_columns 400 \N patch patch_46_47_c.sql|extend_db_release 418 \N patch patch_47_48_a.sql|schema_version 436 \N patch patch_48_49_a.sql|schema_version 437 \N patch patch_48_49_b.sql|new_canonical_transcript_column 438 \N patch patch_48_49_c.sql|regulatory_support_removal 439 \N patch patch_48_49_d.sql|new_info_type_enum 470 \N patch patch_48_49_e.sql|ensembl_object_type_not_null 471 \N patch patch_49_50_a.sql|schema_version 472 \N patch patch_49_50_b.sql|coord_system_version_default 473 \N patch patch_49_50_c.sql|canonical_transcript 474 \N patch patch_49_50_d.sql|seq_region_indices 4034 1 dna_align_featurebuild.level toplevel 4001 1 genebuild.last_otherfeatures_update 2006-06 501 \N patch patch_49_50_e.sql|mapping_seq_region 502 \N patch patch_50_51_a.sql|schema_version 503 \N patch patch_50_51_b.sql|protein_feature_hit_name 504 \N patch patch_50_51_c.sql|meta_coord_index 505 \N patch patch_50_51_d.sql|multispecies 506 \N patch patch_50_51_e.sql|feature_external_data 507 \N patch patch_50_51_f.sql|meta_species_id_values 508 \N patch patch_50_51_g.sql|protein_feature_score 522 \N patch patch_50_51_h.sql|external_db_db_name 523 \N patch patch_50_51_i.sql|meta_value_binary 536 \N patch patch_51_52_a.sql|schema_version 537 \N patch patch_51_52_b.sql|widen_columns 538 \N patch patch_51_52_c.sql|pair_dna_align_feature_id 539 \N patch patch_51_52_d.sql|external_db_description 549 \N patch patch_52_53_a.sql|schema_version 550 \N patch patch_52_53_b.sql|external_db_type_enum 551 \N patch patch_52_53_c.sql|identity_xref_rename 552 \N patch patch_52_53_d.sql|drop_go_xref_index 581 1 assembly.coverage_depth high 802 \N patch patch_58_59_a.sql|schema_version 583 \N patch patch_53_54_a.sql|schema_version 584 \N patch patch_53_54_b.sql|widen_columns 585 \N patch patch_53_54_c.sql|identity_object_analysis_move 603 \N patch patch_45_46_g.sql|object_xref_linkage_annotation 615 \N patch patch_54_55_a.sql|schema_version 616 \N patch patch_54_55_b.sql|add_go_xrefs_types 617 \N patch patch_54_55_c.sql|add_splicing_event_tables 618 \N patch patch_54_55_d.sql|add_dependent_xref_table 619 \N patch patch_54_55_e.sql|add_is_constitutive_column 620 \N patch patch_54_55_f.sql|coord_system.version_null 652 \N patch patch_54_55_g.sql|analysis_description.display_label_NOT_NULL 653 \N patch patch_54_55_h.sql|gene_archive.allow_for_NULLs 6437 1 species.stable_id_prefix ENSCSAV 655 \N patch patch_55_56_a.sql|schema_version 656 \N patch patch_55_56_b.sql|add_index_names 657 \N patch patch_55_56_c.sql|drop_oligo_tables_and_xrefs 658 \N patch patch_55_56_d.sql|add_index_to_splicing_event_feature 722 \N patch patch_56_57_a.sql|schema_version 723 \N patch patch_56_57_b.sql|unmapped_object.typ_enum_tidy 724 \N patch patch_56_57_c.sql|external_db_type_enum 742 \N patch patch_56_57_d.sql|allow_meta_null 743 \N patch patch_56_57_e.sql|canonical_translations 744 \N patch patch_56_57_f.sql|simple_feature.display_label 773 \N patch patch_57_58_a.sql|schema_version 6647 1 species.production_name ciona_savignyi 6646 1 species.taxonomy_id 51511 803 \N patch patch_58_59_b.sql|assembly_exception_exc_type_enum 804 \N patch patch_58_59_c.sql|splicing_event_attrib_type_id 805 \N patch patch_58_59_d.sql|object_xref_extend_index 806 \N schema_type core 807 \N patch patch_58_59_e.sql|meta_schema_type 6662 1 species.scientific_name Ciona savignyi 819 \N patch patch_59_60_a.sql|schema_version 820 \N patch patch_59_60_b.sql|rename_go_xref_table 821 \N patch patch_59_60_c.sql|QC_fixes 850 \N patch patch_60_61_a.sql|schema_version 851 \N patch patch_60_61_b.sql|create_seq_region_synonym_table 852 \N patch patch_60_61_c.sql|rejig_object_xref_indexes 880 \N patch patch_61_62_a.sql|schema_version 881 \N patch patch_61_62_b.sql|synonym_field_extension 882 \N patch patch_61_62_d.sql|remove_display_label_linkable 883 \N patch patch_61_62_c.sql|db_name_db_release_idx 886 \N patch patch_61_62_e.sql|seq_region_synonym_seq_region_idx 887 \N patch patch_62_63_a.sql|schema_version 888 \N patch patch_62_63_b.sql|indexing_changes 889 \N patch patch_62_63_c.sql|remove_dbprimary_acc_linkable 919 \N patch patch_63_64_a.sql|schema_version 920 \N patch patch_63_64_b.sql|add_operons 921 \N patch patch_63_64_c.sql|is_ref_added_to_alt_allele 925 \N patch patch_63_64_d.sql|linkage_type change in ontology_xref 926 \N patch patch_64_65_a.sql|schema_version 927 \N patch patch_64_65_b.sql|merge_stable_id_with_object 928 \N patch patch_64_65_c.sql|add_data_file 929 \N patch patch_64_65_d.sql|add_checksum_info_type 931 \N patch patch_65_66_a.sql|schema_version 932 \N patch patch_65_66_b.sql|fix_external_db_id 933 \N patch patch_65_66_c.sql|reorder_unmapped_obj_index 934 \N patch patch_65_66_d.sql|add_index_to_ontology_xref_table 935 \N patch patch_65_66_e.sql|fix_external_db_id_in_xref 936 \N patch patch_65_66_f.sql|drop_default_values 977 \N patch patch_66_67_a.sql|schema_version 978 \N patch patch_66_67_b.sql|drop_stable_id_views 979 \N patch patch_66_67_c.sql|adding_intron_supporting_evidence 980 \N patch patch_66_67_d.sql|adding_gene_transcript_annotated 981 \N patch patch_66_67_e.sql|index_canonical_transcript_id 1220 \N patch patch_67_68_e.sql|fix_67_68_e_xref_index 6439 1 species.common_name Sea squirt Ciona savignyi 6649 1 species.display_name C.savignyi 6648 1 species.url Ciona_savignyi 1157 \N patch patch_67_68_a.sql|schema_version 1158 \N patch patch_67_68_b.sql|xref_uniqueness 1159 \N patch patch_67_68_c.sql|altering_intron_supporting_evidence 1160 \N patch patch_67_68_d.sql|add_is_splice_canonical_and_seq_index 1221 \N patch patch_68_69_a.sql|schema_version 1252 \N patch patch_69_70_a.sql|schema_version 1253 \N patch patch_69_70_b.sql|add_mapping_set_history 1254 \N patch patch_69_70_c.sql|column_datatype_consistency 1255 \N patch patch_69_70_d.sql|data_file_id_auto_increment 1256 \N patch patch_69_70_e.sql|protein_feature_hit_description 1287 \N patch patch_70_71_a.sql|schema_version 1288 \N patch patch_70_71_b.sql|mapping_set_index 1318 \N patch patch_71_72_a.sql|schema_version 1319 \N patch patch_71_72_b.sql|associated_xref 1349 \N patch patch_72_73_a.sql|schema_version 1378 \N patch patch_72_73_b.sql|alt_allele_type 1379 \N patch patch_72_73_c.sql|add_object_type_marker 1380 \N patch patch_73_74_a.sql|schema_version 1381 \N patch patch_73_74_b.sql|remove_dnac 1382 \N patch patch_73_74_c.sql|remove_unconventional_transcript_association 1383 \N patch patch_73_74_d.sql|remove_qtl 1384 \N patch patch_73_74_e.sql|remove_canonical_annotation 1385 \N patch patch_73_74_f.sql|remove_pair_dna_align 1386 \N patch patch_73_74_g.sql|add_transcript_idx_tise 1443 \N patch patch_73_74_h.sql|alt_allele_unique_gene_idx 1444 \N patch patch_74_75_a.sql|schema_version 1445 \N patch patch_74_75_b.sql|transcript_source 1446 \N patch patch_74_75_c.sql|add_genome_statistics 1475 \N patch patch_74_75_d.sql|default_transcript_source 1476 \N patch patch_74_75_e.sql|unique_attrib_key 1477 \N patch patch_74_75_f.sql|longer_code 1478 \N patch patch_75_76_a.sql|schema_version 1479 \N patch patch_75_76_b.sql|allow_null_karyotype 1480 \N patch patch_75_76_c.sql|remove_alternative_splicing 1510 \N patch patch_76_77_a.sql|schema_version 1539 \N patch patch_77_78_a.sql|schema_version 1540 \N patch patch_77_78_b.sql|source_column_increase 1597 \N patch patch_77_78_c.sql|Change unmapped_reason_id from smallint to int 1598 \N patch patch_78_79_a.sql|schema_version 1627 \N patch patch_78_79_b.sql|bamcov support 1628 \N patch patch_79_80_a.sql|schema_version 1629 \N patch patch_79_80_b.sql|xref_dbprimary_acc_longer 1630 \N patch patch_79_80_c.sql|seq_region_synonym_longer 1659 \N patch patch_79_80_d.sql|genome_statistics_value_longer 1661 \N patch patch_80_81_a.sql|schema_version 1690 \N patch patch_81_82_a.sql|schema_version 1691 \N patch patch_81_82_b.sql|xref_width 1692 \N patch patch_81_82_c.sql|seq_synonym_key 6455 1 species.division EnsemblVertebrates 1722 \N patch patch_82_83_a.sql|schema_version 1751 \N patch patch_83_84_a.sql|schema_version 1752 \N patch patch_83_84_b.sql|xref.version_default 1753 \N patch patch_83_84_c.sql|protein_feature_unique 1754 \N patch patch_83_84_d.sql|longer_synonym 1783 \N patch patch_83_84_e.sql|nullable_versions 1784 \N patch patch_84_85_a.sql|schema_version 1785 \N patch patch_84_85_b.sql|remove_duplicated_key 1814 \N patch patch_85_86_a.sql|schema_version 1844 \N patch patch_85_86_b.sql|add dna_align_feature_attrib table 1845 \N patch patch_85_86_c.sql|meta_case_insensitive 1846 \N patch patch_86_87_a.sql|schema_version 1847 \N patch patch_86_87_b.sql|meta_value_NOT_NULL 1848 \N patch patch_86_87_c.sql|datetime_default_NULL 1878 \N patch patch_87_88_a.sql|schema_version 1879 \N patch patch_87_88_b.sql|seq_region_name_255 1909 \N patch patch_87_88_c.sql|protein_featue_uniqueness 2461 \N patch patch_88_89_a.sql|schema_version 3564 \N patch patch_89_90_a.sql|schema_version 3565 \N patch patch_89_90_b.sql|remove_status 4035 1 protein_align_featurebuild.level toplevel 4587 \N patch patch_89_90_c.sql|pf_hit_name_case_sensitive 4965 \N patch patch_90_91_a.sql|schema_version 4966 \N patch patch_90_91_b.sql|align_type 4967 \N patch patch_90_91_c.sql|protein_align_type 4968 \N patch patch_90_91_d.sql|remove_external_data 6657 1 species.classification Bilateria 6658 1 species.classification Eumetazoa 6641 1 species.alias ciona_savignyi 6303 \N patch patch_91_92_a.sql|schema_version 6304 \N patch patch_91_92_b.sql|add_cigar_line_align_type 6392 \N patch patch_92_93_a.sql|schema_version 6393 \N patch patch_92_93_b.sql|biotype_table 6394 \N patch patch_92_93_c.sql|collate_index_interpro 6395 \N patch patch_93_94_a.sql|schema_version 6396 \N patch patch_93_94_b.sql|nullable_ox_analysis 6397 \N patch patch_93_94_c.sql|default_aln_type 6642 1 species.alias ciosav 6655 1 species.classification Chordata 6427 \N patch patch_94_95_a.sql|schema_version 6428 \N patch patch_94_95_b.sql|vertebrate_division_rename 6654 1 species.classification Tunicata 6458 \N patch patch_95_96_a.sql|schema_version 6459 \N patch patch_96_97_a.sql|schema_version 6460 \N patch patch_96_97_b.sql|biotype_so_term 6461 \N patch patch_96_97_c.sql|rnaproduct_tables 6462 \N patch patch_96_97_d.sql|add_object_type_rnaproduct 6463 \N patch patch_96_97_e.sql|add_stable_id_event_type_rnaproduct 6643 1 species.alias csav 6490 \N patch patch_97_98_a.sql|schema_version 6491 \N patch patch_98_99_a.sql|schema_version 6492 \N patch patch_99_100_a.sql|schema_version 6493 \N patch patch_99_100_b.sql|alter_externaldb_type_notnull 6494 \N patch patch_99_100_c.sql|alter_mapping_session_assembly_length 6495 \N patch patch_100_101_a.sql|schema_version 6496 \N patch patch_101_102_a.sql|schema_version 6497 \N patch patch_102_103_a.sql|schema_version 6498 \N patch patch_103_104_a.sql|schema_version 6499 \N patch patch_104_105_a.sql|schema_version 6500 \N patch patch_80_81_b.sql|xref_width 6501 \N patch patch_105_106_a.sql|schema_version 6640 1 species.alias ciona savignyi 6659 1 species.classification Metazoa 6527 \N patch patch_106_107_a.sql|schema_version 6528 \N patch patch_106_107_b.sql|Added index for seq_region_mapping 6529 \N patch patch_107_108_a.sql|schema_version 6644 1 species.alias csavignyi 6653 1 species.classification Ascidiacea 6555 \N patch patch_108_109_a.sql|schema_version 6556 \N patch patch_108_109_b.sql|Added xref source GeneCards into external_db 6557 \N patch patch_109_110_a.sql|schema_version 6558 \N patch patch_109_110_b.sql|Add IS_PAR relationship to link X- and Y-PAR genes 6559 \N patch patch_109_110_c.sql|Allow gene id to belong to multiple alt allele groups 6560 \N patch patch_110_111_a.sql|schema_version 6639 1 species.alias c.savignyi 6652 1 species.classification Phlebobranchia 6586 \N patch patch_111_112_a.sql|schema_version 6587 \N patch patch_111_112_b.sql|Allow meta_value to be null 6645 1 species.alias sea squirt ciona savignyi 6660 1 species.classification Opisthokonta 6650 1 species.classification Ciona savignyi 6651 1 species.classification Cionidae 6638 1 species.alias 51511 6656 1 species.classification Deuterostomia 6661 1 species.classification Eukaryota 6663 \N patch patch_111_112_c.sql|Extend meta_key length to 64