metadata: contig_metadata: 10 rows where bioproject = "PRJEB55250", tax_phylum = "Bdellovibrionota" and tax

10 rows where bioproject = "PRJEB55250", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

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
7774262	7774262	PRJEB55250_P_NODE_4727_length_322_cov_1.293173_g4603_i0	PRJEB55250	4727	322	1.293173	4.16401706	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	556	5.25e-154	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g4603	i0	97.826	198.717391304348	322	7	100	0	1	322	660312	660633	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	63987	556	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
17973369	17973369	PRJEB55250_P_NODE_16335_length_241_cov_1.732143_g16211_i0	PRJEB55250	16335	241	1.732143	4.17446463	Bacteriovorax stolpii	960	Bacteria	Bacteria	375	1.1299999999999998e-99	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g16211	i0	94.979	2.98340248962656	239	12	99	0	1	239	1109992	1110230	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	719	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18843466	18843466	PRJEB55250_P_NODE_2335_length_428_cov_2.157746_g2212_i0	PRJEB55250	2335	428	2.157746	9.23515288	Peredibacter	263370	Bacteria	Bacteria	669	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2212	i0	94.86	190.707943925234	428	22	100	0	1	428	511270	511697	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	81623	675	0.991111111111111	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
21393981	21393981	PRJEB55250_P_NODE_5777_length_298_cov_2.791111_g5653_i0	PRJEB55250	5777	298	2.791111	8.31751078	Bacteriovorax	146784	Bacteria	Bacteria	507	4.92e-139	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g5653	i0	97.315	307.456375838926	298	8	100	0	1	298	1660838	1660541	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	91622	507	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
24347679	24347679	PRJEB55250_P_NODE_4560_length_326_cov_3.624506_g4436_i0	PRJEB55250	4560	326	3.624506	11.81588956	Peredibacter starrii	28202	Bacteria	Bacteria	553	6.889999999999998e-153	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4436	i0	97.531	27.8374233128834	324	7	99	1	3	326	512477	512155	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	9075	553	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
28044294	28044294	PRJEB55250_P_NODE_8305_length_274_cov_1.467662_g8181_i0	PRJEB55250	8305	274	1.467662	4.02139388	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	144	3.85e-39	NR	MFA5583056.1	2081706	g8181	i0	78.2	2.89051094890511	87	19	95.3	0	272	12	139	225	MFA5583056.1 DUF3458 domain-containing protein [Bacteriovoracaceae bacterium]	diamond	792	144	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
31076351	31076351	PRJEB55250_P_NODE_14135_length_246_cov_0.890173_g14011_i0	PRJEB55250	14135	246	0.890173	2.18982558	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	82	2.3e-17	NR	HXH76339.1	2081706	g14011	i0	87.2	0.573170731707317	47	6	57.3	0	245	105	128	174	HXH76339.1 NADH-quinone oxidoreductase subunit J [Bacteriovoracaceae bacterium]	diamond	141	82	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
31202138	31202138	PRJEB55250_P_NODE_10455_length_258_cov_1.389189_g10331_i0	PRJEB55250	10455	258	1.389189	3.58410762	Bdellovibrio bacteriovorus W	765869	Bacteria	Bacteria	51.2	1.04e-5	NR	AHI05177.1	765869	g10331	i0	54.3	1.08139534883721	46	21	53.5	0	119	256	4	49	AHI05177.1 transposase [Bdellovibrio bacteriovorus W]	diamond	279	51.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
31866674	31866674	PRJEB55250_P_NODE_8537_length_272_cov_1.547739_g8413_i0	PRJEB55250	8537	272	1.547739	4.20985008	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	92	2.52e-20	NR	MEK6554738.1	3034175	g8413	i0	52.3	1.95220588235294	86	41	94.9	0	258	1	90	175	MEK6554738.1 hybrid sensor histidine kinase/response regulator [Bdellovibrionota bacterium]	diamond	531	92	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
32625801	32625801	PRJEB55250_P_NODE_11800_length_251_cov_0.865169_g11676_i0	PRJEB55250	11800	251	0.865169	2.17157419	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	117	1.33e-28	NR	MFA5584434.1	2081706	g11676	i0	72.3	0.99203187250996006	83	23	99.2	0	1	249	171	253	MFA5584434.1 FtsX-like permease family protein [Bacteriovoracaceae bacterium]	diamond	249	117	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae 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);;