RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA290839", 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 · 4 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA290839 · 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
31496498 31496498 PRJNA290839_P_NODE_576_length_338_cov_1.166038_g555_i0 PRJNA290839 576 338 1.166038 3.94120844 Planctomycetota bacterium 2026780 Bacteria Bacteria 59.7 1.23e-7   NR HLX60008.1 2026780 g555 i0 35.8 1.88165680473373 106 55 94.1 3 19 336 200 292 HLX60008.1 phosphoesterase [Planctomycetota bacterium] diamond 636 59.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31685937 31685937 PRJNA290839_P_NODE_897_length_270_cov_1.421320_g876_i0 PRJNA290839 897 270 1.42132 3.837564 Phycisphaerae bacterium 2026778 Bacteria Bacteria 55.5 1.72e-6   NR MCK4659756.1 2026778 g876 i0 36.6 0.911111111111111 82 44 84.4 3 38 265 373 452 MCK4659756.1 thrombospondin type 3 repeat-containing protein [Phycisphaerae bacterium] diamond 246 55.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
31717697 31717697 PRJNA290839_P_NODE_917_length_266_cov_1.606218_g896_i0 PRJNA290839 917 266 1.606218 4.27253988 Pirellulaceae bacterium 2699754 Bacteria Bacteria 46.2 0.00304   NR MEZ6091142.1 2699754 g896 i0 44.2 0.484962406015038 43 24 48.5 0 264 136 315 357 MEZ6091142.1 hypothetical protein [Pirellulaceae bacterium] diamond 129 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
32034099 32034099 PRJNA290839_P_NODE_1458_length_245_cov_0.906977_g1437_i0 PRJNA290839 1458 245 0.906977 2.22209365 Planctomycetota bacterium 2026780 Bacteria Bacteria 63.5 1.77e-9   NR MCY2924072.1 2026780 g1437 i0 55.2 0.710204081632653 58 26 71 0 65 238 565 622 MCY2924072.1 hypothetical protein [Planctomycetota bacterium] diamond 174 63.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;