RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA699078" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA699078 · 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
27335714 27335714 PRJNA699078_S_NODE_55303_length_229_cov_1.466667_g54354_i0 PRJNA699078 55303 229 1.466667 3.35866743 Rhodopirellula sallentina 1263869 Bacteria Bacteria 93.2 2.88e-20   NR WP_085979993.1 1263869 g54354 i0 69.5 1.54585152838428 59 18 77.3 0 1 177 308 366 WP_085979993.1 cis-3-hydroxy-L-proline dehydratase [Rhodopirellula sallentina] diamond 354 93.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rhodopirellula Rhodopirellula sallentina
27556437 27556437 PRJNA699078_S_NODE_11084_length_462_cov_6.135593_g10169_i0 PRJNA699078 11084 462 6.135593 28.34643966 Planctomycetota bacterium 2026780 Bacteria Bacteria 147 3.31e-40   NR MEI8371948.1 2026780 g10169 i0 56.1 5.31168831168831 132 58 85.7 0 422 27 193 324 MEI8371948.1 hypothetical protein [Planctomycetota bacterium] diamond 2454 147 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31283326 31283326 PRJNA699078_S_NODE_65855_length_208_cov_1.503145_g64906_i0 PRJNA699078 65855 208 1.503145 3.1265416 Planctomycetes bacterium RIFCSPLOWO2_12_38_17 1801946 Bacteria Bacteria 42.7 0.0243   NR OHB98512.1 1801946 g64906 i0 29.6 0.778846153846154 54 38 77.9 0 47 208 84 137 OHB98512.1 MAG: hypothetical protein A2W74_07070 [Planctomycetes bacterium RIFCSPLOWO2_12_38_17] diamond 162 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium RIFCSPLOWO2_12_38_17
31346795 31346795 PRJNA699078_S_NODE_34456_length_295_cov_1.268293_g33507_i0 PRJNA699078 34456 295 1.268293 3.74146435 Pirellulaceae bacterium 2699754 Bacteria Bacteria 68.2 6.35e-11   NR MDA7951408.1 2699754 g33507 i0 47.9 0.722033898305085 71 37 72.2 0 294 82 269 339 MDA7951408.1 asparaginase [Pirellulaceae bacterium] diamond 213 68.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae 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);;