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

5 rows where analysis = "diamond", bioproject = "PRJEB3181" 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
14084295	14084295	PRJEB3181_P_NODE_7572_length_306_cov_2.720000_g7311_i0	PRJEB3181	7572	306	2.72	8.3232	Candidatus Protochlamydia sp. W-9	1785087	Bacteria	Bacteria	107	1.58e-24	NR	WP_075882638.1	1785087	g7311	i0	98.3	0.568627450980392	58	1	56.9	0	176	3	331	388	WP_075882638.1 chaperonin GroEL [Candidatus Protochlamydia sp. W-9]	diamond	174	107	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
15358071	15358071	PRJEB3181_P_NODE_16613_length_205_cov_1.419540_g16349_i0	PRJEB3181	16613	205	1.41954	2.910057	Parachlamydiaceae	92713	Bacteria	Bacteria	112	3.31e-27	NR	WP_075882638.1	1785087	g16349	i0	96.6	3.45365853658537	59	2	86.3	0	179	3	1	59	WP_075882638.1 chaperonin GroEL [Candidatus Protochlamydia sp. W-9]	diamond	708	113	0.991150442477876	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
26780221	26780221	PRJEB3181_S_NODE_2741_length_334_cov_4.083612_g2448_i0	PRJEB3181	2741	334	4.083612	13.63926408	Chlamydiales bacterium	2047757	Bacteria	Bacteria	85.1	3e-18	NR	MCP5470420.1	2047757	g2448	i0	73.3	0.673652694610778	75	20	67.4	0	46	270	81	155	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	225	85.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31834759	31834759	PRJEB3181_P_NODE_26017_length_157_cov_3.960317_g25752_i0	PRJEB3181	26017	157	3.960317	6.21769769	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	91.7	6.69e-20	NR	WP_079992857.1	389348	g25752	i0	84.3	0.974522292993631	51	8	97.5	0	154	2	474	524	WP_079992857.1 His/Gly/Thr/Pro-type tRNA ligase C-terminal domain-containing protein [Candidatus Protochlamydia naegleriophila]	diamond	153	91.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
32309843	32309843	PRJEB3181_P_NODE_20419_length_181_cov_4.566667_g20155_i0	PRJEB3181	20419	181	4.566667	8.26566727	Waddliaceae bacterium	2026802	Bacteria	Bacteria	73.2	1.01e-14	NR	HEY4831554.1	2026802	g20155	i0	57.6	0.977900552486188	59	19	87.8	1	159	1	41	99	HEY4831554.1 BON domain-containing protein [Waddliaceae bacterium]	diamond	177	73.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae 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);;