contig_metadata
26 rows where bioproject = "PRJNA1186363" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 319684 | 319684 | PRJNA1186363_P_NODE_10081_length_653_cov_1.068966_g9204_i0 | PRJNA1186363 | 10081 | 653 | 1.068966 | 6.98034798 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 58.4 | 0.001 | NTclustered | gi|1958061316|gb|CP064987.1| | 2052180 | g9204 | i0 | 100 | 0.973966309341501 | 31 | 0 | 5 | 0 | 351 | 381 | 1928298 | 1928268 | Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome | blastn | 636 | 58.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 319863 | 319863 | PRJNA1186363_P_NODE_3561_length_1099_cov_3.621832_g3038_i0 | PRJNA1186363 | 3561 | 1099 | 3.621832 | 39.80393368 | Stieleria neptunia | 2527979 | Bacteria | Bacteria | 56.5 | 0.009 | NTclustered | gi|1712721777|gb|CP037423.1| | 2527979 | g3038 | i0 | 100 | 0.0272975432211101 | 30 | 0 | 3 | 0 | 719 | 748 | 10851789 | 10851760 | Stieleria neptunia strain Enr13 chromosome | blastn | 30 | 56.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Stieleria | Stieleria neptunia | |
| 7973130 | 7973130 | PRJNA1186363_P_NODE_7547_length_768_cov_2.722302_g6740_i0 | PRJNA1186363 | 7547 | 768 | 2.722302 | 20.90727936 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 234 | 3.3899999999999997e-69 | NR | HSX03888.1 | 2047756 | g6740 | i0 | 54 | 0.83984375 | 215 | 93 | 82.4 | 4 | 766 | 134 | 141 | 353 | HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 645 | 234 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 9247749 | 9247749 | PRJNA1186363_P_NODE_43928_length_242_cov_0.923077_g43040_i0 | PRJNA1186363 | 43928 | 242 | 0.923077 | 2.23384634 | uncultured Planctomycetaceae bacterium | 100233 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2874253757|emb|OY969698.1| | 100233 | g43040 | i0 | 100 | 0.582644628099174 | 29 | 0 | 12 | 0 | 202 | 230 | 2534415 | 2534443 | MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1 | blastn | 141 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | uncultured Planctomycetaceae bacterium | ||
| 16896867 | 16896867 | PRJNA1186363_P_NODE_26434_length_349_cov_1.130435_g25546_i0 | PRJNA1186363 | 26434 | 349 | 1.130435 | 3.94521815 | Bacteria | 2 | Bacteria | Bacteria | 106 | 2.22e-24 | NR | MBY0230280.1 | 2052164 | g25546 | i0 | 48.3 | 2.810888252149 | 116 | 59 | 99.7 | 1 | 348 | 1 | 274 | 388 | MBY0230280.1 serpin family protein [Gemmataceae bacterium] | diamond | 981 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 23271833 | 23271833 | PRJNA1186363_P_NODE_17499_length_462_cov_2.406170_g16612_i0 | PRJNA1186363 | 17499 | 462 | 2.40617 | 11.1165054 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 122 | 6.17e-29 | NR | HSX03888.1 | 2047756 | g16612 | i0 | 46 | 0.818181818181818 | 126 | 58 | 76.6 | 3 | 367 | 14 | 29 | 152 | HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 378 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 26882627 | 26882627 | PRJNA1186363_P_NODE_31921_length_300_cov_1.713656_g31033_i0 | PRJNA1186363 | 31921 | 300 | 1.713656 | 5.140968 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 63.9 | 2.61e-9 | NR | HMP82275.1 | 2026799 | g31033 | i0 | 62.5 | 0.97 | 48 | 18 | 48 | 0 | 299 | 156 | 216 | 263 | HMP82275.1 kelch repeat-containing protein [Verrucomicrobiota bacterium] | diamond | 291 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26882635 | 26882635 | PRJNA1186363_P_NODE_38141_length_253_cov_1.733333_g37253_i0 | PRJNA1186363 | 38141 | 253 | 1.733333 | 4.38533249 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 63.9 | 7.26e-10 | NR | HOD12385.1 | 2035772 | g37253 | i0 | 46.7 | 0.711462450592885 | 60 | 26 | 64 | 1 | 166 | 5 | 44 | 103 | HOD12385.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 180 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27660198 | 27660198 | PRJNA1186363_P_NODE_18064_length_453_cov_1.350000_g17176_i0 | PRJNA1186363 | 18064 | 453 | 1.35 | 6.1155 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 130 | 5.57e-34 | NR | MEI7865572.1 | 2201154 | g17176 | i0 | 50 | 6.17218543046358 | 126 | 56 | 82.8 | 4 | 64 | 438 | 54 | 173 | MEI7865572.1 polysaccharide deacetylase family protein [Chthoniobacterales bacterium] | diamond | 2796 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 28304041 | 28304041 | PRJNA1186363_P_NODE_44086_length_227_cov_3.551948_g43198_i0 | PRJNA1186363 | 44086 | 227 | 3.551948 | 8.06292196 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 61.2 | 9.1e-9 | NR | MBR7138026.1 | 2053569 | g43198 | i0 | 64.3 | 0.555066079295154 | 42 | 15 | 55.5 | 0 | 225 | 100 | 317 | 358 | MBR7138026.1 toll/interleukin-1 receptor domain-containing protein [Lentisphaeria bacterium] | diamond | 126 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 28366987 | 28366987 | PRJNA1186363_P_NODE_14126_length_532_cov_1.592593_g13242_i0 | PRJNA1186363 | 14126 | 532 | 1.592593 | 8.47259476 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 127 | 9.3e-32 | NR | MBP7975267.1 | 2026799 | g13242 | i0 | 60.8 | 1.15601503759399 | 97 | 37 | 54.7 | 1 | 1 | 291 | 53 | 148 | MBP7975267.1 glycerophosphodiester phosphodiesterase [Verrucomicrobiota bacterium] | diamond | 615 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28366988 | 28366988 | PRJNA1186363_P_NODE_14326_length_527_cov_2.121145_g13442_i0 | PRJNA1186363 | 14326 | 527 | 2.121145 | 11.17843415 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 198 | 1.0499999999999998e-56 | NR | HSX03888.1 | 2047756 | g13442 | i0 | 54.9 | 0.870967741935484 | 153 | 69 | 87.1 | 0 | 527 | 69 | 467 | 619 | HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 459 | 198 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 29175784 | 29175784 | PRJNA1186363_P_NODE_42229_length_245_cov_0.906977_g41341_i0 | PRJNA1186363 | 42229 | 245 | 0.906977 | 2.22209365 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42.7 | 0.032 | NR | MCX6977575.1 | 2026799 | g41341 | i0 | 29.2 | 3.51428571428571 | 72 | 50 | 86.9 | 1 | 233 | 21 | 124 | 195 | MCX6977575.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 861 | 43.1 | 0.990719257540603 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29251045 | 29251045 | PRJNA1186363_P_NODE_22389_length_393_cov_0.878125_g21501_i0 | PRJNA1186363 | 22389 | 393 | 0.878125 | 3.45103125 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 65.5 | 4.04e-10 | NR | HIB69548.1 | 2052180 | g21501 | i0 | 51.9 | 0.412213740458015 | 54 | 26 | 41.2 | 0 | 1 | 162 | 8 | 61 | HIB69548.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 162 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 29503666 | 29503666 | PRJNA1186363_P_NODE_13910_length_537_cov_2.043103_g13026_i0 | PRJNA1186363 | 13910 | 537 | 2.043103 | 10.97146311 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 133 | 1.47e-32 | NR | HSX03888.1 | 2047756 | g13026 | i0 | 50.5 | 0.620111731843575 | 111 | 55 | 62 | 0 | 3 | 335 | 509 | 619 | HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 333 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 29648810 | 29648810 | PRJNA1186363_P_NODE_38470_length_253_cov_0.866667_g37582_i0 | PRJNA1186363 | 38470 | 253 | 0.866667 | 2.19266751 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.1 | 0.0291 | NR | MBI3877432.1 | 2026799 | g37582 | i0 | 29.9 | 1.81422924901186 | 77 | 52 | 88.9 | 2 | 13 | 237 | 74 | 150 | MBI3877432.1 redoxin domain-containing protein [Verrucomicrobiota bacterium] | diamond | 459 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29787864 | 29787864 | PRJNA1186363_P_NODE_43291_length_243_cov_0.917647_g42403_i0 | PRJNA1186363 | 43291 | 243 | 0.917647 | 2.22988221 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 44.3 | 0.0106 | NR | MFP4069785.1 | 2026772 | g42403 | i0 | 33.3 | 0.703703703703704 | 57 | 31 | 70.4 | 1 | 17 | 187 | 481 | 530 | MFP4069785.1 alpha/beta fold hydrolase [Opitutales bacterium] | diamond | 171 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 30122847 | 30122847 | PRJNA1186363_P_NODE_42452_length_245_cov_0.906977_g41564_i0 | PRJNA1186363 | 42452 | 245 | 0.906977 | 2.22209365 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 52.4 | 1.52e-5 | NR | HKB05582.1 | 2052164 | g41564 | i0 | 44.3 | 3.55102040816327 | 70 | 35 | 83.3 | 3 | 209 | 6 | 93 | 160 | HKB05582.1 hypothetical protein [Gemmataceae bacterium] | diamond | 870 | 52.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 30135169 | 30135169 | PRJNA1186363_P_NODE_41212_length_247_cov_1.321839_g40324_i0 | PRJNA1186363 | 41212 | 247 | 1.321839 | 3.26494233 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 44.7 | 0.00856 | NR | MFI5343916.1 | 2047757 | g40324 | i0 | 45.5 | 0.668016194331984 | 55 | 28 | 66.8 | 1 | 83 | 247 | 1677 | 1729 | MFI5343916.1 DUF3638 domain-containing protein [Chlamydiales bacterium] | diamond | 165 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 30154310 | 30154310 | PRJNA1186363_P_NODE_43312_length_243_cov_0.917647_g42424_i0 | PRJNA1186363 | 43312 | 243 | 0.917647 | 2.22988221 | Bacteria | 2 | Bacteria | Bacteria | 129 | 2.27e-33 | NR | KPL25334.1 | 1703410 | g42424 | i0 | 75.3 | 16 | 81 | 20 | 100 | 0 | 1 | 243 | 285 | 365 | KPL25334.1 MAG: 6-phosphogluconate dehydrogenase [Phycisphaerae bacterium SM1_79] | diamond | 3888 | 130 | 0.992307692307692 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium SM1_79 | ||||
| 30546247 | 30546247 | PRJNA1186363_P_NODE_38613_length_253_cov_0.866667_g37725_i0 | PRJNA1186363 | 38613 | 253 | 0.866667 | 2.19266751 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 55.5 | 1.38e-6 | NR | MFP6764498.1 | 2026779 | g37725 | i0 | 44.7 | 0.901185770750988 | 76 | 35 | 88.9 | 2 | 9 | 233 | 189 | 258 | MFP6764498.1 Calx-beta domain-containing protein [Planctomycetaceae bacterium] | diamond | 228 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 30830492 | 30830492 | PRJNA1186363_P_NODE_17294_length_466_cov_1.353690_g16407_i0 | PRJNA1186363 | 17294 | 466 | 1.35369 | 6.3081954 | Candidatus Scalindua sp. | 2268189 | Bacteria | Bacteria | 69.7 | 8.23e-11 | NR | MBT3880675.1 | 2268189 | g16407 | i0 | 53.7 | 0.347639484978541 | 54 | 25 | 34.8 | 0 | 2 | 163 | 241 | 294 | MBT3880675.1 dihydrodipicolinate synthase family protein [Candidatus Scalindua sp.] | diamond | 162 | 69.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiales | Candidatus Scalinduaceae | Candidatus Scalindua | Candidatus Scalindua sp. | |
| 31052058 | 31052058 | PRJNA1186363_P_NODE_41055_length_248_cov_0.891429_g40167_i0 | PRJNA1186363 | 41055 | 248 | 0.891429 | 2.21074392 | Phycisphaeraceae bacterium | 2026777 | Bacteria | Bacteria | 150 | 5.93e-43 | NR | MCC6581972.1 | 2026777 | g40167 | i0 | 81.7 | 0.991935483870968 | 82 | 15 | 99.2 | 0 | 2 | 247 | 149 | 230 | MCC6581972.1 hypothetical protein [Phycisphaeraceae bacterium] | diamond | 246 | 150 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaeraceae | Phycisphaeraceae bacterium | ||
| 31431070 | 31431070 | PRJNA1186363_P_NODE_24516_length_369_cov_1.054054_g23628_i0 | PRJNA1186363 | 24516 | 369 | 1.054054 | 3.88945926 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 45.1 | 0.0248 | NR | MCH8967560.1 | 2026780 | g23628 | i0 | 40.5 | 1.61788617886179 | 79 | 36 | 56.1 | 5 | 4 | 210 | 642 | 719 | MCH8967560.1 FG-GAP repeat protein [Planctomycetota bacterium] | diamond | 597 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32348816 | 32348816 | PRJNA1186363_P_NODE_28979_length_325_cov_1.912698_g28091_i0 | PRJNA1186363 | 28979 | 325 | 1.912698 | 6.2162685 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 55.1 | 1.03e-6 | NR | MEY4774332.1 | 2026780 | g28091 | i0 | 34.4 | 0.886153846153846 | 96 | 55 | 88.6 | 2 | 31 | 318 | 1 | 88 | MEY4774332.1 hypothetical protein [Planctomycetota bacterium] | diamond | 288 | 55.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32727574 | 32727574 | PRJNA1186363_P_NODE_40840_length_248_cov_0.891429_g39952_i0 | PRJNA1186363 | 40840 | 248 | 0.891429 | 2.21074392 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 49.7 | 5.52e-5 | NR | MCQ2393371.1 | 2212473 | g39952 | i0 | 87.5 | 0.290322580645161 | 24 | 3 | 29 | 0 | 3 | 74 | 135 | 158 | MCQ2393371.1 nucleoside deaminase [Kiritimatiellia bacterium] | diamond | 72 | 49.7 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia 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);;