metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB81327" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB81327" 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
3547870	3547870	PRJEB81327_P_NODE_8383_length_480_cov_1.786241_g7776_i0	PRJEB81327	8383	480	1.786241	8.5739568	Bacteriovorax	146784	Bacteria	Bacteria	859	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g7776	i0	98.96	97.1666666666667	481	4	100	1	1	480	1661547	1662027	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	46640	859	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
9066876	9066876	PRJEB81327_P_NODE_16428_length_333_cov_2.315385_g15820_i0	PRJEB81327	16428	333	2.315385	7.71023205	Peredibacter starrii	28202	Bacteria	Bacteria	442	1.5899999999999995e-119	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g15820	i0	90.746	113.606606606607	335	26	100	5	1	333	511037	510706	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	37831	442	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
11618208	11618208	PRJEB81327_P_NODE_22610_length_293_cov_3.068182_g22002_i0	PRJEB81327	22610	293	3.068182	8.98977326	Peredibacter starrii	28202	Bacteria	Bacteria	521	1.7199999999999993e-143	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g22002	i0	98.644	189.81228668942	295	2	100	1	1	293	512018	511724	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	55615	521	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
11618696	11618696	PRJEB81327_P_NODE_63630_length_242_cov_0.911243_g63022_i0	PRJEB81327	63630	242	0.911243	2.20520806	Bacteriovorax stolpii	960	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g63022	i0	100	3	242	0	100	0	1	242	2982866	2982625	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	726	448	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
15442381	15442381	PRJEB81327_P_NODE_38853_length_263_cov_1.573684_g38245_i0	PRJEB81327	38853	263	1.573684	4.13878892	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	361	3.51e-95	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g38245	i0	93.443	166.67680608365	244	14	92	2	20	262	3251008	3250766	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	43836	361	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
17991812	17991812	PRJEB81327_P_NODE_9515_length_446_cov_2.504021_g8907_i0	PRJEB81327	9515	446	2.504021	11.16793366	Peredibacter starrii	28202	Bacteria	Bacteria	789	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g8907	i0	98.655	71.8677130044843	446	5	100	1	1	446	511913	512357	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	32053	789	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
19265121	19265121	PRJEB81327_P_NODE_17916_length_319_cov_3.276423_g17308_i0	PRJEB81327	17916	319	3.276423	10.45178937	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	477	4.159999999999998e-130	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g17308	i0	93.73	42.6300940438871	319	19	100	1	1	319	1292383	1292700	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	13599	477	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
21816834	21816834	PRJEB81327_P_NODE_5698_length_604_cov_2.391714_g5116_i0	PRJEB81327	5698	604	2.391714	14.44595256	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	645	2.159999999999999e-180	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g5116	i0	86.013	211.566225165563	622	64	100	14	1	604	659803	659187	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	127786	645	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
23091998	23091998	PRJEB81327_P_NODE_55979_length_246_cov_0.890173_g55371_i0	PRJEB81327	55979	246	0.890173	2.18982558	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	272	1.5699999999999999e-68	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g55371	i0	86.585	343.325203252033	246	33	100	0	1	246	612961	613206	Bdellovibrio bacteriovorus W, complete genome	blastn	84458	272	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus

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