contig_metadata
19 rows where bioproject = "PRJNA656952" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 622398 | 622398 | PRJNA656952_P_NODE_35221_length_248_cov_0.880000_g35034_i0 | PRJNA656952 | 35221 | 248 | 0.88 | 2.1824 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 167 | 8.47e-46 | NR | HLO41002.1 | 2052180 | g35034 | i0 | 92.7 | 0.991935483870968 | 82 | 6 | 99.2 | 0 | 248 | 3 | 290 | 371 | HLO41002.1 PSD1 and planctomycete cytochrome C domain-containing protein [Phycisphaerales bacterium] | diamond | 246 | 167 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 1160010 | 1160010 | PRJNA656952_P_NODE_24761_length_279_cov_1.495146_g24574_i0 | PRJNA656952 | 24761 | 279 | 1.495146 | 4.17145734 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 121 | 9.829999999999999e-30 | NR | HTK74860.1 | 2052164 | g24574 | i0 | 64.4 | 0.967741935483871 | 90 | 32 | 96.8 | 0 | 277 | 8 | 336 | 425 | HTK74860.1 hypothetical protein [Gemmataceae bacterium] | diamond | 270 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 1898498 | 1898498 | PRJNA656952_P_NODE_30922_length_251_cov_1.488764_g30735_i0 | PRJNA656952 | 30922 | 251 | 1.488764 | 3.73679764 | Aquisphaera giovannonii | 406548 | Bacteria | Bacteria | 270 | 5.77e-68 | NTclustered | gi|1730068067|gb|CP042997.1| | 406548 | g30735 | i0 | 86.111 | 5.82470119521912 | 252 | 33 | 100 | 2 | 1 | 251 | 273092 | 272842 | Aquisphaera giovannonii strain OJF2 chromosome, complete genome | blastn | 1462 | 270 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Aquisphaera | Aquisphaera giovannonii | |
| 3711876 | 3711876 | PRJNA656952_P_NODE_31683_length_251_cov_0.865169_g31496_i0 | PRJNA656952 | 31683 | 251 | 0.865169 | 2.17157419 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 167 | 2.39e-50 | NR | HLO40943.1 | 2052180 | g31496 | i0 | 95.2 | 0.99203187250996006 | 83 | 4 | 99.2 | 0 | 250 | 2 | 41 | 123 | HLO40943.1 carboxyl transferase domain-containing protein [Phycisphaerales bacterium] | diamond | 249 | 167 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 4450043 | 4450043 | PRJNA656952_P_NODE_22864_length_288_cov_1.320930_g22677_i0 | PRJNA656952 | 22864 | 288 | 1.32093 | 3.8042784 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 337 | 6.57e-88 | NTclustered | gi|1958061316|gb|CP064987.1| | 2052180 | g22677 | i0 | 88.136 | 4.04513888888889 | 295 | 19 | 99 | 6 | 1 | 286 | 577547 | 577834 | Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome | blastn | 1165 | 337 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 10826628 | 10826628 | PRJNA656952_P_NODE_32489_length_250_cov_0.870056_g32302_i0 | PRJNA656952 | 32489 | 250 | 0.870056 | 2.17514 | Lacipirellula limnantheis | 2528024 | Bacteria | Bacteria | 307 | 4.3800000000000005e-79 | NTclustered | gi|1712529062|gb|CP036339.1| | 2528024 | g32302 | i0 | 89.627 | 0.964 | 241 | 25 | 96 | 0 | 10 | 250 | 5092434 | 5092674 | Lacipirellula limnantheis strain I41 chromosome | blastn | 241 | 307 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Lacipirellulaceae | Lacipirellula | Lacipirellula limnantheis | |
| 10826785 | 10826785 | PRJNA656952_P_NODE_39669_length_244_cov_0.900585_g39482_i0 | PRJNA656952 | 39669 | 244 | 0.900585 | 2.1974274 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 75 | 4.7e-9 | NTclustered | gi|2874253853|emb|OY969909.1| | 1914239 | g39482 | i0 | 83.544 | 0.733606557377049 | 79 | 13 | 32 | 0 | 143 | 221 | 4625057 | 4625135 | MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 | blastn | 179 | 75 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 17200455 | 17200455 | PRJNA656952_P_NODE_37494_length_246_cov_0.890173_g37307_i0 | PRJNA656952 | 37494 | 246 | 0.890173 | 2.18982558 | Lignipirellula cremea | 2528010 | Bacteria | Bacteria | 178 | 3.5099999999999993e-40 | NTclustered | gi|1712668320|gb|CP036433.1| | 2528010 | g37307 | i0 | 80.672 | 0.967479674796748 | 238 | 38 | 95 | 6 | 1 | 234 | 3224211 | 3223978 | Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome | blastn | 238 | 178 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Lignipirellula | Lignipirellula cremea | |
| 18474653 | 18474653 | PRJNA656952_P_NODE_32955_length_250_cov_0.870056_g32768_i0 | PRJNA656952 | 32955 | 250 | 0.870056 | 2.17514 | Tepidisphaeraceae bacterium | 2876886 | Bacteria | Bacteria | 388 | 1.5199999999999998e-103 | NTclustered | gi|2874253799|emb|OY969783.1| | 2876886 | g32768 | i0 | 96.97 | 282.532 | 231 | 7 | 92 | 0 | 1 | 231 | 2501336 | 2501106 | MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1 | blastn | 70633 | 388 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Tepidisphaerales | Tepidisphaeraceae | Tepidisphaeraceae bacterium | ||
| 18474702 | 18474702 | PRJNA656952_P_NODE_35115_length_248_cov_0.880000_g34928_i0 | PRJNA656952 | 35115 | 248 | 0.88 | 2.1824 | Gemmata massiliana | 1210884 | Bacteria | Bacteria | 132 | 1.6e-37 | NR | WP_162667600.1 | 1210884 | g34928 | i0 | 75.6 | 0.991935483870968 | 82 | 20 | 99.2 | 0 | 3 | 248 | 28 | 109 | WP_162667600.1 response regulator [Gemmata massiliana] | diamond | 246 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmata | Gemmata massiliana | |
| 26732774 | 26732774 | PRJNA656952_P_NODE_36301_length_247_cov_0.885057_g36114_i0 | PRJNA656952 | 36301 | 247 | 0.885057 | 2.18609079 | Humisphaera sp. | 2807514 | Bacteria | Bacteria | 78.2 | 3.09e-15 | NR | MEA2734762.1 | 2807514 | g36114 | i0 | 45.9 | 0.898785425101215 | 74 | 33 | 89.9 | 1 | 3 | 224 | 189 | 255 | MEA2734762.1 hypothetical protein [Humisphaera sp.] | diamond | 222 | 78.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Tepidisphaerales | Tepidisphaeraceae | Humisphaera | Humisphaera sp. | |
| 26796550 | 26796550 | PRJNA656952_P_NODE_31881_length_251_cov_0.865169_g31694_i0 | PRJNA656952 | 31881 | 251 | 0.865169 | 2.17157419 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 122 | 2.73e-32 | NR | GDX99692.1 | 2026778 | g31694 | i0 | 72.3 | 0.99203187250996006 | 83 | 23 | 99.2 | 0 | 250 | 2 | 35 | 117 | GDX99692.1 hypothetical protein LBMAG48_20960 [Phycisphaerae bacterium] | diamond | 249 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 27144118 | 27144118 | PRJNA656952_P_NODE_42642_length_242_cov_0.911243_g42455_i0 | PRJNA656952 | 42642 | 242 | 0.911243 | 2.20520806 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 103 | 9.53e-27 | NR | MDB5333575.1 | 2052180 | g42455 | i0 | 69.4 | 0.892561983471074 | 72 | 19 | 89.3 | 1 | 217 | 2 | 1 | 69 | MDB5333575.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 216 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 27744985 | 27744985 | PRJNA656952_P_NODE_32644_length_250_cov_0.870056_g32457_i0 | PRJNA656952 | 32644 | 250 | 0.870056 | 2.17514 | Pirellula sp. | 117 | Bacteria | Bacteria | 142 | 4.92e-37 | NR | MBA4106471.1 | 117 | g32457 | i0 | 96.3 | 0.984 | 82 | 3 | 98.4 | 0 | 248 | 3 | 460 | 541 | MBA4106471.1 hybrid sensor histidine kinase/response regulator [Pirellula sp.] | diamond | 246 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellula | Pirellula sp. | |
| 30649818 | 30649818 | PRJNA656952_P_NODE_26913_length_270_cov_0.903553_g26726_i0 | PRJNA656952 | 26913 | 270 | 0.903553 | 2.4395931 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 43.1 | 0.0378 | NR | MBJ76935.1 | 2026780 | g26726 | i0 | 41.5 | 0.588888888888889 | 53 | 31 | 58.9 | 0 | 111 | 269 | 659 | 711 | MBJ76935.1 hypothetical protein [Planctomycetota bacterium] | diamond | 159 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30681423 | 30681423 | PRJNA656952_P_NODE_39253_length_245_cov_0.895349_g39066_i0 | PRJNA656952 | 39253 | 245 | 0.895349 | 2.19360505 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 164 | 1.8999999999999998e-47 | NR | HLP85146.1 | 2052180 | g39066 | i0 | 95.1 | 0.991836734693878 | 81 | 4 | 99.2 | 0 | 3 | 245 | 103 | 183 | HLP85146.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 243 | 164 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 30744867 | 30744867 | PRJNA656952_P_NODE_37634_length_246_cov_0.890173_g37447_i0 | PRJNA656952 | 37634 | 246 | 0.890173 | 2.18982558 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 124 | 1.08e-31 | NR | MDX1967521.1 | 2026779 | g37447 | i0 | 98.5 | 2.48780487804878 | 68 | 1 | 82.9 | 0 | 245 | 42 | 330 | 397 | MDX1967521.1 phosphoglycerate kinase [Planctomycetaceae bacterium] | diamond | 612 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 32136245 | 32136245 | PRJNA656952_P_NODE_33998_length_249_cov_0.875000_g33811_i0 | PRJNA656952 | 33998 | 249 | 0.875 | 2.17875 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 85.1 | 3.36e-17 | NR | HLP84061.1 | 2052180 | g33811 | i0 | 51.4 | 0.843373493975904 | 70 | 34 | 84.3 | 0 | 37 | 246 | 173 | 242 | HLP84061.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 210 | 85.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 32560023 | 32560023 | PRJNA656952_P_NODE_42979_length_242_cov_0.911243_g42792_i0 | PRJNA656952 | 42979 | 242 | 0.911243 | 2.20520806 | Gemmata | 113 | Bacteria | Bacteria | 87.4 | 4.64e-19 | NR | MBM3982944.1 | 2026780 | g42792 | i0 | 58.3 | 6.47107438016529 | 84 | 31 | 99.2 | 1 | 241 | 2 | 134 | 217 | MBM3982944.1 sigma-70 family RNA polymerase sigma factor [Planctomycetota bacterium] | diamond | 1566 | 87.4 | 1 | 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);;