metadata: contig_metadata: 21 rows where bioproject = "PRJNA1105232" and tax

21 rows where bioproject = "PRJNA1105232" 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
6590679	6590679	PRJNA1105232_S_NODE_2946_length_326_cov_1.765343_g2730_i0	PRJNA1105232	2946	326	1.765343	5.75501818	Bacteria	2	Bacteria	Bacteria	134	3.79e-34	NR	MCB1111354.1	2052156	g2730	i0	55.6	5.9079754601227	108	47	99.4	1	3	326	478	584	MCB1111354.1 phosphoenolpyruvate carboxykinase (GTP) [Chlamydiia bacterium]	diamond	1926	134	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
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
27762934	27762934	PRJNA1105232_S_NODE_1024_length_481_cov_5.129630_g812_i0	PRJNA1105232	1024	481	5.12963	24.6735203	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	128	2.9499999999999993e-31	NR	HXX41603.1	2201154	g812	i0	47.2	1.004158004158	161	83	99.2	2	1	477	342	502	HXX41603.1 S8 family serine peptidase [Chthoniobacterales bacterium]	diamond	483	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales 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
27952147	27952147	PRJNA1105232_S_NODE_4085_length_287_cov_2.840336_g3869_i0	PRJNA1105232	4085	287	2.840336	8.15176432	Prosthecobacter sp.	1965333	Bacteria	Bacteria	47	0.00207	NR	WP_395752574.1	1965333	g3869	i0	50	1.27526132404181	40	20	41.8	0	279	160	491	530	WP_395752574.1 hypothetical protein [Prosthecobacter sp.]	diamond	366	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
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
29499156	29499156	PRJNA1105232_S_NODE_15690_length_167_cov_2.567797_g15474_i0	PRJNA1105232	15690	167	2.567797	4.28822099	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	76.3	2.02e-14	NR	HEX4839823.1	2047756	g15474	i0	64.8	0.970059880239521	54	19	97	0	5	166	227	280	HEX4839823.1 oligoendopeptidase F [Rhabdochlamydiaceae bacterium]	diamond	162	76.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
29584936	29584936	PRJNA1105232_S_NODE_10710_length_196_cov_1.877551_g10494_i0	PRJNA1105232	10710	196	1.877551	3.67999996	Bacteria	2	Bacteria	Bacteria	86.3	4.72e-18	NR	HPC60402.1	2026799	g10494	i0	63.8	5.3265306122449	58	21	88.8	0	191	18	233	290	HPC60402.1 peptidoglycan recognition family protein [Verrucomicrobiota bacterium]	diamond	1044	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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
30469946	30469946	PRJNA1105232_S_NODE_17673_length_160_cov_2.180180_g17457_i0	PRJNA1105232	17673	160	2.18018	3.488288	Bacteria	2	Bacteria	Bacteria	47.8	2.09e-4	NR	MBU0677327.1	2026799	g17457	i0	43.6	2.04375	55	27	95.6	1	154	2	723	777	MBU0677327.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	327	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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
31964173	31964173	PRJNA1105232_S_NODE_2058_length_372_cov_4.445820_g1842_i0	PRJNA1105232	2058	372	4.44582	16.5384504	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	124	5.02e-30	NR	MEY2546246.1	2026799	g1842	i0	57.3	0.943548387096774	117	48	92.7	1	364	20	401	517	MEY2546246.1 serine protease AprX [Verrucomicrobiota bacterium]	diamond	351	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
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
32880282	32880282	PRJNA1105232_S_NODE_1580_length_410_cov_7.573407_g1365_i0	PRJNA1105232	1580	410	7.5734069999999996	31.0509687	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	118	8.959999999999999e-28	NR	MEY2546246.1	2026799	g1365	i0	47.1	1.00975609756098	138	69	98	1	407	6	369	506	MEY2546246.1 serine protease AprX [Verrucomicrobiota bacterium]	diamond	414	118	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;