metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA833575" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA833575" 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
19950924	19950924	PRJNA833575_P_NODE_40196_length_233_cov_0.878049_g40059_i0	PRJNA833575	40196	233	0.878049	2.04585417	root	1	Root_unresolved	Root_unresolved	105	6.020000000000001e-27	NR	WP_006636326.1	1386	g40059	i0	66.7	8.98712446351931	69	23	88.8	0	214	8	3	71	WP_006636326.1 MULTISPECIES: glutathione peroxidase [Bacillus]	diamond	2094	105	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
27600444	27600444	PRJNA833575_P_NODE_33624_length_255_cov_1.317204_g33487_i0	PRJNA833575	33624	255	1.317204	3.3588702	Bacillati	1783272	Bacteria	Bacteria	57.4	1.29e-8	NR	MBO5985740.1	1898203	g33487	i0	54	1.70588235294118	50	20	56.5	2	255	112	24	72	MBO5985740.1 DUF4215 domain-containing protein [Lachnospiraceae bacterium]	diamond	435	57.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28263120	28263120	PRJNA833575_P_NODE_45946_length_227_cov_0.911392_g45809_i0	PRJNA833575	45946	227	0.911392	2.06885984	Bacteria	2	Bacteria	Bacteria	70.5	5.09e-12	NR	MBP3232660.1	1872532	g45809	i0	50.7	11.920704845815	69	33	89.9	1	207	4	649	717	MBP3232660.1 FIST C-terminal domain-containing protein [Anaerovibrio sp.]	diamond	2706	71.2	0.990168539325843	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Anaerovibrio	Anaerovibrio sp.
28412723	28412723	PRJNA833575_P_NODE_37626_length_237_cov_1.714286_g37489_i0	PRJNA833575	37626	237	1.714286	4.06285782	Clostridiaceae bacterium	1898204	Bacteria	Bacteria	141	4.569999999999999e-37	NR	NBH77902.1	1898204	g37489	i0	86.1	1	79	11	100	0	237	1	574	652	NBH77902.1 alpha-galactosidase [Clostridiaceae bacterium]	diamond	237	141	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium
29422781	29422781	PRJNA833575_P_NODE_15009_length_378_cov_0.957929_g14872_i0	PRJNA833575	15009	378	0.957929	3.62097162	Syntrophomonadaceae bacterium	2093811	Bacteria	Bacteria	167	8.77e-49	NR	NLB89001.1	2093811	g14872	i0	68	2.97619047619048	125	40	99.2	0	3	377	5	129	NLB89001.1 bifunctional phosphoribosylaminoimidazolecarboxamide formyltransferase/IMP cyclohydrolase [Syntrophomonadaceae bacterium]	diamond	1125	167	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae		Syntrophomonadaceae bacterium
29928426	29928426	PRJNA833575_P_NODE_13211_length_401_cov_0.846386_g13074_i0	PRJNA833575	13211	401	0.846386	3.39400786	Bacilli bacterium	1903720	Bacteria	Bacteria	49.3	0.00112	NR	MEE3344554.1	1903720	g13074	i0	48	0.374064837905237	50	26	37.4	0	62	211	248	297	MEE3344554.1 filamin/ABP280 repeat domain-containing protein [Bacilli bacterium]	diamond	150	49.3	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
30758298	30758298	PRJNA833575_P_NODE_40334_length_233_cov_0.878049_g40197_i0	PRJNA833575	40334	233	0.878049	2.04585417	Blautia	572511	Bacteria	Bacteria	128	2.3e-34	NR	WP_033140526.1	765821	g40197	i0	80	1.931330472103	75	15	96.6	0	9	233	50	124	WP_033140526.1 fructose bisphosphate aldolase [uncultured Blautia sp.]	diamond	450	128	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	uncultured Blautia sp.
31824468	31824468	PRJNA833575_P_NODE_29437_length_274_cov_1.404878_g29300_i0	PRJNA833575	29437	274	1.404878	3.84936572	Virgibacillus proomii	84407	Bacteria	Bacteria	56.2	9.29e-7	NR	WP_245799798.1	84407	g29300	i0	50.8	2.01459854014599	61	29	66.8	1	263	81	486	545	WP_245799798.1 M4 family metallopeptidase [Virgibacillus proomii]	diamond	552	56.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus proomii

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