RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA399711" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA399711 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
32952342 32952342 PRJNA399711_S_NODE_90794_length_160_cov_4.398374_g90652_i0 PRJNA399711 90794 160 4.398374 7.0373984 Haliotis rufescens 6454 Mollusca Mollusca 44.3 0.00278   NR XP_046355967.1 6454 g90652 i0 56.1 4.40625 41 18 76.9 0 158 36 165 205 XP_046355967.1 pre-mRNA-splicing factor SPF27-like [Haliotis rufescens] diamond 705 44.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
32969140 32969140 PRJNA399711_S_NODE_34538_length_227_cov_3.552632_g34396_i0 PRJNA399711 34538 227 3.552632 8.06447464 Bradybaena similaris 145626 Mollusca Mollusca 46.6 0.00102   NR BFZ08772.1 145626 g34396 i0 60 0.462555066079295 35 14 46.3 0 220 116 184 218 BFZ08772.1 hypothetical protein BsWGS_11812 [Bradybaena similaris] diamond 105 46.6 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
33003217 33003217 PRJNA399711_S_NODE_51867_length_196_cov_6.496855_g51725_i0 PRJNA399711 51867 196 6.496855 12.7338358 Elysia chlorotica 188477 Mollusca Mollusca 71.2 1.71e-12   NR RUS88711.1 188477 g51725 i0 47.6 1.92857142857143 63 33 96.4 0 6 194 145 207 RUS88711.1 hypothetical protein EGW08_003526 [Elysia chlorotica] diamond 378 71.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia chlorotica
33020386 33020386 PRJNA399711_S_NODE_76084_length_171_cov_2.253731_g75942_i0 PRJNA399711 76084 171 2.253731 3.85388001 Tegillarca granosa 220873 Mollusca Mollusca 57.4 2.1e-8   NR KAJ8309193.1 220873 g75942 i0 82.8 2.96491228070175 29 5 50.9 0 3 89 67 95 KAJ8309193.1 hypothetical protein KUTeg_014067 [Tegillarca granosa] diamond 507 57.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Arcoida Arcidae Tegillarca Tegillarca granosa
33088387 33088387 PRJNA399711_S_NODE_33590_length_229_cov_4.984375_g33448_i0 PRJNA399711 33590 229 4.984375 11.41421875 Octopus sinensis 2607531 Mollusca Mollusca 66.2 1.55e-10   NR XP_029657608.1 2607531 g33448 i0 50 4.28384279475982 72 35 93 1 3 215 414 485 XP_029657608.1 uncharacterized protein LOC115231815 [Octopus sinensis] diamond 981 66.2 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus sinensis
33105371 33105371 PRJNA399711_S_NODE_21046_length_270_cov_16.218884_g20904_i0 PRJNA399711 21046 270 16.218884 43.7909868 Haliotis asinina 109174 Mollusca Mollusca 43.9 0.0196   NR XP_067657806.1 109174 g20904 i0 35.4 1.42222222222222 65 36 71.1 2 240 49 144 203 XP_067657806.1 uncharacterized protein [Haliotis asinina] diamond 384 43.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
33146056 33146056 PRJNA399711_S_NODE_33711_length_229_cov_3.067708_g33569_i0 PRJNA399711 33711 229 3.067708 7.02505132 Metazoa 33208 Mollusca Mollusca 119 5.04e-33   NR XP_014777882.1 37653 g33569 i0 75.7 7.75545851528384 74 18 96.9 0 227 6 8 81 XP_014777882.1 60S ribosomal protein L37 [Octopus bimaculoides] diamond 1776 119 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus bimaculoides

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);;