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

10 rows where analysis = "diamond", bioproject = "PRJNA641991" and tax_phylum = "Bacillota"

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
8271055	8271055	PRJNA641991_S_NODE_4087_length_264_cov_1.186047_g3968_i0	PRJNA641991	4087	264	1.186047	3.13116408	Eubacteriales	186802	Bacteria	Bacteria	126	6.35e-33	NR	MBD8962269.1	2485925	g3968	i0	70	3.60227272727273	80	24	90.9	0	241	2	171	250	MBD8962269.1 aspartate--ammonia ligase [Oscillospiraceae bacterium]	diamond	951	126	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
21020150	21020150	PRJNA641991_P_NODE_3737_length_164_cov_0.886957_g3696_i0	PRJNA641991	3737	164	0.886957	1.45460948	Clostridium	1485	Bacteria	Bacteria	75.5	3.61e-14	NR	MBQ6820692.1	1506	g3696	i0	82.1	7.13414634146341	39	7	71.3	0	162	46	562	600	MBQ6820692.1 beta-glucuronidase [Clostridium sp.]	diamond	1170	75.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
27175856	27175856	PRJNA641991_S_NODE_13022_length_165_cov_0.879310_g12903_i0	PRJNA641991	13022	165	0.87931	1.4508615	Clostridium botulinum	1491	Bacteria	Bacteria	45.1	0.00194	NR	WP_265210576.1	1491	g12903	i0	44.2	0.945454545454545	52	25	94.5	1	157	2	69	116	WP_265210576.1 CDP-glycerol glycerophosphotransferase family protein [Clostridium botulinum]	diamond	156	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
27302645	27302645	PRJNA641991_S_NODE_5083_length_238_cov_7.793651_g4964_i0	PRJNA641991	5083	238	7.793651	18.54888938	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	43.1	0.0248	NR	MEA5061696.1	2049044	g4964	i0	33.8	0.857142857142857	68	38	79.4	2	3	191	183	248	MEA5061696.1 ComEC/Rec2 family competence protein [Erysipelotrichaceae bacterium]	diamond	204	43.1	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
28104083	28104083	PRJNA641991_S_NODE_4245_length_259_cov_1.942857_g4126_i0	PRJNA641991	4245	259	1.942857	5.03199963	Bacillales	1385	Bacteria	Bacteria	50.1	1.19e-4	NR	WP_101967018.1	28031	g4126	i0	41.3	3.15057915057915	63	33	68.3	1	82	258	286	348	WP_101967018.1 S-layer homology domain-containing protein [Lysinibacillus fusiformis]	diamond	816	50.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus fusiformis
28249682	28249682	PRJNA641991_S_NODE_7946_length_197_cov_44.581081_g7827_i0	PRJNA641991	7946	197	44.581081	87.82472957	Bacillus sp. MHSD17	3026937	Bacteria	Bacteria	41.2	0.0421	NR	MDD1371223.1	3026937	g7827	i0	54.5	0.50253807106599	33	15	50.3	0	102	4	119	151	MDD1371223.1 PH domain-containing protein [Bacillus sp. MHSD17]	diamond	99	41.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. MHSD17
28281172	28281172	PRJNA641991_S_NODE_13406_length_164_cov_0.886957_g13287_i0	PRJNA641991	13406	164	0.886957	1.45460948	Clostridium sp.	1506	Bacteria	Bacteria	42.4	0.0162	NR	MEG0297248.1	1506	g13287	i0	51.1	2.14024390243902	45	20	78.7	1	142	14	23	67	MEG0297248.1 ATP-binding cassette domain-containing protein [Clostridium sp.]	diamond	351	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
30713110	30713110	PRJNA641991_S_NODE_13034_length_165_cov_0.879310_g12915_i0	PRJNA641991	13034	165	0.87931	1.4508615	Cytobacillus citreus	2833586	Bacteria	Bacteria	60.5	6.62e-9	NR	WP_213103100.1	2833586	g12915	i0	70.7	0.745454545454545	41	11	74.5	1	146	24	309	348	WP_213103100.1 enoyl-CoA hydratase/isomerase family protein [Cytobacillus citreus]	diamond	123	60.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus citreus
30934444	30934444	PRJNA641991_S_NODE_8574_length_192_cov_0.930070_g8455_i0	PRJNA641991	8574	192	0.93007	1.7857344	Pseudoflavonifractor capillosus	106588	Bacteria	Bacteria	41.2	0.0161	NR	WP_204898878.1	106588	g8455	i0	33.3	0.984375	63	42	98.4	0	4	192	15	77	WP_204898878.1 hypothetical protein [Pseudoflavonifractor capillosus]	diamond	189	41.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Pseudoflavonifractor	Pseudoflavonifractor capillosus
32021837	32021837	PRJNA641991_S_NODE_10698_length_175_cov_0.960317_g10579_i0	PRJNA641991	10698	175	0.960317	1.68055475	Bacillati	1783272	Bacteria	Bacteria	92	6.22e-20	NR	MDI9461189.1	1879010	g10579	i0	73.2	13.3028571428571	56	15	96	0	173	6	425	480	MDI9461189.1 pyruvate, phosphate dikinase [Bacillota bacterium]	diamond	2328	92	1	Bacteria	Bacillati	Bacillota					Bacillota 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);;