metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJNA846110" and tax

20 rows where analysis = "diamond", bioproject = "PRJNA846110" 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
2108595	2108595	PRJNA846110_P_NODE_30002_length_241_cov_0.916667_g29757_i0	PRJNA846110	30002	241	0.916667	2.20916747	Clostridium tunisiense	219748	Bacteria	Bacteria	155	1.23e-42	NR	WP_017416499.1	219748	g29757	i0	89.9	0.983402489626556	79	8	98.3	0	5	241	377	455	WP_017416499.1 glutamine--tRNA ligase/YqeY domain fusion protein [Clostridium tunisiense]	diamond	237	155	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium tunisiense
15259358	15259358	PRJNA846110_P_NODE_29712_length_241_cov_1.833333_g29467_i0	PRJNA846110	29712	241	1.833333	4.41833253	Atopostipes sp.	1872652	Bacteria	Bacteria	151	7.66e-44	NR	HZK23241.1	1872652	g29467	i0	100	0.995850622406639	80	0	99.6	0	240	1	140	219	HZK23241.1 50S ribosomal protein L1 [Atopostipes sp.]	diamond	240	151	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Atopostipes	Atopostipes sp.
26683204	26683204	PRJNA846110_P_NODE_15341_length_286_cov_1.107981_g15096_i0	PRJNA846110	15341	286	1.107981	3.16882566	Bacillati	1783272	Bacteria	Bacteria	59.7	1.5e-8	NR	WP_257141121.1	2033486	g15096	i0	52.9	1.65734265734266	51	23	52.4	1	153	4	21	71	WP_257141121.1 NUDIX hydrolase [Bacillus sp. AFS015802]	diamond	474	60.1	0.993344425956739	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. AFS015802
26833335	26833335	PRJNA846110_P_NODE_2901_length_610_cov_13.577281_g2664_i0	PRJNA846110	2901	610	13.577281	82.8214141	Staphylococcus aureus	1280	Bacteria	Bacteria	212	3.19e-64	NR	RBL73497.1	1280	g2664	i0	91.5	4.02786885245902	117	10	57.5	0	609	259	231	347	RBL73497.1 elongation factor 1-alpha, partial [Staphylococcus aureus]	diamond	2457	212	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27157676	27157676	PRJNA846110_P_NODE_25502_length_247_cov_0.885057_g25257_i0	PRJNA846110	25502	247	0.885057	2.18609079	Petroclostridium	2304687	Bacteria	Bacteria	146	5.49e-40	NR	HYF83686.1	2044939	g25257	i0	80.5	2.98785425101215	82	16	99.6	0	1	246	308	389	HYF83686.1 M14 family metallopeptidase [Clostridia bacterium]	diamond	738	146	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
27252722	27252722	PRJNA846110_P_NODE_21603_length_255_cov_1.483516_g21358_i0	PRJNA846110	21603	255	1.483516	3.7829658	Bacteria	2	Bacteria	Bacteria	55.1	1.06e-6	NR	WP_087363648.1	52242	g21358	i0	45	5.28235294117647	60	33	70.6	0	187	8	2	61	WP_087363648.1 LexA family protein [Lactobacillus gallinarum]	diamond	1347	55.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus gallinarum
27402499	27402499	PRJNA846110_P_NODE_21483_length_255_cov_3.807692_g21238_i0	PRJNA846110	21483	255	3.807692	9.7096146	Selenomonadaceae bacterium	2652289	Bacteria	Bacteria	42.7	0.0414	NR	MBP3723099.1	2652289	g21238	i0	38.1	0.494117647058824	42	26	49.4	0	5	130	316	357	MBP3723099.1 hypothetical protein [Selenomonadaceae bacterium]	diamond	126	42.7	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae		Selenomonadaceae bacterium
27623620	27623620	PRJNA846110_P_NODE_22644_length_251_cov_0.865169_g22399_i0	PRJNA846110	22644	251	0.865169	2.17157419	Fictibacillus gelatini	225985	Bacteria	Bacteria	73.2	3.38e-13	NR	WP_026678119.1	225985	g22399	i0	66	1.38645418326693	53	18	63.3	0	2	160	222	274	WP_026678119.1 pur operon repressor [Fictibacillus gelatini]	diamond	348	73.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Fictibacillaceae	Fictibacillus	Fictibacillus gelatini
28254788	28254788	PRJNA846110_P_NODE_12206_length_312_cov_0.974895_g11961_i0	PRJNA846110	12206	312	0.974895	3.0416724	Listeria monocytogenes	1639	Bacteria	Bacteria	150	4.06e-45	NR	WP_369698555.1	1639	g11961	i0	93.8	0.778846153846154	81	5	77.9	0	28	270	1	81	WP_369698555.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	243	150	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28822961	28822961	PRJNA846110_P_NODE_20768_length_259_cov_1.655914_g20523_i0	PRJNA846110	20768	259	1.655914	4.28881726	Ectobacillus antri	2486280	Bacteria	Bacteria	115	1.71e-29	NR	WP_124565785.1	2486280	g20523	i0	60	0.984555984555985	85	34	98.5	0	259	5	100	184	WP_124565785.1 hypothetical protein [Ectobacillus antri]	diamond	255	115	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Ectobacillus	Ectobacillus antri
29675393	29675393	PRJNA846110_P_NODE_29990_length_241_cov_0.916667_g29745_i0	PRJNA846110	29990	241	0.916667	2.20916747	Gracilibacillus kekensis	1027249	Bacteria	Bacteria	131	6.519999999999998e-35	NR	WP_073203111.1	1027249	g29745	i0	82.5	0.995850622406639	80	14	99.6	0	2	241	191	270	WP_073203111.1 GerAB/ArcD/ProY family transporter [Gracilibacillus kekensis]	diamond	240	131	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gracilibacillus	Gracilibacillus kekensis
30023352	30023352	PRJNA846110_P_NODE_26951_length_245_cov_0.895349_g26706_i0	PRJNA846110	26951	245	0.895349	2.19360505	Finegoldia magna	1260	Bacteria	Bacteria	49.7	6.87e-5	NR	WP_316057626.1	1260	g26706	i0	46.1	3.72244897959184	76	36	93.1	1	5	232	108	178	WP_316057626.1 terminase small subunit [Finegoldia magna]	diamond	912	49.7	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
30339614	30339614	PRJNA846110_P_NODE_24892_length_248_cov_0.880000_g24647_i0	PRJNA846110	24892	248	0.88	2.1824	Listeria monocytogenes	1639	Bacteria	Bacteria	154	1.1e-45	NR	WP_369698494.1	1639	g24647	i0	100	2.9758064516129	82	0	99.2	0	3	248	60	141	WP_369698494.1 RNA-directed DNA polymerase, partial [Listeria monocytogenes]	diamond	738	154	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
30844709	30844709	PRJNA846110_P_NODE_15934_length_283_cov_1.142857_g15689_i0	PRJNA846110	15934	283	1.142857	3.23428531	Sinobaca sp. H24	2923376	Bacteria	Bacteria	110	3.03e-27	NR	WP_252315335.1	2923376	g15689	i0	88.7	0.657243816254417	62	7	65.7	0	189	4	1	62	WP_252315335.1 ABC transporter ATP-binding protein [Sinobaca sp. H24]	diamond	186	110	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Sporolactobacillaceae	Sinobaca	Sinobaca sp. H24
31571921	31571921	PRJNA846110_P_NODE_30896_length_229_cov_2.006410_g30651_i0	PRJNA846110	30896	229	2.00641	4.5946789	Marinococcus halophilus	1371	Bacteria	Bacteria	80.9	7.35e-16	NR	WP_094908010.1	1371	g30651	i0	97.5	0.524017467248908	40	1	52.4	0	121	2	1	40	WP_094908010.1 3-phosphoserine/phosphohydroxythreonine transaminase [Marinococcus halophilus]	diamond	120	80.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Marinococcus	Marinococcus halophilus
31887942	31887942	PRJNA846110_P_NODE_28357_length_243_cov_1.029412_g28112_i0	PRJNA846110	28357	243	1.029412	2.50147116	Listeria monocytogenes	1639	Bacteria	Bacteria	117	3.19e-32	NR	WP_369697278.1	1639	g28112	i0	93.7	0.777777777777778	63	4	77.8	0	3	191	47	109	WP_369697278.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	189	117	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
32204487	32204487	PRJNA846110_P_NODE_24418_length_249_cov_0.875000_g24173_i0	PRJNA846110	24418	249	0.875	2.17875	Gemella sanguinis	84135	Bacteria	Bacteria	144	8.05e-40	NR	WP_371488334.1	84135	g24173	i0	86.4	2.95180722891566	81	11	97.6	0	6	248	212	292	WP_371488334.1 glycosyltransferase family 52 [Gemella sanguinis]	diamond	735	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella sanguinis
32425996	32425996	PRJNA846110_P_NODE_19499_length_265_cov_2.307292_g19254_i0	PRJNA846110	19499	265	2.307292	6.1143238	Bacilli bacterium	1903720	Bacteria	Bacteria	83.6	2.17e-18	NR	MEG0407242.1	1903720	g19254	i0	100	0.452830188679245	40	0	45.3	0	146	265	1	40	MEG0407242.1 hypothetical protein [Bacilli bacterium]	diamond	120	83.6	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
32457730	32457730	PRJNA846110_P_NODE_16919_length_278_cov_1.463415_g16674_i0	PRJNA846110	16919	278	1.463415	4.0682937	Listeria monocytogenes	1639	Bacteria	Bacteria	60.1	1e-9	NR	WP_369698293.1	1639	g16674	i0	96.8	0.334532374100719	31	1	33.5	0	2	94	34	64	WP_369698293.1 hypothetical protein [Listeria monocytogenes]	diamond	93	60.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
32615540	32615540	PRJNA846110_P_NODE_19420_length_266_cov_1.331606_g19175_i0	PRJNA846110	19420	266	1.331606	3.54207196	Anoxybacteroides voinovskiense	230470	Bacteria	Bacteria	137	5.44e-39	NR	WP_183186044.1	230470	g19175	i0	87.2	0.879699248120301	78	10	88	0	266	33	86	163	WP_183186044.1 tRNA adenosine(34) deaminase TadA [Anoxybacteroides voinovskiense]	diamond	234	137	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacteroides	Anoxybacteroides voinovskiense

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