metadata: contig_metadata: 12 rows where bioproject = "PRJNA1262902", tax_phylum = "Bdellovibrionota" and tax

12 rows where bioproject = "PRJNA1262902", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

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
15666408	15666408	PRJNA1262902_P_NODE_12353_length_241_cov_0.916667_g12311_i0	PRJNA1262902	12353	241	0.916667	2.20916747	Peredibacter	263370	Bacteria	Bacteria	92.8	1.48e-22	NR	WP_321394569.1	263370	g12311	i0	76.5	2.00414937759336	51	12	63.5	0	239	87	33	83	WP_321394569.1 MULTISPECIES: glutaredoxin family protein [Peredibacter]	diamond	483	92.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter
27281494	27281494	PRJNA1262902_P_NODE_9243_length_247_cov_0.885057_g9201_i0	PRJNA1262902	9243	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	147	4.25e-39	NR	HXH30934.1	2081706	g9201	i0	90	3.91093117408907	80	8	97.2	0	245	6	684	763	HXH30934.1 pitrilysin family protein [Bacteriovoracaceae bacterium]	diamond	966	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
27326803	27326803	PRJNA1262902_P_NODE_8383_length_249_cov_0.875000_g8341_i0	PRJNA1262902	8383	249	0.875	2.17875	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	155	2.44e-43	NR	MES2528791.1	3034175	g8341	i0	84.1	0.987951807228916	82	13	98.8	0	248	3	285	366	MES2528791.1 M14 family metallopeptidase [Bdellovibrionota bacterium]	diamond	246	155	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27800588	27800588	PRJNA1262902_P_NODE_10784_length_244_cov_0.900585_g10742_i0	PRJNA1262902	10784	244	0.900585	2.1974274	Silvanigrellales bacterium	2767476	Bacteria	Bacteria	42	0.0409	NR	MCA2961265.1	2767476	g10742	i0	35.5	0.762295081967213	62	37	72.5	1	210	34	74	135	MCA2961265.1 hypothetical protein [Silvanigrellales bacterium]	diamond	186	42	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales			Silvanigrellales bacterium
28684699	28684699	PRJNA1262902_P_NODE_11247_length_243_cov_0.905882_g11205_i0	PRJNA1262902	11247	243	0.905882	2.20129326	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	142	2.83e-39	NR	MES2526893.1	3034175	g11205	i0	80	0.987654320987654	80	16	98.8	0	3	242	88	167	MES2526893.1 GTPase Era [Bdellovibrionota bacterium]	diamond	240	142	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
30168487	30168487	PRJNA1262902_P_NODE_10732_length_244_cov_0.900585_g10690_i0	PRJNA1262902	10732	244	0.900585	2.1974274	Bacteriovoracia bacterium	3058048	Bacteria	Bacteria	120	1.65e-29	NR	MFP5386939.1	3058048	g10690	i0	71.3	0.983606557377049	80	23	98.4	0	3	242	783	862	MFP5386939.1 TIGR03960 family B12-binding radical SAM protein [Bacteriovoracia bacterium]	diamond	240	120	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia				Bacteriovoracia bacterium
30327161	30327161	PRJNA1262902_P_NODE_10152_length_245_cov_0.895349_g10110_i0	PRJNA1262902	10152	245	0.895349	2.19360505	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	74.3	2.83e-13	NR	MCM2348438.1	2081706	g10110	i0	66.7	0.73469387755102	60	18	73.5	1	185	6	310	367	MCM2348438.1 50S ribosome-binding GTPase [Bacteriovoracaceae bacterium]	diamond	180	74.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30421812	30421812	PRJNA1262902_P_NODE_11193_length_243_cov_0.905882_g11151_i0	PRJNA1262902	11193	243	0.905882	2.20129326	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	129	1.95e-33	NR	HXH32246.1	2081706	g11151	i0	71.3	0.987654320987654	80	23	98.8	0	2	241	241	320	HXH32246.1 tRNA lysidine(34) synthetase TilS [Bacteriovoracaceae bacterium]	diamond	240	129	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30453285	30453285	PRJNA1262902_P_NODE_6673_length_258_cov_1.297297_g6631_i0	PRJNA1262902	6673	258	1.297297	3.34702626	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	155	2.19e-43	NR	MBY0516417.1	2081706	g6631	i0	78.6	0.976744186046512	84	18	97.7	0	253	2	11	94	MBY0516417.1 twitch domain-containing radical SAM protein [Bacteriovoracaceae bacterium]	diamond	252	155	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30547787	30547787	PRJNA1262902_P_NODE_10193_length_245_cov_0.895349_g10151_i0	PRJNA1262902	10193	245	0.895349	2.19360505	Bacteriovoracia bacterium	3058048	Bacteria	Bacteria	79.3	6.29e-16	NR	MFP5386358.1	3058048	g10151	i0	46.2	1.78775510204082	78	42	95.5	0	11	244	29	106	MFP5386358.1 hypothetical protein [Bacteriovoracia bacterium]	diamond	438	79.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia				Bacteriovoracia bacterium
32287217	32287217	PRJNA1262902_P_NODE_6179_length_263_cov_1.621053_g6137_i0	PRJNA1262902	6179	263	1.621053	4.26336939	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	136	3.45e-35	NR	HXH31525.1	2081706	g6137	i0	72.1	0.980988593155893	86	24	98.1	0	263	6	214	299	HXH31525.1 trehalase family glycosidase [Bacteriovoracaceae bacterium]	diamond	258	136	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32823542	32823542	PRJNA1262902_P_NODE_10440_length_245_cov_0.895349_g10398_i0	PRJNA1262902	10440	245	0.895349	2.19360505	Bacteriovoracia bacterium	3058048	Bacteria	Bacteria	114	9.17e-30	NR	MFP5384878.1	3058048	g10398	i0	65.8	0.96734693877551	79	27	96.7	0	8	244	1	79	MFP5384878.1 BON domain-containing protein [Bacteriovoracia bacterium]	diamond	237	114	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia				Bacteriovoracia 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);;