metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA749559" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA749559" and tax_kingdom = "Bacillati"

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
29105592	29105592	PRJNA749559_P_NODE_2488_length_275_cov_1.766355_g2418_i0	PRJNA749559	2488	275	1.766355	4.85747625	Listeria monocytogenes	1639	Bacteria	Bacteria	47.8	1.2e-4	NR	WP_333734094.1	1639	g2418	i0	29.2	1.61454545454545	72	46	78.5	1	13	228	24	90	WP_333734094.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	444	47.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
30432306	30432306	PRJNA749559_P_NODE_4613_length_205_cov_0.888889_g4543_i0	PRJNA749559	4613	205	0.888889	1.82222245	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	73.2	1.23e-14	NR	MDR0839482.1	2485925	g4543	i0	54	0.921951219512195	63	29	92.2	0	189	1	26	88	MDR0839482.1 RidA family protein [Oscillospiraceae bacterium]	diamond	189	73.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
30526646	30526646	PRJNA749559_P_NODE_2253_length_290_cov_0.873362_g2183_i0	PRJNA749559	2253	290	0.873362	2.5327498	unclassified Streptomyces	2593676	Bacteria	Bacteria	43.9	0.0253	NR	WP_030027838.1	2593676	g2183	i0	41.5	0.848275862068966	82	38	80.7	5	37	270	447	522	WP_030027838.1 MULTISPECIES: alpha/beta hydrolase [unclassified Streptomyces]	diamond	246	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
30652905	30652905	PRJNA749559_P_NODE_4553_length_205_cov_1.555556_g4483_i0	PRJNA749559	4553	205	1.555556	3.1888898	Candidatus Caldilinea saccharophila	3140701	Bacteria	Bacteria	42.4	0.0225	NR	MBK8799436.1	3140701	g4483	i0	76	0.365853658536585	25	6	36.6	0	88	162	12	36	MBK8799436.1 HNH endonuclease [Candidatus Caldilinea saccharophila]	diamond	75	42.4	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Candidatus Caldilinea saccharophila
31221588	31221588	PRJNA749559_P_NODE_5075_length_201_cov_0.857143_g5005_i0	PRJNA749559	5075	201	0.857143	1.72285743	Staphylococcus aureus	1280	Bacteria	Bacteria	43.9	0.00174	NR	WP_254613577.1	1280	g5005	i0	56.3	1.28358208955224	48	19	71.6	1	56	199	9	54	WP_254613577.1 hypothetical protein [Staphylococcus aureus]	diamond	258	43.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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