RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA591127" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA591127 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
26636458 26636458 PRJNA591127_P_NODE_27481_length_156_cov_2.109244_g27312_i0 PRJNA591127 27481 156 2.109244 3.29042064 Pomacea canaliculata 400727 Mollusca Mollusca 67.4 2.24e-12   NR XP_025086345.1 400727 g27312 i0 67.4 1.76923076923077 46 15 88.5 0 143 6 1 46 XP_025086345.1 LOW QUALITY PROTEIN: 40S ribosomal protein S11-like [Pomacea canaliculata] diamond 276 67.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
29132492 29132492 PRJNA591127_P_NODE_19229_length_197_cov_2.043750_g19060_i0 PRJNA591127 19229 197 2.04375 4.0261875 Elysia marginata 1093978 Mollusca Mollusca 43.1 0.0044   NR GFS14131.1 1093978 g19060 i0 80 0.380710659898477 25 5 38.1 0 122 196 40 64 GFS14131.1 60S acidic ribosomal protein P2 [Elysia marginata] diamond 75 43.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia marginata
31989668 31989668 PRJNA591127_P_NODE_18278_length_197_cov_2.250000_g18109_i0 PRJNA591127 18278 197 2.25 4.4325 Opisthokonta 33154 Mollusca Mollusca 41.6 0.0456   NR XP_021379854.1 6573 g18109 i0 76 1.90355329949239 25 6 38.1 0 75 1 182 206 XP_021379854.1 60S ribosomal protein L10a-2-like [Mizuhopecten yessoensis] diamond 375 42 0.990476190476191 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis

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