contig_metadata
18 rows where bioproject = "PRJNA1112809", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11226668 | 11226668 | PRJNA1112809_P_NODE_164649_length_251_cov_0.865169_g161374_i0 | PRJNA1112809 | 164649 | 251 | 0.865169 | 2.17157419 | Bdellovibrio | 958 | Bacteria | Bacteria | 182 | 2.78e-41 | NTclustered | gi|2801803968|gb|CP169237.1| | 959 | g161374 | i0 | 79.921 | 2.02390438247012 | 254 | 45 | 100 | 5 | 1 | 251 | 3316080 | 3315830 | Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome | blastn | 508 | 182 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 12973816 | 12973816 | PRJNA1112809_P_NODE_177651_length_246_cov_1.427746_g174376_i0 | PRJNA1112809 | 177651 | 246 | 1.427746 | 3.51225516 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 98.2 | 1.05e-21 | NR | WP_102244205.1 | 960 | g174376 | i0 | 69.9 | 1.78048780487805 | 73 | 22 | 89 | 0 | 246 | 28 | 43 | 115 | WP_102244205.1 HAMP domain-containing methyl-accepting chemotaxis protein [Bacteriovorax stolpii] | diamond | 438 | 98.6 | 0.995943204868154 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 19347726 | 19347726 | PRJNA1112809_P_NODE_96976_length_337_cov_2.424242_g93701_i0 | PRJNA1112809 | 96976 | 337 | 2.424242 | 8.16969554 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 76.8 | 1.89e-9 | NTclustered | gi|2621706492|emb|OY764265.1| | 3034175 | g93701 | i0 | 94 | 1.08308605341246 | 50 | 3 | 15 | 0 | 136 | 185 | 1805896 | 1805847 | MAG: Bdellovibrionota bacterium isolate efddfb02-ff0c-4ac5-ae96-c61d995422a3 genome assembly, chromosome: 1 | blastn | 365 | 76.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 23174003 | 23174003 | PRJNA1112809_P_NODE_91899_length_349_cov_1.938406_g88624_i0 | PRJNA1112809 | 91899 | 349 | 1.938406 | 6.76503694 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 206 | 3.1e-64 | NR | OYZ23593.1 | 1970323 | g88624 | i0 | 84.5 | 1.99426934097421 | 116 | 18 | 99.7 | 0 | 348 | 1 | 42 | 157 | OYZ23593.1 MAG: hypothetical protein B7Y39_04440 [Bdellovibrio sp. 28-41-41] | diamond | 696 | 207 | 0.995169082125604 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. 28-41-41 | ||
| 27700044 | 27700044 | PRJNA1112809_P_NODE_149344_length_264_cov_1.607330_g146069_i0 | PRJNA1112809 | 149344 | 264 | 1.60733 | 4.2433512 | Bdellovibrionales bacterium RIFOXYD1_FULL_55_31 | 1797404 | Bacteria | Bacteria | 74.7 | 2.78e-13 | NR | OFZ85158.1 | 1797404 | g146069 | i0 | 46.2 | 1.98863636363636 | 91 | 44 | 97.7 | 1 | 261 | 4 | 145 | 235 | OFZ85158.1 MAG: hypothetical protein A2603_06300 [Bdellovibrionales bacterium RIFOXYD1_FULL_55_31] | diamond | 525 | 74.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFOXYD1_FULL_55_31 | ||||
| 27785801 | 27785801 | PRJNA1112809_P_NODE_193144_length_241_cov_0.916667_g189869_i0 | PRJNA1112809 | 193144 | 241 | 0.916667 | 2.20916747 | Micavibrio | 213485 | Bacteria | Bacteria | 148 | 4.769999999999998e-41 | NR | MBI2234646.1 | 349221 | g189869 | i0 | 82.3 | 1.96680497925311 | 79 | 14 | 98.3 | 0 | 3 | 239 | 117 | 195 | MBI2234646.1 phosphoserine transaminase [Micavibrio aeruginosavorus] | diamond | 474 | 148 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 27975026 | 27975026 | PRJNA1112809_P_NODE_80165_length_382_cov_2.213592_g76890_i0 | PRJNA1112809 | 80165 | 382 | 2.213592 | 8.45592144 | Bacteria | 2 | Bacteria | Bacteria | 185 | 2.2699999999999997e-55 | NR | MBS1984054.1 | 2053517 | g76890 | i0 | 77.2 | 1.99476439790576 | 127 | 29 | 99.7 | 0 | 1 | 381 | 40 | 166 | MBS1984054.1 tyrosine-type recombinase/integrase [Bdellovibrionales bacterium] | diamond | 762 | 186 | 0.99462365591397806 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28299578 | 28299578 | PRJNA1112809_P_NODE_199406_length_227_cov_4.519481_g196131_i0 | PRJNA1112809 | 199406 | 227 | 4.519481 | 10.25922187 | Bdellovibrio sp. ArHS | 1569284 | Bacteria | Bacteria | 94.4 | 1.83e-20 | NR | WP_041871773.1 | 1569284 | g196131 | i0 | 65.3 | 0.991189427312775 | 75 | 26 | 99.1 | 0 | 3 | 227 | 78 | 152 | WP_041871773.1 hypothetical protein [Bdellovibrio sp. ArHS] | diamond | 225 | 94.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. ArHS | ||
| 29435936 | 29435936 | PRJNA1112809_P_NODE_113730_length_306_cov_2.643777_g110455_i0 | PRJNA1112809 | 113730 | 306 | 2.643777 | 8.08995762 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 89.4 | 1.44e-19 | NR | MFL5812612.1 | 3034169 | g110455 | i0 | 60.6 | 0.696078431372549 | 71 | 26 | 67.6 | 1 | 208 | 2 | 76 | 146 | MFL5812612.1 plastocyanin/azurin family copper-binding protein [Bdellovibrionia bacterium] | diamond | 213 | 89.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia bacterium | |||||
| 29941677 | 29941677 | PRJNA1112809_P_NODE_161311_length_253_cov_1.488889_g158036_i0 | PRJNA1112809 | 161311 | 253 | 1.488889 | 3.76688917 | uncultured Bdellovibrio sp. | 239744 | Bacteria | Bacteria | 94 | 1.21e-21 | NR | WP_295904741.1 | 239744 | g158036 | i0 | 72.1 | 0.723320158102767 | 61 | 17 | 72.3 | 0 | 251 | 69 | 147 | 207 | WP_295904741.1 hypothetical protein [uncultured Bdellovibrio sp.] | diamond | 183 | 94 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | uncultured Bdellovibrio sp. | ||
| 30352783 | 30352783 | PRJNA1112809_P_NODE_132952_length_281_cov_1.480769_g129677_i0 | PRJNA1112809 | 132952 | 281 | 1.480769 | 4.16096089 | Bdellovibrio | 958 | Bacteria | Bacteria | 181 | 1.54e-53 | NR | WP_374078843.1 | 958 | g129677 | i0 | 94.6 | 2.97864768683274 | 93 | 5 | 99.3 | 0 | 280 | 2 | 248 | 340 | WP_374078843.1 MULTISPECIES: S1 RNA-binding domain-containing protein [Bdellovibrio] | diamond | 837 | 181 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | |||
| 30510231 | 30510231 | PRJNA1112809_P_NODE_46853_length_569_cov_1.733871_g43602_i0 | PRJNA1112809 | 46853 | 569 | 1.733871 | 9.86572599 | Silvanigrella sp. | 2024976 | Bacteria | Bacteria | 191 | 9.17e-58 | NR | WP_397601174.1 | 2024976 | g43602 | i0 | 53.8 | 0.901581722319859 | 171 | 78 | 89.6 | 1 | 47 | 556 | 13 | 183 | WP_397601174.1 hexitol phosphatase HxpB [Silvanigrella sp.] | diamond | 513 | 191 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrella | Silvanigrella sp. | ||
| 30889438 | 30889438 | PRJNA1112809_P_NODE_169934_length_249_cov_0.875000_g166659_i0 | PRJNA1112809 | 169934 | 249 | 0.875 | 2.17875 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 133 | 5.28e-34 | NR | PZQ47721.1 | 349221 | g166659 | i0 | 76.9 | 0.939759036144578 | 78 | 18 | 94 | 0 | 2 | 235 | 425 | 502 | PZQ47721.1 MAG: hypothetical protein DI551_02865 [Micavibrio aeruginosavorus] | diamond | 234 | 133 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 31426699 | 31426699 | PRJNA1112809_P_NODE_188816_length_242_cov_1.822485_g185541_i0 | PRJNA1112809 | 188816 | 242 | 1.822485 | 4.4104137 | uncultured Bdellovibrio sp. | 239744 | Bacteria | Bacteria | 95.9 | 6.360000000000001e-21 | NR | WP_295904633.1 | 239744 | g185541 | i0 | 82.5 | 0.78099173553719 | 63 | 11 | 78.1 | 0 | 52 | 240 | 1 | 63 | WP_295904633.1 methyl-accepting chemotaxis protein [uncultured Bdellovibrio sp.] | diamond | 189 | 95.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | uncultured Bdellovibrio sp. | ||
| 31521749 | 31521749 | PRJNA1112809_P_NODE_135016_length_279_cov_1.334951_g131741_i0 | PRJNA1112809 | 135016 | 279 | 1.334951 | 3.72451329 | Bdellovibrionales bacterium RIFOXYD1_FULL_55_31 | 1797404 | Bacteria | Bacteria | 110 | 1.2e-25 | NR | OFZ85158.1 | 1797404 | g131741 | i0 | 66.3 | 2.96774193548387 | 92 | 27 | 98.9 | 1 | 2 | 277 | 675 | 762 | OFZ85158.1 MAG: hypothetical protein A2603_06300 [Bdellovibrionales bacterium RIFOXYD1_FULL_55_31] | diamond | 828 | 110 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFOXYD1_FULL_55_31 | ||||
| 31742875 | 31742875 | PRJNA1112809_P_NODE_131357_length_283_cov_1.247619_g128082_i0 | PRJNA1112809 | 131357 | 283 | 1.247619 | 3.53076177 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 127 | 1.23e-31 | NR | PZP54292.1 | 349221 | g128082 | i0 | 70.5 | 1.00706713780919 | 95 | 27 | 99.6 | 1 | 283 | 2 | 513 | 607 | PZP54292.1 MAG: type II and III secretion system family protein [Micavibrio aeruginosavorus] | diamond | 285 | 127 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 32217649 | 32217649 | PRJNA1112809_P_NODE_153338_length_260_cov_1.935829_g150063_i0 | PRJNA1112809 | 153338 | 260 | 1.935829 | 5.0331554 | Halobacteriovoraceae bacterium | 2026745 | Bacteria | Bacteria | 74.3 | 3.41e-13 | NR | MBT3585768.1 | 2026745 | g150063 | i0 | 44.2 | 1.85769230769231 | 86 | 46 | 99.2 | 1 | 2 | 259 | 408 | 491 | MBT3585768.1 DUF3404 domain-containing protein [Halobacteriovoraceae bacterium] | diamond | 483 | 74.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 32565946 | 32565946 | PRJNA1112809_P_NODE_195539_length_237_cov_2.792683_g192264_i0 | PRJNA1112809 | 195539 | 237 | 2.792683 | 6.61865871 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 113 | 2.4899999999999996e-29 | NR | MDB5492475.1 | 2024841 | g192264 | i0 | 68.8 | 0.974683544303797 | 77 | 24 | 97.5 | 0 | 236 | 6 | 23 | 99 | MDB5492475.1 hypothetical protein [Micavibrio sp.] | diamond | 231 | 113 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio 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);;