metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA793147" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA793147" 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
12257198	12257198	PRJNA793147_P_NODE_27830_length_316_cov_1.165992_g27564_i0	PRJNA793147	27830	316	1.165992	3.68453472	Clostridioides difficile	1496	Bacteria	Bacteria	176	8.61e-54	NR	WP_236885984.1	1496	g27564	i0	79.6	0.977848101265823	103	21	97.8	0	309	1	25	127	WP_236885984.1 condensation domain-containing protein, partial [Clostridioides difficile]	diamond	309	176	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
13969689	13969689	PRJNA793147_P_NODE_13171_length_471_cov_6.512438_g12905_i0	PRJNA793147	13171	471	6.512438	30.67358298	Staphylococcus aureus	1280	Bacteria	Bacteria	219	5.27e-71	NR	MBO8589692.1	1280	g12905	i0	94.1	0.751592356687898	118	7	75.2	0	442	89	1	118	MBO8589692.1 non-specific lipid-transfer protein [Staphylococcus aureus]	diamond	354	219	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
22455136	22455136	PRJNA793147_P_NODE_42238_length_259_cov_2.205263_g41972_i0	PRJNA793147	42238	259	2.205263	5.71163117	Bacteria	2	Bacteria	Bacteria	182	3.3499999999999997e-57	NR	MFP3454109.1	3080859	g41972	i0	100	6.97297297297297	86	0	99.6	0	258	1	37	122	MFP3454109.1 hypothetical protein [Bacillus sp. SIMBA_154]	diamond	1806	182	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. SIMBA_154
26895789	26895789	PRJNA793147_P_NODE_13141_length_472_cov_1.856079_g12875_i0	PRJNA793147	13141	472	1.856079	8.76069288	Ruminococcus sp.	41978	Bacteria	Bacteria	54.3	3.62e-5	NR	WP_295116239.1	41978	g12875	i0	30.5	2.08474576271186	105	69	64.2	2	5	307	284	388	WP_295116239.1 serpin family protein [Ruminococcus sp.]	diamond	984	54.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
27347610	27347610	PRJNA793147_P_NODE_38763_length_270_cov_1.432836_g38497_i0	PRJNA793147	38763	270	1.432836	3.8686572	Bacillota	1239	Bacteria	Bacteria	111	4.7e-27	NR	WP_335488428.1	86668	g38497	i0	60.4	26.4888888888889	91	35	100	1	270	1	203	293	WP_335488428.1 UDP-glucose 4-epimerase GalE [Neobacillus niacini]	diamond	7152	112	0.991071428571429	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus niacini
27622630	27622630	PRJNA793147_P_NODE_16484_length_415_cov_1.997110_g16218_i0	PRJNA793147	16484	415	1.99711	8.2880065	Virgibacillus proomii	84407	Bacteria	Bacteria	85.9	6.28e-17	NR	WP_245799828.1	84407	g16218	i0	43.8	1.61204819277108	105	51	71.6	3	302	6	209	311	WP_245799828.1 lytic polysaccharide monooxygenase [Virgibacillus proomii]	diamond	669	85.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus proomii
28064479	28064479	PRJNA793147_P_NODE_41905_length_260_cov_2.261780_g41639_i0	PRJNA793147	41905	260	2.26178	5.880628	Ruminococcus sp.	41978	Bacteria	Bacteria	41.6	0.0311	NR	MCI5793590.1	41978	g41639	i0	37.7	0.611538461538462	53	33	61.2	0	87	245	32	84	MCI5793590.1 thioredoxin [Ruminococcus sp.]	diamond	159	41.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
28475021	28475021	PRJNA793147_P_NODE_63566_length_212_cov_2.013986_g63300_i0	PRJNA793147	63566	212	2.013986	4.26965032	Clostridia bacterium	2044939	Bacteria	Bacteria	95.5	6.5700000000000005e-21	NR	MEG2569817.1	2044939	g63300	i0	58	1.95283018867925	69	29	97.6	0	6	212	285	353	MEG2569817.1 host specificity factor TipJ family phage tail protein [Clostridia bacterium]	diamond	414	95.5	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28538360	28538360	PRJNA793147_P_NODE_6447_length_707_cov_10.304075_g6194_i0	PRJNA793147	6447	707	10.304075	72.84981025	Clostridia bacterium	2044939	Bacteria	Bacteria	54.3	2.09e-4	NR	MCX7920512.1	2044939	g6194	i0	29.9	2.11315417256011	167	110	69.6	4	618	127	349	511	MCX7920512.1 fibronectin type III domain-containing protein [Clostridia bacterium]	diamond	1494	54.3	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28799646	28799646	PRJNA793147_P_NODE_61527_length_226_cov_1.471338_g61261_i0	PRJNA793147	61527	226	1.471338	3.32522388	Bacteria	2	Bacteria	Bacteria	54.3	4.34e-7	NR	WP_043735078.1	1359	g61261	i0	57.4	1.8716814159292	47	18	62.4	1	225	85	81	125	WP_043735078.1 cytidine deaminase [Lactococcus cremoris]	diamond	423	54.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
29927610	29927610	PRJNA793147_P_NODE_40871_length_264_cov_0.846154_g40605_i0	PRJNA793147	40871	264	0.846154	2.23384656	Staphylococcus aureus	1280	Bacteria	Bacteria	104	3.4300000000000005e-27	NR	MBO8584250.1	1280	g40605	i0	89.7	0.659090909090909	58	6	65.9	0	89	262	3	60	MBO8584250.1 hypothetical protein [Staphylococcus aureus]	diamond	174	104	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30053633	30053633	PRJNA793147_P_NODE_39891_length_266_cov_5.796954_g39625_i0	PRJNA793147	39891	266	5.796954	15.41989764	Clostridia bacterium	2044939	Bacteria	Bacteria	55.8	1.16e-6	NR	MBQ3524161.1	2044939	g39625	i0	31.2	6.15789473684211	93	57	97	2	3	260	364	456	MBQ3524161.1 glycoside hydrolase family 18 protein [Clostridia bacterium]	diamond	1638	55.8	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30148370	30148370	PRJNA793147_P_NODE_29792_length_306_cov_1.489451_g29526_i0	PRJNA793147	29792	306	1.489451	4.55772006	Staphylococcus aureus	1280	Bacteria	Bacteria	160	8.52e-49	NR	MBO8589692.1	1280	g29526	i0	92.4	0.901960784313726	92	7	90.2	0	277	2	1	92	MBO8589692.1 non-specific lipid-transfer protein [Staphylococcus aureus]	diamond	276	160	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30316251	30316251	PRJNA793147_P_NODE_30352_length_303_cov_3.679487_g30086_i0	PRJNA793147	30352	303	3.679487	11.14884561	root	1	Root_unresolved	Root_unresolved	106	4.3500000000000006e-27	NR	WP_015358673.1	1510	g30086	i0	63	11.6138613861386	73	27	72.3	0	223	5	4	76	WP_015358673.1 glycine cleavage system protein GcvH [Thermoclostridium stercorarium]	diamond	3519	107	0.990654205607477	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Thermoclostridium	Thermoclostridium stercorarium
30496258	30496258	PRJNA793147_P_NODE_18193_length_392_cov_5.597523_g17927_i0	PRJNA793147	18193	392	5.597523	21.94229016	Eubacteriales bacterium	2831996	Bacteria	Bacteria	45.4	0.0198	NR	MDD4564346.1	2831996	g17927	i0	26.8	0.971938775510204	127	88	94.1	3	18	386	129	254	MDD4564346.1 glycosyl hydrolase family 18 protein [Eubacteriales bacterium]	diamond	381	45.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
31950257	31950257	PRJNA793147_P_NODE_56117_length_231_cov_0.888889_g55851_i0	PRJNA793147	56117	231	0.888889	2.05333359	Moryella indoligenes	371674	Bacteria	Bacteria	150	6.68e-42	NR	WP_106611457.1	371674	g55851	i0	100	2	77	0	100	0	1	231	125	201	WP_106611457.1 hypothetical protein [Moryella indoligenes]	diamond	462	150	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Moryella	Moryella indoligenes
32866398	32866398	PRJNA793147_P_NODE_47820_length_243_cov_1.626437_g47554_i0	PRJNA793147	47820	243	1.626437	3.95224191	Bacillota bacterium	1879010	Bacteria	Bacteria	55.5	1.17e-6	NR	NPV80201.1	1879010	g47554	i0	35	0.987654320987654	80	48	98.8	1	242	3	179	254	NPV80201.1 serpin family protein [Bacillota bacterium]	diamond	240	55.5	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
32906993	32906993	PRJNA793147_P_NODE_35320_length_283_cov_1.336449_g35054_i0	PRJNA793147	35320	283	1.336449	3.78215067	root	1	Root_unresolved	Root_unresolved	45.4	0.0038	NR	HCW04896.1	1506	g35054	i0	35.3	6.48763250883392	85	50	89	2	253	2	91	171	HCW04896.1 protein kinase [Clostridium sp.]	diamond	1836	45.8	0.991266375545852	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);;