contig_metadata
27 rows where bioproject = "PRJNA473201" and tax_clade = "PVC group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5548126 | 5548126 | PRJNA473201_P_NODE_76945_length_245_cov_0.895349_g76203_i0 | PRJNA473201 | 76945 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82.4 | 2.03e-17 | NR | NIP23489.1 | 2026778 | g76203 | i0 | 53.8 | 3.79591836734694 | 78 | 35 | 94.3 | 1 | 239 | 9 | 1 | 78 | NIP23489.1 RNA 2'-phosphotransferase [Phycisphaerae bacterium] | diamond | 930 | 82.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 15746704 | 15746704 | PRJNA473201_P_NODE_52573_length_285_cov_17.165094_g51831_i0 | PRJNA473201 | 52573 | 285 | 17.165094 | 48.9205179 | Opitutus terrae | 107709 | Bacteria | Bacteria | 143 | 1.52e-29 | NTclustered | gi|177839040|gb|CP001032.1| | 452637 | g51831 | i0 | 92.929 | 33.4842105263158 | 99 | 5 | 34 | 2 | 15 | 112 | 2052834 | 2052931 | Opitutus terrae PB90-1, complete genome | blastn | 9543 | 143 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 19570412 | 19570412 | PRJNA473201_P_NODE_85256_length_241_cov_0.916667_g84514_i0 | PRJNA473201 | 85256 | 241 | 0.916667 | 2.20916747 | Saltatorellus ferox | 2528018 | Bacteria | Bacteria | 145 | 3.48e-30 | NTclustered | gi|1712682957|gb|CP036434.1| | 2528018 | g84514 | i0 | 80.423 | 58.3858921161826 | 189 | 37 | 78 | 0 | 31 | 219 | 3604364 | 3604176 | Planctomycetes bacterium Poly30 chromosome, complete genome | blastn | 14071 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Saltatorellus | Saltatorellus ferox | |||
| 22120714 | 22120714 | PRJNA473201_P_NODE_62298_length_260_cov_1.299465_g61556_i0 | PRJNA473201 | 62298 | 260 | 1.299465 | 3.378609 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 94.7 | 2.32e-20 | NR | RYD77759.1 | 2026800 | g61556 | i0 | 64.9 | 0.888461538461538 | 77 | 27 | 88.8 | 0 | 259 | 29 | 447 | 523 | RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium] | diamond | 231 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 26601038 | 26601038 | PRJNA473201_P_NODE_68321_length_250_cov_0.870056_g67579_i0 | PRJNA473201 | 68321 | 250 | 0.870056 | 2.17514 | Omnitrophica bacterium RBG_13_46_9 | 1801818 | Bacteria | Bacteria | 54.7 | 2.28e-6 | NR | OGW75973.1 | 1801818 | g67579 | i0 | 34.1 | 1.74 | 82 | 46 | 98.4 | 1 | 1 | 246 | 55 | 128 | OGW75973.1 MAG: hypothetical protein A2Z72_04745 [Omnitrophica bacterium RBG_13_46_9] | diamond | 435 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica bacterium RBG_13_46_9 | |||||
| 26807631 | 26807631 | PRJNA473201_P_NODE_52821_length_285_cov_1.165094_g52079_i0 | PRJNA473201 | 52821 | 285 | 1.165094 | 3.3205179 | Bacteria | 2 | Bacteria | Bacteria | 56.6 | 5.7e-7 | NR | MFT5328049.1 | 2026779 | g52079 | i0 | 37.2 | 3.57894736842105 | 94 | 54 | 98.9 | 2 | 3 | 284 | 70 | 158 | MFT5328049.1 carbonic anhydrase [Planctomycetaceae bacterium] | diamond | 1020 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 27486990 | 27486990 | PRJNA473201_P_NODE_76043_length_246_cov_0.890173_g75301_i0 | PRJNA473201 | 76043 | 246 | 0.890173 | 2.18982558 | Planctomycetales bacterium | 2053591 | Bacteria | Bacteria | 47.4 | 7.82e-4 | NR | MCA9139358.1 | 2053591 | g75301 | i0 | 39.2 | 0.902439024390244 | 74 | 26 | 79.3 | 2 | 241 | 47 | 29 | 92 | MCA9139358.1 hypothetical protein [Planctomycetales bacterium] | diamond | 222 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetales bacterium | |||
| 27613419 | 27613419 | PRJNA473201_P_NODE_78024_length_245_cov_0.895349_g77282_i0 | PRJNA473201 | 78024 | 245 | 0.895349 | 2.19360505 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 42.7 | 0.0385 | NR | MEI8380909.1 | 2026780 | g77282 | i0 | 45.9 | 0.453061224489796 | 37 | 20 | 45.3 | 0 | 157 | 47 | 436 | 472 | MEI8380909.1 glycosyltransferase family 9 protein [Planctomycetota bacterium] | diamond | 111 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27739898 | 27739898 | PRJNA473201_P_NODE_32124_length_349_cov_1.623188_g31382_i0 | PRJNA473201 | 32124 | 349 | 1.623188 | 5.66492612 | Candidatus Didemnitutus sp. | 2814259 | Bacteria | Bacteria | 64.7 | 2.61e-9 | NR | MBP6863799.1 | 2814259 | g31382 | i0 | 39.1 | 0.988538681948424 | 115 | 66 | 97.1 | 3 | 10 | 348 | 764 | 876 | MBP6863799.1 immunoglobulin domain-containing protein [Candidatus Didemnitutus sp.] | diamond | 345 | 64.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Candidatus Didemnitutus | Candidatus Didemnitutus sp. | |
| 28970993 | 28970993 | PRJNA473201_P_NODE_49848_length_292_cov_1.726027_g49106_i0 | PRJNA473201 | 49848 | 292 | 1.726027 | 5.03999884 | Zavarzinella formosa | 360055 | Bacteria | Bacteria | 47.4 | 0.00167 | NR | WP_020468205.1 | 360055 | g49106 | i0 | 37 | 1.02739726027397 | 100 | 43 | 88.4 | 3 | 291 | 34 | 1753 | 1846 | WP_020468205.1 beta strand repeat-containing protein [Zavarzinella formosa] | diamond | 300 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Zavarzinella | Zavarzinella formosa | |
| 29034347 | 29034347 | PRJNA473201_P_NODE_77968_length_245_cov_0.895349_g77226_i0 | PRJNA473201 | 77968 | 245 | 0.895349 | 2.19360505 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 75.1 | 1.58e-13 | NR | PWU11941.1 | 2026799 | g77226 | i0 | 46.2 | 1.9469387755102 | 78 | 40 | 95.5 | 1 | 235 | 2 | 1941 | 2016 | PWU11941.1 MAG: hypothetical protein C5B50_22285 [Verrucomicrobiota bacterium] | diamond | 477 | 75.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29065795 | 29065795 | PRJNA473201_P_NODE_10728_length_617_cov_2.566176_g9995_i0 | PRJNA473201 | 10728 | 617 | 2.566176 | 15.83330592 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 84 | 7.97e-15 | NR | MSR63205.1 | 2026780 | g9995 | i0 | 47.7 | 0.427876823338736 | 88 | 40 | 42.8 | 2 | 140 | 403 | 342 | 423 | MSR63205.1 HYR domain-containing protein [Planctomycetota bacterium] | diamond | 264 | 84 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29176758 | 29176758 | PRJNA473201_P_NODE_77929_length_245_cov_0.895349_g77187_i0 | PRJNA473201 | 77929 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 65.1 | 4.03e-10 | NR | MCP4652737.1 | 2035772 | g77187 | i0 | 45.9 | 4.42040816326531 | 61 | 33 | 74.7 | 0 | 58 | 240 | 6 | 66 | MCP4652737.1 ribose-phosphate pyrophosphokinase [Candidatus Omnitrophota bacterium] | diamond | 1083 | 65.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29286573 | 29286573 | PRJNA473201_P_NODE_75549_length_246_cov_0.890173_g74807_i0 | PRJNA473201 | 75549 | 246 | 0.890173 | 2.18982558 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 59.7 | 4.12e-8 | NR | MFH1338997.1 | 2035772 | g74807 | i0 | 68.4 | 1.3780487804878 | 38 | 12 | 46.3 | 0 | 2 | 115 | 204 | 241 | MFH1338997.1 thrombospondin type 3 repeat-containing protein [Candidatus Omnitrophota bacterium] | diamond | 339 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30076050 | 30076050 | PRJNA473201_P_NODE_16732_length_486_cov_12.397094_g15990_i0 | PRJNA473201 | 16732 | 486 | 12.397094 | 60.24987684 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 75.5 | 5.03e-13 | NR | MEP5351923.1 | 1962973 | g15990 | i0 | 51.6 | 0.574074074074074 | 93 | 43 | 56.8 | 2 | 85 | 360 | 84 | 175 | MEP5351923.1 reverse transcriptase domain-containing protein [Luteolibacter sp.] | diamond | 279 | 75.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 30138979 | 30138979 | PRJNA473201_P_NODE_61712_length_261_cov_19.271277_g60970_i0 | PRJNA473201 | 61712 | 261 | 19.271277 | 50.29803297 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 106 | 1.5600000000000002e-26 | NR | HBO57038.1 | 2026771 | g60970 | i0 | 61.2 | 0.977011494252874 | 85 | 33 | 97.7 | 0 | 256 | 2 | 71 | 155 | HBO57038.1 endonuclease [Opitutia bacterium] | diamond | 255 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 30424123 | 30424123 | PRJNA473201_P_NODE_80213_length_244_cov_0.900585_g79471_i0 | PRJNA473201 | 80213 | 244 | 0.900585 | 2.1974274 | Planctomycetia bacterium | 2052181 | Bacteria | Bacteria | 43.1 | 0.0167 | NR | NCY03362.1 | 2052181 | g79471 | i0 | 43.1 | 0.713114754098361 | 58 | 28 | 65.2 | 1 | 61 | 219 | 55 | 112 | NCY03362.1 hypothetical protein [Planctomycetia bacterium] | diamond | 174 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetia bacterium | ||||
| 30644725 | 30644725 | PRJNA473201_P_NODE_81053_length_243_cov_0.905882_g80311_i0 | PRJNA473201 | 81053 | 243 | 0.905882 | 2.20129326 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 137 | 1.72e-36 | NR | MFA6044981.1 | 2052180 | g80311 | i0 | 75.9 | 0.975308641975309 | 79 | 19 | 97.5 | 0 | 7 | 243 | 284 | 362 | MFA6044981.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 237 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 30661043 | 30661043 | PRJNA473201_P_NODE_16613_length_488_cov_7.455422_g15871_i0 | PRJNA473201 | 16613 | 488 | 7.455422 | 36.38245936 | Candidatus Bathyanammoxibius | 2983802 | Bacteria | Bacteria | 66.2 | 1.36e-9 | NR | MEK7449764.1 | 2026780 | g15871 | i0 | 59.2 | 10.2356557377049 | 49 | 20 | 30.1 | 0 | 245 | 99 | 173 | 221 | MEK7449764.1 c-type cytochrome biogenesis protein CcsB [Planctomycetota bacterium] | diamond | 4995 | 66.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30787491 | 30787491 | PRJNA473201_P_NODE_72114_length_248_cov_0.880000_g71372_i0 | PRJNA473201 | 72114 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 159 | 3e-43 | NR | MEN9573094.1 | 2026799 | g71372 | i0 | 92.7 | 3.96774193548387 | 82 | 6 | 99.2 | 0 | 246 | 1 | 849 | 930 | MEN9573094.1 Concanavalin A-like lectin/glucanase superfamily [Verrucomicrobiota bacterium] | diamond | 984 | 159 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31308419 | 31308419 | PRJNA473201_P_NODE_67955_length_250_cov_0.870056_g67213_i0 | PRJNA473201 | 67955 | 250 | 0.870056 | 2.17514 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 52.8 | 1.26e-5 | NR | HTL47411.1 | 2499141 | g67213 | i0 | 46.3 | 0.648 | 54 | 29 | 64.8 | 0 | 50 | 211 | 2711 | 2764 | HTL47411.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 162 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31561724 | 31561724 | PRJNA473201_P_NODE_65316_length_252_cov_1.614525_g64574_i0 | PRJNA473201 | 65316 | 252 | 1.614525 | 4.068603 | Pirellulales bacterium | 2715253 | Bacteria | Bacteria | 71.6 | 2.92e-12 | NR | HWB08540.1 | 2715253 | g64574 | i0 | 52.4 | 4.98809523809524 | 84 | 37 | 100 | 2 | 252 | 1 | 1247 | 1327 | HWB08540.1 immunoglobulin domain-containing protein [Pirellulales bacterium] | diamond | 1257 | 71.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulales bacterium | |||
| 31687996 | 31687996 | PRJNA473201_P_NODE_28537_length_369_cov_1.753378_g27795_i0 | PRJNA473201 | 28537 | 369 | 1.753378 | 6.46996482 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 231 | 1.36e-71 | NR | MDR3405335.1 | 2510640 | g27795 | i0 | 87 | 2 | 123 | 16 | 100 | 0 | 369 | 1 | 280 | 402 | MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.] | diamond | 738 | 231 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 32447622 | 32447622 | PRJNA473201_P_NODE_81999_length_243_cov_0.905882_g81257_i0 | PRJNA473201 | 81999 | 243 | 0.905882 | 2.20129326 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 42.7 | 0.0206 | NR | MEY3458332.1 | 2026780 | g81257 | i0 | 50 | 0.617283950617284 | 50 | 18 | 61.7 | 1 | 71 | 220 | 51 | 93 | MEY3458332.1 hypothetical protein [Planctomycetota bacterium] | diamond | 150 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32762778 | 32762778 | PRJNA473201_P_NODE_35700_length_333_cov_1.184615_g34958_i0 | PRJNA473201 | 35700 | 333 | 1.184615 | 3.94476795 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 66.2 | 1.15e-10 | NR | GDY20741.1 | 2026799 | g34958 | i0 | 37.7 | 2.74774774774775 | 106 | 58 | 93.7 | 4 | 333 | 22 | 77 | 176 | GDY20741.1 NUDIX hydrolase [Verrucomicrobiota bacterium] | diamond | 915 | 66.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32762783 | 32762783 | PRJNA473201_P_NODE_54560_length_280_cov_21.932367_g53818_i0 | PRJNA473201 | 54560 | 280 | 21.932367 | 61.4106276 | Rhodopirellula bahusiensis | 2014065 | Bacteria | Bacteria | 45.4 | 0.0034 | NR | MEP4684613.1 | 2014065 | g53818 | i0 | 48.8 | 0.439285714285714 | 41 | 21 | 43.9 | 0 | 72 | 194 | 110 | 150 | MEP4684613.1 hypothetical protein [Rhodopirellula bahusiensis] | diamond | 123 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Rhodopirellula | Rhodopirellula bahusiensis | |
| 32857255 | 32857255 | PRJNA473201_P_NODE_76460_length_246_cov_0.890173_g75718_i0 | PRJNA473201 | 76460 | 246 | 0.890173 | 2.18982558 | Planctomycetales bacterium ZRK34 | 2723666 | Bacteria | Bacteria | 77.4 | 8.24e-16 | NR | QNN24803.1 | 2723666 | g75718 | i0 | 65.5 | 2.25609756097561 | 55 | 19 | 67.1 | 0 | 184 | 20 | 62 | 116 | QNN24803.1 MGMT family protein [Planctomycetales bacterium ZRK34] | diamond | 555 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetales bacterium ZRK34 |
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);;