contig_metadata
21 rows where bioproject = "PRJNA485080" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14477712 | 14477712 | PRJNA485080_P_NODE_26772_length_249_cov_0.875000_g26678_i0 | PRJNA485080 | 26772 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 137 | 6.789999999999999e-37 | NR | MBC8108210.1 | 2026778 | g26678 | i0 | 78.3 | 3.96385542168675 | 83 | 18 | 100 | 0 | 1 | 249 | 234 | 316 | MBC8108210.1 phospho-N-acetylmuramoyl-pentapeptide-transferase [Phycisphaerae bacterium] | diamond | 987 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 14477810 | 14477810 | PRJNA485080_P_NODE_33072_length_246_cov_0.890173_g32978_i0 | PRJNA485080 | 33072 | 246 | 0.890173 | 2.18982558 | Humisphaera borealis | 2807512 | Bacteria | Bacteria | 145 | 7.08e-39 | NR | WP_206294808.1 | 2807512 | g32978 | i0 | 84.1 | 4 | 82 | 13 | 100 | 0 | 246 | 1 | 215 | 296 | WP_206294808.1 hypothetical protein [Humisphaera borealis] | diamond | 984 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Tepidisphaerales | Tepidisphaeraceae | Humisphaera | Humisphaera borealis | |
| 18300886 | 18300886 | PRJNA485080_P_NODE_36755_length_244_cov_0.900585_g36661_i0 | PRJNA485080 | 36755 | 244 | 0.900585 | 2.1974274 | Limnoglobus roseus | 2598579 | Bacteria | Bacteria | 329 | 9.08e-86 | NTclustered | gi|1733446852|gb|CP042425.1| | 2598579 | g36661 | i0 | 91.322 | 127.094262295082 | 242 | 19 | 99 | 2 | 1 | 241 | 2956909 | 2957149 | Limnoglobus roseus strain PX52 chromosome, complete genome | blastn | 31011 | 329 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Limnoglobus | Limnoglobus roseus | |
| 20850723 | 20850723 | PRJNA485080_P_NODE_24517_length_250_cov_0.870056_g24423_i0 | PRJNA485080 | 24517 | 250 | 0.870056 | 2.17514 | Phycisphaeraceae bacterium | 2026777 | Bacteria | Bacteria | 84.3 | 9.62e-17 | NR | MEX0777320.1 | 2026777 | g24423 | i0 | 57.1 | 3.996 | 84 | 35 | 99.6 | 1 | 250 | 2 | 1606 | 1689 | MEX0777320.1 PQQ-dependent sugar dehydrogenase [Phycisphaeraceae bacterium] | diamond | 999 | 84.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaeraceae | Phycisphaeraceae bacterium | ||
| 26696361 | 26696361 | PRJNA485080_P_NODE_28981_length_248_cov_0.880000_g28887_i0 | PRJNA485080 | 28981 | 248 | 0.88 | 2.1824 | Chlamydia trachomatis | 813 | Bacteria | Bacteria | 58.5 | 3.98e-9 | NR | CRH27399.1 | 813 | g28887 | i0 | 59.3 | 0.653225806451613 | 54 | 17 | 59.3 | 1 | 1 | 147 | 25 | 78 | CRH27399.1 Uncharacterised protein [Chlamydia trachomatis] | diamond | 162 | 58.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia trachomatis | |
| 27834329 | 27834329 | PRJNA485080_P_NODE_25844_length_249_cov_0.875000_g25750_i0 | PRJNA485080 | 25844 | 249 | 0.875 | 2.17875 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42.4 | 0.0394 | NR | MEI6341235.1 | 2026799 | g25750 | i0 | 39.7 | 0.698795180722892 | 58 | 33 | 67.5 | 1 | 44 | 211 | 109 | 166 | MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] | diamond | 174 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28086886 | 28086886 | PRJNA485080_P_NODE_10665_length_329_cov_0.917969_g10571_i0 | PRJNA485080 | 10665 | 329 | 0.917969 | 3.02011801 | Chlamydia trachomatis | 813 | Bacteria | Bacteria | 45.8 | 8.91e-4 | NR | CRH27399.1 | 813 | g10571 | i0 | 51 | 0.866261398176292 | 49 | 24 | 44.7 | 0 | 152 | 6 | 30 | 78 | CRH27399.1 Uncharacterised protein [Chlamydia trachomatis] | diamond | 285 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia trachomatis | |
| 28118465 | 28118465 | PRJNA485080_P_NODE_18505_length_270_cov_0.928934_g18411_i0 | PRJNA485080 | 18505 | 270 | 0.928934 | 2.5081218 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 43.1 | 0.0352 | NR | HET6408581.1 | 2811408 | g18411 | i0 | 42.9 | 0.466666666666667 | 42 | 24 | 46.7 | 0 | 264 | 139 | 192 | 233 | HET6408581.1 substrate-binding domain-containing protein [Chthoniobacteraceae bacterium] | diamond | 126 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 28244693 | 28244693 | PRJNA485080_P_NODE_30386_length_247_cov_0.885057_g30292_i0 | PRJNA485080 | 30386 | 247 | 0.885057 | 2.18609079 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 43.5 | 0.0216 | NR | MBR6588306.1 | 2212473 | g30292 | i0 | 35.1 | 0.692307692307692 | 57 | 34 | 65.6 | 1 | 174 | 13 | 527 | 583 | MBR6588306.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 171 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28560745 | 28560745 | PRJNA485080_P_NODE_14347_length_298_cov_0.937778_g14253_i0 | PRJNA485080 | 14347 | 298 | 0.937778 | 2.79457844 | Lacunisphaera limnophila | 1838286 | Bacteria | Bacteria | 46.6 | 7.41e-4 | NR | WP_069962458.1 | 1838286 | g14253 | i0 | 39.3 | 0.563758389261745 | 56 | 33 | 55.4 | 1 | 248 | 84 | 49 | 104 | WP_069962458.1 gamma-glutamylcyclotransferase family protein [Lacunisphaera limnophila] | diamond | 168 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera limnophila | |
| 29760283 | 29760283 | PRJNA485080_P_NODE_36711_length_244_cov_0.900585_g36617_i0 | PRJNA485080 | 36711 | 244 | 0.900585 | 2.1974274 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 42.7 | 0.0397 | NR | MBF0384853.1 | 2035772 | g36617 | i0 | 34.2 | 0.897540983606557 | 73 | 39 | 86.1 | 2 | 7 | 216 | 1662 | 1728 | MBF0384853.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 219 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29839640 | 29839640 | PRJNA485080_P_NODE_23751_length_250_cov_0.870056_g23657_i0 | PRJNA485080 | 23751 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 114 | 7.449999999999998e-30 | NR | HVK15909.1 | 1914235 | g23657 | i0 | 71.4 | 3.336 | 70 | 20 | 84 | 0 | 211 | 2 | 3 | 72 | HVK15909.1 SAM-dependent chlorinase/fluorinase [Fimbriiglobus sp.] | diamond | 834 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Fimbriiglobus | Fimbriiglobus sp. | |
| 29949969 | 29949969 | PRJNA485080_P_NODE_26771_length_249_cov_0.875000_g26677_i0 | PRJNA485080 | 26771 | 249 | 0.875 | 2.17875 | uncultured Rubinisphaera sp. | 1678686 | Bacteria | Bacteria | 45.4 | 0.00349 | NR | WP_339743927.1 | 1678686 | g26677 | i0 | 46 | 1.19277108433735 | 50 | 24 | 60.2 | 1 | 213 | 64 | 4 | 50 | WP_339743927.1 immunity 26/phosphotriesterase HocA family protein [uncultured Rubinisphaera sp.] | diamond | 297 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Rubinisphaera | uncultured Rubinisphaera sp. | |
| 30361135 | 30361135 | PRJNA485080_P_NODE_29392_length_248_cov_0.880000_g29298_i0 | PRJNA485080 | 29392 | 248 | 0.88 | 2.1824 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 44.7 | 0.00812 | NR | MBL8726187.1 | 2026780 | g29298 | i0 | 38 | 0.604838709677419 | 50 | 30 | 60.5 | 1 | 23 | 172 | 285 | 333 | MBL8726187.1 hypothetical protein [Planctomycetota bacterium] | diamond | 150 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30897925 | 30897925 | PRJNA485080_P_NODE_33954_length_245_cov_1.343023_g33860_i0 | PRJNA485080 | 33954 | 245 | 1.343023 | 3.29040635 | Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_ | 2035772 | Bacteria | Bacteria | 42.4 | 0.0448 | NR | PIQ88852.1 | 1974746 | g33860 | i0 | 37.5 | 0.391836734693878 | 32 | 20 | 39.2 | 0 | 131 | 226 | 88 | 119 | PIQ88852.1 MAG: hypothetical protein COV72_06135 [Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_42_13] | diamond | 96 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Ghiorseimicrobium | Candidatus Ghiorseimicrobium undicola | ||||
| 30992657 | 30992657 | PRJNA485080_P_NODE_37134_length_244_cov_0.900585_g37040_i0 | PRJNA485080 | 37134 | 244 | 0.900585 | 2.1974274 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 41.2 | 0.0427 | NR | HCD32792.1 | 2052180 | g37040 | i0 | 53.3 | 0.368852459016393 | 30 | 14 | 36.9 | 0 | 216 | 127 | 21 | 50 | HCD32792.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 90 | 41.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 31340254 | 31340254 | PRJNA485080_P_NODE_25476_length_250_cov_0.864407_g25382_i0 | PRJNA485080 | 25476 | 250 | 0.864407 | 2.1610175 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 133 | 4.639999999999999e-34 | NR | MEN9636027.1 | 2026799 | g25382 | i0 | 75.6 | 0.984 | 82 | 20 | 98.4 | 0 | 248 | 3 | 675 | 756 | MEN9636027.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 246 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31340258 | 31340258 | PRJNA485080_P_NODE_39776_length_243_cov_0.905882_g39682_i0 | PRJNA485080 | 39776 | 243 | 0.905882 | 2.20129326 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 43.1 | 0.0266 | NR | MEM9410775.1 | 2026780 | g39682 | i0 | 37.7 | 0.753086419753086 | 61 | 38 | 75.3 | 0 | 188 | 6 | 122 | 182 | MEM9410775.1 STY4199 family HEPN domain-containing protein [Planctomycetota bacterium] | diamond | 183 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31751343 | 31751343 | PRJNA485080_P_NODE_36337_length_244_cov_0.900585_g36243_i0 | PRJNA485080 | 36337 | 244 | 0.900585 | 2.1974274 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 42.7 | 0.0371 | NR | HLP09157.1 | 2006848 | g36243 | i0 | 31.3 | 0.786885245901639 | 64 | 44 | 78.7 | 0 | 233 | 42 | 43 | 106 | HLP09157.1 ABC transporter permease [Opitutaceae bacterium] | diamond | 192 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31846234 | 31846234 | PRJNA485080_P_NODE_34837_length_245_cov_0.895349_g34743_i0 | PRJNA485080 | 34837 | 245 | 0.895349 | 2.19360505 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 42.4 | 0.0493 | NR | MDP6361313.1 | 2026780 | g34743 | i0 | 33.9 | 0.759183673469388 | 62 | 35 | 74.7 | 2 | 37 | 219 | 83 | 139 | MDP6361313.1 DUF6259 domain-containing protein [Planctomycetota bacterium] | diamond | 186 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32321272 | 32321272 | PRJNA485080_P_NODE_36039_length_244_cov_0.947368_g35945_i0 | PRJNA485080 | 36039 | 244 | 0.947368 | 2.31157792 | Chlamydia trachomatis | 813 | Bacteria | Bacteria | 70.5 | 7.54e-14 | NR | CRH27399.1 | 813 | g35945 | i0 | 65.5 | 0.676229508196721 | 55 | 19 | 67.6 | 0 | 61 | 225 | 25 | 79 | CRH27399.1 Uncharacterised protein [Chlamydia trachomatis] | diamond | 165 | 70.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia trachomatis |
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);;