metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA407368" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA407368" 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
27296715	27296715	PRJNA407368_S_NODE_2343_length_400_cov_7.722372_g2241_i0	PRJNA407368	2343	400	7.722372	30.889488	Chlamydiales bacterium	2047757	Bacteria	Bacteria	76.3	4.4e-13	NR	MCE5294811.1	2047757	g2241	i0	46.7	0.69	92	48	69	1	327	52	180	270	MCE5294811.1 amino acid adenylation domain-containing protein [Chlamydiales bacterium]	diamond	276	76.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29349194	29349194	PRJNA407368_S_NODE_7749_length_185_cov_2.634615_g7647_i0	PRJNA407368	7749	185	2.634615	4.87403775	Estrella lausannensis	483423	Bacteria	Bacteria	51.6	1.26e-5	NR	WP_098039224.1	483423	g7647	i0	51.7	0.940540540540541	58	27	94.1	1	185	12	279	335	WP_098039224.1 NO-inducible flavohemoprotein [Estrella lausannensis]	diamond	174	51.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
30833740	30833740	PRJNA407368_S_NODE_3554_length_311_cov_4.141844_g3452_i0	PRJNA407368	3554	311	4.141844	12.88113484	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	126	2.94e-33	NR	MFI0435901.1	2052176	g3452	i0	89.7	0.655948553054662	68	7	65.6	0	1	204	117	184	MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	204	126	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31561016	31561016	PRJNA407368_S_NODE_416_length_987_cov_7.930063_g380_i0	PRJNA407368	416	987	7.930063	78.26972181	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	53.1	5.31e-4	NR	MFI0435897.1	2052176	g380	i0	61.5	0.11854103343465	39	15	11.9	0	134	250	221	259	MFI0435897.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	117	53.1	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);;