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

10 rows where analysis = "diamond", bioproject = "PRJNA896973" 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
2148482	2148482	PRJNA896973_P_NODE_20802_length_255_cov_1.620879_g20708_i0	PRJNA896973	20802	255	1.620879	4.13324145	Enterococcus faecium	1352	Bacteria	Bacteria	137	1.83e-40	NR	MFN1222476.1	1352	g20708	i0	100	0.905882352941176	77	0	90.6	0	232	2	1	77	MFN1222476.1 hypothetical protein [Enterococcus faecium]	diamond	231	137	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
24195549	24195549	PRJNA896973_P_NODE_22359_length_250_cov_0.870056_g22265_i0	PRJNA896973	22359	250	0.870056	2.17514	Alterileibacterium massiliense	1870997	Bacteria	Bacteria	157	8.06e-45	NR	WP_071132773.1	1870997	g22265	i0	100	0.996	83	0	99.6	0	250	2	97	179	WP_071132773.1 ABC transporter ATP-binding protein [Alterileibacterium massiliense]	diamond	249	157	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Alterileibacterium	Alterileibacterium massiliense
26897645	26897645	PRJNA896973_P_NODE_26981_length_243_cov_0.888235_g26887_i0	PRJNA896973	26981	243	0.888235	2.15841105	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	42.7	0.0353	NR	WP_227149811.1	1590	g26887	i0	32.8	1.5679012345679	64	41	76.5	1	195	10	115	178	WP_227149811.1 dTDP-4-dehydrorhamnose reductase [Lactiplantibacillus plantarum]	diamond	381	43.1	0.990719257540603	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
28540291	28540291	PRJNA896973_S_NODE_1927_length_283_cov_1.904762_g1913_i0	PRJNA896973	1927	283	1.904762	5.39047646	Compostibacillus humi	1245525	Bacteria	Bacteria	154	7.81e-44	NR	WP_308421535.1	1245525	g1913	i0	92.8	0.879858657243816	83	6	88	0	263	15	47	129	WP_308421535.1 ABC transporter ATP-binding protein [Compostibacillus humi]	diamond	249	154	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Compostibacillus	Compostibacillus humi
29550220	29550220	PRJNA896973_P_NODE_27010_length_242_cov_2.964497_g26916_i0	PRJNA896973	27010	242	2.964497	7.17408274	Streptococcus pneumoniae	1313	Bacteria	Bacteria	68.6	4.29e-13	NR	WP_216969834.1	1313	g26916	i0	100	0.433884297520661	35	0	43.4	0	1	105	46	80	WP_216969834.1 hypothetical protein, partial [Streptococcus pneumoniae]	diamond	105	68.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
29802930	29802930	PRJNA896973_S_NODE_2991_length_232_cov_2.037736_g2977_i0	PRJNA896973	2991	232	2.037736	4.72754752	Clostridia bacterium	2044939	Bacteria	Bacteria	45.4	0.00346	NR	MBR0230735.1	2044939	g2977	i0	64.9	1.00862068965517	37	13	47.8	0	157	47	257	293	MBR0230735.1 hypothetical protein [Clostridia bacterium]	diamond	234	45.4	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
31699258	31699258	PRJNA896973_S_NODE_957_length_376_cov_3.528053_g943_i0	PRJNA896973	957	376	3.528053	13.26547928	Blautia stercoris	871664	Bacteria	Bacteria	88.2	1.3e-17	NR	WP_372554359.1	871664	g943	i0	75.5	0.422872340425532	53	13	42.3	0	162	4	252	304	WP_372554359.1 IS200/IS605 family accessory protein TnpB-related protein [Blautia stercoris]	diamond	159	88.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia stercoris
31825566	31825566	PRJNA896973_P_NODE_18897_length_266_cov_1.207254_g18803_i0	PRJNA896973	18897	266	1.207254	3.21129564	Listeria monocytogenes	1639	Bacteria	Bacteria	143	3.47e-40	NR	HAB7350312.1	1639	g18803	i0	80.5	0.981203007518797	87	17	98.1	0	6	266	117	203	HAB7350312.1 RepB family plasmid replication initiator protein [Listeria monocytogenes]	diamond	261	143	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
32805370	32805370	PRJNA896973_S_NODE_980_length_373_cov_4.186667_g966_i0	PRJNA896973	980	373	4.186667	15.61626791	Staphylococcus aureus	1280	Bacteria	Bacteria	177	3.089999999999999e-55	NR	WP_407809854.1	1280	g966	i0	91.8	0.788203753351206	98	8	78.8	0	344	51	1	98	WP_407809854.1 hypothetical protein [Staphylococcus aureus]	diamond	294	177	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32836829	32836829	PRJNA896973_S_NODE_740_length_425_cov_3.446023_g726_i0	PRJNA896973	740	425	3.446023	14.64559775	Oribacterium sinus	237576	Bacteria	Bacteria	142	3.01e-37	NR	WP_007157777.1	237576	g726	i0	95.9	0.515294117647059	73	3	51.5	0	186	404	1	73	WP_007157777.1 ATP-binding protein [Oribacterium sinus]	diamond	219	142	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Oribacterium	Oribacterium sinus

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