metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA874604" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA874604" and tax_phylum = "Bdellovibrionota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3402520	3402520	PRJNA874604_P_NODE_38243_length_314_cov_2.655602_g37891_i0	PRJNA874604	38243	314	2.655602	8.33859028	Peredibacter starrii	28202	Bacteria	Bacteria	536	6.649999999999999e-148	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g37891	i0	97.452	57.4872611464968	314	8	100	0	1	314	512329	512016	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	18051	536	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
8891332	8891332	PRJNA874604_P_NODE_95187_length_242_cov_1.384615_g94835_i0	PRJNA874604	95187	242	1.384615	3.3507683	Bacteriovorax	146784	Bacteria	Bacteria	409	1.12e-109	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g94835	i0	97.107	203.206611570248	242	7	100	0	1	242	1660773	1660532	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	49176	409	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
16155461	16155461	PRJNA874604_P_NODE_87833_length_245_cov_0.895349_g87481_i0	PRJNA874604	87833	245	0.895349	2.19360505	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	259	1.21e-64	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g87481	i0	85.772	3.01224489795918	246	33	100	2	1	245	2106095	2105851	Bacteriovorax sp. HI3 DNA, complete genome	blastn	738	259	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
19979590	19979590	PRJNA874604_P_NODE_94616_length_243_cov_0.905882_g94264_i0	PRJNA874604	94616	243	0.905882	2.20129326	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	193	1.24e-44	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g94264	i0	83.333	0.864197530864197	210	33	86	2	1	209	3692010	3692218	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	210	193	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
21253676	21253676	PRJNA874604_P_NODE_26737_length_360_cov_1.073171_g26385_i0	PRJNA874604	26737	360	1.073171	3.8634156	Bdellovibrio sp. HM001	3113894	Bacteria	Bacteria	398	3.8e-106	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g26385	i0	86.63	0.997222222222222	359	48	99	0	1	359	3486622	3486980	Bdellovibrio sp. HM001 DNA, complete genome	blastn	359	398	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
23804643	23804643	PRJNA874604_P_NODE_71779_length_250_cov_0.870056_g71427_i0	PRJNA874604	71779	250	0.870056	2.17514	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	383	7.07e-102	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g71427	i0	94.378	2.996	249	14	99	0	1	249	3010651	3010403	Bacteriovorax sp. HI3 DNA, complete genome	blastn	749	383	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3

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);;