metadata: contig_metadata: 15 rows where bioproject = "PRJNA694557" and tax

15 rows where bioproject = "PRJNA694557" 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
1949418	1949418	PRJNA694557_P_NODE_4442_length_716_cov_3.191291_g4231_i0	PRJNA694557	4442	716	3.191291	22.84964356	Bdellovibrionia bacterium	3034169	Bacteria	Bacteria	162	3.779999999999999e-46	NR	MFL5815437.1	3034169	g4231	i0	63.6	0.494413407821229	118	42	49.4	1	328	681	6	122	MFL5815437.1 type IV pilin protein [Bdellovibrionia bacterium]	diamond	354	162	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia				Bdellovibrionia bacterium
10108503	10108503	PRJNA694557_P_NODE_9248_length_453_cov_2.981579_g9028_i0	PRJNA694557	9248	453	2.981579	13.50655287	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	143	4.41e-40	NR	HMN68004.1	2053517	g9028	i0	51.7	2.94701986754967	149	72	98.7	0	7	453	36	184	HMN68004.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	1335	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
12152455	12152455	PRJNA694557_P_NODE_18570_length_293_cov_1.663636_g18350_i0	PRJNA694557	18570	293	1.663636	4.87445348	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	114	2.97e-28	NR	MEK7691598.1	3034175	g18350	i0	59.6	0.911262798634812	89	36	91.1	0	291	25	53	141	MEK7691598.1 S66 peptidase family protein [Bdellovibrionota bacterium]	diamond	267	114	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
26924441	26924441	PRJNA694557_P_NODE_20882_length_271_cov_2.661616_g20662_i0	PRJNA694557	20882	271	2.661616	7.21297936	Oligoflexia bacterium	2599941	Bacteria	Bacteria	51.6	3.96e-5	NR	MBX7144624.1	2599941	g20662	i0	39	1.40590405904059	59	36	65.3	0	83	259	3	61	MBX7144624.1 hypothetical protein [Oligoflexia bacterium]	diamond	381	51.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
26987533	26987533	PRJNA694557_P_NODE_6242_length_581_cov_3.173228_g6023_i0	PRJNA694557	6242	581	3.173228	18.43645468	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	290	4.289999999999999e-96	NR	MEK6578397.1	3034175	g6023	i0	75.4	0.965576592082616	187	46	96.6	0	562	2	85	271	MEK6578397.1 MlaD family protein [Bdellovibrionota bacterium]	diamond	561	290	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27430459	27430459	PRJNA694557_P_NODE_5283_length_644_cov_2.835377_g5065_i0	PRJNA694557	5283	644	2.835377	18.25982788	Oligoflexus tunisiensis	708132	Bacteria	Bacteria	45.8	0.00592	NR	WP_218110376.1	708132	g5065	i0	34.3	0.312111801242236	67	43	30.7	1	221	418	12	78	WP_218110376.1 hypothetical protein [Oligoflexus tunisiensis]	diamond	201	45.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus tunisiensis
27966919	27966919	PRJNA694557_P_NODE_24745_length_245_cov_1.790698_g24525_i0	PRJNA694557	24745	245	1.790698	4.3872101	Bdellovibrionales bacterium GWA2_49_15	1797384	Bacteria	Bacteria	119	5.65e-29	NR	OFZ12555.1	1797384	g24525	i0	66.7	0.991836734693878	81	27	99.2	0	245	3	292	372	OFZ12555.1 MAG: hypothetical protein A2X86_14620 [Bdellovibrionales bacterium GWA2_49_15]	diamond	243	119	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium GWA2_49_15
28282506	28282506	PRJNA694557_P_NODE_17926_length_300_cov_1.991189_g17706_i0	PRJNA694557	17926	300	1.991189	5.973567	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	105	1.17e-24	NR	MBX3022697.1	2053517	g17706	i0	52.7	0.93	93	44	93	0	22	300	24	116	MBX3022697.1 alpha/beta hydrolase [Bdellovibrionales bacterium]	diamond	279	105	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28483545	28483545	PRJNA694557_P_NODE_27186_length_207_cov_4.022388_g26966_i0	PRJNA694557	27186	207	4.022388	8.32634316	Pseudomonadati	3379134	Bacteria	Bacteria	50.4	4.31e-5	NR	HLW57034.1	2081706	g26966	i0	41	3.55072463768116	61	36	88.4	0	184	2	169	229	HLW57034.1 phosphatidylserine/phosphatidylglycerophosphate/cardiolipin synthase family protein [Bacteriovoracaceae bacterium]	diamond	735	50.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30272450	30272450	PRJNA694557_P_NODE_2532_length_991_cov_2.968410_g2361_i0	PRJNA694557	2532	991	2.96841	29.4169431	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	121	8.84e-27	NR	MBS1983280.1	2053517	g2361	i0	45.7	0.417759838546922	138	71	40.6	1	424	23	126	263	MBS1983280.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	414	121	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30304237	30304237	PRJNA694557_P_NODE_17952_length_300_cov_1.339207_g17732_i0	PRJNA694557	17952	300	1.339207	4.017621	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	80.9	1.24e-15	NR	MEK6772515.1	3034175	g17732	i0	59.3	1.72	59	24	59	0	299	123	249	307	MEK6772515.1 lytic transglycosylase domain-containing protein [Bdellovibrionota bacterium]	diamond	516	80.9	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31895567	31895567	PRJNA694557_P_NODE_11077_length_405_cov_2.783133_g10857_i0	PRJNA694557	11077	405	2.783133	11.27168865	Bdellovibrio	958	Bacteria	Bacteria	50.4	4.09e-4	NR	HEY1078878.1	28201	g10857	i0	28.7	1.5037037037037	122	75	87.4	4	359	6	25	138	HEY1078878.1 hypothetical protein [Bdellovibrio sp.]	diamond	609	50.8	0.992125984251969	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
31947375	31947375	PRJNA694557_P_NODE_7837_length_502_cov_5.645688_g7617_i0	PRJNA694557	7837	502	5.645688	28.34135376	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	197	3.13e-59	NR	MBK7843055.1	2053517	g7617	i0	62	1.9840637450199201	166	58	96.2	1	20	502	88	253	MBK7843055.1 diphosphomevalonate decarboxylase [Bdellovibrionales bacterium]	diamond	996	197	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32517335	32517335	PRJNA694557_P_NODE_7199_length_531_cov_13.548035_g6979_i0	PRJNA694557	7199	531	13.548035	71.94006585	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	153	3.22e-40	NR	PZP56752.1	349221	g6979	i0	62.9	0.700564971751412	124	46	70.1	0	147	518	1	124	PZP56752.1 MAG: hypothetical protein DI586_02685 [Micavibrio aeruginosavorus]	diamond	372	153	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
32654242	32654242	PRJNA694557_P_NODE_12100_length_383_cov_2.258065_g11880_i0	PRJNA694557	12100	383	2.258065	8.64838895	Bdellovibrio	958	Bacteria	Bacteria	207	2.49e-60	NR	MBI2522395.1	28201	g11880	i0	75.4	2.77284595300261	118	29	92.4	0	383	30	365	482	MBI2522395.1 hypothetical protein [Bdellovibrio sp.]	diamond	1062	207	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio 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);;