metadata: contig_metadata: 6 rows where bioproject = "PRJNA1073712", tax_kingdom = "Pseudomonadati" and tax

6 rows where bioproject = "PRJNA1073712", tax_kingdom = "Pseudomonadati" 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
5290433	5290433	PRJNA1073712_P_NODE_3565_length_373_cov_1.540000_g3482_i0	PRJNA1073712	3565	373	1.54	5.7442	Peredibacter starrii	28202	Bacteria	Bacteria	675	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g3482	i0	99.2	170.436997319035	375	1	100	2	1	373	512148	511774	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	63573	675	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
25242524	25242524	PRJNA1073712_P_NODE_7800_length_284_cov_2.421801_g7717_i0	PRJNA1073712	7800	284	2.421801	6.87791484	Peredibacter	263370	Bacteria	Bacteria	429	1.04e-115	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g7717	i0	94.909	108.028169014085	275	13	97	1	2	276	512478	512205	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	30680	433	0.990762124711316	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
27446878	27446878	PRJNA1073712_P_NODE_15283_length_244_cov_0.900585_g15200_i0	PRJNA1073712	15283	244	0.900585	2.1974274	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	139	7.72e-38	NR	PZP55147.1	349221	g15200	i0	90	0.983606557377049	80	8	98.4	0	3	242	237	316	PZP55147.1 MAG: hypothetical protein DI586_07735 [Micavibrio aeruginosavorus]	diamond	240	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
30288970	30288970	PRJNA1073712_P_NODE_13492_length_247_cov_0.885057_g13409_i0	PRJNA1073712	13492	247	0.885057	2.18609079	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	60.1	6.42e-10	NR	MBX2987089.1	2026715	g13409	i0	79.5	0.473684210526316	39	8	47.4	0	129	245	1	39	MBX2987089.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	117	60.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
31331280	31331280	PRJNA1073712_P_NODE_12776_length_248_cov_0.880000_g12693_i0	PRJNA1073712	12776	248	0.88	2.1824	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	141	7.14e-39	NR	PZP56550.1	349221	g12693	i0	87.7	0.979838709677419	81	10	98	0	244	2	199	279	PZP56550.1 MAG: glycerol-3-phosphate acyltransferase [Micavibrio aeruginosavorus]	diamond	243	141	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
32722643	32722643	PRJNA1073712_P_NODE_12520_length_249_cov_0.875000_g12437_i0	PRJNA1073712	12520	249	0.875	2.17875	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	123	2.33e-32	NR	PZP57235.1	349221	g12437	i0	68.3	0.987951807228916	82	26	98.8	0	3	248	11	92	PZP57235.1 MAG: aminodeoxychorismate synthase component I, partial [Micavibrio aeruginosavorus]	diamond	246	123	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus

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