RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA889065", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 4 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA889065 · 4 ✖

analysis 1

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
27094938 27094938 PRJNA889065_S_NODE_21902_length_208_cov_1.345455_g21664_i0 PRJNA889065 21902 208 1.345455 2.7985464 Pseudomonadati 3379134 Bacteria Bacteria 62.8 1.86e-9   NR MDQ6655875.1 2026799 g21664 i0 53.6 4.42788461538461 56 26 80.8 0 32 199 285 340 MDQ6655875.1 NADH:flavin oxidoreductase/NADH oxidase [Verrucomicrobiota bacterium] diamond 921 63.2 0.993670886075949 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28168805 28168805 PRJNA889065_S_NODE_14945_length_251_cov_1.634615_g14707_i0 PRJNA889065 14945 251 1.634615 4.10288365 Bacteria 2 Bacteria Bacteria 48.9 2.38e-4   NR PYJ64909.1 2026799 g14707 i0 30.1 6.34661354581673 83 56 99.2 2 250 2 177 257 PYJ64909.1 MAG: class I SAM-dependent methyltransferase [Verrucomicrobiota bacterium] diamond 1593 48.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31066762 31066762 PRJNA889065_S_NODE_12735_length_270_cov_1.823789_g12497_i0 PRJNA889065 12735 270 1.823789 4.9242303 Spartobacteria bacterium 2052183 Bacteria Bacteria 60.1 3.93e-8   NR NCC52901.1 2052183 g12497 i0 45.6 0.755555555555556 68 37 75.6 0 65 268 57 124 NCC52901.1 hypothetical protein [Spartobacteria bacterium] diamond 204 60.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria       Spartobacteria bacterium
31168983 31168983 PRJNA889065_S_NODE_35135_length_161_cov_1.559322_g34897_i0 PRJNA889065 35135 161 1.559322 2.51050842 Bacteria 2 Bacteria Bacteria 58.2 9.67e-9   NR MCZ7638296.1 2026799 g34897 i0 56.8 1.63975155279503 44 18 82 1 1 132 108 150 MCZ7638296.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 264 58.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;