metadata: contig_metadata: 13 rows where bioproject = "PRJNA1105232", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJNA1105232", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
26719139	26719139	PRJNA1105232_S_NODE_701_length_557_cov_6.143701_g493_i0	PRJNA1105232	701	557	6.143701	34.22041457	Gemmataceae bacterium	2052164	Bacteria	Bacteria	96.7	2e-20	NR	HZU34768.1	2052164	g493	i0	54.3	0.495511669658887	92	39	47.9	2	216	482	186	277	HZU34768.1 glycoside hydrolase family 19 protein [Gemmataceae bacterium]	diamond	276	96.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27762937	27762937	PRJNA1105232_S_NODE_2604_length_341_cov_3.609589_g2388_i0	PRJNA1105232	2604	341	3.609589	12.30869849	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	114	6.480000000000001e-27	NR	MDP7030110.1	2052180	g2388	i0	50	0.98533724340176	112	55	97.7	1	9	341	293	404	MDP7030110.1 M14 family zinc carboxypeptidase [Phycisphaerales bacterium]	diamond	336	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27848543	27848543	PRJNA1105232_S_NODE_6804_length_235_cov_1.059140_g6588_i0	PRJNA1105232	6804	235	1.05914	2.488979	Bacteria	2	Bacteria	Bacteria	85.5	3.05e-17	NR	GMU22953.1	2026778	g6588	i0	52.5	1.88936170212766	80	36	99.6	1	235	2	1290	1369	GMU22953.1 MAG: hypothetical protein AMXMBFR13_30370 [Phycisphaerae bacterium]	diamond	444	85.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27857319	27857319	PRJNA1105232_S_NODE_7405_length_227_cov_2.044944_g7189_i0	PRJNA1105232	7405	227	2.044944	4.64202288	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	63.9	1.03e-9	NR	MSR41607.1	2052180	g7189	i0	46.6	1.9295154185022	73	35	91.2	2	9	215	359	431	MSR41607.1 hypothetical protein [Phycisphaerales bacterium]	diamond	438	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28701330	28701330	PRJNA1105232_S_NODE_6167_length_244_cov_1.953846_g5951_i0	PRJNA1105232	6167	244	1.953846	4.76738424	Candidatus Uabimicrobium	2897349	Bacteria	Bacteria	99	1.57e-22	NR	WP_368239156.1	2596890	g5951	i0	54.9	3.02459016393443	82	36	99.6	1	2	244	188	269	WP_368239156.1 polysaccharide deacetylase family protein [Candidatus Uabimicrobium amorphum]	diamond	738	100	0.99	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
29120571	29120571	PRJNA1105232_S_NODE_17369_length_162_cov_0.920354_g17153_i0	PRJNA1105232	17369	162	0.920354	1.49097348	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0314	NR	MEM8758000.1	2026780	g17153	i0	41	0.722222222222222	39	23	72.2	0	136	20	136	174	MEM8758000.1 glycosyltransferase family 9 protein [Planctomycetota bacterium]	diamond	117	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29332711	29332711	PRJNA1105232_S_NODE_15109_length_169_cov_1.933333_g14893_i0	PRJNA1105232	15109	169	1.933333	3.26733277	root	1	Root_unresolved	Root_unresolved	50.1	3.57e-5	NR	WP_162658356.1	692036	g14893	i0	46.2	3.67455621301775	52	27	90.5	1	169	17	101	152	WP_162658356.1 molecular chaperone DnaJ [Tuwongella immobilis]	diamond	621	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
29499155	29499155	PRJNA1105232_S_NODE_15150_length_169_cov_1.391667_g14934_i0	PRJNA1105232	15150	169	1.391667	2.35191723	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	84	4.14e-17	NR	HMB03388.1	2691532	g14934	i0	67.9	1.97041420118343	56	18	99.4	0	168	1	259	314	HMB03388.1 LodA/GoxA family CTQ-dependent oxidase [Isosphaeraceae bacterium]	diamond	333	84	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
29774572	29774572	PRJNA1105232_S_NODE_14471_length_172_cov_3.357724_g14255_i0	PRJNA1105232	14471	172	3.357724	5.77528528	Candidatus Uabimicrobium	2897349	Bacteria	Bacteria	52.4	5.7e-6	NR	WP_151971054.1	2596890	g14255	i0	43.8	3.38372093023256	48	27	83.7	0	28	171	350	397	WP_151971054.1 SGNH/GDSL hydrolase family protein [Candidatus Uabimicrobium amorphum]	diamond	582	52.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
29941491	29941491	PRJNA1105232_S_NODE_17671_length_160_cov_2.216216_g17455_i0	PRJNA1105232	17671	160	2.216216	3.5459456	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	70.5	2.8e-13	NR	HEX5103568.1	2699754	g17455	i0	64	3.80625	50	18	93.8	0	7	156	109	158	HEX5103568.1 DUF885 domain-containing protein [Pirellulaceae bacterium]	diamond	609	70.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
30699497	30699497	PRJNA1105232_S_NODE_17334_length_162_cov_0.920354_g17118_i0	PRJNA1105232	17334	162	0.920354	1.49097348	Planctomycetota bacterium	2026780	Bacteria	Bacteria	57.4	4.11e-8	NR	HIJ72320.1	2026780	g17118	i0	50.9	0.981481481481482	53	25	98.1	1	3	161	109	160	HIJ72320.1 YdcF family protein [Planctomycetota bacterium]	diamond	159	57.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31015553	31015553	PRJNA1105232_S_NODE_12975_length_181_cov_1.181818_g12759_i0	PRJNA1105232	12975	181	1.181818	2.13909058	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	69.3	6.44e-12	NR	WP_151966163.1	2596890	g12759	i0	71.1	2.2707182320442	45	13	74.6	0	27	161	265	309	WP_151966163.1 M28 family metallopeptidase [Candidatus Uabimicrobium amorphum]	diamond	411	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
32439165	32439165	PRJNA1105232_S_NODE_13279_length_179_cov_1.500000_g13063_i0	PRJNA1105232	13279	179	1.5	2.685	Planctomycetes bacterium TBK1r	2527963	Bacteria	Bacteria	45.1	0.00245	NR	QDV82623.1	2527963	g13063	i0	40.8	1.42458100558659	49	29	82.1	0	155	9	489	537	QDV82623.1 CHAT domain protein [Planctomycetes bacterium TBK1r]	diamond	255	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis

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