metadata: contig_metadata: 18 rows where bioproject = "PRJNA971593", tax_kingdom = "Pseudomonadati" and tax

18 rows where bioproject = "PRJNA971593", 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
4772640	4772640	PRJNA971593_P_NODE_25904_length_246_cov_0.890173_g25755_i0	PRJNA971593	25904	246	0.890173	2.18982558	Bdellovibrionota	3018035	Bacteria	Bacteria	120	4.71e-30	NR	MBS1959460.1	2053517	g25755	i0	74.7	3.5609756097561	79	19	96.3	1	7	243	128	205	MBS1959460.1 methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [Bdellovibrionales bacterium]	diamond	876	121	0.991735537190083	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
18796013	18796013	PRJNA971593_P_NODE_19535_length_269_cov_1.178571_g19386_i0	PRJNA971593	19535	269	1.178571	3.17035599	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	139	1.48e-39	NR	MCB0394868.1	2053517	g19386	i0	73	1.98513011152416	89	24	99.3	0	1	267	3	91	MCB0394868.1 peroxiredoxin [Bdellovibrionales bacterium]	diamond	534	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26867934	26867934	PRJNA971593_P_NODE_17121_length_288_cov_1.195349_g16972_i0	PRJNA971593	17121	288	1.195349	3.44260512	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	73.2	1.03e-12	NR	MCB0386755.1	2053517	g16972	i0	44.6	0.958333333333333	92	36	86.5	5	27	275	285	370	MCB0386755.1 C1 family peptidase [Bdellovibrionales bacterium]	diamond	276	73.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27437052	27437052	PRJNA971593_P_NODE_3663_length_632_cov_1.377460_g3519_i0	PRJNA971593	3663	632	1.37746	8.7055472	Halobacteriovoraceae bacterium	2026745	Bacteria	Bacteria	91.3	1.2e-17	NR	MCB9093311.1	2026745	g3519	i0	36	0.816455696202532	172	95	81.6	3	115	630	32	188	MCB9093311.1 hypothetical protein [Halobacteriovoraceae bacterium]	diamond	516	91.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
27500027	27500027	PRJNA971593_P_NODE_103_length_2519_cov_21.611611_g63_i0	PRJNA971593	103	2519	21.611611	544.39648109	Bacteriovoracales bacterium	2497611	Bacteria	Bacteria	72	1.05e-8	NR	MDC0253985.1	2497611	g63	i0	37.5	0.123858674077015	104	56	11.3	2	515	231	737	840	MDC0253985.1 hypothetical protein [Bacteriovoracales bacterium]	diamond	312	72	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales			Bacteriovoracales bacterium
27790512	27790512	PRJNA971593_P_NODE_26864_length_244_cov_0.900585_g26715_i0	PRJNA971593	26864	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	107	6.63e-25	NR	MBC7659705.1	1971216	g26715	i0	56.6	5.7172131147541	76	33	93.4	0	243	16	156	231	MBC7659705.1 hypothetical protein [Oligoflexus sp.]	diamond	1395	107	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
27973565	27973565	PRJNA971593_P_NODE_25985_length_246_cov_0.890173_g25836_i0	PRJNA971593	25985	246	0.890173	2.18982558	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	62.8	3.3e-9	NR	MEK6705120.1	3034175	g25836	i0	40.3	1.95121951219512	77	44	91.5	1	227	3	267	343	MEK6705120.1 bifunctional UDP-sugar hydrolase/5'-nucleotidase [Bdellovibrionota bacterium]	diamond	480	62.8	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
28225859	28225859	PRJNA971593_P_NODE_13006_length_334_cov_1.475096_g12857_i0	PRJNA971593	13006	334	1.475096	4.92682064	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	93.6	4.25e-21	NR	MBX9767865.1	2053517	g12857	i0	43	0.961077844311377	107	61	96.1	0	321	1	22	128	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	321	93.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28358582	28358582	PRJNA971593_P_NODE_10966_length_365_cov_1.352740_g10817_i0	PRJNA971593	10966	365	1.35274	4.937501	Pseudomonadati	3379134	Bacteria	Bacteria	106	2.89e-25	NR	MAF98313.1	2024841	g10817	i0	51.4	4.47123287671233	105	46	86.3	1	49	363	27	126	MAF98313.1 hypothetical protein [Micavibrio sp.]	diamond	1632	106	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
28605067	28605067	PRJNA971593_P_NODE_9347_length_397_cov_1.422840_g9198_i0	PRJNA971593	9347	397	1.42284	5.6486748	Fluviispira multicolorata	2654512	Bacteria	Bacteria	64.3	6.16e-9	NR	WP_152212914.1	2654512	g9198	i0	53.6	0.423173803526448	56	26	42.3	0	169	2	409	464	WP_152212914.1 ABC transporter transmembrane domain-containing protein [Fluviispira multicolorata]	diamond	168	64.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Fluviispira	Fluviispira multicolorata
29488926	29488926	PRJNA971593_P_NODE_16370_length_295_cov_1.040541_g16221_i0	PRJNA971593	16370	295	1.040541	3.06959595	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	87.4	5.44e-20	NR	MCB0368288.1	2053517	g16221	i0	42.9	1.91186440677966	91	52	92.5	0	293	21	9	99	MCB0368288.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	564	87.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29741429	29741429	PRJNA971593_P_NODE_27850_length_243_cov_0.905882_g27701_i0	PRJNA971593	27850	243	0.905882	2.20129326	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	57	3.21e-7	NR	MBT3982485.1	2081706	g27701	i0	40.6	1.5679012345679	69	41	85.2	0	239	33	48	116	MBT3982485.1 fatty acid desaturase [Bacteriovoracaceae bacterium]	diamond	381	57	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
29962823	29962823	PRJNA971593_P_NODE_24911_length_247_cov_0.885057_g24762_i0	PRJNA971593	24911	247	0.885057	2.18609079	Oligoflexus sp.	1971216	Bacteria	Bacteria	43.9	0.0155	NR	WP_324957648.1	1971216	g24762	i0	32.9	1.68825910931174	85	49	97.2	2	2	241	288	369	WP_324957648.1 SpoIIE family protein phosphatase [Oligoflexus sp.]	diamond	417	43.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
30279082	30279082	PRJNA971593_P_NODE_22512_length_251_cov_0.865169_g22363_i0	PRJNA971593	22512	251	0.865169	2.17157419	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	121	2.32e-31	NR	MBA2406307.1	2053517	g22363	i0	62.7	0.99203187250996006	83	31	99.2	0	1	249	182	264	MBA2406307.1 threonylcarbamoyl-AMP synthase [Bdellovibrionales bacterium]	diamond	249	121	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30531368	30531368	PRJNA971593_P_NODE_13313_length_330_cov_1.241245_g13164_i0	PRJNA971593	13313	330	1.241245	4.0961085	Silvanigrellales bacterium	2767476	Bacteria	Bacteria	56.6	1.05e-6	NR	MCA2961696.1	2767476	g13164	i0	65.7	2.2	35	12	31.8	0	261	157	240	274	MCA2961696.1 DUF1295 domain-containing protein [Silvanigrellales bacterium]	diamond	726	56.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales			Silvanigrellales bacterium
31384901	31384901	PRJNA971593_P_NODE_5776_length_506_cov_1.066975_g5628_i0	PRJNA971593	5776	506	1.066975	5.3988935	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	185	4.25e-56	NR	MBX9767865.1	2053517	g5628	i0	89.2	0.604743083003953	102	11	60.5	0	308	3	1	102	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	306	185	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32055248	32055248	PRJNA971593_P_NODE_15238_length_307_cov_1.363248_g15089_i0	PRJNA971593	15238	307	1.363248	4.18517136	Fluviispira	2698753	Bacteria	Bacteria	76.3	7.29e-14	NR	MBX9703292.1	2654442	g15089	i0	50	2.07166123778502	72	36	70.4	0	216	1	47	118	MBX9703292.1 CDP-diacylglycerol--serine O-phosphatidyltransferase [Silvanigrellaceae bacterium]	diamond	636	76.6	0.996083550913838	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
32555602	32555602	PRJNA971593_P_NODE_13119_length_333_cov_0.988462_g12970_i0	PRJNA971593	13119	333	0.988462	3.29157846	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	106	3.4e-26	NR	MBX9767865.1	2053517	g12970	i0	45	1	111	60	99.1	1	4	333	1	111	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	333	106	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales 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);;