RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1123686" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1123686 · 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
27027720 27027720 PRJNA1123686_S_NODE_1862_length_291_cov_118.458015_g1830_i0 PRJNA1123686 1862 291 118.458015 344.71282365 Metazoa 33208 Mollusca Mollusca 57 1.14e-7   NR XP_052281997.1 45954 g1830 i0 45.9 70.1855670103093 85 46 87.6 0 16 270 59 143 XP_052281997.1 40S ribosomal protein S15-like isoform X2 [Dreissena polymorpha] diamond 20424 57.4 0.993031358885017 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Dreissenidae Dreissena Dreissena polymorpha
28175506 28175506 PRJNA1123686_S_NODE_2406_length_273_cov_43.086066_g2374_i0 PRJNA1123686 2406 273 43.086066 117.62496018 Acanthosepion pharaonis 158019 Mollusca Mollusca 42.7 0.0424   NR CAE1297564.1 158019 g2374 i0 56.6 0.582417582417582 53 23 58.2 0 3 161 164 216 CAE1297564.1 EEF1B [Acanthosepion pharaonis] diamond 159 42.7 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Sepiida Sepiidae Acanthosepion Acanthosepion pharaonis
28838654 28838654 PRJNA1123686_S_NODE_1008_length_333_cov_88.273026_g976_i0 PRJNA1123686 1008 333 88.273026 293.94917658 Conus magus 6492 Mollusca Mollusca 67.8 4.99e-12   NR QFQ61218.1 6492 g976 i0 54.7 0.675675675675676 75 34 67.6 0 2 226 14 88 QFQ61218.1 60S ribosomal protein L10 [Conus magus] diamond 225 67.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Neogastropoda Conidae Conus Conus magus
28922451 28922451 PRJNA1123686_S_NODE_5708_length_221_cov_201.994792_g5676_i0 PRJNA1123686 5708 221 201.994792 446.40849032 Metazoa 33208 Mollusca Mollusca 51.2 1.57e-5   NR OWF40427.1 6573 g5676 i0 72.7 58.5475113122172 44 12 59.7 0 198 67 153 196 OWF40427.1 40S ribosomal protein S23 [Mizuhopecten yessoensis] diamond 12939 51.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
31829221 31829221 PRJNA1123686_S_NODE_257_length_437_cov_37.762255_g228_i0 PRJNA1123686 257 437 37.762255 165.02105435000001 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 86.3 5.97e-19   NR XP_055890193.1 6526 g228 i0 74.1 17.1693363844394 54 14 37.1 0 49 210 13 66 XP_055890193.1 small nuclear ribonucleoprotein E [Biomphalaria glabrata] diamond 7503 86.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata

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