metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA591000" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA591000" 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
13318900	13318900	PRJNA591000_P_NODE_1051_length_1119_cov_18.296330_g732_i0	PRJNA591000	1051	1119	18.29633	204.7359327	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	264	7.51e-82	NR	HEX4925533.1	2053517	g732	i0	82.6	5.44504021447721	161	28	43.2	0	107	589	1	161	HEX4925533.1 alanine dehydrogenase [Bdellovibrionales bacterium]	diamond	6093	264	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
23517308	23517308	PRJNA591000_P_NODE_4019_length_722_cov_5.712843_g3160_i0	PRJNA591000	4019	722	5.712843	41.24672646	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	281	3.47e-92	NR	MBX3020194.1	2053517	g3160	i0	71.6	0.847645429362881	204	58	84.8	0	613	2	2	205	MBX3020194.1 amino acid ABC transporter ATP-binding protein [Bdellovibrionales bacterium]	diamond	612	281	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26794895	26794895	PRJNA591000_P_NODE_12201_length_415_cov_1.764249_g10615_i0	PRJNA591000	12201	415	1.764249	7.32163335	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	50.1	5.72e-4	NR	MBL7663606.1	2081706	g10615	i0	56.7	0.665060240963855	30	13	21.7	0	325	414	51	80	MBL7663606.1 class I SAM-dependent RNA methyltransferase [Bacteriovoracaceae bacterium]	diamond	276	50.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
28356337	28356337	PRJNA591000_P_NODE_14766_length_384_cov_3.053521_g13164_i0	PRJNA591000	14766	384	3.053521	11.72552064	Bacteria	2	Bacteria	Bacteria	45.8	0.00584	NR	MBX2989460.1	2026715	g13164	i0	65	0.9375	40	14	31.3	0	123	4	57	96	MBX2989460.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	360	45.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28735357	28735357	PRJNA591000_P_NODE_14487_length_388_cov_4.835655_g12888_i0	PRJNA591000	14487	388	4.835655	18.7623414	Bacteria	2	Bacteria	Bacteria	45.8	0.00598	NR	MBX2989460.1	2026715	g12888	i0	65	0.927835051546392	40	14	30.9	0	266	385	57	96	MBX2989460.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	360	45.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28911006	28911006	PRJNA591000_P_NODE_5828_length_598_cov_2.548330_g4594_i0	PRJNA591000	5828	598	2.54833	15.2390134	Bdellovibrio sp.	28201	Bacteria	Bacteria	59.7	1.33e-6	NR	MBC7466702.1	28201	g4594	i0	69.6	0.280936454849498	56	14	28.1	1	332	499	235	287	MBC7466702.1 hypothetical protein [Bdellovibrio sp.]	diamond	168	59.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
29132481	29132481	PRJNA591000_P_NODE_13509_length_400_cov_4.929919_g11917_i0	PRJNA591000	13509	400	4.929919	19.719676	Oligoflexia bacterium	2599941	Bacteria	Bacteria	79.7	2.32e-14	NR	MBX7137041.1	2599941	g11917	i0	42.9	1.425	84	48	63	0	131	382	265	348	MBX7137041.1 hypothetical protein [Oligoflexia bacterium]	diamond	570	79.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
29890300	29890300	PRJNA591000_P_NODE_931_length_1161_cov_14.378975_g641_i0	PRJNA591000	931	1161	14.378975	166.93989975	Oligoflexia bacterium	2599941	Bacteria	Bacteria	387	8.24e-127	NR	HMO16870.1	2599941	g641	i0	68.2	1.34625322997416	261	83	67.4	0	1	783	197	457	HMO16870.1 methionine--tRNA ligase [Oligoflexia bacterium]	diamond	1563	387	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
30205797	30205797	PRJNA591000_P_NODE_13032_length_406_cov_1.145889_g11443_i0	PRJNA591000	13032	406	1.145889	4.65230934	Oligoflexia bacterium	2599941	Bacteria	Bacteria	53.5	2.59e-5	NR	MBK9293674.1	2599941	g11443	i0	63.9	0.532019704433498	36	13	26.6	0	3	110	212	247	MBK9293674.1 hypothetical protein [Oligoflexia bacterium]	diamond	216	53.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
32496166	32496166	PRJNA591000_P_NODE_14499_length_388_cov_2.027855_g12900_i0	PRJNA591000	14499	388	2.027855	7.8680774	Bacteria	2	Bacteria	Bacteria	72	5.52e-12	NR	OFZ79150.1	1797403	g12900	i0	78	0.951030927835051	41	9	31.7	0	2	124	139	179	OFZ79150.1 MAG: hypothetical protein A2583_00465 [Bdellovibrionales bacterium RIFOXYD1_FULL_53_11]	diamond	369	72	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium RIFOXYD1_FULL_53_11

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