metadata: contig_metadata: 33 rows where analysis = "diamond", bioproject = "PRJNA407886" and tax

33 rows where analysis = "diamond", bioproject = "PRJNA407886" 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
5521804	5521804	PRJNA407886_P_NODE_71305_length_250_cov_0.870056_g69611_i0	PRJNA407886	71305	250	0.870056	2.17514	Aliicoccus persicus	930138	Bacteria	Bacteria	161	1.3899999999999999e-46	NR	WP_091475955.1	930138	g69611	i0	100	0.996	83	0	99.6	0	2	250	61	143	WP_091475955.1 LLM class flavin-dependent oxidoreductase [Aliicoccus persicus]	diamond	249	161	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Aliicoccus	Aliicoccus persicus
10010169	10010169	PRJNA407886_P_NODE_36228_length_369_cov_1.040541_g34534_i0	PRJNA407886	36228	369	1.040541	3.83959629	Bacillota	1239	Bacteria	Bacteria	192	2.7499999999999997e-54	NR	WP_077140664.1	1817405	g34534	i0	80.5	126.983739837398	123	24	100	0	1	369	564	686	WP_077140664.1 ATP-dependent chaperone ClpB [Abyssicoccus albus]	diamond	46857	193	0.994818652849741	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Abyssicoccaceae	Abyssicoccus	Abyssicoccus albus
15720722	15720722	PRJNA407886_P_NODE_73113_length_248_cov_0.880000_g71419_i0	PRJNA407886	73113	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	80.1	2.28e-17	NR	WP_066446101.1	1796628	g71419	i0	59.6	1.36693548387097	57	21	69	1	171	1	3	57	WP_066446101.1 thioredoxin [Longibaculum muris]	diamond	339	80.1	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Longibaculum	Longibaculum muris
16995073	16995073	PRJNA407886_P_NODE_50454_length_302_cov_2.655022_g48760_i0	PRJNA407886	50454	302	2.655022	8.01816644	Bacillati	1783272	Bacteria	Bacteria	119	3.98e-32	NR	WP_028051727.1	54265	g48760	i0	75.7	20.682119205298	74	18	73.5	0	80	301	2	75	WP_028051727.1 nucleoside-diphosphate kinase [Carboxydothermus ferrireducens]	diamond	6246	120	0.991666666666667	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Carboxydothermus	Carboxydothermus ferrireducens
23369878	23369878	PRJNA407886_P_NODE_61819_length_269_cov_2.938776_g60125_i0	PRJNA407886	61819	269	2.938776	7.90530744	Proteiniclasticum ruminis	398199	Bacteria	Bacteria	135	2.84e-36	NR	WP_074910747.1	398199	g60125	i0	86.3	3.21189591078067	73	10	81.4	0	3	221	267	339	WP_074910747.1 type I glyceraldehyde-3-phosphate dehydrogenase [Proteiniclasticum ruminis]	diamond	864	135	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Proteiniclasticum	Proteiniclasticum ruminis
26726941	26726941	PRJNA407886_P_NODE_58741_length_278_cov_1.087805_g57047_i0	PRJNA407886	58741	278	1.087805	3.0240979	Clostridia bacterium	2044939	Bacteria	Bacteria	100	5.6999999999999995e-25	NR	MBR0266266.1	2044939	g57047	i0	57.7	3.36690647482014	78	33	84.2	0	3	236	46	123	MBR0266266.1 RidA family protein [Clostridia bacterium]	diamond	936	100	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
26758886	26758886	PRJNA407886_P_NODE_52701_length_295_cov_1.729730_g51007_i0	PRJNA407886	52701	295	1.72973	5.1027035	Bacillota bacterium	1879010	Bacteria	Bacteria	42	0.0472	NR	MCL2301437.1	1879010	g51007	i0	40.4	0.579661016949153	57	34	58	0	199	29	65	121	MCL2301437.1 hypothetical protein [Bacillota bacterium]	diamond	171	42	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
27043914	27043914	PRJNA407886_P_NODE_84062_length_212_cov_4.431655_g82368_i0	PRJNA407886	84062	212	4.431655	9.3951086	Eubacteriales bacterium	2831996	Bacteria	Bacteria	54.3	2.13e-6	NR	MDD3765982.1	2831996	g82368	i0	50	0.622641509433962	44	21	60.8	1	13	141	3088	3131	MDD3765982.1 ZmpA/ZmpB/ZmpC family metallo-endopeptidase-related protein [Eubacteriales bacterium]	diamond	132	54.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
27060553	27060553	PRJNA407886_P_NODE_47662_length_313_cov_1.275000_g45968_i0	PRJNA407886	47662	313	1.275	3.99075	Bacteria	2	Bacteria	Bacteria	73.2	1.35e-13	NR	MBR2801563.1	2049044	g45968	i0	48	4.31309904153355	75	37	71.9	1	3	227	95	167	MBR2801563.1 GNAT family N-acetyltransferase [Erysipelotrichaceae bacterium]	diamond	1350	73.6	0.994565217391304	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
27486332	27486332	PRJNA407886_P_NODE_73723_length_248_cov_0.880000_g72029_i0	PRJNA407886	73723	248	0.88	2.1824	Peptostreptococcaceae bacterium	1904861	Bacteria	Bacteria	58.2	1.23e-7	NR	MDO5061637.1	1904861	g72029	i0	52.6	2.05645161290323	57	26	67.7	1	246	79	248	304	MDO5061637.1 stalk domain-containing protein [Peptostreptococcaceae bacterium]	diamond	510	58.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae		Peptostreptococcaceae bacterium
27517914	27517914	PRJNA407886_P_NODE_71263_length_250_cov_0.870056_g69569_i0	PRJNA407886	71263	250	0.870056	2.17514	Tissierellales	1737405	Bacteria	Bacteria	67	3.14e-11	NR	WP_071138888.1	1737405	g69569	i0	50	2.664	74	36	88.8	1	249	28	140	212	WP_071138888.1 MULTISPECIES: GNAT family N-acetyltransferase [Tissierellales]	diamond	666	67	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales
27833531	27833531	PRJNA407886_P_NODE_69784_length_251_cov_0.865169_g68090_i0	PRJNA407886	69784	251	0.865169	2.17157419	Anaerococcus sp.	1872515	Bacteria	Bacteria	79.7	2.83e-16	NR	WP_308767616.1	1872515	g68090	i0	97.5	0.956175298804781	40	1	47.8	0	131	250	1	40	WP_308767616.1 uracil-DNA glycosylase family protein [Anaerococcus sp.]	diamond	240	79.7	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp.
27928332	27928332	PRJNA407886_P_NODE_37145_length_363_cov_1.096552_g35451_i0	PRJNA407886	37145	363	1.096552	3.98048376	Brevibacillus parabrevis	54914	Bacteria	Bacteria	46.2	0.00538	NR	WP_122965685.1	54914	g35451	i0	30.1	1.01652892561983	123	71	91.7	4	349	17	87	206	WP_122965685.1 peptidylprolyl isomerase [Brevibacillus parabrevis]	diamond	369	46.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus parabrevis
28071236	28071236	PRJNA407886_P_NODE_82085_length_241_cov_0.916667_g80391_i0	PRJNA407886	82085	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	45.1	0.00571	NR	HBV82066.1	1898203	g80391	i0	63.3	2.17842323651452	30	11	37.3	0	19	108	902	931	HBV82066.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	525	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28433603	28433603	PRJNA407886_P_NODE_73506_length_248_cov_0.880000_g71812_i0	PRJNA407886	73506	248	0.88	2.1824	Clostridia bacterium	2044939	Bacteria	Bacteria	51.2	4.13e-5	NR	MDE7296545.1	2044939	g71812	i0	36.8	0.689516129032258	57	36	69	0	243	73	581	637	MDE7296545.1 leucine-rich repeat domain-containing protein [Clostridia bacterium]	diamond	171	51.2	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28465215	28465215	PRJNA407886_P_NODE_18646_length_603_cov_1.283019_g16974_i0	PRJNA407886	18646	603	1.283019	7.73660457	Soehngenia saccharolytica	253256	Bacteria	Bacteria	48.5	0.00836	NR	TJX64500.1	253256	g16974	i0	28.7	0.572139303482587	115	71	53.7	4	83	406	121	231	TJX64500.1 hypothetical protein E8P77_12060 [Soehngenia saccharolytica]	diamond	345	48.5	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Soehngenia	Soehngenia saccharolytica
28686360	28686360	PRJNA407886_P_NODE_54667_length_289_cov_1.634259_g52973_i0	PRJNA407886	54667	289	1.634259	4.72300851	Massilibacterium senegalense	1632858	Bacteria	Bacteria	99.4	1.7e-24	NR	WP_062199444.1	1632858	g52973	i0	57.8	2.53287197231834	83	35	86.2	0	1	249	39	121	WP_062199444.1 group I truncated hemoglobin [Massilibacterium senegalense]	diamond	732	99.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Massilibacterium	Massilibacterium senegalense
28843811	28843811	PRJNA407886_P_NODE_74048_length_247_cov_1.706897_g72354_i0	PRJNA407886	74048	247	1.706897	4.21603559	Cohnella endophytica	2419778	Bacteria	Bacteria	62	5.97e-9	NR	WP_120976945.1	2419778	g72354	i0	50.9	0.692307692307692	57	28	69.2	0	51	221	352	408	WP_120976945.1 ammonium transporter [Cohnella endophytica]	diamond	171	62	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella endophytica
29506937	29506937	PRJNA407886_P_NODE_35510_length_373_cov_4.686667_g33816_i0	PRJNA407886	35510	373	4.686667	17.48126791	Eubacteriales bacterium	2831996	Bacteria	Bacteria	55.8	4.54e-6	NR	MDD3765982.1	2831996	g33816	i0	33.7	0.715817694369973	89	39	70.8	3	43	306	3062	3131	MDD3765982.1 ZmpA/ZmpB/ZmpC family metallo-endopeptidase-related protein [Eubacteriales bacterium]	diamond	267	55.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
29822562	29822562	PRJNA407886_P_NODE_81191_length_241_cov_1.422619_g79497_i0	PRJNA407886	81191	241	1.422619	3.42851179	Catonella morbi	43997	Bacteria	Bacteria	126	1.37e-34	NR	WP_023356025.1	43997	g79497	i0	82.1	0.970954356846473	78	14	97.1	0	6	239	53	130	WP_023356025.1 DUF4230 domain-containing protein [Catonella morbi]	diamond	234	126	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Catonella	Catonella morbi
29871068	29871068	PRJNA407886_P_NODE_76971_length_245_cov_0.895349_g75277_i0	PRJNA407886	76971	245	0.895349	2.19360505	Enterococcus	1350	Bacteria	Bacteria	47.8	6.69e-4	NR	MDU6522882.1	35783	g75277	i0	43.8	1.83673469387755	48	27	58.8	0	191	48	1148	1195	MDU6522882.1 SpaA isopeptide-forming pilin-related protein [Enterococcus sp.]	diamond	450	47.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus sp.
29949215	29949215	PRJNA407886_P_NODE_71371_length_250_cov_0.870056_g69677_i0	PRJNA407886	71371	250	0.870056	2.17514	Pelotomaculum sp. PtaU1.Bin	2053590	Bacteria	Bacteria	44.7	0.00763	NR	OPY57353.1	1811695	g69677	i0	40.8	1.704	71	34	84	2	37	246	19	82	OPY57353.1 MAG: hypothetical protein A4E55_01750 [Pelotomaculum sp. PtaU1.Bin035]	diamond	426	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfotomaculaceae	Pelotomaculum	Pelotomaculum sp. PtaU1.Bin035
30029073	30029073	PRJNA407886_P_NODE_12591_length_826_cov_6.883134_g11137_i0	PRJNA407886	12591	826	6.883134	56.85468684	root	1	Root_unresolved	Root_unresolved	309	2.49e-100	NR	QHG77622.1	1280	g11137	i0	67.1	77.8002421307506	219	72	79.5	0	714	58	55	273	QHG77622.1 30S ribosomal protein S5 [Staphylococcus aureus]	diamond	64263	312	0.990384615384615	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30106992	30106992	PRJNA407886_P_NODE_38172_length_356_cov_2.717314_g36478_i0	PRJNA407886	38172	356	2.717314	9.67363784	Eubacteriales bacterium	2831996	Bacteria	Bacteria	53.1	3.27e-5	NR	MDD3765982.1	2831996	g36478	i0	46	0.421348314606742	50	26	41.3	1	125	271	3082	3131	MDD3765982.1 ZmpA/ZmpB/ZmpC family metallo-endopeptidase-related protein [Eubacteriales bacterium]	diamond	150	53.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
30612502	30612502	PRJNA407886_P_NODE_73573_length_248_cov_0.880000_g71879_i0	PRJNA407886	73573	248	0.88	2.1824	Clostridia bacterium	2044939	Bacteria	Bacteria	46.2	0.00134	NR	MBO7151690.1	2044939	g71879	i0	59.5	1.34274193548387	37	15	44.8	0	1	111	36	72	MBO7151690.1 J domain-containing protein [Clostridia bacterium]	diamond	333	46.2	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
31040309	31040309	PRJNA407886_P_NODE_61595_length_270_cov_1.563452_g59901_i0	PRJNA407886	61595	270	1.563452	4.2213204	Bacillati	1783272	Bacteria	Bacteria	58.5	7.6e-8	NR	WP_300228541.1	142586	g59901	i0	41.4	3.83333333333333	70	38	77.8	1	270	61	162	228	WP_300228541.1 CorA family divalent cation transporter [Eubacterium sp.]	diamond	1035	58.9	0.99320882852292	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium sp.
31229405	31229405	PRJNA407886_P_NODE_41575_length_338_cov_2.316981_g39881_i0	PRJNA407886	41575	338	2.316981	7.83139578	Bacteria	2	Bacteria	Bacteria	45.8	0.00932	NR	MCI5863028.1	1898203	g39881	i0	37.1	1.11834319526627	62	38	54.1	1	150	332	375	436	MCI5863028.1 RICIN domain-containing protein [Lachnospiraceae bacterium]	diamond	378	46.2	0.991341991341991	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
31276148	31276148	PRJNA407886_P_NODE_82155_length_241_cov_0.916667_g80461_i0	PRJNA407886	82155	241	0.916667	2.20916747	Jeotgalibacillus proteolyticus	2082395	Bacteria	Bacteria	42.7	0.0344	NR	WP_167578550.1	2082395	g80461	i0	36.1	0.759336099585062	61	33	71	2	27	197	309	367	WP_167578550.1 nucleotidyltransferase [Jeotgalibacillus proteolyticus]	diamond	183	42.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Jeotgalibacillus	Jeotgalibacillus proteolyticus
31592716	31592716	PRJNA407886_P_NODE_78096_length_244_cov_0.900585_g76402_i0	PRJNA407886	78096	244	0.900585	2.1974274	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.1	0.0281	NR	MCI6887157.1	1898203	g76402	i0	41.4	0.713114754098361	58	28	70.1	3	244	74	219	271	MCI6887157.1 extracellular solute-binding protein [Lachnospiraceae bacterium]	diamond	174	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
31957031	31957031	PRJNA407886_P_NODE_58497_length_278_cov_2.078049_g56803_i0	PRJNA407886	58497	278	2.078049	5.77697622	Bacillota	1239	Bacteria	Bacteria	47.8	9.33e-4	NR	WP_070144216.1	1405	g56803	i0	37.3	1.42446043165468	67	41	71.2	1	278	81	32	98	WP_070144216.1 RICIN domain-containing protein [Bacillus mycoides]	diamond	396	47.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
32003819	32003819	PRJNA407886_P_NODE_75898_length_246_cov_0.890173_g74204_i0	PRJNA407886	75898	246	0.890173	2.18982558	Bacillus thuringiensis	1428	Bacteria	Bacteria	53.1	5.06e-7	NR	MRB67761.1	1428	g74204	i0	61.4	0.536585365853659	44	17	53.7	0	114	245	7	50	MRB67761.1 hypothetical protein [Bacillus thuringiensis]	diamond	132	53.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
32098632	32098632	PRJNA407886_P_NODE_64498_length_263_cov_1.100000_g62804_i0	PRJNA407886	64498	263	1.1	2.893	Lentilactobacillus raoultii	1987503	Bacteria	Bacteria	40.8	0.0401	NR	WP_121978453.1	1987503	g62804	i0	44.4	0.4106463878327	36	20	41.1	0	13	120	42	77	WP_121978453.1 hypothetical protein [Lentilactobacillus raoultii]	diamond	108	40.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lentilactobacillus	Lentilactobacillus raoultii
32541893	32541893	PRJNA407886_P_NODE_78019_length_244_cov_0.900585_g76325_i0	PRJNA407886	78019	244	0.900585	2.1974274	Aedoeadaptatus coxii	755172	Bacteria	Bacteria	160	1.66e-47	NR	WP_322627486.1	755172	g76325	i0	97.5	0.995901639344262	81	2	99.6	0	1	243	150	230	WP_322627486.1 ABC transporter ATP-binding protein [Aedoeadaptatus coxii]	diamond	243	160	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Aedoeadaptatus	Aedoeadaptatus coxii

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