RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1111082" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1111082 · 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
215311 215311 PRJNA1111082_P_NODE_3961_length_391_cov_1.830189_g3916_i0 PRJNA1111082 3961 391 1.830189 7.15603899 Gemmata sp. 1914242 Bacteria Bacteria 190 8.439999999999999e-55   NR HEY1188550.1 1914242 g3916 i0 73.8 1.92583120204604 126 33 96.7 0 1 378 63 188 HEY1188550.1 terminase TerL endonuclease subunit [Gemmata sp.] diamond 753 190 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
7867996 7867996 PRJNA1111082_P_NODE_11787_length_246_cov_0.901734_g11742_i0 PRJNA1111082 11787 246 0.901734 2.21826564 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 121 1.33e-33   NR MEO6810791.1 2691532 g11742 i0 76.3 0.975609756097561 80 19 97.6 0 3 242 27 106 MEO6810791.1 quaternary ammonium compound efflux SMR transporter SugE [Isosphaeraceae bacterium] diamond 240 121 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
14244067 14244067 PRJNA1111082_P_NODE_11212_length_249_cov_0.886364_g11167_i0 PRJNA1111082 11212 249 0.886364 2.20704636 Pirellula 123 Bacteria Bacteria 160 3.2399999999999998e-46   NR ADB15389.1 530564 g11167 i0 88.9 2.95180722891566 81 9 97.6 0 247 5 217 297 ADB15389.1 Xylose isomerase domain protein TIM barrel [Pirellula staleyi DSM 6068] diamond 735 160 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula staleyi
20616425 20616425 PRJNA1111082_P_NODE_12837_length_236_cov_2.883436_g12792_i0 PRJNA1111082 12837 236 2.883436 6.80490896 Planctomycetota bacterium 2026780 Bacteria Bacteria 65.5 3.32e-10   NR MEM9588827.1 2026780 g12792 i0 54.1 0.940677966101695 74 29 87.7 2 21 227 608 681 MEM9588827.1 hypothetical protein [Planctomycetota bacterium] diamond 222 65.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
22698191 22698191 PRJNA1111082_P_NODE_11218_length_249_cov_0.886364_g11173_i0 PRJNA1111082 11218 249 0.886364 2.20704636 Gemmataceae bacterium 2052164 Bacteria Bacteria 77 1.96e-14   NR HZY85830.1 2052164 g11173 i0 52.4 1.97590361445783 82 32 98.8 1 248 3 170 244 HZY85830.1 hypothetical protein [Gemmataceae bacterium] diamond 492 77 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
26783126 26783126 PRJNA1111082_P_NODE_7461_length_296_cov_1.354260_g7416_i0 PRJNA1111082 7461 296 1.35426 4.0086096 Zavarzinella formosa 360055 Bacteria Bacteria 75.5 6.88e-14   NR WP_020471670.1 360055 g7416 i0 44.3 1.79391891891892 88 49 89.2 0 33 296 59 146 WP_020471670.1 hypothetical protein [Zavarzinella formosa] diamond 531 75.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Zavarzinella Zavarzinella formosa
26814735 26814735 PRJNA1111082_P_NODE_8501_length_278_cov_2.380488_g8456_i0 PRJNA1111082 8501 278 2.380488 6.61775664 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 197 3.21e-58   NR MBQ3333869.1 2691551 g8456 i0 100 0.992805755395683 92 0 99.3 0 278 3 65 156 MBQ3333869.1 outer membrane beta-barrel protein [Thermoguttaceae bacterium] diamond 276 197 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
28173098 28173098 PRJNA1111082_P_NODE_10406_length_253_cov_0.866667_g10361_i0 PRJNA1111082 10406 253 0.866667 2.19266751 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 54.7 2.11e-6   NR WP_068411074.1 1636152 g10361 i0 55.1 0.58102766798419 49 22 58.1 0 251 105 237 285 WP_068411074.1 hypothetical protein [Planctomyces sp. SH-PL62] diamond 147 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
28362524 28362524 PRJNA1111082_P_NODE_6766_length_310_cov_0.966245_g6721_i0 PRJNA1111082 6766 310 0.966245 2.9953595 Gemmataceae bacterium 2052164 Bacteria Bacteria 45.1 0.0098   NR MFO0937836.1 2052164 g6721 i0 40 0.967741935483871 100 38 84.2 4 3 263 139 229 MFO0937836.1 phage virion morphogenesis protein [Gemmataceae bacterium] diamond 300 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28394157 28394157 PRJNA1111082_P_NODE_5526_length_337_cov_1.393939_g5481_i0 PRJNA1111082 5526 337 1.393939 4.69757443 Rhodopirellula bahusiensis 2014065 Bacteria Bacteria 138 1.4e-37   NR WP_158231013.1 2014065 g5481 i0 54.5 1.95845697329377 110 50 97.9 0 337 8 159 268 WP_158231013.1 tyrosine-type recombinase/integrase [Rhodopirellula bahusiensis] diamond 660 138 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rhodopirellula Rhodopirellula bahusiensis
28804455 28804455 PRJNA1111082_P_NODE_6228_length_320_cov_1.263158_g6183_i0 PRJNA1111082 6228 320 1.263158 4.0421056 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 103 4.78e-24   NR MBL8849220.1 2026779 g6183 i0 44.7 0.965625 103 52 94.7 2 4 306 72 171 MBL8849220.1 hypothetical protein [Planctomycetaceae bacterium] diamond 309 103 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29026024 29026024 PRJNA1111082_P_NODE_12608_length_242_cov_0.923077_g12563_i0 PRJNA1111082 12608 242 0.923077 2.23384634 Phycisphaerales bacterium 2052180 Bacteria Bacteria 116 8.91e-29   NR MDB5302699.1 2052180 g12563 i0 67.5 4.95867768595041 80 26 99.2 0 241 2 265 344 MDB5302699.1 Aminotransferase [Phycisphaerales bacterium] diamond 1200 116 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29246670 29246670 PRJNA1111082_P_NODE_3929_length_392_cov_2.959248_g3884_i0 PRJNA1111082 3929 392 2.959248 11.60025216 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 105 1.61e-25   NR MBT6153218.1 2026779 g3884 i0 42.2 0.887755102040816 116 64 88.8 2 388 41 65 177 MBT6153218.1 hypothetical protein [Planctomycetaceae bacterium] diamond 348 105 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29972996 29972996 PRJNA1111082_P_NODE_3331_length_421_cov_1.660920_g3286_i0 PRJNA1111082 3331 421 1.66092 6.9924732 Rhodopirellula sp. JC639 2755585 Bacteria Bacteria 99 2.0600000000000001e-22   NR WP_182869993.1 2755585 g3286 i0 60.8 1.68883610451306 79 31 56.3 0 185 421 1 79 WP_182869993.1 tetratricopeptide repeat protein [Rhodopirellula sp. JC639] diamond 711 99 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Stieleria Stieleria mannarensis
30762968 30762968 PRJNA1111082_P_NODE_3534_length_410_cov_1.299703_g3489_i0 PRJNA1111082 3534 410 1.299703 5.3287823 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 84 8.68e-16   NR MFO1007344.1 2026779 g3489 i0 88.1 0.307317073170732 42 5 30.7 0 2 127 482 523 MFO1007344.1 signal peptidase I [Planctomycetaceae bacterium] diamond 126 84 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30921051 30921051 PRJNA1111082_P_NODE_9974_length_257_cov_1.695652_g9929_i0 PRJNA1111082 9974 257 1.695652 4.35782564 Fuerstiella sp. 1936112 Bacteria Bacteria 44.7 0.00952   NR MCP4783352.1 1936112 g9929 i0 71.4 0.326848249027237 28 8 32.7 0 60 143 386 413 MCP4783352.1 hypothetical protein [Fuerstiella sp.] diamond 84 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella sp.
31395121 31395121 PRJNA1111082_P_NODE_10616_length_252_cov_0.871508_g10571_i0 PRJNA1111082 10616 252 0.871508 2.19620016 Thermogutta sp. 1962930 Bacteria Bacteria 66.6 3.74e-12   NR HOA52104.1 1962930 g10571 i0 48.7 0.928571428571429 78 37 90.5 2 2 229 12 88 HOA52104.1 hypothetical protein [Thermogutta sp.] diamond 234 66.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae Thermogutta Thermogutta sp.
31426585 31426585 PRJNA1111082_P_NODE_12376_length_243_cov_1.329412_g12331_i0 PRJNA1111082 12376 243 1.329412 3.23047116 Pirellula sp. 117 Bacteria Bacteria 90.1 7e-19   NR MCU0708356.1 117 g12331 i0 59.7 0.950617283950617 77 30 93.8 1 241 14 218 294 MCU0708356.1 hypothetical protein [Pirellula sp.] diamond 231 90.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
31458399 31458399 PRJNA1111082_P_NODE_8556_length_278_cov_1.141463_g8511_i0 PRJNA1111082 8556 278 1.141463 3.17326714 Planctomycetota bacterium 2026780 Bacteria Bacteria 159 2.07e-44   NR MCY2974881.1 2026780 g8511 i0 84.6 0.982014388489209 91 14 98.2 0 1 273 49 139 MCY2974881.1 L-serine ammonia-lyase [Planctomycetota bacterium] diamond 273 159 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31670843 31670843 PRJNA1111082_P_NODE_8977_length_271_cov_1.691919_g8932_i0 PRJNA1111082 8977 271 1.691919 4.58510049 Pseudomonadati 3379134 Bacteria Bacteria 143 9.8e-40   NR WP_146675247.1 1632865 g8932 i0 73 3.88560885608856 89 24 98.5 0 2 268 13 101 WP_146675247.1 DNA methyltransferase [Pirellula sp. SH-Sr6A] diamond 1053 143 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp. SH-Sr6A
31742790 31742790 PRJNA1111082_P_NODE_6337_length_317_cov_2.528689_g6292_i0 PRJNA1111082 6337 317 2.528689 8.01594413 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 50.8 4.92e-5   NR MCE5269605.1 2026779 g6292 i0 52.9 0.643533123028391 34 16 32.2 0 103 2 25 58 MCE5269605.1 thioredoxin family protein [Planctomycetaceae bacterium] diamond 204 50.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31774434 31774434 PRJNA1111082_P_NODE_2937_length_445_cov_3.284946_g2892_i0 PRJNA1111082 2937 445 3.284946 14.6180097 Planctomycetota bacterium 2026780 Bacteria Bacteria 81.6 7.84e-17   NR MEI6130685.1 2026780 g2892 i0 43.8 0.539325842696629 80 45 53.9 0 202 441 5 84 MEI6130685.1 hypothetical protein [Planctomycetota bacterium] diamond 240 81.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32027695 32027695 PRJNA1111082_P_NODE_10838_length_251_cov_0.876404_g10793_i0 PRJNA1111082 10838 251 0.876404 2.19977404 Planctomycetota bacterium 2026780 Bacteria Bacteria 72.4 1.49e-12   NR MCP4260582.1 2026780 g10793 i0 62.3 1.26693227091633 53 20 63.3 0 3 161 923 975 MCP4260582.1 amino acid adenylation domain-containing protein [Planctomycetota bacterium] diamond 318 72.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32059224 32059224 PRJNA1111082_P_NODE_11058_length_250_cov_0.870056_g11013_i0 PRJNA1111082 11058 250 0.870056 2.17514 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 140 1e-36   NR MBA4191734.1 2026779 g11013 i0 97.4 0.912 76 2 91.2 0 229 2 460 535 MBA4191734.1 S46 family peptidase [Planctomycetaceae bacterium] diamond 228 140 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32280991 32280991 PRJNA1111082_P_NODE_4979_length_353_cov_1.639286_g4934_i0 PRJNA1111082 4979 353 1.639286 5.78667958 Planctomycetota bacterium 2026780 Bacteria Bacteria 146 2.1799999999999996e-41   NR MEM9369103.1 2026780 g4934 i0 65.5 3.77337110481586 110 35 90.9 1 348 28 29 138 MEM9369103.1 hypothetical protein [Planctomycetota bacterium] diamond 1332 146 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32407410 32407410 PRJNA1111082_P_NODE_2779_length_457_cov_1.236979_g2734_i0 PRJNA1111082 2779 457 1.236979 5.65299403 Pirellula sp. SH-Sr6A 1632865 Bacteria Bacteria 102 5.37e-22   NR WP_146679622.1 1632865 g2734 i0 44.2 0.905908096280088 138 76 90.6 1 455 42 338 474 WP_146679622.1 phage portal protein [Pirellula sp. SH-Sr6A] diamond 414 102 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp. SH-Sr6A
32565825 32565825 PRJNA1111082_P_NODE_6379_length_317_cov_1.036885_g6334_i0 PRJNA1111082 6379 317 1.036885 3.28692545 Planctomycetota bacterium 2026780 Bacteria Bacteria 126 9.229999999999999e-34   NR MEK7992897.1 2026780 g6334 i0 65.4 0.984227129337539 104 36 98.4 0 314 3 33 136 MEK7992897.1 hypothetical protein [Planctomycetota bacterium] diamond 312 126 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32659749 32659749 PRJNA1111082_P_NODE_10840_length_251_cov_0.876404_g10795_i0 PRJNA1111082 10840 251 0.876404 2.19977404 Pirellulaceae bacterium 2699754 Bacteria Bacteria 46.2 0.0018   NR NLE39160.1 2699754 g10795 i0 64.9 0.884462151394422 37 13 44.2 0 251 141 175 211 NLE39160.1 glucosamine-6-phosphate deaminase [Pirellulaceae bacterium] diamond 222 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae 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);;