1 \N schema_type core 2 \N schema_version 113 3 \N patch patch_92_93_a.sql|schema_version 4 \N patch patch_92_93_b.sql|biotype_table 5 \N patch patch_92_93_c.sql|collate_index_interpro 6 1 genebuild.start_date 2018-05-Ensembl 7 1 assembly.date 2014-04 122 1 species.common_name guppy 491 1 species.display_name Guppy 490 1 species.scientific_name Poecilia reticulata 493 1 species.taxonomy_id 8081 12 1 assembly.accession GCA_000633615.2 13 1 assembly.default Guppy_female_1.0_MT 14 1 assembly.name Guppy_female_1.0_MT 15 1 assembly.web_accession_source NCBI 16 1 assembly.web_accession_type GenBank Assembly ID 17 1 assembly.coverage_depth high 18 1 genebuild.id 32 19 1 genebuild.method full_genebuild 20 1 genebuild.projection_source_db danio_rerio_core_92_11 21 1 annotation.provider_name Ensembl 22 1 annotation.provider_url www.ensembl.org 494 1 species.production_name poecilia_reticulata 211 1 repeat.analysis repeatmask_repbase_teleost 210 1 repeat.analysis dust 468 1 species.classification Ctenosquamata 469 1 species.classification Eurypterygia 470 1 species.classification Neoteleostei 471 1 species.classification Euteleosteomorpha 472 1 species.classification Clupeocephala 59 1 genebuild.level toplevel 60 1 transcriptbuild.level toplevel 61 1 exonbuild.level toplevel 62 1 repeat_featurebuild.level toplevel 63 1 dna_align_featurebuild.level toplevel 64 1 protein_align_featurebuild.level toplevel 65 1 simple_featurebuild.level toplevel 66 1 prediction_transcriptbuild.level toplevel 67 1 prediction_exonbuild.level toplevel 120 1 species.stable_id_prefix ENSPRE 492 1 species.url Poecilia_reticulata 70 1 genebuild.initial_release_date 2018-07 71 1 genebuild.last_geneset_update 2020-03 157 1 species.division EnsemblVertebrates 73 \N patch patch_93_94_a.sql|schema_version 74 \N patch patch_93_94_b.sql|nullable_ox_analysis 75 \N patch patch_93_94_c.sql|default_aln_type 466 1 species.classification Euacanthomorphacea 547 1 xref.timestamp 2024-07-30 16:57:05 540 1 sample.location_param LG19:16223017-16231247 541 1 sample.location_text LG19:16223017-16231247 536 1 sample.gene_param ENSPREG00000010893 537 1 sample.gene_text mfsd13a 538 1 sample.transcript_param ENSPRET00000016327 539 1 sample.transcript_text mfsd13a-201 117 \N patch patch_94_95_a.sql|schema_version 118 \N patch patch_94_95_b.sql|vertebrate_division_rename 478 1 species.classification Euteleostomi 160 \N patch patch_95_96_a.sql|schema_version 162 \N patch patch_96_97_a.sql|schema_version 163 \N patch patch_96_97_b.sql|biotype_so_term 164 \N patch patch_96_97_c.sql|rnaproduct_tables 165 \N patch patch_96_97_d.sql|add_object_type_rnaproduct 166 \N patch patch_96_97_e.sql|add_stable_id_event_type_rnaproduct 473 1 species.classification Osteoglossocephalai 474 1 species.classification Teleostei 205 \N patch patch_97_98_a.sql|schema_version 542 1 sample.search_text glycoprotein 208 \N patch patch_98_99_a.sql|schema_version 213 1 repeat.analysis trf 214 \N patch patch_99_100_a.sql|schema_version 215 \N patch patch_99_100_b.sql|alter_externaldb_type_notnull 216 \N patch patch_99_100_c.sql|alter_mapping_session_assembly_length 218 \N patch patch_100_101_a.sql|schema_version 219 1 assembly.provider_name 220 1 assembly.provider_url 221 \N patch patch_101_102_a.sql|schema_version 222 \N patch patch_102_103_a.sql|schema_version 223 \N patch patch_103_104_a.sql|schema_version 224 \N patch patch_104_105_a.sql|schema_version 544 1 sample.vep_hgvs ENSPRET00000000760.1:c.4A>T\\nENSPRET00000001055.1:c.57+16C>A\\nENSPRET00000000819.1:c.5del 545 1 sample.vep_vcf LG2 27965287 . A T . . .\\nLG3 19937466 . C A . . .\\nLG9 22883001 . TA T . . . 234 1 sample.vep_spdi NC_024332.1:27965286:A:T\\nNC_024333.1:19937465:C:A\\nNC_024339.1:22883001:A: 543 1 sample.vep_ensembl LG2 27965287 27965287 A/T 1\\nLG3 19937466 19937466 C/A 1\\nLG9 22883002 22883002 A/- 1 236 \N patch patch_105_106_a.sql|schema_version 467 1 species.classification Acanthomorphata 284 \N patch patch_106_107_a.sql|schema_version 285 \N patch patch_106_107_b.sql|Added index for seq_region_mapping 296 \N patch patch_107_108_a.sql|schema_version 479 1 species.classification Teleostomi 344 \N patch patch_108_109_a.sql|schema_version 345 \N patch patch_108_109_b.sql|Added xref source GeneCards into external_db 356 \N patch patch_109_110_a.sql|schema_version 357 \N patch patch_109_110_b.sql|Add IS_PAR relationship to link X- and Y-PAR genes 358 \N patch patch_109_110_c.sql|Allow gene id to belong to multiple alt allele groups 369 \N patch patch_110_111_a.sql|schema_version 476 1 species.classification Actinopteri 464 1 species.classification Ovalentaria 465 1 species.classification Percomorphaceae 481 1 species.classification Vertebrata 480 1 species.classification Gnathostomata 477 1 species.classification Actinopterygii 417 \N patch patch_111_112_a.sql|schema_version 418 \N patch patch_111_112_b.sql|Allow meta_value to be null 475 1 species.classification Neopterygii 458 1 species.classification Poecilia reticulata 459 1 species.classification Poeciliinae 460 1 species.classification Poeciliidae 461 1 species.classification Cyprinodontoidei 462 1 species.classification Cyprinodontiformes 463 1 species.classification Atherinomorphae 456 \N patch patch_112_113_a.sql|schema_version 457 \N patch patch_112_113_b.sql|Ensure meta_value is not null 482 1 species.classification Craniata 483 1 species.classification Chordata 484 1 species.classification Deuterostomia 485 1 species.classification Bilateria 486 1 species.classification Eumetazoa 487 1 species.classification Metazoa 488 1 species.classification Opisthokonta 489 1 species.classification Eukaryota