contig_metadata
4 rows where bioproject = "PRJNA983848", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7649564 | 7649564 | PRJNA983848_P_NODE_165786_length_228_cov_2.012903_g159903_i0 | PRJNA983848 | 165786 | 228 | 2.012903 | 4.5894188400000004 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 357 | 3.85e-94 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g159903 | i0 | 94.805 | 135.394736842105 | 231 | 9 | 100 | 2 | 1 | 228 | 848 | 618 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 30870 | 357 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 9895731 | 9895731 | PRJNA983848_P_NODE_141308_length_251_cov_1.314607_g135425_i0 | PRJNA983848 | 141308 | 251 | 1.314607 | 3.29966357 | Bacteriovorax stolpii | 960 | Bacteria | Bacteria | 392 | 1.18e-104 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g135425 | i0 | 94.821 | 2 | 251 | 13 | 100 | 0 | 1 | 251 | 1001498 | 1001748 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 502 | 392 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 14996179 | 14996179 | PRJNA983848_P_NODE_160992_length_241_cov_2.279762_g155109_i0 | PRJNA983848 | 160992 | 241 | 2.279762 | 5.49422642 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 265 | 2.5599999999999996e-66 | NTclustered | gi|2258818259|gb|CP060220.1| | 2026715 | g155109 | i0 | 87.826 | 160.298755186722 | 230 | 22 | 94 | 5 | 15 | 241 | 3251641 | 3251867 | MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome | blastn | 38632 | 265 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 27721809 | 27721809 | PRJNA983848_P_NODE_108604_length_289_cov_1.379630_g102721_i0 | PRJNA983848 | 108604 | 289 | 1.37963 | 3.9871307 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 43.1 | 0.0387 | NR | MEC9282068.1 | 3034175 | g102721 | i0 | 36.1 | 0.633217993079585 | 61 | 38 | 62.3 | 1 | 102 | 281 | 110 | 170 | MEC9282068.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 183 | 43.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota 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);;