contig_metadata
24 rows where bioproject = "PRJNA1102048", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4038550 | 4038550 | PRJNA1102048_P_NODE_8264_length_302_cov_3.148472_g8160_i0 | PRJNA1102048 | 8264 | 302 | 3.148472 | 9.50838544 | Bdellovibrio reynosensis | 2835041 | Bacteria | Bacteria | 494 | 3.89e-135 | NTclustered | gi|2216477995|gb|CP093442.1| | 2835041 | g8160 | i0 | 96.333 | 332.23178807947 | 300 | 11 | 99 | 0 | 1 | 300 | 953163 | 952864 | Bdellovibrio reynosensis strain LBG001 chromosome, complete genome | blastn | 100334 | 494 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio reynosensis | ||
| 16322498 | 16322498 | PRJNA1102048_P_NODE_6093_length_350_cov_1.111913_g5989_i0 | PRJNA1102048 | 6093 | 350 | 1.111913 | 3.8916955 | Bdellovibrio | 958 | Bacteria | Bacteria | 636 | 7.18e-178 | NTclustered | gi|2800924434|gb|CP168967.1| | 959 | g5989 | i0 | 99.429 | 181.722857142857 | 350 | 2 | 100 | 0 | 1 | 350 | 784147 | 783798 | Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome | blastn | 63603 | 636 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 20612947 | 20612947 | PRJNA1102048_P_NODE_3097_length_479_cov_2.652709_g2993_i0 | PRJNA1102048 | 3097 | 479 | 2.652709 | 12.70647611 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 122 | 1.49e-32 | NR | MCB0368029.1 | 2053517 | g2993 | i0 | 56.1 | 0.670146137787056 | 107 | 46 | 66.4 | 1 | 478 | 161 | 18 | 124 | MCB0368029.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 321 | 122 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 24437614 | 24437614 | PRJNA1102048_P_NODE_15080_length_246_cov_0.890173_g14976_i0 | PRJNA1102048 | 15080 | 246 | 0.890173 | 2.18982558 | Bacteriovoracales | 2024979 | Bacteria | Bacteria | 160 | 2.1e-44 | NR | MAF76598.1 | 2026745 | g14976 | i0 | 98.8 | 1.97560975609756 | 81 | 1 | 98.8 | 0 | 244 | 2 | 194 | 274 | MAF76598.1 30S ribosomal protein S1 [Halobacteriovoraceae bacterium] | diamond | 486 | 160 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 25246337 | 25246337 | PRJNA1102048_P_NODE_10540_length_272_cov_1.547739_g10436_i0 | PRJNA1102048 | 10540 | 272 | 1.547739 | 4.20985008 | Bacteriovorax | 146784 | Bacteria | Bacteria | 166 | 1.6299999999999996e-47 | NR | MDD4972878.1 | 2608087 | g10436 | i0 | 85.6 | 16.8419117647059 | 90 | 13 | 99.3 | 0 | 272 | 3 | 5 | 94 | MDD4972878.1 isocitrate dehydrogenase (NADP(+)) [Bacteriovorax sp.] | diamond | 4581 | 166 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. | ||
| 26805770 | 26805770 | PRJNA1102048_P_NODE_17081_length_242_cov_0.911243_g16977_i0 | PRJNA1102048 | 17081 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 150 | 1.3899999999999996e-43 | NR | MBD65938.1 | 2026745 | g16977 | i0 | 92.5 | 12.8925619834711 | 80 | 6 | 99.2 | 0 | 3 | 242 | 119 | 198 | MBD65938.1 arsenical resistance protein ArsH [Halobacteriovoraceae bacterium] | diamond | 3120 | 151 | 0.993377483443709 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 26878095 | 26878095 | PRJNA1102048_P_NODE_13421_length_250_cov_0.870056_g13317_i0 | PRJNA1102048 | 13421 | 250 | 0.870056 | 2.17514 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 50.4 | 7.53e-5 | NR | MEC7276116.1 | 3034175 | g13317 | i0 | 75 | 0.336 | 28 | 7 | 33.6 | 0 | 249 | 166 | 334 | 361 | MEC7276116.1 saccharopine dehydrogenase [Bdellovibrionota bacterium] | diamond | 84 | 50.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 28109807 | 28109807 | PRJNA1102048_P_NODE_2225_length_549_cov_7.161765_g2123_i0 | PRJNA1102048 | 2225 | 549 | 7.161765 | 39.31808985 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 70.9 | 1.63e-11 | NR | MCB0369154.1 | 2053517 | g2123 | i0 | 30.7 | 0.748633879781421 | 137 | 89 | 74.9 | 2 | 506 | 96 | 3 | 133 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 411 | 70.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28488904 | 28488904 | PRJNA1102048_P_NODE_5887_length_355_cov_2.730496_g5783_i0 | PRJNA1102048 | 5887 | 355 | 2.730496 | 9.6932608 | Bacteriovorax sp. | 2608087 | Bacteria | Bacteria | 158 | 1.01e-44 | NR | MBP9680396.1 | 2608087 | g5783 | i0 | 72 | 3.56619718309859 | 107 | 30 | 90.4 | 0 | 327 | 7 | 8 | 114 | MBP9680396.1 adenosine kinase [Bacteriovorax sp.] | diamond | 1266 | 158 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. | ||
| 29246558 | 29246558 | PRJNA1102048_P_NODE_17209_length_242_cov_0.911243_g17105_i0 | PRJNA1102048 | 17209 | 242 | 0.911243 | 2.20520806 | Halobacteriovoraceae bacterium | 2026745 | Bacteria | Bacteria | 116 | 4.45e-32 | NR | MBT3583655.1 | 2026745 | g17105 | i0 | 79.7 | 0.793388429752066 | 64 | 13 | 79.3 | 0 | 1 | 192 | 9 | 72 | MBT3583655.1 hypothetical protein [Halobacteriovoraceae bacterium] | diamond | 192 | 116 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 29372942 | 29372942 | PRJNA1102048_P_NODE_13129_length_250_cov_0.870056_g13025_i0 | PRJNA1102048 | 13129 | 250 | 0.870056 | 2.17514 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 76.3 | 1.64e-15 | NR | MEE2671064.1 | 3034175 | g13025 | i0 | 43.9 | 0.984 | 82 | 41 | 98.4 | 2 | 249 | 4 | 15 | 91 | MEE2671064.1 VOC family protein [Bdellovibrionota bacterium] | diamond | 246 | 76.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 30153492 | 30153492 | PRJNA1102048_P_NODE_12872_length_251_cov_0.865169_g12768_i0 | PRJNA1102048 | 12872 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 120 | 2.55e-29 | NR | MCF8057649.1 | 2081706 | g12768 | i0 | 68.7 | 1.99601593625498 | 83 | 25 | 98 | 1 | 251 | 6 | 379 | 461 | MCF8057649.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 501 | 121 | 0.991735537190083 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 30289218 | 30289218 | PRJNA1102048_P_NODE_17492_length_241_cov_1.255952_g17388_i0 | PRJNA1102048 | 17492 | 241 | 1.255952 | 3.02684432 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 116 | 1.7399999999999999e-31 | NR | MCB0370182.1 | 2053517 | g17388 | i0 | 76 | 3.78423236514523 | 75 | 18 | 93.4 | 0 | 241 | 17 | 43 | 117 | MCB0370182.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 912 | 116 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30384024 | 30384024 | PRJNA1102048_P_NODE_10473_length_273_cov_1.415000_g10369_i0 | PRJNA1102048 | 10473 | 273 | 1.415 | 3.86295 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 113 | 1.8000000000000002e-28 | NR | MBX9767866.1 | 2053517 | g10369 | i0 | 63.3 | 0.989010989010989 | 90 | 33 | 98.9 | 0 | 273 | 4 | 68 | 157 | MBX9767866.1 GTP-binding protein [Bdellovibrionales bacterium] | diamond | 270 | 113 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30384034 | 30384034 | PRJNA1102048_P_NODE_16753_length_243_cov_0.905882_g16649_i0 | PRJNA1102048 | 16753 | 243 | 0.905882 | 2.20129326 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 136 | 4.82e-38 | NR | MEC7276380.1 | 3034175 | g16649 | i0 | 78.8 | 0.987654320987654 | 80 | 17 | 98.8 | 0 | 2 | 241 | 144 | 223 | MEC7276380.1 class I SAM-dependent methyltransferase [Bdellovibrionota bacterium] | diamond | 240 | 136 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 30509969 | 30509969 | PRJNA1102048_P_NODE_15073_length_246_cov_0.890173_g14969_i0 | PRJNA1102048 | 15073 | 246 | 0.890173 | 2.18982558 | Silvanigrellales bacterium | 2767476 | Bacteria | Bacteria | 59.7 | 1.68e-9 | NR | MCA2959144.1 | 2767476 | g14969 | i0 | 69.8 | 0.524390243902439 | 43 | 13 | 52.4 | 0 | 117 | 245 | 11 | 53 | MCA2959144.1 30S ribosomal protein S15 [Silvanigrellales bacterium] | diamond | 129 | 59.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellales bacterium | ||||
| 30572940 | 30572940 | PRJNA1102048_P_NODE_17833_length_241_cov_0.916667_g17729_i0 | PRJNA1102048 | 17833 | 241 | 0.916667 | 2.20916747 | Bdellovibrionales bacterium RIFOXYD1_FULL_44_7 | 1797402 | Bacteria | Bacteria | 55.5 | 1.16e-7 | NR | OFZ75141.1 | 1797402 | g17729 | i0 | 47.3 | 0.684647302904564 | 55 | 29 | 68.5 | 0 | 209 | 45 | 4 | 58 | OFZ75141.1 MAG: heme biosynthesis protein HemY [Bdellovibrionales bacterium RIFOXYD1_FULL_44_7] | diamond | 165 | 55.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFOXYD1_FULL_44_7 | ||||
| 30943797 | 30943797 | PRJNA1102048_P_NODE_1414_length_646_cov_1.570681_g1314_i0 | PRJNA1102048 | 1414 | 646 | 1.570681 | 10.14659926 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 231 | 9.11e-72 | NR | WP_142409471.1 | 960 | g1314 | i0 | 70.2 | 2.3359133126935 | 168 | 50 | 78 | 0 | 646 | 143 | 161 | 328 | WP_142409471.1 adenosine kinase [Bacteriovorax stolpii] | diamond | 1509 | 233 | 0.991416309012876 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 31078883 | 31078883 | PRJNA1102048_P_NODE_7095_length_325_cov_1.222222_g6991_i0 | PRJNA1102048 | 7095 | 325 | 1.222222 | 3.9722215 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 148 | 1.06e-40 | NR | MEC7278021.1 | 3034175 | g6991 | i0 | 67.9 | 1.00615384615385 | 109 | 34 | 99.7 | 1 | 2 | 325 | 254 | 362 | MEC7278021.1 PQQ-binding-like beta-propeller repeat protein [Bdellovibrionota bacterium] | diamond | 327 | 148 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31173186 | 31173186 | PRJNA1102048_P_NODE_13415_length_250_cov_0.870056_g13311_i0 | PRJNA1102048 | 13415 | 250 | 0.870056 | 2.17514 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 141 | 2.09e-37 | NR | MEC7277924.1 | 3034175 | g13311 | i0 | 80.7 | 0.996 | 83 | 16 | 99.6 | 0 | 1 | 249 | 315 | 397 | MEC7277924.1 murein biosynthesis integral membrane protein MurJ [Bdellovibrionota bacterium] | diamond | 249 | 141 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31521532 | 31521532 | PRJNA1102048_P_NODE_16156_length_244_cov_0.900585_g16052_i0 | PRJNA1102048 | 16156 | 244 | 0.900585 | 2.1974274 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 144 | 1.87e-39 | NR | MEC7275041.1 | 3034175 | g16052 | i0 | 83.8 | 0.983606557377049 | 80 | 13 | 98.4 | 0 | 240 | 1 | 226 | 305 | MEC7275041.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 240 | 144 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32565706 | 32565706 | PRJNA1102048_P_NODE_12939_length_251_cov_0.865169_g12835_i0 | PRJNA1102048 | 12939 | 251 | 0.865169 | 2.17157419 | Halobacteriovoraceae bacterium | 2026745 | Bacteria | Bacteria | 109 | 5.630000000000001e-27 | NR | MBC97755.1 | 2026745 | g12835 | i0 | 95.3 | 0.764940239043825 | 64 | 3 | 76.5 | 0 | 2 | 193 | 214 | 277 | MBC97755.1 flagellin FliC [Halobacteriovoraceae bacterium] | diamond | 192 | 109 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 32597037 | 32597037 | PRJNA1102048_P_NODE_13060_length_250_cov_1.700565_g12956_i0 | PRJNA1102048 | 13060 | 250 | 1.700565 | 4.2514125 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 117 | 2.96e-30 | NR | MBX9767866.1 | 2053517 | g12956 | i0 | 61 | 0.984 | 82 | 32 | 98.4 | 0 | 2 | 247 | 166 | 247 | MBX9767866.1 GTP-binding protein [Bdellovibrionales bacterium] | diamond | 246 | 117 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32848783 | 32848783 | PRJNA1102048_P_NODE_880_length_778_cov_5.204255_g788_i0 | PRJNA1102048 | 880 | 778 | 5.204255 | 40.4891039 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 319 | 1.7399999999999995e-107 | NR | MBX9767865.1 | 2053517 | g788 | i0 | 89.6 | 0.667095115681234 | 173 | 18 | 66.7 | 0 | 260 | 778 | 1 | 173 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 519 | 319 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales 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);;