RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "candidate division CSSED10-310"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • candidate division CSSED10-310 · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1148190 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_kingdom 0

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
292213 292213 PRJNA1148190_P_NODE_205001_length_372_cov_2.899666_g193831_i0 PRJNA1148190 205001 372 2.899666 10.78675752 candidate division CSSED10-310 bacterium 2855610 Bacteria Bacteria 90.5 2.96e-18   NR MBN1355278.1 2855610 g193831 i0 54.8 0.588709677419355 73 32 58.9 1 152 370 69 140 MBN1355278.1 hypothetical protein [candidate division CSSED10-310 bacterium] diamond 219 90.5 1 Bacteria Bacteria candidate phyla   candidate division CSSED10-310         candidate division CSSED10-310 bacterium
29092329 29092329 PRJNA1148190_P_NODE_376608_length_291_cov_1.417431_g365435_i0 PRJNA1148190 376608 291 1.417431 4.12472421 candidate division CSSED10-310 bacterium 2855610 Bacteria Bacteria 60.1 2.85e-9   NR MBN2056925.1 2855610 g365435 i0 36.4 1.65979381443299 77 49 79.4 0 55 285 4 80 MBN2056925.1 tetratricopeptide repeat protein [candidate division CSSED10-310 bacterium] diamond 483 60.1 1 Bacteria Bacteria candidate phyla   candidate division CSSED10-310         candidate division CSSED10-310 bacterium
32474763 32474763 PRJNA1148190_P_NODE_751379_length_243_cov_0.870588_g740206_i0 PRJNA1148190 751379 243 0.870588 2.11552884 candidate division CSSED10-310 bacterium 2855610 Bacteria Bacteria 47 0.0012   NR MFC1848621.1 2855610 g740206 i0 27.8 0.888888888888889 72 51 87.7 1 213 1 236 307 MFC1848621.1 hypothetical protein [candidate division CSSED10-310 bacterium] diamond 216 47 1 Bacteria Bacteria candidate phyla   candidate division CSSED10-310         candidate division CSSED10-310 bacterium
32569484 32569484 PRJNA1148190_P_NODE_580999_length_251_cov_1.488764_g569826_i0 PRJNA1148190 580999 251 1.488764 3.73679764 candidate division CSSED10-310 bacterium 2855610 Bacteria Bacteria 73.9 4.21e-13   NR MBN1355278.1 2855610 g569826 i0 55.4 0.669322709163347 56 24 66.9 1 195 28 86 140 MBN1355278.1 hypothetical protein [candidate division CSSED10-310 bacterium] diamond 168 73.9 1 Bacteria Bacteria candidate phyla   candidate division CSSED10-310         candidate division CSSED10-310 bacterium

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