RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA1151638 · 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
16879088 16879088 PRJNA1151638_P_NODE_6334_length_244_cov_0.912281_g6267_i0 PRJNA1151638 6334 244 0.912281 2.22596564 Planctomycetota bacterium 2026780 Bacteria Bacteria 131 7.019999999999998e-35   NR REK09410.1 2026780 g6267 i0 88.9 1.77049180327869 72 8 88.5 0 27 242 1 72 REK09410.1 MAG: gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium] diamond 432 131 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
22713899 22713899 PRJNA1151638_P_NODE_3618_length_276_cov_1.600985_g3551_i0 PRJNA1151638 3618 276 1.600985 4.4187186 Bacteria 2 Bacteria Bacteria 57 5.07e-7   NR MEY4395675.1 2026780 g3551 i0 45.5 5.59782608695652 77 38 79.3 1 3 221 355 431 MEY4395675.1 hypothetical protein [Planctomycetota bacterium] diamond 1545 57 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30577172 30577172 PRJNA1151638_P_NODE_6773_length_242_cov_0.923077_g6706_i0 PRJNA1151638 6773 242 0.923077 2.23384634 Planctomycetota bacterium 2026780 Bacteria Bacteria 98.6 1.7099999999999998e-23   NR MCE9565124.1 2026780 g6706 i0 74.1 1.58677685950413 58 15 71.9 0 177 4 1 58 MCE9565124.1 oxidoreductase [Planctomycetota bacterium] diamond 384 98.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31399271 31399271 PRJNA1151638_P_NODE_2456_length_315_cov_2.334711_g2389_i0 PRJNA1151638 2456 315 2.334711 7.35433965 Planctomycetota bacterium 2026780 Bacteria Bacteria 102 1.0300000000000001e-22   NR MCC7510596.1 2026780 g2389 i0 49.5 1.96190476190476 103 51 97.1 1 309 4 747 849 MCC7510596.1 DNA polymerase III subunit alpha [Planctomycetota bacterium] diamond 618 102 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);;