metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA345071" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA345071" 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
9998546	9998546	PRJNA345071_P_NODE_11188_length_230_cov_2.955414_g11148_i0	PRJNA345071	11188	230	2.955414	6.7974522	Bacilli	91061	Bacteria	Bacteria	89	1.65e-18	NR	WP_067971948.1	1375	g11148	i0	68.8	11.2695652173913	64	20	83.5	0	228	37	12	75	WP_067971948.1 MULTISPECIES: pyruvate kinase [Aerococcus]	diamond	2592	89	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus
18244891	18244891	PRJNA345071_P_NODE_3275_length_335_cov_2.229008_g3235_i0	PRJNA345071	3275	335	2.229008	7.4671768	Syntrophomonadaceae bacterium	2093811	Bacteria	Bacteria	172	2.0299999999999998e-47	NR	MBC7076168.1	2093811	g3235	i0	80.2	19.8805970149254	111	22	99.4	0	2	334	545	655	MBC7076168.1 ATP-dependent chaperone ClpB [Syntrophomonadaceae bacterium]	diamond	6660	172	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae		Syntrophomonadaceae bacterium
27074736	27074736	PRJNA345071_P_NODE_642_length_631_cov_2.114695_g602_i0	PRJNA345071	642	631	2.114695	13.34372545	Bacillus cereus	1396	Bacteria	Bacteria	56.2	1.77e-6	NR	WP_098605782.1	1396	g602	i0	54.3	0.437400950871632	46	21	21.9	0	425	288	3	48	WP_098605782.1 lectin [Bacillus cereus]	diamond	276	56.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
27895916	27895916	PRJNA345071_P_NODE_7865_length_252_cov_0.871508_g7825_i0	PRJNA345071	7865	252	0.871508	2.19620016	Clostridiales bacterium	1898207	Bacteria	Bacteria	57.4	2.9e-7	NR	PWL98330.1	1898207	g7825	i0	96.6	0.345238095238095	29	1	34.5	0	87	1	1	29	PWL98330.1 MAG: recombinase family protein [Clostridiales bacterium]	diamond	87	57.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
27959141	27959141	PRJNA345071_P_NODE_2885_length_349_cov_1.978261_g2845_i0	PRJNA345071	2885	349	1.978261	6.90413089	Enterococcus faecalis	1351	Bacteria	Bacteria	106	1.84e-27	NR	WP_375855466.1	1351	g2845	i0	93.8	0.558739255014327	65	4	55.9	0	348	154	24	88	WP_375855466.1 hypothetical protein [Enterococcus faecalis]	diamond	195	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
28401199	28401199	PRJNA345071_P_NODE_8446_length_250_cov_0.881356_g8406_i0	PRJNA345071	8446	250	0.881356	2.20339	Candidatus Stercoripulliclostridium merdigallinarum	2840951	Bacteria	Bacteria	64.7	7.65e-10	NR	HIU60157.1	2840951	g8406	i0	48.1	0.948	79	41	94.8	0	1	237	331	409	HIU60157.1 hypothetical protein [Candidatus Stercoripulliclostridium merdigallinarum]	diamond	237	64.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Candidatus Stercoripulliclostridium	Candidatus Stercoripulliclostridium merdigallinarum
28748484	28748484	PRJNA345071_P_NODE_3507_length_328_cov_1.090196_g3467_i0	PRJNA345071	3507	328	1.090196	3.57584288	Soehngenia saccharolytica	253256	Bacteria	Bacteria	102	8.18e-25	NR	TJX35225.1	253256	g3467	i0	54.1	0.896341463414634	98	38	83.2	1	54	326	31	128	TJX35225.1 J domain-containing protein [Soehngenia saccharolytica]	diamond	294	102	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Soehngenia	Soehngenia saccharolytica
29506205	29506205	PRJNA345071_P_NODE_5650_length_280_cov_1.386473_g5610_i0	PRJNA345071	5650	280	1.386473	3.8821244	Listeria monocytogenes	1639	Bacteria	Bacteria	112	8.43e-30	NR	MBH0213458.1	1639	g5610	i0	70.9	0.846428571428571	79	23	84.6	0	5	241	11	89	MBH0213458.1 hypothetical protein [Listeria monocytogenes]	diamond	237	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
30534233	30534233	PRJNA345071_P_NODE_4273_length_305_cov_2.301724_g4233_i0	PRJNA345071	4273	305	2.301724	7.0202582	root	1	Root_unresolved	Root_unresolved	46.6	0.00301	NR	PKM89696.1	2013771	g4233	i0	35.2	7.94754098360656	91	36	89.5	4	31	303	189	256	PKM89696.1 MAG: glycoside hydrolase [Firmicutes bacterium HGW-Firmicutes-10]	diamond	2424	46.6	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium HGW-Firmicutes-10
31275404	31275404	PRJNA345071_P_NODE_10295_length_244_cov_0.888889_g10255_i0	PRJNA345071	10295	244	0.888889	2.16888916	Halobacillus rhizosphaerae	3064889	Bacteria	Bacteria	114	2.71e-27	NR	WP_411788268.1	3064889	g10255	i0	73.8	1.0327868852459	84	19	99.6	1	244	2	190	273	WP_411788268.1 hypothetical protein [Halobacillus rhizosphaerae]	diamond	252	114	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halobacillus	Halobacillus rhizosphaerae
31465490	31465490	PRJNA345071_P_NODE_9196_length_247_cov_1.396552_g9156_i0	PRJNA345071	9196	247	1.396552	3.44948344	Listeria monocytogenes	1639	Bacteria	Bacteria	101	1.4e-25	NR	MBH0213458.1	1639	g9156	i0	92	0.607287449392713	50	4	60.7	0	247	98	65	114	MBH0213458.1 hypothetical protein [Listeria monocytogenes]	diamond	150	101	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
31545862	31545862	PRJNA345071_P_NODE_2396_length_374_cov_1.813953_g2356_i0	PRJNA345071	2396	374	1.813953	6.78418422	Bacteria	2	Bacteria	Bacteria	177	4.5399999999999986e-55	NR	MBH0219648.1	1639	g2356	i0	86.6	2.31818181818182	97	13	77.8	0	1	291	13	109	MBH0219648.1 DUF538 domain-containing protein [Listeria monocytogenes]	diamond	867	177	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes

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);;