metadata: contig_metadata: 7 rows where bioproject = "PRJNA1164198", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA1164198", 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
311956	311956	PRJNA1164198_P_NODE_16001_length_309_cov_2.665254_g15732_i0	PRJNA1164198	16001	309	2.665254	8.23563486	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	405	1.92e-108	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g15732	i0	92.58	236.433656957929	283	19	91	2	27	308	612462	612743	Bdellovibrio bacteriovorus W, complete genome	blastn	73058	405	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27704219	27704219	PRJNA1164198_P_NODE_30304_length_243_cov_0.917647_g30035_i0	PRJNA1164198	30304	243	0.917647	2.22988221	Bacteriovorax antarcticus	3088717	Bacteria	Bacteria	101	2.64e-23	NR	WP_323578327.1	3088717	g30035	i0	97.9	0.580246913580247	47	1	58	0	101	241	131	177	WP_323578327.1 hypothetical protein [Bacteriovorax antarcticus]	diamond	141	101	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax antarcticus
27830138	27830138	PRJNA1164198_P_NODE_27304_length_248_cov_0.891429_g27035_i0	PRJNA1164198	27304	248	0.891429	2.21074392	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	146	3.849999999999999e-40	NR	MBX2996455.1	2026715	g27035	i0	100	0.991935483870968	82	0	99.2	0	248	3	100	181	MBX2996455.1 AgmX/PglI C-terminal domain-containing protein [Pseudobdellovibrionaceae bacterium]	diamond	246	146	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28872008	28872008	PRJNA1164198_P_NODE_18328_length_289_cov_1.722222_g18059_i0	PRJNA1164198	18328	289	1.722222	4.97722158	Oligoflexia bacterium	2599941	Bacteria	Bacteria	43.1	0.0468	NR	MCO5141485.1	2599941	g18059	i0	44.2	0.44636678200692	43	24	44.6	0	3	131	573	615	MCO5141485.1 hypothetical protein [Oligoflexia bacterium]	diamond	129	43.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
29061706	29061706	PRJNA1164198_P_NODE_21988_length_265_cov_1.536458_g21719_i0	PRJNA1164198	21988	265	1.536458	4.0716137	Oligoflexia bacterium	2599941	Bacteria	Bacteria	88.2	2.44e-18	NR	MDR3608176.1	2599941	g21719	i0	42.3	1.09811320754717	97	46	98.5	1	5	265	246	342	MDR3608176.1 glycerophosphodiester phosphodiesterase [Oligoflexia bacterium]	diamond	291	88.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
30767173	30767173	PRJNA1164198_P_NODE_30994_length_242_cov_0.923077_g30725_i0	PRJNA1164198	30994	242	0.923077	2.23384634	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	167	1.43e-48	NR	MBX2993904.1	2026715	g30725	i0	100	0.966942148760331	78	0	96.7	0	2	235	287	364	MBX2993904.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	234	167	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
31810453	31810453	PRJNA1164198_P_NODE_25937_length_250_cov_0.881356_g25668_i0	PRJNA1164198	25937	250	0.881356	2.20339	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	94.7	5.5e-21	NR	WP_061833723.1	959	g25668	i0	66.7	0.756	63	21	75.6	0	190	2	1	63	WP_061833723.1 pectin acetylesterase-family hydrolase [Bdellovibrio bacteriovorus]	diamond	189	94.7	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);;