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

5 rows where bioproject = "PRJNA680334", 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
26828940	26828940	PRJNA680334_S_NODE_16481_length_270_cov_2.367089_g15995_i0	PRJNA680334	16481	270	2.367089	6.3911403	Chlamydiales bacterium	2047757	Bacteria	Bacteria	132	9.99e-36	NR	HSX11004.1	2047757	g15995	i0	71.9	0.988888888888889	89	25	98.9	0	270	4	31	119	HSX11004.1 tetraacyldisaccharide 4'-kinase [Chlamydiales bacterium]	diamond	267	132	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28514951	28514951	PRJNA680334_S_NODE_24367_length_239_cov_5.063107_g23881_i0	PRJNA680334	24367	239	5.063107	12.10082573	Chlamydiia	204429	Bacteria	Bacteria	65.1	4.24e-10	NR	SCA64233.1	1871323	g23881	i0	42.1	2.86192468619247	76	43	95.4	1	5	232	188	262	SCA64233.1 hypothetical protein SCG7086_CW_00010 [Chlamydiales bacterium SCGC AG-110-P3]	diamond	684	65.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium SCGC AG-110-P3
29040086	29040086	PRJNA680334_S_NODE_21508_length_249_cov_2.134259_g21022_i0	PRJNA680334	21508	249	2.134259	5.31430491	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	50.1	8.06e-5	NR	HRD54787.1	2052176	g21022	i0	38.4	0.879518072289157	73	42	85.5	2	247	35	4	75	HRD54787.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	219	50.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
29355716	29355716	PRJNA680334_S_NODE_76869_length_167_cov_3.104478_g76383_i0	PRJNA680334	76869	167	3.104478	5.18447826	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	110	1.3500000000000002e-26	NR	MBX7066161.1	2052178	g76383	i0	92.6	0.970059880239521	54	4	97	0	167	6	53	106	MBX7066161.1 NAD-glutamate dehydrogenase [Parachlamydiales bacterium]	diamond	162	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
31472589	31472589	PRJNA680334_S_NODE_54256_length_187_cov_2.383117_g53770_i0	PRJNA680334	54256	187	2.383117	4.45642879	Chlamydia psittaci	83554	Bacteria	Bacteria	83.6	6.9e-19	NR	EPP30060.1	1112246	g53770	i0	86.2	0.93048128342246	58	8	93	0	13	186	51	108	EPP30060.1 putative membrane protein, partial [Chlamydia psittaci 08-2626_L3]	diamond	174	83.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci

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);;