metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA950981" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA950981" 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
7311884	7311884	PRJNA950981_P_NODE_19626_length_246_cov_0.901734_g19450_i0	PRJNA950981	19626	246	0.901734	2.21826564	Anaerococcus sp.	1872515	Bacteria	Bacteria	105	8.7e-28	NR	MDU5229872.1	1872515	g19450	i0	100	0.658536585365854	54	0	65.9	0	2	163	6	59	MDU5229872.1 hypothetical protein [Anaerococcus sp.]	diamond	162	105	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp.
22610815	22610815	PRJNA950981_P_NODE_11778_length_299_cov_1.212389_g11602_i0	PRJNA950981	11778	299	1.212389	3.62504311	Bacteria	2	Bacteria	Bacteria	151	2.26e-42	NR	MBR5479408.1	2044939	g11602	i0	71.4	14.6588628762542	98	28	98.3	0	1	294	209	306	MBR5479408.1 UDP-glucose 4-epimerase GalE [Clostridia bacterium]	diamond	4383	151	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
27190042	27190042	PRJNA950981_P_NODE_18002_length_250_cov_0.881356_g17826_i0	PRJNA950981	18002	250	0.881356	2.20339	Bacteria	2	Bacteria	Bacteria	84	1.23e-16	NR	MBP3887817.1	1926876	g17826	i0	52.4	24.864	84	36	97.2	2	248	6	216	298	MBP3887817.1 UvrD-helicase domain-containing protein [Cellulosilyticum sp.]	diamond	6216	84.3	0.99644128113879	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Cellulosilyticaceae	Cellulosilyticum	Cellulosilyticum sp.
28036412	28036412	PRJNA950981_P_NODE_15525_length_261_cov_1.648936_g15349_i0	PRJNA950981	15525	261	1.648936	4.30372296	Leuconostoc mesenteroides	1245	Bacteria	Bacteria	43.1	0.0292	NR	WP_114668796.1	1245	g15349	i0	36.7	0.689655172413793	60	38	69	0	208	29	172	231	WP_114668796.1 amino acid ABC transporter ATP-binding protein [Leuconostoc mesenteroides]	diamond	180	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc mesenteroides
29488540	29488540	PRJNA950981_P_NODE_12750_length_288_cov_1.293023_g12574_i0	PRJNA950981	12750	288	1.293023	3.72390624	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	101	7.36e-26	NR	WP_229963743.1	1590	g12574	i0	100	0.729166666666667	70	0	72.9	0	287	78	4	73	WP_229963743.1 hypothetical protein [Lactiplantibacillus plantarum]	diamond	210	101	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
31415991	31415991	PRJNA950981_P_NODE_20736_length_244_cov_0.912281_g20560_i0	PRJNA950981	20736	244	0.912281	2.22596564	Salicibibacter cibarius	2743000	Bacteria	Bacteria	43.1	0.0256	NR	WP_200123581.1	2743000	g20560	i0	37.5	0.688524590163934	56	34	68.9	1	40	207	35	89	WP_200123581.1 DUF3100 domain-containing protein [Salicibibacter cibarius]	diamond	168	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salicibibacter	Salicibibacter cibarius
31858704	31858704	PRJNA950981_P_NODE_12937_length_286_cov_1.464789_g12761_i0	PRJNA950981	12937	286	1.464789	4.18929654	Roseburia sp.	2049040	Bacteria	Bacteria	51.2	6.21e-5	NR	HAT89477.1	2049040	g12761	i0	39.7	0.713286713286713	68	38	71.3	1	204	1	116	180	HAT89477.1 hypothetical protein [Roseburia sp.]	diamond	204	51.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia sp.
32371827	32371827	PRJNA950981_P_NODE_19559_length_246_cov_1.699422_g19383_i0	PRJNA950981	19559	246	1.699422	4.18057812	Paenibacillaceae	186822	Bacteria	Bacteria	103	2.54e-26	NR	WP_204516782.1	1125967	g19383	i0	71.9	7.24390243902439	64	18	78	0	50	241	2	65	WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus]	diamond	1782	103	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus

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