metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1097627" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1097627" 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
28109785	28109785	PRJNA1097627_P_NODE_171905_length_246_cov_0.890173_g171612_i0	PRJNA1097627	171905	246	0.890173	2.18982558	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	42.7	0.0398	NR	NLM78062.1	2485925	g171612	i0	32.8	0.74390243902439	61	40	73.2	1	186	7	248	308	NLM78062.1 hypothetical protein [Oscillospiraceae bacterium]	diamond	183	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
29435722	29435722	PRJNA1097627_P_NODE_146410_length_250_cov_0.870056_g146117_i0	PRJNA1097627	146410	250	0.870056	2.17514	Lacicoccus qingdaonensis	576118	Bacteria	Bacteria	160	1.83e-43	NR	WP_092985070.1	576118	g146117	i0	100	0.996	83	0	99.6	0	1	249	468	550	WP_092985070.1 ATP-dependent Clp protease ATP-binding subunit [Lacicoccus qingdaonensis]	diamond	249	160	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Salinicoccaceae	Lacicoccus	Lacicoccus qingdaonensis
29625001	29625001	PRJNA1097627_P_NODE_204430_length_241_cov_0.916667_g204137_i0	PRJNA1097627	204430	241	0.916667	2.20916747	Clostridiales bacterium	1898207	Bacteria	Bacteria	118	8.71e-31	NR	NTV77887.1	1898207	g204137	i0	67.9	0.970954356846473	78	25	97.1	0	241	8	26	103	NTV77887.1 hypothetical protein [Clostridiales bacterium]	diamond	234	118	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
29656650	29656650	PRJNA1097627_P_NODE_195010_length_242_cov_0.911243_g194717_i0	PRJNA1097627	195010	242	0.911243	2.20520806	Anaerococcus murdochii	411577	Bacteria	Bacteria	134	4.36e-36	NR	WP_223419116.1	411577	g194717	i0	94.9	0.966942148760331	78	4	96.7	0	235	2	1	78	WP_223419116.1 transglutaminase domain-containing protein [Anaerococcus murdochii]	diamond	234	134	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus murdochii
30509948	30509948	PRJNA1097627_P_NODE_183913_length_244_cov_0.900585_g183620_i0	PRJNA1097627	183913	244	0.900585	2.1974274	Defluviitaleaceae bacterium	2660712	Bacteria	Bacteria	60.5	2.7e-9	NR	MCL2215826.1	2660712	g183620	i0	55.8	0.528688524590164	43	19	52.9	0	116	244	1	43	MCL2215826.1 hypothetical protein [Defluviitaleaceae bacterium]	diamond	129	60.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Defluviitaleaceae		Defluviitaleaceae bacterium
31512873	31512873	PRJNA1097627_P_NODE_147896_length_250_cov_0.870056_g147603_i0	PRJNA1097627	147896	250	0.870056	2.17514	Staphylococcaceae	90964	Bacteria	Bacteria	80.5	2.11e-15	NR	MDU4503098.1	1292	g147603	i0	50.6	6.828	81	40	97.2	0	246	4	558	638	MDU4503098.1 relaxase MobL [Staphylococcus warneri]	diamond	1707	80.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
32090845	32090845	PRJNA1097627_P_NODE_192038_length_243_cov_0.876471_g191745_i0	PRJNA1097627	192038	243	0.876471	2.12982453	Faecalibacterium	216851	Bacteria	Bacteria	97.8	2.36e-22	NR	WP_097781996.1	216851	g191745	i0	90	0.617283950617284	50	5	61.7	0	94	243	1	50	WP_097781996.1 MULTISPECIES: hypothetical protein [Faecalibacterium]	diamond	150	97.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium

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