metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA946307" 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
27119966	27119966	PRJNA946307_P_NODE_32362_length_230_cov_1.707182_g31488_i0	PRJNA946307	32362	230	1.707182	3.9265186	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	62.4	2.71e-10	NR	HSX03393.1	2047756	g31488	i0	49.1	2.37391304347826	57	17	74.3	1	186	16	1	45	HSX03393.1 metallophosphoesterase [Rhabdochlamydiaceae bacterium]	diamond	546	62.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
27190005	27190005	PRJNA946307_P_NODE_144942_length_166_cov_0.888889_g144068_i0	PRJNA946307	144942	166	0.888889	1.47555574	Candidatus Protochlamydia	282132	Bacteria	Bacteria	97.1	4.03e-22	NR	WP_079992799.1	389348	g144068	i0	73.6	3.63253012048193	53	14	95.8	0	6	164	145	197	WP_079992799.1 prolipoprotein diacylglyceryl transferase [Candidatus Protochlamydia naegleriophila]	diamond	603	97.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
28200505	28200505	PRJNA946307_P_NODE_155546_length_163_cov_2.763158_g154672_i0	PRJNA946307	155546	163	2.763158	4.50394754	Pseudomonadati	3379134	Bacteria	Bacteria	85.9	5.99e-18	NR	WP_059358656.1	83552	g154672	i0	71.9	8.1717791411043	57	10	93.9	1	158	6	107	163	WP_059358656.1 multicopper oxidase family protein [Parachlamydia acanthamoebae]	diamond	1332	86.3	0.995365005793743	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
28225444	28225444	PRJNA946307_P_NODE_93026_length_187_cov_2.326087_g92152_i0	PRJNA946307	93026	187	2.326087	4.34978269	Parachlamydia sp.	2052048	Bacteria	Bacteria	99	4.569999999999999e-23	NR	MCE5315941.1	2052048	g92152	i0	83.9	0.898395721925134	56	9	89.8	0	169	2	37	92	MCE5315941.1 EF-P lysine aminoacylase GenX [Parachlamydia sp.]	diamond	168	99	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
30214906	30214906	PRJNA946307_P_NODE_95512_length_186_cov_2.072993_g94638_i0	PRJNA946307	95512	186	2.072993	3.85576698	Waddliaceae bacterium	2026802	Bacteria	Bacteria	55.1	3.94e-7	NR	HEY4832187.1	2026802	g94638	i0	49	0.82258064516129	51	26	82.3	0	173	21	82	132	HEY4832187.1 RHS repeat domain-containing protein [Waddliaceae bacterium]	diamond	153	55.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
30562267	30562267	PRJNA946307_P_NODE_153573_length_164_cov_0.904348_g152699_i0	PRJNA946307	153573	164	0.904348	1.48313072	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	79.3	1.4e-17	NR	MFI0435421.1	2052176	g152699	i0	64	0.914634146341463	50	18	91.5	0	1	150	32	81	MFI0435421.1 zinc ribbon domain-containing protein [Parachlamydiaceae bacterium]	diamond	150	79.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
30625522	30625522	PRJNA946307_P_NODE_101733_length_183_cov_2.694030_g100859_i0	PRJNA946307	101733	183	2.69403	4.9300749	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	85.5	8.85e-18	NR	HEY5234572.1	2047756	g100859	i0	74.1	0.950819672131147	58	15	95.1	0	176	3	119	176	HEY5234572.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	174	85.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
30783738	30783738	PRJNA946307_P_NODE_43374_length_211_cov_3.395062_g42500_i0	PRJNA946307	43374	211	3.395062	7.16358082	Candidatus Anoxychlamydiales bacterium	2705072	Bacteria	Bacteria	42	0.0478	NR	NGX56840.1	2705072	g42500	i0	58.6	0.412322274881517	29	12	41.2	0	16	102	855	883	NGX56840.1 DNA polymerase III subunit alpha [Candidatus Anoxychlamydiales bacterium]	diamond	87	42	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Candidatus Anoxychlamydiales			Candidatus Anoxychlamydiales bacterium
31068264	31068264	PRJNA946307_P_NODE_166875_length_159_cov_2.300000_g166001_i0	PRJNA946307	166875	159	2.3	3.657	Chlamydiales bacterium	2047757	Bacteria	Bacteria	55.5	3.81e-7	NR	MCE5293246.1	2047757	g166001	i0	75	1.20754716981132	32	8	60.4	0	152	57	2877	2908	MCE5293246.1 hypothetical protein [Chlamydiales bacterium]	diamond	192	55.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31479318	31479318	PRJNA946307_P_NODE_141456_length_167_cov_0.881356_g140582_i0	PRJNA946307	141456	167	0.881356	1.47186452	Parachlamydia sp.	2052048	Bacteria	Bacteria	81.3	3.51e-16	NR	MCE2982382.1	2052048	g140582	i0	74.5	0.844311377245509	47	12	84.4	0	154	14	169	215	MCE2982382.1 hypothetical protein [Parachlamydia sp.]	diamond	141	81.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
32143443	32143443	PRJNA946307_P_NODE_113718_length_178_cov_1.503876_g112844_i0	PRJNA946307	113718	178	1.503876	2.67689928	Waddliaceae bacterium	2026802	Bacteria	Bacteria	66.2	3.09e-12	NR	HEY4832768.1	2026802	g112844	i0	59.6	0.876404494382023	52	21	87.6	0	164	9	15	66	HEY4832768.1 HNH endonuclease [Waddliaceae bacterium]	diamond	156	66.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
32175279	32175279	PRJNA946307_P_NODE_149358_length_165_cov_0.896552_g148484_i0	PRJNA946307	149358	165	0.896552	1.4793108	Criblamydia sequanensis	340071	Bacteria	Bacteria	108	6.699999999999999e-26	NR	WP_176454877.1	340071	g148484	i0	94.2	0.945454545454545	52	3	94.5	0	158	3	108	159	WP_176454877.1 DUF1073 domain-containing protein [Criblamydia sequanensis]	diamond	156	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
32213546	32213546	PRJNA946307_P_NODE_52618_length_210_cov_3.031056_g51744_i0	PRJNA946307	52618	210	3.031056	6.3652176	Bacteria	2	Bacteria	Bacteria	50.4	4.49e-5	NR	MBI5272891.1	2052156	g51744	i0	78.1	0.9	32	7	45.7	0	97	2	55	86	MBI5272891.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Chlamydiia bacterium]	diamond	189	50.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32555151	32555151	PRJNA946307_P_NODE_79059_length_194_cov_8.827586_g78185_i0	PRJNA946307	79059	194	8.827586	17.12551684	Chlamydia sp. 32-24	1895742	Bacteria	Bacteria	65.9	1.33e-10	NR	OJU82085.1	1895742	g78185	i0	100	1.51546391752577	31	0	47.9	0	97	189	307	337	OJU82085.1 MAG: flagellum-specific ATP synthase FliI [Chlamydia sp. 32-24]	diamond	294	65.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia sp. 32-24

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);;