metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1233317" 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
1047120	1047120	PRJNA1233317_S_NODE_2821_length_366_cov_3.576547_g2785_i0	PRJNA1233317	2821	366	3.576547	13.09016202	Clostridia	186801	Bacteria	Bacteria	236	3.52e-73	NR	MCI5504112.1	142586	g2785	i0	91	20.9672131147541	122	11	100	0	366	1	76	197	MCI5504112.1 IS1634 family transposase [Eubacterium sp.]	diamond	7674	236	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium sp.
2886512	2886512	PRJNA1233317_S_NODE_13623_length_209_cov_2.033333_g13587_i0	PRJNA1233317	13623	209	2.033333	4.24966597	Lacrimispora sp.	2719234	Bacteria	Bacteria	128	7.16e-34	NR	MFT4006820.1	2719234	g13587	i0	100	0.990430622009569	69	0	99	0	3	209	276	344	MFT4006820.1 type II secretion system F family protein [Lacrimispora sp.]	diamond	207	128	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lacrimispora	Lacrimispora sp.
10539472	10539472	PRJNA1233317_S_NODE_13469_length_210_cov_5.317881_g13433_i0	PRJNA1233317	13469	210	5.317881	11.1675501	Clostridia bacterium	2044939	Bacteria	Bacteria	137	2.19e-36	NR	MBO5458324.1	2044939	g13433	i0	100	2	70	0	100	0	1	210	11	80	MBO5458324.1 DUF1846 domain-containing protein [Clostridia bacterium]	diamond	420	137	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
11814250	11814250	PRJNA1233317_S_NODE_1830_length_399_cov_2.858824_g1794_i0	PRJNA1233317	1830	399	2.858824	11.40670776	Bacilli bacterium	1903720	Bacteria	Bacteria	171	3.96e-51	NR	MBQ4030131.1	1903720	g1794	i0	70.5	0.917293233082707	122	36	91.7	0	3	368	100	221	MBQ4030131.1 ThiF family adenylyltransferase [Bacilli bacterium]	diamond	366	171	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
19461617	19461617	PRJNA1233317_S_NODE_14176_length_204_cov_2.944828_g14140_i0	PRJNA1233317	14176	204	2.944828	6.00744912	Frisingicoccus	1918511	Bacteria	Bacteria	138	1.44e-36	NR	WP_132090597.1	1796636	g14140	i0	94	2.95588235294118	67	4	98.5	0	3	203	295	361	WP_132090597.1 arginine--tRNA ligase [Frisingicoccus caecimuris]	diamond	603	138	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Frisingicoccus	Frisingicoccus caecimuris
27673181	27673181	PRJNA1233317_S_NODE_6404_length_295_cov_9.355932_g6368_i0	PRJNA1233317	6404	295	9.355932	27.5999994	Streptococcus anginosus	1328	Bacteria	Bacteria	65.9	4.62e-10	NR	WP_330942626.1	1328	g6368	i0	47.1	1.42372881355932	70	31	65.1	1	226	35	281	350	WP_330942626.1 hypothetical protein [Streptococcus anginosus]	diamond	420	65.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus anginosus
29125679	29125679	PRJNA1233317_S_NODE_6769_length_290_cov_3.095238_g6733_i0	PRJNA1233317	6769	290	3.095238	8.9761902	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	170	1.06e-47	NR	MBP3478889.1	2485925	g6733	i0	91.7	4.96551724137931	96	8	99.3	0	2	289	496	591	MBP3478889.1 ABC transporter ATP-binding protein [Oscillospiraceae bacterium]	diamond	1440	170	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
29144454	29144454	PRJNA1233317_S_NODE_6469_length_294_cov_6.540426_g6433_i0	PRJNA1233317	6469	294	6.540426	19.22885244	Bacillales	1385	Bacteria	Bacteria	64.7	1.02e-9	NR	WP_013487399.1	1413	g6433	i0	94.4	2.57142857142857	36	2	36.7	0	185	292	1	36	WP_013487399.1 sodium-dependent bicarbonate transport family permease [Evansella cellulosilytica]	diamond	756	64.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Evansella	Evansella cellulosilytica
29157173	29157173	PRJNA1233317_S_NODE_14429_length_202_cov_2.986014_g14393_i0	PRJNA1233317	14429	202	2.986014	6.03174828	Agathobacter rectalis	39491	Bacteria	Bacteria	43.1	0.00184	NR	WP_306785560.1	39491	g14393	i0	54.1	1.12871287128713	37	17	55	0	85	195	1	37	WP_306785560.1 hypothetical protein, partial [Agathobacter rectalis]	diamond	228	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
29346519	29346519	PRJNA1233317_S_NODE_15009_length_198_cov_2.194245_g14973_i0	PRJNA1233317	15009	198	2.194245	4.3446051	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	54.7	1.98e-7	NR	MBE6762333.1	2485925	g14973	i0	63.2	1.15151515151515	38	14	57.6	0	115	2	1	38	MBE6762333.1 sporulation protein YtfJ [Oscillospiraceae bacterium]	diamond	228	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
29567318	29567318	PRJNA1233317_S_NODE_4630_length_326_cov_2.284644_g4594_i0	PRJNA1233317	4630	326	2.284644	7.44793944	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	203	1.32e-64	NR	MBR3187411.1	1898203	g4594	i0	100	0.993865030674847	108	0	99.4	0	3	326	58	165	MBR3187411.1 ATP synthase subunit I [Lachnospiraceae bacterium]	diamond	324	203	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
29807090	29807090	PRJNA1233317_S_NODE_2531_length_375_cov_2.873418_g2495_i0	PRJNA1233317	2531	375	2.873418	10.7753175	Ruoffia	2862144	Bacteria	Bacteria	102	9.36e-23	NR	WP_328590758.1	87458	g2495	i0	53.8	1.488	93	41	74.4	1	322	44	348	438	WP_328590758.1 glucosaminidase domain-containing protein [Ruoffia tabacinasalis]	diamond	558	102	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Ruoffia	Ruoffia tabacinasalis
30831026	30831026	PRJNA1233317_S_NODE_5634_length_307_cov_7.012097_g5598_i0	PRJNA1233317	5634	307	7.012097	21.52713779	Roseburia zhanii	2763064	Bacteria	Bacteria	129	4.2799999999999997e-32	NR	WP_186867037.1	2763064	g5598	i0	71.6	1.85667752442997	95	27	92.8	0	299	15	1567	1661	WP_186867037.1 beta-L-arabinofuranosidase domain-containing protein [Roseburia zhanii]	diamond	570	129	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia zhanii
30894405	30894405	PRJNA1233317_S_NODE_8314_length_267_cov_31.245192_g8278_i0	PRJNA1233317	8314	267	31.245192	83.42466264	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	70.5	1.32e-13	NR	WP_252130143.1	1590	g8278	i0	70.8	6.98876404494382	48	14	53.9	0	1	144	42	89	WP_252130143.1 hypothetical protein, partial [Lactiplantibacillus plantarum]	diamond	1866	70.9	0.994358251057828	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
32444255	32444255	PRJNA1233317_S_NODE_1019_length_456_cov_5.254408_g983_i0	PRJNA1233317	1019	456	5.254408	23.96010048	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	174	1.09e-48	NR	MBR5337732.1	1898203	g983	i0	58.9	0.993421052631579	151	61	98.7	1	453	4	101	251	MBR5337732.1 DUF2142 domain-containing protein [Lachnospiraceae bacterium]	diamond	453	174	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae 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);;