metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA169559" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA169559" 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
4882798	4882798	PRJNA169559_P_NODE_48604_length_156_cov_1.913386_g46527_i0	PRJNA169559	48604	156	1.913386	2.98488216	Parvimonas micra	33033	Bacteria	Bacteria	113	2.19e-31	NR	WP_410522833.1	33033	g46527	i0	98.1	1	52	1	100	0	156	1	21	72	WP_410522833.1 gamma carbonic anhydrase family protein, partial [Parvimonas micra]	diamond	156	113	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
27010522	27010522	PRJNA169559_P_NODE_9282_length_558_cov_1.629490_g7581_i0	PRJNA169559	9282	558	1.62949	9.0925542	Bacilli bacterium	1903720	Bacteria	Bacteria	59.7	1.13e-6	NR	MBR4619254.1	1903720	g7581	i0	46.2	0.559139784946237	52	28	28	0	312	467	1454	1505	MBR4619254.1 hypothetical protein [Bacilli bacterium]	diamond	312	59.7	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
27200136	27200136	PRJNA169559_P_NODE_30682_length_262_cov_1.334764_g28606_i0	PRJNA169559	30682	262	1.334764	3.49708168	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	55.1	2.13e-6	NR	MDE6728347.1	2485925	g28606	i0	69.7	2.26717557251908	33	10	37.8	0	103	5	393	425	MDE6728347.1 ABC transporter ATP-binding protein/permease [Oscillospiraceae bacterium]	diamond	594	55.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
27421803	27421803	PRJNA169559_P_NODE_6783_length_651_cov_3.123794_g1037_i1	PRJNA169559	6783	651	3.123794	20.33589894	Bacilli bacterium	1903720	Bacteria	Bacteria	55.8	3.51e-5	NR	MBO6195346.1	1903720	g1037	i1	30.3	2.70967741935484	155	100	67.7	2	70	510	285	439	MBO6195346.1 TMEM198/TM7SF3 family protein [Bacilli bacterium]	diamond	1764	55.8	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
27976064	27976064	PRJNA169559_P_NODE_14245_length_445_cov_3.139423_g12318_i0	PRJNA169559	14245	445	3.139423	13.97043235	Bacillaceae	186817	Bacteria	Bacteria	63.9	1.37e-8	NR	WP_206782928.1	86664	g12318	i0	36.7	4.35505617977528	98	58	64	3	64	348	869	965	WP_206782928.1 bifunctional cytochrome P450/NADPH--P450 reductase [Priestia flexa]	diamond	1938	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia flexa
28368694	28368694	PRJNA169559_P_NODE_25686_length_295_cov_1.473684_g23610_i0	PRJNA169559	25686	295	1.473684	4.3473678	Syntrophomonadaceae bacterium	2093811	Bacteria	Bacteria	67.8	8.53e-12	NR	NLU51239.1	2093811	g23610	i0	63.3	0.986440677966102	49	16	47.8	1	154	294	46	94	NLU51239.1 MaoC family dehydratase [Syntrophomonadaceae bacterium]	diamond	291	67.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae		Syntrophomonadaceae bacterium
28463684	28463684	PRJNA169559_P_NODE_22946_length_329_cov_2.080000_g20875_i0	PRJNA169559	22946	329	2.08	6.8432	Lactococcus petauri	1940789	Bacteria	Bacteria	124	9.889999999999999e-35	NR	WP_263946447.1	1940789	g20875	i0	100	0.574468085106383	63	0	57.4	0	105	293	1	63	WP_263946447.1 hypothetical protein, partial [Lactococcus petauri]	diamond	189	124	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus petauri
30059987	30059987	PRJNA169559_P_NODE_26271_length_289_cov_1.969231_g24195_i0	PRJNA169559	26271	289	1.969231	5.69107759	Bacillati	1783272	Bacteria	Bacteria	44.3	0.00896	NR	WP_022433463.1	28050	g24195	i0	37.5	3.75778546712803	56	35	58.1	0	116	283	28	83	WP_022433463.1 MULTISPECIES: peptide deformylase [Lachnospira]	diamond	1086	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnospira
30376526	30376526	PRJNA169559_P_NODE_41972_length_230_cov_1.502488_g39895_i0	PRJNA169559	41972	230	1.502488	3.4557224	root	1	Root_unresolved	Root_unresolved	92	3.14e-20	NR	MBR6396986.1	1898203	g39895	i0	47.9	24.4304347826087	73	38	95.2	0	223	5	117	189	MBR6396986.1 eukaryotic translation initiation factor EIF4E family protein [Lachnospiraceae bacterium]	diamond	5619	92	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30849975	30849975	PRJNA169559_P_NODE_14334_length_444_cov_2.691566_g12405_i0	PRJNA169559	14334	444	2.691566	11.95055304	Paenibacillaceae	186822	Bacteria	Bacteria	141	2.09e-40	NR	WP_239631023.1	185978	g12405	i0	61.2	7.81081081081081	116	45	78.4	0	35	382	1	116	WP_239631023.1 MULTISPECIES: group I truncated hemoglobin [unclassified Paenibacillus]	diamond	3468	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus
32381912	32381912	PRJNA169559_P_NODE_48599_length_156_cov_1.984252_g46522_i0	PRJNA169559	48599	156	1.984252	3.09543312	Staphylococcus aureus	1280	Bacteria	Bacteria	86.3	8.8e-20	NR	WP_414058267.1	1280	g46522	i0	70	1.15384615384615	60	9	98.1	1	2	154	83	142	WP_414058267.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	180	86.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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