metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA534016" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA534016" 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
8160350	8160350	PRJNA534016_P_NODE_5487_length_355_cov_2.691489_g5397_i0	PRJNA534016	5487	355	2.691489	9.55478595	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	149	9.919999999999997e-42	NR	HCP06138.1	2026801	g5397	i0	67	3.65070422535211	115	31	97.2	2	1	345	145	252	HCP06138.1 transaldolase [Verrucomicrobiales bacterium]	diamond	1296	149	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
26793034	26793034	PRJNA534016_P_NODE_15821_length_246_cov_1.780347_g15731_i0	PRJNA534016	15821	246	1.780347	4.37965362	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	45.8	0.00326	NR	MFO0827385.1	2052180	g15731	i0	70	0.365853658536585	30	9	36.6	0	237	148	741	770	MFO0827385.1 DUF3488 and transglutaminase-like domain-containing protein [Phycisphaerales bacterium]	diamond	90	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26919647	26919647	PRJNA534016_P_NODE_17502_length_243_cov_0.905882_g17412_i0	PRJNA534016	17502	243	0.905882	2.20129326	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	100	1.86e-23	NR	MBN9692575.1	2026799	g17412	i0	97.9	0.592592592592593	48	1	59.3	0	243	100	223	270	MBN9692575.1 EamA family transporter [Verrucomicrobiota bacterium]	diamond	144	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27123998	27123998	PRJNA534016_P_NODE_18882_length_232_cov_2.792453_g18792_i0	PRJNA534016	18882	232	2.792453	6.47849096	Verrucomicrobiota	74201	Bacteria	Bacteria	46.6	0.00136	NR	HEY6675445.1	1965319	g18792	i0	41.1	2.14655172413793	56	33	72.4	0	24	191	18	73	HEY6675445.1 adenylate/guanylate cyclase domain-containing protein [Terrimicrobium sp.]	diamond	498	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.
27377494	27377494	PRJNA534016_P_NODE_5103_length_366_cov_3.969283_g5013_i0	PRJNA534016	5103	366	3.969283	14.52757578	Pseudomonadati	3379134	Bacteria	Bacteria	145	8.77e-41	NR	MBI2191822.1	2026780	g5013	i0	61.7	1.88524590163934	115	44	94.3	0	21	365	133	247	MBI2191822.1 glucose 1-dehydrogenase [Planctomycetota bacterium]	diamond	690	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28277782	28277782	PRJNA534016_P_NODE_3186_length_458_cov_1.200000_g3096_i0	PRJNA534016	3186	458	1.2	5.496	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	45.1	0.0469	NR	MBU4376468.1	2035772	g3096	i0	32.5	0.746724890829694	114	72	72.7	4	416	84	117	228	MBU4376468.1 LON peptidase substrate-binding domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	342	45.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
29635265	29635265	PRJNA534016_P_NODE_6790_length_323_cov_3.400000_g6700_i0	PRJNA534016	6790	323	3.4	10.982	Planctomycetales bacterium	2053591	Bacteria	Bacteria	119	2.74e-31	NR	MCX7409788.1	2053591	g6700	i0	57.1	2.89783281733746	105	45	97.5	0	322	8	53	157	MCX7409788.1 hypothetical protein [Planctomycetales bacterium]	diamond	936	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
30014690	30014690	PRJNA534016_P_NODE_3591_length_433_cov_1.416667_g3501_i0	PRJNA534016	3591	433	1.416667	6.13416811	Planctomycetota bacterium	2026780	Bacteria	Bacteria	51.2	3.25e-4	NR	MCH7595330.1	2026780	g3501	i0	32.2	1.58660508083141	121	65	72.1	3	6	317	1402	1522	MCH7595330.1 hypothetical protein [Planctomycetota bacterium]	diamond	687	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30440423	30440423	PRJNA534016_P_NODE_18733_length_236_cov_2.245399_g18643_i0	PRJNA534016	18733	236	2.245399	5.29914164	Bacteria	2	Bacteria	Bacteria	67	9.4e-11	NR	MBB65172.1	2026802	g18643	i0	45.6	2.3135593220339	68	37	86.4	0	28	231	490	557	MBB65172.1 arginine--tRNA ligase [Waddliaceae bacterium]	diamond	546	67	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
30724598	30724598	PRJNA534016_P_NODE_7534_length_309_cov_1.148305_g7444_i0	PRJNA534016	7534	309	1.148305	3.54826245	Pseudomonadati	3379134	Bacteria	Bacteria	73.6	1.13e-12	NR	WP_015244788.1	466153	g7444	i0	41.2	4.64077669902913	97	53	94.2	1	1	291	222	314	WP_015244788.1 glycosyltransferase family 1 protein [Singulisphaera acidiphila]	diamond	1434	73.9	0.995940460081191	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
30930926	30930926	PRJNA534016_P_NODE_16714_length_244_cov_2.146199_g16624_i0	PRJNA534016	16714	244	2.146199	5.23672556	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	42.4	0.0108	NR	MBI4397736.1	2035772	g16624	i0	52.9	2.37295081967213	34	16	41.8	0	241	140	37	70	MBI4397736.1 type II toxin-antitoxin system Phd/YefM family antitoxin [Candidatus Omnitrophota bacterium]	diamond	579	42.4	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
31531712	31531712	PRJNA534016_P_NODE_196_length_1614_cov_11.643738_g174_i0	PRJNA534016	196	1614	11.643738	187.92993132	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	49.7	0.0296	NR	MFN3165656.1	2026777	g174	i0	26.4	0.239776951672862	129	70	20.8	3	870	535	170	290	MFN3165656.1 protein kinase domain-containing protein [Phycisphaeraceae bacterium]	diamond	387	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
32132733	32132733	PRJNA534016_P_NODE_12218_length_261_cov_5.058511_g12128_i0	PRJNA534016	12218	261	5.058511	13.20271371	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	78.2	1.52e-14	NR	MFO0959493.1	2691532	g12128	i0	72.2	0.620689655172414	54	15	62.1	0	164	3	4	57	MFO0959493.1 serine/threonine-protein kinase [Isosphaeraceae bacterium]	diamond	162	78.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
32385733	32385733	PRJNA534016_P_NODE_11419_length_268_cov_1.302564_g11329_i0	PRJNA534016	11419	268	1.302564	3.49087152	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.0102	NR	MFH1733007.1	2026780	g11329	i0	35.2	0.604477611940298	54	35	60.4	0	22	183	38	91	MFH1733007.1 C45 family peptidase [Planctomycetota bacterium]	diamond	162	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;