RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB12366" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJEB12366 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
8638740 8638740 PRJEB12366_P_NODE_13747_length_194_cov_1.723270_g13557_i0 PRJEB12366 13747 194 1.72327 3.3431438 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 97.8 7.810000000000001e-22   NR MCK9614584.1 2035772 g13557 i0 75 22.639175257732 64 15 99 1 193 2 545 607 MCK9614584.1 pyruvate, phosphate dikinase [Candidatus Omnitrophota bacterium] diamond 4392 97.8 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
27507209 27507209 PRJEB12366_P_NODE_8283_length_271_cov_1.449153_g8093_i0 PRJEB12366 8283 271 1.449153 3.92720463 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 62 8.81e-9   NR MDD4872606.1 2212473 g8093 i0 43 6.74169741697417 86 46 95.2 2 11 268 60 142 MDD4872606.1 serine/threonine-protein kinase [Kiritimatiellia bacterium] diamond 1827 62 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28075249 28075249 PRJEB12366_P_NODE_8525_length_266_cov_1.606061_g8335_i0 PRJEB12366 8525 266 1.606061 4.27212226 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.1 0.0345   NR MEY4199220.1 2026799 g8335 i0 41.2 0.575187969924812 51 24 57.5 2 78 230 248 292 MEY4199220.1 nuclease superfamily [Verrucomicrobiota bacterium] diamond 153 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29212166 29212166 PRJEB12366_P_NODE_17949_length_163_cov_1.179688_g17759_i0 PRJEB12366 17949 163 1.179688 1.92289144 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 40.8 0.0383   NR HTL28666.1 2876886 g17759 i0 44.7 0.699386503067485 38 21 69.9 0 18 131 56 93 HTL28666.1 GNAT family N-acetyltransferase [Tepidisphaeraceae bacterium] diamond 114 40.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae 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);;