metadata: contig_metadata: 14 rows where bioproject = "PRJNA316313", tax_clade = "PVC group" and tax

14 rows where bioproject = "PRJNA316313", 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
6764792	6764792	PRJNA316313_P_NODE_30526_length_312_cov_4.072727_g29145_i0	PRJNA316313	30526	312	4.072727	12.70690824	Chlamydia psittaci 1	83554	Bacteria	Bacteria	114	7.58e-29	NR	EPP36802.1	1238236	g29145	i0	99	1	104	1	100	0	312	1	5	108	EPP36802.1 hypothetical protein CP10743SC13_1855 [Chlamydia psittaci 10_743_SC13]	diamond	312	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
27232528	27232528	PRJNA316313_P_NODE_288463_length_187_cov_2.506667_g287077_i0	PRJNA316313	288463	187	2.506667	4.68746729	Chlamydiales bacterium	2047757	Bacteria	Bacteria	53.1	3.03e-6	NR	MBN9377168.1	2047757	g287077	i0	45.9	0.978609625668449	61	26	97.9	1	3	185	92	145	MBN9377168.1 DUF4239 domain-containing protein [Chlamydiales bacterium]	diamond	183	53.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27408192	27408192	PRJNA316313_P_NODE_262043_length_187_cov_2.700000_g260657_i0	PRJNA316313	262043	187	2.7	5.049	PVC group	1783257	Bacteria	Bacteria	49.3	6.39e-6	NR	CRH93460.1	813	g260657	i0	92	18.8502673796791	25	2	40.1	0	3	77	36	60	CRH93460.1 PTS-dependent dihydroxyacetone kinase%2C ADP-binding subunit dhaL [Chlamydia trachomatis]	diamond	3525	49.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27502867	27502867	PRJNA316313_P_NODE_439083_length_151_cov_3.982456_g437697_i0	PRJNA316313	439083	151	3.982456	6.01350856	Bacteria	2	Bacteria	Bacteria	52.4	2.6e-6	NR	CQB87088.1	813	g437697	i0	100	0.993377483443709	25	0	49.7	0	3	77	175	199	CQB87088.1 putative 8-amino-7-oxononanoate synthase [Chlamydia trachomatis]	diamond	150	52.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27674974	27674974	PRJNA316313_P_NODE_153584_length_187_cov_4.540000_g152198_i0	PRJNA316313	153584	187	4.54	8.4898	Chlamydia ibidis	1405396	Bacteria	Bacteria	49.3	6.95e-6	NR	EPP35264.1	1405396	g152198	i0	84	0.401069518716578	25	4	40.1	0	1	75	11	35	EPP35264.1 hypothetical protein CP10139811_1531, partial [Chlamydia ibidis]	diamond	75	49.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
28085168	28085168	PRJNA316313_P_NODE_410265_length_151_cov_5.894737_g408879_i0	PRJNA316313	410265	151	5.894737	8.90105287	Chlamydiales bacterium	2047757	Bacteria	Bacteria	64.7	1.25e-10	NR	MBN9378751.1	2047757	g408879	i0	49.3	1.45033112582781	73	12	95.4	1	151	8	100	172	MBN9378751.1 MBL fold metallo-hydrolase [Chlamydiales bacterium]	diamond	219	64.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28779725	28779725	PRJNA316313_P_NODE_403787_length_151_cov_7.289474_g402401_i0	PRJNA316313	403787	151	7.289474	11.00710574	Neochlamydia sp. EPS4	1478175	Bacteria	Bacteria	72	5.03e-13	NR	WP_238579008.1	1478175	g402401	i0	67.3	1.09271523178808	55	12	97.4	1	2	148	790	844	WP_238579008.1 AMP-binding protein [Neochlamydia sp. EPS4]	diamond	165	72	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. EPS4
29158955	29158955	PRJNA316313_P_NODE_500349_length_150_cov_3.433628_g498963_i0	PRJNA316313	500349	150	3.433628	5.150442	Chlamydiales bacterium	2047757	Bacteria	Bacteria	45.1	0.00158	NR	MBN9377312.1	2047757	g498963	i0	88	0.5	25	3	50	0	75	149	593	617	MBN9377312.1 CusA/CzcA family heavy metal efflux RND transporter [Chlamydiales bacterium]	diamond	75	45.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29253243	29253243	PRJNA316313_P_NODE_388629_length_156_cov_2.151261_g387243_i0	PRJNA316313	388629	156	2.151261	3.35596716	Chlamydia ibidis	1405396	Bacteria	Bacteria	87.8	6.4400000000000006e-21	NR	EPP35474.1	1405396	g387243	i0	93	0.826923076923077	43	3	82.7	0	156	28	6	48	EPP35474.1 hypothetical protein CP10139811_1167, partial [Chlamydia ibidis]	diamond	129	87.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
30579827	30579827	PRJNA316313_P_NODE_460153_length_151_cov_3.307018_g458767_i0	PRJNA316313	460153	151	3.307018	4.99359718	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	57.8	5.28e-8	NR	HSW86126.1	2047756	g458767	i0	38	1.98675496688742	100	12	99.3	1	1	150	142	241	HSW86126.1 GMC oxidoreductase [Rhabdochlamydiaceae bacterium]	diamond	300	57.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
30864360	30864360	PRJNA316313_P_NODE_81414_length_221_cov_2.701087_g80028_i0	PRJNA316313	81414	221	2.701087	5.96940227	Chlamydia psittaci 1	83554	Bacteria	Bacteria	48.9	1.83e-5	NR	EPP36608.1	1238236	g80028	i0	91.3	0.312217194570136	23	2	31.2	0	212	144	1	23	EPP36608.1 hypothetical protein CP10743SC13_1857 [Chlamydia psittaci 10_743_SC13]	diamond	69	48.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
31180088	31180088	PRJNA316313_P_NODE_9935_length_536_cov_4.474950_g8701_i0	PRJNA316313	9935	536	4.47495	23.985732	Chlamydia psittaci	83554	Bacteria	Bacteria	76.6	4.3e-15	NR	EPP28701.1	1112246	g8701	i0	57.5	0.408582089552239	73	6	40.9	1	55	273	4	51	EPP28701.1 hypothetical protein CP082626L3_1512, partial [Chlamydia psittaci 08-2626_L3]	diamond	219	76.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
31211534	31211534	PRJNA316313_P_NODE_42775_length_275_cov_4.756303_g41390_i0	PRJNA316313	42775	275	4.756303	13.07983325	Chlamydia psittaci 84-8471/1	1112230	Bacteria	Bacteria	71.6	1.71e-14	NR	EPP38980.1	1112230	g41390	i0	94.3	0.381818181818182	35	2	38.2	0	274	170	12	46	EPP38980.1 hypothetical protein CP8484711_2377, partial [Chlamydia psittaci 84-8471/1]	diamond	105	71.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
31939340	31939340	PRJNA316313_P_NODE_319257_length_187_cov_2.253333_g317871_i0	PRJNA316313	319257	187	2.253333	4.21373271	Parachlamydia sp.	2052048	Bacteria	Bacteria	54.7	1.08e-6	NR	MCE2984111.1	2052048	g317871	i0	92	0.401069518716578	25	2	40.1	0	112	186	316	340	MCE2984111.1 phytoene desaturase family protein [Parachlamydia sp.]	diamond	75	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.

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