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

5 rows where analysis = "diamond", bioproject = "PRJNA379145" 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
26631792	26631792	PRJNA379145_P_NODE_42421_length_283_cov_2.512000_g40269_i0	PRJNA379145	42421	283	2.512	7.10896	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	70.1	1.08e-11	NR	HMS92978.1	2026720	g40269	i0	40.8	2.41696113074205	76	44	79.5	1	59	283	83	158	HMS92978.1 cellulase family glycosylhydrolase [Candidatus Saccharibacteria bacterium]	diamond	684	70.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
26726323	26726323	PRJNA379145_P_NODE_12481_length_833_cov_2.391250_g11079_i0	PRJNA379145	12481	833	2.39125	19.9191125	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	153	9.95e-41	NR	HUA69260.1	2973664	g11079	i0	36.1	1.77551020408163	255	124	90.8	6	8	763	53	271	HUA69260.1 tartrate-resistant acid phosphatase type 5 family protein [Candidatus Saccharimonadales bacterium]	diamond	1479	153	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
26916720	26916720	PRJNA379145_P_NODE_14602_length_749_cov_2.596369_g11079_i1	PRJNA379145	14602	749	2.596369	19.44680381	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	166	7.33e-46	NR	HUA69260.1	2973664	g11079	i1	40.5	1.75033377837116	227	124	89.7	5	742	71	53	271	HUA69260.1 tartrate-resistant acid phosphatase type 5 family protein [Candidatus Saccharimonadales bacterium]	diamond	1311	166	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
28117134	28117134	PRJNA379145_P_NODE_50665_length_230_cov_1.456853_g48511_i0	PRJNA379145	50665	230	1.456853	3.3507619	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	83.6	1.31e-16	NR	MBR2725423.1	2026720	g48511	i0	52	7.81304347826087	75	33	97.8	1	228	4	335	406	MBR2725423.1 UvrD-helicase domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	1797	83.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
28622521	28622521	PRJNA379145_P_NODE_22647_length_539_cov_2.496047_g20688_i0	PRJNA379145	22647	539	2.496047	13.45369333	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	48.9	0.00481	NR	NCO10391.1	2026720	g20688	i0	40.3	0.345083487940631	62	33	34.5	2	2	187	707	764	NCO10391.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	186	48.9	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);;