metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA1105232" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA1105232" 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
1487269	1487269	PRJNA1105232_S_NODE_3162_length_317_cov_3.250000_g2946_i0	PRJNA1105232	3162	317	3.25	10.3025	Clostridiales bacterium	1898207	Bacteria	Bacteria	144	1.06e-39	NR	NLV58462.1	1898207	g2946	i0	69.5	1.98738170347003	105	32	99.4	0	317	3	210	314	NLV58462.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridiales bacterium]	diamond	630	144	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
27320660	27320660	PRJNA1105232_S_NODE_11123_length_193_cov_1.270833_g10907_i0	PRJNA1105232	11123	193	1.270833	2.45270769	Niallia nealsonii	115979	Bacteria	Bacteria	68.9	1.13e-11	NR	WP_101177614.1	115979	g10907	i0	50.8	1.98963730569948	63	31	97.9	0	192	4	924	986	WP_101177614.1 alpha-mannosidase [Niallia nealsonii]	diamond	384	68.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia nealsonii
27636506	27636506	PRJNA1105232_S_NODE_8964_length_211_cov_1.283951_g8748_i0	PRJNA1105232	8964	211	1.283951	2.70913661	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.9	0.00943	NR	MBR1651450.1	1898203	g8748	i0	42.3	2.21800947867299	52	29	72.5	1	30	182	247	298	MBR1651450.1 glycosyltransferase family 2 protein [Lachnospiraceae bacterium]	diamond	468	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28552169	28552169	PRJNA1105232_S_NODE_15767_length_167_cov_1.322034_g15551_i0	PRJNA1105232	15767	167	1.322034	2.20779678	Staphylococcus aureus	1280	Bacteria	Bacteria	54.7	4.73e-8	NR	MDN8682973.1	1280	g15551	i0	58.5	0.952095808383233	53	21	93.4	1	164	9	1	53	MDN8682973.1 hypothetical protein [Staphylococcus aureus]	diamond	159	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
29025946	29025946	PRJNA1105232_S_NODE_9948_length_202_cov_3.052288_g9732_i0	PRJNA1105232	9948	202	3.052288	6.16562176	Clostridia bacterium	2044939	Bacteria	Bacteria	68.9	1.7e-13	NR	HEX9060528.1	2044939	g9732	i0	48.4	1.9009900990099	64	31	92.1	1	188	3	5	68	HEX9060528.1 VOC family protein [Clostridia bacterium]	diamond	384	68.9	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29341466	29341466	PRJNA1105232_S_NODE_9269_length_208_cov_1.635220_g9053_i0	PRJNA1105232	9269	208	1.63522	3.4012576	Bacillus sp. V5-8f	2053044	Bacteria	Bacteria	45.4	5.69e-4	NR	WP_101631345.1	2053044	g9053	i0	43.5	0.663461538461538	46	20	66.3	1	154	17	24	63	WP_101631345.1 phospholipase [Bacillus sp. V5-8f]	diamond	138	45.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. V5-8f
30216859	30216859	PRJNA1105232_S_NODE_4232_length_283_cov_1.401709_g4016_i0	PRJNA1105232	4232	283	1.401709	3.96683647	Bacteria	2	Bacteria	Bacteria	57.8	3.1e-7	NR	WP_091726713.1	415015	g4016	i0	65	2.57597173144876	40	14	42.4	0	279	160	460	499	WP_091726713.1 ATP-dependent metallopeptidase FtsH/Yme1/Tma family protein [Proteiniborus ethanoligenes]	diamond	729	57.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Proteiniborus	Proteiniborus ethanoligenes
30312268	30312268	PRJNA1105232_S_NODE_11932_length_187_cov_2.347826_g11716_i0	PRJNA1105232	11932	187	2.347826	4.39043462	Bacillaceae	186817	Bacteria	Bacteria	48.9	1.19e-4	NR	WP_151573940.1	1071718	g11716	i0	36.7	2.79144385026738	60	35	96.3	1	184	5	463	519	WP_151573940.1 alkaline phosphatase [Bacillus mesophilum]	diamond	522	49.3	0.991886409736308	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mesophilum
31078898	31078898	PRJNA1105232_S_NODE_4955_length_266_cov_1.714286_g4739_i0	PRJNA1105232	4955	266	1.714286	4.56000076	Tissierella praeacuta	43131	Bacteria	Bacteria	92	2.02e-20	NR	WP_353097328.1	43131	g4739	i0	53.9	1.99624060150376	89	40	99.2	1	2	265	118	206	WP_353097328.1 copper homeostasis protein CutC [Tissierella praeacuta]	diamond	531	92	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Tissierella	Tissierella praeacuta
31204687	31204687	PRJNA1105232_S_NODE_9415_length_207_cov_1.145570_g9199_i0	PRJNA1105232	9415	207	1.14557	2.3713299	Alkaliphilus sp.	1872455	Bacteria	Bacteria	84.7	3.54e-17	NR	MBS3995326.1	1872455	g9199	i0	66.7	4.43478260869565	60	20	87	0	186	7	341	400	MBS3995326.1 proline--tRNA ligase [Alkaliphilus sp.]	diamond	918	84.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Natronincolaceae	Alkaliphilus	Alkaliphilus sp.
31964172	31964172	PRJNA1105232_S_NODE_11718_length_189_cov_0.771429_g11502_i0	PRJNA1105232	11718	189	0.771429	1.45800081	[Clostridium] innocuum	1522	Bacteria	Bacteria	44.7	0.00379	NR	WP_233106945.1	1522	g11502	i0	43.9	0.650793650793651	41	23	65.1	0	67	189	69	109	WP_233106945.1 isoaspartyl peptidase/L-asparaginase [[Clostridium] innocuum]	diamond	123	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum
32154162	32154162	PRJNA1105232_S_NODE_11118_length_193_cov_1.409722_g10902_i0	PRJNA1105232	11118	193	1.409722	2.72076346	Clostridia bacterium	2044939	Bacteria	Bacteria	121	8.189999999999999e-31	NR	MBP7025639.1	2044939	g10902	i0	93.8	7.95854922279793	64	4	99.5	0	1	192	100	163	MBP7025639.1 type II secretion system F family protein [Clostridia bacterium]	diamond	1536	121	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32407329	32407329	PRJNA1105232_S_NODE_17379_length_162_cov_0.920354_g17163_i0	PRJNA1105232	17379	162	0.920354	1.49097348	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	48.5	1.06e-4	NR	MBE6134959.1	2049044	g17163	i0	45.1	1.88888888888889	51	28	94.4	0	5	157	237	287	MBE6134959.1 ATP synthase F1 subunit gamma [Erysipelotrichaceae bacterium]	diamond	306	48.5	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae 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);;