metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA493828" 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
26981974	26981974	PRJNA493828_P_NODE_29482_length_257_cov_2.945652_g29063_i0	PRJNA493828	29482	257	2.945652	7.57032564	Chlamydia psittaci	83554	Bacteria	Bacteria	40.8	0.0263	NR	EPJ13726.1	1112252	g29063	i0	55.6	0.420233463035019	36	15	40.9	1	244	140	26	61	EPJ13726.1 hypothetical protein CP01DC11_1481, partial [Chlamydia psittaci 01DC11]	diamond	108	40.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
28213619	28213619	PRJNA493828_P_NODE_32646_length_250_cov_1.423729_g32227_i0	PRJNA493828	32646	250	1.423729	3.5593225	Chlamydiales bacterium 38-26	1895743	Bacteria	Bacteria	95.1	1.4e-20	NR	OJV08385.1	1895743	g32227	i0	100	1.176	43	0	51.6	0	248	120	4	46	OJV08385.1 MAG: hypothetical protein BGO14_05655 [Chlamydiales bacterium 38-26]	diamond	294	95.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium 38-26
30850740	30850740	PRJNA493828_P_NODE_37234_length_244_cov_0.900585_g36815_i0	PRJNA493828	37234	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	120	7.289999999999999e-30	NR	WP_032125010.1	389348	g36815	i0	70.4	10.9549180327869	81	19	99.6	1	243	1	171	246	WP_032125010.1 asparagine--tRNA ligase [Candidatus Protochlamydia naegleriophila]	diamond	2673	121	0.991735537190083	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
31024833	31024833	PRJNA493828_P_NODE_26215_length_267_cov_1.237113_g25796_i0	PRJNA493828	26215	267	1.237113	3.30309171	Chlamydiales bacterium	2047757	Bacteria	Bacteria	118	3.51e-30	NR	HSX13160.1	2047757	g25796	i0	63.1	0.943820224719101	84	31	94.4	0	14	265	174	257	HSX13160.1 FAD-dependent oxidoreductase [Chlamydiales bacterium]	diamond	252	118	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31815284	31815284	PRJNA493828_P_NODE_38717_length_242_cov_1.396450_g38298_i0	PRJNA493828	38717	242	1.39645	3.379409	Chlamydiales bacterium	2047757	Bacteria	Bacteria	155	7.9499999999999995e-47	NR	MBN9377900.1	2047757	g38298	i0	100	0.991735537190083	80	0	99.2	0	242	3	62	141	MBN9377900.1 YtxH domain-containing protein [Chlamydiales bacterium]	diamond	240	155	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;