contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJDB14274" and tax_kingdom = "Pseudomonadati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26874509 | 26874509 | PRJDB14274_S_NODE_4801_length_283_cov_1.666667_g4723_i0 | PRJDB14274 | 4801 | 283 | 1.666667 | 4.71666761 | Solidesulfovibrio carbinolicus | 296842 | Bacteria | Bacteria | 74.7 | 3.4e-13 | NR | WP_129348747.1 | 296842 | g4723 | i0 | 39.4 | 4.86572438162544 | 94 | 57 | 99.6 | 0 | 1 | 282 | 160 | 253 | WP_129348747.1 bifunctional metallophosphatase/5'-nucleotidase [Solidesulfovibrio carbinolicus] | diamond | 1377 | 74.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Solidesulfovibrio | Solidesulfovibrio carbinolicus | ||
| 27221829 | 27221829 | PRJDB14274_S_NODE_2583_length_381_cov_1.531250_g2505_i0 | PRJDB14274 | 2583 | 381 | 1.53125 | 5.8340625 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 149 | 5.06e-39 | NR | MBK7911650.1 | 1898104 | g2505 | i0 | 54 | 3.94488188976378 | 126 | 58 | 99.2 | 0 | 2 | 379 | 606 | 731 | MBK7911650.1 ribonucleoside-diphosphate reductase subunit alpha [Bacteroidota bacterium] | diamond | 1503 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 28043180 | 28043180 | PRJDB14274_S_NODE_7905_length_226_cov_1.012121_g7827_i0 | PRJDB14274 | 7905 | 226 | 1.012121 | 2.28739346 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 44.3 | 0.00824 | NR | HTL66095.1 | 1961806 | g7827 | i0 | 32.3 | 1.64601769911504 | 62 | 42 | 82.3 | 0 | 218 | 33 | 246 | 307 | HTL66095.1 hypothetical protein [Lacunisphaera sp.] | diamond | 372 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 28416316 | 28416316 | PRJDB14274_S_NODE_5506_length_266_cov_2.360976_g5428_i0 | PRJDB14274 | 5506 | 266 | 2.360976 | 6.28019616 | root | 1 | Root_unresolved | Root_unresolved | 121 | 1.77e-33 | NR | WP_416561407.1 | 573 | g5428 | i0 | 71.6 | 16.8721804511278 | 88 | 25 | 99.2 | 0 | 264 | 1 | 16 | 103 | WP_416561407.1 hypothetical protein, partial [Klebsiella pneumoniae] | diamond | 4488 | 122 | 0.991803278688525 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Klebsiella | Klebsiella pneumoniae | ||
| 28800754 | 28800754 | PRJDB14274_S_NODE_9868_length_205_cov_0.902778_g9790_i0 | PRJDB14274 | 9868 | 205 | 0.902778 | 1.8506949 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 44.7 | 0.0048 | NR | MEX1365420.1 | 2545255 | g9790 | i0 | 36.7 | 0.878048780487805 | 60 | 35 | 83.4 | 2 | 177 | 7 | 56 | 115 | MEX1365420.1 IgGFc-binding protein [Nannocystaceae bacterium] | diamond | 180 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 28832402 | 28832402 | PRJDB14274_S_NODE_10088_length_203_cov_1.267606_g10010_i0 | PRJDB14274 | 10088 | 203 | 1.267606 | 2.57324018 | Candidatus Zhuqueibacter pondensis | 3396518 | Bacteria | Bacteria | 94.7 | 1.08e-20 | NR | MDZ7288678.1 | 3396518 | g10010 | i0 | 73.3 | 3.63546798029557 | 60 | 15 | 87.2 | 1 | 199 | 23 | 889 | 948 | MDZ7288678.1 aminomethyl-transferring glycine dehydrogenase [Candidatus Zhuqueibacter pondensis] | diamond | 738 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zhuqueibacterales | Candidatus Zhuqueibacteraceae | Candidatus Zhuqueibacter | Candidatus Zhuqueibacter pondensis | |||
| 28959029 | 28959029 | PRJDB14274_S_NODE_5608_length_264_cov_2.113300_g5530_i0 | PRJDB14274 | 5608 | 264 | 2.1133 | 5.579112 | Pseudomonadota bacterium | 1977087 | Bacteria | Bacteria | 43.5 | 0.0215 | NR | MDQ6646288.1 | 1977087 | g5530 | i0 | 35.6 | 0.670454545454545 | 59 | 38 | 67 | 0 | 256 | 80 | 106 | 164 | MDQ6646288.1 glutathione S-transferase C-terminal domain-containing protein [Pseudomonadota bacterium] | diamond | 177 | 43.5 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Pseudomonadota bacterium | ||||||
| 29016411 | 29016411 | PRJDB14274_S_NODE_9788_length_205_cov_1.354167_g9710_i0 | PRJDB14274 | 9788 | 205 | 1.354167 | 2.77604235 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 94.4 | 1.2e-20 | NR | NND55299.1 | 1913989 | g9710 | i0 | 86.3 | 14.8682926829268 | 51 | 7 | 74.6 | 0 | 204 | 52 | 422 | 472 | NND55299.1 adenosylhomocysteinase [Gammaproteobacteria bacterium] | diamond | 3048 | 94.4 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Gammaproteobacteria bacterium | |||||
| 29205733 | 29205733 | PRJDB14274_S_NODE_9729_length_206_cov_0.896552_g9651_i0 | PRJDB14274 | 9729 | 206 | 0.896552 | 1.84689712 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 80.9 | 8.35e-16 | NR | NDC88964.1 | 1898104 | g9651 | i0 | 54.4 | 20.7815533980583 | 68 | 29 | 99 | 1 | 206 | 3 | 316 | 381 | NDC88964.1 glutamine synthetase type III [Bacteroidota bacterium] | diamond | 4281 | 80.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 29678800 | 29678800 | PRJDB14274_S_NODE_7350_length_234_cov_1.121387_g7272_i0 | PRJDB14274 | 7350 | 234 | 1.121387 | 2.62404558 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82 | 2.2e-17 | NR | NLY94724.1 | 2026763 | g7272 | i0 | 61.9 | 1.61538461538462 | 63 | 24 | 80.8 | 0 | 2 | 190 | 116 | 178 | NLY94724.1 oligoribonuclease [Myxococcales bacterium] | diamond | 378 | 82 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29684661 | 29684661 | PRJDB14274_S_NODE_10070_length_203_cov_1.436620_g9992_i0 | PRJDB14274 | 10070 | 203 | 1.43662 | 2.9163386 | Pseudomonadota bacterium | 1977087 | Bacteria | Bacteria | 103 | 1.51e-26 | NR | MEL6702651.1 | 1977087 | g9992 | i0 | 73.1 | 1.98029556650246 | 67 | 18 | 99 | 0 | 201 | 1 | 42 | 108 | MEL6702651.1 30S ribosomal protein S11 [Pseudomonadota bacterium] | diamond | 402 | 103 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Pseudomonadota bacterium | ||||||
| 29937741 | 29937741 | PRJDB14274_S_NODE_9411_length_208_cov_1.115646_g9333_i0 | PRJDB14274 | 9411 | 208 | 1.115646 | 2.32054368 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 41.6 | 0.0134 | NR | MEM7457776.1 | 2026780 | g9333 | i0 | 48.7 | 0.5625 | 39 | 19 | 56.3 | 1 | 80 | 196 | 46 | 83 | MEM7457776.1 hypothetical protein [Planctomycetota bacterium] | diamond | 117 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30253868 | 30253868 | PRJDB14274_S_NODE_9612_length_207_cov_0.883562_g9534_i0 | PRJDB14274 | 9612 | 207 | 0.883562 | 1.82897334 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 110 | 4.23e-26 | NR | MCB0345085.1 | 2053517 | g9534 | i0 | 76.6 | 4.63768115942029 | 64 | 15 | 92.8 | 0 | 15 | 206 | 247 | 310 | MCB0345085.1 acetate--CoA ligase [Bdellovibrionales bacterium] | diamond | 960 | 110 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30348914 | 30348914 | PRJDB14274_S_NODE_8732_length_215_cov_1.220779_g8654_i0 | PRJDB14274 | 8732 | 215 | 1.220779 | 2.62467485 | Alphaproteobacteria bacterium | 1913988 | Bacteria | Bacteria | 80.5 | 5.15e-17 | NR | MFO0203429.1 | 1913988 | g8654 | i0 | 59.3 | 0.823255813953488 | 59 | 24 | 82.3 | 0 | 213 | 37 | 91 | 149 | MFO0203429.1 hypothetical protein [Alphaproteobacteria bacterium] | diamond | 177 | 80.5 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Alphaproteobacteria bacterium | |||||
| 30853863 | 30853863 | PRJDB14274_S_NODE_2874_length_361_cov_1.616667_g2796_i0 | PRJDB14274 | 2874 | 361 | 1.616667 | 5.83616787 | Flavobacteriales bacterium CG_4_8_14_3_um_filter_35_1 | 2021391 | Bacteria | Bacteria | 98.2 | 1.68e-21 | NR | PIX07545.1 | 1974001 | g2796 | i0 | 75.2 | 0.939058171745152 | 113 | 28 | 93.9 | 0 | 355 | 17 | 254 | 366 | PIX07545.1 MAG: hypothetical protein COZ76_02930 [Flavobacteriales bacterium CG_4_8_14_3_um_filter_35_10] | diamond | 339 | 98.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriales bacterium CG_4_8_14_3_um_filter_35_10 | |||
| 31011843 | 31011843 | PRJDB14274_S_NODE_10135_length_203_cov_0.915493_g10057_i0 | PRJDB14274 | 10135 | 203 | 0.915493 | 1.85845079 | Alphaproteobacteria bacterium | 1913988 | Bacteria | Bacteria | 80.9 | 3.1e-17 | NR | MFO0203429.1 | 1913988 | g10057 | i0 | 55.2 | 4.95073891625616 | 67 | 30 | 99 | 0 | 201 | 1 | 82 | 148 | MFO0203429.1 hypothetical protein [Alphaproteobacteria bacterium] | diamond | 1005 | 80.9 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Alphaproteobacteria bacterium | |||||
| 31037908 | 31037908 | PRJDB14274_S_NODE_8175_length_222_cov_1.397516_g8097_i0 | PRJDB14274 | 8175 | 222 | 1.397516 | 3.10248552 | root | 1 | Root_unresolved | Root_unresolved | 112 | 6.03e-27 | NR | MBT3273499.1 | 2026792 | g8097 | i0 | 66.2 | 17 | 74 | 25 | 100 | 0 | 222 | 1 | 357 | 430 | MBT3273499.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Spirochaetales bacterium] | diamond | 3774 | 113 | 0.991150442477876 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Spirochaetales bacterium | ||||
| 31359748 | 31359748 | PRJDB14274_S_NODE_3456_length_330_cov_1.182156_g3378_i0 | PRJDB14274 | 3456 | 330 | 1.182156 | 3.9011148 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 44.7 | 0.0209 | NR | HRE83688.1 | 2006848 | g3378 | i0 | 38.1 | 0.572727272727273 | 63 | 38 | 56.4 | 1 | 238 | 53 | 401 | 463 | HRE83688.1 prolyl oligopeptidase family serine peptidase [Opitutaceae bacterium] | diamond | 189 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31612653 | 31612653 | PRJDB14274_S_NODE_7976_length_225_cov_1.170732_g7898_i0 | PRJDB14274 | 7976 | 225 | 1.170732 | 2.634147 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 43.5 | 0.0153 | NR | MCU0781010.1 | 2562705 | g7898 | i0 | 36.5 | 0.693333333333333 | 52 | 24 | 69.3 | 1 | 188 | 33 | 284 | 326 | MCU0781010.1 polyprenyl synthetase family protein [Akkermansiaceae bacterium] | diamond | 156 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 31928897 | 31928897 | PRJDB14274_S_NODE_5637_length_264_cov_0.960591_g5559_i0 | PRJDB14274 | 5637 | 264 | 0.960591 | 2.53596024 | Candidatus Polarisedimenticolia bacterium | 3069555 | Bacteria | Bacteria | 95.1 | 7.24e-23 | NR | HKQ96897.1 | 3069555 | g5559 | i0 | 56.1 | 0.931818181818182 | 82 | 36 | 93.2 | 0 | 19 | 264 | 10 | 91 | HKQ96897.1 formate--tetrahydrofolate ligase [Candidatus Polarisedimenticolia bacterium] | diamond | 246 | 95.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Candidatus Polarisedimenticolia | Candidatus Polarisedimenticolia bacterium | |||||
| 32023948 | 32023948 | PRJDB14274_S_NODE_7318_length_234_cov_1.618497_g7240_i0 | PRJDB14274 | 7318 | 234 | 1.618497 | 3.78728298 | Pseudomonadota bacterium | 1977087 | Bacteria | Bacteria | 110 | 3.71e-29 | NR | MEL6702586.1 | 1977087 | g7240 | i0 | 64.5 | 0.974358974358974 | 76 | 27 | 97.4 | 0 | 232 | 5 | 13 | 88 | MEL6702586.1 uL14 family ribosomal protein [Pseudomonadota bacterium] | diamond | 228 | 110 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Pseudomonadota bacterium | ||||||
| 32055434 | 32055434 | PRJDB14274_S_NODE_3018_length_352_cov_1.340206_g2940_i0 | PRJDB14274 | 3018 | 352 | 1.340206 | 4.71752512 | Psychromonas sp. MB-3u-54 | 2058319 | Bacteria | Bacteria | 45.1 | 0.0181 | NR | WP_101038493.1 | 2058319 | g2940 | i0 | 27.7 | 0.801136363636364 | 94 | 68 | 80.1 | 0 | 61 | 342 | 129 | 222 | WP_101038493.1 efflux RND transporter periplasmic adaptor subunit [Psychromonas sp. MB-3u-54] | diamond | 282 | 45.1 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Alteromonadales | Psychromonadaceae | Psychromonas | Psychromonas sp. MB-3u-54 | ||
| 32055441 | 32055441 | PRJDB14274_S_NODE_7338_length_234_cov_1.202312_g7260_i0 | PRJDB14274 | 7338 | 234 | 1.202312 | 2.81341008 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 82.4 | 3.3e-16 | NR | HEV3217645.1 | 2910147 | g7260 | i0 | 61 | 0.987179487179487 | 77 | 29 | 98.7 | 1 | 3 | 233 | 54 | 129 | HEV3217645.1 NAD-dependent succinate-semialdehyde dehydrogenase [Vicinamibacterales bacterium] | diamond | 231 | 82.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32087176 | 32087176 | PRJDB14274_S_NODE_1458_length_504_cov_2.171558_g1382_i0 | PRJDB14274 | 1458 | 504 | 2.171558 | 10.94465232 | Gammaproteobacteria bacterium | 1913989 | Bacteria | Bacteria | 47.4 | 0.00897 | NR | MCP3667323.1 | 1913989 | g1382 | i0 | 46.6 | 0.345238095238095 | 58 | 31 | 34.5 | 0 | 489 | 316 | 112 | 169 | MCP3667323.1 hypothetical protein [Gammaproteobacteria bacterium] | diamond | 174 | 47.4 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Gammaproteobacteria 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);;