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

5 rows where bioproject = "PRJNA773778", 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_family	tax_species
27369753	27369753	PRJNA773778_S_NODE_7303_length_483_cov_6.009756_g7153_i0	PRJNA773778	7303	483	6.009756	29.02712148	Candidatus Saccharimonadaceae bacterium	2830836	Bacteria	Bacteria	168	4.88e-48	NR	MBS7346392.1	2830836	g7153	i0	68	3.03105590062112	122	39	75.8	0	2	367	162	283	MBS7346392.1 glycosyltransferase family 2 protein [Candidatus Saccharimonadaceae bacterium]	diamond	1464	168	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonadaceae bacterium
29516298	29516298	PRJNA773778_S_NODE_28030_length_290_cov_3.608295_g27880_i0	PRJNA773778	28030	290	3.608295	10.4640555	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	48.1	7.34e-4	NR	MDO8266012.1	2026720	g27880	i0	39.1	1.82068965517241	64	39	66.2	0	85	276	177	240	MDO8266012.1 PepSY domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	528	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
30021933	30021933	PRJNA773778_S_NODE_38211_length_256_cov_2.032787_g38061_i0	PRJNA773778	38211	256	2.032787	5.20393472	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	60.5	2.11e-8	NR	MDB5176421.1	2026720	g38061	i0	84.4	0.375	32	5	37.5	0	1	96	286	317	MDB5176421.1 mechanosensitive ion channel MscS, small conductance mechanosensitive channel [Candidatus Saccharibacteria bacterium]	diamond	96	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
31095904	31095904	PRJNA773778_S_NODE_49035_length_236_cov_5.668712_g48885_i0	PRJNA773778	49035	236	5.668712	13.37816032	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	82.8	8.58e-17	NR	HUD10702.1	2973664	g48885	i0	62.1	1.51271186440678	58	22	73.7	0	5	178	238	295	HUD10702.1 sugar phosphate nucleotidyltransferase [Candidatus Saccharimonadales bacterium]	diamond	357	82.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales		Candidatus Saccharimonadales bacterium
31602134	31602134	PRJNA773778_S_NODE_9756_length_434_cov_10.739612_g9606_i0	PRJNA773778	9756	434	10.739612	46.60991608	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	120	3.2399999999999996e-32	NR	MBB1523567.1	2026720	g9606	i0	65.3	0.69815668202765	101	33	69.8	1	388	86	23	121	MBB1523567.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	303	120	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);;