metadata: contig_metadata: 12 rows where bioproject = "PRJNA833575", tax_phylum = "Bacillota" and tax

12 rows where bioproject = "PRJNA833575", tax_phylum = "Bacillota" and tax_superkingdom = "Bacteria"

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
824576	824576	PRJNA833575_P_NODE_44601_length_228_cov_0.905660_g44464_i0	PRJNA833575	44601	228	0.90566	2.0649048	Lachnospiraceae bacterium JLR.KK009	3114295	Bacteria	Bacteria	246	8.69e-61	NTclustered	gi\|2692820420\|gb\|CP143549.1\|	3114295	g44464	i0	86.547	153.171052631579	223	30	98	0	6	228	1520	1742	Lachnospiraceae bacterium JLR.KK009 strain JLR.KK002 chromosome	blastn	34923	246	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium JLR.KK009
17402661	17402661	PRJNA833575_P_NODE_32774_length_259_cov_1.247368_g32637_i0	PRJNA833575	32774	259	1.247368	3.23068312	Blautia producta	33035	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1575847935\|gb\|CP035945.1\|	33035	g32637	i0	100	0.108108108108108	28	0	11	0	81	108	3257834	3257807	Blautia producta strain PMF1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia producta
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
22906510	22906510	PRJNA833575_P_NODE_32078_length_262_cov_1.471503_g31941_i0	PRJNA833575	32078	262	1.471503	3.85533786	Staphylococcus	1279	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|2536850969\|gb\|CP129362.1\|	1283	g31941	i0	99.618	52	262	1	100	0	1	262	2374045	2374306	Staphylococcus haemolyticus strain CCSH-121 chromosome, complete genome	blastn	13624	479	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
25050738	25050738	PRJNA833575_P_NODE_39820_length_233_cov_2.792683_g39683_i0	PRJNA833575	39820	233	2.792683	6.50695139	Dolosigranulum pigrum	29394	Bacteria	Bacteria	429	8.239999999999998e-116	NTclustered	gi\|2020690643\|gb\|CP040409.1\|	29394	g39683	i0	100	24.8927038626609	232	0	99	0	1	232	1199757	1199988	Dolosigranulum pigrum strain KPL3274 chromosome, complete genome	blastn	5800	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
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);;