contig_metadata
24 rows where bioproject = "PRJNA540466", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1783403 | 1783403 | PRJNA540466_S_NODE_33022_length_315_cov_1.913223_g32473_i0 | PRJNA540466 | 33022 | 315 | 1.913223 | 6.02665245 | PVC group | 1783257 | Bacteria | Bacteria | 162 | 7.55e-44 | NR | MAT15335.1 | 37635 | g32473 | i0 | 90.8 | 46.0666666666667 | 87 | 8 | 82.9 | 0 | 289 | 29 | 197 | 283 | MAT15335.1 aconitate hydratase AcnA [Planctomyces sp.] | diamond | 14511 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomyces | Planctomyces sp. | |
| 3059003 | 3059003 | PRJNA540466_S_NODE_42963_length_281_cov_2.884615_g42414_i0 | PRJNA540466 | 42963 | 281 | 2.884615 | 8.10576815 | Urbifossiella limnaea | 2528023 | Bacteria | Bacteria | 350 | 8.2e-92 | NTclustered | gi|1712585314|gb|CP036273.1| | 2528023 | g42414 | i0 | 91.085 | 112.800711743772 | 258 | 23 | 92 | 0 | 1 | 258 | 2019860 | 2019603 | Urbifossiella limnaea strain ETA_A1 chromosome, complete genome | blastn | 31697 | 350 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Urbifossiella | Urbifossiella limnaea | |
| 6885527 | 6885527 | PRJNA540466_S_NODE_18606_length_409_cov_2.062500_g18057_i0 | PRJNA540466 | 18606 | 409 | 2.0625 | 8.435625 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 483 | 1.18e-131 | NTclustered | gi|2874253853|emb|OY969909.1| | 1914239 | g18057 | i0 | 89.61 | 78.0953545232274 | 385 | 33 | 93 | 6 | 30 | 409 | 2003145 | 2002763 | MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 | blastn | 31941 | 483 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 8161103 | 8161103 | PRJNA540466_S_NODE_68187_length_228_cov_3.993548_g67638_i0 | PRJNA540466 | 68187 | 228 | 3.993548 | 9.10528944 | uncultured Planctomycetota bacterium | 120965 | Bacteria | Bacteria | 377 | 2.95e-100 | NTclustered | gi|262410150|gb|GU074326.1| | 120965 | g67638 | i0 | 99.519 | 92.4210526315789 | 208 | 0 | 91 | 1 | 22 | 228 | 50 | 257 | Uncultured planctomycete clone 2S49 16S ribosomal RNA gene, partial sequence | blastn | 21072 | 377 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | uncultured Planctomycetota bacterium | |||||
| 10712333 | 10712333 | PRJNA540466_S_NODE_59609_length_247_cov_1.339080_g59060_i0 | PRJNA540466 | 59609 | 247 | 1.33908 | 3.3075276 | Rhodopirellula baltica | 265606 | Bacteria | Bacteria | 60.2 | 1.33e-4 | NTclustered | gi|32445988|emb|BX294148.1| | 243090 | g59060 | i0 | 100 | 8.33603238866397 | 32 | 0 | 13 | 0 | 151 | 182 | 35552 | 35583 | Rhodopirellula baltica SH 1 complete genome; segment 16/24 | blastn | 2059 | 60.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Rhodopirellula | Rhodopirellula baltica | |
| 18359682 | 18359682 | PRJNA540466_S_NODE_53435_length_257_cov_2.070652_g52886_i0 | PRJNA540466 | 53435 | 257 | 2.070652 | 5.32157564 | Maioricimonas rarisocia | 2528026 | Bacteria | Bacteria | 248 | 2.78e-61 | NTclustered | gi|1712603021|gb|CP036275.1| | 2528026 | g52886 | i0 | 90.052 | 80.6070038910506 | 191 | 19 | 74 | 0 | 31 | 221 | 1845629 | 1845439 | Maioricimonas rarisocia strain Mal4 chromosome, complete genome | blastn | 20716 | 248 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Maioricimonas | Maioricimonas rarisocia | |
| 20909996 | 20909996 | PRJNA540466_S_NODE_28137_length_338_cov_1.520755_g27588_i0 | PRJNA540466 | 28137 | 338 | 1.520755 | 5.1401519 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 392 | 1.66e-104 | NTclustered | gi|2874253853|emb|OY969909.1| | 1914239 | g27588 | i0 | 89.423 | 157.470414201183 | 312 | 32 | 92 | 1 | 12 | 322 | 2002575 | 2002886 | MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 | blastn | 53225 | 392 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 27457252 | 27457252 | PRJNA540466_S_NODE_50143_length_264_cov_1.366492_g49594_i0 | PRJNA540466 | 50143 | 264 | 1.366492 | 3.60753888 | Planctomyces sp. SH-PL62 | 1636152 | Bacteria | Bacteria | 42.7 | 0.0495 | NR | WP_068409703.1 | 1636152 | g49594 | i0 | 36.7 | 0.681818181818182 | 60 | 34 | 68.2 | 1 | 19 | 198 | 161 | 216 | WP_068409703.1 BatA domain-containing protein [Planctomyces sp. SH-PL62] | diamond | 180 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomyces | Planctomyces sp. SH-PL62 | |
| 29035967 | 29035967 | PRJNA540466_S_NODE_55168_length_254_cov_1.276243_g54619_i0 | PRJNA540466 | 55168 | 254 | 1.276243 | 3.24165722 | Novipirellula aureliae | 2527966 | Bacteria | Bacteria | 42.7 | 0.0369 | NR | TWU33679.1 | 2527966 | g54619 | i0 | 38.9 | 0.637795275590551 | 54 | 29 | 63.8 | 2 | 237 | 76 | 184 | 233 | TWU33679.1 hypothetical protein Q31b_57360 [Novipirellula aureliae] | diamond | 162 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Novipirellula | Novipirellula aureliae | |
| 29240137 | 29240137 | PRJNA540466_S_NODE_60589_length_246_cov_0.890173_g60040_i0 | PRJNA540466 | 60589 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 52 | 3.92e-6 | NR | MCA8910227.1 | 2026780 | g60040 | i0 | 55.3 | 2.75609756097561 | 38 | 17 | 46.3 | 0 | 243 | 130 | 82 | 119 | MCA8910227.1 DUF1669 domain-containing protein [Planctomycetota bacterium] | diamond | 678 | 52.4 | 0.99236641221374 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29477481 | 29477481 | PRJNA540466_S_NODE_22790_length_372_cov_5.438127_g22241_i0 | PRJNA540466 | 22790 | 372 | 5.438127 | 20.22983244 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 44.7 | 0.0328 | NR | MCH7632471.1 | 2026780 | g22241 | i0 | 29.6 | 0.57258064516129 | 71 | 50 | 57.3 | 0 | 119 | 331 | 309 | 379 | MCH7632471.1 hypothetical protein [Planctomycetota bacterium] | diamond | 213 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29477482 | 29477482 | PRJNA540466_S_NODE_24690_length_359_cov_1.062937_g24141_i0 | PRJNA540466 | 24690 | 359 | 1.062937 | 3.81594383 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 45.8 | 0.00599 | NR | MBX9581723.1 | 2052164 | g24141 | i0 | 46.8 | 1.30362116991643 | 77 | 36 | 61 | 3 | 19 | 237 | 107 | 182 | MBX9581723.1 disulfide bond formation protein B [Gemmataceae bacterium] | diamond | 468 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 29824969 | 29824969 | PRJNA540466_S_NODE_49131_length_266_cov_1.787565_g48582_i0 | PRJNA540466 | 49131 | 266 | 1.787565 | 4.7549229 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 45.8 | 0.00378 | NR | MFM7149898.1 | 2052164 | g48582 | i0 | 54.5 | 0.37218045112782 | 33 | 15 | 37.2 | 0 | 222 | 124 | 271 | 303 | MFM7149898.1 EF-hand domain-containing protein [Gemmataceae bacterium] | diamond | 99 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 29824974 | 29824974 | PRJNA540466_S_NODE_67211_length_231_cov_2.329114_g66662_i0 | PRJNA540466 | 67211 | 231 | 2.329114 | 5.38025334 | Pirellula sp. | 117 | Bacteria | Bacteria | 70.1 | 4.33e-13 | NR | HUP81692.1 | 117 | g66662 | i0 | 66.7 | 0.584415584415584 | 45 | 15 | 58.4 | 0 | 97 | 231 | 1 | 45 | HUP81692.1 CsbD family protein [Pirellula sp.] | diamond | 135 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellula | Pirellula sp. | |
| 29951481 | 29951481 | PRJNA540466_S_NODE_32751_length_316_cov_2.181070_g32202_i0 | PRJNA540466 | 32751 | 316 | 2.18107 | 6.8921812 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 85.5 | 6.02e-17 | NR | MEM9643452.1 | 2026780 | g32202 | i0 | 44.6 | 0.787974683544304 | 83 | 46 | 78.8 | 0 | 291 | 43 | 319 | 401 | MEM9643452.1 nucleoside monophosphate kinase [Planctomycetota bacterium] | diamond | 249 | 85.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29983078 | 29983078 | PRJNA540466_S_NODE_43771_length_279_cov_2.160194_g43222_i0 | PRJNA540466 | 43771 | 279 | 2.160194 | 6.02694126 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 47 | 1.19e-4 | NR | MBY0513755.1 | 2052164 | g43222 | i0 | 58.1 | 1.45161290322581 | 43 | 17 | 45.2 | 1 | 227 | 102 | 1 | 43 | MBY0513755.1 hypothetical protein [Gemmataceae bacterium] | diamond | 405 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 30014725 | 30014725 | PRJNA540466_S_NODE_36611_length_301_cov_2.973684_g36062_i0 | PRJNA540466 | 36611 | 301 | 2.973684 | 8.95078884 | Lacipirellula limnantheis | 2528024 | Bacteria | Bacteria | 177 | 4.9e-54 | NR | WP_145431844.1 | 2528024 | g36062 | i0 | 91.6 | 1.8936877076412 | 95 | 8 | 94.7 | 0 | 17 | 301 | 68 | 162 | WP_145431844.1 DedA family protein [Lacipirellula limnantheis] | diamond | 570 | 177 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Lacipirellulaceae | Lacipirellula | Lacipirellula limnantheis | |
| 30773080 | 30773080 | PRJNA540466_S_NODE_40694_length_288_cov_1.223256_g40145_i0 | PRJNA540466 | 40694 | 288 | 1.223256 | 3.52297728 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 60.5 | 1.19e-8 | NR | MBI3831542.1 | 2026780 | g40145 | i0 | 43.6 | 3.375 | 78 | 39 | 76 | 1 | 41 | 259 | 107 | 184 | MBI3831542.1 PH domain-containing protein [Planctomycetota bacterium] | diamond | 972 | 60.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31767817 | 31767817 | PRJNA540466_S_NODE_41657_length_285_cov_1.731132_g41108_i0 | PRJNA540466 | 41657 | 285 | 1.731132 | 4.9337262 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62.4 | 7.16e-9 | NR | MCU0727425.1 | 2026780 | g41108 | i0 | 47 | 3.8 | 66 | 30 | 69.5 | 1 | 22 | 219 | 100 | 160 | MCU0727425.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Planctomycetota bacterium] | diamond | 1083 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32132787 | 32132787 | PRJNA540466_S_NODE_54438_length_255_cov_2.137363_g53889_i0 | PRJNA540466 | 54438 | 255 | 2.137363 | 5.45027565 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 48.1 | 5.1e-4 | NR | HEV7280295.1 | 2699754 | g53889 | i0 | 53.1 | 0.376470588235294 | 32 | 15 | 37.6 | 0 | 251 | 156 | 317 | 348 | HEV7280295.1 cyclopropane-fatty-acyl-phospholipid synthase family protein [Pirellulaceae bacterium] | diamond | 96 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 32495745 | 32495745 | PRJNA540466_S_NODE_28539_length_336_cov_1.186312_g27990_i0 | PRJNA540466 | 28539 | 336 | 1.186312 | 3.98600832 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 103 | 1.69e-25 | NR | HKB02725.1 | 2052164 | g27990 | i0 | 50 | 4.75 | 108 | 51 | 96.4 | 2 | 3 | 326 | 24 | 128 | HKB02725.1 CBS domain-containing protein [Gemmataceae bacterium] | diamond | 1596 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 32575781 | 32575781 | PRJNA540466_S_NODE_42319_length_283_cov_1.857143_g41770_i0 | PRJNA540466 | 42319 | 283 | 1.857143 | 5.25571469 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 48.1 | 6.51e-4 | NR | MBI5863225.1 | 2026780 | g41770 | i0 | 44.2 | 0.858657243816254 | 52 | 28 | 55.1 | 1 | 279 | 124 | 190 | 240 | MBI5863225.1 lipase family protein [Planctomycetota bacterium] | diamond | 243 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32653096 | 32653096 | PRJNA540466_S_NODE_61760_length_244_cov_1.701754_g61211_i0 | PRJNA540466 | 61760 | 244 | 1.701754 | 4.15227976 | PVC group | 1783257 | Bacteria | Bacteria | 50.8 | 3.21e-5 | NR | MEE2639803.1 | 2026780 | g61211 | i0 | 45.1 | 3.11065573770492 | 51 | 28 | 62.7 | 0 | 2 | 154 | 143 | 193 | MEE2639803.1 DUF1990 domain-containing protein [Planctomycetota bacterium] | diamond | 759 | 50.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32733158 | 32733158 | PRJNA540466_S_NODE_59860_length_247_cov_0.885057_g59311_i0 | PRJNA540466 | 59860 | 247 | 0.885057 | 2.18609079 | Mariniblastus sp. | 2005381 | Bacteria | Bacteria | 90.9 | 9.8e-22 | NR | MCH2177586.1 | 2005381 | g59311 | i0 | 72.5 | 0.619433198380567 | 51 | 14 | 61.9 | 0 | 182 | 30 | 42 | 92 | MCH2177586.1 DUF427 domain-containing protein [Mariniblastus sp.] | diamond | 153 | 90.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Mariniblastus | Mariniblastus sp. |
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);;