metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA694557" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA694557" 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
14702161	14702161	PRJNA694557_P_NODE_12592_length_373_cov_2.543333_g12372_i0	PRJNA694557	12592	373	2.543333	9.48663209	Christensenellaceae bacterium	2054177	Bacteria	Bacteria	210	1.95e-64	NR	MDR2514738.1	2054177	g12372	i0	86.8	2.94369973190349	121	16	97.3	0	373	11	249	369	MDR2514738.1 methionine adenosyltransferase [Christensenellaceae bacterium]	diamond	1098	210	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales	Christensenellaceae		Christensenellaceae bacterium
21075942	21075942	PRJNA694557_P_NODE_5317_length_642_cov_6.479789_g5099_i0	PRJNA694557	5317	642	6.479789	41.60024538	Alkalihalobacterium chitinilyticum	2980103	Bacteria	Bacteria	276	1.55e-88	NR	WP_275120281.1	2980103	g5099	i0	100	0.682242990654206	146	0	68.2	0	641	204	258	403	WP_275120281.1 MDR family MFS transporter [Alkalihalobacterium chitinilyticum]	diamond	438	276	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium chitinilyticum
26670774	26670774	PRJNA694557_P_NODE_4961_length_668_cov_2.366387_g4745_i0	PRJNA694557	4961	668	2.366387	15.80746516	Cohnella sp. GCM1	1883426	Bacteria	Bacteria	72	1.51e-10	NR	WP_378153644.1	3273389	g4745	i0	29.2	1.04640718562874	233	122	92.5	8	47	664	28	244	WP_378153644.1 discoidin domain-containing protein [Cohnella sp. GCM10027633]	diamond	699	72	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella sp. GCM10027633
28345831	28345831	PRJNA694557_P_NODE_15386_length_330_cov_1.766537_g15166_i0	PRJNA694557	15386	330	1.766537	5.8295721	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	45.1	0.0155	NR	MBP3913147.1	1898203	g15166	i0	29	6.03636363636364	107	65	93.6	3	17	325	285	384	MBP3913147.1 glycoside hydrolase family 2 protein [Lachnospiraceae bacterium]	diamond	1992	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28377336	28377336	PRJNA694557_P_NODE_25906_length_241_cov_0.916667_g25686_i0	PRJNA694557	25906	241	0.916667	2.20916747	Brevibacillus sp. MCWH	2508871	Bacteria	Bacteria	104	8.47e-26	NR	WP_216369602.1	2508871	g25686	i0	66.2	0.846473029045643	68	23	84.6	0	223	20	1	68	WP_216369602.1 hypothetical protein, partial [Brevibacillus sp. MCWH]	diamond	204	104	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus sp. MCWH
28946031	28946031	PRJNA694557_P_NODE_18148_length_298_cov_1.262222_g17928_i0	PRJNA694557	18148	298	1.262222	3.76142156	Clostridium cylindrosporum	1495	Bacteria	Bacteria	79	9.08e-15	NR	WP_048569099.1	1495	g17928	i0	43.3	0.906040268456376	90	51	90.6	0	13	282	153	242	WP_048569099.1 hypothetical protein [Clostridium cylindrosporum]	diamond	270	79	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium cylindrosporum
29103780	29103780	PRJNA694557_P_NODE_21948_length_262_cov_2.629630_g21728_i0	PRJNA694557	21948	262	2.62963	6.8896306	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	59.3	9.31e-10	NR	KZU89800.1	1590	g21728	i0	72.5	1.77480916030534	40	11	45.8	0	78	197	1	40	KZU89800.1 hypothetical protein Nizo3893_2340 [Lactiplantibacillus plantarum]	diamond	465	59.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
30304235	30304235	PRJNA694557_P_NODE_13812_length_353_cov_2.682143_g13592_i0	PRJNA694557	13812	353	2.682143	9.46796479	Sutcliffiella cohnii	33932	Bacteria	Bacteria	142	2.9199999999999996e-37	NR	WP_328226299.1	33932	g13592	i0	74.3	0.858356940509915	101	26	85.8	0	325	23	60	160	WP_328226299.1 hypothetical protein [Sutcliffiella cohnii]	diamond	303	142	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Sutcliffiella	Sutcliffiella cohnii
30473170	30473170	PRJNA694557_P_NODE_16913_length_311_cov_2.941176_g16693_i0	PRJNA694557	16913	311	2.941176	9.14705736	Bacillota	1239	Bacteria	Bacteria	166	4.39e-47	NR	WP_072977130.1	43131	g16693	i0	80.4	3.7427652733119	97	16	93.6	1	20	310	58	151	WP_072977130.1 adenosylmethionine--8-amino-7-oxononanoate transaminase [Tissierella praeacuta]	diamond	1164	166	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Tissierella	Tissierella praeacuta
31599741	31599741	PRJNA694557_P_NODE_2756_length_940_cov_3.118800_g2574_i0	PRJNA694557	2756	940	3.1188	29.31672	Alkalihalobacterium chitinilyticum	2980103	Bacteria	Bacteria	435	2.6799999999999993e-152	NR	WP_373323137.1	2980103	g2574	i0	99	0.667021276595745	209	2	66.7	0	211	837	1	209	WP_373323137.1 nuclease-related domain-containing protein [Alkalihalobacterium chitinilyticum]	diamond	627	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium chitinilyticum
31757706	31757706	PRJNA694557_P_NODE_8917_length_463_cov_1.871795_g8697_i0	PRJNA694557	8917	463	1.871795	8.66641085	Anoxybacillus flavithermus	33934	Bacteria	Bacteria	60.8	2.54e-8	NR	WP_192953109.1	33934	g8697	i0	50	0.453563714902808	70	30	45.4	1	354	145	87	151	WP_192953109.1 BC1872 family protein [Anoxybacillus flavithermus]	diamond	210	60.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
31820855	31820855	PRJNA694557_P_NODE_7697_length_510_cov_3.043478_g7477_i0	PRJNA694557	7697	510	3.043478	15.5217378	Gottschalkia purinilytica	1503	Bacteria	Bacteria	124	1.3899999999999999e-31	NR	WP_050354029.1	1503	g7477	i0	85.3	0.441176470588235	75	11	44.1	0	493	269	169	243	WP_050354029.1 Crp/Fnr family transcriptional regulator [Gottschalkia purinilytica]	diamond	225	124	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Gottschalkiaceae	Gottschalkia	Gottschalkia purinilytica
31884177	31884177	PRJNA694557_P_NODE_19057_length_288_cov_2.111628_g18837_i0	PRJNA694557	19057	288	2.111628	6.08148864	Alkalibacterium thalassium	426701	Bacteria	Bacteria	168	4.75e-46	NR	WP_091267210.1	426701	g18837	i0	93.3	0.9375	90	6	93.8	0	270	1	291	380	WP_091267210.1 DNA mismatch repair protein MutS [Alkalibacterium thalassium]	diamond	270	168	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Alkalibacterium	Alkalibacterium thalassium
32200713	32200713	PRJNA694557_P_NODE_12798_length_369_cov_3.665541_g12578_i0	PRJNA694557	12798	369	3.665541	13.52584629	Peptoniphilus	162289	Bacteria	Bacteria	207	3.26e-65	NR	WP_010248000.1	162289	g12578	i0	100	0.934959349593496	115	0	93.5	0	368	24	114	228	WP_010248000.1 MULTISPECIES: hypothetical protein [Peptoniphilus]	diamond	345	207	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus
32359157	32359157	PRJNA694557_P_NODE_17399_length_306_cov_1.321888_g17179_i0	PRJNA694557	17399	306	1.321888	4.04497728	Jeotgalicoccus halotolerans	157227	Bacteria	Bacteria	171	4.6e-47	NR	WP_115885937.1	157227	g17179	i0	93.9	0.96078431372549	98	6	96.1	0	296	3	483	580	WP_115885937.1 ATP-dependent chaperone ClpB [Jeotgalicoccus halotolerans]	diamond	294	171	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus halotolerans
32390551	32390551	PRJNA694557_P_NODE_24059_length_248_cov_1.108571_g23839_i0	PRJNA694557	24059	248	1.108571	2.74925608	Clostridium sp.	1506	Bacteria	Bacteria	100	2.58e-23	NR	MEG0371882.1	1506	g23839	i0	68	3.71370967741935	75	24	90.7	0	22	246	14	88	MEG0371882.1 YicC/YloC family endoribonuclease [Clostridium sp.]	diamond	921	100	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.

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