metadata: contig_metadata: 26 rows where bioproject = "PRJEB3181", tax_clade = "PVC group" and tax

26 rows where bioproject = "PRJEB3181", tax_clade = "PVC group" 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
55960	55960	PRJEB3181_P_NODE_18161_length_194_cov_4.484663_g17897_i0	PRJEB3181	18161	194	4.484663	8.70024622	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	309	9e-80	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g17897	i0	95.361	2.72164948453608	194	9	100	0	1	194	2276514	2276321	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	528	309	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
2605943	2605943	PRJEB3181_P_NODE_5883_length_339_cov_3.152597_g5627_i0	PRJEB3181	5883	339	3.152597	10.68730383	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	577	4.2699999999999996e-160	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g5627	i0	97.345	2.023598820059	339	9	100	0	1	339	2024738	2025076	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	686	577	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
3882102	3882102	PRJEB3181_P_NODE_4404_length_377_cov_6.895954_g4156_i0	PRJEB3181	4404	377	6.895954	25.99774658	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	590	6.15e-164	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g4156	i0	94.947	1.98143236074271	376	19	99	0	2	377	2281070	2281445	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	747	590	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
6434171	6434171	PRJEB3181_P_NODE_2786_length_439_cov_18.573529_g2576_i0	PRJEB3181	2786	439	18.573529	81.53779231	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	726	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g2576	i0	99.5	61.6651480637813	400	1	91	1	41	439	2474985	2475384	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	27071	726	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
7708210	7708210	PRJEB3181_P_NODE_17387_length_199_cov_3.125000_g17123_i0	PRJEB3181	17387	199	3.125	6.21875	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	259	9.48e-65	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g17123	i0	91	1.00502512562814	200	7	100	4	1	199	2642648	2642459	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	200	259	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8983018	8983018	PRJEB3181_P_NODE_13828_length_227_cov_2.709184_g13564_i0	PRJEB3181	13828	227	2.709184	6.14984768	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	351	1.78e-92	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g13564	i0	95.475	0.973568281938326	221	9	97	1	7	227	2456619	2456838	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	221	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
11534113	11534113	PRJEB3181_P_NODE_14150_length_224_cov_3.414508_g13886_i0	PRJEB3181	14150	224	3.414508	7.64849792	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	326	1.06e-84	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g13886	i0	92.889	1.00446428571429	225	15	100	1	1	224	339315	339091	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	225	326	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
11534115	11534115	PRJEB3181_P_NODE_1530_length_525_cov_5.163968_g1369_i0	PRJEB3181	1530	525	5.163968	27.110832	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	839	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1369	i0	95.602	1.99428571428571	523	23	99	0	3	525	1752008	1751486	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	1047	839	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
11534140	11534140	PRJEB3181_P_NODE_23070_length_169_cov_2.507246_g22805_i0	PRJEB3181	23070	169	2.507246	4.23724574	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g22805	i0	99.408	2.00591715976331	169	1	100	0	1	169	261075	261243	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	339	307	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
13742296	13742296	PRJEB3181_P_NODE_15491_length_213_cov_4.758242_g15227_i0	PRJEB3181	15491	213	4.758242	10.13505546	Chlamydia	810	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2160142209\|gb\|CP042670.1\|	813	g15227	i0	96.97	3.71830985915493	33	1	15	0	108	140	76097	76129	Chlamydia trachomatis strain TC0080-IGR-TC0081::TncL2/tetR-4243 chromosome, complete genome	blastn	792	56.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
14084204	14084204	PRJEB3181_P_NODE_13932_length_226_cov_3.061538_g13668_i0	PRJEB3181	13932	226	3.061538	6.91907588	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	339	1.3799999999999998e-88	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g13668	i0	95.735	0.933628318584071	211	7	92	2	14	222	170131	170341	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	211	339	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14084215	14084215	PRJEB3181_P_NODE_15472_length_213_cov_8.170330_g15208_i0	PRJEB3181	15472	213	8.17033	17.4028029	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	246	8.01e-61	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g15208	i0	87.963	1.01408450704225	216	16	100	7	1	213	386717	386925	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	216	246	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14084233	14084233	PRJEB3181_P_NODE_212_length_988_cov_4.402299_g162_i0	PRJEB3181	212	988	4.402299	43.49471412	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1251	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g162	i0	97.541	102.047570850202	732	16	98	2	246	975	1250219	1250950	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	100823	1251	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14084273	14084273	PRJEB3181_P_NODE_4872_length_363_cov_125.632530_g4623_i0	PRJEB3181	4872	363	125.63253	456.0460839	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	625	1.6199999999999994e-174	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g4623	i0	99.707	122.247933884298	341	1	94	0	1	341	1248957	1249297	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	44376	625	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14084295	14084295	PRJEB3181_P_NODE_7572_length_306_cov_2.720000_g7311_i0	PRJEB3181	7572	306	2.72	8.3232	Candidatus Protochlamydia sp. W-9	1785087	Bacteria	Bacteria	107	1.58e-24	NR	WP_075882638.1	1785087	g7311	i0	98.3	0.568627450980392	58	1	56.9	0	176	3	331	388	WP_075882638.1 chaperonin GroEL [Candidatus Protochlamydia sp. W-9]	diamond	174	107	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
15358071	15358071	PRJEB3181_P_NODE_16613_length_205_cov_1.419540_g16349_i0	PRJEB3181	16613	205	1.41954	2.910057	Parachlamydiaceae	92713	Bacteria	Bacteria	112	3.31e-27	NR	WP_075882638.1	1785087	g16349	i0	96.6	3.45365853658537	59	2	86.3	0	179	3	1	59	WP_075882638.1 chaperonin GroEL [Candidatus Protochlamydia sp. W-9]	diamond	708	113	0.991150442477876	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
17907591	17907591	PRJEB3181_P_NODE_25435_length_159_cov_6.867188_g25170_i0	PRJEB3181	25435	159	6.867188	10.91882892	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	183	4.469999999999999e-42	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g25170	i0	92.857	163.213836477987	126	9	79	0	28	153	2364308	2364433	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	25951	183	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
19181353	19181353	PRJEB3181_P_NODE_10616_length_260_cov_30.336245_g10352_i0	PRJEB3181	10616	260	30.336245	78.874237	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	459	1.19e-124	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g10352	i0	98.462	329.084615384615	260	4	100	0	1	260	1249583	1249324	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	85562	459	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
19181587	19181587	PRJEB3181_S_NODE_4276_length_286_cov_25721.358566_g3983_i0	PRJEB3181	4276	286	25721.358566	73563.08549876	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	411	3.789999999999999e-110	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g3983	i0	99.123	153.076923076923	228	2	80	0	59	286	1249297	1249070	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	43780	411	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
20456748	20456748	PRJEB3181_P_NODE_20497_length_181_cov_2.146667_g20233_i0	PRJEB3181	20497	181	2.146667	3.88546727	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	315	1.78e-81	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g20233	i0	100	137.801104972376	170	0	94	0	12	181	1251510	1251341	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	24942	315	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23008060	23008060	PRJEB3181_P_NODE_8919_length_284_cov_4.620553_g8655_i0	PRJEB3181	8919	284	4.620553	13.12237052	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	222	1.89e-53	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g8655	i0	81.949	0.975352112676056	277	37	95	10	1	271	2613801	2613532	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	277	222	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23008221	23008221	PRJEB3181_S_NODE_9199_length_208_cov_731.479769_g8906_i0	PRJEB3181	9199	208	731.479769	1521.47791952	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	302	1.6400000000000001e-77	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g8906	i0	96.196	1.74519230769231	184	7	88	0	25	208	2281070	2281253	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	363	302	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
24281812	24281812	PRJEB3181_P_NODE_9660_length_273_cov_2.933884_g9396_i0	PRJEB3181	9660	273	2.933884	8.00950332	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	246	1.0699999999999999e-60	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g9396	i0	87.156	0.798534798534799	218	26	79	2	48	264	430542	430326	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	218	246	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26780221	26780221	PRJEB3181_S_NODE_2741_length_334_cov_4.083612_g2448_i0	PRJEB3181	2741	334	4.083612	13.63926408	Chlamydiales bacterium	2047757	Bacteria	Bacteria	85.1	3e-18	NR	MCP5470420.1	2047757	g2448	i0	73.3	0.673652694610778	75	20	67.4	0	46	270	81	155	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	225	85.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31834759	31834759	PRJEB3181_P_NODE_26017_length_157_cov_3.960317_g25752_i0	PRJEB3181	26017	157	3.960317	6.21769769	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	91.7	6.69e-20	NR	WP_079992857.1	389348	g25752	i0	84.3	0.974522292993631	51	8	97.5	0	154	2	474	524	WP_079992857.1 His/Gly/Thr/Pro-type tRNA ligase C-terminal domain-containing protein [Candidatus Protochlamydia naegleriophila]	diamond	153	91.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
32309843	32309843	PRJEB3181_P_NODE_20419_length_181_cov_4.566667_g20155_i0	PRJEB3181	20419	181	4.566667	8.26566727	Waddliaceae bacterium	2026802	Bacteria	Bacteria	73.2	1.01e-14	NR	HEY4831554.1	2026802	g20155	i0	57.6	0.977900552486188	59	19	87.8	1	159	1	41	99	HEY4831554.1 BON domain-containing protein [Waddliaceae bacterium]	diamond	177	73.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae 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);;