contig_metadata
6 rows where bioproject = "PRJNA624323" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 596383 | 596383 | PRJNA624323_P_NODE_8561_length_247_cov_0.885057_g8399_i0 | PRJNA624323 | 8561 | 247 | 0.885057 | 2.18609079 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 407 | 4.14e-109 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g8399 | i0 | 96.356 | 31.8906882591093 | 247 | 9 | 100 | 0 | 1 | 247 | 512231 | 512477 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 7877 | 407 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 9524733 | 9524733 | PRJNA624323_P_NODE_6648_length_277_cov_3.828431_g6486_i0 | PRJNA624323 | 6648 | 277 | 3.828431 | 10.60475387 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 477 | 3.5499999999999992e-130 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g6486 | i0 | 97.826 | 219.223826714801 | 276 | 6 | 99 | 0 | 2 | 277 | 511856 | 511581 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 60725 | 477 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 12075747 | 12075747 | PRJNA624323_P_NODE_9550_length_241_cov_0.916667_g9388_i0 | PRJNA624323 | 9550 | 241 | 0.916667 | 2.20916747 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 193 | 1.23e-44 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g9388 | i0 | 83.981 | 33.2448132780083 | 206 | 28 | 84 | 4 | 40 | 241 | 3448266 | 3448470 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 8012 | 193 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 13350536 | 13350536 | PRJNA624323_P_NODE_3251_length_409_cov_1.571429_g3090_i0 | PRJNA624323 | 3251 | 409 | 1.571429 | 6.42714461 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 590 | 6.729999999999998e-164 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g3090 | i0 | 92.683 | 100.689486552567 | 410 | 29 | 100 | 1 | 1 | 409 | 3447261 | 3446852 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 41182 | 590 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 19001623 | 19001623 | PRJNA624323_P_NODE_9955_length_226_cov_2.483660_g9793_i0 | PRJNA624323 | 9955 | 226 | 2.48366 | 5.6130716 | Bdellovibrio | 958 | Bacteria | Bacteria | 230 | 8.659999999999999e-56 | NTclustered | gi|2800948966|gb|CP168973.1| | 959 | g9793 | i0 | 90.751 | 54.6238938053097 | 173 | 14 | 77 | 2 | 21 | 193 | 816492 | 816662 | Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome | blastn | 12345 | 230 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 29101704 | 29101704 | PRJNA624323_P_NODE_8448_length_248_cov_0.880000_g8286_i0 | PRJNA624323 | 8448 | 248 | 0.88 | 2.1824 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 168 | 1.4699999999999998e-48 | NR | MBX2993231.1 | 2026715 | g8286 | i0 | 97.6 | 0.991935483870968 | 82 | 2 | 99.2 | 0 | 247 | 2 | 269 | 350 | MBX2993231.1 site-specific integrase [Pseudobdellovibrionaceae bacterium] | diamond | 246 | 168 | 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);;