RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA358490" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA358490 · 2 ✖

analysis 1

  • diamond · 2 ✖
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
28022563 28022563 PRJNA358490_P_NODE_10945_length_289_cov_3.280000_g10603_i0 PRJNA358490 10945 289 3.28 9.4792 Mytilus coruscus 42192 Mollusca Mollusca 71.6 1.34e-12   NR CAC5378609.1 42192 g10603 i0 37.2 1.99307958477509 94 55 93.4 2 287 18 146 239 CAC5378609.1 Glycine receptor subunit beta,Glycine receptor subunit alpha-4,Glycine receptor subunit alpha-2,Glycine receptor subunit alpha-1 [Mytilus coruscus] diamond 576 71.6 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus coruscus
31054612 31054612 PRJNA358490_P_NODE_2915_length_839_cov_13.617500_g2715_i0 PRJNA358490 2915 839 13.6175 114.250825 Aplysia californica 6500 Mollusca Mollusca 72.8 2.53e-10   NR XP_005096259.1 6500 g2715 i0 35 0.643623361144219 180 101 59.4 4 818 321 576 753 XP_005096259.1 protein DD3-3 [Aplysia californica] diamond 540 72.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica

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