metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA421571" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA421571" and tax_phylum = "Chlamydiota"

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
28780849	28780849	PRJNA421571_P_NODE_96567_length_248_cov_0.880000_g94018_i0	PRJNA421571	96567	248	0.88	2.1824	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	60.1	3.02e-8	NR	HUD01872.1	2047756	g94018	i0	45.5	2.86693548387097	55	30	66.5	0	168	4	33	87	HUD01872.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	711	60.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
31908964	31908964	PRJNA421571_P_NODE_59837_length_340_cov_1.880150_g57288_i0	PRJNA421571	59837	340	1.88015	6.39251	Chlamydiales bacterium	2047757	Bacteria	Bacteria	105	3.3100000000000004e-26	NR	MCP5470420.1	2047757	g57288	i0	46.9	0.997058823529412	113	60	99.7	0	340	2	3	115	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	339	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32558616	32558616	PRJNA421571_P_NODE_43459_length_436_cov_1.269972_g40911_i0	PRJNA421571	43459	436	1.269972	5.53707792	Bacteria	2	Bacteria	Bacteria	99.4	2.7500000000000003e-21	NR	MCP5508850.1	2047757	g40911	i0	37.1	2.07798165137615	151	82	99.1	5	436	5	283	427	MCP5508850.1 hypothetical protein [Chlamydiales bacterium]	diamond	906	99.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32856723	32856723	PRJNA421571_P_NODE_76280_length_286_cov_1.389671_g73731_i0	PRJNA421571	76280	286	1.389671	3.97445906	Simkania sp.	34094	Bacteria	Bacteria	101	6.669999999999999e-23	NR	MCB1076117.1	34094	g73731	i0	55.4	0.965034965034965	92	41	96.5	0	278	3	47	138	MCB1076117.1 enoyl-CoA hydratase/isomerase family protein [Simkania sp.]	diamond	276	101	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania 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);;