metadata: contig_metadata: 30 rows where analysis = "diamond", bioproject = "PRJNA609258" and tax

30 rows where analysis = "diamond", bioproject = "PRJNA609258" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1863906	1863906	PRJNA609258_P_NODE_58002_length_244_cov_0.912281_g57617_i0	PRJNA609258	58002	244	0.912281	2.22596564	Microbacterium	33882	Bacteria	Bacteria	125	8.03e-32	NR	WP_165801242.1	2033	g57617	i0	98.6	1.80737704918033	74	1	91	0	222	1	117	190	WP_165801242.1 sensor histidine kinase [Microbacterium testaceum]	diamond	441	125	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
4415451	4415451	PRJNA609258_P_NODE_54404_length_248_cov_0.891429_g54019_i0	PRJNA609258	54404	248	0.891429	2.21074392	Cylindrospermopsis	77021	Bacteria	Bacteria	52.8	1.19e-5	NR	WP_218773708.1	77022	g54019	i0	39	3.95564516129032	82	45	96.8	2	7	246	448	526	WP_218773708.1 beta strand repeat-containing protein [Cylindrospermopsis raciborskii]	diamond	981	53.1	0.994350282485876	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cylindrospermopsis	Cylindrospermopsis raciborskii
6965811	6965811	PRJNA609258_P_NODE_43006_length_278_cov_1.043902_g42621_i0	PRJNA609258	43006	278	1.043902	2.90204756	Geodermatophilus sp.	52020	Bacteria	Bacteria	146	3.04e-39	NR	HST99102.1	52020	g42621	i0	69.2	9.90647482014388	91	28	98.2	0	2	274	107	197	HST99102.1 acetyl-CoA hydrolase/transferase family protein [Geodermatophilus sp.]	diamond	2754	146	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Geodermatophilus	Geodermatophilus sp.
26795345	26795345	PRJNA609258_P_NODE_50421_length_252_cov_0.871508_g50036_i0	PRJNA609258	50421	252	0.871508	2.19620016	Microbacterium testaceum	2033	Bacteria	Bacteria	89	2.8e-20	NR	WP_116537810.1	2033	g50036	i0	97.8	0.535714285714286	45	1	53.6	0	2	136	107	151	WP_116537810.1 hypothetical protein [Microbacterium testaceum]	diamond	135	89	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
27522448	27522448	PRJNA609258_P_NODE_54123_length_248_cov_0.891429_g53738_i0	PRJNA609258	54123	248	0.891429	2.21074392	Mycobacteroides franklinii	948102	Bacteria	Bacteria	61.6	1.42e-9	NR	WP_078281761.1	948102	g53738	i0	52.1	0.883064516129032	73	31	88.3	2	220	2	1	69	WP_078281761.1 hypothetical protein [Mycobacteroides franklinii]	diamond	219	61.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides franklinii
27585682	27585682	PRJNA609258_P_NODE_46704_length_263_cov_1.205263_g46319_i0	PRJNA609258	46704	263	1.205263	3.16984169	Parvimonas sp. M13	3110694	Bacteria	Bacteria	50.1	9.25e-5	NR	WP_324000474.1	3110694	g46319	i0	42.3	0.809885931558935	71	40	81	1	214	2	7	76	WP_324000474.1 interleukin-like EMT inducer domain-containing protein, partial [Parvimonas sp. M13]	diamond	213	50.1	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas sp. M13
27617370	27617370	PRJNA609258_P_NODE_52504_length_250_cov_0.881356_g52119_i0	PRJNA609258	52504	250	0.881356	2.20339	Microbacterium testaceum	2033	Bacteria	Bacteria	171	2.07e-47	NR	WP_116537362.1	2033	g52119	i0	100	0.996	83	0	99.6	0	1	249	171	253	WP_116537362.1 ATP-binding cassette domain-containing protein [Microbacterium testaceum]	diamond	249	171	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
28280068	28280068	PRJNA609258_P_NODE_47886_length_258_cov_1.264865_g47501_i0	PRJNA609258	47886	258	1.264865	3.2633517	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	43.9	0.0174	NR	WP_356315796.1	3155344	g47501	i0	53.3	0.523255813953488	45	19	51.2	2	67	198	176	219	WP_356315796.1 DUF6056 family protein [Streptomyces sp. NPDC005426]	diamond	135	43.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC005426
28501396	28501396	PRJNA609258_P_NODE_59827_length_242_cov_0.923077_g59442_i0	PRJNA609258	59827	242	0.923077	2.23384634	Schaalia georgiae	52768	Bacteria	Bacteria	101	1.7199999999999995e-23	NR	WP_341532730.1	52768	g59442	i0	67.9	0.966942148760331	78	25	96.7	0	239	6	251	328	WP_341532730.1 zinc-binding dehydrogenase [Schaalia georgiae]	diamond	234	101	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia georgiae
29082862	29082862	PRJNA609258_P_NODE_45908_length_266_cov_1.212435_g45523_i0	PRJNA609258	45908	266	1.212435	3.2250771	Bacteria	2	Bacteria	Bacteria	177	2.0299999999999993e-55	NR	MFV3464652.1	1773	g45523	i0	100	1.98496240601504	88	0	99.2	0	3	266	48	135	MFV3464652.1 polysaccharide biosynthesis/export family protein [Mycobacterium tuberculosis]	diamond	528	177	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis
29132931	29132931	PRJNA609258_P_NODE_45629_length_267_cov_1.474227_g45244_i0	PRJNA609258	45629	267	1.474227	3.93618609	uncultured Granulicatella sp.	316089	Bacteria	Bacteria	80.1	8.54e-18	NR	WP_314076697.1	316089	g45244	i0	84.2	0.426966292134831	38	6	42.7	0	7	120	17	54	WP_314076697.1 hypothetical protein [uncultured Granulicatella sp.]	diamond	114	80.1	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	uncultured Granulicatella sp.
29164583	29164583	PRJNA609258_P_NODE_51289_length_251_cov_0.876404_g50904_i0	PRJNA609258	51289	251	0.876404	2.19977404	uncultured Corynebacterium sp.	159447	Bacteria	Bacteria	179	1.11e-51	NR	WP_288814857.1	159447	g50904	i0	98.8	0.99203187250996006	83	1	99.2	0	251	3	154	236	WP_288814857.1 alkaline phosphatase D family protein [uncultured Corynebacterium sp.]	diamond	249	179	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	uncultured Corynebacterium sp.
29606015	29606015	PRJNA609258_P_NODE_36570_length_305_cov_15.008621_g36185_i0	PRJNA609258	36570	305	15.008621	45.77629405	Veillonella sp.	1926307	Bacteria	Bacteria	159	2.3899999999999994e-48	NR	WP_366512514.1	1926307	g36185	i0	73.3	1.97704918032787	101	27	99.3	0	305	3	3	103	WP_366512514.1 hypothetical protein [Veillonella sp.]	diamond	603	159	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella sp.
29827294	29827294	PRJNA609258_P_NODE_50351_length_252_cov_0.871508_g49966_i0	PRJNA609258	50351	252	0.871508	2.19620016	Pseudoclavibacter sp.	1915061	Bacteria	Bacteria	96.7	2.8000000000000003e-23	NR	HHW50564.1	1915061	g49966	i0	100	0.535714285714286	45	0	53.6	0	3	137	100	144	HHW50564.1 threonine--tRNA ligase [Pseudoclavibacter sp.]	diamond	135	96.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudoclavibacter	Pseudoclavibacter sp.
30017079	30017079	PRJNA609258_P_NODE_48951_length_254_cov_1.292818_g48566_i0	PRJNA609258	48951	254	1.292818	3.28375772	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	78.2	1.43e-14	NR	KAF0227013.1	2049044	g48566	i0	48.8	20.6811023622047	82	41	95.7	1	249	7	278	359	KAF0227013.1 MAG: ATP-dependent Clp protease ATP-binding subunit [Erysipelotrichaceae bacterium]	diamond	5253	78.2	1	Bacteria		Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
30048370	30048370	PRJNA609258_P_NODE_50511_length_252_cov_0.871508_g50126_i0	PRJNA609258	50511	252	0.871508	2.19620016	Gracilibacillus sp. YIM 98692	2663532	Bacteria	Bacteria	41.2	0.0233	NR	WP_346427626.1	2663532	g50126	i0	42.6	0.642857142857143	54	29	64.3	1	228	67	18	69	WP_346427626.1 hypothetical protein [Gracilibacillus sp. YIM 98692]	diamond	162	41.2	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gracilibacillus	Gracilibacillus sp. YIM 98692
30079969	30079969	PRJNA609258_P_NODE_56152_length_246_cov_0.901734_g55767_i0	PRJNA609258	56152	246	0.901734	2.21826564	Mycolicibacter arupensis	342002	Bacteria	Bacteria	100	1.34e-22	NR	WP_273438504.1	342002	g55767	i0	100	0.536585365853659	44	0	53.7	0	2	133	392	435	WP_273438504.1 lipase family protein [Mycolicibacter arupensis]	diamond	132	100	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacter	Mycolicibacter arupensis
30333376	30333376	PRJNA609258_P_NODE_57512_length_245_cov_0.906977_g57127_i0	PRJNA609258	57512	245	0.906977	2.22209365	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	42.4	0.0465	NR	MCR4779334.1	1898203	g57127	i0	35	0.73469387755102	60	36	73.5	1	219	40	125	181	MCR4779334.1 6-phospho-beta-glucosidase [Lachnospiraceae bacterium]	diamond	180	42.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30396549	30396549	PRJNA609258_P_NODE_40513_length_288_cov_1.172093_g40128_i0	PRJNA609258	40513	288	1.172093	3.37562784	Microbacterium sp. ACRRU	2918204	Bacteria	Bacteria	158	2.3199999999999993e-43	NR	WP_239274785.1	2918204	g40128	i0	81.9	1.94791666666667	94	17	97.9	0	7	288	192	285	WP_239274785.1 DUF4012 domain-containing protein [Microbacterium sp. ACRRU]	diamond	561	158	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. ACRRU
30396556	30396556	PRJNA609258_P_NODE_55153_length_247_cov_0.896552_g54768_i0	PRJNA609258	55153	247	0.896552	2.21448344	Microbacterium sp. LCT-H2	1914306	Bacteria	Bacteria	135	3.38e-37	NR	WP_071330048.1	1914306	g54768	i0	100	0.789473684210526	65	0	78.9	0	53	247	1	65	WP_071330048.1 endonuclease/exonuclease/phosphatase family protein [Microbacterium sp. LCT-H2]	diamond	195	135	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. LCT-H2
30553904	30553904	PRJNA609258_P_NODE_56053_length_246_cov_0.901734_g55668_i0	PRJNA609258	56053	246	0.901734	2.21826564	Coriobacteriia bacterium	2052159	Bacteria	Bacteria	76.6	3.86e-14	NR	MCG2807668.1	2052159	g55668	i0	51.9	0.939024390243902	77	37	93.9	0	2	232	95	171	MCG2807668.1 hypothetical protein [Coriobacteriia bacterium]	diamond	231	76.6	1	Bacteria		Bacillati	Actinomycetota	Coriobacteriia				Coriobacteriia bacterium
30648605	30648605	PRJNA609258_P_NODE_32573_length_326_cov_1.233202_g32188_i0	PRJNA609258	32573	326	1.233202	4.02023852	Anabaenopsis elenkinii	156213	Bacteria	Bacteria	43.5	0.0476	NR	WP_200989542.1	156213	g32188	i0	32	0.690184049079755	75	45	66.3	3	35	250	252	323	WP_200989542.1 fatty acid desaturase [Anabaenopsis elenkinii]	diamond	225	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis elenkinii
31009501	31009501	PRJNA609258_P_NODE_54274_length_248_cov_0.891429_g53889_i0	PRJNA609258	54274	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	159	4.05e-48	NR	WP_316317407.1	28447	g53889	i0	100	1.98387096774194	82	0	99.2	0	1	246	12	93	WP_316317407.1 metallophosphoesterase, partial [Clavibacter michiganensis]	diamond	492	159	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis
31407481	31407481	PRJNA609258_P_NODE_56116_length_246_cov_0.901734_g55731_i0	PRJNA609258	56116	246	0.901734	2.21826564	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	159	3.87e-49	NR	WP_304136056.1	1528099	g55731	i0	98.7	0.951219512195122	78	1	95.1	0	235	2	1	78	WP_304136056.1 hypothetical protein [Lawsonella clevelandensis]	diamond	234	159	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31578743	31578743	PRJNA609258_P_NODE_51716_length_251_cov_0.876404_g51331_i0	PRJNA609258	51716	251	0.876404	2.19977404	Microbacterium	33882	Bacteria	Bacteria	166	1.48e-49	NR	WP_181373596.1	33882	g51331	i0	100	1.9840637450199201	83	0	99.2	0	250	2	148	230	WP_181373596.1 MULTISPECIES: PH domain-containing protein [Microbacterium]	diamond	498	166	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium
31705150	31705150	PRJNA609258_P_NODE_47257_length_260_cov_1.668449_g46872_i0	PRJNA609258	47257	260	1.668449	4.3379674	Bifidobacterium	1678	Bacteria	Bacteria	110	3.86e-26	NR	WP_003839434.1	1689	g46872	i0	68.2	4.05	88	26	99.2	1	3	260	8	95	WP_003839434.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [Bifidobacterium dentium]	diamond	1053	110	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium dentium
31723582	31723582	PRJNA609258_P_NODE_45637_length_267_cov_1.402062_g45252_i0	PRJNA609258	45637	267	1.402062	3.74350554	Mycobacterium sp. Root265	1736504	Bacteria	Bacteria	113	3.1e-27	NR	WP_162264179.1	1736504	g45252	i0	88.7	0.696629213483146	62	7	69.7	0	188	3	11	72	WP_162264179.1 PE-PPE domain-containing protein [Mycobacterium sp. Root265]	diamond	186	113	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. Root265
31976663	31976663	PRJNA609258_P_NODE_1978_length_1288_cov_9.093827_g1807_i0	PRJNA609258	1978	1288	9.093827	117.12849176	Brotonthovivens ammoniilytica	2981725	Bacteria	Bacteria	47	0.0218	NR	WP_158424257.1	2981725	g1807	i0	26.8	0.321428571428571	138	92	31.2	3	785	384	1	133	WP_158424257.1 hypothetical protein [Brotonthovivens ammoniilytica]	diamond	414	47	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Brotonthovivens	Brotonthovivens ammoniilytica
32071631	32071631	PRJNA609258_P_NODE_52198_length_250_cov_0.881356_g51813_i0	PRJNA609258	52198	250	0.881356	2.20339	Kocuria sp.	1871328	Bacteria	Bacteria	93.2	3.76e-20	NR	MDN5699594.1	1871328	g51813	i0	58.3	1.728	72	30	86.4	0	1	216	180	251	MDN5699594.1 DUF262 domain-containing protein [Kocuria sp.]	diamond	432	93.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria sp.
32609372	32609372	PRJNA609258_P_NODE_54620_length_248_cov_0.891429_g54235_i0	PRJNA609258	54620	248	0.891429	2.21074392	Pseudoclavibacter sp.	1915061	Bacteria	Bacteria	154	1.6999999999999998e-44	NR	HHW50931.1	1915061	g54235	i0	100	0.991935483870968	82	0	99.2	0	3	248	162	243	HHW50931.1 ABC transporter permease [Pseudoclavibacter sp.]	diamond	246	154	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudoclavibacter	Pseudoclavibacter 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);;