metadata: contig_metadata: 5 rows where bioproject = "PRJNA1067370", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA1067370", tax_clade = "FCB group" and tax_phylum = "Candidatus Cloacimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26940541	26940541	PRJNA1067370_P_NODE_36502_length_330_cov_1.797665_g35954_i0	PRJNA1067370	36502	330	1.797665	5.9322945	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	43.9	0.0361	NR	MCK4358411.1	2030808	g35954	i0	42.4	0.536363636363636	59	34	53.6	0	252	76	248	306	MCK4358411.1 abortive infection family protein [Candidatus Cloacimonadota bacterium]	diamond	177	43.9	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
27343619	27343619	PRJNA1067370_P_NODE_72843_length_260_cov_1.647059_g72294_i0	PRJNA1067370	72843	260	1.647059	4.2823534	Bacteria	2	Bacteria	Bacteria	72.8	6.2e-13	NR	MDP8203978.1	3039904	g72294	i0	41.7	1.93846153846154	84	44	96.9	1	252	1	23	101	MDP8203978.1 ChaN family lipoprotein [Candidatus Tenebribacter mawsonii]	diamond	504	73.2	0.994535519125683	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales		Candidatus Tenebribacter	Candidatus Tenebribacter mawsonii
28583296	28583296	PRJNA1067370_P_NODE_58287_length_282_cov_1.842105_g57738_i0	PRJNA1067370	58287	282	1.842105	5.1947361	Candidatus Cloacimonetes bacterium HGW-Cloacimonetes-2	2013734	Bacteria	Bacteria	52.8	1.85e-5	NR	PKN75693.1	2013734	g57738	i0	51	1.25531914893617	51	25	54.3	0	153	1	98	148	PKN75693.1 MAG: zinc carboxypeptidase [Candidatus Cloacimonetes bacterium HGW-Cloacimonetes-2]	diamond	354	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonetes bacterium HGW-Cloacimonetes-2
31607507	31607507	PRJNA1067370_P_NODE_8736_length_612_cov_1.582560_g8207_i0	PRJNA1067370	8736	612	1.58256	9.6852672	Pseudomonadati	3379134	Bacteria	Bacteria	150	2.71e-39	NR	NLG61881.1	2030808	g8207	i0	45.3	1.86274509803922	190	95	88.7	1	580	38	296	485	NLG61881.1 glutamine synthetase type III [Candidatus Cloacimonadota bacterium]	diamond	1140	150	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
32776966	32776966	PRJNA1067370_P_NODE_15280_length_473_cov_1.540000_g14733_i0	PRJNA1067370	15280	473	1.54	7.2842	Candidatus Cloacimonadaceae	3039865	Bacteria	Bacteria	78.2	1.81e-13	NR	MEN6398023.1	2053534	g14733	i0	37.9	1.83298097251586	145	84	91.3	4	5	436	289	428	MEN6398023.1 SBBP repeat-containing protein [Candidatus Cloacimonas sp.]	diamond	867	78.6	0.994910941475827	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Cloacimonas	Candidatus Cloacimonas sp.

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