metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA811237" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA811237" 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
4637290	4637290	PRJNA811237_S_NODE_33524_length_162_cov_1.442478_g33284_i0	PRJNA811237	33524	162	1.442478	2.33681436	Pseudomonadati	3379134	Bacteria	Bacteria	75.9	2.65e-14	NR	MBF0299061.1	2599941	g33284	i0	60	1.88888888888889	50	20	92.6	0	159	10	893	942	MBF0299061.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Oligoflexia bacterium]	diamond	306	76.6	0.990861618798956	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
26674049	26674049	PRJNA811237_S_NODE_15561_length_207_cov_1.613924_g15321_i0	PRJNA811237	15561	207	1.613924	3.34082268	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	72	2.96e-13	NR	MDY0028698.1	2026715	g15321	i0	63	2.66666666666667	46	17	66.7	0	1	138	172	217	MDY0028698.1 nucleotide exchange factor GrpE [Pseudobdellovibrionaceae bacterium]	diamond	552	72	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27906807	27906807	PRJNA811237_S_NODE_10625_length_237_cov_1.898936_g10385_i0	PRJNA811237	10625	237	1.898936	4.50047832	Bdellovibrio sp.	28201	Bacteria	Bacteria	46.6	0.00139	NR	MBI4925042.1	28201	g10385	i0	33.8	0.860759493670886	68	42	84.8	2	206	6	220	285	MBI4925042.1 cation transporter [Bdellovibrio sp.]	diamond	204	46.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
28042270	28042270	PRJNA811237_S_NODE_4565_length_338_cov_2.719723_g4325_i0	PRJNA811237	4565	338	2.719723	9.19266374	Bdellovibrio	958	Bacteria	Bacteria	137	2.96e-36	NR	MBC7420993.1	28201	g4325	i0	72.6	10.1715976331361	95	26	84.3	0	5	289	285	379	MBC7420993.1 cystathionine gamma-synthase [Bdellovibrio sp.]	diamond	3438	137	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
28254340	28254340	PRJNA811237_S_NODE_30206_length_165_cov_0.879310_g29966_i0	PRJNA811237	30206	165	0.87931	1.4508615	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	80.9	6.15e-18	NR	MBX9702949.1	2654442	g29966	i0	75	0.945454545454545	52	13	94.5	0	8	163	22	73	MBX9702949.1 hypothetical protein [Silvanigrellaceae bacterium]	diamond	156	80.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
28538776	28538776	PRJNA811237_S_NODE_21487_length_184_cov_1.511111_g21247_i0	PRJNA811237	21487	184	1.511111	2.78044424	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	103	3.1999999999999998e-24	NR	MCB0371130.1	2053517	g21247	i0	73.8	0.994565217391304	61	16	99.5	0	2	184	230	290	MCB0371130.1 ATP-grasp domain-containing protein [Bdellovibrionales bacterium]	diamond	183	103	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28633490	28633490	PRJNA811237_S_NODE_17467_length_199_cov_1.340000_g17227_i0	PRJNA811237	17467	199	1.34	2.6666	Bdellovibrionia bacterium	3034169	Bacteria	Bacteria	58.2	7.35e-8	NR	MFL5815885.1	3034169	g17227	i0	62.3	0.919597989949749	61	22	90.5	1	194	15	69	129	MFL5815885.1 right-handed parallel beta-helix repeat-containing protein [Bdellovibrionia bacterium]	diamond	183	58.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia				Bdellovibrionia bacterium
29233319	29233319	PRJNA811237_S_NODE_12189_length_226_cov_1.152542_g11949_i0	PRJNA811237	12189	226	1.152542	2.60474492	Halobacteriovoraceae bacterium	2026745	Bacteria	Bacteria	60.5	1.62e-8	NR	MCB9093311.1	2026745	g11949	i0	50	0.716814159292035	54	27	71.7	0	225	64	189	242	MCB9093311.1 hypothetical protein [Halobacteriovoraceae bacterium]	diamond	162	60.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
29643343	29643343	PRJNA811237_S_NODE_6470_length_291_cov_1.173554_g6230_i0	PRJNA811237	6470	291	1.173554	3.41504214	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	45.1	0.00971	NR	MCB0368268.1	2053517	g6230	i0	36.2	1.27835051546392	58	31	58.8	2	175	5	33	85	MCB0368268.1 DUF4215 domain-containing protein [Bdellovibrionales bacterium]	diamond	372	45.4	0.993392070484582	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29873541	29873541	PRJNA811237_S_NODE_10031_length_242_cov_3.668394_g9791_i0	PRJNA811237	10031	242	3.668394	8.87751348	Bdellovibrio	958	Bacteria	Bacteria	109	2.77e-26	NR	MBC7420993.1	28201	g9791	i0	72.4	5.65289256198347	76	21	94.2	0	240	13	304	379	MBC7420993.1 cystathionine gamma-synthase [Bdellovibrio sp.]	diamond	1368	109	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
30496728	30496728	PRJNA811237_S_NODE_30913_length_164_cov_1.773913_g30673_i0	PRJNA811237	30913	164	1.773913	2.90921732	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	54.7	7.26e-7	NR	MCB0368270.1	2053517	g30673	i0	51	0.932926829268293	51	25	93.3	0	163	11	47	97	MCB0368270.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	153	54.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30852918	30852918	PRJNA811237_S_NODE_3034_length_416_cov_2.463215_g2794_i0	PRJNA811237	3034	416	2.463215	10.2469744	Pseudomonadati	3379134	Bacteria	Bacteria	185	2.5099999999999998e-54	NR	WP_021279072.1	1353530	g2794	i0	66.2	27.1586538461538	133	45	95.9	0	1	399	179	311	WP_021279072.1 trans-sulfuration enzyme family protein [Bacteriovorax sp. DB6_IX]	diamond	11298	185	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. DB6_IX
31476470	31476470	PRJNA811237_S_NODE_14696_length_211_cov_1.833333_g14456_i0	PRJNA811237	14696	211	1.833333	3.86833263	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	128	1.66e-35	NR	MBX9767865.1	2053517	g14456	i0	90	0.995260663507109	70	7	99.5	0	2	211	17	86	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	210	128	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31792413	31792413	PRJNA811237_S_NODE_16137_length_205_cov_0.980769_g15897_i0	PRJNA811237	16137	205	0.980769	2.01057645	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	85.9	1.27e-17	NR	MCB0368268.1	2053517	g15897	i0	54.5	0.965853658536585	66	30	96.6	0	203	6	225	290	MCB0368268.1 DUF4215 domain-containing protein [Bdellovibrionales bacterium]	diamond	198	85.9	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);;