metadata: contig_metadata: 17 rows where bioproject = "PRJNA929922", tax_kingdom = "Pseudomonadati" and tax

17 rows where bioproject = "PRJNA929922", 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
6011826	6011826	PRJNA929922_S_NODE_58765_length_254_cov_3.513812_g58541_i0	PRJNA929922	58765	254	3.513812	8.92508248	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	372	1.56e-98	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g58541	i0	96.053	91.2637795275591	228	9	90	0	21	248	1292537	1292764	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	23181	372	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
6357658	6357658	PRJNA929922_P_NODE_159045_length_242_cov_0.911243_g158505_i0	PRJNA929922	159045	242	0.911243	2.20520806	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	132	1.3e-34	NR	MBS1962476.1	2053517	g158505	i0	81.3	0.991735537190083	80	15	99.2	0	3	242	237	316	MBS1962476.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	240	132	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26905495	26905495	PRJNA929922_P_NODE_149941_length_243_cov_0.905882_g149401_i0	PRJNA929922	149941	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	53.5	4.77e-6	NR	WP_338635669.1	495820	g149401	i0	48.9	2.34567901234568	47	24	58	0	221	81	59	105	WP_338635669.1 IS66 family transposase [Spirobacillus cienkowskii]	diamond	570	53.9	0.992578849721707	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales		Spirobacillus	Spirobacillus cienkowskii
26930001	26930001	PRJNA929922_P_NODE_117402_length_249_cov_0.875000_g116862_i0	PRJNA929922	117402	249	0.875	2.17875	Bdellovibrionales bacterium GWB1_55_8	1797386	Bacteria	Bacteria	111	1.63e-26	NR	OFZ21655.1	1797386	g116862	i0	63.4	1.97590361445783	82	30	98.8	0	3	248	318	399	OFZ21655.1 MAG: hypothetical protein A2X94_07850 [Bdellovibrionales bacterium GWB1_55_8]	diamond	492	111	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium GWB1_55_8
27119452	27119452	PRJNA929922_P_NODE_134042_length_246_cov_0.890173_g133502_i0	PRJNA929922	134042	246	0.890173	2.18982558	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	43.9	0.00143	NR	WP_088565424.1	959	g133502	i0	46.3	0.658536585365854	54	24	65.9	1	176	15	10	58	WP_088565424.1 hypothetical protein [Bdellovibrio bacteriovorus]	diamond	162	43.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27246112	27246112	PRJNA929922_P_NODE_112463_length_250_cov_0.870056_g111923_i0	PRJNA929922	112463	250	0.870056	2.17514	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	48.5	1.55e-4	NR	WP_413941755.1	3394362	g111923	i0	32.2	0.708	59	40	70.8	0	180	4	32	90	WP_413941755.1 hypothetical protein [Bdellovibrio sp. HCB2-146]	diamond	177	48.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
27625350	27625350	PRJNA929922_P_NODE_163164_length_241_cov_0.916667_g162624_i0	PRJNA929922	163164	241	0.916667	2.20916747	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	70.9	1.73e-13	NR	MBS1961324.1	2053517	g162624	i0	81	0.522821576763486	42	8	52.3	0	111	236	1	42	MBS1961324.1 helix-turn-helix domain-containing protein [Bdellovibrionales bacterium]	diamond	126	70.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28509293	28509293	PRJNA929922_P_NODE_117887_length_249_cov_0.875000_g117347_i0	PRJNA929922	117887	249	0.875	2.17875	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	146	1.28e-41	NR	MFN8792081.1	2053517	g117347	i0	78	0.987951807228916	82	18	98.8	0	2	247	26	107	MFN8792081.1 N-formylglutamate amidohydrolase [Bdellovibrionales bacterium]	diamond	246	146	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28572376	28572376	PRJNA929922_P_NODE_75747_length_284_cov_1.284360_g75207_i0	PRJNA929922	75747	284	1.28436	3.6475824	Halobacteriovoraceae bacterium	2026745	Bacteria	Bacteria	44.3	0.0153	NR	MCB9095004.1	2026745	g75207	i0	30.8	0.823943661971831	78	46	73.9	2	257	48	43	120	MCB9095004.1 Fpg/Nei family DNA glycosylase [Halobacteriovoraceae bacterium]	diamond	234	44.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
28730301	28730301	PRJNA929922_P_NODE_111787_length_250_cov_0.870056_g111247_i0	PRJNA929922	111787	250	0.870056	2.17514	Bdellovibrio sp. ArHS	1569284	Bacteria	Bacteria	100	3.28e-25	NR	WP_041875367.1	1569284	g111247	i0	75	0.816	68	17	81.6	0	46	249	1	68	WP_041875367.1 helix-turn-helix domain-containing protein [Bdellovibrio sp. ArHS]	diamond	204	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ArHS
29772049	29772049	PRJNA929922_P_NODE_148251_length_244_cov_0.877193_g147711_i0	PRJNA929922	148251	244	0.877193	2.14035092	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	60.1	2.9e-8	NR	MBY0314976.1	2053517	g147711	i0	47.2	0.885245901639344	72	37	87.3	1	26	238	3	74	MBY0314976.1 response regulator [Bdellovibrionales bacterium]	diamond	216	60.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30600602	30600602	PRJNA929922_P_NODE_123433_length_248_cov_0.880000_g122893_i0	PRJNA929922	123433	248	0.88	2.1824	Bdellovibrio	958	Bacteria	Bacteria	140	7.73e-37	NR	WP_291515649.1	1569284	g122893	i0	73.8	3.89516129032258	80	21	96.8	0	4	243	359	438	WP_291515649.1 S8 family serine peptidase [Bdellovibrio sp. ArHS]	diamond	966	140	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ArHS
30846418	30846418	PRJNA929922_P_NODE_138654_length_245_cov_0.895349_g138114_i0	PRJNA929922	138654	245	0.895349	2.19360505	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	140	1.11e-38	NR	MBX3021331.1	2053517	g138114	i0	86.4	2.97551020408163	81	11	99.2	0	1	243	85	165	MBX3021331.1 class II fructose-bisphosphatase [Bdellovibrionales bacterium]	diamond	729	140	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31295864	31295864	PRJNA929922_P_NODE_120355_length_249_cov_0.875000_g119815_i0	PRJNA929922	120355	249	0.875	2.17875	Bdellovibrio	958	Bacteria	Bacteria	109	1.07e-25	NR	WP_374074268.1	959	g119815	i0	57.8	6.96385542168675	83	35	100	0	1	249	410	492	WP_374074268.1 transglycosylase SLT domain-containing protein [Bdellovibrio bacteriovorus]	diamond	1734	110	0.990909090909091	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
32174760	32174760	PRJNA929922_P_NODE_144498_length_244_cov_0.900585_g143958_i0	PRJNA929922	144498	244	0.900585	2.1974274	Oligoflexia bacterium	2599941	Bacteria	Bacteria	52	2e-5	NR	MFN7685340.1	2599941	g143958	i0	43.1	2.54508196721311	65	37	79.9	0	230	36	363	427	MFN7685340.1 reverse transcriptase domain-containing protein [Oligoflexia bacterium]	diamond	621	52	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
32269654	32269654	PRJNA929922_P_NODE_123158_length_248_cov_0.880000_g122618_i0	PRJNA929922	123158	248	0.88	2.1824	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	100	2.67e-23	NR	PZQ46810.1	349221	g122618	i0	76.7	0.883064516129032	73	14	88.3	1	1	219	126	195	PZQ46810.1 MAG: ostA-like family protein [Micavibrio aeruginosavorus]	diamond	219	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
32491140	32491140	PRJNA929922_P_NODE_137079_length_246_cov_0.890173_g136539_i0	PRJNA929922	137079	246	0.890173	2.18982558	Oligoflexus sp.	1971216	Bacteria	Bacteria	110	5.62e-26	NR	WP_324952854.1	1971216	g136539	i0	60.5	1.97560975609756	81	32	98.8	0	244	2	88	168	WP_324952854.1 M1 family aminopeptidase [Oligoflexus sp.]	diamond	486	110	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.

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