RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA797655 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
2063451 2063451 PRJNA797655_S_NODE_43402_length_329_cov_2.181818_g42797_i0 PRJNA797655 43402 329 2.181818 7.17818122 Roseimaritima 1579506 Bacteria Bacteria 137 1.28e-36   NR MBU6172826.1 2026780 g42797 i0 63.2 2.01519756838906 114 35 97.6 1 324 4 7 120 MBU6172826.1 DUF1559 domain-containing protein [Planctomycetota bacterium] diamond 663 138 0.992753623188406 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27211753 27211753 PRJNA797655_S_NODE_107962_length_238_cov_3.061538_g107357_i0 PRJNA797655 107962 238 3.061538 7.28646044 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 43.1 0.0262   NR RYD65353.1 2026800 g107357 i0 30 0.882352941176471 70 40 76.9 1 41 223 101 170 RYD65353.1 MAG: cobaltochelatase subunit CobN, partial [Verrucomicrobiaceae bacterium] diamond 210 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
27275214 27275214 PRJNA797655_S_NODE_151803_length_205_cov_1.481481_g151198_i0 PRJNA797655 151803 205 1.481481 3.03703605 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 42 0.0371   NR MDX1681814.1 2026777 g151198 i0 36.4 0.64390243902439 44 28 64.4 0 58 189 106 149 MDX1681814.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 132 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
27464854 27464854 PRJNA797655_S_NODE_118903_length_229_cov_1.629032_g118298_i0 PRJNA797655 118903 229 1.629032 3.73048328 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.00469   NR MFM1871646.1 2026780 g118298 i0 34.7 0.943231441048035 72 40 94.3 1 11 226 15 79 MFM1871646.1 hypothetical protein [Planctomycetota bacterium] diamond 216 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27496369 27496369 PRJNA797655_S_NODE_249923_length_158_cov_1.669565_g249318_i0 PRJNA797655 249923 158 1.669565 2.6379127000000002 Phycisphaerae bacterium 2026778 Bacteria Bacteria 41.2 0.0412   NR MFO0837951.1 2026778 g249318 i0 42.5 0.759493670886076 40 21 75.9 1 145 26 311 348 MFO0837951.1 ferric reductase-like transmembrane domain-containing protein [Phycisphaerae bacterium] diamond 120 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27654352 27654352 PRJNA797655_S_NODE_87444_length_259_cov_2.222222_g86839_i0 PRJNA797655 87444 259 2.222222 5.75555498 Gemmataceae bacterium 2052164 Bacteria Bacteria 42.7 0.0441   NR HKA06075.1 2052164 g86839 i0 50 0.486486486486487 42 18 45.2 1 88 204 214 255 HKA06075.1 aspartate aminotransferase family protein [Gemmataceae bacterium] diamond 126 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27843464 27843464 PRJNA797655_S_NODE_79084_length_269_cov_1.699115_g78479_i0 PRJNA797655 79084 269 1.699115 4.57061935 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.7 0.0478   NR MBN8249179.1 2026799 g78479 i0 54.3 0.390334572490706 35 16 39 0 147 251 73 107 MBN8249179.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 105 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28317260 28317260 PRJNA797655_S_NODE_39146_length_339_cov_3.395270_g38541_i0 PRJNA797655 39146 339 3.39527 11.5099653 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 92 4.85e-19   NR MBK7497391.1 2035772 g38541 i0 48.2 0.991150442477876 112 57 98.2 1 1 333 40 151 MBK7497391.1 DEAD/DEAH box helicase [Candidatus Omnitrophota bacterium] diamond 336 92 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
28475145 28475145 PRJNA797655_S_NODE_50126_length_314_cov_3.583026_g49521_i0 PRJNA797655 50126 314 3.583026 11.25070164 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0451   NR MEW6197564.1 2026780 g49521 i0 41.7 0.936305732484076 60 25 47.8 1 223 74 280 339 MEW6197564.1 hypothetical protein [Planctomycetota bacterium] diamond 294 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28696282 28696282 PRJNA797655_S_NODE_174427_length_191_cov_3.445946_g173822_i0 PRJNA797655 174427 191 3.445946 6.58175686 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 40.4 0.0479   NR MBS0661764.1 2026799 g173822 i0 43.5 0.722513089005236 46 26 72.3 0 182 45 35 80 MBS0661764.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 138 40.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29012165 29012165 PRJNA797655_S_NODE_117088_length_230_cov_3.475936_g116483_i0 PRJNA797655 117088 230 3.475936 7.9946528 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0422   NR MBS0208492.1 2026780 g116483 i0 41.5 0.691304347826087 53 31 69.1 0 206 48 131 183 MBS0208492.1 tryptophan synthase subunit beta [Planctomycetota bacterium] diamond 159 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29138390 29138390 PRJNA797655_S_NODE_156049_length_202_cov_1.968553_g155444_i0 PRJNA797655 156049 202 1.968553 3.97647706 Gemmataceae bacterium 2052164 Bacteria Bacteria 42.7 0.00901   NR MFO0841988.1 2052164 g155444 i0 53.8 0.386138613861386 26 12 38.6 0 120 43 81 106 MFO0841988.1 hypothetical protein [Gemmataceae bacterium] diamond 78 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29264241 29264241 PRJNA797655_S_NODE_280389_length_150_cov_1.065421_g279784_i0 PRJNA797655 280389 150 1.065421 1.5981315 Pirellulaceae bacterium 2699754 Bacteria Bacteria 41.2 0.0382   NR MBC7857034.1 2699754 g279784 i0 37.5 0.8 40 25 80 0 1 120 600 639 MBC7857034.1 squalene/phytoene synthase family protein [Pirellulaceae bacterium] diamond 120 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
29327495 29327495 PRJNA797655_S_NODE_76449_length_272_cov_2.851528_g75844_i0 PRJNA797655 76449 272 2.851528 7.75615616 Lentisphaeria bacterium 2053569 Bacteria Bacteria 43.9 0.0204   NR MBO5990022.1 2053569 g75844 i0 43.2 0.485294117647059 44 25 48.5 0 268 137 18 61 MBO5990022.1 TolC family protein [Lentisphaeria bacterium] diamond 132 43.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
29548401 29548401 PRJNA797655_S_NODE_104730_length_241_cov_3.040404_g104125_i0 PRJNA797655 104730 241 3.040404 7.32737364 Lentisphaerota bacterium 1932692 Bacteria Bacteria 43.1 0.0257   NR NLX25613.1 1932692 g104125 i0 32.7 0.609958506224066 49 31 61 1 84 230 118 164 NLX25613.1 hypothetical protein [Lentisphaerota bacterium] diamond 147 43.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
29905198 29905198 PRJNA797655_S_NODE_209231_length_174_cov_3.297710_g208626_i0 PRJNA797655 209231 174 3.29771 5.7380154 Planctomycetia 203683 Bacteria Bacteria 43.1 0.0045   NR MCE9529368.1 2053591 g208626 i0 50 1.31034482758621 38 17 65.5 1 9 122 56 91 MCE9529368.1 hypothetical protein [Planctomycetales bacterium] diamond 228 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
30053756 30053756 PRJNA797655_S_NODE_88611_length_258_cov_1.562791_g88006_i0 PRJNA797655 88611 258 1.562791 4.03200078 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0225   NR MDA0836984.1 2026780 g88006 i0 35.4 0.755813953488372 65 42 75.6 0 232 38 10 74 MDA0836984.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium] diamond 195 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30527787 30527787 PRJNA797655_S_NODE_202073_length_178_cov_1.066667_g201468_i0 PRJNA797655 202073 178 1.066667 1.89866726 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 42.4 0.0217   NR MBL9176073.1 2026801 g201468 i0 48.8 0.691011235955056 41 19 69.1 1 159 37 217 255 MBL9176073.1 acyltransferase family protein [Verrucomicrobiales bacterium] diamond 123 42.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
30907204 30907204 PRJNA797655_S_NODE_210634_length_174_cov_1.465649_g210029_i0 PRJNA797655 210634 174 1.465649 2.55022926 Gemmataceae bacterium 2052164 Bacteria Bacteria 42.4 0.0201   NR HLN27799.1 2052164 g210029 i0 44.7 0.655172413793103 38 20 63.8 1 173 63 206 243 HLN27799.1 sodium:solute symporter family protein [Gemmataceae bacterium] diamond 114 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31571064 31571064 PRJNA797655_S_NODE_107076_length_239_cov_2.316327_g106471_i0 PRJNA797655 107076 239 2.316327 5.53602153 Pirellulaceae 2691357 Bacteria Bacteria 42 0.0263   NR WP_230262523.1 2691357 g106471 i0 36.4 0.690376569037657 55 30 69 1 199 35 3 52 WP_230262523.1 MULTISPECIES: hypothetical protein [Pirellulaceae] diamond 165 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae    
31823774 31823774 PRJNA797655_S_NODE_178557_length_189_cov_2.301370_g177952_i0 PRJNA797655 178557 189 2.30137 4.3495893 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 43.1 0.014   NR MBA3963233.1 2201154 g177952 i0 35.6 0.936507936507937 59 38 93.7 0 10 186 217 275 MBA3963233.1 hypothetical protein [Chthoniobacterales bacterium] diamond 177 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
31823784 31823784 PRJNA797655_S_NODE_273297_length_151_cov_2.222222_g272692_i0 PRJNA797655 273297 151 2.222222 3.35555522 Planctomycetia bacterium 2052181 Bacteria Bacteria 41.2 0.038   NR MFM8979317.1 2052181 g272692 i0 56.3 0.635761589403974 32 12 59.6 1 61 150 62 93 MFM8979317.1 DUF1800 family protein [Planctomycetia bacterium] diamond 96 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
31832825 31832825 PRJNA797655_S_NODE_137677_length_214_cov_2.526316_g137072_i0 PRJNA797655 137677 214 2.526316 5.40631624 Planctomycetia 203683 Bacteria Bacteria 55.8 4.75e-7   NR MSU78880.1 2052164 g137072 i0 75.8 6.14018691588785 33 8 46.3 0 1 99 234 266 MSU78880.1 FAA hydrolase family protein [Gemmataceae bacterium] diamond 1314 56.2 0.99288256227758 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31950390 31950390 PRJNA797655_S_NODE_68277_length_283_cov_4.108333_g67672_i0 PRJNA797655 68277 283 4.108333 11.62658239 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 44.3 0.0178   NR MBO7299483.1 2212473 g67672 i0 37 0.57243816254417 54 34 57.2 0 178 17 429 482 MBO7299483.1 hypothetical protein [Kiritimatiellia bacterium] diamond 162 44.3 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32583414 32583414 PRJNA797655_S_NODE_204999_length_176_cov_2.526316_g204394_i0 PRJNA797655 204999 176 2.526316 4.44631616 Lentisphaerota bacterium 1932692 Bacteria Bacteria 85.9 6.8e-20   NR MBE6365228.1 1932692 g204394 i0 97.9 0.801136363636364 47 1 80.1 0 176 36 30 76 MBE6365228.1 hypothetical protein [Lentisphaerota bacterium] diamond 141 85.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
32583418 32583418 PRJNA797655_S_NODE_260659_length_154_cov_2.162162_g260054_i0 PRJNA797655 260659 154 2.162162 3.32972948 Planctomycetota bacterium 2026780 Bacteria Bacteria 40.8 0.0404   NR MCP4712170.1 2026780 g260054 i0 43.2 0.720779220779221 37 21 72.1 0 9 119 89 125 MCP4712170.1 DUF1080 domain-containing protein [Planctomycetota bacterium] diamond 111 40.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32645853 32645853 PRJNA797655_S_NODE_111360_length_235_cov_2.750000_g110755_i0 PRJNA797655 111360 235 2.75 6.4625 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 43.5 0.0174   NR RKY37208.1 2035772 g110755 i0 34.3 0.893617021276596 70 44 86.8 1 224 21 226 295 RKY37208.1 MAG: hypothetical protein DRP78_01670 [Candidatus Omnitrophota bacterium] diamond 210 43.5 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
32645859 32645859 PRJNA797655_S_NODE_199300_length_179_cov_1.735294_g198695_i0 PRJNA797655 199300 179 1.735294 3.10617626 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 44.3 0.00452   NR MEN6452554.1 2691551 g198695 i0 50 0.569832402234637 34 16 57 1 9 110 250 282 MEN6452554.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Thermoguttaceae bacterium] diamond 102 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae 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);;