metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA690234" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA690234" 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
28693197	28693197	PRJNA690234_P_NODE_8687_length_435_cov_2.632597_g8321_i0	PRJNA690234	8687	435	2.632597	11.45179695	Amphibacillus indicireducens	1076330	Bacteria	Bacteria	63.9	1.15e-8	NR	WP_344911417.1	1076330	g8321	i0	30.5	0.724137931034483	105	71	71	1	378	70	378	482	WP_344911417.1 ABC transporter ATP-binding protein [Amphibacillus indicireducens]	diamond	315	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Amphibacillus	Amphibacillus indicireducens
29324373	29324373	PRJNA690234_P_NODE_22989_length_265_cov_1.041667_g22622_i0	PRJNA690234	22989	265	1.041667	2.76041755	Streptococcus dysgalactiae	1334	Bacteria	Bacteria	99.4	6.24e-22	NR	MBM6549248.1	119602	g22622	i0	52.1	1.08679245283019	96	38	99.6	2	2	265	343	438	MBM6549248.1 DUF1759 domain-containing protein [Streptococcus dysgalactiae subsp. equisimilis]	diamond	288	99.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus dysgalactiae
29861268	29861268	PRJNA690234_P_NODE_30591_length_244_cov_0.912281_g30224_i0	PRJNA690234	30591	244	0.912281	2.22596564	Priestia megaterium	1404	Bacteria	Bacteria	95.1	1.41e-20	NR	MBT2278850.1	1404	g30224	i0	58	0.995901639344262	81	34	99.6	0	243	1	621	701	MBT2278850.1 DEAD/DEAH box helicase [Priestia megaterium]	diamond	243	95.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
30967204	30967204	PRJNA690234_P_NODE_2294_length_870_cov_7.028858_g1998_i0	PRJNA690234	2294	870	7.028858	61.1510646	Lactobacillales bacterium	1993866	Bacteria	Bacteria	47	0.0183	NR	MBE6159497.1	1993866	g1998	i0	30	0.344827586206897	100	57	30	2	387	127	49	148	MBE6159497.1 hypothetical protein [Lactobacillales bacterium]	diamond	300	47	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales			Lactobacillales bacterium
31187907	31187907	PRJNA690234_P_NODE_26335_length_251_cov_0.876404_g25968_i0	PRJNA690234	26335	251	0.876404	2.19977404	Sporomusa acidovorans	112900	Bacteria	Bacteria	120	2.4199999999999997e-30	NR	WP_093796893.1	112900	g25968	i0	64.6	0.9800796812749	82	29	98	0	246	1	274	355	WP_093796893.1 M20/M25/M40 family metallo-hydrolase [Sporomusa acidovorans]	diamond	246	120	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Sporomusa	Sporomusa acidovorans
31441167	31441167	PRJNA690234_P_NODE_16016_length_317_cov_72.364754_g15649_i0	PRJNA690234	16016	317	72.364754	229.39627018	Veillonella sp.	1926307	Bacteria	Bacteria	164	2.06e-50	NR	WP_366512514.1	1926307	g15649	i0	74	1.96845425867508	104	27	98.4	0	316	5	2	105	WP_366512514.1 hypothetical protein [Veillonella sp.]	diamond	624	164	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella sp.
32358966	32358966	PRJNA690234_P_NODE_27159_length_250_cov_0.875706_g26792_i0	PRJNA690234	27159	250	0.875706	2.189265	Thermicanus aegyptius	94009	Bacteria	Bacteria	141	2.72e-41	NR	WP_005587977.1	94009	g26792	i0	82.9	0.984	82	14	98.4	0	246	1	22	103	WP_005587977.1 Spx/MgsR family RNA polymerase-binding regulatory protein [Thermicanus aegyptius]	diamond	246	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
32496876	32496876	PRJNA690234_P_NODE_30779_length_243_cov_2.152941_g30412_i0	PRJNA690234	30779	243	2.152941	5.23164663	FCB group	1783270	Bacteria	Bacteria	44.3	0.0104	NR	WP_139125126.1	1305675	g30412	i0	38.8	2.49382716049383	67	39	80.2	1	20	214	148	214	WP_139125126.1 sugar ABC transporter ATP-binding protein [Bacillus solimangrovi]	diamond	606	44.7	0.991051454138702	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus solimangrovi
32674377	32674377	PRJNA690234_P_NODE_26860_length_250_cov_0.881356_g26493_i0	PRJNA690234	26860	250	0.881356	2.20339	Thermicanus aegyptius	94009	Bacteria	Bacteria	119	3.64e-31	NR	WP_084213425.1	94009	g26493	i0	77.1	0.996	83	19	99.6	0	250	2	22	104	WP_084213425.1 PspA/IM30 family protein [Thermicanus aegyptius]	diamond	249	119	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius

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