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

5 rows where bioproject = "PRJNA1067443", 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_species
22690349	22690349	PRJNA1067443_P_NODE_478_length_698_cov_13.729600_g462_i0	PRJNA1067443	478	698	13.7296	95.832608	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	189	6.85e-57	NR	MCD8561725.1	2026720	g462	i0	71.4	2.26934097421203	133	38	57.2	0	410	12	1	133	MCD8561725.1 16S rRNA (guanine(966)-N(2))-methyltransferase RsmD [Candidatus Saccharibacteria bacterium]	diamond	1584	189	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
29624645	29624645	PRJNA1067443_P_NODE_750_length_619_cov_8.223443_g732_i0	PRJNA1067443	750	619	8.223443	50.90311217	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	108	6.3799999999999996e-24	NR	MEI7689381.1	2026720	g732	i0	34.4	0.901453957996769	186	117	88.7	4	46	594	72	255	MEI7689381.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	558	108	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
29679541	29679541	PRJNA1067443_P_NODE_11370_length_277_cov_1.411765_g11352_i0	PRJNA1067443	11370	277	1.411765	3.91058905	Bacteria	2	Bacteria	Bacteria	107	8.800000000000001e-27	NR	MDB5184991.1	2026720	g11352	i0	57.1	1.91696750902527	91	39	98.6	0	275	3	111	201	MDB5184991.1 isochorismatase hydrolase, nicotinamidase/pyrazinamidase [Candidatus Saccharibacteria bacterium]	diamond	531	107	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
30288849	30288849	PRJNA1067443_P_NODE_852_length_597_cov_8.463740_g834_i0	PRJNA1067443	852	597	8.46374	50.5285278	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	190	5.669999999999998e-55	NR	MDB5160362.1	2026720	g834	i0	86.1	1.60804020100503	108	15	54.3	0	273	596	1	108	MDB5160362.1 obg, GTPase obg [Candidatus Saccharibacteria bacterium]	diamond	960	190	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
30920561	30920561	PRJNA1067443_P_NODE_12554_length_270_cov_1.456853_g12536_i0	PRJNA1067443	12554	270	1.456853	3.9335031	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	88.2	3.2e-19	NR	MBB1558610.1	2026720	g12536	i0	95.7	0.511111111111111	46	2	51.1	0	139	2	1	46	MBB1558610.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	138	88.2	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);;