metadata: contig_metadata: 7 rows where bioproject = "PRJNA874604", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJNA874604", 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
9780403	9780403	PRJNA874604_P_NODE_75788_length_249_cov_0.875000_g75436_i0	PRJNA874604	75788	249	0.875	2.17875	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	366	7.09e-97	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g75436	i0	93.173	59.1004016064257	249	17	100	0	1	249	799854	799606	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	14716	366	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
27055337	27055337	PRJNA874604_P_NODE_65602_length_256_cov_1.393443_g65250_i0	PRJNA874604	65602	256	1.393443	3.56721408	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	84.7	6.76e-17	NR	HEY4160733.1	2973664	g65250	i0	60.3	3.76171875	63	25	73.8	0	57	245	5	67	HEY4160733.1 bifunctional sulfate adenylyltransferase/adenylylsulfate kinase [Candidatus Saccharimonadales bacterium]	diamond	963	84.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
27371580	27371580	PRJNA874604_P_NODE_100923_length_239_cov_2.638554_g100571_i0	PRJNA874604	100923	239	2.638554	6.30614406	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	77.4	2e-16	NR	MBW4061930.1	2026720	g100571	i0	65.4	1.26778242677824	52	18	65.3	0	2	157	44	95	MBW4061930.1 type II toxin-antitoxin system RelE/ParE family toxin [Candidatus Saccharibacteria bacterium]	diamond	303	77.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
29328843	29328843	PRJNA874604_P_NODE_55089_length_275_cov_1.183168_g54737_i0	PRJNA874604	55089	275	1.183168	3.253712	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	119	2.29e-30	NR	HEY2004086.1	2890869	g54737	i0	67.4	0.970909090909091	89	29	97.1	0	269	3	174	262	HEY2004086.1 VWA domain-containing protein [Candidatus Saccharimonadia bacterium]	diamond	267	119	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia		Candidatus Saccharimonadia bacterium
29360534	29360534	PRJNA874604_P_NODE_97389_length_242_cov_0.911243_g97037_i0	PRJNA874604	97389	242	0.911243	2.20520806	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	107	6.0099999999999995e-25	NR	OJU87796.1	1895829	g97037	i0	64.6	1.01652892561983	82	27	99.2	1	241	2	82	163	OJU87796.1 MAG: hypothetical protein BGO17_02320 [Candidatus Saccharibacteria bacterium 49-20]	diamond	246	107	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 49-20
32561293	32561293	PRJNA874604_P_NODE_96099_length_242_cov_0.911243_g95747_i0	PRJNA874604	96099	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	123	1.01e-31	NR	MDB5181157.1	2026720	g95747	i0	91.3	3.42148760330579	69	6	85.5	0	208	2	1	69	MDB5181157.1 nusA [Candidatus Saccharibacteria bacterium]	diamond	828	124	0.991935483870968	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
32616034	32616034	PRJNA874604_P_NODE_96580_length_242_cov_0.911243_g96228_i0	PRJNA874604	96580	242	0.911243	2.20520806	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	94.4	2.64e-21	NR	MAU33634.1	2026720	g96228	i0	55.1	1.92148760330579	78	35	96.7	0	242	9	194	271	MAU33634.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	465	94.4	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);;