contig_metadata
4 rows where bioproject = "PRJNA451191" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1092740 | 1092740 | PRJNA451191_P_NODE_53801_length_203_cov_0.915493_g53530_i0 | PRJNA451191 | 53801 | 203 | 0.915493 | 1.85845079 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 353 | 4.33e-93 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g53530 | i0 | 98.03 | 182.408866995074 | 203 | 4 | 100 | 0 | 1 | 203 | 1216 | 1014 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 37029 | 353 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 2990607 | 2990607 | PRJNA451191_P_NODE_18103_length_339_cov_9.370504_g17832_i0 | PRJNA451191 | 18103 | 339 | 9.370504 | 31.76600856 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 499 | 9.51e-137 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g17832 | i0 | 93.215 | 101.955752212389 | 339 | 23 | 100 | 0 | 1 | 339 | 3446972 | 3447310 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 34563 | 499 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 8745695 | 8745695 | PRJNA451191_P_NODE_42727_length_218_cov_0.828025_g42456_i0 | PRJNA451191 | 42727 | 218 | 0.828025 | 1.8050945 | Peredibacter | 263370 | Bacteria | Bacteria | 368 | 1.68e-97 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g42456 | i0 | 98.558 | 89.3256880733945 | 208 | 3 | 95 | 0 | 11 | 218 | 513594 | 513387 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 19473 | 368 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 15742929 | 15742929 | PRJNA451191_P_NODE_27013_length_273_cov_2.933962_g26742_i0 | PRJNA451191 | 27013 | 273 | 2.933962 | 8.00971626 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 438 | 1.6499999999999995e-118 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g26742 | i0 | 95.604 | 97.6556776556776 | 273 | 12 | 100 | 0 | 1 | 273 | 3446952 | 3446680 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 26660 | 438 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 |
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);;