contig_metadata
21 rows where bioproject = "PRJNA1082072", tax_clade = "PVC group" and tax_kingdom = "Pseudomonadati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1467757 | 1467757 | PRJNA1082072_P_NODE_2082_length_251_cov_0.865169_g2075_i0 | PRJNA1082072 | 2082 | 251 | 0.865169 | 2.17157419 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 140 | 2.37e-36 | NR | HEY7152357.1 | 2052164 | g2075 | i0 | 88 | 1.97211155378486 | 83 | 10 | 99.2 | 0 | 249 | 1 | 146 | 228 | HEY7152357.1 DNA-directed RNA polymerase subunit beta' [Gemmataceae bacterium] | diamond | 495 | 140 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 2743897 | 2743897 | PRJNA1082072_P_NODE_1723_length_274_cov_1.457711_g1716_i0 | PRJNA1082072 | 1723 | 274 | 1.457711 | 3.99412814 | Thermoguttaceae bacterium | 2691551 | Bacteria | Bacteria | 62 | 9e-9 | NR | MEN6494220.1 | 2691551 | g1716 | i0 | 52.8 | 0.788321167883212 | 72 | 34 | 78.8 | 0 | 257 | 42 | 748 | 819 | MEN6494220.1 efflux RND transporter permease subunit [Thermoguttaceae bacterium] | diamond | 216 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Thermoguttaceae | Thermoguttaceae bacterium | ||
| 9120803 | 9120803 | PRJNA1082072_P_NODE_2308_length_249_cov_0.875000_g2301_i0 | PRJNA1082072 | 2308 | 249 | 0.875 | 2.17875 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 105 | 5.91e-25 | NR | HZV00243.1 | 2026780 | g2301 | i0 | 64.6 | 2.97590361445783 | 82 | 29 | 98.8 | 0 | 247 | 2 | 198 | 279 | HZV00243.1 PDZ domain-containing protein [Planctomycetota bacterium] | diamond | 741 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 11671872 | 11671872 | PRJNA1082072_P_NODE_2350_length_248_cov_0.880000_g2343_i0 | PRJNA1082072 | 2350 | 248 | 0.88 | 2.1824 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 127 | 2.9999999999999998e-33 | NR | HZU99629.1 | 2026780 | g2343 | i0 | 81.5 | 1.95967741935484 | 81 | 15 | 98 | 0 | 1 | 243 | 214 | 294 | HZU99629.1 thiolase family protein [Planctomycetota bacterium] | diamond | 486 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 26909349 | 26909349 | PRJNA1082072_P_NODE_2382_length_248_cov_0.880000_g2375_i0 | PRJNA1082072 | 2382 | 248 | 0.88 | 2.1824 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 46.2 | 0.00242 | NR | MBN2561389.1 | 2026778 | g2375 | i0 | 39.7 | 2.98790322580645 | 58 | 34 | 69 | 1 | 75 | 245 | 168 | 225 | MBN2561389.1 protein kinase [Phycisphaerae bacterium] | diamond | 741 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 26909351 | 26909351 | PRJNA1082072_P_NODE_602_length_406_cov_1.849850_g595_i0 | PRJNA1082072 | 602 | 406 | 1.84985 | 7.510391 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 50.1 | 6.28e-4 | NR | MCY2974157.1 | 2026780 | g595 | i0 | 36.1 | 1.6256157635468 | 72 | 46 | 53.2 | 0 | 5 | 220 | 274 | 345 | MCY2974157.1 hypothetical protein [Planctomycetota bacterium] | diamond | 660 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28078114 | 28078114 | PRJNA1082072_P_NODE_2365_length_248_cov_0.880000_g2358_i0 | PRJNA1082072 | 2365 | 248 | 0.88 | 2.1824 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 93.2 | 7.1e-20 | NR | MEC8554359.1 | 2026780 | g2358 | i0 | 56.1 | 3.97983870967742 | 82 | 36 | 99.2 | 0 | 1 | 246 | 768 | 849 | MEC8554359.1 Ig-like domain-containing protein [Planctomycetota bacterium] | diamond | 987 | 93.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28267468 | 28267468 | PRJNA1082072_P_NODE_1246_length_310_cov_1.126582_g1239_i0 | PRJNA1082072 | 1246 | 310 | 1.126582 | 3.4924042 | Roseimaritima ulvae | 980254 | Bacteria | Bacteria | 53.5 | 1.4e-5 | NR | WP_168215727.1 | 980254 | g1239 | i0 | 39.8 | 2.99032258064516 | 103 | 62 | 99.7 | 0 | 1 | 309 | 1551 | 1653 | WP_168215727.1 Ig-like domain-containing protein [Roseimaritima ulvae] | diamond | 927 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Roseimaritima | Roseimaritima ulvae | |
| 28393869 | 28393869 | PRJNA1082072_P_NODE_1806_length_268_cov_1.579487_g1799_i0 | PRJNA1082072 | 1806 | 268 | 1.579487 | 4.23302516 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 54.3 | 3.92e-6 | NR | MCH8165545.1 | 2026780 | g1799 | i0 | 41.5 | 0.727611940298508 | 65 | 37 | 72.8 | 1 | 230 | 36 | 149 | 212 | MCH8165545.1 hypothetical protein [Planctomycetota bacterium] | diamond | 195 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29120374 | 29120374 | PRJNA1082072_P_NODE_1929_length_260_cov_1.112299_g1922_i0 | PRJNA1082072 | 1929 | 260 | 1.112299 | 2.8919774 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 104 | 2.22e-25 | NR | MBY0307716.1 | 2052180 | g1922 | i0 | 56.6 | 0.957692307692308 | 83 | 35 | 94.6 | 1 | 5 | 250 | 22 | 104 | MBY0307716.1 S10 family peptidase [Phycisphaerales bacterium] | diamond | 249 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 29814687 | 29814687 | PRJNA1082072_P_NODE_2171_length_250_cov_0.870056_g2164_i0 | PRJNA1082072 | 2171 | 250 | 0.870056 | 2.17514 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 85.9 | 1.19e-17 | NR | MFO0965902.1 | 2052164 | g2164 | i0 | 88.6 | 3.144 | 44 | 5 | 52.8 | 0 | 1 | 132 | 171 | 214 | MFO0965902.1 biopolymer transporter Tol [Gemmataceae bacterium] | diamond | 786 | 85.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 29941307 | 29941307 | PRJNA1082072_P_NODE_2251_length_249_cov_0.875000_g2244_i0 | PRJNA1082072 | 2251 | 249 | 0.875 | 2.17875 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 46.2 | 0.00256 | NR | MBC8871848.1 | 2026780 | g2244 | i0 | 43.2 | 1.85542168674699 | 74 | 37 | 89.2 | 3 | 231 | 10 | 1089 | 1157 | MBC8871848.1 DUF4347 domain-containing protein [Planctomycetota bacterium] | diamond | 462 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30312199 | 30312199 | PRJNA1082072_P_NODE_1612_length_280_cov_1.115942_g1605_i0 | PRJNA1082072 | 1612 | 280 | 1.115942 | 3.1246376 | root | 1 | Root_unresolved | Root_unresolved | 133 | 2.18e-36 | NR | MCB1084310.1 | 34094 | g1605 | i0 | 70.7 | 3.94285714285714 | 92 | 27 | 98.6 | 0 | 280 | 5 | 39 | 130 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 1104 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 30415404 | 30415404 | PRJNA1082072_P_NODE_2513_length_246_cov_0.890173_g2506_i0 | PRJNA1082072 | 2513 | 246 | 0.890173 | 2.18982558 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 42.4 | 0.0407 | NR | MFM9001903.1 | 2026771 | g2506 | i0 | 34.9 | 0.768292682926829 | 63 | 36 | 70.7 | 1 | 176 | 3 | 116 | 178 | MFM9001903.1 hypothetical protein [Opitutia bacterium] | diamond | 189 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 30415405 | 30415405 | PRJNA1082072_P_NODE_2973_length_241_cov_0.916667_g2966_i0 | PRJNA1082072 | 2973 | 241 | 0.916667 | 2.20916747 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 60.1 | 2.87e-8 | NR | MBN8246635.1 | 2026799 | g2966 | i0 | 33.3 | 3.4356846473029 | 60 | 40 | 74.7 | 0 | 241 | 62 | 753 | 812 | MBN8246635.1 preprotein translocase subunit SecA [Verrucomicrobiota bacterium] | diamond | 828 | 60.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30659241 | 30659241 | PRJNA1082072_P_NODE_1493_length_286_cov_1.807512_g1486_i0 | PRJNA1082072 | 1493 | 286 | 1.807512 | 5.16948432 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 57.8 | 3.1e-7 | NR | HLX60008.1 | 2026780 | g1486 | i0 | 48.6 | 1.5 | 72 | 29 | 75.5 | 2 | 66 | 281 | 221 | 284 | HLX60008.1 phosphoesterase [Planctomycetota bacterium] | diamond | 429 | 57.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30794095 | 30794095 | PRJNA1082072_P_NODE_2814_length_242_cov_1.822485_g2807_i0 | PRJNA1082072 | 2814 | 242 | 1.822485 | 4.4104137 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 59.7 | 3.94e-8 | NR | MFH1921320.1 | 2026780 | g2807 | i0 | 41.3 | 3.83057851239669 | 75 | 43 | 93 | 1 | 232 | 8 | 887 | 960 | MFH1921320.1 PKD domain-containing protein [Planctomycetota bacterium] | diamond | 927 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31805869 | 31805869 | PRJNA1082072_P_NODE_1137_length_324_cov_2.091633_g1130_i0 | PRJNA1082072 | 1137 | 324 | 2.091633 | 6.77689092 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 85.9 | 7.16e-17 | NR | MBN2505827.1 | 2026799 | g1130 | i0 | 45 | 2.83333333333333 | 111 | 50 | 98.1 | 4 | 320 | 3 | 416 | 520 | MBN2505827.1 HYR domain-containing protein [Verrucomicrobiota bacterium] | diamond | 918 | 85.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32027401 | 32027401 | PRJNA1082072_P_NODE_2978_length_241_cov_0.916667_g2971_i0 | PRJNA1082072 | 2978 | 241 | 0.916667 | 2.20916747 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 59.3 | 5.31e-8 | NR | MCK4659826.1 | 2026778 | g2971 | i0 | 43.9 | 0.821576763485477 | 66 | 35 | 82.2 | 1 | 40 | 237 | 91 | 154 | MCK4659826.1 hypothetical protein [Phycisphaerae bacterium] | diamond | 198 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 32249183 | 32249183 | PRJNA1082072_P_NODE_218_length_636_cov_2.296625_g211_i0 | PRJNA1082072 | 218 | 636 | 2.296625 | 14.606535 | Zavarzinella formosa | 360055 | Bacteria | Bacteria | 62 | 3.44e-7 | NR | WP_020468205.1 | 360055 | g211 | i0 | 37.9 | 0.660377358490566 | 140 | 60 | 56.1 | 6 | 21 | 377 | 1733 | 1866 | WP_020468205.1 beta strand repeat-containing protein [Zavarzinella formosa] | diamond | 420 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Zavarzinella | Zavarzinella formosa | |
| 32525406 | 32525406 | PRJNA1082072_P_NODE_379_length_492_cov_1.930788_g372_i0 | PRJNA1082072 | 379 | 492 | 1.930788 | 9.49947696 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 80.9 | 2.88e-14 | NR | MFN0136844.1 | 2026778 | g372 | i0 | 39 | 2.70121951219512 | 154 | 84 | 93.3 | 4 | 32 | 490 | 1099 | 1243 | MFN0136844.1 choice-of-anchor tandem repeat NxxGxxAF-containing protein [Phycisphaerae bacterium] | diamond | 1329 | 81.6 | 0.991421568627451 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae 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);;