RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA930380", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 3 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJNA930380 · 3 ✖

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
28098754 28098754 PRJNA930380_P_NODE_6345_length_290_cov_1.096774_g6292_i0 PRJNA930380 6345 290 1.096774 3.1806446 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.1 0.0467   NR MCH8219576.1 2026780 g6292 i0 42.9 0.506896551724138 49 24 50.7 1 55 201 476 520 MCH8219576.1 peptide chain release factor 3 [Planctomycetota bacterium] diamond 147 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28509340 28509340 PRJNA930380_P_NODE_8867_length_278_cov_1.434146_g8814_i0 PRJNA930380 8867 278 1.434146 3.98692588 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 44.7 0.0119   NR HWE04171.1 2876886 g8814 i0 39.7 0.679856115107914 63 38 68 0 271 83 376 438 HWE04171.1 peptidylprolyl isomerase [Tepidisphaeraceae bacterium] diamond 189 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
31542016 31542016 PRJNA930380_P_NODE_14296_length_241_cov_0.916667_g14243_i0 PRJNA930380 14296 241 0.916667 2.20916747 Phycisphaerales bacterium 2052180 Bacteria Bacteria 43.9 0.00486   NR MFO0894886.1 2052180 g14243 i0 47.4 0.473029045643154 38 20 47.3 0 126 13 14 51 MFO0894886.1 PQQ-binding-like beta-propeller repeat protein [Phycisphaerales bacterium] diamond 114 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales 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);;