contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA608660" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1860814 | 1860814 | PRJNA608660_P_NODE_5282_length_634_cov_6.505983_g4981_i0 | PRJNA608660 | 5282 | 634 | 6.505983 | 41.24793222 | Bdellovibrio sp. qaytius | 1916293 | Bacteria | Bacteria | 254 | 1.61e-62 | NTclustered | gi|1552089877|gb|CP025734.1| | 1916293 | g4981 | i0 | 82.807 | 0.449526813880126 | 285 | 48 | 45 | 1 | 33 | 317 | 2130176 | 2130459 | Bdellovibrio sp. qaytius chromosome, complete genome | blastn | 285 | 254 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. qaytius | ||
| 2422105 | 2422105 | PRJNA608660_P_NODE_12622_length_417_cov_2.695652_g12274_i0 | PRJNA608660 | 12622 | 417 | 2.695652 | 11.24086884 | Bacteriovorax | 146784 | Bacteria | Bacteria | 678 | 0 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g12274 | i0 | 96.798 | 95.4460431654676 | 406 | 13 | 97 | 0 | 4 | 409 | 1661573 | 1661978 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 39801 | 678 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 12625895 | 12625895 | PRJNA608660_P_NODE_19130_length_325_cov_4.094203_g18774_i0 | PRJNA608660 | 19130 | 325 | 4.094203 | 13.30615975 | Peredibacter | 263370 | Bacteria | Bacteria | 545 | 1.15e-150 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g18774 | i0 | 98.697 | 179.104615384615 | 307 | 4 | 94 | 0 | 19 | 325 | 511414 | 511108 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 58209 | 545 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 13338635 | 13338635 | PRJNA608660_P_NODE_13611_length_399_cov_3.380000_g13260_i0 | PRJNA608660 | 13611 | 399 | 3.38 | 13.4862 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 640 | 6.41e-179 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g13260 | i0 | 96.632 | 9.3734335839599 | 386 | 11 | 96 | 2 | 15 | 399 | 512477 | 512093 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 3740 | 640 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 13338861 | 13338861 | PRJNA608660_P_NODE_35471_length_207_cov_1.417722_g35115_i0 | PRJNA608660 | 35471 | 207 | 1.417722 | 2.93468454 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 191 | 3.68e-44 | NTclustered | gi|2258818259|gb|CP060220.1| | 2026715 | g35115 | i0 | 83.824 | 85.8937198067633 | 204 | 30 | 98 | 3 | 1 | 203 | 3251773 | 3251572 | MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome | blastn | 17780 | 191 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 22261795 | 22261795 | PRJNA608660_P_NODE_29938_length_236_cov_1.598930_g29582_i0 | PRJNA608660 | 29938 | 236 | 1.59893 | 3.7734748 | Bdellovibrio sp. HCB-162 | 3394234 | Bacteria | Bacteria | 233 | 7.039999999999999e-57 | NTclustered | gi|2898207634|gb|CP178861.1| | 3394234 | g29582 | i0 | 85.088 | 0.966101694915254 | 228 | 34 | 97 | 0 | 1 | 228 | 1628321 | 1628094 | Bdellovibrio sp. HCB-162 chromosome, complete genome | blastn | 228 | 233 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB-162 | ||
| 23536981 | 23536981 | PRJNA608660_P_NODE_1119_length_1087_cov_6.196532_g974_i0 | PRJNA608660 | 1119 | 1087 | 6.196532 | 67.35630284 | Bdellovibrio sp. qaytius | 1916293 | Bacteria | Bacteria | 859 | 0 | NTclustered | gi|1552089877|gb|CP025734.1| | 1916293 | g974 | i0 | 85.766 | 136.804047838086 | 829 | 98 | 75 | 18 | 257 | 1075 | 666868 | 666050 | Bdellovibrio sp. qaytius chromosome, complete genome | blastn | 148706 | 859 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. qaytius |
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);;