contig_metadata
22 rows where bioproject = "PRJNA549880" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1787269 | 1787269 | PRJNA549880_P_NODE_12722_length_247_cov_0.885057_g12629_i0 | PRJNA549880 | 12722 | 247 | 0.885057 | 2.18609079 | Phycisphaeraceae bacterium | 2026777 | Bacteria | Bacteria | 243 | 1.23e-59 | NTclustered | gi|1938775668|gb|CP054178.1| | 2026777 | g12629 | i0 | 87.383 | 191.506072874494 | 214 | 23 | 85 | 4 | 1 | 211 | 194138 | 194350 | MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome | blastn | 47302 | 243 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaeraceae | Phycisphaeraceae bacterium | ||
| 3062705 | 3062705 | PRJNA549880_P_NODE_11123_length_250_cov_0.870056_g11030_i0 | PRJNA549880 | 11123 | 250 | 0.870056 | 2.17514 | Chthoniobacter | 295577 | Bacteria | Bacteria | 131 | 6.72e-34 | NR | WP_131989125.1 | 191863 | g11030 | i0 | 84.3 | 3.984 | 83 | 13 | 99.6 | 0 | 249 | 1 | 402 | 484 | WP_131989125.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Chthoniobacter flavus] | diamond | 996 | 131 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 18363358 | 18363358 | PRJNA549880_P_NODE_11335_length_249_cov_1.312500_g11242_i0 | PRJNA549880 | 11335 | 249 | 1.3125 | 3.268125 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 96.7 | 2.37e-22 | NR | HEY1083879.1 | 1965333 | g11242 | i0 | 95.8 | 0.578313253012048 | 48 | 2 | 57.8 | 0 | 105 | 248 | 1 | 48 | HEY1083879.1 hypothetical protein [Prosthecobacter sp.] | diamond | 144 | 96.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 22188843 | 22188843 | PRJNA549880_P_NODE_8278_length_281_cov_1.177885_g8185_i0 | PRJNA549880 | 8278 | 281 | 1.177885 | 3.30985685 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 127 | 4.9000000000000005e-34 | NR | MEA3210088.1 | 2510640 | g8185 | i0 | 84.3 | 2.24199288256228 | 70 | 11 | 74.7 | 0 | 280 | 71 | 186 | 255 | MEA3210088.1 methionyl aminopeptidase [Chthoniobacter sp.] | diamond | 630 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 26997648 | 26997648 | PRJNA549880_P_NODE_13002_length_246_cov_0.890173_g12909_i0 | PRJNA549880 | 13002 | 246 | 0.890173 | 2.18982558 | PVC group | 1783257 | Bacteria | Bacteria | 139 | 2.9e-40 | NR | HEV7869214.1 | 2811408 | g12909 | i0 | 84.1 | 2 | 82 | 13 | 100 | 0 | 246 | 1 | 33 | 114 | HEV7869214.1 VTT domain-containing protein [Chthoniobacteraceae bacterium] | diamond | 492 | 139 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 27204151 | 27204151 | PRJNA549880_P_NODE_8482_length_278_cov_1.487805_g8389_i0 | PRJNA549880 | 8482 | 278 | 1.487805 | 4.1360979 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 174 | 3.61e-49 | NR | MDB6120269.1 | 2026800 | g8389 | i0 | 94.6 | 0.992805755395683 | 92 | 5 | 99.3 | 0 | 1 | 276 | 423 | 514 | MDB6120269.1 sul1 [Verrucomicrobiaceae bacterium] | diamond | 276 | 174 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 27330916 | 27330916 | PRJNA549880_P_NODE_9523_length_263_cov_1.215789_g9430_i0 | PRJNA549880 | 9523 | 263 | 1.215789 | 3.19752507 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 91.3 | 4.08e-19 | NR | MBN1527352.1 | 2035772 | g9430 | i0 | 45.3 | 2.85171102661597 | 86 | 47 | 98.1 | 0 | 258 | 1 | 630 | 715 | MBN1527352.1 valine--tRNA ligase [Candidatus Omnitrophota bacterium] | diamond | 750 | 91.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27520278 | 27520278 | PRJNA549880_P_NODE_12863_length_246_cov_1.450867_g12770_i0 | PRJNA549880 | 12863 | 246 | 1.450867 | 3.56913282 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 65.9 | 8.83e-12 | NR | RYD66739.1 | 2026800 | g12770 | i0 | 54.4 | 0.695121951219512 | 57 | 26 | 69.5 | 0 | 174 | 4 | 1 | 57 | RYD66739.1 MAG: hypothetical protein EOP83_04320 [Verrucomicrobiaceae bacterium] | diamond | 171 | 65.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28277909 | 28277909 | PRJNA549880_P_NODE_8386_length_279_cov_2.233010_g8293_i0 | PRJNA549880 | 8386 | 279 | 2.23301 | 6.2300979 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 130 | 1.1499999999999999e-32 | NR | RYD66867.1 | 2026800 | g8293 | i0 | 64.5 | 1 | 93 | 33 | 100 | 0 | 279 | 1 | 515 | 607 | RYD66867.1 MAG: hypothetical protein EOP83_04055, partial [Verrucomicrobiaceae bacterium] | diamond | 279 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28846234 | 28846234 | PRJNA549880_P_NODE_8788_length_274_cov_1.179104_g8695_i0 | PRJNA549880 | 8788 | 274 | 1.179104 | 3.23074496 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 189 | 2.3699999999999997e-56 | NR | HEY1083325.1 | 1965333 | g8695 | i0 | 98.9 | 0.996350364963504 | 91 | 1 | 99.6 | 0 | 2 | 274 | 92 | 182 | HEY1083325.1 condensation domain-containing protein [Prosthecobacter sp.] | diamond | 273 | 189 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 29492705 | 29492705 | PRJNA549880_P_NODE_15250_length_242_cov_0.911243_g15157_i0 | PRJNA549880 | 15250 | 242 | 0.911243 | 2.20520806 | Chthoniobacter | 295577 | Bacteria | Bacteria | 90.9 | 1.91e-19 | NR | WP_006977527.1 | 191863 | g15157 | i0 | 95.3 | 1.59917355371901 | 43 | 2 | 53.3 | 0 | 114 | 242 | 98 | 140 | WP_006977527.1 aminopeptidase [Chthoniobacter flavus] | diamond | 387 | 90.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 29572459 | 29572459 | PRJNA549880_P_NODE_14290_length_244_cov_0.894737_g14197_i0 | PRJNA549880 | 14290 | 244 | 0.894737 | 2.18315828 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 40.8 | 0.0389 | NR | RYD66026.1 | 2026800 | g14197 | i0 | 58.6 | 0.35655737704918 | 29 | 11 | 35.7 | 1 | 146 | 232 | 38 | 65 | RYD66026.1 MAG: hypothetical protein EOP83_06015 [Verrucomicrobiaceae bacterium] | diamond | 87 | 40.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30235897 | 30235897 | PRJNA549880_P_NODE_15212_length_242_cov_0.911243_g15119_i0 | PRJNA549880 | 15212 | 242 | 0.911243 | 2.20520806 | Candidatus Brocadiales bacterium | 2760054 | Bacteria | Bacteria | 42 | 0.0368 | NR | MEE9200699.1 | 2760054 | g15119 | i0 | 65 | 0.247933884297521 | 20 | 7 | 24.8 | 0 | 175 | 116 | 30 | 49 | MEE9200699.1 cytochrome C [Candidatus Brocadiales bacterium] | diamond | 60 | 42 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiales | Candidatus Brocadiales bacterium | |||
| 30299518 | 30299518 | PRJNA549880_P_NODE_15272_length_242_cov_0.911243_g15179_i0 | PRJNA549880 | 15272 | 242 | 0.911243 | 2.20520806 | Anatilimnocola aggregata | 2528021 | Bacteria | Bacteria | 137 | 3.0599999999999995e-37 | NR | WP_202921142.1 | 2528021 | g15179 | i0 | 88.6 | 0.979338842975207 | 79 | 9 | 97.9 | 0 | 1 | 237 | 184 | 262 | WP_202921142.1 NAD(P)H-dependent glycerol-3-phosphate dehydrogenase [Anatilimnocola aggregata] | diamond | 237 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Anatilimnocola | Anatilimnocola aggregata | |
| 31278508 | 31278508 | PRJNA549880_P_NODE_11195_length_250_cov_0.870056_g11102_i0 | PRJNA549880 | 11195 | 250 | 0.870056 | 2.17514 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 124 | 4.02e-31 | NR | RYD67054.1 | 2026800 | g11102 | i0 | 72 | 0.984 | 82 | 23 | 98.4 | 0 | 4 | 249 | 87 | 168 | RYD67054.1 MAG: PAS domain S-box protein [Verrucomicrobiaceae bacterium] | diamond | 246 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31689723 | 31689723 | PRJNA549880_P_NODE_9637_length_261_cov_1.638298_g9544_i0 | PRJNA549880 | 9637 | 261 | 1.638298 | 4.27595778 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 49.7 | 1.6e-4 | NR | MBT3202658.1 | 2052180 | g9544 | i0 | 62.1 | 0.333333333333333 | 29 | 11 | 33.3 | 0 | 155 | 69 | 439 | 467 | MBT3202658.1 DUF1593 domain-containing protein [Phycisphaerales bacterium] | diamond | 87 | 49.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 31847883 | 31847883 | PRJNA549880_P_NODE_12457_length_247_cov_0.885057_g12364_i0 | PRJNA549880 | 12457 | 247 | 0.885057 | 2.18609079 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 55.5 | 1.22e-6 | NR | MEQ1859438.1 | 2811408 | g12364 | i0 | 57.8 | 1.03238866396761 | 45 | 19 | 54.7 | 0 | 137 | 3 | 1 | 45 | MEQ1859438.1 dicarboxylate/amino acid:cation symporter [Chthoniobacteraceae bacterium] | diamond | 255 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 31911243 | 31911243 | PRJNA549880_P_NODE_13597_length_245_cov_0.895349_g13504_i0 | PRJNA549880 | 13597 | 245 | 0.895349 | 2.19360505 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 58.2 | 1.05e-8 | NR | MEI9897641.1 | 2510640 | g13504 | i0 | 61.9 | 0.514285714285714 | 42 | 16 | 51.4 | 0 | 47 | 172 | 66 | 107 | MEI9897641.1 hypothetical protein [Chthoniobacter sp.] | diamond | 126 | 58.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 32037850 | 32037850 | PRJNA549880_P_NODE_7198_length_297_cov_1.321429_g7105_i0 | PRJNA549880 | 7198 | 297 | 1.321429 | 3.92464413 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 57.8 | 2.03e-7 | NR | MEI9893325.1 | 2510640 | g7105 | i0 | 65 | 0.818181818181818 | 40 | 14 | 40.4 | 0 | 176 | 295 | 1 | 40 | MEI9893325.1 CHASE3 domain-containing protein [Chthoniobacter sp.] | diamond | 243 | 57.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 32607104 | 32607104 | PRJNA549880_P_NODE_12900_length_246_cov_0.919075_g12807_i0 | PRJNA549880 | 12900 | 246 | 0.919075 | 2.2609245 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 85.1 | 4.78e-17 | NR | MDR3402433.1 | 2510640 | g12807 | i0 | 52 | 1.74390243902439 | 75 | 36 | 91.5 | 0 | 237 | 13 | 49 | 123 | MDR3402433.1 hypothetical protein [Chthoniobacter sp.] | diamond | 429 | 85.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 32621885 | 32621885 | PRJNA549880_P_NODE_9380_length_265_cov_1.317708_g9287_i0 | PRJNA549880 | 9380 | 265 | 1.317708 | 3.4919262 | Chthoniobacter | 295577 | Bacteria | Bacteria | 52 | 2.56e-5 | NR | MEA3210404.1 | 2510640 | g9287 | i0 | 65.9 | 0.928301886792453 | 41 | 14 | 46.4 | 0 | 125 | 3 | 1 | 41 | MEA3210404.1 hypothetical protein [Chthoniobacter sp.] | diamond | 246 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 32701483 | 32701483 | PRJNA549880_P_NODE_14400_length_243_cov_0.905882_g14307_i0 | PRJNA549880 | 14400 | 243 | 0.905882 | 2.20129326 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 120 | 7.26e-30 | NR | MEO8352811.1 | 2811408 | g14307 | i0 | 70 | 0.987654320987654 | 80 | 24 | 98.8 | 0 | 4 | 243 | 428 | 507 | MEO8352811.1 helicase-related protein [Chthoniobacteraceae bacterium] | diamond | 240 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae 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);;