metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA825466" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA825466" 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
26674281	26674281	PRJNA825466_P_NODE_22061_length_246_cov_1.664740_g21960_i0	PRJNA825466	22061	246	1.66474	4.0952604	Bacilli bacterium	1903720	Bacteria	Bacteria	97.1	4.28e-22	NR	MFA5543239.1	1903720	g21960	i0	60.5	0.98780487804878	81	32	98.8	0	245	3	197	277	MFA5543239.1 hypothetical protein [Bacilli bacterium]	diamond	243	97.1	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
27781112	27781112	PRJNA825466_P_NODE_22804_length_246_cov_0.890173_g22703_i0	PRJNA825466	22804	246	0.890173	2.18982558	Staphylococcus warneri	1292	Bacteria	Bacteria	54.3	7.66e-8	NR	MDU1259878.1	1292	g22703	i0	88.5	0.317073170731707	26	3	31.7	0	168	245	1	26	MDU1259878.1 hypothetical protein [Staphylococcus warneri]	diamond	78	54.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
27843985	27843985	PRJNA825466_P_NODE_10704_length_283_cov_1.438095_g10603_i0	PRJNA825466	10704	283	1.438095	4.06980885	Aneurinibacillus sp. REN35	3237286	Bacteria	Bacteria	77	4.33e-14	NR	WP_371148519.1	3237286	g10603	i0	51.6	0.964664310954064	91	42	94.3	1	269	3	97	187	WP_371148519.1 Ig-like domain-containing protein [Aneurinibacillus sp. REN35]	diamond	273	77	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Aneurinibacillus	Aneurinibacillus sp. REN35
29738333	29738333	PRJNA825466_P_NODE_23490_length_245_cov_0.895349_g23389_i0	PRJNA825466	23490	245	0.895349	2.19360505	Bacillota bacterium	1879010	Bacteria	Bacteria	133	1.15e-35	NR	MBS6491167.1	1879010	g23389	i0	98.6	0.844897959183673	69	1	84.5	0	1	207	289	357	MBS6491167.1 flavodoxin family protein [Bacillota bacterium]	diamond	207	133	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
30812697	30812697	PRJNA825466_P_NODE_24214_length_245_cov_0.895349_g24113_i0	PRJNA825466	24214	245	0.895349	2.19360505	Christensenellales bacterium	3083246	Bacteria	Bacteria	170	1.55e-47	NR	MEI3415225.1	3083246	g24113	i0	98.8	3.96734693877551	81	1	99.2	0	1	243	88	168	MEI3415225.1 InlB B-repeat-containing protein [Christensenellales bacterium]	diamond	972	170	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales			Christensenellales bacterium
30812698	30812698	PRJNA825466_P_NODE_9874_length_289_cov_1.425926_g9773_i0	PRJNA825466	9874	289	1.425926	4.12092614	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.9	0.0247	NR	MDE6852470.1	1898203	g9773	i0	40.7	0.612456747404844	59	35	61.2	0	206	30	220	278	MDE6852470.1 DUF1430 domain-containing protein [Lachnospiraceae bacterium]	diamond	177	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
31200122	31200122	PRJNA825466_P_NODE_13895_length_264_cov_1.612565_g13794_i0	PRJNA825466	13895	264	1.612565	4.2571716	Dialister	39948	Bacteria	Bacteria	181	1.0699999999999995e-55	NR	WP_007069140.1	39948	g13794	i0	98.9	2.96590909090909	87	1	98.9	0	2	262	72	158	WP_007069140.1 MULTISPECIES: MBL fold metallo-hydrolase [Dialister]	diamond	783	181	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Dialister
32077584	32077584	PRJNA825466_P_NODE_25338_length_244_cov_0.900585_g25237_i0	PRJNA825466	25338	244	0.900585	2.1974274	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	120	1.99e-30	NR	NTW91148.1	2049044	g25237	i0	64.2	0.995901639344262	81	29	99.6	0	244	2	8	88	NTW91148.1 hypothetical protein [Erysipelotrichaceae bacterium]	diamond	243	120	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
32812707	32812707	PRJNA825466_S_NODE_1540_length_249_cov_0.875000_g1534_i0	PRJNA825466	1540	249	0.875	2.17875	Clostridium	1485	Bacteria	Bacteria	56.2	2.3e-7	NR	APH21198.1	1491	g1534	i0	45.5	2.09638554216867	55	30	66.3	0	165	1	81	135	APH21198.1 hypothetical protein NPD1_3383 [Clostridium botulinum]	diamond	522	56.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum

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