metadata: contig_metadata: 12 rows where bioproject = "PRJNA770826" and tax

12 rows where bioproject = "PRJNA770826" 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
746931	746931	PRJNA770826_P_NODE_4121_length_425_cov_1.510638_g3950_i0	PRJNA770826	4121	425	1.510638	6.4202115	Chlamydiota bacterium	2081524	Bacteria	Bacteria	208	3.7900000000000005e-64	NR	NGX47840.1	2081524	g3950	i0	65.7	18.0282352941176	140	47	98.8	1	425	6	150	288	NGX47840.1 GDP-L-fucose synthase [Chlamydiota bacterium]	diamond	7662	208	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
3298180	3298180	PRJNA770826_P_NODE_7983_length_289_cov_0.908333_g7812_i0	PRJNA770826	7983	289	0.908333	2.62508237	Candidatus Syngnamydia salmonis	504270	Bacteria	Bacteria	342	1.4199999999999997e-89	NTclustered	gi\|1214145827\|gb\|KY427067.1\|	504270	g7812	i0	92.857	251.429065743945	238	13	82	4	1	236	3721	3486	Candidatus Syngnamydia salmonis isolate H03/14Pp 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer 23S ribosomal RNA and 5S ribosomal RNA genes, complete sequence	blastn	72663	342	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia salmonis
4575177	4575177	PRJNA770826_P_NODE_2784_length_521_cov_1.932203_g2615_i0	PRJNA770826	2784	521	1.932203	10.06677763	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	706	0	NTclustered	gi\|18029193\|gb\|AF364564.1\|	174324	g2615	i0	94.348	106.781190019194	460	26	88	0	62	521	173	632	Uncultured Chlamydiales bacterium clone P-4 16S ribosomal RNA gene, partial sequence	blastn	55633	706	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
16049589	16049589	PRJNA770826_P_NODE_7353_length_304_cov_1.560784_g7182_i0	PRJNA770826	7353	304	1.560784	4.74478336	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	337	6.98e-88	NTclustered	gi\|2041291174\|gb\|CP073762.1\|	2698248	g7182	i0	87.713	149.220394736842	293	30	96	6	14	304	517318	517606	MAG: Simkaniaceae bacterium isolate M30B2 chromosome, complete genome	blastn	45363	337	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
16509638	16509638	PRJNA770826_P_NODE_41533_length_162_cov_1.380531_g41362_i0	PRJNA770826	41533	162	1.380531	2.23646022	Candidatus Protochlamydia	282132	Bacteria	Bacteria	267	4.419999999999999e-67	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g41362	i0	96.296	155.37037037037	162	6	100	0	1	162	1248920	1248759	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	25170	267	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
20333158	20333158	PRJNA770826_P_NODE_7336_length_304_cov_2.141176_g7165_i0	PRJNA770826	7336	304	2.141176	6.50917504	Candidatus Protochlamydia	282132	Bacteria	Bacteria	518	2.32e-142	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g7165	i0	97.987	162.582236842105	298	6	98	0	7	304	1249349	1249052	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	49425	518	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
24158344	24158344	PRJNA770826_P_NODE_12739_length_225_cov_1.869318_g12568_i0	PRJNA770826	12739	225	1.869318	4.2059655	Parachlamydia	83551	Bacteria	Bacteria	355	1.36e-93	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g12568	i0	95.133	149.56	226	9	100	2	1	225	953	1177	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	33651	355	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
24973586	24973586	PRJNA770826_P_NODE_5520_length_360_cov_1.633441_g5349_i0	PRJNA770826	5520	360	1.633441	5.8803876	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	455	2.23e-123	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g5349	i0	89.694	167.45	359	33	99	3	2	358	654194	653838	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	60282	455	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
29999808	29999808	PRJNA770826_P_NODE_22991_length_169_cov_0.866667_g22820_i0	PRJNA770826	22991	169	0.866667	1.46466723	Parachlamydiaceae	92713	Bacteria	Bacteria	54.3	1.15e-6	NR	WP_059060745.1	389348	g22820	i0	55.6	2.84023668639053	54	23	94.1	1	168	10	258	311	WP_059060745.1 ADP-ribosylhydrolase MavL family protein [Candidatus Protochlamydia naegleriophila]	diamond	480	54.7	0.992687385740402	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
31253894	31253894	PRJNA770826_P_NODE_16435_length_200_cov_0.814570_g16264_i0	PRJNA770826	16435	200	0.81457	1.62914	Chlamydiales bacterium STE3	1910938	Bacteria	Bacteria	47	6.69e-4	NR	KAF3363195.1	1910938	g16264	i0	44.4	0.945	63	30	93	2	3	188	308	366	KAF3363195.1 Uncharacterized protein PHSC3_000209 [Chlamydiales bacterium STE3]	diamond	189	47	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium STE3
32139744	32139744	PRJNA770826_P_NODE_12198_length_230_cov_1.618785_g12027_i0	PRJNA770826	12198	230	1.618785	3.7232055	Chlamydiales bacterium	2047757	Bacteria	Bacteria	69.7	1.55e-12	NR	MDB2614325.1	2047757	g12027	i0	38.4	0.952173913043478	73	45	95.2	0	12	230	75	147	MDB2614325.1 hypothetical protein [Chlamydiales bacterium]	diamond	219	69.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32361409	32361409	PRJNA770826_P_NODE_28059_length_167_cov_1.322034_g27888_i0	PRJNA770826	28059	167	1.322034	2.20779678	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	79	2.27e-15	NR	QVL54756.1	2698248	g27888	i0	64.6	2.74850299401198	48	17	86.2	0	3	146	466	513	QVL54756.1 MAG: hypothetical protein KFB95_05390 [Simkaniaceae bacterium]	diamond	459	79	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae 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);;