contig_metadata
23 rows where bioproject = "PRJNA896554", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2146011 | 2146011 | PRJNA896554_P_NODE_155762_length_249_cov_0.875000_g148222_i0 | PRJNA896554 | 155762 | 249 | 0.875 | 2.17875 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 151 | 8.8e-45 | NR | MCB0370127.1 | 2053517 | g148222 | i0 | 93.5 | 0.927710843373494 | 77 | 5 | 92.8 | 0 | 232 | 2 | 31 | 107 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 231 | 151 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 3421788 | 3421788 | PRJNA896554_P_NODE_174203_length_241_cov_1.351190_g166663_i0 | PRJNA896554 | 174203 | 241 | 1.35119 | 3.2563679 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 141 | 1.0999999999999999e-38 | NR | MEZ4814640.1 | 3034175 | g166663 | i0 | 85 | 6.70954356846473 | 80 | 10 | 99.6 | 1 | 240 | 1 | 53 | 130 | MEZ4814640.1 S-(hydroxymethyl)glutathione dehydrogenase/class III alcohol dehydrogenase [Bdellovibrionota bacterium] | diamond | 1617 | 141 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 5071780 | 5071780 | PRJNA896554_P_NODE_123324_length_286_cov_1.276995_g115784_i0 | PRJNA896554 | 123324 | 286 | 1.276995 | 3.6522057 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 178 | 8.62e-50 | NR | MBX3020485.1 | 2053517 | g115784 | i0 | 98.9 | 2.95804195804196 | 94 | 1 | 98.6 | 0 | 284 | 3 | 385 | 478 | MBX3020485.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Bdellovibrionales bacterium] | diamond | 846 | 178 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 7249152 | 7249152 | PRJNA896554_P_NODE_173186_length_242_cov_0.911243_g165646_i0 | PRJNA896554 | 173186 | 242 | 0.911243 | 2.20520806 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 141 | 5.02e-39 | NR | HEY8280637.1 | 3034175 | g165646 | i0 | 93.8 | 0.991735537190083 | 80 | 5 | 99.2 | 0 | 242 | 3 | 119 | 198 | HEY8280637.1 class II fructose-bisphosphatase [Bdellovibrionota bacterium] | diamond | 240 | 141 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 11447488 | 11447488 | PRJNA896554_P_NODE_138109_length_265_cov_1.604167_g130569_i0 | PRJNA896554 | 138109 | 265 | 1.604167 | 4.25104255 | Halobacteriovorax | 1652133 | Bacteria | Bacteria | 156 | 1.7900000000000002e-33 | NTclustered | gi|1249980216|gb|CP017414.1| | 97084 | g130569 | i0 | 78.088 | 34.9358490566038 | 251 | 51 | 94 | 4 | 1 | 249 | 2043772 | 2043524 | Halobacteriovorax marinus strain BE01 chromosome, complete genome | blastn | 9258 | 156 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax marinus | ||
| 13625207 | 13625207 | PRJNA896554_P_NODE_43871_length_790_cov_2.152022_g36681_i0 | PRJNA896554 | 43871 | 790 | 2.152022 | 17.0009738 | Bdellovibrionales bacterium GWA1_52_35 | 1797383 | Bacteria | Bacteria | 59.7 | 3.96e-6 | NR | OFZ02782.1 | 1797383 | g36681 | i0 | 36.8 | 0.330379746835443 | 87 | 54 | 33 | 1 | 784 | 524 | 432 | 517 | OFZ02782.1 MAG: hypothetical protein A2X97_04205 [Bdellovibrionales bacterium GWA1_52_35] | diamond | 261 | 59.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium GWA1_52_35 | ||||
| 16175007 | 16175007 | PRJNA896554_P_NODE_79633_length_402_cov_1.124620_g72093_i0 | PRJNA896554 | 79633 | 402 | 1.12462 | 4.5209724 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 203 | 2.13e-60 | NR | MCB0370360.1 | 2053517 | g72093 | i0 | 79.1 | 1 | 134 | 25 | 97.8 | 1 | 395 | 3 | 276 | 409 | MCB0370360.1 HAD-IC family P-type ATPase [Bdellovibrionales bacterium] | diamond | 402 | 203 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 23824511 | 23824511 | PRJNA896554_P_NODE_82199_length_390_cov_2.441640_g74659_i0 | PRJNA896554 | 82199 | 390 | 2.44164 | 9.522396 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 88.2 | 5.04e-19 | NR | WP_324954760.1 | 1971216 | g74659 | i0 | 40.2 | 1.01538461538462 | 132 | 38 | 99.2 | 4 | 4 | 390 | 16 | 109 | WP_324954760.1 hypothetical protein [Oligoflexus sp.] | diamond | 396 | 88.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 26707165 | 26707165 | PRJNA896554_P_NODE_152201_length_250_cov_1.214689_g144661_i0 | PRJNA896554 | 152201 | 250 | 1.214689 | 3.0367225 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 141 | 4.39e-38 | NR | MCB0368368.1 | 2053517 | g144661 | i0 | 86.7 | 0.996 | 83 | 9 | 99.6 | 1 | 1 | 249 | 277 | 357 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 249 | 141 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27940167 | 27940167 | PRJNA896554_P_NODE_133845_length_271_cov_1.166667_g126305_i0 | PRJNA896554 | 133845 | 271 | 1.166667 | 3.16166757 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 130 | 3.04e-35 | NR | MBX9767866.1 | 2053517 | g126305 | i0 | 71.9 | 0.985239852398524 | 89 | 24 | 97.4 | 1 | 269 | 6 | 3 | 91 | MBX9767866.1 GTP-binding protein [Bdellovibrionales bacterium] | diamond | 267 | 130 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29076899 | 29076899 | PRJNA896554_P_NODE_137328_length_266_cov_1.595855_g129788_i0 | PRJNA896554 | 137328 | 266 | 1.595855 | 4.2449743 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 162 | 9.13e-49 | NR | MBP9675022.1 | 2081706 | g129788 | i0 | 88.5 | 0.981203007518797 | 87 | 10 | 98.1 | 0 | 3 | 263 | 40 | 126 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 261 | 162 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29203244 | 29203244 | PRJNA896554_P_NODE_72549_length_439_cov_3.021858_g65009_i0 | PRJNA896554 | 72549 | 439 | 3.021858 | 13.26595662 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 46.6 | 0.0135 | NR | MCB0348069.1 | 2053517 | g65009 | i0 | 47.6 | 0.430523917995444 | 63 | 22 | 40.3 | 2 | 260 | 436 | 397 | 452 | MCB0348069.1 PKD domain-containing protein [Bdellovibrionales bacterium] | diamond | 189 | 46.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30181937 | 30181937 | PRJNA896554_P_NODE_133952_length_271_cov_1.126263_g126412_i0 | PRJNA896554 | 133952 | 271 | 1.126263 | 3.05217273 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 93.6 | 1.67e-21 | NR | MCB0368409.1 | 2053517 | g126412 | i0 | 46.2 | 1.00738007380074 | 91 | 48 | 99.6 | 1 | 1 | 270 | 53 | 143 | MCB0368409.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 273 | 93.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30189699 | 30189699 | PRJNA896554_P_NODE_157432_length_248_cov_0.880000_g149892_i0 | PRJNA896554 | 157432 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 80.5 | 1.97e-15 | NR | PZO79293.1 | 349221 | g149892 | i0 | 47.4 | 1.86290322580645 | 78 | 35 | 89.5 | 2 | 1 | 222 | 361 | 436 | PZO79293.1 MAG: hypothetical protein DI626_11630 [Micavibrio aeruginosavorus] | diamond | 462 | 80.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 30213470 | 30213470 | PRJNA896554_P_NODE_147332_length_254_cov_1.104972_g139792_i0 | PRJNA896554 | 147332 | 254 | 1.104972 | 2.80662888 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 122 | 2.56e-34 | NR | MCB0370849.1 | 2053517 | g139792 | i0 | 90 | 0.826771653543307 | 70 | 7 | 82.7 | 0 | 39 | 248 | 1 | 70 | MCB0370849.1 protein kinase [Bdellovibrionales bacterium] | diamond | 210 | 122 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30498030 | 30498030 | PRJNA896554_P_NODE_150833_length_251_cov_0.865169_g143293_i0 | PRJNA896554 | 150833 | 251 | 0.865169 | 2.17157419 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 150 | 7.48e-41 | NR | PZQ46742.1 | 349221 | g143293 | i0 | 87.7 | 1.94820717131474 | 81 | 10 | 96.8 | 0 | 250 | 8 | 149 | 229 | PZQ46742.1 MAG: hypothetical protein DI551_04635 [Micavibrio aeruginosavorus] | diamond | 489 | 150 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 30845597 | 30845597 | PRJNA896554_P_NODE_164834_length_245_cov_0.895349_g157294_i0 | PRJNA896554 | 164834 | 245 | 0.895349 | 2.19360505 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 95.1 | 7.789999999999999e-23 | NR | MES2744750.1 | 3034175 | g157294 | i0 | 62 | 0.96734693877551 | 79 | 30 | 96.7 | 0 | 9 | 245 | 36 | 114 | MES2744750.1 DoxX protein [Bdellovibrionota bacterium] | diamond | 237 | 95.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31161126 | 31161126 | PRJNA896554_P_NODE_126075_length_282_cov_1.105263_g118535_i0 | PRJNA896554 | 126075 | 282 | 1.105263 | 3.11684166 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 100 | 1.76e-25 | NR | MCB0369353.1 | 2053517 | g118535 | i0 | 60.5 | 0.861702127659574 | 81 | 30 | 85.1 | 2 | 3 | 242 | 1 | 80 | MCB0369353.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 243 | 100 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31572812 | 31572812 | PRJNA896554_P_NODE_155436_length_249_cov_0.875000_g147896_i0 | PRJNA896554 | 155436 | 249 | 0.875 | 2.17875 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 89.7 | 1.21e-18 | NR | HEY8280183.1 | 3034175 | g147896 | i0 | 54.2 | 1 | 83 | 38 | 100 | 0 | 249 | 1 | 282 | 364 | HEY8280183.1 transcription-repair coupling factor [Bdellovibrionota bacterium] | diamond | 249 | 89.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31857208 | 31857208 | PRJNA896554_P_NODE_152417_length_250_cov_0.870056_g144877_i0 | PRJNA896554 | 152417 | 250 | 0.870056 | 2.17514 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 120 | 3.05e-33 | NR | MCB0368989.1 | 2053517 | g144877 | i0 | 69.5 | 0.984 | 82 | 25 | 98.4 | 0 | 248 | 3 | 1 | 82 | MCB0368989.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 246 | 120 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32015488 | 32015488 | PRJNA896554_P_NODE_170538_length_243_cov_0.905882_g162998_i0 | PRJNA896554 | 170538 | 243 | 0.905882 | 2.20129326 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 100 | 3.5199999999999996e-24 | NR | HUP58353.1 | 3034175 | g162998 | i0 | 56.8 | 1 | 81 | 35 | 100 | 0 | 1 | 243 | 123 | 203 | HUP58353.1 DUF2071 domain-containing protein [Bdellovibrionota bacterium] | diamond | 243 | 100 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32616448 | 32616448 | PRJNA896554_P_NODE_150340_length_251_cov_0.865169_g142800_i0 | PRJNA896554 | 150340 | 251 | 0.865169 | 2.17157419 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 144 | 1.51e-39 | NR | MBA2404471.1 | 2053517 | g142800 | i0 | 80.7 | 0.99203187250996006 | 83 | 16 | 99.2 | 0 | 1 | 249 | 36 | 118 | MBA2404471.1 thioredoxin domain-containing protein [Bdellovibrionales bacterium] | diamond | 249 | 144 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32710805 | 32710805 | PRJNA896554_P_NODE_123980_length_285_cov_1.396226_g116440_i0 | PRJNA896554 | 123980 | 285 | 1.396226 | 3.9792441 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 48.9 | 4.18e-4 | NR | MCO5141485.1 | 2599941 | g116440 | i0 | 27.9 | 0.905263157894737 | 86 | 60 | 88.4 | 1 | 253 | 2 | 809 | 894 | MCO5141485.1 hypothetical protein [Oligoflexia bacterium] | diamond | 258 | 48.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia 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);;