metadata: contig_metadata: 5 rows where bioproject = "PRJNA902848", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA902848", tax_clade = "Bacteria candidate phyla" 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
26675733	26675733	PRJNA902848_P_NODE_20081_length_242_cov_0.923077_g20031_i0	PRJNA902848	20081	242	0.923077	2.23384634	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	98.2	2.72e-22	NR	MEI7689437.1	2026720	g20031	i0	58.2	0.979338842975207	79	33	97.9	0	5	241	60	138	MEI7689437.1 glycosyltransferase family 4 protein [Candidatus Saccharibacteria bacterium]	diamond	237	98.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
27814217	27814217	PRJNA902848_P_NODE_13104_length_253_cov_0.866667_g13054_i0	PRJNA902848	13104	253	0.866667	2.19266751	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	161	1.4399999999999998e-47	NR	GDX62557.1	2026720	g13054	i0	96.3	0.972332015810277	82	3	97.2	0	248	3	1	82	GDX62557.1 putative metal-dependent hydrolase YabD [Candidatus Saccharibacteria bacterium]	diamond	246	161	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
29550368	29550368	PRJNA902848_P_NODE_12990_length_253_cov_0.866667_g12940_i0	PRJNA902848	12990	253	0.866667	2.19266751	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	97.4	9.49e-22	NR	HUD07873.1	2973664	g12940	i0	62.7	3.92490118577075	83	29	98.4	1	251	3	53	133	HUD07873.1 cysteine desulfurase family protein [Candidatus Saccharimonadales bacterium]	diamond	993	97.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
31288065	31288065	PRJNA902848_P_NODE_13355_length_253_cov_0.866667_g13305_i0	PRJNA902848	13355	253	0.866667	2.19266751	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	84.7	3.24e-18	NR	MDB5176431.1	2026720	g13305	i0	51.8	0.984189723320158	83	40	98.4	0	251	3	52	134	MDB5176431.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	249	84.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
31794013	31794013	PRJNA902848_P_NODE_13877_length_252_cov_0.871508_g13827_i0	PRJNA902848	13877	252	0.871508	2.19620016	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	58.5	1.11e-7	NR	MBR3172634.1	2026720	g13827	i0	60	0.476190476190476	40	16	47.6	0	120	1	45	84	MBR3172634.1 trypsin-like peptidase domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	120	58.5	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);;