contig_metadata
16 rows where bioproject = "PRJNA1174207", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1590589 | 1590589 | PRJNA1174207_P_NODE_43302_length_226_cov_2.013072_g42773_i0 | PRJNA1174207 | 43302 | 226 | 2.013072 | 4.54954272 | Oligoflexales bacterium | 2687297 | Bacteria | Bacteria | 76.3 | 1.47e-14 | NR | MBP9708592.1 | 2687297 | g42773 | i0 | 51.4 | 0.982300884955752 | 74 | 36 | 98.2 | 0 | 224 | 3 | 50 | 123 | MBP9708592.1 hypothetical protein [Oligoflexales bacterium] | diamond | 222 | 76.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexales bacterium | ||||
| 4142403 | 4142403 | PRJNA1174207_P_NODE_21424_length_308_cov_3.165957_g20895_i0 | PRJNA1174207 | 21424 | 308 | 3.165957 | 9.75114756 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 424 | 5.29e-114 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g20895 | i0 | 91.558 | 197.918831168831 | 308 | 25 | 99 | 1 | 2 | 308 | 3446110 | 3446417 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 60959 | 424 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 6143557 | 6143557 | PRJNA1174207_P_NODE_32725_length_253_cov_1.711111_g32196_i0 | PRJNA1174207 | 32725 | 253 | 1.711111 | 4.32911083 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 340 | 4.379999999999999e-89 | NTclustered | gi|469926873|gb|CP003538.1| | 349215 | g32196 | i0 | 91.235 | 283.766798418972 | 251 | 20 | 99 | 2 | 1 | 251 | 463138 | 463386 | Micavibrio aeruginosavorus EPB, complete genome | blastn | 71793 | 342 | 0.994152046783626 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 10519286 | 10519286 | PRJNA1174207_P_NODE_29429_length_267_cov_1.381443_g28900_i0 | PRJNA1174207 | 29429 | 267 | 1.381443 | 3.68845281 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 416 | 7.519999999999998e-112 | NTclustered | gi|2800948966|gb|CP168973.1| | 959 | g28900 | i0 | 95.076 | 153.625468164794 | 264 | 13 | 99 | 0 | 1 | 264 | 1677242 | 1677505 | Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome | blastn | 41018 | 416 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 11794114 | 11794114 | PRJNA1174207_P_NODE_20850_length_310_cov_3.312236_g20321_i0 | PRJNA1174207 | 20850 | 310 | 3.312236 | 10.2679316 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 85.9 | 4.6e-17 | NR | MCB0406681.1 | 2053517 | g20321 | i0 | 69.4 | 1.42258064516129 | 49 | 15 | 47.4 | 0 | 309 | 163 | 102 | 150 | MCB0406681.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Bdellovibrionales bacterium] | diamond | 441 | 85.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 15618259 | 15618259 | PRJNA1174207_P_NODE_20413_length_313_cov_2.275000_g19884_i0 | PRJNA1174207 | 20413 | 313 | 2.275 | 7.12075 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 171 | 5.209999999999999e-52 | NR | MCB0370127.1 | 2053517 | g19884 | i0 | 78.6 | 3.94888178913738 | 103 | 22 | 98.7 | 0 | 311 | 3 | 59 | 161 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 1236 | 171 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27040550 | 27040550 | PRJNA1174207_P_NODE_40642_length_242_cov_0.911243_g40113_i0 | PRJNA1174207 | 40642 | 242 | 0.911243 | 2.20520806 | Bdellovibrionales bacterium CG22_combo_CG1 | 2053517 | Bacteria | Bacteria | 55.8 | 8.09e-7 | NR | PIP89443.1 | 1973930 | g40113 | i0 | 39.5 | 0.942148760330578 | 76 | 46 | 94.2 | 0 | 15 | 242 | 159 | 234 | PIP89443.1 MAG: alkane 1-monooxygenase [Bdellovibrionales bacterium CG22_combo_CG10-13_8_21_14_all_38_13] | diamond | 228 | 55.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium CG22_combo_CG10-13_8_21_14_all_38_13 | ||||
| 28859693 | 28859693 | PRJNA1174207_P_NODE_25028_length_285_cov_2.542453_g24499_i0 | PRJNA1174207 | 25028 | 285 | 2.542453 | 7.24599105 | root | 1 | Root_unresolved | Root_unresolved | 68.6 | 7.45e-12 | NR | MDH4468212.1 | 2081706 | g24499 | i0 | 40.4 | 3.03157894736842 | 94 | 50 | 98.9 | 2 | 283 | 2 | 96 | 183 | MDH4468212.1 lipocalin family protein [Bacteriovoracaceae bacterium] | diamond | 864 | 68.9 | 0.995645863570392 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29207298 | 29207298 | PRJNA1174207_P_NODE_32309_length_255_cov_1.439560_g31780_i0 | PRJNA1174207 | 32309 | 255 | 1.43956 | 3.670878 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 81.3 | 1.19e-15 | NR | QQG36778.1 | 349221 | g31780 | i0 | 77.1 | 1.72941176470588 | 48 | 11 | 56.5 | 0 | 253 | 110 | 271 | 318 | QQG36778.1 MAG: uroporphyrinogen-III synthase [Micavibrio aeruginosavorus] | diamond | 441 | 81.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 29440192 | 29440192 | PRJNA1174207_P_NODE_40750_length_242_cov_0.911243_g40221_i0 | PRJNA1174207 | 40750 | 242 | 0.911243 | 2.20520806 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 140 | 5.82e-37 | NR | MBX3022978.1 | 2053517 | g40221 | i0 | 78.8 | 0.991735537190083 | 80 | 17 | 99.2 | 0 | 240 | 1 | 85 | 164 | MBX3022978.1 4Fe-4S dicluster domain-containing protein [Bdellovibrionales bacterium] | diamond | 240 | 140 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30040535 | 30040535 | PRJNA1174207_P_NODE_18331_length_332_cov_1.521236_g17802_i0 | PRJNA1174207 | 18331 | 332 | 1.521236 | 5.05050352 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 139 | 3.68e-39 | NR | MCB0369154.1 | 2053517 | g17802 | i0 | 64.4 | 0.939759036144578 | 104 | 37 | 94 | 0 | 328 | 17 | 56 | 159 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 312 | 139 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31020072 | 31020072 | PRJNA1174207_P_NODE_22855_length_297_cov_1.937500_g22326_i0 | PRJNA1174207 | 22855 | 297 | 1.9375 | 5.754375 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 68.6 | 2.59e-11 | NR | HEY8279801.1 | 3034175 | g22326 | i0 | 44.1 | 1.92929292929293 | 93 | 52 | 93.9 | 0 | 19 | 297 | 18 | 110 | HEY8279801.1 tetratricopeptide repeat protein [Bdellovibrionota bacterium] | diamond | 573 | 68.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31810535 | 31810535 | PRJNA1174207_P_NODE_41057_length_241_cov_2.434524_g40528_i0 | PRJNA1174207 | 41057 | 241 | 2.434524 | 5.86720284 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 99.4 | 3.0099999999999997e-25 | NR | MCB0369232.1 | 2053517 | g40528 | i0 | 57.5 | 0.908713692946058 | 73 | 31 | 90.9 | 0 | 17 | 235 | 5 | 77 | MCB0369232.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 219 | 99.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31841978 | 31841978 | PRJNA1174207_P_NODE_35097_length_249_cov_0.875000_g34568_i0 | PRJNA1174207 | 35097 | 249 | 0.875 | 2.17875 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 147 | 6.489999999999998e-42 | NR | MBX3021450.1 | 2053517 | g34568 | i0 | 75.6 | 1.98795180722892 | 82 | 20 | 98.8 | 0 | 249 | 4 | 155 | 236 | MBX3021450.1 class I SAM-dependent methyltransferase [Bdellovibrionales bacterium] | diamond | 495 | 147 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32475132 | 32475132 | PRJNA1174207_P_NODE_22959_length_296_cov_2.986547_g22430_i0 | PRJNA1174207 | 22959 | 296 | 2.986547 | 8.84017912 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 116 | 4.37e-28 | NR | NUM88387.1 | 2053517 | g22430 | i0 | 47.7 | 7.98648648648649 | 132 | 34 | 98.3 | 1 | 295 | 5 | 196 | 327 | NUM88387.1 efflux RND transporter permease subunit [Bdellovibrionales bacterium] | diamond | 2364 | 116 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32526176 | 32526176 | PRJNA1174207_P_NODE_38099_length_245_cov_0.895349_g37570_i0 | PRJNA1174207 | 38099 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 112 | 1.6e-26 | NR | MBL7557774.1 | 2026715 | g37570 | i0 | 72.2 | 3.72244897959184 | 79 | 18 | 96.7 | 1 | 8 | 244 | 264 | 338 | MBL7557774.1 DNA translocase FtsK 4TM domain-containing protein [Pseudobdellovibrionaceae bacterium] | diamond | 912 | 112 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae 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);;