metadata: contig_metadata: 30 rows where analysis = "diamond", bioproject = "PRJNA944150" and tax

30 rows where analysis = "diamond", bioproject = "PRJNA944150" 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
20385394	20385394	PRJNA944150_P_NODE_29836_length_177_cov_2.976562_g29585_i0	PRJNA944150	29836	177	2.976562	5.26851474	Humisphaera sp.	2807514	Bacteria	Bacteria	108	2.56e-26	NR	HEX8916314.1	2807514	g29585	i0	90	1.01694915254237	60	4	98.3	1	3	176	285	344	HEX8916314.1 peptidase U32 family protein [Humisphaera sp.]	diamond	180	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera sp.
21325919	21325919	PRJNA944150_P_NODE_45157_length_161_cov_0.910714_g44906_i0	PRJNA944150	45157	161	0.910714	1.46624954	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	84	3.62e-17	NR	MCU0704282.1	1914235	g44906	i0	76.6	0.875776397515528	47	11	87.6	0	150	10	94	140	MCU0704282.1 NADH-quinone oxidoreductase subunit M [Fimbriiglobus sp.]	diamond	141	84	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
26683739	26683739	PRJNA944150_P_NODE_16761_length_210_cov_3.521739_g16510_i0	PRJNA944150	16761	210	3.521739	7.3956519	Bacteria	2	Bacteria	Bacteria	53.9	2.69e-6	NR	MBA3312052.1	2026779	g16510	i0	78.1	3.2	32	7	45.7	0	113	208	144	175	MBA3312052.1 Do family serine endopeptidase [Planctomycetaceae bacterium]	diamond	672	53.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26961834	26961834	PRJNA944150_P_NODE_23902_length_188_cov_3.035971_g23651_i0	PRJNA944150	23902	188	3.035971	5.70762548	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.2	1.44e-12	NR	MCE9566045.1	2026780	g23651	i0	66.7	0.718085106382979	45	15	71.8	0	182	48	97	141	MCE9566045.1 hypothetical protein [Planctomycetota bacterium]	diamond	135	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26961840	26961840	PRJNA944150_P_NODE_37682_length_166_cov_0.871795_g37431_i0	PRJNA944150	37682	166	0.871795	1.4471797	Gemmataceae bacterium	2052164	Bacteria	Bacteria	46.2	7.81e-4	NR	MCI0456912.1	2052164	g37431	i0	49	0.921686746987952	51	20	92.2	1	14	166	201	245	MCI0456912.1 MoxR family ATPase [Gemmataceae bacterium]	diamond	153	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27467818	27467818	PRJNA944150_P_NODE_32423_length_173_cov_0.862903_g32172_i0	PRJNA944150	32423	173	0.862903	1.49282219	Planctomycetota bacterium	2026780	Bacteria	Bacteria	73.9	1.38e-13	NR	MBI5764028.1	2026780	g32172	i0	77.8	0.780346820809249	45	10	78	0	37	171	2	46	MBI5764028.1 serine/threonine protein kinase [Planctomycetota bacterium]	diamond	135	73.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27499376	27499376	PRJNA944150_P_NODE_35863_length_167_cov_0.864407_g35612_i0	PRJNA944150	35863	167	0.864407	1.44355969	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.2	4.15e-13	NR	MCP4614407.1	2026780	g35612	i0	52.8	0.952095808383233	53	25	95.2	0	163	5	24	76	MCP4614407.1 phosphoesterase [Planctomycetota bacterium]	diamond	159	71.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27657342	27657342	PRJNA944150_P_NODE_48244_length_151_cov_2.764706_g47993_i0	PRJNA944150	48244	151	2.764706	4.17470606	Planctomycetota bacterium	2026780	Bacteria	Bacteria	62	1.62e-9	NR	MCH7686076.1	2026780	g47993	i0	66	1.88741721854305	47	16	93.4	0	9	149	430	476	MCH7686076.1 hypothetical protein [Planctomycetota bacterium]	diamond	285	62	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28509675	28509675	PRJNA944150_P_NODE_33507_length_171_cov_1.131148_g33256_i0	PRJNA944150	33507	171	1.131148	1.93426308	Planctomycetota bacterium	2026780	Bacteria	Bacteria	108	9.06e-26	NR	MCY2961948.1	2026780	g33256	i0	89.3	0.982456140350877	56	6	98.2	0	2	169	157	212	MCY2961948.1 M14 family metallopeptidase [Planctomycetota bacterium]	diamond	168	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28572746	28572746	PRJNA944150_P_NODE_26807_length_183_cov_2.164179_g26556_i0	PRJNA944150	26807	183	2.164179	3.96044757	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	107	3.07e-25	NR	HET6573639.1	1914235	g26556	i0	83.3	1.9672131147541	60	10	98.4	0	181	2	357	416	HET6573639.1 lipopolysaccharide kinase InaA family protein [Fimbriiglobus sp.]	diamond	360	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
28919921	28919921	PRJNA944150_P_NODE_24428_length_187_cov_6.014493_g24177_i0	PRJNA944150	24428	187	6.014493	11.24710191	Aquisphaera insulae	2712864	Bacteria	Bacteria	72.8	3.82e-13	NR	WP_165222447.1	2712864	g24177	i0	57.6	0.946524064171123	59	25	94.7	0	9	185	1	59	WP_165222447.1 efflux RND transporter periplasmic adaptor subunit [Aquisphaera insulae]	diamond	177	72.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera insulae
29078130	29078130	PRJNA944150_P_NODE_40588_length_164_cov_0.886957_g40337_i0	PRJNA944150	40588	164	0.886957	1.45460948	Gemmataceae bacterium	2052164	Bacteria	Bacteria	87.4	2.08e-18	NR	MFO0879429.1	2052164	g40337	i0	79.6	0.98780487804878	54	11	98.8	0	162	1	253	306	MFO0879429.1 DUF1501 domain-containing protein [Gemmataceae bacterium]	diamond	162	87.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29116476	29116476	PRJNA944150_P_NODE_40068_length_164_cov_1.417391_g39817_i0	PRJNA944150	40068	164	1.417391	2.32452124	PVC group	1783257	Bacteria	Bacteria	52.8	4.2e-7	NR	MEW6200195.1	2026780	g39817	i0	82.8	11.1585365853659	29	5	53	0	87	1	1	29	MEW6200195.1 MTH1187 family thiamine-binding protein [Planctomycetota bacterium]	diamond	1830	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29425082	29425082	PRJNA944150_P_NODE_30189_length_177_cov_1.234375_g29938_i0	PRJNA944150	30189	177	1.234375	2.18484375	Rubripirellula tenax	2528015	Bacteria	Bacteria	105	8.1e-25	NR	WP_186775929.1	2528015	g29938	i0	86.4	1	59	8	100	0	177	1	416	474	WP_186775929.1 ISNCY family transposase [Rubripirellula tenax]	diamond	177	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula tenax
29709040	29709040	PRJNA944150_P_NODE_40270_length_164_cov_0.886957_g40019_i0	PRJNA944150	40270	164	0.886957	1.45460948	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	52.8	3.57e-6	NR	MBA3315048.1	2026779	g40019	i0	66.7	0.603658536585366	33	11	60.4	0	163	65	295	327	MBA3315048.1 lipid kinase YegS [Planctomycetaceae bacterium]	diamond	99	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29772402	29772402	PRJNA944150_P_NODE_31091_length_175_cov_1.619048_g30840_i0	PRJNA944150	31091	175	1.619048	2.833334	Candidatus Brocadiaceae bacterium	2094028	Bacteria	Bacteria	40.8	0.0149	NR	MCR4319790.1	2094028	g30840	i0	55.6	0.462857142857143	27	12	46.3	0	90	170	9	35	MCR4319790.1 hypothetical protein [Candidatus Brocadiaceae bacterium]	diamond	81	40.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae		Candidatus Brocadiaceae bacterium
29772409	29772409	PRJNA944150_P_NODE_41591_length_163_cov_1.438596_g41340_i0	PRJNA944150	41591	163	1.438596	2.34491148	Planctomycetota bacterium	2026780	Bacteria	Bacteria	73.2	1.65e-13	NR	MEI7683389.1	2026780	g41340	i0	66	0.975460122699387	53	18	97.5	0	161	3	30	82	MEI7683389.1 sulfur carrier protein ThiS [Planctomycetota bacterium]	diamond	159	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30056726	30056726	PRJNA944150_P_NODE_32971_length_171_cov_8.032787_g32720_i0	PRJNA944150	32971	171	8.032787	13.73606577	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	106	8.72e-26	NR	HEX6987144.1	2026779	g32720	i0	86	2	57	8	100	0	1	171	188	244	HEX6987144.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	342	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30151405	30151405	PRJNA944150_P_NODE_37092_length_166_cov_1.538462_g36841_i0	PRJNA944150	37092	166	1.538462	2.55384692	Planctomycetia bacterium	2052181	Bacteria	Bacteria	119	1.6599999999999998e-31	NR	MBL8821909.1	2052181	g36841	i0	98.1	0.975903614457831	54	1	97.6	0	165	4	219	272	MBL8821909.1 esterase [Planctomycetia bacterium]	diamond	162	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
30214677	30214677	PRJNA944150_P_NODE_28432_length_180_cov_2.015267_g28181_i0	PRJNA944150	28432	180	2.015267	3.6274806	Pirellulales bacterium	2715253	Bacteria	Bacteria	75.1	4.76e-14	NR	HUY31240.1	2715253	g28181	i0	61	2.95	59	23	98.3	0	179	3	230	288	HUY31240.1 AIPR family protein [Pirellulales bacterium]	diamond	531	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30246657	30246657	PRJNA944150_P_NODE_37832_length_166_cov_0.871795_g37581_i0	PRJNA944150	37832	166	0.871795	1.4471797	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	90.1	1.6e-20	NR	HSZ56540.1	2876886	g37581	i0	75.9	0.975903614457831	54	13	97.6	0	162	1	131	184	HSZ56540.1 O-methyltransferase [Tepidisphaeraceae bacterium]	diamond	162	90.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30783580	30783580	PRJNA944150_P_NODE_26894_length_183_cov_1.723881_g26643_i0	PRJNA944150	26894	183	1.723881	3.15470223	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	42.4	0.0242	NR	HEV3165125.1	2691532	g26643	i0	48.9	0.737704918032787	45	23	73.8	0	177	43	1685	1729	HEV3165125.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	135	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
31130849	31130849	PRJNA944150_P_NODE_45995_length_159_cov_2.736364_g45744_i0	PRJNA944150	45995	159	2.736364	4.35081876	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	91.3	9.73e-20	NR	MCK6483657.1	2026778	g45744	i0	77.4	5	53	12	100	0	1	159	649	701	MCK6483657.1 hypothetical protein [Phycisphaerae bacterium]	diamond	795	91.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31232539	31232539	PRJNA944150_P_NODE_23915_length_188_cov_2.863309_g23664_i0	PRJNA944150	23915	188	2.863309	5.38302092	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	6.64e-7	NR	MBA4015698.1	117	g23664	i0	73.5	2.66489361702128	34	9	54.3	0	5	106	180	213	MBA4015698.1 phytanoyl-CoA dioxygenase [Pirellula sp.]	diamond	501	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
31479172	31479172	PRJNA944150_P_NODE_7536_length_312_cov_28.346008_g7285_i0	PRJNA944150	7536	312	28.346008	88.43954496	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	43.9	0.0317	NR	MBL0927283.1	2052180	g7285	i0	43.8	0.461538461538462	48	25	46.2	1	46	189	301	346	MBL0927283.1 coproporphyrinogen III oxidase family protein [Phycisphaerales bacterium]	diamond	144	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31637041	31637041	PRJNA944150_P_NODE_24436_length_187_cov_5.007246_g24185_i0	PRJNA944150	24436	187	5.007246	9.36355002	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.1	1.5e-10	NR	MBM3993867.1	2026780	g24185	i0	46.8	0.994652406417112	62	33	99.5	0	2	187	50	111	MBM3993867.1 hypothetical protein [Planctomycetota bacterium]	diamond	186	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31921811	31921811	PRJNA944150_P_NODE_44857_length_161_cov_0.910714_g44606_i0	PRJNA944150	44857	161	0.910714	1.46624954	Planctopirus limnophila	120	Bacteria	Bacteria	93.2	2.05e-20	NR	WP_013111982.1	120	g44606	i0	84.3	0.950310559006211	51	8	95	0	6	158	325	375	WP_013111982.1 hypothetical protein [Planctopirus limnophila]	diamond	153	93.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
32016689	32016689	PRJNA944150_P_NODE_30438_length_176_cov_2.118110_g30187_i0	PRJNA944150	30438	176	2.11811	3.7278736	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	65.1	1.98e-10	NR	HTN74652.1	2699754	g30187	i0	56.9	0.988636363636364	58	25	98.9	0	1	174	481	538	HTN74652.1 tubulin-like doman-containing protein [Pirellulaceae bacterium]	diamond	174	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
32301856	32301856	PRJNA944150_P_NODE_30259_length_176_cov_92.409449_g30008_i0	PRJNA944150	30259	176	92.409449	162.64063024	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.00809	NR	MBN8643811.1	2026780	g30008	i0	40.9	0.75	44	24	75	1	1	132	283	324	MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium]	diamond	132	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32308624	32308624	PRJNA944150_P_NODE_28079_length_181_cov_1.378788_g27828_i0	PRJNA944150	28079	181	1.378788	2.49560628	Planctomycetia	203683	Bacteria	Bacteria	120	1.57e-30	NR	MEQ1826331.1	117	g27828	i0	94.9	2.93370165745856	59	3	97.8	0	3	179	359	417	MEQ1826331.1 DUF1552 domain-containing protein [Pirellula sp.]	diamond	531	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.

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