metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA541476" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA541476" 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
509179	509179	PRJNA541476_P_NODE_38081_length_243_cov_1.988235_g37875_i0	PRJNA541476	38081	243	1.988235	4.83141105	Bacteria	2	Bacteria	Bacteria	63.5	1.74e-9	NR	MBR2676149.1	2060878	g37875	i0	55.7	4.2962962962963	61	20	75.3	1	225	43	387	440	MBR2676149.1 response regulator [Solobacterium sp.]	diamond	1044	63.9	0.993740219092332	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Solobacterium	Solobacterium sp.
16421361	16421361	PRJNA541476_P_NODE_9593_length_367_cov_5.085034_g9387_i0	PRJNA541476	9593	367	5.085034	18.66207478	Metabacillus sp.	2675275	Bacteria	Bacteria	122	8.16e-34	NR	HZH60916.1	2675275	g9387	i0	78.3	0.678474114441417	83	18	67.8	0	118	366	1	83	HZH60916.1 ATP synthase subunit C family protein [Metabacillus sp.]	diamond	249	122	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus sp.
26602846	26602846	PRJNA541476_P_NODE_4361_length_548_cov_4.985263_g4165_i0	PRJNA541476	4361	548	4.985263	27.31924124	Bacilli bacterium	1903720	Bacteria	Bacteria	48.1	0.00179	NR	MDY0118353.1	1903720	g4165	i0	31.5	0.39963503649635	73	48	39.4	2	449	234	41	112	MDY0118353.1 hypothetical protein [Bacilli bacterium]	diamond	219	48.1	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
26697914	26697914	PRJNA541476_P_NODE_41101_length_235_cov_2.549383_g40895_i0	PRJNA541476	41101	235	2.549383	5.99105005	Acidaminococcaceae bacterium	2049052	Bacteria	Bacteria	42.7	0.0322	NR	MBQ9284252.1	2049052	g40895	i0	37.5	1.22553191489362	48	29	60	1	201	61	48	95	MBQ9284252.1 IS30 family transposase [Acidaminococcaceae bacterium]	diamond	288	42.7	1	Bacteria	Bacillati	Bacillota	Negativicutes	Acidaminococcales	Acidaminococcaceae		Acidaminococcaceae bacterium
26761261	26761261	PRJNA541476_P_NODE_29161_length_252_cov_0.865922_g28955_i0	PRJNA541476	29161	252	0.865922	2.18212344	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	72	6.8e-13	NR	RKW58770.1	1898203	g28955	i0	97.2	0.428571428571429	36	1	42.9	0	109	2	1	36	RKW58770.1 MAG: M48 family peptidase [Lachnospiraceae bacterium]	diamond	108	72	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
27172490	27172490	PRJNA541476_P_NODE_27722_length_254_cov_1.508287_g27516_i0	PRJNA541476	27722	254	1.508287	3.83104898	Planococcus	1372	Bacteria	Bacteria	54.3	3.45e-6	NR	WP_082707498.1	1372	g27516	i0	44.8	3.36614173228346	58	32	68.5	0	61	234	163	220	WP_082707498.1 MULTISPECIES: PLP-dependent aminotransferase family protein [Planococcus]	diamond	855	54.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus
27804591	27804591	PRJNA541476_P_NODE_41644_length_229_cov_3.153846_g41438_i0	PRJNA541476	41644	229	3.153846	7.22230734	Peptostreptococcaceae bacterium AGR-M142	3133363	Bacteria	Bacteria	44.7	0.00679	NR	WXR62754.1	3133363	g41438	i0	38.6	1.65065502183406	70	43	91.7	0	7	216	499	568	WXR62754.1 cadherin-like beta sandwich domain-containing protein [Peptostreptococcaceae bacterium AGR-M142]	diamond	378	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae		Peptostreptococcaceae bacterium AGR-M142
27930711	27930711	PRJNA541476_P_NODE_21505_length_276_cov_1.177340_g21299_i0	PRJNA541476	21505	276	1.17734	3.2494584	Virgibacillus phasianinus	2017483	Bacteria	Bacteria	50.1	1.26e-4	NR	WP_089061277.1	2017483	g21299	i0	33.8	0.706521739130435	65	40	70.7	1	80	274	144	205	WP_089061277.1 GNAT family N-acetyltransferase [Virgibacillus phasianinus]	diamond	195	50.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus phasianinus
28071769	28071769	PRJNA541476_P_NODE_24385_length_265_cov_1.510417_g24179_i0	PRJNA541476	24385	265	1.510417	4.00260505	Clostridia	186801	Bacteria	Bacteria	70.5	6.21e-12	NR	WP_103083235.1	84032	g24179	i0	45.6	3.79245283018868	68	35	74.7	1	1	198	164	231	WP_103083235.1 glycoside hydrolase family 5 protein [Clostridium thermosuccinogenes]	diamond	1005	71.2	0.990168539325843	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium thermosuccinogenes
28372660	28372660	PRJNA541476_P_NODE_2906_length_687_cov_3.890879_g2715_i0	PRJNA541476	2906	687	3.890879	26.73033873	Paenibacillus agilis	3020863	Bacteria	Bacteria	77.4	2.77e-12	NR	WP_186786209.1	3020863	g2715	i0	40.7	1.21834061135371	140	69	61.1	4	266	685	871	996	WP_186786209.1 cadherin-like beta sandwich domain-containing protein [Paenibacillus agilis]	diamond	837	77.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus agilis
28435988	28435988	PRJNA541476_P_NODE_40546_length_241_cov_2.654762_g40340_i0	PRJNA541476	40546	241	2.654762	6.39797642	Halanaerobium sp. DL-	1895664	Bacteria	Bacteria	77.4	1.87e-14	NR	WP_114474350.1	1653064	g40340	i0	58.3	5.01659751037344	60	25	74.7	0	61	240	39	98	WP_114474350.1 peptide-methionine (R)-S-oxide reductase MsrB [Halanaerobium sp. DL-01]	diamond	1209	77.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium sp. DL-01
28450915	28450915	PRJNA541476_P_NODE_11706_length_339_cov_1.763158_g11500_i0	PRJNA541476	11706	339	1.763158	5.97710562	Haloimpatiens	1755832	Bacteria	Bacteria	76.3	2.06e-13	NR	WP_138205802.1	1380675	g11500	i0	39.8	5.09734513274336	93	56	82.3	0	294	16	561	653	WP_138205802.1 DsrE/DsrF/DrsH-like family protein [Haloimpatiens lingqiaonensis]	diamond	1728	76.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Haloimpatiens	Haloimpatiens lingqiaonensis
28671901	28671901	PRJNA541476_P_NODE_28887_length_252_cov_0.871508_g28681_i0	PRJNA541476	28887	252	0.871508	2.19620016	Halanaerobium	2330	Bacteria	Bacteria	105	2.51e-24	NR	WP_005486959.1	43595	g28681	i0	78.1	3.80952380952381	64	14	76.2	0	193	2	184	247	WP_005486959.1 Tex family protein [Halanaerobium saccharolyticum]	diamond	960	106	0.990566037735849	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium saccharolyticum
29871680	29871680	PRJNA541476_P_NODE_29311_length_251_cov_2.235955_g29105_i0	PRJNA541476	29311	251	2.235955	5.61224705	Bacillota	1239	Bacteria	Bacteria	79.3	4.98e-15	NR	MDO5018305.1	1689303	g29105	i0	68.6	9.2390438247012	51	16	61	0	1	153	410	460	MDO5018305.1 glycine--tRNA ligase [Lagierella massiliensis]	diamond	2319	80.1	0.990012484394507	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Lagierella	Lagierella massiliensis
29983111	29983111	PRJNA541476_P_NODE_34271_length_247_cov_0.885057_g34065_i0	PRJNA541476	34271	247	0.885057	2.18609079	Halocella sp. SP3-1	2382161	Bacteria	Bacteria	78.6	5.5e-15	NR	WP_125990340.1	2382161	g34065	i0	45.9	0.898785425101215	74	40	89.9	0	2	223	263	336	WP_125990340.1 hypothetical protein [Halocella sp. SP3-1]	diamond	222	78.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halocella	Halocella sp. SP3-1
30425876	30425876	PRJNA541476_P_NODE_7533_length_413_cov_0.941176_g7329_i0	PRJNA541476	7533	413	0.941176	3.88705688	Mammaliicoccus sciuri	1296	Bacteria	Bacteria	129	5.11e-36	NR	MCH5142011.1	1296	g7329	i0	70.4	0.588377723970944	81	24	58.8	0	410	168	2	82	MCH5142011.1 hypothetical protein [Mammaliicoccus sciuri]	diamond	243	129	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus sciuri
30709696	30709696	PRJNA541476_P_NODE_27354_length_255_cov_1.653846_g27148_i0	PRJNA541476	27354	255	1.653846	4.2173073	Eubacterium ramulus	39490	Bacteria	Bacteria	41.6	0.0238	NR	WP_336302767.1	39490	g27148	i0	41.9	0.505882352941176	43	25	50.6	0	242	114	4	46	WP_336302767.1 hypothetical protein [Eubacterium ramulus]	diamond	129	41.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium ramulus
30773115	30773115	PRJNA541476_P_NODE_20234_length_281_cov_1.437500_g20028_i0	PRJNA541476	20234	281	1.4375	4.039375	Neobacillus niacini	86668	Bacteria	Bacteria	61.6	1.28e-8	NR	WP_335435396.1	86668	g20028	i0	42.9	1.81494661921708	91	51	97.2	1	273	1	222	311	WP_335435396.1 flagellin [Neobacillus niacini]	diamond	510	61.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus niacini
31057699	31057699	PRJNA541476_P_NODE_37435_length_244_cov_0.912281_g37229_i0	PRJNA541476	37435	244	0.912281	2.22596564	Enterococcus faecalis	1351	Bacteria	Bacteria	152	1.0499999999999999e-40	NR	WP_263698349.1	1351	g37229	i0	95.1	0.995901639344262	81	4	99.6	0	244	2	251	331	WP_263698349.1 type 2 lanthipeptide synthetase LanM [Enterococcus faecalis]	diamond	243	152	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
31198165	31198165	PRJNA541476_P_NODE_13235_length_324_cov_1.235060_g13029_i0	PRJNA541476	13235	324	1.23506	4.0015944	Bacillati	1783272	Bacteria	Bacteria	97.8	5.36e-22	NR	NPV28270.1	1879010	g13029	i0	49.1	7.66666666666667	106	48	98.1	2	5	322	82	181	NPV28270.1 4-hydroxy-tetrahydrodipicolinate synthase [Bacillota bacterium]	diamond	2484	98.2	0.995926680244399	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31293388	31293388	PRJNA541476_P_NODE_25455_length_261_cov_1.867021_g25249_i0	PRJNA541476	25455	261	1.867021	4.87292481	root	1	Root_unresolved	Root_unresolved	43.9	0.00206	NR	WP_416083710.1	1352	g25249	i0	38.6	1.26436781609195	70	24	58.6	1	215	63	1	70	WP_416083710.1 hypothetical protein, partial [Enterococcus faecium]	diamond	330	44.3	0.99097065462754	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
31373603	31373603	PRJNA541476_P_NODE_18296_length_290_cov_1.423963_g18090_i0	PRJNA541476	18296	290	1.423963	4.1294927	Candidatus Merdisoma sp. JLR.KK	3101169	Bacteria	Bacteria	43.9	0.0253	NR	WP_334337558.1	3114299	g18090	i0	40.4	0.537931034482759	52	31	53.8	0	275	120	361	412	WP_334337558.1 hypothetical protein [Candidatus Merdisoma sp. JLR.KK011]	diamond	156	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Candidatus Merdisoma	Candidatus Merdisoma sp. JLR.KK011
31405262	31405262	PRJNA541476_P_NODE_5956_length_464_cov_1.534527_g5753_i0	PRJNA541476	5956	464	1.534527	7.12020528	Paenibacillus sp. MMO-177	3081289	Bacteria	Bacteria	113	6.57e-26	NR	WP_336788583.1	3081289	g5753	i0	41.8	1.88793103448276	146	78	93.8	3	436	2	117	256	WP_336788583.1 GMC family oxidoreductase [Paenibacillus sp. MMO-177]	diamond	876	113	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. MMO-177
31641263	31641263	PRJNA541476_P_NODE_28796_length_252_cov_0.871508_g28590_i0	PRJNA541476	28796	252	0.871508	2.19620016	Bacillota	1239	Bacteria	Bacteria	79	7.71e-15	NR	WP_218653432.1	82348	g28590	i0	52.6	6.80952380952381	78	34	92.9	1	249	16	161	235	WP_218653432.1 cation-translocating P-type ATPase [Streptococcus pluranimalium]	diamond	1716	79.7	0.991217063989962	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pluranimalium
31879354	31879354	PRJNA541476_P_NODE_22737_length_271_cov_1.363636_g22531_i0	PRJNA541476	22737	271	1.363636	3.69545356	Bacillota bacterium	1879010	Bacteria	Bacteria	44.3	0.0148	NR	MBQ7016389.1	1879010	g22531	i0	33.7	0.918819188191882	83	51	91.9	2	264	16	298	376	MBQ7016389.1 DUF3472 domain-containing protein [Bacillota bacterium]	diamond	249	44.3	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31926010	31926010	PRJNA541476_P_NODE_10917_length_348_cov_2.010909_g10711_i0	PRJNA541476	10917	348	2.010909	6.99796332	Bacteria	2	Bacteria	Bacteria	131	2.29e-34	NR	HLU11181.1	1871622	g10711	i0	50.9	7.94827586206897	116	55	100	2	348	1	11	124	HLU11181.1 hypothetical protein [Oceanobacillus sp.]	diamond	2766	131	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus sp.
32210901	32210901	PRJNA541476_P_NODE_618_length_1418_cov_3.846840_g526_i0	PRJNA541476	618	1418	3.84684	54.5481912	PVC group	1783257	Bacteria	Bacteria	72	4.15e-9	NR	WP_218229321.1	79263	g526	i0	28.3	2.86459802538787	350	195	72.4	15	1401	376	406	706	WP_218229321.1 cadherin-like beta sandwich domain-containing protein [Paenibacillus chitinolyticus]	diamond	4062	72	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus chitinolyticus

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