metadata: contig_metadata: 3 rows where bioproject = "PRJEB11523" and tax

3 rows where bioproject = "PRJEB11523" 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
26874854	26874854	PRJEB11523_P_NODE_5041_length_208_cov_20.647799_g4963_i0	PRJEB11523	5041	208	20.647799	42.94742192	Chlamydiota bacterium	2081524	Bacteria	Bacteria	108	6.38e-26	NR	MES2199665.1	2081524	g4963	i0	87.1	3.57692307692308	62	8	89.4	0	187	2	71	132	MES2199665.1 type III secretion system ATPase SctN [Chlamydiota bacterium]	diamond	744	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28479461	28479461	PRJEB11523_P_NODE_7526_length_167_cov_0.864407_g7448_i0	PRJEB11523	7526	167	0.864407	1.44355969	PVC group	1783257	Bacteria	Bacteria	110	1.15e-28	NR	CRH69182.1	813	g7448	i0	96.4	1.97604790419162	55	2	98.8	0	3	167	128	182	CRH69182.1 Pur operon repressor [Chlamydia trachomatis]	diamond	330	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
31201373	31201373	PRJEB11523_P_NODE_3475_length_264_cov_1.423256_g3397_i0	PRJEB11523	3475	264	1.423256	3.75739584	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	128	8.810000000000001e-36	NR	MBX7066303.1	2052178	g3397	i0	80.9	2.29545454545455	68	12	77.3	1	224	21	87	153	MBX7066303.1 signal peptidase II [Parachlamydiales bacterium]	diamond	606	128	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales 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);;