metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax

12 rows where analysis = "diamond", bioproject = "PRJEB39269" 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
3883167	3883167	PRJEB39269_P_NODE_12124_length_402_cov_1.206612_g11719_i0	PRJEB39269	12124	402	1.206612	4.85058024	Bacteria	2	Bacteria	Bacteria	154	6.26e-44	NR	HEX9785044.1	2006848	g11719	i0	73.2	2.8955223880597	97	25	72.4	1	401	111	169	264	HEX9785044.1 DUF1080 domain-containing protein [Opitutaceae bacterium]	diamond	1164	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
13742738	13742738	PRJEB39269_P_NODE_80271_length_158_cov_4.495798_g79866_i0	PRJEB39269	80271	158	4.495798	7.10336084	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.1	1.71e-8	NR	MFM2096802.1	2026780	g79866	i0	92.6	2.6962025316455702	27	2	51.3	0	82	2	6	32	MFM2096802.1 Dihydrofolate reductase type 3 [Planctomycetota bacterium]	diamond	426	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26748016	26748016	PRJEB39269_P_NODE_41141_length_214_cov_1.657143_g40736_i0	PRJEB39269	41141	214	1.657143	3.54628602	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	94.7	1.28e-20	NR	HET9374130.1	2201154	g40736	i0	58	0.967289719626168	69	29	96.7	0	208	2	155	223	HET9374130.1 two-component regulator propeller domain-containing protein [Chthoniobacterales bacterium]	diamond	207	94.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
27570440	27570440	PRJEB39269_P_NODE_87124_length_153_cov_1.649123_g86719_i0	PRJEB39269	87124	153	1.649123	2.52315819	Opitutaceae bacterium	2006848	Bacteria	Bacteria	43.1	0.00794	NR	HEX9783952.1	2006848	g86719	i0	48.9	0.882352941176471	45	23	88.2	0	8	142	704	748	HEX9783952.1 TonB-dependent receptor [Opitutaceae bacterium]	diamond	135	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27697146	27697146	PRJEB39269_P_NODE_88684_length_152_cov_1.442478_g88279_i0	PRJEB39269	88684	152	1.442478	2.19256656	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	66.2	5.43e-11	NR	HSZ58344.1	2876886	g88279	i0	70.2	7.36184210526316	47	14	92.8	0	10	150	18	64	HSZ58344.1 long-chain fatty acid--CoA ligase [Tepidisphaeraceae bacterium]	diamond	1119	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27823261	27823261	PRJEB39269_P_NODE_66784_length_170_cov_3.083969_g66379_i0	PRJEB39269	66784	170	3.083969	5.2427473000000004	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	50.4	1.44e-5	NR	MBX3406412.1	2026777	g66379	i0	84.6	0.9	26	4	45.9	0	1	78	21	46	MBX3406412.1 sigma-70 family RNA polymerase sigma factor [Phycisphaeraceae bacterium]	diamond	153	50.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
27879651	27879651	PRJEB39269_P_NODE_49165_length_196_cov_1.044586_g48760_i0	PRJEB39269	49165	196	1.044586	2.04738856	Bacteria	2	Bacteria	Bacteria	122	2.9499999999999997e-32	NR	MBV8413705.1	2026799	g48760	i0	84.6	3.97959183673469	65	10	99.5	0	1	195	169	233	MBV8413705.1 5-deoxy-glucuronate isomerase [Verrucomicrobiota bacterium]	diamond	780	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28549479	28549479	PRJEB39269_P_NODE_82147_length_157_cov_1.525424_g81742_i0	PRJEB39269	82147	157	1.525424	2.39491568	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	86.3	5.35e-18	NR	HEV3098604.1	2665650	g81742	i0	80.4	0.974522292993631	51	10	97.5	0	1	153	777	827	HEV3098604.1 CusA/CzcA family heavy metal efflux RND transporter [Candidatus Udaeobacter sp.]	diamond	153	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
28959957	28959957	PRJEB39269_P_NODE_34248_length_236_cov_1.441624_g33843_i0	PRJEB39269	34248	236	1.441624	3.40223264	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	45.1	0.00522	NR	MBX3417541.1	2699754	g33843	i0	40.4	0.597457627118644	47	28	59.7	0	23	163	22	68	MBX3417541.1 AMP-binding protein [Pirellulaceae bacterium]	diamond	141	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29117794	29117794	PRJEB39269_P_NODE_52589_length_189_cov_3.213333_g52184_i0	PRJEB39269	52589	189	3.213333	6.07319937	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0478	NR	HET6202587.1	2026780	g52184	i0	37.9	0.920634920634921	58	32	85.7	1	10	171	48	105	HET6202587.1 glycosyltransferase [Planctomycetota bacterium]	diamond	174	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29622334	29622334	PRJEB39269_P_NODE_68710_length_169_cov_2.784615_g68305_i0	PRJEB39269	68710	169	2.784615	4.70599935	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	80.1	8.94e-16	NR	MBI5691970.1	2026799	g68305	i0	74.1	1.02958579881657	58	12	97.6	1	3	167	15	72	MBI5691970.1 NADP-dependent isocitrate dehydrogenase [Verrucomicrobiota bacterium]	diamond	174	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31771683	31771683	PRJEB39269_P_NODE_87137_length_153_cov_1.596491_g86732_i0	PRJEB39269	87137	153	1.596491	2.44263123	Gemmataceae bacterium	2052164	Bacteria	Bacteria	51.2	1.14e-5	NR	MEO2089549.1	2052164	g86732	i0	56.1	0.803921568627451	41	18	80.4	0	1	123	230	270	MEO2089549.1 hypothetical protein [Gemmataceae bacterium]	diamond	123	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;