contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA608660" and tax_phylum = "Bdellovibrionota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1860633 | 1860633 | PRJNA608660_P_NODE_31422_length_227_cov_2.337079_g31066_i0 | PRJNA608660 | 31422 | 227 | 2.337079 | 5.30516933 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 137 | 4.859999999999999e-37 | NR | WP_235044643.1 | 453816 | g31066 | i0 | 90.7 | 4.95594713656388 | 75 | 7 | 99.1 | 0 | 3 | 227 | 225 | 299 | WP_235044643.1 peptide chain release factor 2 [Pseudobdellovibrio exovorus] | diamond | 1125 | 137 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 12063927 | 12063927 | PRJNA608660_P_NODE_14650_length_383_cov_2.556886_g14297_i0 | PRJNA608660 | 14650 | 383 | 2.556886 | 9.79287338 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 145 | 3.51e-39 | NR | MFN8847863.1 | 2053517 | g14297 | i0 | 91.7 | 0.563968668407311 | 72 | 6 | 56.4 | 0 | 375 | 160 | 56 | 127 | MFN8847863.1 bifunctional 2-methylcitrate synthase/citrate synthase [Bdellovibrionales bacterium] | diamond | 216 | 145 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 12064175 | 12064175 | PRJNA608660_P_NODE_41310_length_183_cov_2.216418_g40953_i0 | PRJNA608660 | 41310 | 183 | 2.216418 | 4.05604494 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 55.8 | 2.09e-7 | NR | MBC7466258.1 | 28201 | g40953 | i0 | 51 | 0.80327868852459 | 49 | 22 | 80.3 | 1 | 14 | 160 | 115 | 161 | MBC7466258.1 hypothetical protein [Bdellovibrio sp.] | diamond | 147 | 55.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 13900837 | 13900837 | PRJNA608660_P_NODE_17991_length_338_cov_3.958478_g17636_i0 | PRJNA608660 | 17991 | 338 | 3.958478 | 13.37965564 | Bacteria | 2 | Bacteria | Bacteria | 111 | 1.03e-25 | NR | MBL7557961.1 | 2026715 | g17636 | i0 | 85.9 | 2.89349112426035 | 64 | 9 | 56.8 | 0 | 329 | 138 | 642 | 705 | MBL7557961.1 cadmium-translocating P-type ATPase [Pseudobdellovibrionaceae bacterium] | diamond | 978 | 112 | 0.991071428571429 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 26763578 | 26763578 | PRJNA608660_P_NODE_48561_length_164_cov_0.904348_g48204_i0 | PRJNA608660 | 48561 | 164 | 0.904348 | 1.48313072 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 87.4 | 8.63e-19 | NR | MBC7420711.1 | 28201 | g48204 | i0 | 84.1 | 2.41463414634146 | 44 | 7 | 80.5 | 0 | 156 | 25 | 256 | 299 | MBC7420711.1 hypothetical protein [Bdellovibrio sp.] | diamond | 396 | 87.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 26858962 | 26858962 | PRJNA608660_P_NODE_21641_length_299_cov_1.640000_g21285_i0 | PRJNA608660 | 21641 | 299 | 1.64 | 4.9036 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 94.7 | 3.32e-20 | NR | GIL17027.1 | 2599941 | g21285 | i0 | 48.9 | 0.903010033444816 | 90 | 46 | 90.3 | 0 | 29 | 298 | 106 | 195 | GIL17027.1 MAG: hypothetical protein BroJett040_07780 [Oligoflexia bacterium] | diamond | 270 | 94.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 26890517 | 26890517 | PRJNA608660_P_NODE_14021_length_392_cov_9.247813_g13669_i0 | PRJNA608660 | 14021 | 392 | 9.247813 | 36.25142696 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 144 | 1.6499999999999999e-38 | NR | MBK8204757.1 | 2053517 | g13669 | i0 | 63.8 | 2.91581632653061 | 127 | 46 | 97.2 | 0 | 1 | 381 | 41 | 167 | MBK8204757.1 TolC family protein [Bdellovibrionales bacterium] | diamond | 1143 | 144 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27775263 | 27775263 | PRJNA608660_P_NODE_47024_length_166_cov_3.085470_g46667_i0 | PRJNA608660 | 47024 | 166 | 3.08547 | 5.1218802 | Bacteriovoracia bacterium | 3058048 | Bacteria | Bacteria | 65.1 | 1.41e-10 | NR | MFP5459035.1 | 3058048 | g46667 | i0 | 69.8 | 0.77710843373494 | 43 | 13 | 77.7 | 0 | 132 | 4 | 1 | 43 | MFP5459035.1 exonuclease domain-containing protein [Bacteriovoracia bacterium] | diamond | 129 | 65.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracia bacterium | |||||
| 27869648 | 27869648 | PRJNA608660_P_NODE_33825_length_215_cov_1.078313_g33469_i0 | PRJNA608660 | 33825 | 215 | 1.078313 | 2.31837295 | Bdellovibrionales bacterium RIFCSPHIGHO2_ | 2053517 | Bacteria | Bacteria | 63.5 | 9.86e-11 | NR | OFZ31042.1 | 1797389 | g33469 | i0 | 61.5 | 0.725581395348837 | 52 | 20 | 72.6 | 0 | 54 | 209 | 81 | 132 | OFZ31042.1 MAG: hypothetical protein A2622_00095 [Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29] | diamond | 156 | 63.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29 | ||||
| 27932938 | 27932938 | PRJNA608660_P_NODE_46665_length_167_cov_1.322034_g46308_i0 | PRJNA608660 | 46665 | 167 | 1.322034 | 2.20779678 | Halobacteriovorax sp. | 2020862 | Bacteria | Bacteria | 87.8 | 1.6e-18 | NR | MBH47361.1 | 2020862 | g46308 | i0 | 63 | 0.970059880239521 | 54 | 20 | 97 | 0 | 163 | 2 | 46 | 99 | MBH47361.1 hypothetical protein [Halobacteriovorax sp.] | diamond | 162 | 87.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax sp. | ||
| 27996194 | 27996194 | PRJNA608660_P_NODE_4785_length_660_cov_4.238953_g4492_i0 | PRJNA608660 | 4785 | 660 | 4.238953 | 27.9770898 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 67 | 7.28e-9 | NR | MDC0980284.1 | 2053517 | g4492 | i0 | 33.3 | 0.545454545454545 | 120 | 75 | 53.2 | 3 | 11 | 361 | 367 | 484 | MDC0980284.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 360 | 67 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28198484 | 28198484 | PRJNA608660_P_NODE_12346_length_422_cov_11.056300_g11999_i0 | PRJNA608660 | 12346 | 422 | 11.0563 | 46.657586 | Bdellovibrio | 958 | Bacteria | Bacteria | 117 | 1.2399999999999999e-28 | NR | MBC7465877.1 | 28201 | g11999 | i0 | 43.5 | 1.96208530805687 | 138 | 78 | 98.1 | 0 | 414 | 1 | 74 | 211 | MBC7465877.1 glycosyltransferase family 2 protein [Bdellovibrio sp.] | diamond | 828 | 118 | 0.991525423728814 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 29069772 | 29069772 | PRJNA608660_P_NODE_50908_length_153_cov_3.394231_g50551_i0 | PRJNA608660 | 50908 | 153 | 3.394231 | 5.19317343 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 89 | 2.89e-19 | NR | MBC7466874.1 | 28201 | g50551 | i0 | 87.2 | 2.76470588235294 | 47 | 6 | 92.2 | 0 | 12 | 152 | 33 | 79 | MBC7466874.1 metallophosphoesterase [Bdellovibrio sp.] | diamond | 423 | 89 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 29777279 | 29777279 | PRJNA608660_P_NODE_5931_length_603_cov_1.593863_g5620_i0 | PRJNA608660 | 5931 | 603 | 1.593863 | 9.61099389 | Bdellovibrio | 958 | Bacteria | Bacteria | 147 | 4.5e-40 | NR | MBC7464632.1 | 28201 | g5620 | i0 | 61.9 | 1.11940298507463 | 113 | 43 | 56.2 | 0 | 601 | 263 | 147 | 259 | MBC7464632.1 AgmX/PglI C-terminal domain-containing protein [Bdellovibrio sp.] | diamond | 675 | 147 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 30048340 | 30048340 | PRJNA608660_P_NODE_6991_length_562_cov_13.411306_g6664_i0 | PRJNA608660 | 6991 | 562 | 13.411306 | 75.37153972 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 174 | 1.02e-46 | NR | MBC7465812.1 | 28201 | g6664 | i0 | 46.4 | 1.02491103202847 | 192 | 92 | 96.6 | 2 | 552 | 10 | 601 | 792 | MBC7465812.1 hypothetical protein [Bdellovibrio sp.] | diamond | 576 | 174 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 30301748 | 30301748 | PRJNA608660_P_NODE_11612_length_436_cov_33.529716_g11265_i0 | PRJNA608660 | 11612 | 436 | 33.529716 | 146.18956176 | Bdellovibrio sp. ArHS | 1569284 | Bacteria | Bacteria | 182 | 7.209999999999998e-54 | NR | WP_041872138.1 | 1569284 | g11265 | i0 | 64.1 | 3.99082568807339 | 145 | 51 | 99.1 | 1 | 5 | 436 | 7 | 151 | WP_041872138.1 hydroxymethylglutaryl-CoA lyase [Bdellovibrio sp. ArHS] | diamond | 1740 | 182 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. ArHS | ||
| 30301752 | 30301752 | PRJNA608660_P_NODE_7032_length_561_cov_2.542969_g6705_i0 | PRJNA608660 | 7032 | 561 | 2.542969 | 14.26605609 | Bdellovibrionales bacterium RIFCSPHIGHO2_ | 2053517 | Bacteria | Bacteria | 211 | 2.63e-60 | NR | OFZ31493.1 | 1797389 | g6705 | i0 | 63.3 | 0.903743315508021 | 169 | 62 | 90.4 | 0 | 554 | 48 | 187 | 355 | OFZ31493.1 MAG: hypothetical protein A2622_02600 [Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29] | diamond | 507 | 211 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29 | ||||
| 30680216 | 30680216 | PRJNA608660_P_NODE_15473_length_370_cov_16.171340_g15120_i0 | PRJNA608660 | 15473 | 370 | 16.17134 | 59.833958 | Bdellovibrionales bacterium RIFOXYC1_FULL_54_43 | 1797397 | Bacteria | Bacteria | 88.2 | 1.65e-18 | NR | OFZ55204.1 | 1797397 | g15120 | i0 | 46.7 | 1.48378378378378 | 90 | 48 | 73 | 0 | 87 | 356 | 32 | 121 | OFZ55204.1 MAG: hypothetical protein A2428_17145 [Bdellovibrionales bacterium RIFOXYC1_FULL_54_43] | diamond | 549 | 88.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFOXYC1_FULL_54_43 | ||||
| 30820003 | 30820003 | PRJNA608660_P_NODE_11654_length_435_cov_11.536269_g11307_i0 | PRJNA608660 | 11654 | 435 | 11.536269 | 50.18277015 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 63.9 | 1.16e-8 | NR | MBI4925345.1 | 28201 | g11307 | i0 | 36.8 | 1.49655172413793 | 68 | 43 | 46.9 | 0 | 240 | 37 | 454 | 521 | MBI4925345.1 TonB-dependent receptor [Bdellovibrio sp.] | diamond | 651 | 63.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 31597365 | 31597365 | PRJNA608660_P_NODE_50836_length_154_cov_2.533333_g50479_i0 | PRJNA608660 | 50836 | 154 | 2.533333 | 3.90133282 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 52.8 | 3.24e-6 | NR | MBC7467136.1 | 28201 | g50479 | i0 | 62.2 | 1.44155844155844 | 37 | 14 | 72.1 | 0 | 43 | 153 | 309 | 345 | MBC7467136.1 lytic transglycosylase domain-containing protein [Bdellovibrio sp.] | diamond | 222 | 52.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 31628721 | 31628721 | PRJNA608660_P_NODE_44036_length_174_cov_1.168000_g43679_i0 | PRJNA608660 | 44036 | 174 | 1.168 | 2.03232 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 84.7 | 2.18e-17 | NR | GIL17845.1 | 2599941 | g43679 | i0 | 72.4 | 1 | 58 | 15 | 100 | 1 | 174 | 1 | 50 | 106 | GIL17845.1 MAG: serine protease [Oligoflexia bacterium] | diamond | 174 | 84.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 31723559 | 31723559 | PRJNA608660_P_NODE_4657_length_668_cov_14.555735_g4365_i0 | PRJNA608660 | 4657 | 668 | 14.555735 | 97.2323098 | Bdellovibrio | 958 | Bacteria | Bacteria | 102 | 2.84e-24 | NR | WP_374074086.1 | 958 | g4365 | i0 | 70.3 | 0.332335329341317 | 74 | 21 | 32.8 | 1 | 40 | 258 | 1 | 74 | WP_374074086.1 MULTISPECIES: Sec-independent protein translocase subunit TatA/TatB [Bdellovibrio] | diamond | 222 | 102 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | |||
| 32103230 | 32103230 | PRJNA608660_P_NODE_41818_length_181_cov_2.022727_g41461_i0 | PRJNA608660 | 41818 | 181 | 2.022727 | 3.66113587 | Bdellovibrio | 958 | Bacteria | Bacteria | 80.1 | 1.9e-16 | NR | WP_347358122.1 | 958 | g41461 | i0 | 67.2 | 0.961325966850829 | 58 | 19 | 96.1 | 0 | 179 | 6 | 30 | 87 | WP_347358122.1 MULTISPECIES: coenzyme F420-0:L-glutamate ligase [Bdellovibrio] | diamond | 174 | 80.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | |||
| 32685239 | 32685239 | PRJNA608660_P_NODE_46060_length_168_cov_1.436975_g45703_i0 | PRJNA608660 | 46060 | 168 | 1.436975 | 2.414118 | Pseudobdellovibrionaceae | 213483 | Bacteria | Bacteria | 97.4 | 1.0300000000000001e-22 | NR | MBC7465590.1 | 28201 | g45703 | i0 | 82.1 | 2.96428571428571 | 56 | 10 | 100 | 0 | 168 | 1 | 150 | 205 | MBC7465590.1 phosphate/phosphite/phosphonate ABC transporter substrate-binding protein [Bdellovibrio sp.] | diamond | 498 | 97.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio 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);;