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 855 1 species.taxonomy_id 9606 16 1 genebuild.last_geneset_update 2015-10 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 24 1 assembly.web_accession_source NCBI 25 1 assembly.web_accession_type GenBank Assembly ID 26 1 genebuild.start_date 2014-01-Ensembl 27 1 genebuild.initial_release_date 2014-07 300 1 gencode.version GENCODE 24 830 1 genebuild.level toplevel 30 1 assembly.long_name Genome Reference Consortium Human Build 38 31 1 genebuild.method full_genebuild 856 1 species.common_name human 844 1 species.alias human_vep 865 1 species.classification Primates 866 1 species.classification Euarchontoglires 846 1 species.alias hsap 857 1 species.display_name Human 888 1 species.production_name homo_vepiens 887 1 species.scientific_name Homo vepiens 854 1 species.stable_id_prefix ENS 889 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 87 1 repeat.analysis repeatmask_repbase_human 88 1 repeat.analysis dust 89 1 repeat.analysis trf 831 1 transcriptbuild.level toplevel 832 1 exonbuild.level toplevel 833 1 repeat_featurebuild.level toplevel 834 1 dna_align_featurebuild.level toplevel 835 1 protein_align_featurebuild.level toplevel 836 1 simple_featurebuild.level toplevel 837 1 prediction_transcriptbuild.level toplevel 838 1 prediction_exonbuild.level toplevel 845 1 species.alias 9606 858 1 species.classification Homo sapiens 197 1 genebuild.havana_datafreeze_date 04-08-2015 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 847 1 species.alias homsap 868 1 species.classification Eutheria 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 337 1 removed_evidence_flag.ensembl_dbversion homo_sapiens_core_84_38 843 1 xref.timestamp 2015-12-29 01:19:38 340 1 removed_evidence_flag.uniprot_dbversion uniprot_2016_01 351 \N patch patch_76_77_a.sql|schema_version 848 1 species.alias hsapiens 871 1 species.classification Amniota 872 1 species.classification Tetrapoda 402 \N patch patch_77_78_a.sql|schema_version 403 \N patch patch_77_78_b.sql|source_column_increase 849 1 species.alias homo sapiens 867 1 species.classification Boreoeutheria 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 851 1 species.alias homo 873 1 species.classification Dipnotetrapodomorpha 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 565 1 assembly.mapping chromosome:GRCh37#chromosome:NCBI36 566 1 assembly.mapping chromosome:GRCh37#chromosome:NCBI35 567 1 assembly.mapping chromosome:GRCh37#chromosome:NCBI34 568 1 assembly.mapping chromosome:NCBI36#chromosome:NCBI35 569 \N patch patch_78_79_b.sql|bamcov support 570 \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 852 1 species.alias enshs 859 1 species.classification Homininae 860 1 species.classification Hominidae 621 \N patch patch_79_80_d.sql|genome_statistics_value_longer 658 \N patch patch_80_81_a.sql|schema_version 861 1 species.classification Hominoidea 862 1 species.classification Catarrhini 706 \N patch patch_81_82_a.sql|schema_version 707 \N patch patch_81_82_b.sql|xref_width 708 \N patch patch_81_82_c.sql|seq_synonym_key 850 1 species.alias homo_sapiens 874 1 species.classification Sarcopterygii 875 1 species.classification Euteleostomi 863 1 species.classification Simiiformes 864 1 species.classification Haplorrhini 757 1 species.division EnsemblVertebrates 781 \N patch patch_82_83_a.sql|schema_version 878 1 species.classification Vertebrata 876 1 species.classification Teleostomi 877 1 species.classification Gnathostomata 869 1 species.classification Theria 870 1 species.classification Mammalia 839 \N patch patch_83_84_a.sql|schema_version 840 \N patch patch_83_84_b.sql|xref.version_default 841 \N patch patch_83_84_c.sql|protein_feature_unique 842 \N patch patch_83_84_d.sql|longer_synonym 853 1 species.alias h_sapiens 879 1 species.classification Craniata 880 1 species.classification Chordata 881 1 species.classification Deuterostomia 882 1 species.classification Bilateria 883 1 species.classification Eumetazoa 884 1 species.classification Metazoa 885 1 species.classification Opisthokonta 886 1 species.classification Eukaryota 890 \N patch patch_83_84_e.sql|nullable_versions 891 \N patch patch_84_85_a.sql|schema_version 892 \N patch patch_84_85_b.sql|remove_duplicated_key 893 \N patch patch_85_86_a.sql|schema_version 894 \N patch patch_85_86_b.sql|add dna_align_feature_attrib table 895 \N patch patch_85_86_c.sql|meta_case_insensitive 896 \N patch patch_86_87_a.sql|schema_version 897 \N patch patch_86_87_b.sql|meta_value_NOT_NULL 898 \N patch patch_86_87_c.sql|datetime_default_NULL 899 \N patch patch_87_88_a.sql|schema_version 900 \N patch patch_87_88_b.sql|seq_region_name_255 901 \N patch patch_87_88_c.sql|protein_featue_uniqueness 902 \N patch patch_88_89_a.sql|schema_version 903 \N patch patch_89_90_a.sql|schema_version 904 \N patch patch_89_90_b.sql|remove_status 905 \N patch patch_89_90_c.sql|pf_hit_name_case_sensitive 906 \N patch patch_90_91_a.sql|schema_version 907 \N patch patch_90_91_b.sql|align_type 908 \N patch patch_90_91_c.sql|protein_align_type 909 \N patch patch_90_91_d.sql|remove_external_data 910 \N patch patch_91_92_a.sql|schema_version 911 \N patch patch_91_92_b.sql|add_cigar_line_align_type 912 \N patch patch_92_93_a.sql|schema_version 913 \N patch patch_92_93_b.sql|biotype_table 914 \N patch patch_92_93_c.sql|collate_index_interpro 915 \N patch patch_93_94_a.sql|schema_version 916 \N patch patch_93_94_b.sql|nullable_ox_analysis 917 \N patch patch_93_94_c.sql|default_aln_type 918 \N patch patch_94_95_a.sql|schema_version 919 \N patch patch_94_95_b.sql|vertebrate_division_rename 920 \N patch patch_95_96_a.sql|schema_version 921 \N patch patch_96_97_a.sql|schema_version 922 \N patch patch_96_97_b.sql|biotype_so_term 923 \N patch patch_96_97_c.sql|rnaproduct_tables 924 \N patch patch_96_97_d.sql|add_object_type_rnaproduct 925 \N patch patch_96_97_e.sql|add_stable_id_event_type_rnaproduct 926 \N patch patch_97_98_a.sql|schema_version 927 \N patch patch_98_99_a.sql|schema_version 928 \N patch patch_99_100_a.sql|schema_version 929 \N patch patch_99_100_b.sql|alter_externaldb_type_notnull 930 \N patch patch_99_100_c.sql|alter_mapping_session_assembly_length 931 \N patch patch_100_101_a.sql|schema_version 932 \N patch patch_101_102_a.sql|schema_version 933 \N patch patch_102_103_a.sql|schema_version 934 \N patch patch_103_104_a.sql|schema_version 935 \N patch patch_104_105_a.sql|schema_version 936 \N patch patch_105_106_a.sql|schema_version 937 \N patch patch_106_107_a.sql|schema_version 938 \N patch patch_106_107_b.sql|Added index for seq_region_mapping 939 \N patch patch_107_108_a.sql|schema_version 940 \N patch patch_108_109_a.sql|schema_version 941 \N patch patch_108_109_b.sql|Added xref source GeneCards into external_db