metadata: contig_metadata: 5 rows where bioproject = "PRJNA529241" and tax

5 rows where bioproject = "PRJNA529241" 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_species
13252488	13252488	PRJNA529241_P_NODE_147571_length_187_cov_1.820000_g145249_i0	PRJNA529241	147571	187	1.82	3.4034	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2621703325\|emb\|OY762463.1\|	3060593	g145249	i0	96.875	0.171122994652406	32	1	17	0	147	178	3933196	3933227	MAG: Candidatus Cloacimonadales bacterium isolate 65c66405-a38e-4cb1-a3a4-7640fae4a1c6 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadales bacterium
27362301	27362301	PRJNA529241_P_NODE_74203_length_246_cov_6.861244_g71881_i0	PRJNA529241	74203	246	6.861244	16.87866024	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	49.7	1.47e-5	NR	MCK9558796.1	2030808	g71881	i0	44.3	0.74390243902439	61	17	53.7	1	135	4	28	88	MCK9558796.1 hypothetical protein [Candidatus Cloacimonadota bacterium]	diamond	183	49.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota			Candidatus Cloacimonadota bacterium
27582920	27582920	PRJNA529241_P_NODE_350404_length_173_cov_2.860294_g348082_i0	PRJNA529241	350404	173	2.860294	4.94830862	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	42.7	0.0048	NR	MCF7859808.1	2030808	g348082	i0	60.9	0.398843930635838	23	9	39.9	0	1	69	18	40	MCF7859808.1 hypothetical protein [Candidatus Cloacimonadota bacterium]	diamond	69	42.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota			Candidatus Cloacimonadota bacterium
29587018	29587018	PRJNA529241_P_NODE_425610_length_166_cov_1.209302_g423288_i0	PRJNA529241	425610	166	1.209302	2.00744132	Pseudomonadati	3379134	Bacteria	Bacteria	46.6	5.76e-4	NR	MBC8312797.1	2030808	g423288	i0	33.3	4.78915662650602	54	36	97.6	0	1	162	234	287	MBC8312797.1 efflux RND transporter periplasmic adaptor subunit [Candidatus Cloacimonadota bacterium]	diamond	795	46.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota			Candidatus Cloacimonadota bacterium
30235494	30235494	PRJNA529241_P_NODE_66592_length_257_cov_7.072727_g64270_i0	PRJNA529241	66592	257	7.072727	18.17690839	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	50.1	1.15e-5	NR	MCK9558796.1	2030808	g64270	i0	84	0.291828793774319	25	4	29.2	0	76	2	45	69	MCK9558796.1 hypothetical protein [Candidatus Cloacimonadota bacterium]	diamond	75	50.1	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);;