metadata: contig_metadata: 6 rows where bioproject = "PRJNA515078", tax_clade = "PVC group" and tax

6 rows where bioproject = "PRJNA515078", 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
10039459	10039459	PRJNA515078_P_NODE_11208_length_268_cov_1.337662_g10975_i0	PRJNA515078	11208	268	1.337662	3.58493416	Waddliaceae bacterium	2026802	Bacteria	Bacteria	141	1.11e-38	NR	HEY4831209.1	2026802	g10975	i0	75.3	0.996268656716418	89	22	99.6	0	1	267	29	117	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	267	141	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
26633967	26633967	PRJNA515078_P_NODE_34301_length_150_cov_2.070796_g34068_i0	PRJNA515078	34301	150	2.070796	3.106194	Waddlia chondrophila	71667	Bacteria	Bacteria	46.2	6.07e-4	NR	WP_013181660.1	71667	g34068	i0	42.9	2.94	49	25	98	1	149	3	111	156	WP_013181660.1 zinc-binding dehydrogenase [Waddlia chondrophila]	diamond	441	46.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
29035336	29035336	PRJNA515078_P_NODE_8728_length_309_cov_2.073529_g8495_i0	PRJNA515078	8728	309	2.073529	6.40720461	Candidatus Rhabdochlamydia sp.	2320511	Bacteria	Bacteria	110	9.31e-27	NR	MFI0477794.1	2320511	g8495	i0	51.9	1.02912621359223	106	47	99	2	3	308	146	251	MFI0477794.1 RNA ligase family protein [Candidatus Rhabdochlamydia sp.]	diamond	318	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia sp.
29082136	29082136	PRJNA515078_P_NODE_13068_length_245_cov_1.495192_g12835_i0	PRJNA515078	13068	245	1.495192	3.6632204	Bacteria	2	Bacteria	Bacteria	122	5.979999999999999e-31	NR	HRD56046.1	2052176	g12835	i0	68.2	4.10204081632653	85	21	96.7	1	245	9	80	164	HRD56046.1 arginine--tRNA ligase [Parachlamydiaceae bacterium]	diamond	1005	123	0.991869918699187	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
29476838	29476838	PRJNA515078_P_NODE_7090_length_350_cov_2.536741_g6857_i0	PRJNA515078	7090	350	2.536741	8.8785935	Chlamydiota bacterium	2081524	Bacteria	Bacteria	44.3	0.0308	NR	MEI6242079.1	2081524	g6857	i0	32.8	0.574285714285714	67	44	57.4	1	14	214	225	290	MEI6242079.1 S1/P1 nuclease [Chlamydiota bacterium]	diamond	201	44.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32068589	32068589	PRJNA515078_P_NODE_28838_length_162_cov_1.832000_g28605_i0	PRJNA515078	28838	162	1.832	2.96784	Waddliaceae bacterium	2026802	Bacteria	Bacteria	51.2	1.22e-5	NR	HEY4831209.1	2026802	g28605	i0	46	0.925925925925926	50	27	92.6	0	3	152	290	339	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	150	51.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);;