metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA986547" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA986547" 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
26962955	26962955	PRJNA986547_P_NODE_17102_length_199_cov_10.325397_g17020_i0	PRJNA986547	17102	199	10.325397	20.54754003	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	94.7	9.72e-21	NR	MBX6334645.1	2026720	g17020	i0	66.2	0.979899497487437	65	22	98	0	196	2	140	204	MBX6334645.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	195	94.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27342729	27342729	PRJNA986547_P_NODE_3803_length_293_cov_6.895455_g3721_i0	PRJNA986547	3803	293	6.895455	20.20368315	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	124	1.01e-30	NR	HMH70446.1	2973664	g3721	i0	63.9	0.993174061433447	97	35	99.3	0	292	2	215	311	HMH70446.1 polysaccharide deacetylase family protein [Candidatus Saccharimonadales bacterium]	diamond	291	124	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27942580	27942580	PRJNA986547_P_NODE_8465_length_251_cov_2.146067_g8383_i0	PRJNA986547	8465	251	2.146067	5.38662817	Candidatus Nanoperiomorbus periodonticus	2171989	Bacteria	Bacteria	134	1.0599999999999998e-37	NR	WP_129620708.1	2171989	g8383	i0	98.4	0.752988047808765	63	1	75.3	0	1	189	114	176	WP_129620708.1 inorganic diphosphatase [Candidatus Nanoperiomorbus periodonticus]	diamond	189	134	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanoperiomorbia	Candidatus Nanoperiomorbales	Candidatus Nanoperiomorbaceae	Candidatus Nanoperiomorbus	Candidatus Nanoperiomorbus periodonticus
32587495	32587495	PRJNA986547_P_NODE_2839_length_310_cov_3.957806_g2757_i0	PRJNA986547	2839	310	3.957806	12.2691986	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	50.8	7.11e-5	NR	MBF1033638.1	2725945	g2757	i0	37	1.36451612903226	92	52	83.2	2	1	258	96	187	MBF1033638.1 hypothetical protein [Candidatus Nanosynbacter sp.]	diamond	423	50.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.

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