contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA599026" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4969374 | 4969374 | PRJNA599026_S_NODE_40924_length_180_cov_1.557252_g40468_i0 | PRJNA599026 | 40924 | 180 | 1.557252 | 2.8030536 | Bdellovibrio | 958 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|2771112236|gb|CP160486.1| | 959 | g40468 | i0 | 96.875 | 2.13333333333333 | 32 | 1 | 18 | 0 | 113 | 144 | 2317027 | 2316996 | Bdellovibrio bacteriovorus strain MHI39 chromosome | blastn | 384 | 54.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 6949656 | 6949656 | PRJNA599026_S_NODE_15446_length_257_cov_1.557692_g14990_i0 | PRJNA599026 | 15446 | 257 | 1.557692 | 4.00326844 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 226 | 1.3e-54 | NTclustered | gi|2258818259|gb|CP060220.1| | 2026715 | g14990 | i0 | 82.869 | 1.10505836575875 | 251 | 43 | 98 | 0 | 1 | 251 | 2479487 | 2479237 | MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome | blastn | 284 | 226 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 9500248 | 9500248 | PRJNA599026_S_NODE_48948_length_169_cov_1.108333_g48492_i0 | PRJNA599026 | 48948 | 169 | 1.108333 | 1.87308277 | Bdellovibrio sp. HCB209 | 3394354 | Bacteria | Bacteria | 52.8 | 0.014 | NTclustered | gi|2895998570|gb|CP178618.1| | 3394354 | g48492 | i0 | 96.875 | 0.189349112426035 | 32 | 0 | 18 | 1 | 46 | 76 | 2434040 | 2434071 | Bdellovibrio sp. HCB209 chromosome, complete genome | blastn | 32 | 52.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB209 | ||
| 19698577 | 19698577 | PRJNA599026_S_NODE_68316_length_162_cov_0.902655_g67860_i0 | PRJNA599026 | 68316 | 162 | 0.902655 | 1.4623011 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 261 | 2.06e-65 | NTclustered | gi|1950812799|gb|CP066681.1| | 349221 | g67860 | i0 | 95.679 | 1 | 162 | 7 | 100 | 0 | 1 | 162 | 683651 | 683490 | Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome | blastn | 162 | 261 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 20974237 | 20974237 | PRJNA599026_S_NODE_59757_length_164_cov_1.008696_g59301_i0 | PRJNA599026 | 59757 | 164 | 1.008696 | 1.65426144 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 272 | 9.65e-69 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g59301 | i0 | 96.386 | 16.8353658536585 | 166 | 4 | 100 | 1 | 1 | 164 | 511842 | 512007 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 2761 | 272 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 24093279 | 24093279 | PRJNA599026_S_NODE_59299_length_164_cov_1.704348_g58843_i0 | PRJNA599026 | 59299 | 164 | 1.704348 | 2.79513072 | Bdellovibrio | 958 | Bacteria | Bacteria | 82.4 | 1.75e-11 | NTclustered | gi|2800917394|gb|CP168972.1| | 959 | g58843 | i0 | 89.231 | 0.810975609756098 | 65 | 7 | 40 | 0 | 76 | 140 | 2990669 | 2990605 | Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome | blastn | 133 | 82.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus |
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);;