metadata: contig_metadata: 16 rows where bioproject = "PRJNA520845", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJNA520845", 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
6868581	6868581	PRJNA520845_P_NODE_236526_length_247_cov_0.885057_g235027_i0	PRJNA520845	236526	247	0.885057	2.18609079	Chlamydiales bacterium	2047757	Bacteria	Bacteria	63.9	5.17e-11	NR	MCP5470429.1	2047757	g235027	i0	46.3	0.995951417004049	82	44	99.6	0	247	2	8	89	MCP5470429.1 glutathione S-transferase C-terminal domain-containing protein [Chlamydiales bacterium]	diamond	246	63.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
17066426	17066426	PRJNA520845_P_NODE_176354_length_281_cov_0.932692_g174855_i0	PRJNA520845	176354	281	0.932692	2.62086452	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	449	7.86e-122	NTclustered	gi\|1590092048\|gb\|MK616426.1\|	305355	g174855	i0	95.699	112.523131672598	279	12	99	0	3	281	584	306	Uncultured Chlamydiae bacterium clone LG126_2 16S ribosomal RNA gene, partial sequence	blastn	31619	449	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
27362050	27362050	PRJNA520845_P_NODE_76983_length_423_cov_1.760000_g75484_i0	PRJNA520845	76983	423	1.76	7.4448	Chlamydiales bacterium	2047757	Bacteria	Bacteria	213	2.02e-68	NR	MCP5470420.1	2047757	g75484	i0	78	1	141	31	100	0	423	1	3	143	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	423	213	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28087839	28087839	PRJNA520845_P_NODE_234745_length_247_cov_0.885057_g233246_i0	PRJNA520845	234745	247	0.885057	2.18609079	Chlamydiota bacterium	2081524	Bacteria	Bacteria	51.6	2.96e-5	NR	MCI0381486.1	2081524	g233246	i0	35	1.95546558704453	80	49	97.2	1	5	244	250	326	MCI0381486.1 hypothetical protein [Chlamydiota bacterium]	diamond	483	51.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28561704	28561704	PRJNA520845_P_NODE_21727_length_830_cov_3.236460_g20407_i0	PRJNA520845	21727	830	3.23646	26.862618	Simkania sp.	34094	Bacteria	Bacteria	172	4.34e-50	NR	MCB1084326.1	34094	g20407	i0	75.8	0.357831325301205	99	24	35.8	0	828	532	41	139	MCB1084326.1 serine/threonine-protein kinase [Simkania sp.]	diamond	297	172	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28624989	28624989	PRJNA520845_P_NODE_57807_length_490_cov_9.443645_g56312_i0	PRJNA520845	57807	490	9.443645	46.2738605	Chlamydiales bacterium	2047757	Bacteria	Bacteria	270	1.37e-90	NR	MCP5470421.1	2047757	g56312	i0	82.3	0.96734693877551	158	28	96.7	0	485	12	1	158	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	474	270	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28734807	28734807	PRJNA520845_P_NODE_170607_length_285_cov_1.415094_g169108_i0	PRJNA520845	170607	285	1.415094	4.0330179	root	1	Root_unresolved	Root_unresolved	127	7.79e-33	NR	MCB1084282.1	34094	g169108	i0	61.1	3.03157894736842	95	36	98.9	1	2	283	314	408	MCB1084282.1 hypothetical protein [Simkania sp.]	diamond	864	128	0.9921875	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28877229	28877229	PRJNA520845_P_NODE_17248_length_935_cov_3.677494_g16046_i0	PRJNA520845	17248	935	3.677494	34.3845689	Simkania sp.	34094	Bacteria	Bacteria	257	1.48e-81	NR	MCB1084310.1	34094	g16046	i0	74.7	0.545454545454545	170	43	54.5	0	260	769	1	170	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	510	257	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30519579	30519579	PRJNA520845_P_NODE_165973_length_289_cov_1.111111_g164474_i0	PRJNA520845	165973	289	1.111111	3.21111079	Chlamydiota bacterium	2081524	Bacteria	Bacteria	45.8	0.00473	NR	NGX43355.1	2081524	g164474	i0	37.9	1.39100346020761	58	35	60.2	1	25	198	38	94	NGX43355.1 hypothetical protein [Chlamydiota bacterium]	diamond	402	45.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30597984	30597984	PRJNA520845_P_NODE_203313_length_259_cov_1.241935_g201814_i0	PRJNA520845	203313	259	1.241935	3.21661165	Chlamydia	810	Bacteria	Bacteria	49.3	2.08e-4	NR	WP_291892020.1	35827	g201814	i0	35.8	1.54054054054054	67	41	75.3	1	196	2	27	93	WP_291892020.1 FAD:protein FMN transferase [Chlamydia sp.]	diamond	399	49.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia sp.
31594504	31594504	PRJNA520845_P_NODE_242276_length_246_cov_0.890173_g240777_i0	PRJNA520845	242276	246	0.890173	2.18982558	Chlamydiota bacterium	2081524	Bacteria	Bacteria	132	4e-35	NR	MCX6995221.1	2081524	g240777	i0	71.6	6.89024390243902	81	23	98.8	0	244	2	180	260	MCX6995221.1 dehypoxanthine futalosine cyclase [Chlamydiota bacterium]	diamond	1695	132	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31878783	31878783	PRJNA520845_P_NODE_238377_length_246_cov_1.647399_g236878_i0	PRJNA520845	238377	246	1.647399	4.05260154	Simkania sp.	34094	Bacteria	Bacteria	57	1.11e-8	NR	MCB1084368.1	34094	g236878	i0	69.4	0.439024390243902	36	11	43.9	0	236	129	29	64	MCB1084368.1 hypothetical protein [Simkania sp.]	diamond	108	57	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
31925866	31925866	PRJNA520845_P_NODE_205297_length_257_cov_1.673913_g203798_i0	PRJNA520845	205297	257	1.673913	4.30195641	Chlamydia	810	Bacteria	Bacteria	53.9	1.39e-7	NR	EPJ29149.1	1112251	g203798	i0	61.7	1.09727626459144	47	14	53.7	2	13	150	3	46	EPJ29149.1 hypothetical protein CP99DC5_1170, partial [Chlamydia psittaci 99DC5]	diamond	282	53.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
32195351	32195351	PRJNA520845_P_NODE_152458_length_302_cov_1.362445_g150959_i0	PRJNA520845	152458	302	1.362445	4.1145839	Chlamydiota bacterium	2081524	Bacteria	Bacteria	49.7	2.51e-4	NR	MBM3191511.1	2081524	g150959	i0	33	0.963576158940397	97	55	96.4	2	9	299	190	276	MBM3191511.1 methyltransferase domain-containing protein [Chlamydiota bacterium]	diamond	291	49.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32259048	32259048	PRJNA520845_P_NODE_70418_length_443_cov_1.456757_g68919_i0	PRJNA520845	70418	443	1.456757	6.45343351	Simkania sp.	34094	Bacteria	Bacteria	72.8	1.51e-12	NR	MCB1084431.1	34094	g68919	i0	55.4	0.440180586907449	65	29	44	0	252	58	11	75	MCB1084431.1 hypothetical protein [Simkania sp.]	diamond	195	72.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
32575295	32575295	PRJNA520845_P_NODE_50619_length_525_cov_9.243363_g49127_i0	PRJNA520845	50619	525	9.243363	48.52765575	Chlamydiales bacterium	2047757	Bacteria	Bacteria	215	1.33e-68	NR	MCP5470420.1	2047757	g49127	i0	79.6	0.84	147	28	84	1	4	444	1	145	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	441	215	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;