RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA881257" 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 · 8 ✖

bioproject 1

  • PRJNA881257 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
22535305 22535305 PRJNA881257_P_NODE_17718_length_163_cov_0.912281_g17473_i0 PRJNA881257 17718 163 0.912281 1.48701803 Phycisphaerae 666505 Bacteria Bacteria 107 2.81e-25   NR MDB5323872.1 2052180 g17473 i0 98.1 1.98773006134969 54 1 99.4 0 1 162 512 565 MDB5323872.1 pilB [Phycisphaerales bacterium] diamond 324 107 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27719168 27719168 PRJNA881257_P_NODE_6804_length_277_cov_2.267544_g6559_i0 PRJNA881257 6804 277 2.267544 6.28109688 Lentisphaeria bacterium 2053569 Bacteria Bacteria 43.9 0.0214   NR MBR4666996.1 2053569 g6559 i0 36 0.541516245487365 50 32 54.2 0 150 1 301 350 MBR4666996.1 hypothetical protein [Lentisphaeria bacterium] diamond 150 43.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
27907876 27907876 PRJNA881257_P_NODE_16085_length_166_cov_0.888889_g15840_i0 PRJNA881257 16085 166 0.888889 1.47555574 Pirellula sp. 117 Bacteria Bacteria 61.6 2.75e-9   NR MBA4017182.1 117 g15840 i0 51.9 1.95180722891566 54 26 97.6 0 3 164 48 101 MBA4017182.1 hypothetical protein [Pirellula sp.] diamond 324 61.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
28168758 28168758 PRJNA881257_P_NODE_17385_length_163_cov_0.912281_g17140_i0 PRJNA881257 17385 163 0.912281 1.48701803 Humisphaera 2807511 Bacteria Bacteria 89 6.4e-19   NR HEX8911235.1 2807514 g17140 i0 77.8 2.98159509202454 54 12 99.4 0 162 1 468 521 HEX8911235.1 hypothetical protein [Humisphaera sp.] diamond 486 89 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera sp.
28729141 28729141 PRJNA881257_P_NODE_15987_length_166_cov_0.888889_g15742_i0 PRJNA881257 15987 166 0.888889 1.47555574 Planctomyces sp. SH-PL14 1632864 Bacteria Bacteria 112 5.3200000000000006e-27   NR WP_075092220.1 1632864 g15742 i0 89.1 0.993975903614458 55 6 99.4 0 1 165 606 660 WP_075092220.1 zinc-dependent metalloprotease [Planctomyces sp. SH-PL14] diamond 165 112 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
30718752 30718752 PRJNA881257_P_NODE_15814_length_166_cov_0.888889_g15569_i0 PRJNA881257 15814 166 0.888889 1.47555574 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 59.3 1.87e-8   NR HET6249302.1 2876886 g15569 i0 64.9 0.668674698795181 37 13 66.9 0 1 111 405 441 HET6249302.1 glycosyltransferase [Tepidisphaeraceae bacterium] diamond 111 59.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
31224198 31224198 PRJNA881257_P_NODE_15595_length_167_cov_0.881356_g15350_i0 PRJNA881257 15595 167 0.881356 1.47186452 Planctomycetota bacterium 2026780 Bacteria Bacteria 63.2 6.65e-10   NR MEL7089934.1 2026780 g15350 i0 68.2 2.49700598802395 44 14 79 0 32 163 90 133 MEL7089934.1 anthranilate synthase component I family protein [Planctomycetota bacterium] diamond 417 63.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31382634 31382634 PRJNA881257_P_NODE_16596_length_165_cov_0.896552_g16351_i0 PRJNA881257 16596 165 0.896552 1.4793108 Planctomycetia bacterium 2052181 Bacteria Bacteria 103 4.78e-24   NR GDY07179.1 2052181 g16351 i0 92.6 0.981818181818182 54 4 98.2 0 163 2 127 180 GDY07179.1 DNA topoisomerase [Planctomycetia bacterium] diamond 162 103 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia 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);;