metadata: contig_metadata: 10 rows where bioproject = "PRJNA615351", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA615351", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

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
27048856	27048856	PRJNA615351_P_NODE_177082_length_158_cov_2.569106_g162982_i0	PRJNA615351	177082	158	2.569106	4.05918748	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	63.9	3.87e-10	NR	MBN2450668.1	2053569	g162982	i0	61.2	1.84177215189873	49	19	93	0	9	155	143	191	MBN2450668.1 hydroxylamine reductase [Lentisphaeria bacterium]	diamond	291	63.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27680894	27680894	PRJNA615351_P_NODE_11644_length_1908_cov_5.667379_g8373_i0	PRJNA615351	11644	1908	5.667379	108.13359132	Lentisphaeraceae bacterium	2461380	Bacteria	Bacteria	116	4.4599999999999996e-23	NR	MCM8541230.1	2461380	g8373	i0	35.1	0.35377358490566	225	117	33.8	7	1892	1248	81	286	MCM8541230.1 bifunctional serine/threonine-protein kinase/formylglycine-generating enzyme family protein [Lentisphaeraceae bacterium]	diamond	675	116	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae		Lentisphaeraceae bacterium
27914470	27914470	PRJNA615351_P_NODE_71445_length_489_cov_2.555066_g57522_i0	PRJNA615351	71445	489	2.555066	12.49427274	Bacteria	2	Bacteria	Bacteria	118	5.06e-29	NR	NLE42665.1	1932692	g57522	i0	49.2	3.97546012269939	132	61	81	1	398	3	130	255	NLE42665.1 putative beta-lysine N-acetyltransferase [Lentisphaerota bacterium]	diamond	1944	118	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28596469	28596469	PRJNA615351_P_NODE_26687_length_1229_cov_3.734506_g19420_i0	PRJNA615351	26687	1229	3.734506	45.89707874	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	77	5.3e-11	NR	MDP7396481.1	2053569	g19420	i0	24.1	0.871440195280716	357	189	79.3	15	1009	35	457	763	MDP7396481.1 PQQ-binding-like beta-propeller repeat protein [Lentisphaeria bacterium]	diamond	1071	77	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
28704053	28704053	PRJNA615351_P_NODE_140947_length_204_cov_4.094675_g126847_i0	PRJNA615351	140947	204	4.094675	8.353137	Pseudomonadati	3379134	Bacteria	Bacteria	87	5.64e-18	NR	MCK5844774.1	2212475	g126847	i0	63.3	2.70588235294118	60	22	88.2	0	189	10	520	579	MCK5844774.1 hypothetical protein [Victivallales bacterium]	diamond	552	87	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
28785512	28785512	PRJNA615351_P_NODE_141987_length_203_cov_1.178571_g127887_i0	PRJNA615351	141987	203	1.178571	2.39249913	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	47	7.65e-5	NR	MBR7131025.1	2053569	g127887	i0	46.9	0.724137931034483	49	24	69.5	1	160	20	1	49	MBR7131025.1 hypothetical protein [Lentisphaeria bacterium]	diamond	147	47	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
30851591	30851591	PRJNA615351_P_NODE_37394_length_953_cov_4.251634_g27670_i0	PRJNA615351	37394	953	4.251634	40.51807202	Pseudomonadati	3379134	Bacteria	Bacteria	251	1.73e-74	NR	NLG14483.1	1932692	g27670	i0	43.7	12.3651626442812	300	160	94.4	4	52	951	4	294	NLG14483.1 NTP transferase domain-containing protein [Lentisphaerota bacterium]	diamond	11784	253	0.992094861660079	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
30883184	30883184	PRJNA615351_P_NODE_85394_length_391_cov_3.789326_g71333_i0	PRJNA615351	85394	391	3.789326	14.81626466	Bacteria	2	Bacteria	Bacteria	159	7.129999999999998e-48	NR	NLL82652.1	1932692	g71333	i0	64.1	12.7289002557545	103	37	79	0	44	352	1	103	NLL82652.1 L-rhamnose mutarotase [Lentisphaerota bacterium]	diamond	4977	160	0.99375	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
31281184	31281184	PRJNA615351_P_NODE_98095_length_326_cov_1.938144_g83998_i0	PRJNA615351	98095	326	1.938144	6.31834944	Lentisphaerae bacterium WC36	2886196	Bacteria	Bacteria	66.2	5.07e-10	NR	UDQ98464.1	2886196	g83998	i0	33.7	4.41717791411043	101	63	89.3	2	323	33	99	199	UDQ98464.1 DUF1015 family protein [Lentisphaerae bacterium WC36]	diamond	1440	66.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
31976988	31976988	PRJNA615351_P_NODE_29478_length_1148_cov_3.553459_g21532_i0	PRJNA615351	29478	1148	3.553459	40.79370932	Victivallis vadensis	172901	Bacteria	Bacteria	49.7	0.0171	NR	WP_116883453.1	172901	g21532	i0	30.7	0.297909407665505	114	76	29.3	3	712	1047	128	240	WP_116883453.1 glycoside hydrolase family 32 protein [Victivallis vadensis]	diamond	342	49.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	Victivallis vadensis

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);;