metadata: contig_metadata: 13 rows where bioproject = "PRJNA1255065", tax_kingdom = "Pseudomonadati" and tax

13 rows where bioproject = "PRJNA1255065", 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
11256349	11256349	PRJNA1255065_P_NODE_127369_length_166_cov_0.888889_g125141_i0	PRJNA1255065	127369	166	0.888889	1.47555574	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	109	2e-27	NR	NUM89470.1	2053517	g125141	i0	88.9	2.92771084337349	54	6	97.6	0	164	3	21	74	NUM89470.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	486	109	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
15663117	15663117	PRJNA1255065_P_NODE_148213_length_162_cov_1.070796_g145985_i0	PRJNA1255065	148213	162	1.070796	1.73468952	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	220	3.49e-53	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g145985	i0	91.411	162.617283950617	163	10	99	4	1	161	665622	665462	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	26344	220	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
18904560	18904560	PRJNA1255065_P_NODE_124315_length_166_cov_0.888889_g122087_i0	PRJNA1255065	124315	166	0.888889	1.47555574	Peredibacter	263370	Bacteria	Bacteria	278	2.11e-70	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g122087	i0	96.97	242.253012048193	165	5	99	0	2	166	511499	511335	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	40214	278	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
27010418	27010418	PRJNA1255065_P_NODE_125962_length_166_cov_0.888889_g123734_i0	PRJNA1255065	125962	166	0.888889	1.47555574	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	75.5	2.76e-15	NR	WP_158320220.1	959	g123734	i0	67.3	0.993975903614458	55	18	99.4	0	166	2	102	156	WP_158320220.1 flagellar protein FlgN [Bdellovibrio bacteriovorus]	diamond	165	75.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27439637	27439637	PRJNA1255065_P_NODE_132823_length_165_cov_0.896552_g130595_i0	PRJNA1255065	132823	165	0.896552	1.4793108	Bdellovibrio	958	Bacteria	Bacteria	65.9	8.36e-11	NR	WP_088615336.1	1732569	g130595	i0	50	3.92727272727273	54	27	98.2	0	164	3	141	194	WP_088615336.1 aminotransferase class V-fold PLP-dependent enzyme [Bdellovibrio sp. SKB1291214]	diamond	648	66.2	0.995468277945619	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
27579294	27579294	PRJNA1255065_P_NODE_123784_length_166_cov_0.888889_g121556_i0	PRJNA1255065	123784	166	0.888889	1.47555574	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	85.9	5.77e-18	NR	HEY8278379.1	3034175	g121556	i0	85.5	0.993975903614458	55	8	99.4	0	165	1	168	222	HEY8278379.1 peptidoglycan DD-metalloendopeptidase family protein [Bdellovibrionota bacterium]	diamond	165	85.9	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27769023	27769023	PRJNA1255065_P_NODE_129304_length_165_cov_0.896552_g127076_i0	PRJNA1255065	129304	165	0.896552	1.4793108	Oligoflexus sp.	1971216	Bacteria	Bacteria	84.7	7.26e-19	NR	MBC7533558.1	1971216	g127076	i0	95.1	0.745454545454545	41	2	74.5	0	128	6	1	41	MBC7533558.1 flagellar assembly protein FliW [Oligoflexus sp.]	diamond	123	84.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
28242218	28242218	PRJNA1255065_P_NODE_137386_length_164_cov_0.904348_g135158_i0	PRJNA1255065	137386	164	0.904348	1.48313072	Bdellovibrio sp. 28-41-41	1970323	Bacteria	Bacteria	97.1	4.8799999999999997e-23	NR	OYZ24520.1	1970323	g135158	i0	75.9	1.97560975609756	54	13	98.8	0	3	164	110	163	OYZ24520.1 MAG: hydroxyacylglutathione hydrolase [Bdellovibrio sp. 28-41-41]	diamond	324	97.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 28-41-41
29491589	29491589	PRJNA1255065_P_NODE_126110_length_166_cov_0.888889_g123882_i0	PRJNA1255065	126110	166	0.888889	1.47555574	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	62.4	1.47e-9	NR	AZZ37131.1	1916293	g123882	i0	79.5	2.81927710843373	39	8	70.5	0	119	3	2	40	AZZ37131.1 pilus assembly protein PilM [Bdellovibrio sp. qaytius]	diamond	468	62.8	0.993630573248408	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
29726087	29726087	PRJNA1255065_P_NODE_135310_length_164_cov_0.904348_g133082_i0	PRJNA1255065	135310	164	0.904348	1.48313072	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	72.4	4.39e-13	NR	MCB0411610.1	2053517	g133082	i0	66	0.914634146341463	50	17	91.5	0	151	2	179	228	MCB0411610.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	150	72.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31938612	31938612	PRJNA1255065_P_NODE_133837_length_165_cov_0.896552_g131609_i0	PRJNA1255065	133837	165	0.896552	1.4793108	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	115	3.3e-30	NR	WP_413940980.1	3394362	g131609	i0	94.4	2.94545454545455	54	3	98.2	0	2	163	15	68	WP_413940980.1 site-2 protease family protein [Bdellovibrio sp. HCB2-146]	diamond	486	115	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
32287133	32287133	PRJNA1255065_P_NODE_108219_length_169_cov_0.866667_g105991_i0	PRJNA1255065	108219	169	0.866667	1.46466723	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	71.2	1.35e-13	NR	HEY8278553.1	3034175	g105991	i0	66.1	0.994082840236686	56	19	99.4	0	168	1	88	143	HEY8278553.1 ATP synthase F1 subunit delta [Bdellovibrionota bacterium]	diamond	168	71.2	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
32886234	32886234	PRJNA1255065_P_NODE_112880_length_168_cov_0.873950_g110652_i0	PRJNA1255065	112880	168	0.87395	1.468236	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	107	2.32e-25	NR	HLW57781.1	2081706	g110652	i0	87.5	3	56	7	100	0	1	168	178	233	HLW57781.1 aminopeptidase N [Bacteriovoracaceae bacterium]	diamond	504	107	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);;