metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA744060" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA744060" 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
29263050	29263050	PRJNA744060_P_NODE_7629_length_576_cov_3.121272_g7305_i0	PRJNA744060	7629	576	3.121272	17.97852672	Chlamydiales bacterium	2047757	Bacteria	Bacteria	198	7.52e-58	NR	MFT4553856.1	2047757	g7305	i0	57.9	6.61458333333333	159	67	82.8	0	2	478	279	437	MFT4553856.1 alanine-glyoxylate transaminase/(R)-3-amino-2-methylpropionate-pyruvate transaminase [Chlamydiales bacterium]	diamond	3810	198	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales		Chlamydiales bacterium
29957843	29957843	PRJNA744060_P_NODE_18791_length_372_cov_4.665552_g18462_i0	PRJNA744060	18791	372	4.665552	17.35585344	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	68.6	1.21e-10	NR	MFI0434572.1	2052176	g18462	i0	52.2	0.556451612903226	69	26	55.6	1	371	165	316	377	MFI0434572.1 SET domain-containing protein-lysine N-methyltransferase [Parachlamydiaceae bacterium]	diamond	207	68.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydiaceae bacterium
30305958	30305958	PRJNA744060_P_NODE_37792_length_270_cov_0.974619_g37463_i0	PRJNA744060	37792	270	0.974619	2.6314713	Chlamydiota bacterium	2081524	Bacteria	Bacteria	43.5	0.0279	NR	MCI0381953.1	2081524	g37463	i0	45.7	1.04444444444444	46	25	51.1	0	140	3	596	641	MCI0381953.1 tetratricopeptide repeat protein [Chlamydiota bacterium]	diamond	282	43.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota				Chlamydiota bacterium
31158205	31158205	PRJNA744060_P_NODE_52335_length_237_cov_3.182927_g52006_i0	PRJNA744060	52335	237	3.182927	7.54353699	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	50.4	6.26e-5	NR	MFI0434572.1	2052176	g52006	i0	35.6	0.924050632911392	73	34	75.9	1	57	236	19	91	MFI0434572.1 SET domain-containing protein-lysine N-methyltransferase [Parachlamydiaceae bacterium]	diamond	219	50.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydiaceae bacterium
31474922	31474922	PRJNA744060_P_NODE_45996_length_250_cov_0.881356_g45667_i0	PRJNA744060	45996	250	0.881356	2.20339	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	126	6.16e-33	NR	HSX12653.1	2047756	g45667	i0	77.8	1.968	81	18	97.2	0	250	8	99	179	HSX12653.1 ribose-phosphate pyrophosphokinase [Rhabdochlamydiaceae bacterium]	diamond	492	126	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Rhabdochlamydiaceae 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);;