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

5 rows where analysis = "diamond", bioproject = "PRJNA760976" and tax_phylum = "Planctomycetota"

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
27811474	27811474	PRJNA760976_P_NODE_34064_length_289_cov_1.027778_g33743_i0	PRJNA760976	34064	289	1.027778	2.97027842	Gemmataceae bacterium	2052164	Bacteria	Bacteria	99.4	8.34e-22	NR	HEX3148041.1	2052164	g33743	i0	54.3	1.94117647058824	94	43	97.6	0	3	284	635	728	HEX3148041.1 hypothetical protein [Gemmataceae bacterium]	diamond	561	99.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28852974	28852974	PRJNA760976_P_NODE_56048_length_241_cov_1.351190_g55727_i0	PRJNA760976	56048	241	1.35119	3.2563679	Fuerstiella sp.	1936112	Bacteria	Bacteria	74.7	1.71e-13	NR	MEP3482112.1	1936112	g55727	i0	50	1.81742738589212	72	34	89.6	1	239	24	204	273	MEP3482112.1 NO-inducible flavohemoprotein [Fuerstiella sp.]	diamond	438	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
28979659	28979659	PRJNA760976_P_NODE_41908_length_266_cov_1.554404_g41587_i0	PRJNA760976	41908	266	1.554404	4.13471464	Gemmataceae bacterium	2052164	Bacteria	Bacteria	48.9	3.17e-4	NR	HEY8503922.1	2052164	g41587	i0	37.7	0.868421052631579	77	39	86.8	3	231	1	266	333	HEY8503922.1 hypothetical protein [Gemmataceae bacterium]	diamond	231	48.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30843120	30843120	PRJNA760976_P_NODE_12134_length_418_cov_0.849275_g11814_i0	PRJNA760976	12134	418	0.849275	3.5499695	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.2	4.75e-6	NR	NLE60524.1	2026780	g11814	i0	37.6	0.839712918660287	117	69	83.3	3	409	62	67	180	NLE60524.1 carboxypeptidase regulatory-like domain-containing protein [Planctomycetota bacterium]	diamond	351	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32645092	32645092	PRJNA760976_P_NODE_53460_length_244_cov_0.859649_g53139_i0	PRJNA760976	53460	244	0.859649	2.09754356	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	50.8	4.87e-5	NR	HMB95802.1	2876886	g53139	i0	82.6	0.565573770491803	23	4	28.3	0	244	176	282	304	HMB95802.1 DUF4139 domain-containing protein [Tepidisphaeraceae bacterium]	diamond	138	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae 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);;