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

14 rows where bioproject = "PRJNA1009807" 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
1001387	1001387	PRJNA1009807_S_NODE_2101_length_214_cov_8.097143_g2073_i0	PRJNA1009807	2101	214	8.097143	17.32788602	Candidatus Protochlamydia	282132	Bacteria	Bacteria	368	1.65e-97	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g2073	i0	97.664	81.1588785046729	214	5	100	0	1	214	1250437	1250650	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	17368	368	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
3551959	3551959	PRJNA1009807_S_NODE_2403_length_203_cov_2.195122_g2375_i0	PRJNA1009807	2403	203	2.195122	4.45609766	Candidatus Protochlamydia	282132	Bacteria	Bacteria	265	2.09e-66	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g2375	i0	90.148	36.7142857142857	203	20	100	0	1	203	1250165	1249963	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	7453	265	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
3551966	3551966	PRJNA1009807_S_NODE_303_length_489_cov_6.688889_g276_i0	PRJNA1009807	303	489	6.688889	32.70866721	Candidatus Protochlamydia	282132	Bacteria	Bacteria	532	1.3999999999999996e-146	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g276	i0	86.437	116.883435582822	494	57	100	9	1	489	1250927	1250439	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	57156	532	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
3981222	3981222	PRJNA1009807_S_NODE_1644_length_238_cov_9.502513_g1616_i0	PRJNA1009807	1644	238	9.502513	22.61598094	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	348	2.4300000000000005e-91	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1616	i0	92.946	143.483193277311	241	13	100	4	1	238	2059360	2059599	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	34149	348	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
7807366	7807366	PRJNA1009807_S_NODE_3427_length_175_cov_9.830882_g3399_i0	PRJNA1009807	3427	175	9.830882	17.2040435	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	219	1.37e-52	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3399	i0	89.205	93.0114285714286	176	17	100	2	1	175	655056	654882	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	16277	219	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
7807387	7807387	PRJNA1009807_S_NODE_607_length_370_cov_28.287009_g579_i0	PRJNA1009807	607	370	28.287009	104.6619333	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	549	1.0199999999999994e-151	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g579	i0	93.496	194.651351351351	369	24	99	0	2	370	836199	835831	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	72021	549	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
9082263	9082263	PRJNA1009807_S_NODE_108_length_717_cov_7.874631_g56_i2	PRJNA1009807	108	717	7.874631	56.46110427	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	968	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g56	i2	91.123	183.850767085077	721	55	100	6	1	717	653694	654409	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	131821	968	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
10357919	10357919	PRJNA1009807_S_NODE_189_length_584_cov_29.860550_g168_i0	PRJNA1009807	189	584	29.86055	174.385612	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	898	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g168	i0	94.521	175.85102739726	584	28	100	3	1	584	654339	654918	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	102697	898	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
13754824	13754824	PRJNA1009807_S_NODE_71_length_864_cov_12.041212_g56_i0	PRJNA1009807	71	864	12.041212	104.03607168	Candidatus Protochlamydia	282132	Bacteria	Bacteria	1086	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g56	i0	89.45	174.283564814815	872	77	100	13	1	864	1250063	1250927	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	150581	1096	0.990875912408759	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14183486	14183486	PRJNA1009807_S_NODE_72_length_864_cov_7.277576_g56_i1	PRJNA1009807	72	864	7.277576	62.87825664	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1291	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g56	i1	93.671	148.887731481481	869	46	100	8	1	864	1250063	1250927	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	128639	1291	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
18006576	18006576	PRJNA1009807_S_NODE_535_length_397_cov_17.315642_g507_i0	PRJNA1009807	535	397	17.315642	68.74309874	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	556	6.61e-154	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g507	i0	94.247	164.073047858942	365	20	92	1	34	397	652444	652808	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	65137	556	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19280369	19280369	PRJNA1009807_S_NODE_596_length_374_cov_15.056716_g568_i0	PRJNA1009807	596	374	15.056716	56.31211784	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	516	1.05e-141	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g568	i0	91.689	231.909090909091	373	30	99	1	1	372	1249592	1249220	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	86734	516	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23107103	23107103	PRJNA1009807_S_NODE_2419_length_202_cov_4.042945_g2391_i0	PRJNA1009807	2419	202	4.042945	8.1667489	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	209	9.86e-50	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g2391	i0	85.644	181.50495049505	202	25	99	4	3	202	1249350	1249151	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	36664	209	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23107126	23107126	PRJNA1009807_S_NODE_4639_length_155_cov_8.620690_g4611_i0	PRJNA1009807	4639	155	8.62069	13.3620695	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	145	2.04e-30	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g4611	i0	84.932	202.703225806452	146	19	94	2	11	155	493	636	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	31419	145	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae

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