contig_metadata
6 rows where bioproject = "PRJEB73599", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1409725 | 1409725 | PRJEB73599_P_NODE_1222_length_679_cov_96.910769_g1031_i0 | PRJEB73599 | 1222 | 679 | 96.910769 | 658.02412151 | Bdellovibrio sp. qaytius | 1916293 | Bacteria | Bacteria | 841 | 0 | NTclustered | gi|1552089877|gb|CP025734.1| | 1916293 | g1031 | i0 | 89.671 | 333.814432989691 | 668 | 57 | 98 | 11 | 17 | 679 | 665892 | 666552 | Bdellovibrio sp. qaytius chromosome, complete genome | blastn | 226660 | 841 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. qaytius | ||
| 5237708 | 5237708 | PRJEB73599_P_NODE_1845_length_548_cov_4.768786_g1603_i0 | PRJEB73599 | 1845 | 548 | 4.768786 | 26.13294728 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 808 | 0 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g1603 | i0 | 93.26 | 107.204379562044 | 549 | 36 | 100 | 1 | 1 | 548 | 3446740 | 3447288 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 58748 | 808 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 13748919 | 13748919 | PRJEB73599_P_NODE_5071_length_288_cov_2.440154_g4784_i0 | PRJEB73599 | 5071 | 288 | 2.440154 | 7.02764352 | Bacteriovorax | 146784 | Bacteria | Bacteria | 521 | 1.69e-143 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g4784 | i0 | 99.306 | 26.3819444444444 | 288 | 2 | 100 | 0 | 1 | 288 | 1661591 | 1661878 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 7598 | 521 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 27445255 | 27445255 | PRJEB73599_P_NODE_5183_length_284_cov_1.984314_g4896_i0 | PRJEB73599 | 5183 | 284 | 1.984314 | 5.63545176 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 59.3 | 8.92e-8 | NR | WP_015468752.1 | 453816 | g4896 | i0 | 42.3 | 0.823943661971831 | 78 | 45 | 82.4 | 0 | 1 | 234 | 364 | 441 | WP_015468752.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus] | diamond | 234 | 59.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 29623054 | 29623054 | PRJEB73599_P_NODE_9130_length_169_cov_1.407143_g8843_i0 | PRJEB73599 | 9130 | 169 | 1.407143 | 2.37807167 | Pseudobacteriovorax antillogorgiicola | 1513793 | Bacteria | Bacteria | 41.2 | 0.0493 | NR | WP_159455691.1 | 1513793 | g8843 | i0 | 36.2 | 1.02958579881657 | 58 | 35 | 99.4 | 1 | 2 | 169 | 291 | 348 | WP_159455691.1 FAD-dependent oxidoreductase [Pseudobacteriovorax antillogorgiicola] | diamond | 174 | 41.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Pseudobacteriovoracaceae | Pseudobacteriovorax | Pseudobacteriovorax antillogorgiicola | ||
| 30919001 | 30919001 | PRJEB73599_P_NODE_834_length_828_cov_2.382979_g675_i0 | PRJEB73599 | 834 | 828 | 2.382979 | 19.73106612 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 62.4 | 5.99e-7 | NR | WP_015468758.1 | 453816 | g675 | i0 | 31.3 | 0.358695652173913 | 99 | 64 | 35.9 | 1 | 387 | 91 | 342 | 436 | WP_015468758.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus] | diamond | 297 | 62.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus |
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);;