metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA911178" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA911178" 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
27056160	27056160	PRJNA911178_P_NODE_235002_length_253_cov_2.127778_g232528_i0	PRJNA911178	235002	253	2.127778	5.38327834	Chlamydiales bacterium	2047757	Bacteria	Bacteria	67.4	3.22e-11	NR	MDF2577426.1	2047757	g232528	i0	59.6	1.23320158102767	52	21	61.7	0	7	162	177	228	MDF2577426.1 hypothetical protein [Chlamydiales bacterium]	diamond	312	67.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28098298	28098298	PRJNA911178_P_NODE_229785_length_256_cov_1.469945_g227311_i0	PRJNA911178	229785	256	1.469945	3.7630592	Chlamydiales bacterium	2047757	Bacteria	Bacteria	135	1.08e-35	NR	MCC5832844.1	2047757	g227311	i0	67.1	2.9765625	85	28	99.6	0	256	2	202	286	MCC5832844.1 sodium:proton antiporter NhaD [Chlamydiales bacterium]	diamond	762	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28919111	28919111	PRJNA911178_P_NODE_195588_length_274_cov_1.502488_g193115_i0	PRJNA911178	195588	274	1.502488	4.11681712	Waddliaceae bacterium	2026802	Bacteria	Bacteria	114	6.49e-30	NR	HEY4832442.1	2026802	g193115	i0	63.6	0.963503649635037	88	32	96.4	0	11	274	31	118	HEY4832442.1 DUF892 family protein [Waddliaceae bacterium]	diamond	264	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
30537443	30537443	PRJNA911178_P_NODE_209893_length_266_cov_1.891192_g207419_i0	PRJNA911178	209893	266	1.891192	5.03057072	Chlamydia	810	Bacteria	Bacteria	51.6	3.65e-5	NR	WP_247107639.1	83554	g207419	i0	54.5	2.0187969924812	44	19	49.6	1	152	21	132	174	WP_247107639.1 S41 family peptidase, partial [Chlamydia psittaci]	diamond	537	51.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
31327385	31327385	PRJNA911178_P_NODE_288775_length_242_cov_0.911243_g286301_i0	PRJNA911178	288775	242	0.911243	2.20520806	Chlamydiia	204429	Bacteria	Bacteria	89.7	1.13e-19	NR	MCP5507110.1	2047757	g286301	i0	59.1	1.63636363636364	66	27	81.8	0	240	43	187	252	MCP5507110.1 MerR family transcriptional regulator [Chlamydiales bacterium]	diamond	396	89.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32047621	32047621	PRJNA911178_P_NODE_133498_length_320_cov_1.753036_g131025_i0	PRJNA911178	133498	320	1.753036	5.6097152	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	77.8	3.13e-16	NR	MBA3720972.1	2052176	g131025	i0	63.9	0.571875	61	22	57.2	0	271	89	1	61	MBA3720972.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	183	77.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32205824	32205824	PRJNA911178_P_NODE_252738_length_249_cov_0.875000_g250264_i0	PRJNA911178	252738	249	0.875	2.17875	Candidatus Rubidus massiliensis	1444712	Bacteria	Bacteria	66.2	2.24e-10	NR	CDZ79622.1	1444712	g250264	i0	46.5	2.57831325301205	71	38	85.5	0	25	237	573	643	CDZ79622.1 hypothetical protein BN1013_00117 [Candidatus Rubidus massiliensis]	diamond	642	66.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Candidatus Rubidus	Candidatus Rubidus massiliensis
32332673	32332673	PRJNA911178_P_NODE_186299_length_279_cov_1.966019_g183826_i0	PRJNA911178	186299	279	1.966019	5.48519301	Waddliaceae bacterium	2026802	Bacteria	Bacteria	44.7	9.85e-4	NR	MBT7461305.1	2026802	g183826	i0	48.9	2.12903225806452	45	23	48.4	0	4	138	14	58	MBT7461305.1 ribonuclease P protein component [Waddliaceae bacterium]	diamond	594	44.7	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);;