metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA886442" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA886442" 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
11065433	11065433	PRJNA886442_P_NODE_14589_length_243_cov_0.917647_g14425_i0	PRJNA886442	14589	243	0.917647	2.22988221	Planctomycetota bacterium	2026780	Bacteria	Bacteria	147	2.86e-40	NR	RIK83591.1	2026780	g14425	i0	86.3	3.95061728395062	80	10	98.8	1	2	241	223	301	RIK83591.1 MAG: gfo/Idh/MocA family oxidoreductase, partial [Planctomycetota bacterium]	diamond	960	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
21263959	21263959	PRJNA886442_P_NODE_8177_length_280_cov_1.275362_g8013_i0	PRJNA886442	8177	280	1.275362	3.5710136	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	181	4.209999999999999e-55	NR	HEY8965962.1	2720631	g8013	i0	91.4	0.996428571428571	93	8	99.6	0	280	2	38	130	HEY8965962.1 MBL fold metallo-hydrolase [Candidatus Methylacidiphilales bacterium]	diamond	279	181	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
28003241	28003241	PRJNA886442_P_NODE_3585_length_385_cov_1.000000_g3421_i0	PRJNA886442	3585	385	1	3.85	Tautonia sociabilis	2080755	Bacteria	Bacteria	121	4.89e-31	NR	WP_126726219.1	2080755	g3421	i0	65.2	0.716883116883117	92	32	71.7	0	385	110	180	271	WP_126726219.1 class I SAM-dependent methyltransferase [Tautonia sociabilis]	diamond	276	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia sociabilis
30750649	30750649	PRJNA886442_P_NODE_2354_length_455_cov_1.225131_g2190_i0	PRJNA886442	2354	455	1.225131	5.57434605	Gemmataceae bacterium	2052164	Bacteria	Bacteria	120	1.63e-29	NR	HJZ92462.1	2052164	g2190	i0	45.7	1.99120879120879	151	66	99.6	5	1	453	105	239	HJZ92462.1 aldose epimerase family protein [Gemmataceae bacterium]	diamond	906	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30971869	30971869	PRJNA886442_P_NODE_8794_length_272_cov_0.969849_g8630_i0	PRJNA886442	8794	272	0.969849	2.63798928	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	71.6	3.29e-12	NR	MBT8036538.1	2499141	g8630	i0	40.3	0.794117647058823	72	43	79.4	0	57	272	1	72	MBT8036538.1 CDP-glycerol glycerophosphotransferase family protein [Verrucomicrobiia bacterium]	diamond	216	71.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31509346	31509346	PRJNA886442_P_NODE_14096_length_244_cov_0.912281_g13932_i0	PRJNA886442	14096	244	0.912281	2.22596564	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	154	8.929999999999999e-45	NR	HEY8966496.1	2720631	g13932	i0	96.2	1.95491803278689	79	3	97.1	0	242	6	61	139	HEY8966496.1 signal peptide peptidase SppA [Candidatus Methylacidiphilales bacterium]	diamond	477	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
32836558	32836558	PRJNA886442_P_NODE_7800_length_285_cov_1.839623_g7636_i0	PRJNA886442	7800	285	1.839623	5.24292555	Planctomycetia bacterium	2052181	Bacteria	Bacteria	82	4.49e-16	NR	NBO92887.1	2052181	g7636	i0	49.5	1.94736842105263	95	47	98.9	1	2	283	182	276	NBO92887.1 zinc-binding dehydrogenase [Planctomycetia bacterium]	diamond	555	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;