RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA408129" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 16 ✖

bioproject 1

  • PRJNA408129 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
11897366 11897366 PRJNA408129_S_NODE_4130_length_281_cov_4.659836_g4112_i0 PRJNA408129 4130 281 4.659836 13.09413916 Pseudomonadati 3379134 Bacteria Bacteria 100 2.15e-22   NR MFP4070214.1 2026772 g4112 i0 83.9 2.41281138790036 56 9 59.8 0 280 113 692 747 MFP4070214.1 catalase/peroxidase HPI [Opitutales bacterium] diamond 678 100 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales bacterium
19544292 19544292 PRJNA408129_S_NODE_31276_length_156_cov_2.655462_g31258_i0 PRJNA408129 31276 156 2.655462 4.14252072 Lacipirellula parvula 2650471 Bacteria Bacteria 105 3.63e-25   NR WP_152100837.1 2650471 g31258 i0 98 0.980769230769231 51 1 98.1 0 155 3 98 148 WP_152100837.1 hypothetical protein [Lacipirellula parvula] diamond 153 105 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula parvula
26648842 26648842 PRJNA408129_S_NODE_7581_length_239_cov_6.257426_g7563_i0 PRJNA408129 7581 239 6.257426 14.95524814 Paludisphaera 1763521 Bacteria Bacteria 51.6 2.62e-5   NR WP_277862173.1 3030827 g7563 i0 48.9 1.09205020920502 45 23 56.5 0 187 53 515 559 WP_277862173.1 Ig-like domain repeat protein [Paludisphaera mucosa] diamond 261 52 0.992307692307692 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Paludisphaera Paludisphaera mucosa
27360155 27360155 PRJNA408129_S_NODE_23643_length_170_cov_1.571429_g23625_i0 PRJNA408129 23643 170 1.571429 2.6714293 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 91.3 1.11e-19   NR MES2920926.1 2026799 g23625 i0 83.6 0.970588235294118 55 9 97.1 0 170 6 170 224 MES2920926.1 carboxy terminal-processing peptidase [Verrucomicrobiota bacterium] diamond 165 91.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28149497 28149497 PRJNA408129_S_NODE_28085_length_161_cov_3.524194_g28067_i0 PRJNA408129 28085 161 3.524194 5.67395234 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.6 0.0147   NR MEQ8765592.1 2026780 g28067 i0 40 0.838509316770186 45 27 83.9 0 9 143 35 79 MEQ8765592.1 DUF4405 domain-containing protein [Planctomycetota bacterium] diamond 135 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28623143 28623143 PRJNA408129_S_NODE_27047_length_163_cov_2.388889_g27029_i0 PRJNA408129 27047 163 2.388889 3.89388907 Paludisphaera borealis 1387353 Bacteria Bacteria 66.6 4.54e-11   NR WP_083713394.1 1387353 g27029 i0 82.5 2.5398773006135 40 7 73.6 0 39 158 23 62 WP_083713394.1 amidohydrolase [Paludisphaera borealis] diamond 414 66.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Paludisphaera Paludisphaera borealis
28970364 28970364 PRJNA408129_S_NODE_33508_length_153_cov_2.517241_g33490_i0 PRJNA408129 33508 153 2.517241 3.85137873 Neochlamydia sp. S13 1353976 Bacteria Bacteria 75.1 2.25e-14   NR WP_042241681.1 1353976 g33490 i0 66 0.980392156862745 50 17 98 0 153 4 110 159 WP_042241681.1 archaetidylserine decarboxylase [Neochlamydia sp. S13] diamond 150 75.1 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Neochlamydia Neochlamydia sp. S13
29727807 29727807 PRJNA408129_S_NODE_33970_length_152_cov_5.626087_g33952_i0 PRJNA408129 33970 152 5.626087 8.55165224 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 74.7 5.64e-14   NR MFP6764688.1 2026779 g33952 i0 73.3 6.21710526315789 45 12 88.8 0 2 136 271 315 MFP6764688.1 AAA family ATPase [Planctomycetaceae bacterium] diamond 945 74.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30517871 30517871 PRJNA408129_S_NODE_11013_length_215_cov_6.825843_g10995_i0 PRJNA408129 11013 215 6.825843 14.67556245 Chlamydia ibidis 1405396 Bacteria Bacteria 50.4 3.76e-6   NR EPP34943.1 1405396 g10995 i0 88.5 0.362790697674419 26 3 36.3 0 209 132 40 65 EPP34943.1 hypothetical protein CP10139811_1560, partial [Chlamydia ibidis] diamond 78 50.4 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia ibidis
30770801 30770801 PRJNA408129_S_NODE_20314_length_178_cov_2.226950_g20296_i0 PRJNA408129 20314 178 2.22695 3.963971 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0084   NR MEC8651550.1 2026780 g20296 i0 38 0.842696629213483 50 31 84.3 0 7 156 182 231 MEC8651550.1 hypothetical protein [Planctomycetota bacterium] diamond 150 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31845449 31845449 PRJNA408129_S_NODE_31637_length_155_cov_10.423729_g31619_i0 PRJNA408129 31637 155 10.423729 16.15677995 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.8 7.27e-4   NR HZV01369.1 2026780 g31619 i0 53.8 0.754838709677419 39 18 75.5 0 149 33 170 208 HZV01369.1 hypothetical protein [Planctomycetota bacterium] diamond 117 45.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31893841 31893841 PRJNA408129_S_NODE_14197_length_199_cov_2.549383_g14179_i0 PRJNA408129 14197 199 2.549383 5.07327217 Planctomycetia 203683 Bacteria Bacteria 102 1.1199999999999999e-23   NR WP_148074061.1 1400387 g14179 i0 74.2 9.30150753768844 62 16 93.5 0 6 191 376 437 WP_148074061.1 sodium-dependent transporter [Bythopirellula goksoeyrii] diamond 1851 102 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Bythopirellula Bythopirellula goksoeyrii
32003836 32003836 PRJNA408129_S_NODE_14318_length_198_cov_5.062112_g14300_i0 PRJNA408129 14318 198 5.062112 10.02298176 Pirellulales bacterium 2715253 Bacteria Bacteria 63.9 6.88e-10   NR HZZ28781.1 2715253 g14300 i0 60 0.909090909090909 60 24 90.9 0 197 18 269 328 HZZ28781.1 autotransporter-associated beta strand repeat-containing protein [Pirellulales bacterium] diamond 180 63.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
32415233 32415233 PRJNA408129_S_NODE_26559_length_164_cov_2.094488_g26541_i0 PRJNA408129 26559 164 2.094488 3.43496032 Planctomycetia bacterium 2052181 Bacteria Bacteria 42.7 0.00378   NR MBI2481475.1 2052181 g26541 i0 50 0.658536585365854 36 18 65.9 0 116 9 7 42 MBI2481475.1 hypothetical protein [Planctomycetia bacterium] diamond 108 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
32431867 32431867 PRJNA408129_S_NODE_18459_length_183_cov_3.143836_g18441_i0 PRJNA408129 18459 183 3.143836 5.75321988 PVC group 1783257 Bacteria Bacteria 51.6 1.29e-5   NR HMC66185.1 2052164 g18441 i0 100 6.95081967213115 25 0 41 0 174 100 457 481 HMC66185.1 DNA-directed RNA polymerase subunit beta' [Gemmataceae bacterium] diamond 1272 51.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32715810 32715810 PRJNA408129_S_NODE_29160_length_159_cov_5.122951_g29142_i0 PRJNA408129 29160 159 5.122951 8.14549209 Pseudomonadati 3379134 Bacteria Bacteria 90.9 1.83e-20   NR MBV8226507.1 2026799 g29142 i0 78.8 3.84905660377358 52 11 98.1 0 157 2 91 142 MBV8226507.1 cysteine hydrolase [Verrucomicrobiota bacterium] diamond 612 90.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;