metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA169559" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA169559" 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
11843784	11843784	PRJNA169559_P_NODE_690_length_2008_cov_3.763517_g322_i0	PRJNA169559	690	2008	3.763517	75.57142136	root	1	Root_unresolved	Root_unresolved	785	3.05e-278	NR	WP_013182645.1	71667	g322	i0	62.2	10.9093625498008	611	221	91.1	6	1861	32	2	603	WP_013182645.1 phosphoenolpyruvate carboxykinase (GTP) [Waddlia chondrophila]	diamond	21906	790	0.993670886075949	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
27737631	27737631	PRJNA169559_P_NODE_48424_length_159_cov_2.176923_g46347_i0	PRJNA169559	48424	159	2.176923	3.4613075699999998	Candidatus Rhabdochlamydia sp.	2320511	Bacteria	Bacteria	109	3.01e-26	NR	MFI0478845.1	2320511	g46347	i0	98	0.962264150943396	51	1	96.2	0	155	3	1100	1150	MFI0478845.1 hypothetical protein [Candidatus Rhabdochlamydia sp.]	diamond	153	109	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia sp.
28558388	28558388	PRJNA169559_P_NODE_46087_length_200_cov_1.356725_g44010_i0	PRJNA169559	46087	200	1.356725	2.71345	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	146	1.84e-42	NR	MFI0436095.1	2052176	g44010	i0	98.5	0.99	66	1	99	0	3	200	7	72	MFI0436095.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	198	146	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31748931	31748931	PRJNA169559_P_NODE_45197_length_213_cov_1.923913_g43120_i0	PRJNA169559	45197	213	1.923913	4.09793469	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	63.9	8.32e-10	NR	MFI0436003.1	2052176	g43120	i0	40.3	1.01408450704225	72	41	98.6	1	211	2	454	525	MFI0436003.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	216	63.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32160526	32160526	PRJNA169559_P_NODE_10278_length_528_cov_37.835671_g8515_i0	PRJNA169559	10278	528	37.835671	199.77234288	Chlamydiales bacterium	2047757	Bacteria	Bacteria	148	3.8e-42	NR	MCP5470421.1	2047757	g8515	i0	51.9	3.40340909090909	156	69	87.5	2	507	46	6	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1797	148	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32634362	32634362	PRJNA169559_P_NODE_26900_length_284_cov_1.635294_g24824_i0	PRJNA169559	26900	284	1.635294	4.64423496	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	57.8	2.25e-7	NR	MFI0435901.1	2052176	g24824	i0	76.3	0.401408450704225	38	9	40.1	0	282	169	140	177	MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	114	57.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae 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);;