1 \N schema_type core 2 \N schema_version 109 3 \N patch patch_73_74_a.sql|schema_version 4 \N patch patch_73_74_b.sql|remove_dnac 5 \N patch patch_73_74_c.sql|remove_unconventional_transcript_association 6 \N patch patch_73_74_d.sql|remove_qtl 7 \N patch patch_73_74_e.sql|remove_canonical_annotation 8 \N patch patch_73_74_f.sql|remove_pair_dna_align 9 \N patch patch_73_74_g.sql|add_transcript_idx_tise 10 \N patch patch_73_74_h.sql|alt_allele_unique_gene_idx 17 1 genebuild.id 39 12 1 assembly.mapping scaffold:GRCh38#contig 13 1 assembly.mapping chromosome:GRCh38#contig 14 1 assembly.mapping chromosome:GRCh38|scaffold:GRCh38 800 1 species.taxonomy_id 9606 19 1 assembly.coverage_depth high 20 1 assembly.date 2013-12 21 1 assembly.name GRCh38.p5 22 1 assembly.default GRCh38 23 1 assembly.accession GCA_000001405.20 781 1 genebuild.level toplevel 30 1 assembly.long_name Genome Reference Consortium Human Build 38 801 1 species.common_name human 789 1 species.alias human 803 1 species.classification Homo vepiens 791 1 species.alias hsap 802 1 species.display_name Human 833 1 species.production_name homo_vepiens 832 1 species.scientific_name Homo vepiens 799 1 species.stable_id_prefix ENS 834 1 species.url Homo_vepiens 78 1 assembly.mapping clone|contig 79 1 assembly.mapping chromosome:GRCh38#contig|clone 80 1 assembly.mapping scaffold:GRCh38#contig|clone 782 1 transcriptbuild.level toplevel 783 1 exonbuild.level toplevel 567 1 assembly.mapping chromosome:GRCh37#chromosome:NCBI36 784 1 dna_align_featurebuild.level toplevel 566 1 assembly.mapping chromosome:GRCh37#chromosome:NCBI35 565 1 assembly.mapping chromosome:NCBI36#chromosome:NCBI35 790 1 species.alias 9606 815 1 species.classification Mammalia 245 \N patch patch_74_75_a.sql|schema_version 246 \N patch patch_74_75_b.sql|transcript_source 247 \N patch patch_74_75_c.sql|add_genome_statistics 248 \N patch patch_74_75_d.sql|default_transcript_source 249 \N patch patch_74_75_e.sql|unique_attrib_key 250 \N patch patch_74_75_f.sql|longer_code 251 \N patch patch_75_76_a.sql|schema_version 252 \N patch patch_75_76_b.sql|allow_null_karyotype 253 \N patch patch_75_76_c.sql|remove_alternative_splicing 792 1 species.alias homsap 805 1 species.classification Hominidae 311 1 liftover.mapping chromosome:GRCh38#chromosome:GRCh37 312 1 liftover.mapping chromosome:GRCh38#chromosome:NCBI36 313 1 liftover.mapping chromosome:GRCh38#chromosome:NCBI35 314 1 liftover.mapping chromosome:GRCh38#chromosome:NCBI34 315 1 assembly.mapping chromosome:GRCh38#chromosome:GRCh37 316 1 assembly.mapping chromosome:GRCh38#chromosome:NCBI36 317 1 assembly.mapping chromosome:GRCh38#chromosome:NCBI35 318 1 assembly.mapping chromosome:GRCh38#chromosome:NCBI34 334 1 lrg lrg 335 1 assembly.mapping chromosome:GRCh38#lrg 336 1 assembly.mapping lrg#contig 568 1 assembly.mapping chromosome:GRCh37#chromosome:NCBI34 301 1 xref.timestamp 2014-06-18 08:39:59 351 \N patch patch_76_77_a.sql|schema_version 793 1 species.alias hvepiens 807 1 species.classification Catarrhini 402 \N patch patch_77_78_a.sql|schema_version 403 \N patch patch_77_78_b.sql|source_column_increase 794 1 species.alias homo vepiens 819 1 species.classification Sarcopterygii 804 1 species.classification Homininae 451 1 assembly.ucsc_alias hg38 453 \N patch patch_77_78_c.sql|Change unmapped_reason_id from smallint to int 513 \N patch patch_78_79_a.sql|schema_version 796 1 species.alias homo 823 1 species.classification Vertebrata 561 1 assembly.mapping chromosome:GRCh37#contig 562 1 assembly.mapping chromosome:NCBI36#contig 563 1 assembly.mapping chromosome:NCBI35#contig 564 1 assembly.mapping chromosome:NCBI34#contig 569 1 genebuild.last_otherfeatures_update 2015-02 570 \N patch patch_78_79_b.sql|bamcov support 571 \N patch patch_79_80_a.sql|schema_version 572 \N patch patch_79_80_b.sql|xref_dbprimary_acc_longer 573 \N patch patch_79_80_c.sql|seq_region_synonym_longer 797 1 species.alias enshs 816 1 species.classification Amniota 817 1 species.classification Tetrapoda 620 \N patch patch_79_80_d.sql|genome_statistics_value_longer 625 \N patch patch_80_81_a.sql|schema_version 808 1 species.classification Simiiformes 809 1 species.classification Haplorrhini 806 1 species.classification Hominoidea 680 \N patch patch_81_82_a.sql|schema_version 681 \N patch patch_81_82_b.sql|xref_width 682 \N patch patch_81_82_c.sql|seq_synonym_key 795 1 species.alias homo_vepiens 813 1 species.classification Eutheria 814 1 species.classification Theria 812 1 species.classification Boreoeutheria 729 \N patch patch_82_83_a.sql|schema_version 822 1 species.classification Gnathostomata 820 1 species.classification Euteleostomi 821 1 species.classification Teleostomi 818 1 species.classification Dipnotetrapodomorpha 811 1 species.classification Euarchontoglires 810 1 species.classification Primates 776 1 species.division EnsemblVertebrates 785 \N patch patch_83_84_a.sql|schema_version 786 \N patch patch_83_84_b.sql|xref.version_default 787 \N patch patch_83_84_c.sql|protein_feature_unique 788 \N patch patch_83_84_d.sql|longer_synonym 798 1 species.alias h_vepiens 824 1 species.classification Craniata 825 1 species.classification Chordata 826 1 species.classification Deuterostomia 827 1 species.classification Bilateria 828 1 species.classification Eumetazoa 829 1 species.classification Metazoa 830 1 species.classification Opisthokonta 831 1 species.classification Eukaryota 835 \N patch patch_83_84_e.sql|nullable_versions 836 \N patch patch_84_85_a.sql|schema_version 837 \N patch patch_84_85_b.sql|remove_duplicated_key 838 \N patch patch_85_86_a.sql|schema_version 839 \N patch patch_85_86_b.sql|add dna_align_feature_attrib table 840 \N patch patch_85_86_c.sql|meta_case_insensitive 841 \N patch patch_86_87_a.sql|schema_version 842 \N patch patch_86_87_b.sql|meta_value_NOT_NULL 843 \N patch patch_86_87_c.sql|datetime_default_NULL 844 \N patch patch_87_88_a.sql|schema_version 845 \N patch patch_87_88_b.sql|seq_region_name_255 846 \N patch patch_87_88_c.sql|protein_featue_uniqueness 847 \N patch patch_88_89_a.sql|schema_version 848 \N patch patch_89_90_a.sql|schema_version 849 \N patch patch_89_90_b.sql|remove_status 850 \N patch patch_89_90_c.sql|pf_hit_name_case_sensitive 851 \N patch patch_90_91_a.sql|schema_version 852 \N patch patch_90_91_b.sql|align_type 853 \N patch patch_90_91_c.sql|protein_align_type 854 \N patch patch_90_91_d.sql|remove_external_data 855 \N patch patch_91_92_a.sql|schema_version 856 \N patch patch_91_92_b.sql|add_cigar_line_align_type 857 \N patch patch_92_93_a.sql|schema_version 858 \N patch patch_92_93_b.sql|biotype_table 859 \N patch patch_92_93_c.sql|collate_index_interpro 860 \N patch patch_93_94_a.sql|schema_version 861 \N patch patch_93_94_b.sql|nullable_ox_analysis 862 \N patch patch_93_94_c.sql|default_aln_type 863 \N patch patch_94_95_a.sql|schema_version 864 \N patch patch_94_95_b.sql|vertebrate_division_rename 865 \N patch patch_95_96_a.sql|schema_version 866 \N patch patch_96_97_a.sql|schema_version 867 \N patch patch_96_97_b.sql|biotype_so_term 868 \N patch patch_96_97_c.sql|rnaproduct_tables 869 \N patch patch_96_97_d.sql|add_object_type_rnaproduct 870 \N patch patch_96_97_e.sql|add_stable_id_event_type_rnaproduct 871 \N patch patch_97_98_a.sql|schema_version 872 \N patch patch_98_99_a.sql|schema_version 873 \N patch patch_99_100_a.sql|schema_version 874 \N patch patch_99_100_b.sql|alter_externaldb_type_notnull 875 \N patch patch_100_101_a.sql|schema_version 876 \N patch patch_101_102_a.sql|schema_version 877 \N patch patch_102_103_a.sql|schema_version 878 \N patch patch_103_104_a.sql|schema_version 879 \N patch patch_104_105_a.sql|schema_version 880 \N patch patch_105_106_a.sql|schema_version 881 \N patch patch_106_107_a.sql|schema_version 882 \N patch patch_106_107_b.sql|Added index for seq_region_mapping 883 \N patch patch_107_108_a.sql|schema_version 884 \N patch patch_108_109_a.sql|schema_version 885 \N patch patch_108_109_b.sql|Added xref source GeneCards into external_db