contig_metadata
27 rows where bioproject = "PRJNA1144090", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 287558 | 287558 | PRJNA1144090_P_NODE_66101_length_311_cov_3.159664_g65566_i0 | PRJNA1144090 | 66101 | 311 | 3.159664 | 9.82655504 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 148 | 8.57e-41 | NR | MDC1174166.1 | 2081706 | g65566 | i0 | 68 | 1.98713826366559 | 103 | 33 | 99.4 | 0 | 309 | 1 | 242 | 344 | MDC1174166.1 thiolase family protein [Bacteriovoracaceae bacterium] | diamond | 618 | 149 | 0.993288590604027 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 5390280 | 5390280 | PRJNA1144090_P_NODE_21465_length_583_cov_8.570588_g20940_i0 | PRJNA1144090 | 21465 | 583 | 8.570588 | 49.96652804 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 217 | 1.51e-68 | NR | MCB0379075.1 | 2053517 | g20940 | i0 | 63.5 | 1.70840480274443 | 167 | 55 | 84.4 | 3 | 492 | 1 | 3 | 166 | MCB0379075.1 superoxide dismutase [Bdellovibrionales bacterium] | diamond | 996 | 217 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 5391082 | 5391082 | PRJNA1144090_P_NODE_94625_length_257_cov_2.510870_g94090_i0 | PRJNA1144090 | 94625 | 257 | 2.51087 | 6.4529359 | Oligoflexales bacterium | 2687297 | Bacteria | Bacteria | 91.7 | 5.25e-20 | NR | MFK7873693.1 | 2687297 | g94090 | i0 | 50.6 | 2.76653696498054 | 83 | 40 | 96.9 | 1 | 253 | 5 | 104 | 185 | MFK7873693.1 inositol oxygenase family protein [Oligoflexales bacterium] | diamond | 711 | 91.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexales bacterium | ||||
| 19412850 | 19412850 | PRJNA1144090_P_NODE_104596_length_248_cov_0.880000_g104061_i0 | PRJNA1144090 | 104596 | 248 | 0.88 | 2.1824 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 159 | 2.03e-44 | NR | PZP54047.1 | 349221 | g104061 | i0 | 93.9 | 0.991935483870968 | 82 | 5 | 99.2 | 0 | 1 | 246 | 94 | 175 | PZP54047.1 MAG: peptidase S41 [Micavibrio aeruginosavorus] | diamond | 246 | 159 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 25259284 | 25259284 | PRJNA1144090_P_NODE_105120_length_247_cov_2.609195_g104585_i0 | PRJNA1144090 | 105120 | 247 | 2.609195 | 6.44471165 | Micavibrio | 213485 | Bacteria | Bacteria | 457 | 4.05e-124 | NTclustered | gi|469926873|gb|CP003538.1| | 349215 | g104585 | i0 | 100 | 202.485829959514 | 247 | 0 | 100 | 0 | 1 | 247 | 463271 | 463025 | Micavibrio aeruginosavorus EPB, complete genome | blastn | 50014 | 457 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 26627329 | 26627329 | PRJNA1144090_P_NODE_65081_length_314_cov_1.763485_g64546_i0 | PRJNA1144090 | 65081 | 314 | 1.763485 | 5.5373429 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 44.7 | 0.0183 | NR | MBF0315679.1 | 2599941 | g64546 | i0 | 25.6 | 0.859872611464968 | 90 | 67 | 86 | 0 | 7 | 276 | 175 | 264 | MBF0315679.1 hypothetical protein [Oligoflexia bacterium] | diamond | 270 | 44.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 26721886 | 26721886 | PRJNA1144090_P_NODE_64521_length_315_cov_3.061983_g63986_i0 | PRJNA1144090 | 64521 | 315 | 3.061983 | 9.64524645 | Halobacteriovorax marinus | 97084 | Bacteria | Bacteria | 118 | 4.1e-29 | NR | WP_096908312.1 | 97084 | g63986 | i0 | 62.5 | 0.838095238095238 | 88 | 33 | 83.8 | 0 | 269 | 6 | 6 | 93 | WP_096908312.1 thiolase family protein [Halobacteriovorax marinus] | diamond | 264 | 118 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax marinus | ||
| 26774764 | 26774764 | PRJNA1144090_P_NODE_86161_length_271_cov_1.555556_g85626_i0 | PRJNA1144090 | 86161 | 271 | 1.555556 | 4.21555676 | Bacteria | 2 | Bacteria | Bacteria | 60.8 | 2.27e-8 | NR | MCB0419810.1 | 2053517 | g85626 | i0 | 40 | 2.97785977859779 | 90 | 50 | 95.2 | 2 | 262 | 5 | 676 | 765 | MCB0419810.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 807 | 60.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 26817466 | 26817466 | PRJNA1144090_P_NODE_114141_length_242_cov_0.911243_g113606_i0 | PRJNA1144090 | 114141 | 242 | 0.911243 | 2.20520806 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 132 | 5.47e-34 | NR | MBA2404931.1 | 2053517 | g113606 | i0 | 75 | 0.991735537190083 | 80 | 20 | 99.2 | 0 | 240 | 1 | 211 | 290 | MBA2404931.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 240 | 132 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27196779 | 27196779 | PRJNA1144090_P_NODE_78342_length_285_cov_1.377358_g77807_i0 | PRJNA1144090 | 78342 | 285 | 1.377358 | 3.9254703 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 67.8 | 9.33e-11 | NR | MBQ46975.1 | 2026715 | g77807 | i0 | 38.4 | 1.04210526315789 | 99 | 57 | 100 | 2 | 1 | 285 | 153 | 251 | MBQ46975.1 MFS transporter [Pseudobdellovibrionaceae bacterium] | diamond | 297 | 67.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 27386735 | 27386735 | PRJNA1144090_P_NODE_34723_length_442_cov_1.403794_g34188_i0 | PRJNA1144090 | 34723 | 442 | 1.403794 | 6.20476948 | Oligoflexales bacterium | 2687297 | Bacteria | Bacteria | 65.9 | 2.57e-9 | NR | MFK7826995.1 | 2687297 | g34188 | i0 | 43.5 | 0.468325791855204 | 69 | 39 | 46.8 | 0 | 108 | 314 | 95 | 163 | MFK7826995.1 FAD-dependent oxidoreductase [Oligoflexales bacterium] | diamond | 207 | 65.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexales bacterium | ||||
| 27607767 | 27607767 | PRJNA1144090_P_NODE_98264_length_252_cov_1.709497_g97729_i0 | PRJNA1144090 | 98264 | 252 | 1.709497 | 4.30793244 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 49.7 | 1.5e-4 | NR | MAM33505.1 | 2024841 | g97729 | i0 | 36.6 | 0.976190476190476 | 82 | 45 | 97.6 | 2 | 5 | 250 | 728 | 802 | MAM33505.1 hypothetical protein [Micavibrio sp.] | diamond | 246 | 49.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 28512179 | 28512179 | PRJNA1144090_P_NODE_105727_length_247_cov_0.885057_g105192_i0 | PRJNA1144090 | 105727 | 247 | 0.885057 | 2.18609079 | Bdellovibrio | 958 | Bacteria | Bacteria | 68.9 | 2.31e-11 | NR | PIS11894.1 | 1975526 | g105192 | i0 | 50.6 | 2.65991902834008 | 77 | 36 | 92.3 | 2 | 229 | 2 | 59 | 134 | PIS11894.1 MAG: hypothetical protein COT73_01520 [Bdellovibrio sp. CG10_big_fil_rev_8_21_14_0_10_47_8] | diamond | 657 | 68.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. CG10_big_fil_rev_8_21_14_0_10_47_8 | ||
| 28796174 | 28796174 | PRJNA1144090_P_NODE_116967_length_240_cov_2.754491_g116432_i0 | PRJNA1144090 | 116967 | 240 | 2.754491 | 6.6107784 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 114 | 3.41e-30 | NR | MFN7455157.1 | 2026715 | g116432 | i0 | 60.8 | 3.9125 | 79 | 31 | 98.8 | 0 | 2 | 238 | 39 | 117 | MFN7455157.1 lipocalin family protein [Pseudobdellovibrionaceae bacterium] | diamond | 939 | 114 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29123466 | 29123466 | PRJNA1144090_P_NODE_78129_length_285_cov_1.952830_g77594_i0 | PRJNA1144090 | 78129 | 285 | 1.95283 | 5.5655655 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 69.7 | 2.06e-11 | NR | HXH31984.1 | 2081706 | g77594 | i0 | 45.9 | 0.778947368421053 | 74 | 40 | 77.9 | 0 | 34 | 255 | 548 | 621 | HXH31984.1 NAD-dependent DNA ligase LigA [Bacteriovoracaceae bacterium] | diamond | 222 | 69.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29312635 | 29312635 | PRJNA1144090_P_NODE_90649_length_263_cov_2.947368_g90114_i0 | PRJNA1144090 | 90649 | 263 | 2.947368 | 7.75157784 | Halobacteriovoraceae bacterium | 2026745 | Bacteria | Bacteria | 42.4 | 0.0332 | NR | MAW06827.1 | 2026745 | g90114 | i0 | 36.5 | 0.844106463878327 | 74 | 36 | 84.4 | 1 | 226 | 5 | 13 | 75 | MAW06827.1 hypothetical protein [Halobacteriovoraceae bacterium] | diamond | 222 | 42.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 29659433 | 29659433 | PRJNA1144090_P_NODE_105670_length_247_cov_0.885057_g105135_i0 | PRJNA1144090 | 105670 | 247 | 0.885057 | 2.18609079 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 129 | 3.56e-35 | NR | PZP55324.1 | 349221 | g105135 | i0 | 77.5 | 0.97165991902834 | 80 | 18 | 97.2 | 0 | 7 | 246 | 86 | 165 | PZP55324.1 MAG: peptidoglycan editing factor PgeF [Micavibrio aeruginosavorus] | diamond | 240 | 129 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 29691142 | 29691142 | PRJNA1144090_P_NODE_57590_length_334_cov_5.413793_g57055_i0 | PRJNA1144090 | 57590 | 334 | 5.413793 | 18.08206862 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 138 | 8.029999999999999e-37 | NR | MBU6152952.1 | 2053517 | g57055 | i0 | 61.5 | 1.86826347305389 | 104 | 40 | 93.4 | 0 | 22 | 333 | 1 | 104 | MBU6152952.1 cystathionine gamma-synthase [Bdellovibrionales bacterium] | diamond | 624 | 138 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30196651 | 30196651 | PRJNA1144090_P_NODE_104552_length_248_cov_0.880000_g104017_i0 | PRJNA1144090 | 104552 | 248 | 0.88 | 2.1824 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 54.7 | 2.27e-6 | NR | MBK7891157.1 | 2053517 | g104017 | i0 | 44.4 | 1.57258064516129 | 63 | 33 | 73.8 | 1 | 195 | 13 | 281 | 343 | MBK7891157.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 390 | 54.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30228360 | 30228360 | PRJNA1144090_P_NODE_121632_length_201_cov_4.343750_g121097_i0 | PRJNA1144090 | 121632 | 201 | 4.34375 | 8.7309375 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 52.8 | 6.37e-6 | NR | WP_015468752.1 | 453816 | g121097 | i0 | 39.4 | 1.05970149253731 | 71 | 38 | 98.5 | 2 | 1 | 198 | 314 | 384 | WP_015468752.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus] | diamond | 213 | 52.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 30797050 | 30797050 | PRJNA1144090_P_NODE_101574_length_250_cov_0.870056_g101039_i0 | PRJNA1144090 | 101574 | 250 | 0.870056 | 2.17514 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 114 | 3.3200000000000005e-27 | NR | PZP54292.1 | 349221 | g101039 | i0 | 67.9 | 0.972 | 81 | 26 | 97.2 | 0 | 245 | 3 | 553 | 633 | PZP54292.1 MAG: type II and III secretion system family protein [Micavibrio aeruginosavorus] | diamond | 243 | 114 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 31018429 | 31018429 | PRJNA1144090_P_NODE_70495_length_301_cov_1.986842_g69960_i0 | PRJNA1144090 | 70495 | 301 | 1.986842 | 5.98039442 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 72 | 2.1e-12 | NR | HLD75282.1 | 3034175 | g69960 | i0 | 59.4 | 3.47840531561462 | 64 | 26 | 63.8 | 0 | 299 | 108 | 236 | 299 | HLD75282.1 TerC family protein [Bdellovibrionota bacterium] | diamond | 1047 | 72 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31461196 | 31461196 | PRJNA1144090_P_NODE_60916_length_325_cov_1.833333_g60381_i0 | PRJNA1144090 | 60916 | 325 | 1.833333 | 5.95833225 | Silvanigrellales bacterium | 2767476 | Bacteria | Bacteria | 47.4 | 0.00212 | NR | MCA2961534.1 | 2767476 | g60381 | i0 | 27.2 | 0.747692307692308 | 81 | 59 | 74.8 | 0 | 54 | 296 | 47 | 127 | MCA2961534.1 VCBS repeat-containing protein [Silvanigrellales bacterium] | diamond | 243 | 47.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellales bacterium | ||||
| 31587604 | 31587604 | PRJNA1144090_P_NODE_22116_length_574_cov_2.796407_g21590_i0 | PRJNA1144090 | 22116 | 574 | 2.796407 | 16.05137618 | Silvanigrella paludirubra | 2499159 | Bacteria | Bacteria | 53.5 | 1.3e-4 | NR | WP_153418714.1 | 2499159 | g21590 | i0 | 38.5 | 0.339721254355401 | 65 | 38 | 34 | 1 | 3 | 197 | 145 | 207 | WP_153418714.1 RCC1 domain-containing protein [Silvanigrella paludirubra] | diamond | 195 | 53.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrella | Silvanigrella paludirubra | ||
| 31608066 | 31608066 | PRJNA1144090_P_NODE_37256_length_424_cov_4.792023_g36721_i0 | PRJNA1144090 | 37256 | 424 | 4.792023 | 20.31817752 | Bdellovibrio | 958 | Bacteria | Bacteria | 209 | 6.950000000000001e-64 | NR | WP_041873635.1 | 1569284 | g36721 | i0 | 70 | 18.9198113207547 | 140 | 42 | 99.1 | 0 | 423 | 4 | 234 | 373 | WP_041873635.1 cystathionine gamma-synthase [Bdellovibrio sp. ArHS] | diamond | 8022 | 211 | 0.990521327014218 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. ArHS | ||
| 32725660 | 32725660 | PRJNA1144090_P_NODE_106460_length_247_cov_0.885057_g105925_i0 | PRJNA1144090 | 106460 | 247 | 0.885057 | 2.18609079 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 96.3 | 8.4e-22 | NR | PZP55800.1 | 349221 | g105925 | i0 | 63.8 | 0.97165991902834 | 80 | 29 | 97.2 | 0 | 245 | 6 | 223 | 302 | PZP55800.1 MAG: hypothetical protein DI586_05730 [Micavibrio aeruginosavorus] | diamond | 240 | 96.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 32757193 | 32757193 | PRJNA1144090_P_NODE_75020_length_291_cov_4.426606_g74485_i0 | PRJNA1144090 | 75020 | 291 | 4.426606 | 12.88142346 | Oligoflexus tunisiensis | 708132 | Bacteria | Bacteria | 48.5 | 3.83e-4 | NR | WP_141736481.1 | 708132 | g74485 | i0 | 35.5 | 0.783505154639175 | 76 | 45 | 78.4 | 1 | 23 | 250 | 35 | 106 | WP_141736481.1 EcsC family protein [Oligoflexus tunisiensis] | diamond | 228 | 48.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus tunisiensis |
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);;