RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA397733" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA397733 · 5 ✖

analysis 1

  • diamond · 5 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
27945009 27945009 PRJNA397733_S_NODE_16105_length_154_cov_1.512000_g16017_i0 PRJNA397733 16105 154 1.512 2.32848 Metazoa 33208 Platyhelminthes Platyhelminthes 101 5.820000000000001e-26   NR VUZ44175.1 6216 g16017 i0 96 145.071428571429 50 2 97.4 0 3 152 93 142 VUZ44175.1 unnamed protein product, partial [Hymenolepis diminuta] diamond 22341 102 0.990196078431373 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Hymenolepididae Hymenolepis Hymenolepis diminuta
28639784 28639784 PRJNA397733_S_NODE_8387_length_207_cov_8.578652_g8299_i0 PRJNA397733 8387 207 8.578652 17.75780964 root 1 Root_unresolved Root_unresolved 136 4.86e-36   NR AAW27432.1 6182 g8299 i0 98.5 832.04347826087 68 1 98.6 0 206 3 258 325 AAW27432.1 SJCHGC09424 protein [Schistosoma japonicum] diamond 172233 137 0.992700729927007 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29649506 29649506 PRJNA397733_S_NODE_16630_length_151_cov_8.016393_g16542_i0 PRJNA397733 16630 151 8.016393 12.10475343 Metazoa 33208 Platyhelminthes Platyhelminthes 112 1.92e-27   NR THD23866.1 6192 g16542 i0 96 465.894039735099 50 2 99.3 0 150 1 67 116 THD23866.1 tubulin alpha chain testis-specific [Fasciola hepatica] diamond 70350 113 0.991150442477876 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciola Fasciola hepatica
31419298 31419298 PRJNA397733_S_NODE_8196_length_210_cov_2.972376_g8108_i0 PRJNA397733 8196 210 2.972376 6.2419896 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 137 1.65e-36   NR XP_024352635.1 6210 g8108 i0 100 163 68 0 97.1 0 208 5 329 396 XP_024352635.1 26S protease regulatory subunit 4 [Echinococcus granulosus] diamond 34230 137 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus
31482855 31482855 PRJNA397733_S_NODE_15656_length_155_cov_4.968254_g15568_i0 PRJNA397733 15656 155 4.968254 7.7007937 Metazoa 33208 Platyhelminthes Platyhelminthes 98.6 3.49e-23   NR AAP06321.1 6182 g15568 i0 100 299.090322580645 51 0 98.7 0 3 155 55 105 AAP06321.1 similar to NM_007126 transitional endoplasmic reticulum ATPase [Schistosoma japonicum] diamond 46359 98.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;