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

9 rows where analysis = "diamond", bioproject = "PRJNA1011844" and tax_phylum = "Candidatus Saccharimonadota"

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_clade	tax_phylum	tax_class	tax_order	tax_species
26971298	26971298	PRJNA1011844_P_NODE_115922_length_290_cov_1.262673_g107346_i0	PRJNA1011844	115922	290	1.262673	3.6617517	Candidatus Saccharibacteria bacterium 32-5	1970480	Bacteria	Bacteria	156	3.07e-44	NR	OYX39241.1	1970480	g107346	i0	78.7	0.920689655172414	89	19	92.1	0	275	9	236	324	OYX39241.1 MAG: hypothetical protein B7Z00_00760 [Candidatus Saccharibacteria bacterium 32-50-10]	diamond	267	156	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 32-50-10
27192623	27192623	PRJNA1011844_P_NODE_133482_length_265_cov_2.067708_g124904_i0	PRJNA1011844	133482	265	2.067708	5.4794262	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	62	6.65e-9	NR	HBO64468.1	2026720	g124904	i0	75.7	1.25660377358491	37	9	41.9	0	263	153	269	305	HBO64468.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	333	62	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
28361129	28361129	PRJNA1011844_P_NODE_171086_length_227_cov_2.642857_g162505_i0	PRJNA1011844	171086	227	2.642857	5.99928539	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	42.4	0.0415	NR	HKR82482.1	2973664	g162505	i0	41.2	0.674008810572687	51	30	67.4	0	19	171	40	90	HKR82482.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	153	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
28487663	28487663	PRJNA1011844_P_NODE_165707_length_235_cov_2.333333_g157126_i0	PRJNA1011844	165707	235	2.333333	5.48333255	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	42	0.0107	NR	MDO4774021.1	2026720	g157126	i0	36.5	0.663829787234043	52	33	66.4	0	45	200	11	62	MDO4774021.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	156	42	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
29403156	29403156	PRJNA1011844_P_NODE_13569_length_1552_cov_8.720081_g9833_i0	PRJNA1011844	13569	1552	8.720081	135.33565712	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	53.5	0.00242	NR	HVF33711.1	2890869	g9833	i0	36.6	0.179768041237113	93	55	18	2	785	507	494	582	HVF33711.1 serine/threonine-protein kinase [Candidatus Saccharimonadia bacterium]	diamond	279	53.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia		Candidatus Saccharimonadia bacterium
29497858	29497858	PRJNA1011844_P_NODE_139230_length_258_cov_2.410811_g130652_i0	PRJNA1011844	139230	258	2.410811	6.21989238	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	48.5	3.99e-4	NR	MCL2445014.1	2026720	g130652	i0	42	0.802325581395349	69	39	80.2	1	47	253	147	214	MCL2445014.1 IPT/TIG domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	207	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
29718764	29718764	PRJNA1011844_P_NODE_94050_length_345_cov_3.422794_g85488_i0	PRJNA1011844	94050	345	3.422794	11.8086393	Candidatus Saccharibacteria bacterium 32-49-12	1970479	Bacteria	Bacteria	58.9	2.39e-7	NR	OYX40957.1	1970479	g85488	i0	37	0.869565217391304	100	62	87	1	341	42	378	476	OYX40957.1 MAG: hypothetical protein B7Y94_05830, partial [Candidatus Saccharibacteria bacterium 32-49-12]	diamond	300	58.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 32-49-12
30603419	30603419	PRJNA1011844_P_NODE_67113_length_472_cov_4.333333_g58675_i0	PRJNA1011844	67113	472	4.333333	20.45333176	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	58.5	1.28e-6	NR	HVP38111.1	2973664	g58675	i0	37.6	0.692796610169492	109	56	69.3	3	86	412	475	571	HVP38111.1 kelch repeat-containing protein [Candidatus Saccharimonadales bacterium]	diamond	327	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
31615063	31615063	PRJNA1011844_P_NODE_936_length_4218_cov_13.434258_g568_i0	PRJNA1011844	936	4218	13.434258	566.65700244	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	54.3	0.00575	NR	HSX42623.1	2973664	g568	i0	24.8	0.214793741109531	302	173	19.4	11	1658	840	99	375	HSX42623.1 lectin-like protein [Candidatus Saccharimonadales bacterium]	diamond	906	54.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales 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);;