contig_metadata
19 rows where bioproject = "PRJNA1093380", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2749917 | 2749917 | PRJNA1093380_P_NODE_6423_length_283_cov_1.100000_g6317_i0 | PRJNA1093380 | 6423 | 283 | 1.1 | 3.113 | Urbifossiella limnaea | 2528023 | Bacteria | Bacteria | 276 | 1.4199999999999999e-69 | NTclustered | gi|1712585314|gb|CP036273.1| | 2528023 | g6317 | i0 | 87.045 | 78.3003533568905 | 247 | 28 | 87 | 4 | 1 | 245 | 2018907 | 2019151 | Urbifossiella limnaea strain ETA_A1 chromosome, complete genome | blastn | 22159 | 276 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Urbifossiella | Urbifossiella limnaea | |
| 5302102 | 5302102 | PRJNA1093380_P_NODE_925_length_575_cov_1.735060_g822_i0 | PRJNA1093380 | 925 | 575 | 1.73506 | 9.976595 | uncultured Planctomycetota bacterium | 120965 | Bacteria | Bacteria | 830 | 0 | NTclustered | gi|2874254043|emb|OY970367.1| | 120965 | g822 | i0 | 92.696 | 207.737391304348 | 575 | 42 | 100 | 0 | 1 | 575 | 3454218 | 3453644 | MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1 | blastn | 119449 | 830 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | uncultured Planctomycetota bacterium | |||||
| 7851856 | 7851856 | PRJNA1093380_P_NODE_1727_length_428_cov_1.636620_g1621_i0 | PRJNA1093380 | 1727 | 428 | 1.63662 | 7.0047336 | uncultured Planctomycetota bacterium | 120965 | Bacteria | Bacteria | 791 | 0 | NTclustered | gi|55975911|gb|AY802942.1| | 120965 | g1621 | i0 | 100 | 99.6144859813084 | 428 | 0 | 100 | 0 | 1 | 428 | 76 | 503 | Uncultured planctomycete clone FPln-22 16S ribosomal RNA gene, partial sequence | blastn | 42635 | 791 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | uncultured Planctomycetota bacterium | |||||
| 9126822 | 9126822 | PRJNA1093380_P_NODE_2388_length_375_cov_3.728477_g2282_i0 | PRJNA1093380 | 2388 | 375 | 3.728477 | 13.98178875 | uncultured Planctomycetota bacterium | 120965 | Bacteria | Bacteria | 649 | 0 | NTclustered | gi|2874254043|emb|OY970367.1| | 120965 | g2282 | i0 | 97.878 | 158.173333333333 | 377 | 4 | 100 | 4 | 1 | 375 | 3454589 | 3454215 | MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1 | blastn | 59315 | 649 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | uncultured Planctomycetota bacterium | |||||
| 14227838 | 14227838 | PRJNA1093380_P_NODE_16752_length_241_cov_1.833333_g16646_i0 | PRJNA1093380 | 16752 | 241 | 1.833333 | 4.41833253 | uncultured Phycisphaerales bacterium | 904075 | Bacteria | Bacteria | 307 | 4.1900000000000005e-79 | NTclustered | gi|2874253847|emb|OY969903.1| | 904075 | g16646 | i0 | 90 | 6.51452282157676 | 250 | 7 | 100 | 13 | 1 | 241 | 1830896 | 1830656 | MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 | blastn | 1570 | 307 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | uncultured Phycisphaerales bacterium | |||
| 14227870 | 14227870 | PRJNA1093380_P_NODE_2692_length_360_cov_3.027875_g2586_i0 | PRJNA1093380 | 2692 | 360 | 3.027875 | 10.90035 | Anatilimnocola aggregata | 2528021 | Bacteria | Bacteria | 593 | 4.519999999999998e-165 | NTclustered | gi|1712591889|gb|CP036274.1| | 2528021 | g2586 | i0 | 96.893 | 116.333333333333 | 354 | 11 | 98 | 0 | 1 | 354 | 7628522 | 7628875 | Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome | blastn | 41880 | 593 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Anatilimnocola | Anatilimnocola aggregata | |
| 16776248 | 16776248 | PRJNA1093380_P_NODE_2014_length_402_cov_2.577508_g1908_i0 | PRJNA1093380 | 2014 | 402 | 2.577508 | 10.36158216 | uncultured Planctomycetota bacterium | 120965 | Bacteria | Bacteria | 616 | 1.0899999999999995e-171 | NTclustered | gi|2874254043|emb|OY970367.1| | 120965 | g1908 | i0 | 94.71 | 476.310945273632 | 397 | 19 | 99 | 2 | 1 | 396 | 3454578 | 3454973 | MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1 | blastn | 191477 | 616 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | uncultured Planctomycetota bacterium | |||||
| 20600198 | 20600198 | PRJNA1093380_P_NODE_2037_length_400_cov_1.853211_g1931_i0 | PRJNA1093380 | 2037 | 400 | 1.853211 | 7.412844 | Urbifossiella limnaea | 2528023 | Bacteria | Bacteria | 575 | 1.8399999999999994e-159 | NTclustered | gi|1712585314|gb|CP036273.1| | 2528023 | g1931 | i0 | 92.556 | 128.4825 | 403 | 26 | 100 | 4 | 1 | 400 | 2019829 | 2019428 | Urbifossiella limnaea strain ETA_A1 chromosome, complete genome | blastn | 51393 | 575 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Urbifossiella | Urbifossiella limnaea | |
| 20600212 | 20600212 | PRJNA1093380_P_NODE_3117_length_343_cov_1.140741_g3011_i0 | PRJNA1093380 | 3117 | 343 | 1.140741 | 3.91274163 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 449 | 9.84e-122 | NTclustered | gi|2874253749|emb|OY969623.1| | 1914239 | g3011 | i0 | 90.23 | 158.00583090379 | 348 | 29 | 100 | 3 | 1 | 343 | 7050955 | 7050608 | MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 | blastn | 54196 | 449 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 23151322 | 23151322 | PRJNA1093380_P_NODE_10199_length_261_cov_1.079787_g10093_i0 | PRJNA1093380 | 10199 | 261 | 1.079787 | 2.81824407 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 359 | 1.25e-94 | NTclustered | gi|2874253853|emb|OY969909.1| | 1914239 | g10093 | i0 | 92.157 | 183.528735632184 | 255 | 18 | 97 | 2 | 8 | 261 | 2002781 | 2002528 | MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 | blastn | 47901 | 359 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 24425089 | 24425089 | PRJNA1093380_P_NODE_4440_length_304_cov_8.086580_g4334_i0 | PRJNA1093380 | 4440 | 304 | 8.08658 | 24.5832032 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 318 | 2.53e-82 | NTclustered | gi|2874253749|emb|OY969623.1| | 1914239 | g4334 | i0 | 87.868 | 145.118421052632 | 272 | 31 | 89 | 2 | 2 | 271 | 7053161 | 7053432 | MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 | blastn | 44116 | 318 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 24425131 | 24425131 | PRJNA1093380_P_NODE_7280_length_277_cov_1.544118_g7174_i0 | PRJNA1093380 | 7280 | 277 | 1.544118 | 4.27720686 | uncultured Phycisphaerales bacterium | 904075 | Bacteria | Bacteria | 222 | 1.84e-53 | NTclustered | gi|2874253847|emb|OY969903.1| | 904075 | g7174 | i0 | 82.182 | 12.8158844765343 | 275 | 33 | 99 | 7 | 1 | 275 | 1831181 | 1831439 | MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 | blastn | 3550 | 222 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | uncultured Phycisphaerales bacterium | |||
| 28299265 | 28299265 | PRJNA1093380_P_NODE_8286_length_272_cov_0.909548_g8180_i0 | PRJNA1093380 | 8286 | 272 | 0.909548 | 2.47397056 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 43.9 | 0.0187 | NR | MBN1809450.1 | 2026780 | g8180 | i0 | 42.6 | 0.672794117647059 | 61 | 28 | 61.8 | 3 | 36 | 203 | 52 | 110 | MBN1809450.1 helix-turn-helix transcriptional regulator [Planctomycetota bacterium] | diamond | 183 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29206553 | 29206553 | PRJNA1093380_P_NODE_17329_length_237_cov_3.475610_g17223_i0 | PRJNA1093380 | 17329 | 237 | 3.47561 | 8.2371957 | Singulisphaera | 466152 | Bacteria | Bacteria | 80.9 | 1.03e-15 | NR | WP_074317405.1 | 1882752 | g17223 | i0 | 56.4 | 4.93670886075949 | 78 | 34 | 98.7 | 0 | 236 | 3 | 40 | 117 | WP_074317405.1 3-dehydroquinate synthase [Singulisphaera sp. GP187] | diamond | 1170 | 81.3 | 0.995079950799508 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Singulisphaera | Singulisphaera sp. GP187 | |
| 29246481 | 29246481 | PRJNA1093380_P_NODE_12389_length_250_cov_0.870056_g12283_i0 | PRJNA1093380 | 12389 | 250 | 0.870056 | 2.17514 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 112 | 3.78e-27 | NR | HEX5272822.1 | 2052164 | g12283 | i0 | 69.5 | 0.984 | 82 | 24 | 98.4 | 1 | 3 | 248 | 176 | 256 | HEX5272822.1 DUF1501 domain-containing protein [Gemmataceae bacterium] | diamond | 246 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 29972803 | 29972803 | PRJNA1093380_P_NODE_16731_length_241_cov_2.333333_g16625_i0 | PRJNA1093380 | 16731 | 241 | 2.333333 | 5.62333253 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 80.9 | 9.87e-16 | NR | HZU34943.1 | 2052164 | g16625 | i0 | 51.3 | 0.995850622406639 | 80 | 39 | 99.6 | 0 | 1 | 240 | 218 | 297 | HZU34943.1 ATP-binding protein [Gemmataceae bacterium] | diamond | 240 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 30532845 | 30532845 | PRJNA1093380_P_NODE_5093_length_291_cov_1.068807_g4987_i0 | PRJNA1093380 | 5093 | 291 | 1.068807 | 3.11022837 | Bacteria | 2 | Bacteria | Bacteria | 43.5 | 0.0362 | NR | PHX78409.1 | 2026779 | g4987 | i0 | 64 | 1.03092783505155 | 25 | 9 | 25.8 | 0 | 88 | 162 | 547 | 571 | PHX78409.1 MAG: hypothetical protein CK544_02960 [Planctomycetaceae bacterium] | diamond | 300 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 31141470 | 31141470 | PRJNA1093380_P_NODE_11115_length_255_cov_2.285714_g11009_i0 | PRJNA1093380 | 11115 | 255 | 2.285714 | 5.8285707 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 60.5 | 2.57e-8 | NR | HVK07542.1 | 2052164 | g11009 | i0 | 68.8 | 1.88235294117647 | 48 | 14 | 55.3 | 1 | 141 | 1 | 2 | 49 | HVK07542.1 PVC-type heme-binding CxxCH protein [Gemmataceae bacterium] | diamond | 480 | 60.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 32785634 | 32785634 | PRJNA1093380_P_NODE_15340_length_244_cov_1.801170_g15234_i0 | PRJNA1093380 | 15340 | 244 | 1.80117 | 4.3948548 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 116 | 2.33e-28 | NR | MFL5327527.1 | 2052164 | g15234 | i0 | 68.8 | 1.95491803278689 | 80 | 25 | 98.4 | 0 | 242 | 3 | 383 | 462 | MFL5327527.1 aldehyde dehydrogenase family protein [Gemmataceae bacterium] | diamond | 477 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae 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);;