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

18 rows where analysis = "diamond", bioproject = "PRJNA664479" 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
26669676	26669676	PRJNA664479_S_NODE_6081_length_221_cov_1.511628_g6005_i0	PRJNA664479	6081	221	1.511628	3.34069788	Bacillus thuringiensis	1428	Bacteria	Bacteria	80.9	5.33e-18	NR	WP_144557273.1	1428	g6005	i0	56.2	0.990950226244344	73	31	99.1	1	220	2	16	87	WP_144557273.1 Hsp70 family protein, partial [Bacillus thuringiensis]	diamond	219	80.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
27061952	27061952	PRJNA664479_S_NODE_3422_length_276_cov_1.140969_g3346_i0	PRJNA664479	3422	276	1.140969	3.14907444	root	1	Root_unresolved	Root_unresolved	71.2	3.09e-13	NR	PWS23037.1	1352	g3346	i0	60.8	112.75	74	29	80.4	0	258	37	5	78	PWS23037.1 glyceraldehyde-3-phosphate dehydrogenase, partial [Enterococcus faecium]	diamond	31119	71.6	0.994413407821229	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
27144262	27144262	PRJNA664479_S_NODE_17522_length_163_cov_0.894737_g17446_i0	PRJNA664479	17522	163	0.894737	1.45842131	Anaerococcus vaginimassiliensis	2042308	Bacteria	Bacteria	64.3	2.85e-10	NR	WP_130818893.1	2042308	g17446	i0	100	1.71165644171779	31	0	57.1	0	163	71	329	359	WP_130818893.1 ABC transporter substrate-binding protein [Anaerococcus vaginimassiliensis]	diamond	279	64.3	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginimassiliensis
28881435	28881435	PRJNA664479_S_NODE_8448_length_199_cov_0.693333_g8372_i0	PRJNA664479	8448	199	0.693333	1.37973267	uncultured Faecalicoccus sp.	1971760	Bacteria	Bacteria	42	0.0348	NR	WP_296241666.1	1971760	g8372	i0	37.7	0.798994974874372	53	30	79.9	1	18	176	101	150	WP_296241666.1 TIGR01906 family membrane protein [uncultured Faecalicoccus sp.]	diamond	159	42	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Faecalicoccus	uncultured Faecalicoccus sp.
29134326	29134326	PRJNA664479_S_NODE_15469_length_165_cov_2.422414_g15393_i0	PRJNA664479	15469	165	2.422414	3.9969831	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	44.7	4.83e-4	NR	WP_252130143.1	1590	g15393	i0	90.5	2.29090909090909	21	2	38.2	0	164	102	69	89	WP_252130143.1 hypothetical protein, partial [Lactiplantibacillus plantarum]	diamond	378	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
29607326	29607326	PRJNA664479_S_NODE_14470_length_167_cov_0.864407_g14394_i0	PRJNA664479	14470	167	0.864407	1.44355969	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	102	5.840000000000001e-26	NR	MDO5702419.1	1898203	g14394	i0	87.3	1.97604790419162	55	7	98.8	0	3	167	15	69	MDO5702419.1 4Fe-4S dicluster domain-containing protein [Lachnospiraceae bacterium]	diamond	330	102	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30124975	30124975	PRJNA664479_S_NODE_15012_length_166_cov_0.871795_g14936_i0	PRJNA664479	15012	166	0.871795	1.4471797	Bacillota	1239	Bacteria	Bacteria	113	2e-27	NR	MCR0437470.1	1522	g14936	i0	100	17.566265060241	54	0	97.6	0	164	3	1335	1388	MCR0437470.1 N-6 DNA methylase [[Clostridium] innocuum]	diamond	2916	113	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum
30176140	30176140	PRJNA664479_S_NODE_292_length_826_cov_49.060489_g239_i0	PRJNA664479	292	826	49.060489	405.23963914	Staphylococcus aureus	1280	Bacteria	Bacteria	57	1.06e-6	NR	MFG1518840.1	1280	g239	i0	41	0.301452784503632	83	49	30.1	0	250	2	1	83	MFG1518840.1 hypothetical protein [Staphylococcus aureus]	diamond	249	57	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30239444	30239444	PRJNA664479_S_NODE_412_length_698_cov_1.922958_g351_i0	PRJNA664479	412	698	1.922958	13.42224684	Staphylococcus warneri	1292	Bacteria	Bacteria	62	1.05e-8	NR	WP_391543843.1	1292	g351	i0	58.5	0.279369627507163	65	22	27.9	3	676	482	29	88	WP_391543843.1 cold shock domain-containing protein [Staphylococcus warneri]	diamond	195	62	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
30271312	30271312	PRJNA664479_S_NODE_15712_length_165_cov_0.879310_g15636_i0	PRJNA664479	15712	165	0.87931	1.4508615	Clostridia bacterium	2044939	Bacteria	Bacteria	63.9	1.02e-10	NR	HWR36841.1	2044939	g15636	i0	62.3	0.963636363636364	53	19	94.5	1	157	2	1	53	HWR36841.1 hypothetical protein [Clostridia bacterium]	diamond	159	63.9	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30303102	30303102	PRJNA664479_S_NODE_15192_length_166_cov_0.871795_g15116_i0	PRJNA664479	15192	166	0.871795	1.4471797	Staphylococcus epidermidis	1282	Bacteria	Bacteria	57.4	5.57e-9	NR	WP_186306285.1	1282	g15116	i0	55.4	1.01204819277108	56	19	90.4	1	166	17	34	89	WP_186306285.1 PLP-dependent transferase, partial [Staphylococcus epidermidis]	diamond	168	57.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
30681550	30681550	PRJNA664479_S_NODE_3733_length_266_cov_3.635945_g3657_i0	PRJNA664479	3733	266	3.635945	9.6716137	Anaerotignum faecicola	2358141	Bacteria	Bacteria	45.1	0.00642	NR	WP_337759023.1	2358141	g3657	i0	44.7	0.857142857142857	38	21	42.9	0	80	193	112	149	WP_337759023.1 hypothetical protein, partial [Anaerotignum faecicola]	diamond	228	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Anaerotignaceae	Anaerotignum	Anaerotignum faecicola
30713349	30713349	PRJNA664479_S_NODE_14974_length_166_cov_1.068376_g14898_i0	PRJNA664479	14974	166	1.068376	1.77350416	Lactiplantibacillus sp. E932	2952565	Bacteria	Bacteria	62.8	9.69e-11	NR	MCM8651624.1	2952565	g14898	i0	73.9	1.66265060240964	46	12	83.1	0	1	138	82	127	MCM8651624.1 hypothetical protein [Lactiplantibacillus sp. E932]	diamond	276	63.2	0.993670886075949	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus sp. E932
31345516	31345516	PRJNA664479_S_NODE_1776_length_365_cov_9.000000_g1700_i0	PRJNA664479	1776	365	9	32.85	Lactiplantibacillus sp. E932	2952565	Bacteria	Bacteria	52.4	2.54e-6	NR	MCM8651719.1	2952565	g1700	i0	50	0.476712328767123	58	29	47.7	0	106	279	5	62	MCM8651719.1 hypothetical protein [Lactiplantibacillus sp. E932]	diamond	174	52.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus sp. E932
31377207	31377207	PRJNA664479_S_NODE_3896_length_262_cov_1.802817_g3820_i0	PRJNA664479	3896	262	1.802817	4.72338054	Staphylococcus epidermidis	1282	Bacteria	Bacteria	41.2	0.0209	NR	WP_222121761.1	1282	g3820	i0	60.6	0.377862595419847	33	13	37.8	0	135	233	33	65	WP_222121761.1 hypothetical protein, partial [Staphylococcus epidermidis]	diamond	99	41.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
31440219	31440219	PRJNA664479_S_NODE_1856_length_359_cov_8.832258_g1780_i0	PRJNA664479	1856	359	8.832258	31.70780622	Lactiplantibacillus sp. E932	2952565	Bacteria	Bacteria	48.5	7.53e-5	NR	MCM8651719.1	2952565	g1780	i0	36.5	0.526462395543176	63	40	52.6	0	94	282	1	63	MCM8651719.1 hypothetical protein [Lactiplantibacillus sp. E932]	diamond	189	48.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus sp. E932
32085074	32085074	PRJNA664479_S_NODE_8958_length_195_cov_0.712329_g8882_i0	PRJNA664479	8958	195	0.712329	1.38904155	root	1	Root_unresolved	Root_unresolved	64.7	6.31e-12	NR	WP_261658001.1	1351	g8882	i0	74.5	24.5692307692308	47	12	72.3	0	55	195	9	55	WP_261658001.1 tropomyosin, partial [Enterococcus faecalis]	diamond	4791	65.1	0.993855606758833	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
32168127	32168127	PRJNA664479_S_NODE_1798_length_364_cov_3.888889_g1722_i0	PRJNA664479	1798	364	3.888889	14.15555596	Bacillus pumilus	1408	Bacteria	Bacteria	68.6	1.44e-12	NR	WP_144558297.1	1408	g1722	i0	60.9	0.527472527472527	64	21	52.7	1	173	364	12	71	WP_144558297.1 Hsp70 family protein, partial [Bacillus pumilus]	diamond	192	68.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus pumilus

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