metadata: contig_metadata: 8 rows where bioproject = "PRJNA1022392", tax_clade = "Bacteria candidate phyla" and tax

8 rows where bioproject = "PRJNA1022392", 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_genus	tax_species
7814709	7814709	PRJNA1022392_P_NODE_40307_length_196_cov_3.308725_g39638_i0	PRJNA1022392	40307	196	3.308725	6.485101	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	69.4	1.68e-7	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g39638	i0	80	0.510204081632653	100	14	49	4	1	96	752806	752709	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	100	69.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
15465154	15465154	PRJNA1022392_P_NODE_60273_length_177_cov_1.330769_g59604_i0	PRJNA1022392	60273	177	1.330769	2.35546113	Candidatus Nanosynbacter lyticus	2093824	Bacteria	Bacteria	202	1.4e-47	NTclustered	gi\|2869833183\|gb\|CP175706.1\|	2093824	g59604	i0	87.861	1.73446327683616	173	19	97	2	6	177	15474	15303	Candidatus Nanosynbacter lyticus strain BB004 chromosome, complete genome	blastn	307	202	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
27287819	27287819	PRJNA1022392_P_NODE_28563_length_206_cov_4.320755_g27894_i0	PRJNA1022392	28563	206	4.320755	8.9007553	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	50.4	4.32e-5	NR	HEY1835475.1	2973664	g27894	i0	75.9	0.87378640776699	29	7	42.2	0	118	204	1	29	HEY1835475.1 excinuclease ABC subunit UvrC [Candidatus Saccharimonadales bacterium]	diamond	180	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
29623936	29623936	PRJNA1022392_P_NODE_75190_length_161_cov_1.087719_g74521_i0	PRJNA1022392	75190	161	1.087719	1.75122759	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	56.6	1.54e-7	NR	MBX6334645.1	2026720	g74521	i0	50.9	0.987577639751553	53	26	98.8	0	2	160	382	434	MBX6334645.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	159	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30351492	30351492	PRJNA1022392_P_NODE_28212_length_206_cov_4.566038_g27543_i0	PRJNA1022392	28212	206	4.566038	9.40603828	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	61.6	4.89e-9	NR	MBI1856882.1	2026720	g27543	i0	93.8	2.79611650485437	32	2	46.6	0	111	206	266	297	MBI1856882.1 cell division protein FtsZ [Candidatus Saccharibacteria bacterium]	diamond	576	61.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30666892	30666892	PRJNA1022392_P_NODE_43013_length_195_cov_3.209459_g42344_i0	PRJNA1022392	43013	195	3.209459	6.25844505	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	68.2	1.42e-11	NR	MBH2007910.1	2026720	g42344	i0	100	0.492307692307692	32	0	49.2	0	3	98	121	152	MBH2007910.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	96	68.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30848642	30848642	PRJNA1022392_P_NODE_71194_length_164_cov_1.461538_g70525_i0	PRJNA1022392	71194	164	1.461538	2.39692232	Pseudomonadati	3379134	Bacteria	Bacteria	99.8	1.8899999999999994e-23	NR	HJM04459.1	2830836	g70525	i0	79.6	2.96341463414634	54	11	98.8	0	163	2	255	308	HJM04459.1 peptidoglycan bridge formation glycyltransferase FemA/FemB family protein [Candidatus Saccharimonadaceae bacterium]	diamond	486	100	0.998	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae		Candidatus Saccharimonadaceae bacterium
32406231	32406231	PRJNA1022392_P_NODE_65339_length_170_cov_3.113821_g64670_i0	PRJNA1022392	65339	170	3.113821	5.2934957	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	86.7	4.65e-18	NR	MCA9323566.1	2026720	g64670	i0	80.4	1.97647058823529	56	11	98.8	0	1	168	82	137	MCA9323566.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Saccharibacteria bacterium]	diamond	336	86.7	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);;