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

9 rows where analysis = "diamond", bioproject = "PRJNA897077" 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
25099591	25099591	PRJNA897077_P_NODE_15600_length_252_cov_0.871508_g15473_i0	PRJNA897077	15600	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	114	2.64e-27	NR	WP_079474020.1	1371	g15473	i0	53.8	27.7738095238095	78	36	92.9	0	239	6	137	214	WP_079474020.1 glycoside hydrolase family 13 protein [Marinococcus halophilus]	diamond	6999	115	0.991304347826087	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Marinococcus	Marinococcus halophilus
27876982	27876982	PRJNA897077_P_NODE_3685_length_503_cov_1.732558_g3558_i0	PRJNA897077	3685	503	1.732558	8.71476674	Epulopiscium sp. SCG-B11WGA-EpuloA1	77094	Bacteria	Bacteria	93.2	3.2200000000000003e-21	NR	ONI39221.1	1710701	g3558	i0	48	0.608349900596421	102	53	60.8	0	1	306	2	103	ONI39221.1 hypothetical protein AN396_08935 [Epulopiscium sp. SCG-B11WGA-EpuloA1]	diamond	306	93.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Candidatus Epulonipiscium	Epulopiscium sp. SCG-B11WGA-EpuloA1
28192509	28192509	PRJNA897077_P_NODE_18566_length_245_cov_0.906977_g18439_i0	PRJNA897077	18566	245	0.906977	2.22209365	Clostridiales bacterium	1898207	Bacteria	Bacteria	51.2	3.95e-5	NR	NLL38597.1	1898207	g18439	i0	96	0.306122448979592	25	1	30.6	0	75	1	1	25	NLL38597.1 preprotein translocase subunit SecA [Clostridiales bacterium]	diamond	75	51.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
29337112	29337112	PRJNA897077_P_NODE_17689_length_247_cov_0.896552_g17562_i0	PRJNA897077	17689	247	0.896552	2.21448344	Anoxybacillaceae	3120669	Bacteria	Bacteria	157	7.73e-45	NR	WP_183185417.1	230470	g17562	i0	92.7	3.98380566801619	82	6	99.6	0	2	247	183	264	WP_183185417.1 3-phosphoserine/phosphohydroxythreonine transaminase [Anoxybacteroides voinovskiense]	diamond	984	158	0.993670886075949	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacteroides	Anoxybacteroides voinovskiense
30087244	30087244	PRJNA897077_P_NODE_4272_length_468_cov_1.794937_g4145_i0	PRJNA897077	4272	468	1.794937	8.40030516	Megasphaera elsdenii	907	Bacteria	Bacteria	45.4	0.0382	NR	WP_278967362.1	907	g4145	i0	30.8	0.685897435897436	107	69	66	4	348	40	361	466	WP_278967362.1 AMP-binding protein [Megasphaera elsdenii]	diamond	321	45.4	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera elsdenii
30813977	30813977	PRJNA897077_P_NODE_11874_length_287_cov_1.799065_g11747_i0	PRJNA897077	11874	287	1.799065	5.16331655	Bacillota bacterium	1879010	Bacteria	Bacteria	78.6	6.69e-15	NR	MCY0899278.1	1879010	g11747	i0	44.4	6.15679442508711	81	41	80.5	1	249	19	217	297	MCY0899278.1 fumarylacetoacetate hydrolase family protein [Bacillota bacterium]	diamond	1767	78.6	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31129626	31129626	PRJNA897077_P_NODE_12115_length_285_cov_1.080189_g11988_i0	PRJNA897077	12115	285	1.080189	3.07853865	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	43.9	0.00649	NR	MCQ2465791.1	2485925	g11988	i0	40.4	0.547368421052632	52	31	54.7	0	185	30	47	98	MCQ2465791.1 arsenate reductase family protein [Oscillospiraceae bacterium]	diamond	156	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
31730732	31730732	PRJNA897077_P_NODE_17917_length_247_cov_0.896552_g17790_i0	PRJNA897077	17917	247	0.896552	2.21448344	Bacillota bacterium	1879010	Bacteria	Bacteria	170	1.38e-49	NR	HOJ58304.1	1879010	g17790	i0	100	0.983805668016194	81	0	98.4	0	3	245	267	347	HOJ58304.1 aldo/keto reductase [Bacillota bacterium]	diamond	243	170	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
32899764	32899764	PRJNA897077_P_NODE_4880_length_439_cov_1.273224_g4753_i0	PRJNA897077	4880	439	1.273224	5.58945336	Clostridia bacterium	2044939	Bacteria	Bacteria	46.2	0.0169	NR	MBN2851472.1	2044939	g4753	i0	29.8	0.847380410022779	124	74	81.3	4	45	401	215	330	MBN2851472.1 DNA polymerase I [Clostridia bacterium]	diamond	372	46.2	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium

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