contig_metadata
17 rows where bioproject = "PRJNA767802" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16047753 | 16047753 | PRJNA767802_P_NODE_16013_length_167_cov_0.864407_g15940_i0 | PRJNA767802 | 16013 | 167 | 0.864407 | 1.44355969 | Pirellulimonas | 2795783 | Bacteria | Bacteria | 101 | 3.23e-23 | NR | MEN1680226.1 | 2026780 | g15940 | i0 | 87.3 | 2.96407185628743 | 55 | 7 | 98.8 | 0 | 1 | 165 | 521 | 575 | MEN1680226.1 CRISPR-associated helicase Cas3' [Planctomycetota bacterium] | diamond | 495 | 102 | 0.990196078431373 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 23698152 | 23698152 | PRJNA767802_P_NODE_3919_length_437_cov_1.311856_g3846_i0 | PRJNA767802 | 3919 | 437 | 1.311856 | 5.73281072 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 276 | 7.88e-89 | NR | MBC7856119.1 | 2699754 | g3846 | i0 | 98.6 | 0.995423340961098 | 145 | 2 | 99.5 | 0 | 437 | 3 | 162 | 306 | MBC7856119.1 sigma-54-dependent Fis family transcriptional regulator [Pirellulaceae bacterium] | diamond | 435 | 276 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 26831762 | 26831762 | PRJNA767802_P_NODE_10241_length_223_cov_1.568966_g10168_i0 | PRJNA767802 | 10241 | 223 | 1.568966 | 3.49879418 | Victivallales bacterium | 2212475 | Bacteria | Bacteria | 41.2 | 0.0326 | NR | MDD3118912.1 | 2212475 | g10168 | i0 | 38 | 0.672645739910314 | 50 | 31 | 67.3 | 0 | 181 | 32 | 35 | 84 | MDD3118912.1 hypothetical protein [Victivallales bacterium] | diamond | 150 | 41.2 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallales bacterium | |||
| 26926677 | 26926677 | PRJNA767802_P_NODE_18482_length_162_cov_0.902655_g18409_i0 | PRJNA767802 | 18482 | 162 | 0.902655 | 1.4623011 | Botrimarina mediterranea | 2528022 | Bacteria | Bacteria | 77 | 8.32e-15 | NR | WP_145116791.1 | 2528022 | g18409 | i0 | 72.2 | 1 | 54 | 13 | 100 | 1 | 1 | 162 | 289 | 340 | WP_145116791.1 DUF1559 domain-containing protein [Botrimarina mediterranea] | diamond | 162 | 77 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Lacipirellulaceae | Botrimarina | Botrimarina mediterranea | |
| 27337804 | 27337804 | PRJNA767802_P_NODE_5763_length_334_cov_3.031579_g5690_i0 | PRJNA767802 | 5763 | 334 | 3.031579 | 10.12547386 | Candidatus Rhabdochlamydia sp. | 2320511 | Bacteria | Bacteria | 80.1 | 8.24e-15 | NR | MFI0477770.1 | 2320511 | g5690 | i0 | 54.1 | 0.664670658682635 | 74 | 34 | 66.5 | 0 | 78 | 299 | 25 | 98 | MFI0477770.1 beta strand repeat-containing protein [Candidatus Rhabdochlamydia sp.] | diamond | 222 | 80.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Candidatus Rhabdochlamydia | Candidatus Rhabdochlamydia sp. | |
| 27432703 | 27432703 | PRJNA767802_P_NODE_11163_length_211_cov_1.574074_g11090_i0 | PRJNA767802 | 11163 | 211 | 1.574074 | 3.32129614 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 131 | 2e-34 | NR | MBC7856119.1 | 2699754 | g11090 | i0 | 94.2 | 0.981042654028436 | 69 | 4 | 98.1 | 0 | 3 | 209 | 310 | 378 | MBC7856119.1 sigma-54-dependent Fis family transcriptional regulator [Pirellulaceae bacterium] | diamond | 207 | 131 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 27811566 | 27811566 | PRJNA767802_P_NODE_4204_length_416_cov_1.915531_g4131_i0 | PRJNA767802 | 4204 | 416 | 1.915531 | 7.96860896 | Fimbriiglobus ruber | 1908690 | Bacteria | Bacteria | 127 | 9.47e-33 | NR | WP_161967608.1 | 1908690 | g4131 | i0 | 49.6 | 0.987980769230769 | 137 | 64 | 95.2 | 2 | 5 | 400 | 45 | 181 | WP_161967608.1 c-type cytochrome [Fimbriiglobus ruber] | diamond | 411 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Fimbriiglobus | Fimbriiglobus ruber | |
| 29927013 | 29927013 | PRJNA767802_P_NODE_5991_length_326_cov_1.472924_g5918_i0 | PRJNA767802 | 5991 | 326 | 1.472924 | 4.80173224 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 96.3 | 1.66e-20 | NR | MFM2169900.1 | 2026799 | g5918 | i0 | 60 | 0.920245398773006 | 100 | 40 | 92 | 0 | 19 | 318 | 493 | 592 | MFM2169900.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 300 | 96.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30495697 | 30495697 | PRJNA767802_P_NODE_1773_length_687_cov_1.719436_g1715_i0 | PRJNA767802 | 1773 | 687 | 1.719436 | 11.81252532 | Pirellulales bacterium | 2715253 | Bacteria | Bacteria | 268 | 3.059999999999999e-87 | NR | MFO0903704.1 | 2715253 | g1715 | i0 | 92 | 0.59825327510917 | 137 | 11 | 59.8 | 0 | 411 | 1 | 1 | 137 | MFO0903704.1 glycosyltransferase [Pirellulales bacterium] | diamond | 411 | 268 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulales bacterium | |||
| 30938052 | 30938052 | PRJNA767802_P_NODE_8054_length_265_cov_1.879630_g7981_i0 | PRJNA767802 | 8054 | 265 | 1.87963 | 4.9810195 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 172 | 1.29e-49 | NR | MBC7856119.1 | 2699754 | g7981 | i0 | 97.7 | 0.984905660377358 | 87 | 2 | 98.5 | 0 | 263 | 3 | 63 | 149 | MBC7856119.1 sigma-54-dependent Fis family transcriptional regulator [Pirellulaceae bacterium] | diamond | 261 | 172 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 31759928 | 31759928 | PRJNA767802_P_NODE_2137_length_620_cov_8.173380_g2074_i0 | PRJNA767802 | 2137 | 620 | 8.17338 | 50.674956 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 148 | 2.87e-39 | NR | HEY5235189.1 | 2047756 | g2074 | i0 | 48.7 | 0.745161290322581 | 154 | 76 | 73.5 | 2 | 25 | 480 | 30 | 182 | HEY5235189.1 nucleotidyltransferase domain-containing protein [Rhabdochlamydiaceae bacterium] | diamond | 462 | 148 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 32171465 | 32171465 | PRJNA767802_P_NODE_4538_length_396_cov_2.239193_g4465_i0 | PRJNA767802 | 4538 | 396 | 2.239193 | 8.86720428 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 148 | 2.31e-41 | NR | MEQ1851759.1 | 2811408 | g4465 | i0 | 89.6 | 0.583333333333333 | 77 | 8 | 58.3 | 0 | 395 | 165 | 205 | 281 | MEQ1851759.1 AraC family transcriptional regulator [Chthoniobacteraceae bacterium] | diamond | 231 | 148 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 32181007 | 32181007 | PRJNA767802_P_NODE_2538_length_565_cov_3.294574_g2470_i0 | PRJNA767802 | 2538 | 565 | 3.294574 | 18.6143431 | root | 1 | Root_unresolved | Root_unresolved | 82 | 1.85e-14 | NR | MCK4859262.1 | 2035772 | g2470 | i0 | 31.6 | 1.59823008849558 | 158 | 104 | 82.8 | 4 | 565 | 98 | 160 | 315 | MCK4859262.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 903 | 82.4 | 0.995145631067961 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32266443 | 32266443 | PRJNA767802_P_NODE_10038_length_226_cov_1.389831_g9965_i0 | PRJNA767802 | 10038 | 226 | 1.389831 | 3.14101806 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 132 | 6.42e-34 | NR | MFN0018561.1 | 2699754 | g9965 | i0 | 91.8 | 0.969026548672566 | 73 | 6 | 96.9 | 0 | 7 | 225 | 31 | 103 | MFN0018561.1 tetratricopeptide repeat protein [Pirellulaceae bacterium] | diamond | 219 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 32812441 | 32812441 | PRJNA767802_P_NODE_4460_length_400_cov_4.339031_g4387_i0 | PRJNA767802 | 4460 | 400 | 4.339031 | 17.356124 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.5 | 2.22e-6 | NR | MBN1442838.1 | 2026780 | g4387 | i0 | 43.6 | 2.31 | 101 | 53 | 75.8 | 1 | 1 | 303 | 63 | 159 | MBN1442838.1 hypothetical protein [Planctomycetota bacterium] | diamond | 924 | 55.8 | 0.99462365591397806 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32865851 | 32865851 | PRJNA767802_P_NODE_3400_length_479_cov_9.641860_g3328_i0 | PRJNA767802 | 3400 | 479 | 9.64186 | 46.1845094 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 97.1 | 5.69e-20 | NR | MDB4663394.1 | 2026799 | g3328 | i0 | 59.7 | 0.482254697286013 | 77 | 28 | 48.2 | 1 | 252 | 22 | 35 | 108 | MDB4663394.1 phage tail protein [Verrucomicrobiota bacterium] | diamond | 231 | 97.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32906857 | 32906857 | PRJNA767802_P_NODE_3600_length_459_cov_2.475610_g3527_i0 | PRJNA767802 | 3600 | 459 | 2.47561 | 11.3630499 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 64.3 | 2.94e-10 | NR | MCW8132934.1 | 2026780 | g3527 | i0 | 47 | 2.20915032679739 | 66 | 33 | 43.1 | 1 | 253 | 56 | 23 | 86 | MCW8132934.1 SWIB/MDM2 domain-containing protein [Planctomycetota bacterium] | diamond | 1014 | 64.7 | 0.993817619783617 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota 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);;