metadata: contig_metadata: 15 rows where bioproject = "PRJNA557436", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJNA557436", 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_species
26649586	26649586	PRJNA557436_S_NODE_4521_length_191_cov_1.147436_g4473_i0	PRJNA557436	4521	191	1.147436	2.19160276	Pseudomonadati	3379134	Bacteria	Bacteria	91.7	2.96e-21	NR	HNA61994.1	2047756	g4473	i0	66.7	4.83769633507853	63	20	97.4	1	5	190	85	147	HNA61994.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	924	91.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Rhabdochlamydiaceae bacterium
27015495	27015495	PRJNA557436_S_NODE_9182_length_152_cov_1.102564_g9134_i0	PRJNA557436	9182	152	1.102564	1.67589728	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	75.9	2.22e-14	NR	HNA61487.1	2047756	g9134	i0	63.3	1.93421052631579	49	18	96.7	0	152	6	219	267	HNA61487.1 bifunctional DNA primase/polymerase [Rhabdochlamydiaceae bacterium]	diamond	294	75.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Rhabdochlamydiaceae bacterium
27268447	27268447	PRJNA557436_S_NODE_8763_length_153_cov_3.101695_g8715_i0	PRJNA557436	8763	153	3.101695	4.74559335	Chlamydiota bacterium	2081524	Bacteria	Bacteria	71.2	7.61e-13	NR	MBM3194158.1	2081524	g8715	i0	60	0.980392156862745	50	20	98	0	151	2	175	224	MBM3194158.1 hypothetical protein [Chlamydiota bacterium]	diamond	150	71.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
28026476	28026476	PRJNA557436_S_NODE_3205_length_217_cov_2.417582_g3157_i0	PRJNA557436	3205	217	2.417582	5.24615294	Chlamydiota bacterium	2081524	Bacteria	Bacteria	72.8	6.51e-13	NR	MBM3194286.1	2081524	g3157	i0	50.8	0.84331797235023	61	29	84.3	1	185	3	67	126	MBM3194286.1 hypothetical protein [Chlamydiota bacterium]	diamond	183	72.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
28847122	28847122	PRJNA557436_S_NODE_2048_length_261_cov_2.553097_g2000_i0	PRJNA557436	2048	261	2.553097	6.66358317	Chlamydiota bacterium	2081524	Bacteria	Bacteria	45.4	0.001	NR	MBM3194167.1	2081524	g2000	i0	43.5	0.528735632183908	46	26	52.9	0	141	4	1	46	MBM3194167.1 hypothetical protein [Chlamydiota bacterium]	diamond	138	45.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
28910137	28910137	PRJNA557436_S_NODE_2988_length_223_cov_2.367021_g2940_i0	PRJNA557436	2988	223	2.367021	5.27845683	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	153	1.38e-44	NR	MFI0436135.1	2052176	g2940	i0	100	0.968609865470852	72	0	96.9	0	2	217	42	113	MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium]	diamond	216	153	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydiaceae bacterium
29194805	29194805	PRJNA557436_S_NODE_8009_length_157_cov_3.704918_g7961_i0	PRJNA557436	8009	157	3.704918	5.81672126	Chlamydiota bacterium	2081524	Bacteria	Bacteria	58.5	2.49e-8	NR	MBM3194339.1	2081524	g7961	i0	52.1	1.91082802547771	48	23	91.7	0	14	157	83	130	MBM3194339.1 hypothetical protein [Chlamydiota bacterium]	diamond	300	58.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
30141597	30141597	PRJNA557436_S_NODE_6012_length_173_cov_1.246377_g5964_i0	PRJNA557436	6012	173	1.246377	2.15623221	Chlamydiae bacterium GWF2_49_8	1797597	Bacteria	Bacteria	46.6	2.13e-4	NR	OGN54068.1	1797597	g5964	i0	37.5	0.971098265895954	56	35	97.1	0	173	6	67	122	OGN54068.1 MAG: hypothetical protein A2098_02700 [Chlamydiae bacterium GWF2_49_8]	diamond	168	46.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiae bacterium GWF2_49_8
30204946	30204946	PRJNA557436_S_NODE_6892_length_165_cov_1.653846_g6844_i0	PRJNA557436	6892	165	1.653846	2.7288459	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	56.6	4.03e-8	NR	HEY5234710.1	2047756	g6844	i0	82.8	3.78181818181818	29	4	52.7	1	12	98	122	149	HEY5234710.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	624	56.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Rhabdochlamydiaceae bacterium
30426821	30426821	PRJNA557436_S_NODE_6033_length_172_cov_2.897810_g5985_i0	PRJNA557436	6033	172	2.89781	4.9842332	Chlamydiota bacterium	2081524	Bacteria	Bacteria	84	1.19e-19	NR	NBO24810.1	2081524	g5985	i0	64.3	0.976744186046512	56	20	97.7	0	3	170	4	59	NBO24810.1 hypothetical protein [Chlamydiota bacterium]	diamond	168	84	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
30521131	30521131	PRJNA557436_S_NODE_1573_length_295_cov_1.776923_g1525_i0	PRJNA557436	1573	295	1.776923	5.24192285	Chlamydiota bacterium	2081524	Bacteria	Bacteria	86.3	1.89e-18	NR	NDD59068.1	2081524	g1525	i0	52.8	0.905084745762712	89	32	90.5	2	290	24	99	177	NDD59068.1 hypothetical protein [Chlamydiota bacterium]	diamond	267	86.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
30710699	30710699	PRJNA557436_S_NODE_94_length_1052_cov_2.395280_g76_i0	PRJNA557436	94	1052	2.39528	25.1983456	Chlamydiota bacterium	2081524	Bacteria	Bacteria	247	8.42e-77	NR	MBM3194280.1	2081524	g76	i0	43.2	0.832699619771863	292	129	83.3	3	2	877	17	271	MBM3194280.1 PD-(D/E)XK nuclease family protein [Chlamydiota bacterium]	diamond	876	247	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
30805551	30805551	PRJNA557436_S_NODE_2594_length_236_cov_2.109453_g2546_i0	PRJNA557436	2594	236	2.109453	4.97830908	Chlamydiota bacterium	2081524	Bacteria	Bacteria	99.8	1.39e-22	NR	MBM3194281.1	2081524	g2546	i0	59.7	0.978813559322034	77	31	97.9	0	4	234	296	372	MBM3194281.1 glycosyltransferase [Chlamydiota bacterium]	diamond	231	99.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
31058641	31058641	PRJNA557436_S_NODE_295_length_629_cov_3.003367_g257_i0	PRJNA557436	295	629	3.003367	18.89117843	Chlamydiota bacterium	2081524	Bacteria	Bacteria	65.1	1.92e-8	NR	MBM3194336.1	2081524	g257	i0	36.9	0.491255961844197	103	64	49.1	1	285	593	1	102	MBM3194336.1 hypothetical protein [Chlamydiota bacterium]	diamond	309	65.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
32418477	32418477	PRJNA557436_S_NODE_499_length_500_cov_2.963441_g451_i0	PRJNA557436	499	500	2.963441	14.817205	Chlamydiota bacterium	2081524	Bacteria	Bacteria	122	8.32e-31	NR	MBM3194173.1	2081524	g451	i0	54.5	0.66	110	50	66	0	167	496	5	114	MBM3194173.1 hypothetical protein [Chlamydiota bacterium]	diamond	330	122	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota 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);;