metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1063685" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1063685" 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
15482695	15482695	PRJNA1063685_S_NODE_80913_length_198_cov_4.416000_g80370_i0	PRJNA1063685	80913	198	4.416	8.74368	Chlamydia psittaci 84-8471/1	1112230	Bacteria	Bacteria	92.8	5.1099999999999996e-23	NR	EPP32950.1	1112230	g80370	i0	90	0.757575757575758	50	5	75.8	0	6	155	1	50	EPP32950.1 hypothetical protein CP8484711_2610, partial [Chlamydia psittaci 84-8471/1]	diamond	150	92.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
21856356	21856356	PRJNA1063685_S_NODE_27518_length_447_cov_4.636364_g26977_i0	PRJNA1063685	27518	447	4.636364	20.72454708	Bacteria	2	Bacteria	Bacteria	229	1.87e-70	NR	HEY4832636.1	2026802	g26977	i0	78.7	15.1275167785235	141	30	94.6	0	445	23	150	290	HEY4832636.1 MBOAT family O-acyltransferase [Waddliaceae bacterium]	diamond	6762	229	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
26687203	26687203	PRJNA1063685_S_NODE_3381_length_795_cov_9.817175_g2985_i0	PRJNA1063685	3381	795	9.817175	78.04654125	Chlamydiia bacterium	2052156	Bacteria	Bacteria	172	6.68e-48	NR	MCB1073391.1	2052156	g2985	i0	43.4	0.860377358490566	228	113	83	8	727	68	111	330	MCB1073391.1 hypothetical protein [Chlamydiia bacterium]	diamond	684	172	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
27415045	27415045	PRJNA1063685_S_NODE_31983_length_415_cov_1.961988_g31441_i0	PRJNA1063685	31983	415	1.961988	8.1422502	Candidatus Algichlamydia australiensis	3341976	Bacteria	Bacteria	45.8	0.0185	NR	MDX8431166.1	3341976	g31441	i0	30.6	0.874698795180723	121	75	83.9	3	406	59	430	546	MDX8431166.1 hypothetical protein [Candidatus Algichlamydia australiensis]	diamond	363	45.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Algichlamydia	Candidatus Algichlamydia australiensis
28298760	28298760	PRJNA1063685_S_NODE_5746_length_711_cov_11.056426_g5283_i0	PRJNA1063685	5746	711	11.056426	78.61118886	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	243	2.72e-73	NR	QVL54756.1	2698248	g5283	i0	57.3	0.89873417721519	213	87	88.2	3	711	85	375	587	QVL54756.1 MAG: hypothetical protein KFB95_05390 [Simkaniaceae bacterium]	diamond	639	243	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
30920414	30920414	PRJNA1063685_S_NODE_62474_length_272_cov_1.195980_g61931_i0	PRJNA1063685	62474	272	1.19598	3.2530656	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	114	1.5600000000000002e-27	NR	MBY0529559.1	2047756	g61931	i0	60	1.98529411764706	90	36	99.3	0	272	3	65	154	MBY0529559.1 7-dehydrocholesterol reductase [Rhabdochlamydiaceae bacterium]	diamond	540	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
32375104	32375104	PRJNA1063685_S_NODE_10799_length_617_cov_2.652574_g10284_i0	PRJNA1063685	10799	617	2.652574	16.36638158	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	53.9	1.42e-4	NR	MBA3720792.1	2052176	g10284	i0	30.6	0.777957860615883	160	92	74.4	6	579	121	416	563	MBA3720792.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	480	53.9	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);;