metadata: contig_metadata: 9 rows where bioproject = "PRJNA1233465" and tax

9 rows where bioproject = "PRJNA1233465" 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
25534149	25534149	PRJNA1233465a_S_NODE_253585_length_158_cov_4.385321_g252311_i0	PRJNA1233465	253585	158	4.385321	6.92880718	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2621706016\|emb\|OY764078.1\|	3060593	g252311	i0	100	0.177215189873418	28	0	18	0	14	41	1947234	1947207	MAG: Candidatus Cloacimonadales bacterium isolate 02056a20-4ec6-4ab0-ab2d-03f0ed9894bb genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
25813621	25813621	PRJNA1233465d_S_NODE_117075_length_171_cov_1.631148_g115964_i0	PRJNA1233465	117075	171	1.631148	2.78926308	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2621706016\|emb\|OY764078.1\|	3060593	g115964	i0	100	0.16374269005848	28	0	16	0	136	163	1947207	1947234	MAG: Candidatus Cloacimonadales bacterium isolate 02056a20-4ec6-4ab0-ab2d-03f0ed9894bb genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
25959964	25959964	PRJNA1233465f_S_NODE_109028_length_230_cov_2.077348_g106748_i0	PRJNA1233465	109028	230	2.077348	4.7779004	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	67.6	7.33e-7	NTclustered	gi\|2621786373\|emb\|OY782831.1\|	3060593	g106748	i0	89.286	18.9173913043478	56	3	24	2	176	230	1166874	1166821	MAG: Candidatus Cloacimonadales bacterium isolate 04309a76-b7cc-48c3-85ee-0a4392eb1095 genome assembly, chromosome: 1	blastn	4351	67.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
26348219	26348219	PRJNA1233465a_S_NODE_158423_length_191_cov_1.373239_g157149_i0	PRJNA1233465	158423	191	1.373239	2.62288649	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2907625735\|emb\|OZ223295.1\|	3060593	g157149	i0	100	0.303664921465969	29	0	15	0	147	175	1394378	1394406	MAG: Candidatus Cloacimonadales bacterium isolate 6aa99263-f948-4c70-b254-b65c93863ac0 genome assembly, chromosome: 1	blastn	58	54.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
26491611	26491611	PRJNA1233465b_S_NODE_312544_length_171_cov_12.811475_g310859_i0	PRJNA1233465	312544	171	12.811475	21.90762225	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2621706016\|emb\|OY764078.1\|	3060593	g310859	i0	100	0.16374269005848	28	0	16	0	28	55	1947234	1947207	MAG: Candidatus Cloacimonadales bacterium isolate 02056a20-4ec6-4ab0-ab2d-03f0ed9894bb genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
26495505	26495505	PRJNA1233465d_S_NODE_22184_length_345_cov_1.567568_g21073_i0	PRJNA1233465	22184	345	1.567568	5.4081096	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	67.6	1.17e-6	NTclustered	gi\|2621786373\|emb\|OY782831.1\|	3060593	g21073	i0	89.286	12.8434782608696	56	3	16	2	137	191	1166821	1166874	MAG: Candidatus Cloacimonadales bacterium isolate 04309a76-b7cc-48c3-85ee-0a4392eb1095 genome assembly, chromosome: 1	blastn	4431	67.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
32992386	32992386	PRJNA1233465f_S_NODE_123099_length_218_cov_1.982249_g120819_i0	PRJNA1233465	123099	218	1.982249	4.32130282	Pseudomonadati	3379134	Bacteria	Bacteria	53.5	3.94e-6	NR	MCB5271919.1	2030808	g120819	i0	61.1	1.51376146788991	36	14	49.5	0	111	218	1	36	MCB5271919.1 DUF4007 family protein [Candidatus Cloacimonadota bacterium]	diamond	330	53.5	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
33034134	33034134	PRJNA1233465a_S_NODE_201276_length_173_cov_1.088710_g200002_i0	PRJNA1233465	201276	173	1.08871	1.8834683	Candidatus Syntrophosphaera sp.	2819277	Bacteria	Bacteria	41.2	0.0397	NR	MBW6513725.1	2819277	g200002	i0	33.3	0.728323699421965	42	28	72.8	0	16	141	70	111	MBW6513725.1 16S rRNA (guanine(966)-N(2))-methyltransferase RsmD [Candidatus Syntrophosphaera sp.]	diamond	126	41.2	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Syntrophosphaera	Candidatus Syntrophosphaera sp.
33162451	33162451	PRJNA1233465b_S_NODE_186896_length_215_cov_2.355422_g185211_i0	PRJNA1233465	186896	215	2.355422	5.0641573	Pseudomonadati	3379134	Bacteria	Bacteria	44.7	0.00522	NR	MCB5271919.1	2030808	g185211	i0	56.3	0.906976744186046	32	14	44.7	0	97	2	1	32	MCB5271919.1 DUF4007 family protein [Candidatus Cloacimonadota bacterium]	diamond	195	44.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota 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);;