RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA1001940" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 2 ✖

bioproject 1

  • PRJNA1001940 · 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
27413905 27413905 PRJNA1001940_S_NODE_203623_length_152_cov_3.082569_g202569_i0 PRJNA1001940 203623 152 3.082569 4.68550488 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.7 0.0108   NR MCX5660276.1 2026780 g202569 i0 53.1 0.631578947368421 32 15 63.2 0 137 42 526 557 MCX5660276.1 hypothetical protein [Planctomycetota bacterium] diamond 96 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32532316 32532316 PRJNA1001940_S_NODE_43159_length_326_cov_1.120141_g42105_i0 PRJNA1001940 43159 326 1.120141 3.65165966 Estrella lausannensis 483423 Bacteria Bacteria 43.5 0.0423   NR WP_098038767.1 483423 g42105 i0 30.4 0.846625766871166 92 56 84.7 2 299 24 90 173 WP_098038767.1 MotA/TolQ/ExbB proton channel family protein [Estrella lausannensis] diamond 276 43.5 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Criblamydiaceae Estrella Estrella lausannensis

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