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

5 rows where analysis = "diamond", bioproject = "PRJNA415856" 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_family	tax_genus	tax_species
27833586	27833586	PRJNA415856_P_NODE_48824_length_162_cov_0.902655_g48563_i0	PRJNA415856	48824	162	0.902655	1.4623011	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	84.7	4.65e-19	NR	MDO4870867.1	2026720	g48563	i0	95.7	0.851851851851852	46	2	85.2	0	25	162	1	46	MDO4870867.1 30S ribosomal protein S7 [Candidatus Saccharibacteria bacterium]	diamond	138	84.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28307308	28307308	PRJNA415856_P_NODE_26706_length_180_cov_1.534351_g26445_i0	PRJNA415856	26706	180	1.534351	2.7618318	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	116	1.7299999999999999e-28	NR	MBF1037421.1	2725945	g26445	i0	89.8	0.983333333333333	59	6	98.3	0	179	3	288	346	MBF1037421.1 hypothetical protein [Candidatus Nanosynbacter sp.]	diamond	177	116	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.
28560012	28560012	PRJNA415856_P_NODE_26227_length_181_cov_1.462121_g25966_i0	PRJNA415856	26227	181	1.462121	2.64643901	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1	1986206	Bacteria	Bacteria	123	1.96e-31	NR	WP_129693348.1	1986206	g25966	i0	100	1.95580110497238	60	0	99.4	0	181	2	118	177	WP_129693348.1 dihydrolipoyl dehydrogenase family protein [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	354	123	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
28623185	28623185	PRJNA415856_P_NODE_34627_length_167_cov_1.728814_g34366_i0	PRJNA415856	34627	167	1.728814	2.88711938	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	83.6	1.09e-17	NR	MEO5950029.1	2973664	g34366	i0	74.1	0.970059880239521	54	14	97	0	167	6	19	72	MEO5950029.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	162	83.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30724069	30724069	PRJNA415856_P_NODE_29594_length_175_cov_1.563492_g29333_i0	PRJNA415856	29594	175	1.563492	2.736111	Bacteria	2	Bacteria	Bacteria	72.8	3.35e-13	NR	TAH36621.1	2026720	g29333	i0	60.7	2.88	56	21	96	1	171	4	90	144	TAH36621.1 MAG: PrgI family protein [Candidatus Saccharibacteria bacterium]	diamond	504	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota 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);;