contig_metadata
24 rows where bioproject = "PRJNA853203", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 841435 | 841435 | PRJNA853203_P_NODE_30581_length_251_cov_0.876404_g30432_i0 | PRJNA853203 | 30581 | 251 | 0.876404 | 2.19977404 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 91.7 | 1.5700000000000001e-19 | NR | MCC7405359.1 | 2053517 | g30432 | i0 | 50.6 | 1.67330677290837 | 83 | 41 | 99.2 | 0 | 3 | 251 | 81 | 163 | MCC7405359.1 S8 family serine peptidase [Bdellovibrionales bacterium] | diamond | 420 | 91.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 2116967 | 2116967 | PRJNA853203_P_NODE_5142_length_333_cov_0.900000_g4993_i0 | PRJNA853203 | 5142 | 333 | 0.9 | 2.997 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 333 | 1e-86 | NTclustered | gi|2258818259|gb|CP060220.1| | 2026715 | g4993 | i0 | 85.849 | 4.94294294294294 | 318 | 40 | 95 | 3 | 1 | 317 | 3251283 | 3251596 | MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome | blastn | 1646 | 333 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 10163238 | 10163238 | PRJNA853203_P_NODE_50368_length_203_cov_4.230769_g50219_i0 | PRJNA853203 | 50368 | 203 | 4.230769 | 8.58846107 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 130 | 6.62e-34 | NR | MBY0517277.1 | 2081706 | g50219 | i0 | 92.5 | 0.990147783251232 | 67 | 5 | 99 | 0 | 3 | 203 | 63 | 129 | MBY0517277.1 sodium:alanine symporter family protein [Bacteriovoracaceae bacterium] | diamond | 201 | 130 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 17419786 | 17419786 | PRJNA853203_P_NODE_49094_length_234_cov_2.881988_g48945_i0 | PRJNA853203 | 49094 | 234 | 2.881988 | 6.74385192 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 74.3 | 9.06e-14 | NR | MFL5785836.1 | 2081706 | g48945 | i0 | 63.5 | 0.666666666666667 | 52 | 19 | 66.7 | 0 | 5 | 160 | 193 | 244 | MFL5785836.1 DNA-formamidopyrimidine glycosylase family protein [Bacteriovoracaceae bacterium] | diamond | 156 | 74.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 21636764 | 21636764 | PRJNA853203_P_NODE_32157_length_250_cov_0.881356_g32008_i0 | PRJNA853203 | 32157 | 250 | 0.881356 | 2.20339 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 126 | 6.25e-33 | NR | MCC7403422.1 | 2053517 | g32008 | i0 | 71.6 | 1.908 | 81 | 23 | 97.2 | 0 | 248 | 6 | 252 | 332 | MCC7403422.1 D-glycero-beta-D-manno-heptose-7-phosphate kinase [Bdellovibrionales bacterium] | diamond | 477 | 126 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27149413 | 27149413 | PRJNA853203_P_NODE_41262_length_245_cov_0.906977_g41113_i0 | PRJNA853203 | 41262 | 245 | 0.906977 | 2.22209365 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 86.3 | 2.54e-19 | NR | MBY0415735.1 | 2053517 | g41113 | i0 | 50.6 | 0.991836734693878 | 81 | 40 | 99.2 | 0 | 243 | 1 | 21 | 101 | MBY0415735.1 universal stress protein [Bdellovibrionales bacterium] | diamond | 243 | 86.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27347898 | 27347898 | PRJNA853203_P_NODE_43023_length_244_cov_1.257310_g42874_i0 | PRJNA853203 | 43023 | 244 | 1.25731 | 3.0678364 | Bdellovibrio | 958 | Bacteria | Bacteria | 119 | 1.05e-31 | NR | WP_284605181.1 | 958 | g42874 | i0 | 65.4 | 9.95901639344262 | 81 | 28 | 99.6 | 0 | 2 | 244 | 74 | 154 | WP_284605181.1 MULTISPECIES: HIT family protein [Bdellovibrio] | diamond | 2430 | 119 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | |||
| 27844536 | 27844536 | PRJNA853203_P_NODE_17724_length_271_cov_1.424242_g17575_i0 | PRJNA853203 | 17724 | 271 | 1.424242 | 3.8596958200000002 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 65.5 | 5.03e-10 | NR | MBX3021255.1 | 2053517 | g17575 | i0 | 50.8 | 0.675276752767528 | 61 | 30 | 67.5 | 0 | 184 | 2 | 17 | 77 | MBX3021255.1 oligosaccharide flippase family protein [Bdellovibrionales bacterium] | diamond | 183 | 65.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28286536 | 28286536 | PRJNA853203_P_NODE_21146_length_264_cov_1.062827_g20997_i0 | PRJNA853203 | 21146 | 264 | 1.062827 | 2.80586328 | Halobacteriovorax sp. HLS | 2234000 | Bacteria | Bacteria | 90.5 | 7.99e-20 | NR | WP_127716242.1 | 2234000 | g20997 | i0 | 58.1 | 0.840909090909091 | 74 | 27 | 84.1 | 1 | 250 | 29 | 26 | 95 | WP_127716242.1 substrate-binding periplasmic protein [Halobacteriovorax sp. HLS] | diamond | 222 | 90.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax sp. HLS | ||
| 28349880 | 28349880 | PRJNA853203_P_NODE_46386_length_243_cov_0.858824_g46237_i0 | PRJNA853203 | 46386 | 243 | 0.858824 | 2.08694232 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 55.8 | 4.71e-7 | NR | MBX3021024.1 | 2053517 | g46237 | i0 | 71.4 | 0.432098765432099 | 35 | 10 | 43.2 | 0 | 106 | 2 | 1 | 35 | MBX3021024.1 endonuclease III [Bdellovibrionales bacterium] | diamond | 105 | 55.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28484448 | 28484448 | PRJNA853203_P_NODE_26766_length_253_cov_0.866667_g26617_i0 | PRJNA853203 | 26766 | 253 | 0.866667 | 2.19266751 | Bdellovibrio | 958 | Bacteria | Bacteria | 80.9 | 4.48e-16 | NR | WP_374074901.1 | 958 | g26617 | i0 | 51.2 | 2.05138339920949 | 86 | 40 | 99.6 | 2 | 2 | 253 | 59 | 144 | WP_374074901.1 MULTISPECIES: cysteine hydrolase family protein [Bdellovibrio] | diamond | 519 | 81.3 | 0.995079950799508 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | |||
| 29013259 | 29013259 | PRJNA853203_P_NODE_10068_length_289_cov_1.199074_g9919_i0 | PRJNA853203 | 10068 | 289 | 1.199074 | 3.46532386 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 137 | 5.87e-40 | NR | MBX3040068.1 | 2026715 | g9919 | i0 | 72.8 | 0.84083044982699 | 81 | 22 | 84.1 | 0 | 253 | 11 | 4 | 84 | MBX3040068.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 243 | 137 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29139555 | 29139555 | PRJNA853203_P_NODE_40589_length_245_cov_2.250000_g40440_i0 | PRJNA853203 | 40589 | 245 | 2.25 | 5.5125 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 174 | 1.77e-50 | NR | WP_408098179.1 | 3383025 | g40440 | i0 | 96.3 | 0.991836734693878 | 81 | 3 | 99.2 | 0 | 245 | 3 | 28 | 108 | WP_408098179.1 acetyl-CoA carboxylase biotin carboxylase subunit [Peredibacter sp. HCB2-198] | diamond | 243 | 174 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 29833887 | 29833887 | PRJNA853203_P_NODE_45391_length_243_cov_0.917647_g45242_i0 | PRJNA853203 | 45391 | 243 | 0.917647 | 2.22988221 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 68.2 | 2.59e-11 | NR | WP_015470256.1 | 453816 | g45242 | i0 | 60 | 1.45679012345679 | 60 | 17 | 71.6 | 2 | 1 | 174 | 239 | 293 | WP_015470256.1 tRNA pseudouridine(55) synthase TruB [Pseudobdellovibrio exovorus] | diamond | 354 | 68.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 29991896 | 29991896 | PRJNA853203_P_NODE_35111_length_248_cov_1.782857_g34962_i0 | PRJNA853203 | 35111 | 248 | 1.782857 | 4.42148536 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 102 | 4.06e-25 | NR | MBX3022022.1 | 2053517 | g34962 | i0 | 64.1 | 0.943548387096774 | 78 | 28 | 94.4 | 0 | 247 | 14 | 28 | 105 | MBX3022022.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Bdellovibrionales bacterium] | diamond | 234 | 102 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30371420 | 30371420 | PRJNA853203_P_NODE_20852_length_264_cov_1.633508_g20703_i0 | PRJNA853203 | 20852 | 264 | 1.633508 | 4.31246112 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 87.8 | 6.76e-18 | NR | HVK62061.1 | 2053517 | g20703 | i0 | 55.3 | 0.965909090909091 | 85 | 36 | 96.6 | 1 | 259 | 5 | 889 | 971 | HVK62061.1 Ig-like domain-containing protein [Bdellovibrionales bacterium] | diamond | 255 | 87.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30600231 | 30600231 | PRJNA853203_P_NODE_18473_length_269_cov_1.897959_g18324_i0 | PRJNA853203 | 18473 | 269 | 1.897959 | 5.10550971 | Bdellovibrio | 958 | Bacteria | Bacteria | 164 | 3.12e-50 | NR | MBC7466343.1 | 28201 | g18324 | i0 | 84.3 | 1.98513011152416 | 89 | 14 | 99.3 | 0 | 267 | 1 | 34 | 122 | MBC7466343.1 Co2+/Mg2+ efflux protein ApaG [Bdellovibrio sp.] | diamond | 534 | 165 | 0.993939393939394 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 30750174 | 30750174 | PRJNA853203_P_NODE_15334_length_276_cov_1.605911_g15185_i0 | PRJNA853203 | 15334 | 276 | 1.605911 | 4.43231436 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 125 | 1.1699999999999998e-31 | NR | MEK6773043.1 | 3034175 | g15185 | i0 | 63.7 | 0.989130434782609 | 91 | 33 | 98.9 | 0 | 4 | 276 | 105 | 195 | MEK6773043.1 metallophosphoesterase [Bdellovibrionota bacterium] | diamond | 273 | 125 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 30758375 | 30758375 | PRJNA853203_P_NODE_20254_length_266_cov_1.025907_g20105_i0 | PRJNA853203 | 20254 | 266 | 1.025907 | 2.72891262 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 114 | 4.44e-27 | NR | MBC7692375.1 | 2599941 | g20105 | i0 | 81.2 | 2.33458646616541 | 69 | 13 | 77.8 | 0 | 59 | 265 | 327 | 395 | MBC7692375.1 fatty acid oxidation complex subunit alpha FadB [Oligoflexia bacterium] | diamond | 621 | 115 | 0.991304347826087 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 30844997 | 30844997 | PRJNA853203_P_NODE_45714_length_243_cov_0.917647_g45565_i0 | PRJNA853203 | 45714 | 243 | 0.917647 | 2.22988221 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 137 | 4.5299999999999997e-38 | NR | HMN69334.1 | 2053517 | g45565 | i0 | 78.8 | 2.93827160493827 | 80 | 17 | 98.8 | 0 | 2 | 241 | 81 | 160 | HMN69334.1 type I methionyl aminopeptidase [Bdellovibrionales bacterium] | diamond | 714 | 137 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31002971 | 31002971 | PRJNA853203_P_NODE_30114_length_251_cov_0.915730_g29965_i0 | PRJNA853203 | 30114 | 251 | 0.91573 | 2.2984823 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 108 | 1.6700000000000002e-26 | NR | MBX3021415.1 | 2053517 | g29965 | i0 | 65 | 0.956175298804781 | 80 | 27 | 95.6 | 1 | 3 | 242 | 113 | 191 | MBX3021415.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 240 | 108 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31382353 | 31382353 | PRJNA853203_P_NODE_46956_length_242_cov_1.325444_g46807_i0 | PRJNA853203 | 46956 | 242 | 1.325444 | 3.20757448 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 122 | 1.16e-30 | NR | MDQ3235709.1 | 2026715 | g46807 | i0 | 72.8 | 1.00413223140496 | 81 | 21 | 99.2 | 1 | 241 | 2 | 338 | 418 | MDQ3235709.1 O-antigen ligase family protein [Pseudobdellovibrionaceae bacterium] | diamond | 243 | 122 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 32394646 | 32394646 | PRJNA853203_P_NODE_32419_length_250_cov_0.881356_g32270_i0 | PRJNA853203 | 32419 | 250 | 0.881356 | 2.20339 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 45.4 | 0.00447 | NR | MBX2988663.1 | 2026715 | g32270 | i0 | 35.9 | 0.936 | 78 | 46 | 92.4 | 3 | 19 | 249 | 6 | 80 | MBX2988663.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 234 | 45.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 32646922 | 32646922 | PRJNA853203_P_NODE_30960_length_251_cov_0.876404_g30811_i0 | PRJNA853203 | 30960 | 251 | 0.876404 | 2.19977404 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 84 | 1.27e-16 | NR | MBA2404122.1 | 2053517 | g30811 | i0 | 86.5 | 0.621513944223108 | 52 | 7 | 62.2 | 0 | 250 | 95 | 128 | 179 | MBA2404122.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 156 | 84 | 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);;