metadata: contig_metadata: 14 rows where bioproject = "PRJNA436017" and tax

14 rows where bioproject = "PRJNA436017" 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
3640093	3640093	PRJNA436017_P_NODE_22683_length_171_cov_2.119403_g22385_i0	PRJNA436017	22683	171	2.119403	3.62417913	Candidatus Protochlamydia	282132	Bacteria	Bacteria	278	2.17e-70	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g22385	i0	95.906	215.59649122807	171	7	100	0	1	171	1250886	1250716	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	36867	278	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
6192034	6192034	PRJNA436017_P_NODE_13465_length_228_cov_2.874346_g13167_i0	PRJNA436017	13465	228	2.874346	6.55350888	Pseudomonadati	3379134	Bacteria	Bacteria	363	8.269999999999999e-96	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g13167	i0	95.575	164.833333333333	226	10	99	0	1	226	1018267	1018042	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	37582	363	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
10017199	10017199	PRJNA436017_P_NODE_3468_length_502_cov_4.881720_g3187_i0	PRJNA436017	3468	502	4.88172	24.5062344	Chlamydiia	204429	Bacteria	Bacteria	610	6.4599999999999996e-170	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g3187	i0	88.934	183.03187250996	497	51	99	4	1	495	2363921	2364415	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	91882	614	0.993485342019544	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
11909743	11909743	PRJNA436017_P_NODE_4770_length_419_cov_4.604712_g4474_i0	PRJNA436017	4770	419	4.604712	19.29374328	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	640	6.769999999999999e-179	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g4474	i0	94.272	159.847255369928	419	22	99	2	2	419	2361202	2361619	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	66976	640	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
13184621	13184621	PRJNA436017_P_NODE_451_length_1268_cov_5.787165_g371_i0	PRJNA436017	451	1268	5.787165	73.3812522	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	1598	0	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g371	i0	89.737	126.126971608833	1257	119	99	10	10	1261	2362519	2363770	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	159929	1598	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
13842560	13842560	PRJNA436017_P_NODE_22691_length_171_cov_1.985075_g22393_i0	PRJNA436017	22691	171	1.985075	3.39447825	Chlamydiia	204429	Bacteria	Bacteria	148	1.78e-31	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g22393	i0	82.558	135.046783625731	172	26	100	4	1	171	574	742	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	23093	148	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
15733557	15733557	PRJNA436017_P_NODE_373_length_1357_cov_8.090152_g127_i3	PRJNA436017	373	1357	8.090152	109.78336264000001	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	1339	0	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g127	i3	92.537	90.6610169491525	938	64	69	6	422	1357	2363978	2363045	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	123027	1339	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
15733601	15733601	PRJNA436017_P_NODE_6373_length_354_cov_3.173502_g6077_i0	PRJNA436017	6373	354	3.173502	11.23419708	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	499	9.95e-137	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g6077	i0	92.09	182.158192090395	354	28	100	0	1	354	1250799	1250446	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	64484	499	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
15733607	15733607	PRJNA436017_P_NODE_6593_length_348_cov_5.475884_g6296_i0	PRJNA436017	6593	348	5.475884	19.05607632	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	425	1.69e-114	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g6296	i0	89.017	140.229885057471	346	35	99	2	5	348	792373	792029	Neochlamydia sp. S13 DNA, complete genome	blastn	48800	425	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
20215206	20215206	PRJNA436017_P_NODE_13756_length_225_cov_3.000000_g13458_i0	PRJNA436017	13756	225	3	6.75	Parachlamydia	83551	Bacteria	Bacteria	294	3.01e-75	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g13458	i0	90.308	134.773333333333	227	19	100	2	1	225	1055	830	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	30324	294	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
22765909	22765909	PRJNA436017_P_NODE_10378_length_267_cov_3.186957_g10080_i0	PRJNA436017	10378	267	3.186957	8.50917519	Candidatus Protochlamydia	282132	Bacteria	Bacteria	313	1.02e-80	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g10080	i0	88.104	141.022471910112	269	24	99	7	2	267	1251315	1251052	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	37653	313	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
22766050	22766050	PRJNA436017_P_NODE_4598_length_429_cov_5.647959_g4302_i0	PRJNA436017	4598	429	5.647959	24.22974411	Candidatus Protochlamydia	282132	Bacteria	Bacteria	693	0	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g4302	i0	95.814	164.331002331002	430	16	100	2	1	429	1250299	1250727	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	70498	693	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
23383148	23383148	PRJNA436017_P_NODE_3379_length_509_cov_5.781780_g3100_i0	PRJNA436017	3379	509	5.78178	29.4292602	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	669	0	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g3100	i0	90.392	404.471512770138	510	47	100	2	1	509	2363921	2364429	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	205876	669	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
27771016	27771016	PRJNA436017_P_NODE_18904_length_188_cov_2.013245_g18606_i0	PRJNA436017	18904	188	2.013245	3.7849006	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	54.7	2.58e-8	NR	MBS4163025.1	362787	g18606	i0	68.6	0.558510638297872	35	11	55.9	0	107	3	4	38	MBS4163025.1 hypothetical protein [Candidatus Protochlamydia amoebophila]	diamond	105	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila

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