contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 638220 | 638220 | PRJNA670521_P_NODE_45821_length_307_cov_0.888889_g45076_i0 | PRJNA670521 | 45821 | 307 | 0.888889 | 2.72888923 | Pseudobdellovibrio sp. HCB154 | 3386277 | Bacteria | Bacteria | 442 | 1.4499999999999995e-119 | NTclustered | gi|2872995934|gb|CP176530.1| | 3386277 | g45076 | i0 | 92.557 | 83.6351791530945 | 309 | 21 | 100 | 2 | 1 | 307 | 700328 | 700020 | Pseudobdellovibrio sp. HCB154 chromosome, complete genome | blastn | 25676 | 442 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio sp. HCB154 | ||
| 3716669 | 3716669 | PRJNA670521_P_NODE_47363_length_302_cov_2.248908_g46618_i0 | PRJNA670521 | 47363 | 302 | 2.248908 | 6.79170216 | Peredibacter | 263370 | Bacteria | Bacteria | 547 | 2.9399999999999987e-151 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g46618 | i0 | 99.338 | 120.513245033113 | 302 | 2 | 100 | 0 | 1 | 302 | 511020 | 511321 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 36395 | 547 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 5741667 | 5741667 | PRJNA670521_P_NODE_53945_length_286_cov_1.802817_g53200_i0 | PRJNA670521 | 53945 | 286 | 1.802817 | 5.15605662 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 497 | 2.82e-136 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g53200 | i0 | 97.917 | 182.468531468531 | 288 | 4 | 100 | 1 | 1 | 286 | 511692 | 511979 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 52186 | 497 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 21040705 | 21040705 | PRJNA670521_P_NODE_53717_length_287_cov_1.233645_g52972_i0 | PRJNA670521 | 53717 | 287 | 1.233645 | 3.54056115 | Bdellovibrio sp. qaytius | 1916293 | Bacteria | Bacteria | 368 | 2.32e-97 | NTclustered | gi|1552089877|gb|CP025734.1| | 1916293 | g52972 | i0 | 89.726 | 165.369337979094 | 292 | 25 | 100 | 4 | 1 | 287 | 666734 | 666443 | Bdellovibrio sp. qaytius chromosome, complete genome | blastn | 47461 | 368 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. qaytius | ||
| 24116817 | 24116817 | PRJNA670521_P_NODE_51819_length_291_cov_1.701835_g51074_i0 | PRJNA670521 | 51819 | 291 | 1.701835 | 4.95233985 | Peredibacter | 263370 | Bacteria | Bacteria | 477 | 3.75e-130 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g51074 | i0 | 96.22 | 200.305841924399 | 291 | 11 | 100 | 0 | 1 | 291 | 512969 | 512679 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 58289 | 477 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii |
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);;