metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA565778" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA565778" and tax_clade = "PVC group"

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
27584980	27584980	PRJNA565778_S_NODE_25824_length_217_cov_37.061111_g25528_i0	PRJNA565778	25824	217	37.061111	80.42261087	Parachlamydia sp.	2052048	Bacteria	Bacteria	55.5	8.76e-7	NR	MCE5318139.1	2052048	g25528	i0	48.4	0.857142857142857	62	32	85.7	0	31	216	417	478	MCE5318139.1 ATP-binding protein [Parachlamydia sp.]	diamond	186	55.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
28703822	28703822	PRJNA565778_S_NODE_26267_length_215_cov_151.303371_g25971_i0	PRJNA565778	26267	215	151.303371	325.30224765	Pseudomonadati	3379134	Bacteria	Bacteria	43.9	0.00434	NR	MSU62638.1	2024890	g25971	i0	39.7	1.54883720930233	58	34	80.9	1	176	3	73	129	MSU62638.1 hypothetical protein [Pedosphaera sp.]	diamond	333	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
28879443	28879443	PRJNA565778_S_NODE_27628_length_210_cov_2.676301_g27332_i0	PRJNA565778	27628	210	2.676301	5.6202321	Planctomycetota bacterium	2026780	Bacteria	Bacteria	75.9	5.25e-14	NR	HRJ77648.1	2026780	g27332	i0	90.2	0.585714285714286	41	4	58.6	0	198	76	774	814	HRJ77648.1 protein DpdF [Planctomycetota bacterium]	diamond	123	75.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29826671	29826671	PRJNA565778_S_NODE_19691_length_249_cov_933.174528_g19395_i0	PRJNA565778	19691	249	933.174528	2323.60457472	Chlamydiales bacterium	2047757	Bacteria	Bacteria	87	3.68e-20	NR	MCE5293497.1	2047757	g19395	i0	52.1	0.879518072289157	73	32	84.3	1	211	2	21	93	MCE5293497.1 hypothetical protein [Chlamydiales bacterium]	diamond	219	87	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29858278	29858278	PRJNA565778_S_NODE_8591_length_368_cov_3.042296_g8295_i0	PRJNA565778	8591	368	3.042296	11.19564928	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47.8	0.00213	NR	MBY0309332.1	2052180	g8295	i0	56.4	0.448369565217391	55	18	44	2	29	190	22	71	MBY0309332.1 ankyrin repeat domain-containing protein [Phycisphaerales bacterium]	diamond	165	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30616510	30616510	PRJNA565778_S_NODE_13253_length_302_cov_4.328302_g12957_i0	PRJNA565778	13253	302	4.328302	13.07147204	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	73.2	8.7e-13	NR	MBN1521042.1	2093365	g12957	i0	64.3	0.556291390728477	56	19	55.6	1	170	3	1	55	MBN1521042.1 glycosyltransferase [Candidatus Auribacterota bacterium]	diamond	168	73.2	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
31090537	31090537	PRJNA565778_S_NODE_1035_length_835_cov_3.659148_g958_i0	PRJNA565778	1035	835	3.659148	30.5538858	Lentisphaeraceae bacterium	2461380	Bacteria	Bacteria	56.2	7.46e-5	NR	MCM8537330.1	2461380	g958	i0	32.2	1.27904191616766	121	76	42.4	3	357	4	3	120	MCM8537330.1 oligopeptidase A [Lentisphaeraceae bacterium]	diamond	1068	56.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae		Lentisphaeraceae bacterium
31862950	31862950	PRJNA565778_S_NODE_37357_length_177_cov_2.507143_g37061_i0	PRJNA565778	37357	177	2.507143	4.43764311	Bacteria	2	Bacteria	Bacteria	85.1	3.51e-19	NR	MCI0458091.1	2052164	g37061	i0	69.2	4.72881355932203	52	16	88.1	0	1	156	83	134	MCI0458091.1 class I SAM-dependent methyltransferase [Gemmataceae bacterium]	diamond	837	85.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32387397	32387397	PRJNA565778_S_NODE_12719_length_308_cov_6.191882_g12423_i0	PRJNA565778	12719	308	6.191882	19.07099656	Chlamydiales bacterium	2047757	Bacteria	Bacteria	108	3.45e-28	NR	MCE5293497.1	2047757	g12423	i0	51.6	0.886363636363636	91	41	85.7	1	265	2	3	93	MCE5293497.1 hypothetical protein [Chlamydiales bacterium]	diamond	273	108	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);;