metadata: contig_metadata: 33 rows where analysis = "diamond", bioproject = "PRJNA222400" and tax

33 rows where analysis = "diamond", bioproject = "PRJNA222400" 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
367262	367262	PRJNA222400_P_NODE_9001_length_163_cov_0.912281_g8968_i0	PRJNA222400	9001	163	0.912281	1.48701803	Pseudomonadati	3379134	Bacteria	Bacteria	82.8	7.68e-17	NR	WP_068772074.1	1184151	g8968	i0	78.8	5.8159509202454	52	11	95.7	0	161	6	31	82	WP_068772074.1 phosphoglycerate kinase [Termitidicoccus mucosus]	diamond	948	82.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
27105388	27105388	PRJNA222400_P_NODE_1162_length_478_cov_1.263403_g1129_i0	PRJNA222400	1162	478	1.263403	6.03906634	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	60.1	3.56e-7	NR	NKB25011.1	2212473	g1129	i0	38.1	0.608786610878661	97	41	60.3	3	3	290	390	468	NKB25011.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	291	60.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27249782	27249782	PRJNA222400_P_NODE_483_length_733_cov_2.514620_g455_i0	PRJNA222400	483	733	2.51462	18.4321646	Bacteria	2	Bacteria	Bacteria	61.6	6.25e-7	NR	MCX6884131.1	2026799	g455	i0	31.3	1.08458390177353	128	83	50.8	2	608	237	44	170	MCX6884131.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	795	62	0.993548387096774	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27737689	27737689	PRJNA222400_P_NODE_2104_length_345_cov_1.179054_g2071_i0	PRJNA222400	2104	345	1.179054	4.0677363	Rubripirellula sp.	1973111	Bacteria	Bacteria	45.4	0.014	NR	MDE0865248.1	1973111	g2071	i0	35.4	0.834782608695652	96	54	76.5	1	63	326	1940	2035	MDE0865248.1 Ig-like domain-containing protein [Rubripirellula sp.]	diamond	288	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula sp.
27832034	27832034	PRJNA222400_P_NODE_1064_length_500_cov_1.917960_g1031_i0	PRJNA222400	1064	500	1.91796	9.5898	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	47	0.00862	NR	MBT15889.1	2026801	g1031	i0	29.6	0.648	108	63	60	3	14	313	58	160	MBT15889.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	324	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28007895	28007895	PRJNA222400_P_NODE_8225_length_166_cov_0.888889_g8192_i0	PRJNA222400	8225	166	0.888889	1.47555574	root	1	Root_unresolved	Root_unresolved	53.5	7.44e-7	NR	WP_154931914.1	122	g8192	i0	50	5.53012048192771	52	25	92.2	1	12	164	58	109	WP_154931914.1 ankyrin repeat domain-containing protein [Gimesia maris]	diamond	918	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
28021694	28021694	PRJNA222400_P_NODE_7165_length_169_cov_0.866667_g7132_i0	PRJNA222400	7165	169	0.866667	1.46466723	Planctomycetota bacterium	2026780	Bacteria	Bacteria	82	1.97e-16	NR	MBI2560779.1	2026780	g7132	i0	69.2	2.87573964497041	52	16	92.3	0	156	1	623	674	MBI2560779.1 glycosyltransferase [Planctomycetota bacterium]	diamond	486	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28084584	28084584	PRJNA222400_P_NODE_6385_length_177_cov_2.031250_g6352_i0	PRJNA222400	6385	177	2.03125	3.5953125	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	47.8	2.63e-4	NR	MFH1046421.1	2035772	g6352	i0	44.9	0.830508474576271	49	27	83.1	0	149	3	1934	1982	MFH1046421.1 LamG-like jellyroll fold domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	147	47.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
28495304	28495304	PRJNA222400_P_NODE_9347_length_162_cov_0.920354_g9314_i0	PRJNA222400	9347	162	0.920354	1.49097348	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	103	1.9099999999999994e-24	NR	MCC7335815.1	2699754	g9314	i0	94.3	0.981481481481482	53	3	98.1	0	161	3	354	406	MCC7335815.1 DUF1501 domain-containing protein [Pirellulaceae bacterium]	diamond	159	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28670903	28670903	PRJNA222400_P_NODE_7567_length_168_cov_0.873950_g7534_i0	PRJNA222400	7567	168	0.87395	1.468236	Bacteria	2	Bacteria	Bacteria	56.2	2.25e-7	NR	MEQ9409136.1	1936112	g7534	i0	47.3	1.91071428571429	55	29	98.2	0	167	3	116	170	MEQ9409136.1 hypothetical protein [Fuerstiella sp.]	diamond	321	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
28716254	28716254	PRJNA222400_P_NODE_7407_length_168_cov_1.302521_g7374_i0	PRJNA222400	7407	168	1.302521	2.18823528	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	59.3	1.13e-8	NR	MCD4781063.1	2035772	g7374	i0	57.4	1.67857142857143	47	17	83.9	1	145	5	172	215	MCD4781063.1 SDR family oxidoreductase [Candidatus Omnitrophota bacterium]	diamond	282	59.3	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
28779188	28779188	PRJNA222400_P_NODE_5587_length_190_cov_0.964539_g5554_i0	PRJNA222400	5587	190	0.964539	1.8326241	Opitutaceae bacterium	2006848	Bacteria	Bacteria	51.6	1.36e-5	NR	HQF39152.1	2006848	g5554	i0	49.2	4.56315789473684	61	29	96.3	1	184	2	305	363	HQF39152.1 serpin family protein [Opitutaceae bacterium]	diamond	867	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28796873	28796873	PRJNA222400_P_NODE_2947_length_276_cov_0.894273_g2914_i0	PRJNA222400	2947	276	0.894273	2.46819348	Bacteria	2	Bacteria	Bacteria	94	5.21e-20	NR	OHB45662.1	1801952	g2914	i0	53.3	4.71739130434783	90	39	97.8	1	2	271	329	415	OHB45662.1 MAG: arginine--tRNA ligase [Planctomycetes bacterium GWC2_45_44]	diamond	1302	94	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium GWC2_45_44
28968847	28968847	PRJNA222400_P_NODE_9208_length_162_cov_1.380531_g9175_i0	PRJNA222400	9208	162	1.380531	2.23646022	Gemmata sp.	1914242	Bacteria	Bacteria	60.1	9.67e-9	NR	HEV3386825.1	1914242	g9175	i0	50	1.72222222222222	54	27	100	0	162	1	185	238	HEV3386825.1 hypothetical protein [Gemmata sp.]	diamond	279	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
29000700	29000700	PRJNA222400_P_NODE_1368_length_442_cov_1.521628_g1335_i0	PRJNA222400	1368	442	1.521628	6.72559576	Chthoniobacter sp.	2510640	Bacteria	Bacteria	61.2	1.16e-7	NR	WP_348543608.1	2510640	g1335	i0	35.8	0.834841628959276	123	75	80.8	4	58	414	83	205	WP_348543608.1 beta strand repeat-containing protein, partial [Chthoniobacter sp.]	diamond	369	61.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
29032138	29032138	PRJNA222400_P_NODE_5548_length_190_cov_1.475177_g5515_i0	PRJNA222400	5548	190	1.475177	2.8028363	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	73.6	2.43e-13	NR	MFN0131981.1	2052180	g5515	i0	52.5	3.80526315789474	59	28	93.2	0	179	3	249	307	MFN0131981.1 M14 family zinc carboxypeptidase [Phycisphaerales bacterium]	diamond	723	73.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29126888	29126888	PRJNA222400_P_NODE_449_length_755_cov_1.385269_g422_i0	PRJNA222400	449	755	1.385269	10.45878095	Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8	1797601	Bacteria	Bacteria	127	1.1e-31	NR	OGN61875.1	1797601	g422	i0	38.5	0.762913907284768	192	101	71.9	5	105	647	67	252	OGN61875.1 MAG: hypothetical protein A3F40_03365 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8]	diamond	576	127	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8
29126892	29126892	PRJNA222400_P_NODE_6889_length_171_cov_2.098361_g6856_i0	PRJNA222400	6889	171	2.098361	3.58819731	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	62.4	1.62e-9	NR	MBY0307194.1	2052180	g6856	i0	53.3	2.33333333333333	45	21	78.9	0	1	135	304	348	MBY0307194.1 cation transporter [Phycisphaerales bacterium]	diamond	399	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29410681	29410681	PRJNA222400_P_NODE_6649_length_174_cov_1.560000_g6616_i0	PRJNA222400	6649	174	1.56	2.7144	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	65.9	8.19e-11	NR	HTY13832.1	2035772	g6616	i0	60	1.58620689655172	45	18	77.6	0	161	27	71	115	HTY13832.1 6-bladed beta-propeller [Candidatus Omnitrophota bacterium]	diamond	276	65.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
29554664	29554664	PRJNA222400_P_NODE_8690_length_164_cov_0.904348_g8657_i0	PRJNA222400	8690	164	0.904348	1.48313072	Pseudomonadati	3379134	Bacteria	Bacteria	44.7	0.00267	NR	HUQ70134.1	2026779	g8657	i0	42.6	1.8109756097561	47	27	86	0	20	160	365	411	HUQ70134.1 ankyrin repeat domain-containing protein [Planctomycetaceae bacterium]	diamond	297	45.1	0.991130820399113	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30263869	30263869	PRJNA222400_P_NODE_6752_length_173_cov_1.258065_g6719_i0	PRJNA222400	6752	173	1.258065	2.17645245	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	60.8	5.9e-9	NR	HEX4052836.1	2876886	g6719	i0	54.4	0.988439306358382	57	26	98.8	0	2	172	610	666	HEX4052836.1 alanine--tRNA ligase [Tepidisphaeraceae bacterium]	diamond	171	60.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30421900	30421900	PRJNA222400_P_NODE_213_length_1013_cov_3.742739_g196_i0	PRJNA222400	213	1013	3.742739	37.91394607	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.6	1.74e-8	NR	MDQ7779968.1	2026780	g196	i0	36.8	0.370187561697927	125	57	36.7	3	909	538	1536	1639	MDQ7779968.1 fibronectin type III domain-containing protein [Planctomycetota bacterium]	diamond	375	68.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30895616	30895616	PRJNA222400_P_NODE_3254_length_256_cov_1.444444_g3221_i0	PRJNA222400	3254	256	1.444444	3.69777664	Planctomycetota bacterium	2026780	Bacteria	Bacteria	127	1.98e-32	NR	MFN0007456.1	2026780	g3221	i0	71.8	2.9765625	85	22	99.6	1	2	256	177	259	MFN0007456.1 cystathionine beta-synthase [Planctomycetota bacterium]	diamond	762	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31053725	31053725	PRJNA222400_P_NODE_1655_length_396_cov_1.285303_g1622_i0	PRJNA222400	1655	396	1.285303	5.08979988	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	52.8	6.63e-5	NR	MBK9138994.1	2026799	g1622	i0	50	0.378787878787879	50	23	37.9	1	394	245	1265	1312	MBK9138994.1 S8 family serine peptidase [Verrucomicrobiota bacterium]	diamond	150	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31496288	31496288	PRJNA222400_P_NODE_8476_length_165_cov_0.896552_g8443_i0	PRJNA222400	8476	165	0.896552	1.4793108	Fuerstiella sp.	1936112	Bacteria	Bacteria	52.4	4.98e-6	NR	MEQ9409136.1	1936112	g8443	i0	51.9	3.89090909090909	52	25	94.5	0	157	2	116	167	MEQ9409136.1 hypothetical protein [Fuerstiella sp.]	diamond	642	52.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
31545644	31545644	PRJNA222400_P_NODE_2336_length_323_cov_1.503650_g2303_i0	PRJNA222400	2336	323	1.50365	4.8567895	Pseudomonadati	3379134	Bacteria	Bacteria	123	1.29e-31	NR	PYL06424.1	2026799	g2303	i0	65.2	8.30340557275542	89	31	82.7	0	56	322	1	89	PYL06424.1 MAG: NADPH:quinone reductase [Verrucomicrobiota bacterium]	diamond	2682	124	0.991935483870968	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31622536	31622536	PRJNA222400_P_NODE_5016_length_199_cov_1.340000_g4983_i0	PRJNA222400	5016	199	1.34	2.6666	Gemmataceae bacterium	2052164	Bacteria	Bacteria	73.2	3.96e-13	NR	HVK07938.1	2052164	g4983	i0	54.2	2.68341708542714	59	27	88.9	0	199	23	451	509	HVK07938.1 S8 family serine peptidase [Gemmataceae bacterium]	diamond	534	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31843885	31843885	PRJNA222400_P_NODE_1577_length_406_cov_2.019608_g1544_i0	PRJNA222400	1577	406	2.019608	8.19960848	Chlamydiia bacterium	2052156	Bacteria	Bacteria	61.6	7.96e-9	NR	MCB1115924.1	2052156	g1544	i0	37.9	1.21182266009852	95	51	64.3	3	350	90	61	155	MCB1115924.1 DoxX family protein [Chlamydiia bacterium]	diamond	492	61.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32002224	32002224	PRJNA222400_P_NODE_298_length_891_cov_1.720903_g275_i0	PRJNA222400	298	891	1.720903	15.33324573	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	56.2	6.62e-5	NR	MEM7396574.1	2026799	g275	i0	31.3	0.387205387205387	115	74	37	2	533	204	227	341	MEM7396574.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	345	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32097097	32097097	PRJNA222400_P_NODE_3118_length_265_cov_1.101852_g3085_i0	PRJNA222400	3118	265	1.101852	2.9199078	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	80.9	1.88e-15	NR	MCX6968401.1	2026799	g3085	i0	50.7	0.80377358490566	71	35	80.4	0	50	262	544	614	MCX6968401.1 PAS domain S-box protein [Verrucomicrobiota bacterium]	diamond	213	80.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32097099	32097099	PRJNA222400_P_NODE_5958_length_184_cov_1.155556_g5925_i0	PRJNA222400	5958	184	1.155556	2.12622304	Chlamydiota bacterium	2081524	Bacteria	Bacteria	46.6	6.09e-4	NR	MEM7175885.1	2081524	g5925	i0	47.7	2.13586956521739	44	23	71.7	0	2	133	144	187	MEM7175885.1 ankyrin repeat domain-containing protein [Chlamydiota bacterium]	diamond	393	46.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32097103	32097103	PRJNA222400_P_NODE_7958_length_166_cov_1.683761_g7925_i0	PRJNA222400	7958	166	1.683761	2.79504326	Chlamydiales bacterium	2047757	Bacteria	Bacteria	70.9	2.43e-14	NR	HSX13502.1	2047757	g7925	i0	60	1.98795180722892	55	20	99.4	1	1	165	21	73	HSX13502.1 2OG-Fe(II) oxygenase [Chlamydiales bacterium]	diamond	330	70.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32697533	32697533	PRJNA222400_P_NODE_3600_length_238_cov_1.867725_g3567_i0	PRJNA222400	3600	238	1.867725	4.4451855	Thalassoroseus pseudoceratinae	2713176	Bacteria	Bacteria	48.1	4.6e-4	NR	WP_166819882.1	2713176	g3567	i0	38	0.995798319327731	79	49	99.6	0	1	237	4087	4165	WP_166819882.1 Calx-beta domain-containing protein [Thalassoroseus pseudoceratinae]	diamond	237	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoroseus	Thalassoroseus pseudoceratinae

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