contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724135 | 724135 | PRJNA745553_S_NODE_19241_length_282_cov_1.473684_g19046_i0 | PRJNA745553 | 19241 | 282 | 1.473684 | 4.15578888 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 102 | 8.8e-23 | NR | HYY26347.1 | 2201154 | g19046 | i0 | 51.1 | 1.93617021276596 | 94 | 43 | 96.8 | 1 | 10 | 282 | 218 | 311 | HYY26347.1 hypothetical protein [Chthoniobacterales bacterium] | diamond | 546 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 8377655 | 8377655 | PRJNA745553_S_NODE_27987_length_233_cov_2.287500_g27792_i0 | PRJNA745553 | 27987 | 233 | 2.2875 | 5.329875 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 74.7 | 4.02e-14 | NR | WP_348542518.1 | 2510640 | g27792 | i0 | 64.7 | 1.6480686695279 | 68 | 23 | 87.6 | 1 | 206 | 3 | 86 | 152 | WP_348542518.1 hypothetical protein [Chthoniobacter sp.] | diamond | 384 | 74.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 21600796 | 21600796 | PRJNA745553_S_NODE_15037_length_317_cov_12.877049_g14842_i0 | PRJNA745553 | 15037 | 317 | 12.877049 | 40.82024533 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 71.2 | 2.61e-12 | NR | MEY3000757.1 | 2026799 | g14842 | i0 | 49.5 | 0.899053627760252 | 95 | 48 | 89.9 | 0 | 22 | 306 | 88 | 182 | MEY3000757.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 285 | 71.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26999275 | 26999275 | PRJNA745553_S_NODE_7642_length_431_cov_1.477654_g7447_i0 | PRJNA745553 | 7642 | 431 | 1.477654 | 6.36868874 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 84.7 | 3.14e-16 | NR | NLN02066.1 | 1932692 | g7447 | i0 | 59.1 | 0.932714617169374 | 66 | 23 | 45.9 | 1 | 206 | 9 | 216 | 277 | NLN02066.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 402 | 85.5 | 0.990643274853801 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 27178975 | 27178975 | PRJNA745553_S_NODE_24802_length_249_cov_1.312500_g24607_i0 | PRJNA745553 | 24802 | 249 | 1.3125 | 3.268125 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 46.6 | 7.59e-4 | NR | MFL5341867.1 | 2052164 | g24607 | i0 | 56 | 3.39759036144578 | 50 | 17 | 57.8 | 2 | 148 | 5 | 33 | 79 | MFL5341867.1 hypothetical protein [Gemmataceae bacterium] | diamond | 846 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 27305777 | 27305777 | PRJNA745553_S_NODE_8963_length_403_cov_3.045455_g8768_i0 | PRJNA745553 | 8963 | 403 | 3.045455 | 12.27318365 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 221 | 1.16e-68 | NR | MEQ1842569.1 | 2026801 | g8768 | i0 | 91.1 | 1.83126550868486 | 123 | 11 | 91.6 | 0 | 402 | 34 | 22 | 144 | MEQ1842569.1 DUF1552 domain-containing protein [Verrucomicrobiales bacterium] | diamond | 738 | 221 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 27779434 | 27779434 | PRJNA745553_S_NODE_15184_length_316_cov_2.851852_g14989_i0 | PRJNA745553 | 15184 | 316 | 2.851852 | 9.01185232 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 41.6 | 0.0417 | NR | MFT5086819.1 | 2026780 | g14989 | i0 | 47.9 | 0.455696202531646 | 48 | 24 | 44.6 | 1 | 20 | 160 | 41 | 88 | MFT5086819.1 hypothetical protein [Planctomycetota bacterium] | diamond | 144 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27842258 | 27842258 | PRJNA745553_S_NODE_24884_length_248_cov_10.537143_g24689_i0 | PRJNA745553 | 24884 | 248 | 10.537143 | 26.13211464 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 97.1 | 6.04e-24 | NR | NJR43130.1 | 2562705 | g24689 | i0 | 82.7 | 0.629032258064516 | 52 | 9 | 62.9 | 0 | 226 | 71 | 60 | 111 | NJR43130.1 DUF3172 domain-containing protein [Akkermansiaceae bacterium] | diamond | 156 | 97.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 28041940 | 28041940 | PRJNA745553_S_NODE_20765_length_271_cov_5.424242_g20570_i0 | PRJNA745553 | 20765 | 271 | 5.424242 | 14.69969582 | Planctomycetia | 203683 | Bacteria | Bacteria | 59.3 | 7.5e-8 | NR | HVL12751.1 | 1914242 | g20570 | i0 | 59.2 | 1.5830258302583 | 49 | 20 | 54.2 | 0 | 103 | 249 | 2 | 50 | HVL12751.1 PQQ-binding-like beta-propeller repeat protein [Gemmata sp.] | diamond | 429 | 59.7 | 0.993299832495812 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmata | Gemmata sp. | |
| 28199524 | 28199524 | PRJNA745553_S_NODE_2686_length_606_cov_7.123827_g2507_i0 | PRJNA745553 | 2686 | 606 | 7.123827 | 43.17039162 | Verrucomicrobiales | 48461 | Bacteria | Bacteria | 129 | 1.68e-34 | NR | NCF13526.1 | 2026800 | g2507 | i0 | 46.8 | 2.14356435643564 | 141 | 74 | 69.3 | 1 | 595 | 176 | 1 | 141 | NCF13526.1 L,D-transpeptidase family protein [Verrucomicrobiaceae bacterium] | diamond | 1299 | 130 | 0.992307692307692 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 29294824 | 29294824 | PRJNA745553_S_NODE_19309_length_281_cov_4.966346_g19114_i0 | PRJNA745553 | 19309 | 281 | 4.966346 | 13.95543226 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 41.6 | 0.0213 | NR | HYE06036.1 | 2026780 | g19114 | i0 | 54.8 | 0.330960854092527 | 31 | 14 | 33.1 | 0 | 145 | 237 | 1 | 31 | HYE06036.1 hypothetical protein [Planctomycetota bacterium] | diamond | 93 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29999694 | 29999694 | PRJNA745553_S_NODE_4851_length_509_cov_2.855505_g4659_i0 | PRJNA745553 | 4851 | 509 | 2.855505 | 14.53452045 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82 | 3.97e-15 | NR | NQW47738.1 | 2026780 | g4659 | i0 | 42.6 | 1.33202357563851 | 115 | 55 | 64.2 | 3 | 330 | 4 | 50 | 159 | NQW47738.1 hypothetical protein [Planctomycetota bacterium] | diamond | 678 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30400781 | 30400781 | PRJNA745553_S_NODE_26753_length_241_cov_1.833333_g26558_i0 | PRJNA745553 | 26753 | 241 | 1.833333 | 4.41833253 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 57 | 1.44e-8 | NR | MFH1678000.1 | 2035772 | g26558 | i0 | 76.5 | 0.846473029045643 | 34 | 8 | 42.3 | 0 | 218 | 117 | 33 | 66 | MFH1678000.1 acyl carrier protein [Candidatus Omnitrophota bacterium] | diamond | 204 | 57 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30432298 | 30432298 | PRJNA745553_S_NODE_4593_length_519_cov_4.195067_g4403_i0 | PRJNA745553 | 4593 | 519 | 4.195067 | 21.77239773 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 80.1 | 4.61e-16 | NR | NJR41937.1 | 2562705 | g4403 | i0 | 55.8 | 1.01734104046243 | 77 | 33 | 43.9 | 1 | 181 | 408 | 24 | 100 | NJR41937.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 528 | 80.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 31316683 | 31316683 | PRJNA745553_S_NODE_11155_length_366_cov_2.174061_g10960_i0 | PRJNA745553 | 11155 | 366 | 2.174061 | 7.95706326 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 117 | 2.42e-29 | NR | NJR41800.1 | 2562705 | g10960 | i0 | 54.1 | 0.89344262295082 | 109 | 50 | 89.3 | 0 | 364 | 38 | 165 | 273 | NJR41800.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 327 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 31854334 | 31854334 | PRJNA745553_S_NODE_2157_length_642_cov_6.472759_g1983_i0 | PRJNA745553 | 2157 | 642 | 6.472759 | 41.55511278 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 47.4 | 0.0218 | NR | MFT7513748.1 | 2035772 | g1983 | i0 | 31.5 | 0.593457943925234 | 127 | 71 | 51.9 | 5 | 146 | 478 | 190 | 316 | MFT7513748.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 381 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32044258 | 32044258 | PRJNA745553_S_NODE_5158_length_499_cov_3.523474_g4964_i0 | PRJNA745553 | 5158 | 499 | 3.523474 | 17.58213526 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 125 | 2.58e-30 | NR | MCK6474102.1 | 2026780 | g4964 | i0 | 45.5 | 0.925851703406814 | 154 | 80 | 90.8 | 3 | 24 | 476 | 186 | 338 | MCK6474102.1 ATP-binding protein [Planctomycetota bacterium] | diamond | 462 | 125 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32613515 | 32613515 | PRJNA745553_S_NODE_19000_length_283_cov_7.700000_g18805_i0 | PRJNA745553 | 19000 | 283 | 7.7 | 21.791 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 45.1 | 6.96e-4 | NR | NJR41825.1 | 2562705 | g18805 | i0 | 76.9 | 0.826855123674912 | 26 | 6 | 27.6 | 0 | 275 | 198 | 33 | 58 | NJR41825.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 234 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 32613521 | 32613521 | PRJNA745553_S_NODE_27880_length_233_cov_5.800000_g27685_i0 | PRJNA745553 | 27880 | 233 | 5.8 | 13.514 | Chlamydia trachomatis | 813 | Bacteria | Bacteria | 56.6 | 2.52e-8 | NR | CRH76625.1 | 813 | g27685 | i0 | 50.7 | 0.862660944206009 | 67 | 24 | 79.8 | 2 | 228 | 43 | 29 | 91 | CRH76625.1 Uncharacterised protein [Chlamydia trachomatis] | diamond | 201 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia trachomatis | |
| 32739632 | 32739632 | PRJNA745553_S_NODE_20800_length_271_cov_3.661616_g20605_i0 | PRJNA745553 | 20800 | 271 | 3.661616 | 9.92297936 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 54.7 | 3.21e-6 | NR | MDR0902603.1 | 2006848 | g20605 | i0 | 39.3 | 0.929889298892989 | 84 | 46 | 87.5 | 2 | 3 | 239 | 475 | 558 | MDR0902603.1 autotransporter outer membrane beta-barrel domain-containing protein [Opitutaceae bacterium] | diamond | 252 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae 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);;