metadata: contig_metadata: 4 rows where bioproject = "PRJNA222400", tax_clade = "PVC group" and tax

4 rows where bioproject = "PRJNA222400", 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_species
29126888	29126888	PRJNA222400_P_NODE_449_length_755_cov_1.385269_g422_i0	PRJNA222400	449	755	1.385269	10.45878095	Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8	1797601	Bacteria	Bacteria	127	1.1e-31	NR	OGN61875.1	1797601	g422	i0	38.5	0.762913907284768	192	101	71.9	5	105	647	67	252	OGN61875.1 MAG: hypothetical protein A3F40_03365 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8]	diamond	576	127	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota			Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8
31843885	31843885	PRJNA222400_P_NODE_1577_length_406_cov_2.019608_g1544_i0	PRJNA222400	1577	406	2.019608	8.19960848	Chlamydiia bacterium	2052156	Bacteria	Bacteria	61.6	7.96e-9	NR	MCB1115924.1	2052156	g1544	i0	37.9	1.21182266009852	95	51	64.3	3	350	90	61	155	MCB1115924.1 DoxX family protein [Chlamydiia bacterium]	diamond	492	61.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia		Chlamydiia bacterium
32097099	32097099	PRJNA222400_P_NODE_5958_length_184_cov_1.155556_g5925_i0	PRJNA222400	5958	184	1.155556	2.12622304	Chlamydiota bacterium	2081524	Bacteria	Bacteria	46.6	6.09e-4	NR	MEM7175885.1	2081524	g5925	i0	47.7	2.13586956521739	44	23	71.7	0	2	133	144	187	MEM7175885.1 ankyrin repeat domain-containing protein [Chlamydiota bacterium]	diamond	393	46.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota			Chlamydiota bacterium
32097103	32097103	PRJNA222400_P_NODE_7958_length_166_cov_1.683761_g7925_i0	PRJNA222400	7958	166	1.683761	2.79504326	Chlamydiales bacterium	2047757	Bacteria	Bacteria	70.9	2.43e-14	NR	HSX13502.1	2047757	g7925	i0	60	1.98795180722892	55	20	99.4	1	1	165	21	73	HSX13502.1 2OG-Fe(II) oxygenase [Chlamydiales bacterium]	diamond	330	70.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiales 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);;