metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1174770" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1174770" and tax_clade = "Bacteria candidate phyla"

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
27420092	27420092	PRJNA1174770_P_NODE_9283_length_166_cov_1.444444_g9194_i0	PRJNA1174770	9283	166	1.444444	2.39777704	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	41.6	0.0344	NR	HVP53504.1	2212470	g9194	i0	34.7	0.885542168674699	49	30	88.6	1	148	2	109	155	HVP53504.1 O-antigen ligase family protein [Candidatus Eiseniibacteriota bacterium]	diamond	147	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
27735929	27735929	PRJNA1174770_P_NODE_7904_length_169_cov_0.866667_g7815_i0	PRJNA1174770	7904	169	0.866667	1.46466723	TM7 phylum sp. oral taxon 346	713049	Bacteria	Bacteria	107	1.54e-25	NR	TWP26302.1	713049	g7815	i0	98.2	0.994082840236686	56	1	99.4	0	169	2	402	457	TWP26302.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [TM7 phylum sp. oral taxon 346]	diamond	168	107	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 346
27786486	27786486	PRJNA1174770_P_NODE_11924_length_162_cov_0.920354_g11835_i0	PRJNA1174770	11924	162	0.920354	1.49097348	Bacteria	2	Bacteria	Bacteria	101	5.3399999999999996e-24	NR	PYN61734.1	2053607	g11835	i0	81.5	5	54	10	100	0	162	1	255	308	PYN61734.1 MAG: malate/lactate/ureidoglycolate dehydrogenase [Candidatus Rokuibacteriota bacterium]	diamond	810	101	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota					Candidatus Rokuibacteriota bacterium
29377420	29377420	PRJNA1174770_P_NODE_10249_length_165_cov_0.887931_g10160_i0	PRJNA1174770	10249	165	0.887931	1.46508615	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	115	5.03e-29	NR	RKV99771.1	1917697	g10160	i0	98.1	1.96363636363636	54	1	98.2	0	164	3	2	55	RKV99771.1 MAG: glycosyltransferase family 1 protein [Candidatus Saccharimonas sp.]	diamond	324	115	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
29396574	29396574	PRJNA1174770_P_NODE_9589_length_166_cov_0.880342_g9500_i0	PRJNA1174770	9589	166	0.880342	1.46136772	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	58.5	7.94e-9	NR	RKW02597.1	1917697	g9500	i0	97	1.19277108433735	33	1	59.6	0	101	3	1	33	RKW02597.1 MAG: virulence factor MviN, partial [Candidatus Saccharimonas sp.]	diamond	198	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
30407650	30407650	PRJNA1174770_P_NODE_9993_length_165_cov_0.896552_g9904_i0	PRJNA1174770	9993	165	0.896552	1.4793108	Bacteria	2	Bacteria	Bacteria	104	7.63e-26	NR	PYN62308.1	2053607	g9904	i0	96.3	3.92727272727273	54	2	98.2	0	3	164	8	61	PYN62308.1 MAG: MBL fold metallo-hydrolase [Candidatus Rokuibacteriota bacterium]	diamond	648	105	0.990476190476191	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota					Candidatus Rokuibacteriota bacterium
31576840	31576840	PRJNA1174770_P_NODE_11776_length_162_cov_1.823009_g11687_i0	PRJNA1174770	11776	162	1.823009	2.95327458	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	109	2.77e-26	NR	MBB1560059.1	2026720	g11687	i0	100	1.96296296296296	53	0	98.1	0	161	3	142	194	MBB1560059.1 S8 family serine peptidase [Candidatus Saccharibacteria bacterium]	diamond	318	109	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32348705	32348705	PRJNA1174770_P_NODE_11659_length_163_cov_0.894737_g11570_i0	PRJNA1174770	11659	163	0.894737	1.45842131	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	91.3	4.1700000000000006e-21	NR	MEO6026583.1	2838779	g11570	i0	96.2	0.957055214723926	52	2	95.7	0	3	158	124	175	MEO6026583.1 SDR family NAD(P)-dependent oxidoreductase [Candidatus Binatia bacterium]	diamond	156	91.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
32348706	32348706	PRJNA1174770_P_NODE_8839_length_167_cov_0.881356_g8750_i0	PRJNA1174770	8839	167	0.881356	1.47186452	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	79.3	1.79e-16	NR	TWP24131.1	713051	g8750	i0	78.8	0.934131736526946	52	7	86.2	1	146	3	1	52	TWP24131.1 IS30 family transposase [TM7 phylum sp. oral taxon 349]	diamond	156	79.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349

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);;