contig_metadata
9 rows where bioproject = "PRJNA720429" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8363315 | 8363315 | PRJNA720429_P_NODE_3727_length_248_cov_1.320000_g3670_i0 | PRJNA720429 | 3727 | 248 | 1.32 | 3.2736 | Bacteriovorax stolpii | 960 | Bacteria | Bacteria | 189 | 1.6399999999999996e-43 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g3670 | i0 | 80.709 | 2 | 254 | 40 | 100 | 6 | 1 | 248 | 463786 | 463536 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 496 | 189 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 26767199 | 26767199 | PRJNA720429_P_NODE_4161_length_246_cov_0.890173_g4104_i0 | PRJNA720429 | 4161 | 246 | 0.890173 | 2.18982558 | Silvanigrellaceae bacterium | 2654442 | Bacteria | Bacteria | 114 | 1.51e-28 | NR | MBX9702590.1 | 2654442 | g4104 | i0 | 89.7 | 0.707317073170732 | 58 | 6 | 70.7 | 0 | 71 | 244 | 164 | 221 | MBX9702590.1 serine/threonine-protein kinase [Silvanigrellaceae bacterium] | diamond | 174 | 114 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrellaceae bacterium | |||
| 26809420 | 26809420 | PRJNA720429_P_NODE_3081_length_255_cov_1.307692_g3024_i0 | PRJNA720429 | 3081 | 255 | 1.307692 | 3.3346146 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 66.2 | 2.19e-10 | NR | MEZ0391224.1 | 2026715 | g3024 | i0 | 87.1 | 3.17647058823529 | 31 | 4 | 36.5 | 0 | 3 | 95 | 460 | 490 | MEZ0391224.1 TldD/PmbA family protein [Pseudobdellovibrionaceae bacterium] | diamond | 810 | 66.6 | 0.993993993993994 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 27336655 | 27336655 | PRJNA720429_P_NODE_2103_length_293_cov_1.931818_g2046_i0 | PRJNA720429 | 2103 | 293 | 1.931818 | 5.66022674 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 89.4 | 2.89e-18 | NR | HLW56653.1 | 2081706 | g2046 | i0 | 62.3 | 1.57679180887372 | 77 | 27 | 78.8 | 2 | 292 | 62 | 769 | 843 | HLW56653.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 462 | 89.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29168076 | 29168076 | PRJNA720429_P_NODE_3709_length_248_cov_1.760000_g3652_i0 | PRJNA720429 | 3709 | 248 | 1.76 | 4.3648 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 92.4 | 1.31e-19 | NR | HXH30291.1 | 2081706 | g3652 | i0 | 80.4 | 1.34274193548387 | 56 | 11 | 67.7 | 0 | 247 | 80 | 843 | 898 | HXH30291.1 aconitate hydratase AcnA [Bacteriovoracaceae bacterium] | diamond | 333 | 92.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29641122 | 29641122 | PRJNA720429_P_NODE_3410_length_250_cov_0.870056_g3353_i0 | PRJNA720429 | 3410 | 250 | 0.870056 | 2.17514 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 120 | 1.73e-30 | NR | WP_413291217.1 | 3394358 | g3353 | i0 | 70.4 | 0.972 | 81 | 24 | 97.2 | 0 | 248 | 6 | 37 | 117 | WP_413291217.1 type II secretion system protein J [Bdellovibrio sp. HCB337] | diamond | 243 | 120 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 30905239 | 30905239 | PRJNA720429_P_NODE_4194_length_246_cov_0.890173_g4137_i0 | PRJNA720429 | 4194 | 246 | 0.890173 | 2.18982558 | Bacteriovorax stolpii | 960 | Bacteria | Bacteria | 134 | 1.68e-34 | NR | WP_142408984.1 | 960 | g4137 | i0 | 91.4 | 0.98780487804878 | 81 | 7 | 98.8 | 0 | 244 | 2 | 197 | 277 | WP_142408984.1 endopeptidase La [Bacteriovorax stolpii] | diamond | 243 | 134 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 32328662 | 32328662 | PRJNA720429_P_NODE_2639_length_271_cov_1.555556_g2582_i0 | PRJNA720429 | 2639 | 271 | 1.555556 | 4.21555676 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 171 | 4.52e-48 | NR | HLT22320.1 | 2081706 | g2582 | i0 | 88.9 | 0.996309963099631 | 90 | 10 | 99.6 | 0 | 1 | 270 | 334 | 423 | HLT22320.1 phospho-sugar mutase [Bacteriovoracaceae bacterium] | diamond | 270 | 171 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32812157 | 32812157 | PRJNA720429_P_NODE_4120_length_246_cov_1.531792_g4063_i0 | PRJNA720429 | 4120 | 246 | 1.531792 | 3.76820832 | Bdellovibrio | 958 | Bacteria | Bacteria | 131 | 2.58e-33 | NR | WP_347358685.1 | 958 | g4063 | i0 | 74.4 | 5 | 82 | 21 | 100 | 0 | 246 | 1 | 454 | 535 | WP_347358685.1 MULTISPECIES: cytochrome-c oxidase, cbb3-type subunit I [Bdellovibrio] | diamond | 1230 | 131 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio |
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);;