metadata: contig_metadata: 5 rows where bioproject = "PRJNA1227535", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA1227535", 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
11814141	11814141	PRJNA1227535_P_NODE_6070_length_312_cov_3.857741_g5947_i0	PRJNA1227535	6070	312	3.857741	12.03615192	PVC group	1783257	Bacteria	Bacteria	99	6.66e-22	NR	CRH67523.1	813	g5947	i0	97.8	3.26923076923077	46	1	44.2	0	12	149	1	46	CRH67523.1 Glycine oxidase [Chlamydia trachomatis]	diamond	1020	99	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
28702214	28702214	PRJNA1227535_P_NODE_29007_length_244_cov_0.912281_g28883_i0	PRJNA1227535	29007	244	0.912281	2.22596564	Chlamydiia	204429	Bacteria	Bacteria	78.2	3.22e-15	NR	MEX0961356.1	2698248	g28883	i0	63.5	3.82377049180328	63	20	73.8	1	217	38	86	148	MEX0961356.1 type II toxin-antitoxin system antitoxin SocA domain-containing protein [Simkaniaceae bacterium]	diamond	933	78.6	0.994910941475827	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
29030899	29030899	PRJNA1227535_P_NODE_15308_length_274_cov_1.512438_g15185_i0	PRJNA1227535	15308	274	1.512438	4.14408012	Chlamydiia bacterium	2052156	Bacteria	Bacteria	65.5	4.72e-10	NR	MCB1114380.1	2052156	g15185	i0	39	0.897810218978102	82	50	89.8	0	267	22	25	106	MCB1114380.1 aminopeptidase P family protein [Chlamydiia bacterium]	diamond	246	65.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
31811186	31811186	PRJNA1227535_P_NODE_3717_length_370_cov_2.353535_g3594_i0	PRJNA1227535	3717	370	2.353535	8.7080795	Chlamydiota bacterium	2081524	Bacteria	Bacteria	239	1.26e-76	NR	NBO24861.1	2081524	g3594	i0	88.6	0.997297297297297	123	14	99.7	0	370	2	59	181	NBO24861.1 transposase [Chlamydiota bacterium]	diamond	369	239	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32696356	32696356	PRJNA1227535_P_NODE_34040_length_199_cov_6.063492_g33916_i0	PRJNA1227535	34040	199	6.063492	12.06634908	Chlamydiia bacterium	2052156	Bacteria	Bacteria	113	7.600000000000001e-28	NR	MCB1113967.1	2052156	g33916	i0	81.8	2.96984924623116	66	12	99.5	0	1	198	83	148	MCB1113967.1 ATP-binding protein [Chlamydiia bacterium]	diamond	591	113	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia 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);;