metadata: contig_metadata: 13 rows where bioproject = "PRJNA857143" and tax

13 rows where bioproject = "PRJNA857143" 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
7221419	7221419	PRJNA857143_S_NODE_145226_length_270_cov_1.979695_g144133_i0	PRJNA857143	145226	270	1.979695	5.3451765	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	327	3.67e-85	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g144133	i0	90.947	20.9703703703704	243	22	90	0	23	265	173361	173603	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	5662	327	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
9771912	9771912	PRJNA857143_S_NODE_21048_length_522_cov_2.485523_g19966_i0	PRJNA857143	21048	522	2.485523	12.97443006	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	695	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g19966	i0	91.984	150.463601532567	499	34	95	6	27	522	2058829	2059324	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	78542	695	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
16146462	16146462	PRJNA857143_S_NODE_193553_length_242_cov_1.846154_g192460_i0	PRJNA857143	193553	242	1.846154	4.46769268	Chlamydiales bacterium	2047757	Bacteria	Bacteria	135	2.03e-35	NR	MDP1834650.1	2047757	g192460	i0	87.5	0.991735537190083	80	10	99.2	0	242	3	267	346	MDP1834650.1 chaperonin GroEL [Chlamydiales bacterium]	diamond	240	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
17422657	17422657	PRJNA857143_S_NODE_88234_length_327_cov_3.271654_g87141_i0	PRJNA857143	88234	327	3.271654	10.69830858	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	130	1.38e-25	NTclustered	gi\|559134048\|tpe\|HG788966.1\|	264201	g87141	i0	76.984	3.0519877675841	252	43	74	14	1	243	389	144	TPA: Candidatus Protochlamydia amoebophila UWE25 transfer-messenger mRNA Proto_amoeb_UWE25, single chain mature transcript	blastn	998	130	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
20361686	20361686	PRJNA857143_S_NODE_73416_length_349_cov_1.405797_g72323_i0	PRJNA857143	73416	349	1.405797	4.90623153	Candidatus Protochlamydia	282132	Bacteria	Bacteria	551	2.669999999999999e-152	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g72323	i0	95.143	169.676217765043	350	15	100	2	1	349	1249939	1249591	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	59217	556	0.991007194244604	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26643391	26643391	PRJNA857143_S_NODE_189881_length_244_cov_0.912281_g188788_i0	PRJNA857143	189881	244	0.912281	2.22596564	Chlamydiota bacterium	2081524	Bacteria	Bacteria	85.5	3.29e-18	NR	NGX30879.1	2081524	g188788	i0	54.4	1.70901639344262	68	31	83.6	0	1	204	126	193	NGX30879.1 hypothetical protein [Chlamydiota bacterium]	diamond	417	85.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27781729	27781729	PRJNA857143_S_NODE_114664_length_297_cov_3.147321_g113571_i0	PRJNA857143	114664	297	3.147321	9.34754337	Chlamydiales bacterium	2047757	Bacteria	Bacteria	130	9.06e-34	NR	MDP1836732.1	2047757	g113571	i0	70.7	1	99	28	99	1	2	295	191	289	MDP1836732.1 hybrid sensor histidine kinase/response regulator [Chlamydiales bacterium]	diamond	297	130	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28073856	28073856	PRJNA857143_S_NODE_81285_length_337_cov_1.409091_g80192_i0	PRJNA857143	81285	337	1.409091	4.74863667	Bacteria	2	Bacteria	Bacteria	130	3.09e-33	NR	PIS03438.1	1973936	g80192	i0	60.4	5.67952522255193	91	35	81	1	335	63	349	438	PIS03438.1 MAG: 7-dehydrocholesterol reductase [Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_42_34]	diamond	1914	130	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_42_34
28728877	28728877	PRJNA857143_S_NODE_17467_length_556_cov_2.706004_g16397_i0	PRJNA857143	17467	556	2.706004	15.04538224	Waddliaceae bacterium	2026802	Bacteria	Bacteria	90.9	3.33e-20	NR	HEY4832333.1	2026802	g16397	i0	47.8	0.485611510791367	90	46	48	1	478	212	3	92	HEY4832333.1 NADH-quinone oxidoreductase subunit K [Waddliaceae bacterium]	diamond	270	90.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
30244788	30244788	PRJNA857143_S_NODE_90692_length_324_cov_2.486056_g89599_i0	PRJNA857143	90692	324	2.486056	8.05482144	Chlamydiales bacterium STE3	1910938	Bacteria	Bacteria	139	4.05e-39	NR	KAF3362289.1	1910938	g89599	i0	63.3	4.62962962962963	98	36	90.7	0	321	28	70	167	KAF3362289.1 Low calcium response locus protein H [Chlamydiales bacterium STE3]	diamond	1500	139	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium STE3
30528908	30528908	PRJNA857143_S_NODE_189113_length_244_cov_1.596491_g188020_i0	PRJNA857143	189113	244	1.596491	3.89543804	Chlamydiota bacterium	2081524	Bacteria	Bacteria	47.8	6.42e-4	NR	MES2345192.1	2081524	g188020	i0	35.7	1.64754098360656	70	41	84.8	3	37	243	161	227	MES2345192.1 hypothetical protein [Chlamydiota bacterium]	diamond	402	47.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32394680	32394680	PRJNA857143_S_NODE_131459_length_282_cov_1.119617_g130366_i0	PRJNA857143	131459	282	1.119617	3.15731994	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	127	1.4499999999999998e-31	NR	MFI0435404.1	2052176	g130366	i0	71.8	1.79787234042553	85	24	90.4	0	257	3	860	944	MFI0435404.1 DEAD/DEAH box helicase [Parachlamydiaceae bacterium]	diamond	507	127	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32773170	32773170	PRJNA857143_S_NODE_164340_length_256_cov_1.278689_g163247_i0	PRJNA857143	164340	256	1.278689	3.27344384	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	79.7	3.88e-16	NR	MEI8125586.1	2052176	g163247	i0	44.6	0.97265625	83	46	97.3	0	253	5	117	199	MEI8125586.1 MC/SLC25 family protein [Parachlamydiaceae bacterium]	diamond	249	79.7	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);;