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

6 rows where bioproject = "PRJNA1008624", 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_species
26781438	26781438	PRJNA1008624_P_NODE_27881_length_169_cov_0.866667_g27693_i0	PRJNA1008624	27881	169	0.866667	1.46466723	Chlamydiota bacterium	2081524	Bacteria	Bacteria	85.5	1.13e-17	NR	MCH9634803.1	2081524	g27693	i0	75.5	1.91715976331361	53	13	94.1	0	9	167	301	353	MCH9634803.1 Arginine--tRNA ligase [Chlamydiota bacterium]	diamond	324	85.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
26844868	26844868	PRJNA1008624_P_NODE_33881_length_164_cov_0.904348_g33693_i0	PRJNA1008624	33881	164	0.904348	1.48313072	Chlamydiota bacterium	2081524	Bacteria	Bacteria	41.6	0.0326	NR	MCH9633308.1	2081524	g33693	i0	66.7	0.49390243902439	27	9	49.4	0	45	125	1	27	MCH9633308.1 Glucokinase [Chlamydiota bacterium]	diamond	81	41.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
29150703	29150703	PRJNA1008624_P_NODE_34869_length_163_cov_0.921053_g34681_i0	PRJNA1008624	34869	163	0.921053	1.50131639	Chlamydiae bacterium CG1	2081524	Bacteria	Bacteria	46.2	7.46e-4	NR	PIS03286.1	1973936	g34681	i0	41.5	0.975460122699387	53	26	88.3	1	4	147	133	185	PIS03286.1 MAG: hypothetical protein COT85_00990 [Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_42_34]	diamond	159	46.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_42_34
29939919	29939919	PRJNA1008624_P_NODE_36931_length_162_cov_0.920354_g36743_i0	PRJNA1008624	36931	162	0.920354	1.49097348	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	49.3	5.81e-5	NR	MBX9922702.1	2047756	g36743	i0	69	2.14814814814815	29	9	53.7	0	75	161	3	31	MBX9922702.1 pyruvate dehydrogenase complex E1 component subunit beta [Rhabdochlamydiaceae bacterium]	diamond	348	49.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Rhabdochlamydiaceae bacterium
31741083	31741083	PRJNA1008624_P_NODE_30837_length_166_cov_0.888889_g30649_i0	PRJNA1008624	30837	166	0.888889	1.47555574	Chlamydiia bacterium	2052156	Bacteria	Bacteria	85.9	8.31e-20	NR	MBI3508299.1	2052156	g30649	i0	78.8	0.939759036144578	52	11	94	0	6	161	23	74	MBI3508299.1 VOC family protein [Chlamydiia bacterium]	diamond	156	85.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia			Chlamydiia bacterium
32279302	32279302	PRJNA1008624_P_NODE_16079_length_212_cov_0.797546_g15891_i0	PRJNA1008624	16079	212	0.797546	1.69079752	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	141	5.59e-40	NR	MFI0436135.1	2052176	g15891	i0	100	0.990566037735849	70	0	99.1	0	3	212	55	124	MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium]	diamond	210	141	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydiaceae 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);;