metadata: contig_metadata: 8 rows where bioproject = "PRJNA1078753", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA1078753", 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
27035837	27035837	PRJNA1078753_P_NODE_10962_length_344_cov_1.505535_g10766_i0	PRJNA1078753	10962	344	1.505535	5.1790404	Chlamydiales bacterium	2047757	Bacteria	Bacteria	107	1.7999999999999997e-24	NR	MFT5319030.1	2047757	g10766	i0	55.9	0.811046511627907	93	39	81.1	1	282	4	14	104	MFT5319030.1 5-histidylcysteine sulfoxide synthase/putative 4-mercaptohistidine N1-methyltransferase [Chlamydiales bacterium]	diamond	279	107	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27035865	27035865	PRJNA1078753_P_NODE_8462_length_378_cov_1.009836_g8266_i0	PRJNA1078753	8462	378	1.009836	3.81718008	Candidatus Protochlamydia sp.	2687294	Bacteria	Bacteria	216	2.3999999999999996e-69	NR	MBA2368468.1	2687294	g8266	i0	79	0.984126984126984	124	26	98.4	0	7	378	48	171	MBA2368468.1 hypothetical protein [Candidatus Protochlamydia sp.]	diamond	372	216	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp.
27541515	27541515	PRJNA1078753_P_NODE_34084_length_247_cov_0.885057_g33888_i0	PRJNA1078753	34084	247	0.885057	2.18609079	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	46.2	0.00237	NR	MCK4934525.1	2698248	g33888	i0	33.3	0.983805668016194	81	51	98.4	1	247	5	190	267	MCK4934525.1 sel1 repeat family protein [Simkaniaceae bacterium]	diamond	243	46.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
28457215	28457215	PRJNA1078753_P_NODE_8826_length_372_cov_1.505017_g8630_i0	PRJNA1078753	8826	372	1.505017	5.59866324	Chlamydiales bacterium	2047757	Bacteria	Bacteria	147	2.21e-42	NR	MCP5470421.1	2047757	g8630	i0	60.4	1.79032258064516	111	44	89.5	0	40	372	1	111	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	666	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28646614	28646614	PRJNA1078753_P_NODE_18147_length_286_cov_1.446009_g17951_i0	PRJNA1078753	18147	286	1.446009	4.13558574	Waddliaceae bacterium	2026802	Bacteria	Bacteria	55.5	2.05e-6	NR	HEY4832829.1	2026802	g17951	i0	52.3	0.461538461538462	44	21	46.2	0	139	8	131	174	HEY4832829.1 hypothetical protein [Waddliaceae bacterium]	diamond	132	55.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
29774496	29774496	PRJNA1078753_P_NODE_11771_length_335_cov_1.763359_g11575_i0	PRJNA1078753	11771	335	1.763359	5.90725265	Bacteria	2	Bacteria	Bacteria	181	9.989999999999999e-54	NR	WP_237559247.1	340071	g11575	i0	76.6	5.95522388059702	111	26	99.4	0	334	2	53	163	WP_237559247.1 PLP-dependent cysteine synthase family protein [Criblamydia sequanensis]	diamond	1995	181	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
30130297	30130297	PRJNA1078753_P_NODE_18192_length_286_cov_1.399061_g17996_i0	PRJNA1078753	18192	286	1.399061	4.00131446	Chlamydiales bacterium	2047757	Bacteria	Bacteria	46.2	0.00315	NR	HEV7738100.1	2047757	g17996	i0	42.2	1.34265734265734	45	26	47.2	0	154	20	182	226	HEV7738100.1 tyrosine--tRNA ligase [Chlamydiales bacterium]	diamond	384	46.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32817100	32817100	PRJNA1078753_P_NODE_21180_length_273_cov_2.310000_g20984_i0	PRJNA1078753	21180	273	2.31	6.3063	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	126	1.0699999999999999e-31	NR	QVL54756.1	2698248	g20984	i0	64.4	1.97802197802198	90	32	98.9	0	3	272	396	485	QVL54756.1 MAG: hypothetical protein KFB95_05390 [Simkaniaceae bacterium]	diamond	540	126	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae 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);;