RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where bioproject = "PRJEB17675", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 30 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 30 ✖

bioproject 1

  • PRJEB17675 · 30 ✖
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
21654 21654 PRJEB17675_P_NODE_14121_length_219_cov_1.081522_g13817_i0 PRJEB17675 14121 219 1.081522 2.36853318 Calycomorphotria hydatis 2528027 Bacteria Bacteria 56.5 0.001   NTclustered gi|1712520392|gb|CP036316.1| 2528027 g13817 i0 96.97 0.150684931506849 33 1 15 0 35 67 4882516 4882548 Calycomorphotria hydatis strain V22 chromosome blastn 33 56.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Calycomorphotria Calycomorphotria hydatis
8948672 8948672 PRJEB17675_P_NODE_2008_length_695_cov_1.769697_g1775_i0 PRJEB17675 2008 695 1.769697 12.29939415 Singulisphaera acidiphila 466153 Bacteria Bacteria 69.4 6.89e-7   NTclustered gi|430012750|gb|CP003364.1| 886293 g1775 i0 83.333 0.112230215827338 78 10 11 1 8 85 2170727 2170801 Singulisphaera acidiphila DSM 18658, complete genome blastn 78 69.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera acidiphila
16598493 16598493 PRJEB17675_P_NODE_25074_length_151_cov_1.724138_g24770_i0 PRJEB17675 25074 151 1.724138 2.60344838 Frigoriglobus tundricola 2774151 Bacteria Bacteria 158 2.54e-34   NTclustered gi|1870286614|gb|CP053452.2| 2774151 g24770 i0 85.526 27.8476821192053 152 21 100 1 1 151 4960131 4959980 Frigoriglobus tundricola strain PL17 chromosome, complete genome blastn 4205 158 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Frigoriglobus Frigoriglobus tundricola
16598520 16598520 PRJEB17675_P_NODE_6774_length_359_cov_2.932099_g6471_i0 PRJEB17675 6774 359 2.932099 10.52623541 Bacteria 2 Bacteria Bacteria 212 2.2999999999999994e-67   NR MBX7104886.1 2052164 g6471 i0 83.9 5.91643454038997 118 19 98.6 0 1 354 82 199 MBX7104886.1 peptidylprolyl isomerase [Gemmataceae bacterium] diamond 2124 213 0.995305164319249 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
22973625 22973625 PRJEB17675_P_NODE_1759_length_737_cov_2.547009_g1544_i0 PRJEB17675 1759 737 2.547009 18.77145633 Gemmata obscuriglobus 114 Bacteria Bacteria 258 7.87e-80   NR WP_010034539.1 114 g1544 i0 66 5.34056987788331 188 64 76.5 0 736 173 307 494 WP_010034539.1 aldehyde dehydrogenase family protein [Gemmata obscuriglobus] diamond 3936 258 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
26653032 26653032 PRJEB17675_P_NODE_5001_length_433_cov_5.959799_g4703_i0 PRJEB17675 5001 433 5.959799 25.80592967 Candidatus Brocadiia bacterium 2517210 Bacteria Bacteria 99 5.28e-21   NR NUM34221.1 2517210 g4703 i0 46.4 0.775981524249423 112 55 74.1 2 385 65 392 503 NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium] diamond 336 99 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia       Candidatus Brocadiia bacterium
26780040 26780040 PRJEB17675_P_NODE_14961_length_210_cov_1.537143_g14657_i0 PRJEB17675 14961 210 1.537143 3.2280003 Phycisphaerales bacterium 2052180 Bacteria Bacteria 67.8 3.16e-11   NR MEN6424598.1 2052180 g14657 i0 73 3.68571428571429 37 10 52.9 0 99 209 3 39 MEN6424598.1 molecular chaperone DnaJ [Phycisphaerales bacterium] diamond 774 67.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27121224 27121224 PRJEB17675_P_NODE_11302_length_254_cov_1.319635_g10998_i0 PRJEB17675 11302 254 1.319635 3.3518729 Pseudomonadati 3379134 Bacteria Bacteria 46.6 0.00195   NR WP_146536169.1 2528013 g10998 i0 41 2.18503937007874 61 35 70.9 1 237 58 1126 1186 WP_146536169.1 SdrD B-like domain-containing protein [Rubripirellula reticaptiva] diamond 555 47 0.991489361702128 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula reticaptiva
27191082 27191082 PRJEB17675_P_NODE_9082_length_295_cov_1.834615_g8778_i0 PRJEB17675 9082 295 1.834615 5.41211425 Planctomycetes bacterium MalM25 2527998 Bacteria Bacteria 63.9 1.34e-9   NR QDT70210.1 2527998 g8778 i0 45.3 0.874576271186441 86 45 87.5 1 23 280 65 148 QDT70210.1 von Willebrand factor type A domain protein [Planctomycetes bacterium MalM25] diamond 258 63.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium MalM25
27343043 27343043 PRJEB17675_P_NODE_8943_length_298_cov_1.821293_g8639_i0 PRJEB17675 8943 298 1.821293 5.42745314 PVC group 1783257 Bacteria Bacteria 45.1 0.0103   NR WP_199186866.1 124 g8639 i0 35 6.17114093959732 60 39 60.4 0 18 197 395 454 WP_199186866.1 TIGR01777 family oxidoreductase [Blastopirellula marina] diamond 1839 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Blastopirellula Blastopirellula marina
28043885 28043885 PRJEB17675_P_NODE_16965_length_194_cov_1.006289_g16661_i0 PRJEB17675 16965 194 1.006289 1.95220066 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.7 0.0194   NR HJP01358.1 2026780 g16661 i0 41.5 1.00515463917526 65 31 94.3 2 5 187 95 156 HJP01358.1 choice-of-anchor A family protein [Planctomycetota bacterium] diamond 195 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28669101 28669101 PRJEB17675_P_NODE_5607_length_403_cov_1.614130_g5308_i0 PRJEB17675 5607 403 1.61413 6.5049439 PVC group 1783257 Bacteria Bacteria 55.1 8.83e-6   NR MAX26391.1 2026777 g5308 i0 32.4 6.15632754342432 108 73 80.4 0 326 3 167 274 MAX26391.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 2481 55.5 0.992792792792793 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
29016593 29016593 PRJEB17675_P_NODE_17748_length_188_cov_1.307190_g17444_i0 PRJEB17675 17748 188 1.30719 2.4575172 PVC group 1783257 Bacteria Bacteria 44.7 0.00373   NR MDP6539182.1 2026780 g17444 i0 35.6 4.26063829787234 59 36 94.1 1 184 8 207 263 MDP6539182.1 choice-of-anchor A family protein [Planctomycetota bacterium] diamond 801 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29496282 29496282 PRJEB17675_P_NODE_19630_length_176_cov_1.304965_g19326_i0 PRJEB17675 19630 176 1.304965 2.2967384 Planctomycetota bacterium 2026780 Bacteria Bacteria 47 4.74e-4   NR MEM7812758.1 2026780 g19326 i0 45 0.681818181818182 40 22 68.2 0 176 57 234 273 MEM7812758.1 zinc-dependent alcohol dehydrogenase family protein [Planctomycetota bacterium] diamond 120 47 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29527962 29527962 PRJEB17675_P_NODE_21530_length_166_cov_1.206107_g21226_i0 PRJEB17675 21530 166 1.206107 2.00213762 Bremerella cremea 1031537 Bacteria Bacteria 86.3 5.91e-18   NR WP_345093321.1 1031537 g21226 i0 74 8.51204819277108 50 13 90.4 0 1 150 410 459 WP_345093321.1 phosphoenolpyruvate carboxykinase (ATP) [Bremerella cremea] diamond 1413 86.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Bremerella Bremerella cremea
29653790 29653790 PRJEB17675_P_NODE_19770_length_175_cov_1.500000_g19466_i0 PRJEB17675 19770 175 1.5 2.625 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 78.6 3.57e-15   NR MBA3313741.1 2026779 g19466 i0 61.4 0.977142857142857 57 22 97.7 0 172 2 2024 2080 MBA3313741.1 hypothetical protein [Planctomycetaceae bacterium] diamond 171 78.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30089806 30089806 PRJEB17675_P_NODE_6632_length_364_cov_1.465046_g6329_i0 PRJEB17675 6632 364 1.465046 5.33276744 Bacteria 2 Bacteria Bacteria 47.8 0.00225   NR MBS0187422.1 2026780 g6329 i0 43.4 1.35989010989011 76 42 62.6 1 2 229 41 115 MBS0187422.1 choice-of-anchor A family protein [Planctomycetota bacterium] diamond 495 48.1 0.993762993762994 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30127681 30127681 PRJEB17675_P_NODE_3552_length_521_cov_1.956790_g3269_i0 PRJEB17675 3552 521 1.95679 10.1948759 Pirellulaceae bacterium 2699754 Bacteria Bacteria 45.4 0.0471   NR MEQ8788125.1 2699754 g3269 i0 30.3 0.570057581573896 99 63 53.6 3 70 348 95 193 MEQ8788125.1 class I mannose-6-phosphate isomerase [Pirellulaceae bacterium] diamond 297 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
30759926 30759926 PRJEB17675_P_NODE_294_length_1529_cov_3.174029_g239_i0 PRJEB17675 294 1529 3.174029 48.53090341 Phycisphaerales bacterium 2052180 Bacteria Bacteria 102 7.71e-20   NR MFT3684555.1 2052180 g239 i0 29.3 1.27141922825376 324 192 62.2 12 1165 215 15 308 MFT3684555.1 choice-of-anchor A family protein [Phycisphaerales bacterium] diamond 1944 102 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30886228 30886228 PRJEB17675_P_NODE_20394_length_171_cov_2.647059_g20090_i0 PRJEB17675 20394 171 2.647059 4.52647089 Planctomycetota bacterium 2026780 Bacteria Bacteria 82 2.03e-16   NR MEM1330204.1 2026780 g20090 i0 70.4 0.947368421052632 54 16 94.7 0 171 10 20 73 MEM1330204.1 MmgE/PrpD family protein [Planctomycetota bacterium] diamond 162 82 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30918010 30918010 PRJEB17675_P_NODE_794_length_1041_cov_2.732604_g661_i0 PRJEB17675 794 1041 2.732604 28.44640764 Phycisphaerales bacterium 2052180 Bacteria Bacteria 120 4.17e-27   NR MFT3684555.1 2052180 g661 i0 31.1 0.907780979827089 315 177 87.9 12 1030 116 24 308 MFT3684555.1 choice-of-anchor A family protein [Phycisphaerales bacterium] diamond 945 120 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31075946 31075946 PRJEB17675_P_NODE_8735_length_302_cov_3.161049_g8431_i0 PRJEB17675 8735 302 3.161049 9.54636798 Symmachiella macrocystis 2527985 Bacteria Bacteria 47.4 0.00169   NR WP_146374485.1 2527985 g8431 i0 41.7 1.78807947019868 60 34 59.6 1 301 122 381 439 WP_146374485.1 caspase family protein [Symmachiella macrocystis] diamond 540 47.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Symmachiella Symmachiella macrocystis
31233643 31233643 PRJEB17675_P_NODE_7295_length_343_cov_1.298701_g6991_i0 PRJEB17675 7295 343 1.298701 4.45454443 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 49.7 3.01e-4   NR MBO7680721.1 2691551 g6991 i0 34.4 2.09912536443149 90 53 78.7 2 283 14 126 209 MBO7680721.1 ankyrin repeat domain-containing protein [Thermoguttaceae bacterium] diamond 720 49.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
31297035 31297035 PRJEB17675_P_NODE_24295_length_154_cov_1.344538_g23991_i0 PRJEB17675 24295 154 1.344538 2.07058852 Sedimentisphaerales bacterium 2813034 Bacteria Bacteria 41.6 0.0279   NR MBN2313733.1 2813034 g23991 i0 46.3 0.798701298701299 41 20 76 1 128 12 794 834 MBN2313733.1 hypothetical protein [Sedimentisphaerales bacterium] diamond 123 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Sedimentisphaerales     Sedimentisphaerales bacterium
31392147 31392147 PRJEB17675_P_NODE_4556_length_456_cov_1.691211_g4259_i0 PRJEB17675 4556 456 1.691211 7.71192216 Phycisphaerales bacterium 2052180 Bacteria Bacteria 79 1.06e-14   NR MBY0307183.1 2052180 g4259 i0 39.9 2.68421052631579 138 77 88.8 5 407 3 45 179 MBY0307183.1 choice-of-anchor A family protein [Phycisphaerales bacterium] diamond 1224 79 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31487076 31487076 PRJEB17675_P_NODE_20196_length_173_cov_1.094203_g19892_i0 PRJEB17675 20196 173 1.094203 1.89297119 Stieleria varia 2528005 Bacteria Bacteria 46.6 6.29e-4   NR WP_231741779.1 2528005 g19892 i0 44.9 0.84971098265896 49 27 85 0 149 3 367 415 WP_231741779.1 vWA domain-containing protein [Stieleria varia] diamond 147 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Stieleria Stieleria varia
31796526 31796526 PRJEB17675_P_NODE_1797_length_730_cov_2.359712_g1580_i0 PRJEB17675 1797 730 2.359712 17.2258976 PVC group 1783257 Bacteria Bacteria 52 0.00105   NR MBN8603554.1 2026780 g1580 i0 33 1.47123287671233 115 72 46 4 15 350 218 330 MBN8603554.1 hypothetical protein [Planctomycetota bacterium] diamond 1074 52.4 0.99236641221374 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32309704 32309704 PRJEB17675_P_NODE_439_length_1323_cov_2.606366_g355_i0 PRJEB17675 439 1323 2.606366 34.48222218 Phycisphaerales bacterium 2052180 Bacteria Bacteria 137 9.98e-33   NR MFT3684555.1 2052180 g355 i0 34.5 0.702947845804989 310 171 68.7 11 14 922 24 308 MFT3684555.1 choice-of-anchor A family protein [Phycisphaerales bacterium] diamond 930 137 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32656635 32656635 PRJEB17675_P_NODE_11300_length_254_cov_1.374429_g10996_i0 PRJEB17675 11300 254 1.374429 3.49104966 Phycisphaerae bacterium 2026778 Bacteria Bacteria 70.9 4.87e-12   NR MFQ5490686.1 2026778 g10996 i0 44.3 2.50393700787402 70 39 82.7 0 6 215 342 411 MFQ5490686.1 ornithine--oxo-acid transaminase [Phycisphaerae bacterium] diamond 636 70.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
32688353 32688353 PRJEB17675_P_NODE_6000_length_387_cov_1.812500_g5700_i0 PRJEB17675 6000 387 1.8125 7.014375 Phycisphaerae bacterium 2026778 Bacteria Bacteria 84.7 3.4e-17   NR MDX2200936.1 2026778 g5700 i0 33.1 4.57364341085271 124 73 90.7 3 26 376 57 177 MDX2200936.1 DUF1579 domain-containing protein [Phycisphaerae bacterium] diamond 1770 84.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae 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);;