contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA431371" and tax_phylum = "Planctomycetota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14457463 | 14457463 | PRJNA431371_P_NODE_8632_length_422_cov_1.736390_g8559_i0 | PRJNA431371 | 8632 | 422 | 1.73639 | 7.3275658 | Pirellulales bacterium | 2715253 | Bacteria | Bacteria | 87.4 | 6.45e-17 | NR | MFM8733708.1 | 2715253 | g8559 | i0 | 44.9 | 0.632701421800948 | 89 | 49 | 63.3 | 0 | 411 | 145 | 474 | 562 | MFM8733708.1 peroxidase family protein [Pirellulales bacterium] | diamond | 267 | 87.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulales bacterium | |||
| 18279773 | 18279773 | PRJNA431371_P_NODE_24615_length_251_cov_0.932584_g24542_i0 | PRJNA431371 | 24615 | 251 | 0.932584 | 2.34078584 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 129 | 4.1799999999999995e-35 | NR | HXG09396.1 | 2052164 | g24542 | i0 | 78.3 | 7.50597609561753 | 83 | 18 | 99.2 | 0 | 251 | 3 | 131 | 213 | HXG09396.1 SDR family NAD(P)-dependent oxidoreductase [Gemmataceae bacterium] | diamond | 1884 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 26663947 | 26663947 | PRJNA431371_P_NODE_14361_length_336_cov_1.463878_g14288_i0 | PRJNA431371 | 14361 | 336 | 1.463878 | 4.91863008 | Thermoguttaceae bacterium | 2691551 | Bacteria | Bacteria | 141 | 1.76e-38 | NR | MEN6365759.1 | 2691551 | g14288 | i0 | 57.1 | 7 | 112 | 48 | 100 | 0 | 1 | 336 | 160 | 271 | MEN6365759.1 DNA adenine methylase [Thermoguttaceae bacterium] | diamond | 2352 | 141 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Thermoguttaceae | Thermoguttaceae bacterium | ||
| 27233812 | 27233812 | PRJNA431371_P_NODE_12423_length_359_cov_0.947552_g12350_i0 | PRJNA431371 | 12423 | 359 | 0.947552 | 3.40171168 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 57 | 1.47e-6 | NR | MFO0979315.1 | 2026779 | g12350 | i0 | 53.5 | 0.35933147632312 | 43 | 20 | 35.9 | 0 | 8 | 136 | 510 | 552 | MFO0979315.1 serine/threonine-protein kinase [Planctomycetaceae bacterium] | diamond | 129 | 57 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 27265497 | 27265497 | PRJNA431371_P_NODE_34263_length_243_cov_0.905882_g34190_i0 | PRJNA431371 | 34263 | 243 | 0.905882 | 2.20129326 | Candidatus Brocadiia bacterium | 2517210 | Bacteria | Bacteria | 89 | 1.87e-18 | NR | NUM34221.1 | 2517210 | g34190 | i0 | 61.5 | 0.802469135802469 | 65 | 25 | 80.2 | 0 | 204 | 10 | 395 | 459 | NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium] | diamond | 195 | 89 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiia bacterium | ||||
| 27581221 | 27581221 | PRJNA431371_P_NODE_29344_length_247_cov_0.885057_g29271_i0 | PRJNA431371 | 29344 | 247 | 0.885057 | 2.18609079 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 55.5 | 1.18e-7 | NR | MEO1993831.1 | 2026779 | g29271 | i0 | 50 | 0.680161943319838 | 56 | 26 | 68 | 2 | 246 | 79 | 49 | 102 | MEO1993831.1 mechanosensitive ion channel domain-containing protein [Planctomycetaceae bacterium] | diamond | 168 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 27597946 | 27597946 | PRJNA431371_P_NODE_7064_length_461_cov_1.389175_g6991_i0 | PRJNA431371 | 7064 | 461 | 1.389175 | 6.40409675 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 87 | 1.37e-16 | NR | MBL8813776.1 | 2026779 | g6991 | i0 | 40.2 | 3.11062906724512 | 132 | 72 | 83.9 | 4 | 1 | 387 | 416 | 543 | MBL8813776.1 peroxidase [Planctomycetaceae bacterium] | diamond | 1434 | 87 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 27708033 | 27708033 | PRJNA431371_P_NODE_14424_length_335_cov_2.057252_g14351_i0 | PRJNA431371 | 14424 | 335 | 2.057252 | 6.8917942 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 45.8 | 0.00919 | NR | MBI5366802.1 | 2026780 | g14351 | i0 | 35.9 | 0.922388059701493 | 103 | 63 | 90.4 | 2 | 11 | 313 | 545 | 646 | MBI5366802.1 protein kinase [Planctomycetota bacterium] | diamond | 309 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27739494 | 27739494 | PRJNA431371_P_NODE_25364_length_251_cov_0.865169_g25291_i0 | PRJNA431371 | 25364 | 251 | 0.865169 | 2.17157419 | Pirellulales bacterium | 2715253 | Bacteria | Bacteria | 53.9 | 4.89e-6 | NR | MFV2066317.1 | 2715253 | g25291 | i0 | 57.1 | 0.669322709163347 | 56 | 19 | 64.5 | 2 | 172 | 11 | 641 | 693 | MFV2066317.1 Ig-like domain-containing protein [Pirellulales bacterium] | diamond | 168 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulales bacterium | |||
| 28054781 | 28054781 | PRJNA431371_P_NODE_11145_length_376_cov_1.016502_g11072_i0 | PRJNA431371 | 11145 | 376 | 1.016502 | 3.82204752 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 142 | 8.19e-41 | NR | MDP6444306.1 | 2699754 | g11072 | i0 | 61.3 | 0.949468085106383 | 119 | 38 | 91 | 3 | 372 | 31 | 11 | 126 | MDP6444306.1 DUF4440 domain-containing protein [Pirellulaceae bacterium] | diamond | 357 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 28244146 | 28244146 | PRJNA431371_P_NODE_10806_length_381_cov_1.464286_g10733_i0 | PRJNA431371 | 10806 | 381 | 1.464286 | 5.57892966 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 48.5 | 0.00164 | NR | MBM4070698.1 | 2026780 | g10733 | i0 | 41.3 | 0.496062992125984 | 63 | 34 | 47.2 | 1 | 38 | 217 | 561 | 623 | MBM4070698.1 tetratricopeptide repeat protein [Planctomycetota bacterium] | diamond | 189 | 48.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28528702 | 28528702 | PRJNA431371_P_NODE_9147_length_411_cov_1.266272_g9074_i0 | PRJNA431371 | 9147 | 411 | 1.266272 | 5.20437792 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 194 | 6.029999999999999e-56 | NR | MCK6490333.1 | 2026780 | g9074 | i0 | 68.4 | 5.81751824817518 | 136 | 43 | 99.3 | 0 | 410 | 3 | 143 | 278 | MCK6490333.1 arginine--tRNA ligase [Planctomycetota bacterium] | diamond | 2391 | 194 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28923726 | 28923726 | PRJNA431371_P_NODE_24828_length_251_cov_0.865169_g24755_i0 | PRJNA431371 | 24828 | 251 | 0.865169 | 2.17157419 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 73.9 | 3.52e-14 | NR | MBN2842661.1 | 2813034 | g24755 | i0 | 50 | 1.72111553784861 | 72 | 34 | 86.1 | 2 | 3 | 218 | 62 | 131 | MBN2842661.1 CHAP domain-containing protein [Sedimentisphaerales bacterium] | diamond | 432 | 73.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Sedimentisphaerales | Sedimentisphaerales bacterium | |||
| 29065382 | 29065382 | PRJNA431371_P_NODE_9368_length_407_cov_0.739521_g9295_i0 | PRJNA431371 | 9368 | 407 | 0.739521 | 3.00985047 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 44.7 | 0.0418 | NR | MFH0946870.1 | 2026780 | g9295 | i0 | 36.8 | 0.7002457002457 | 95 | 54 | 68.6 | 4 | 115 | 393 | 342 | 432 | MFH0946870.1 hypothetical protein [Planctomycetota bacterium] | diamond | 285 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29570315 | 29570315 | PRJNA431371_P_NODE_16130_length_319_cov_2.191057_g16057_i0 | PRJNA431371 | 16130 | 319 | 2.191057 | 6.98947183 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 67.8 | 4.78e-11 | NR | NLX59159.1 | 2026778 | g16057 | i0 | 41.7 | 1.72100313479624 | 96 | 56 | 90.3 | 0 | 303 | 16 | 61 | 156 | NLX59159.1 hypothetical protein [Phycisphaerae bacterium] | diamond | 549 | 67.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 30170425 | 30170425 | PRJNA431371_P_NODE_8692_length_421_cov_1.318966_g8619_i0 | PRJNA431371 | 8692 | 421 | 1.318966 | 5.55284686 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 61.2 | 7.35e-9 | NR | MEI8376678.1 | 2026780 | g8619 | i0 | 43.2 | 1.04750593824228 | 88 | 48 | 62.7 | 1 | 419 | 156 | 42 | 127 | MEI8376678.1 ADP-ribosylglycohydrolase family protein [Planctomycetota bacterium] | diamond | 441 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30186923 | 30186923 | PRJNA431371_P_NODE_12152_length_362_cov_1.065744_g12079_i0 | PRJNA431371 | 12152 | 362 | 1.065744 | 3.85799328 | Pirellulales | 2691354 | Bacteria | Bacteria | 105 | 1.5699999999999994e-23 | NR | WP_347243905.1 | 1962930 | g12079 | i0 | 50 | 3.54696132596685 | 110 | 51 | 87.8 | 1 | 358 | 41 | 401 | 510 | WP_347243905.1 S8 family serine peptidase, partial [Thermogutta sp.] | diamond | 1284 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Thermoguttaceae | Thermogutta | Thermogutta sp. | |
| 30360584 | 30360584 | PRJNA431371_P_NODE_2472_length_691_cov_1.810680_g2399_i0 | PRJNA431371 | 2472 | 691 | 1.81068 | 12.5117988 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 48.9 | 0.0102 | NR | MEC7555909.1 | 2026780 | g2399 | i0 | 30.5 | 0.725036179450072 | 167 | 100 | 69.9 | 8 | 203 | 685 | 379 | 535 | MEC7555909.1 tetratricopeptide repeat protein [Planctomycetota bacterium] | diamond | 501 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30518087 | 30518087 | PRJNA431371_P_NODE_35633_length_242_cov_0.899408_g35560_i0 | PRJNA431371 | 35633 | 242 | 0.899408 | 2.17656736 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 42 | 0.0242 | NR | MEY2742659.1 | 2026780 | g35560 | i0 | 43.6 | 0.681818181818182 | 55 | 29 | 65.7 | 1 | 217 | 59 | 35 | 89 | MEY2742659.1 hypothetical protein [Planctomycetota bacterium] | diamond | 165 | 42 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30549604 | 30549604 | PRJNA431371_P_NODE_17493_length_307_cov_0.987179_g17420_i0 | PRJNA431371 | 17493 | 307 | 0.987179 | 3.03063953 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 47 | 0.00219 | NR | MCP4608556.1 | 2026780 | g17420 | i0 | 42.6 | 0.596091205211726 | 61 | 33 | 58.6 | 2 | 256 | 77 | 30 | 89 | MCP4608556.1 LamG domain-containing protein [Planctomycetota bacterium] | diamond | 183 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30960497 | 30960497 | PRJNA431371_P_NODE_20894_length_279_cov_1.553398_g20821_i0 | PRJNA431371 | 20894 | 279 | 1.553398 | 4.33398042 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 43.5 | 0.0189 | NR | HET6328477.1 | 2026779 | g20821 | i0 | 32.6 | 0.989247311827957 | 92 | 56 | 97.8 | 3 | 274 | 2 | 64 | 150 | HET6328477.1 hypothetical protein [Planctomycetaceae bacterium] | diamond | 276 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 31023649 | 31023649 | PRJNA431371_P_NODE_21755_length_273_cov_1.515000_g21682_i0 | PRJNA431371 | 21755 | 273 | 1.515 | 4.13595 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 43.1 | 0.0395 | NR | MDP6520300.1 | 2026780 | g21682 | i0 | 35.3 | 0.56043956043956 | 51 | 33 | 56 | 0 | 154 | 2 | 743 | 793 | MDP6520300.1 carboxypeptidase-like regulatory domain-containing protein [Planctomycetota bacterium] | diamond | 153 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31307983 | 31307983 | PRJNA431371_P_NODE_17235_length_309_cov_1.305085_g17162_i0 | PRJNA431371 | 17235 | 309 | 1.305085 | 4.03271265 | Candidatus Brocadiia bacterium | 2517210 | Bacteria | Bacteria | 57.8 | 4.07e-7 | NR | NUM34221.1 | 2517210 | g17162 | i0 | 43.9 | 0.796116504854369 | 82 | 40 | 79.6 | 4 | 307 | 62 | 427 | 502 | NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium] | diamond | 246 | 57.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiia bacterium | ||||
| 31339639 | 31339639 | PRJNA431371_P_NODE_11256_length_374_cov_1.192691_g11183_i0 | PRJNA431371 | 11256 | 374 | 1.192691 | 4.46066434 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 151 | 2.77e-40 | NR | MCS6970948.1 | 2026780 | g11183 | i0 | 58.4 | 5.99197860962567 | 125 | 49 | 99.5 | 2 | 3 | 374 | 318 | 440 | MCS6970948.1 arginine--tRNA ligase [Planctomycetota bacterium] | diamond | 2241 | 151 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31561318 | 31561318 | PRJNA431371_P_NODE_34056_length_243_cov_0.905882_g33983_i0 | PRJNA431371 | 34056 | 243 | 0.905882 | 2.20129326 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 62.8 | 3.11e-9 | NR | MBL8827949.1 | 2026779 | g33983 | i0 | 46.1 | 1.90123456790123 | 76 | 33 | 93.8 | 2 | 238 | 11 | 54 | 121 | MBL8827949.1 DUF2029 domain-containing protein [Planctomycetaceae bacterium] | diamond | 462 | 62.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 31655832 | 31655832 | PRJNA431371_P_NODE_97_length_1854_cov_2.344189_g75_i0 | PRJNA431371 | 97 | 1854 | 2.344189 | 43.46126406 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 285 | 5.869999999999999e-87 | NR | MEK7411798.1 | 2026780 | g75 | i0 | 47.4 | 0.56957928802589 | 352 | 179 | 56.3 | 3 | 1725 | 682 | 7 | 356 | MEK7411798.1 hypothetical protein [Planctomycetota bacterium] | diamond | 1056 | 285 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31687585 | 31687585 | PRJNA431371_P_NODE_24097_length_255_cov_1.346154_g24024_i0 | PRJNA431371 | 24097 | 255 | 1.346154 | 3.4326927 | Gemmata palustris | 2822762 | Bacteria | Bacteria | 63.5 | 1.63e-9 | NR | WP_210660116.1 | 2822762 | g24024 | i0 | 44.9 | 1.55294117647059 | 69 | 37 | 81.2 | 1 | 45 | 251 | 16 | 83 | WP_210660116.1 WD40 repeat domain-containing protein [Gemmata palustris] | diamond | 396 | 63.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmata | Gemmata palustris | |
| 32478837 | 32478837 | PRJNA431371_P_NODE_25059_length_251_cov_0.865169_g24986_i0 | PRJNA431371 | 25059 | 251 | 0.865169 | 2.17157419 | Candidatus Brocadiia bacterium | 2517210 | Bacteria | Bacteria | 56.2 | 7.1e-7 | NR | NUM34221.1 | 2517210 | g24986 | i0 | 53.1 | 0.585657370517928 | 49 | 23 | 58.6 | 0 | 152 | 6 | 396 | 444 | NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium] | diamond | 147 | 56.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiia bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;