metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA493828" 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
22783628	22783628	PRJNA493828_P_NODE_25278_length_270_cov_1.172589_g24859_i0	PRJNA493828	25278	270	1.172589	3.1659903	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	95.9	1.59e-21	NR	WP_088564899.1	959	g24859	i0	67.9	2.72222222222222	81	24	87.8	1	239	3	1	81	WP_088564899.1 hypothetical protein [Bdellovibrio bacteriovorus]	diamond	735	95.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27123801	27123801	PRJNA493828_P_NODE_31442_length_252_cov_2.173184_g31023_i0	PRJNA493828	31442	252	2.173184	5.47642368	Bdellovibrio	958	Bacteria	Bacteria	135	1.6e-38	NR	MBC7741563.1	28201	g31023	i0	72.6	7	84	23	100	0	1	252	26	109	MBC7741563.1 DoxX family protein [Bdellovibrio sp.]	diamond	1764	136	0.992647058823529	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
27677430	27677430	PRJNA493828_P_NODE_41484_length_235_cov_3.074074_g41065_i0	PRJNA493828	41484	235	3.074074	7.2240739	Pseudobdellovibrio sp.	2862747	Bacteria	Bacteria	58.9	6.56e-8	NR	MFN3696400.1	2862747	g41065	i0	75.8	1.26382978723404	33	8	42.1	0	136	234	1	33	MFN3696400.1 cysteine--tRNA ligase [Pseudobdellovibrio sp.]	diamond	297	58.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp.
27740603	27740603	PRJNA493828_P_NODE_46264_length_209_cov_4.948529_g45845_i0	PRJNA493828	46264	209	4.948529	10.34242561	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	97.8	4.43e-22	NR	MBX3020441.1	2053517	g45845	i0	65.2	1.99521531100478	69	24	99	0	1	207	232	300	MBX3020441.1 radical SAM family heme chaperone HemW [Bdellovibrionales bacterium]	diamond	417	97.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29019134	29019134	PRJNA493828_P_NODE_30368_length_255_cov_1.956044_g29949_i0	PRJNA493828	30368	255	1.956044	4.9879122	Bacteria	2	Bacteria	Bacteria	150	5.85e-40	NR	HVK61956.1	2053517	g29949	i0	87.5	2.82352941176471	80	10	94.1	0	251	12	749	828	HVK61956.1 DNA polymerase III subunit alpha [Bdellovibrionales bacterium]	diamond	720	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30266787	30266787	PRJNA493828_P_NODE_25092_length_270_cov_2.319797_g24673_i0	PRJNA493828	25092	270	2.319797	6.2634519	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	109	1.4e-25	NR	MFN8792485.1	2053517	g24673	i0	66.7	2.82222222222222	84	28	93.3	0	267	16	460	543	MFN8792485.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	762	109	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30298533	30298533	PRJNA493828_P_NODE_41232_length_236_cov_2.914110_g40813_i0	PRJNA493828	41232	236	2.91411	6.8772996	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	94.7	3.36e-23	NR	PZQ43931.1	349221	g40813	i0	84.7	1.5	59	8	73.7	1	63	236	1	59	PZQ43931.1 MAG: 50S ribosomal protein L21 [Micavibrio aeruginosavorus]	diamond	354	94.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
30393295	30393295	PRJNA493828_P_NODE_30193_length_255_cov_3.615385_g29774_i0	PRJNA493828	30193	255	3.615385	9.21923175	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	54.7	1.2e-7	NR	HLB58800.1	3034175	g29774	i0	61.9	0.494117647058824	42	16	49.4	0	240	115	6	47	HLB58800.1 DUF2283 domain-containing protein [Bdellovibrionota bacterium]	diamond	126	54.7	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
30993207	30993207	PRJNA493828_P_NODE_15274_length_310_cov_3.156118_g14855_i0	PRJNA493828	15274	310	3.156118	9.7839658	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	55.5	1.66e-6	NR	PZP55900.1	349221	g14855	i0	54.2	0.464516129032258	48	22	46.5	0	163	306	50	97	PZP55900.1 MAG: hypothetical protein DI586_05470 [Micavibrio aeruginosavorus]	diamond	144	55.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
32574889	32574889	PRJNA493828_P_NODE_47279_length_203_cov_5.330769_g46860_i0	PRJNA493828	47279	203	5.330769	10.82146107	Micavibrio sp.	2024841	Bacteria	Bacteria	44.7	0.00457	NR	MFA5591923.1	2024841	g46860	i0	41.4	0.857142857142857	58	31	81.3	1	167	3	24	81	MFA5591923.1 TcpQ domain-containing protein [Micavibrio sp.]	diamond	174	44.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
32794767	32794767	PRJNA493828_P_NODE_14600_length_310_cov_4.421941_g14181_i0	PRJNA493828	14600	310	4.421941	13.7080171	Micavibrio sp.	2024841	Bacteria	Bacteria	92.8	1.84e-19	NR	MDE1153379.1	2024841	g14181	i0	67.1	0.67741935483871	70	23	67.7	0	309	100	413	482	MDE1153379.1 signal recognition particle protein [Micavibrio sp.]	diamond	210	92.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio 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);;