metadata: contig_metadata: 16 rows where bioproject = "PRJNA994052" and tax

16 rows where bioproject = "PRJNA994052" 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
4804502	4804502	PRJNA994052_P_NODE_54204_length_234_cov_96.956522_g52949_i0	PRJNA994052	54204	234	96.956522	226.87826148	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	377	3.04e-100	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g52949	i0	96.889	85.8461538461538	225	7	96	0	10	234	1334101	1334325	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	20088	377	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
11179846	11179846	PRJNA994052_P_NODE_48289_length_244_cov_11.578947_g47037_i0	PRJNA994052	48289	244	11.578947	28.25263068	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	357	4.16e-94	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g47037	i0	95.154	155.934426229508	227	9	93	2	19	244	174621	174396	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	38048	357	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
26614781	26614781	PRJNA994052_P_NODE_27541_length_288_cov_28.469767_g26300_i0	PRJNA994052	27541	288	28.469767	81.99292896	Chlamydiota bacterium	2081524	Bacteria	Bacteria	85.5	4.92e-17	NR	NBO24907.1	2081524	g26300	i0	78	0.520833333333333	50	11	52.1	0	2	151	234	283	NBO24907.1 hypothetical protein [Chlamydiota bacterium]	diamond	150	85.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27311221	27311221	PRJNA994052_P_NODE_50083_length_241_cov_17.059524_g48829_i0	PRJNA994052	50083	241	17.059524	41.11345284	Chlamydiota bacterium	2081524	Bacteria	Bacteria	91.7	8.83e-20	NR	MCH9633628.1	2081524	g48829	i0	56.7	0.83402489626556	67	29	83.4	0	5	205	272	338	MCH9633628.1 hypothetical protein [Chlamydiota bacterium]	diamond	201	91.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28953140	28953140	PRJNA994052_P_NODE_60428_length_225_cov_51.197368_g59172_i0	PRJNA994052	60428	225	51.197368	115.194078	Chlamydiota bacterium	2081524	Bacteria	Bacteria	108	1.19e-25	NR	MCH9633337.1	2081524	g59172	i0	72.5	1.81333333333333	69	19	92	0	6	212	56	124	MCH9633337.1 hypothetical protein [Chlamydiota bacterium]	diamond	408	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29268442	29268442	PRJNA994052_P_NODE_19449_length_310_cov_14.810127_g18226_i0	PRJNA994052	19449	310	14.810127	45.9113937	Candidatus Acheromyda pituitae	3076874	Bacteria	Bacteria	95.9	1.29e-20	NR	MBX3718261.1	3076874	g18226	i0	81.6	0.474193548387097	49	9	47.4	0	2	148	133	181	MBX3718261.1 mannose-1-phosphate guanylyltransferase/mannose-6-phosphate isomerase [Candidatus Acheromyda pituitae]	diamond	147	95.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Acheromyda	Candidatus Acheromyda pituitae
29268451	29268451	PRJNA994052_P_NODE_51929_length_238_cov_20.454545_g50674_i0	PRJNA994052	51929	238	20.454545	48.6818171	Chlamydiota bacterium	2081524	Bacteria	Bacteria	73.2	1.49e-13	NR	NDD59168.1	2081524	g50674	i0	57.4	0.76890756302521	61	25	76.9	1	51	233	147	206	NDD59168.1 molecular chaperone GroEL [Chlamydiota bacterium]	diamond	183	73.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29331764	29331764	PRJNA994052_P_NODE_66309_length_217_cov_35.284722_g65053_i0	PRJNA994052	66309	217	35.284722	76.56784674	Chlamydiota bacterium	2081524	Bacteria	Bacteria	82.8	2.62e-17	NR	MCH9632643.1	2081524	g65053	i0	53.5	0.981566820276498	71	33	98.2	0	215	3	71	141	MCH9632643.1 hypothetical protein [Chlamydiota bacterium]	diamond	213	82.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29584059	29584059	PRJNA994052_P_NODE_28690_length_285_cov_40.235849_g27448_i0	PRJNA994052	28690	285	40.235849	114.67216965	Candidatus Acheromyda pituitae	3076874	Bacteria	Bacteria	176	5.68e-50	NR	MBX3718498.1	3076874	g27448	i0	91.1	0.947368421052632	90	8	94.7	0	272	3	115	204	MBX3718498.1 aspartate--tRNA ligase [Candidatus Acheromyda pituitae]	diamond	270	176	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Acheromyda	Candidatus Acheromyda pituitae
30057946	30057946	PRJNA994052_P_NODE_80691_length_200_cov_10.614173_g79434_i0	PRJNA994052	80691	200	10.614173	21.228346	Chlamydiota bacterium	2081524	Bacteria	Bacteria	84.3	4.66e-17	NR	NGX53639.1	2081524	g79434	i0	69.5	0.885	59	18	88.5	0	193	17	81	139	NGX53639.1 Replicative DNA helicase [Chlamydiota bacterium]	diamond	177	84.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30911293	30911293	PRJNA994052_P_NODE_21934_length_304_cov_26.536797_g20706_i0	PRJNA994052	21934	304	26.536797	80.67186288	Chlamydiota bacterium	2081524	Bacteria	Bacteria	85.5	6.18e-17	NR	NBO24907.1	2081524	g20706	i0	78	0.493421052631579	50	11	49.3	0	2	151	234	283	NBO24907.1 hypothetical protein [Chlamydiota bacterium]	diamond	150	85.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31258778	31258778	PRJNA994052_P_NODE_26595_length_291_cov_4.133028_g25355_i0	PRJNA994052	26595	291	4.133028	12.02711148	Chlamydiota bacterium	2081524	Bacteria	Bacteria	108	4.17e-25	NR	MCH9633264.1	2081524	g25355	i0	47	1.38144329896907	134	33	99	1	289	2	99	232	MCH9633264.1 DNA mismatch repair protein MutL [Chlamydiota bacterium]	diamond	402	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31638220	31638220	PRJNA994052_P_NODE_39356_length_260_cov_12.443850_g38110_i0	PRJNA994052	39356	260	12.44385	32.35401	Candidatus Acheromyda pituitae	3076874	Bacteria	Bacteria	112	1.03e-28	NR	MBX3718403.1	3076874	g38110	i0	71.4	0.969230769230769	84	24	96.9	0	255	4	87	170	MBX3718403.1 LysM peptidoglycan-binding domain-containing protein [Candidatus Acheromyda pituitae]	diamond	252	112	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Acheromyda	Candidatus Acheromyda pituitae
32397782	32397782	PRJNA994052_P_NODE_22299_length_303_cov_14.130435_g21071_i0	PRJNA994052	22299	303	14.130435	42.81521805	Candidatus Acheromyda pituitae	3076874	Bacteria	Bacteria	144	1.42e-41	NR	MBX3718787.1	3076874	g21071	i0	65.4	1.05940594059406	107	28	97	1	3	296	8	114	MBX3718787.1 metallophosphoesterase [Candidatus Acheromyda pituitae]	diamond	321	144	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Acheromyda	Candidatus Acheromyda pituitae
32492735	32492735	PRJNA994052_P_NODE_19459_length_310_cov_14.101266_g18236_i0	PRJNA994052	19459	310	14.101266	43.7139246	Candidatus Acheromyda pituitae	3076874	Bacteria	Bacteria	80.9	7.04e-16	NR	MBX3718996.1	3076874	g18236	i0	88.6	0.425806451612903	44	5	42.6	0	16	147	145	188	MBX3718996.1 DUF455 family protein [Candidatus Acheromyda pituitae]	diamond	132	80.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Acheromyda	Candidatus Acheromyda pituitae
32556147	32556147	PRJNA994052_P_NODE_30579_length_280_cov_38.449275_g29336_i0	PRJNA994052	30579	280	38.449275	107.65797	Chlamydiota bacterium	2081524	Bacteria	Bacteria	172	1.75e-49	NR	MCH9632099.1	2081524	g29336	i0	85.9	0.985714285714286	92	13	98.6	0	2	277	127	218	MCH9632099.1 hypothetical protein [Chlamydiota bacterium]	diamond	276	172	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;