metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA928559" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA928559" 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
26961387	26961387	PRJNA928559_P_NODE_71822_length_416_cov_1.288630_g70253_i0	PRJNA928559	71822	416	1.28863	5.3607008	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	46.6	0.00952	NR	HUD01044.1	2047756	g70253	i0	24.1	1.77403846153846	141	96	93.8	3	394	5	219	359	HUD01044.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	738	46.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
27467374	27467374	PRJNA928559_P_NODE_39643_length_531_cov_7.268559_g38087_i0	PRJNA928559	39643	531	7.268559	38.59604829	Chlamydiales bacterium	2047757	Bacteria	Bacteria	197	1.37e-61	NR	MCP5470420.1	2047757	g38087	i0	78.4	0.706214689265537	125	27	70.6	0	17	391	1	125	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	375	197	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28067087	28067087	PRJNA928559_P_NODE_192625_length_251_cov_0.876404_g191056_i0	PRJNA928559	192625	251	0.876404	2.19977404	Chlamydiales bacterium	2047757	Bacteria	Bacteria	95.5	1.68e-21	NR	HLB52200.1	2047757	g191056	i0	55.4	0.99203187250996006	83	33	98	2	2	247	105	184	HLB52200.1 polyamine aminopropyltransferase [Chlamydiales bacterium]	diamond	249	95.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29077687	29077687	PRJNA928559_P_NODE_63828_length_437_cov_6.758242_g62259_i0	PRJNA928559	63828	437	6.758242	29.53351754	Simkania sp.	34094	Bacteria	Bacteria	118	1.13e-29	NR	MCB1084310.1	34094	g62259	i0	57	0.638443935926774	93	40	63.8	0	3	281	104	196	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	279	118	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29235513	29235513	PRJNA928559_P_NODE_58689_length_453_cov_3.526316_g57122_i0	PRJNA928559	58689	453	3.526316	15.97421148	Chlamydiales bacterium	2047757	Bacteria	Bacteria	47	0.00774	NR	MFN0064848.1	2047757	g57122	i0	34.3	0.655629139072848	99	61	64.2	3	413	123	87	183	MFN0064848.1 toxin-antitoxin system YwqK family antitoxin [Chlamydiales bacterium]	diamond	297	47	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29424596	29424596	PRJNA928559_P_NODE_119389_length_326_cov_1.509881_g117820_i0	PRJNA928559	119389	326	1.509881	4.92221206	Chlamydiales bacterium	2047757	Bacteria	Bacteria	73.9	2.72e-13	NR	MCP5470430.1	2047757	g117820	i0	52.8	0.819018404907976	89	42	81.9	0	267	1	4	92	MCP5470430.1 hypothetical protein [Chlamydiales bacterium]	diamond	267	73.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30119493	30119493	PRJNA928559_P_NODE_225612_length_214_cov_6.581560_g224043_i0	PRJNA928559	225612	214	6.58156	14.0845384	Simkania sp.	34094	Bacteria	Bacteria	48.9	1.43e-5	NR	MCB1084365.1	34094	g224043	i0	56.8	0.518691588785047	37	16	51.9	0	209	99	39	75	MCB1084365.1 hypothetical protein [Simkania sp.]	diamond	111	48.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30435897	30435897	PRJNA928559_P_NODE_53893_length_469_cov_7.469697_g52327_i0	PRJNA928559	53893	469	7.469697	35.03287893	Chlamydiales bacterium	2047757	Bacteria	Bacteria	133	1.49e-36	NR	MCP5470421.1	2047757	g52327	i0	51.4	4.0682302771855	142	63	89.6	2	469	50	20	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1908	133	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);;