metadata: contig_metadata: 24 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax

24 rows where analysis = "diamond", bioproject = "PRJNA788929" 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
8422339	8422339	PRJNA788929_P_NODE_19167_length_375_cov_26.605960_g18507_i0	PRJNA788929	19167	375	26.60596	99.77235	Pirellulales bacterium	2715253	Bacteria	Bacteria	178	4.64e-49	NR	HKD35556.1	2715253	g18507	i0	80	8.744	105	21	84	0	353	39	389	493	HKD35556.1 PSD1 and planctomycete cytochrome C domain-containing protein [Pirellulales bacterium]	diamond	3279	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
8422866	8422866	PRJNA788929_P_NODE_7387_length_690_cov_150.565640_g6750_i0	PRJNA788929	7387	690	150.56564	1038.902916	Chlamydiales bacterium	2047757	Bacteria	Bacteria	199	1.73e-61	NR	MCP5470421.1	2047757	g6750	i0	66.5	0.68695652173913	158	48	67.4	2	56	520	1	156	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	474	199	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
9697766	9697766	PRJNA788929_P_NODE_36228_length_257_cov_8.500000_g35567_i0	PRJNA788929	36228	257	8.5	21.845	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	100	1.05e-22	NR	HEV7299532.1	2876886	g35567	i0	88.7	0.618677042801556	53	6	61.9	0	12	170	373	425	HEV7299532.1 NADP-dependent isocitrate dehydrogenase [Tepidisphaeraceae bacterium]	diamond	159	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
12694022	12694022	PRJNA788929_P_NODE_41710_length_243_cov_0.905882_g41049_i0	PRJNA788929	41710	243	0.905882	2.20129326	Planctomycetota bacterium	2026780	Bacteria	Bacteria	153	1.9699999999999998e-42	NR	MBS0203346.1	2026780	g41049	i0	98.8	3.92592592592593	80	1	98.8	0	3	242	167	246	MBS0203346.1 FliI/YscN family ATPase [Planctomycetota bacterium]	diamond	954	153	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
13968222	13968222	PRJNA788929_P_NODE_34271_length_266_cov_10.663212_g33610_i0	PRJNA788929	34271	266	10.663212	28.36414392	Planctomycetota bacterium	2026780	Bacteria	Bacteria	119	3.08e-29	NR	MFO0946774.1	2026780	g33610	i0	70.7	0.845864661654135	75	22	84.6	0	17	241	226	300	MFO0946774.1 hypothetical protein [Planctomycetota bacterium]	diamond	225	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
14798200	14798200	PRJNA788929_P_NODE_44012_length_234_cov_5.204969_g43351_i0	PRJNA788929	44012	234	5.204969	12.17962746	Bacteria	2	Bacteria	Bacteria	100	2.45e-24	NR	WP_077025744.1	1891926	g43351	i0	75	3.12820512820513	60	15	76.9	0	227	48	141	200	WP_077025744.1 peptidylprolyl isomerase [Fuerstiella marisgermanici]	diamond	732	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
23722331	23722331	PRJNA788929_P_NODE_39619_length_247_cov_1.770115_g38958_i0	PRJNA788929	39619	247	1.770115	4.37218405	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	135	1.3e-35	NR	HET6573859.1	1914235	g38958	i0	87	1.67611336032389	69	9	83.8	0	18	224	202	270	HET6573859.1 Gfo/Idh/MocA family oxidoreductase [Fimbriiglobus sp.]	diamond	414	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
24995666	24995666	PRJNA788929_P_NODE_18280_length_386_cov_10.450479_g17620_i0	PRJNA788929	18280	386	10.450479	40.33884894	Gemmataceae bacterium	2052164	Bacteria	Bacteria	133	6.88e-38	NR	MBX9625473.1	2052164	g17620	i0	76.1	0.683937823834197	88	21	68.4	0	343	80	2	89	MBX9625473.1 hypothetical protein [Gemmataceae bacterium]	diamond	264	133	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
26736756	26736756	PRJNA788929_P_NODE_24961_length_320_cov_42.716599_g24300_i0	PRJNA788929	24961	320	42.716599	136.6931168	Gemmatales bacterium	2838789	Bacteria	Bacteria	196	8.61e-56	NR	MFO0815908.1	2838789	g24300	i0	100	0.88125	94	0	88.1	0	305	24	373	466	MFO0815908.1 M1 family aminopeptidase [Gemmatales bacterium]	diamond	282	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
26768818	26768818	PRJNA788929_P_NODE_11021_length_531_cov_21.919214_g10368_i0	PRJNA788929	11021	531	21.919214	116.39102634	Planctomycetales bacterium 71-1	2053591	Bacteria	Bacteria	177	2.07e-53	NR	OJW10282.1	1895807	g10368	i0	71.4	0.751412429378531	133	38	75.1	0	508	110	33	165	OJW10282.1 MAG: hypothetical protein BGO49_06965 [Planctomycetales bacterium 71-10]	diamond	399	177	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 71-10
26768821	26768821	PRJNA788929_P_NODE_18041_length_389_cov_7.031646_g17381_i0	PRJNA788929	18041	389	7.031646	27.35310294	Aureliella helgolandensis	2527968	Bacteria	Bacteria	145	2.81e-37	NR	WP_145082514.1	2527968	g17381	i0	51.7	0.910025706940874	118	57	91	0	24	377	799	916	WP_145082514.1 RHS repeat-associated core domain-containing protein [Aureliella helgolandensis]	diamond	354	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
26895703	26895703	PRJNA788929_P_NODE_10381_length_552_cov_23.653445_g9728_i0	PRJNA788929	10381	552	23.653445	130.5670164	Gemmataceae bacterium	2052164	Bacteria	Bacteria	125	6.4e-30	NR	HEY1861591.1	2052164	g9728	i0	78.1	1.60326086956522	73	16	39.7	0	542	324	467	539	HEY1861591.1 ferrous iron transporter B [Gemmataceae bacterium]	diamond	885	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27053791	27053791	PRJNA788929_P_NODE_7442_length_687_cov_45.074919_g6803_i0	PRJNA788929	7442	687	45.074919	309.66469353	Chlamydiales bacterium	2047757	Bacteria	Bacteria	201	6.06e-62	NR	MCP5470421.1	2047757	g6803	i0	66	0.694323144104803	159	49	68.1	2	70	537	1	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	477	201	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27220712	27220712	PRJNA788929_P_NODE_48442_length_208_cov_8.066667_g47781_i0	PRJNA788929	48442	208	8.066667	16.77866736	Bacteria	2	Bacteria	Bacteria	100	5.04e-24	NR	MDA1180656.1	2026780	g47781	i0	79.7	1.70192307692308	59	12	85.1	0	199	23	148	206	MDA1180656.1 glycosyltransferase family 2 protein [Planctomycetota bacterium]	diamond	354	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27874921	27874921	PRJNA788929_P_NODE_6905_length_722_cov_54.517720_g6276_i0	PRJNA788929	6905	722	54.51772	393.6179384	Gemmataceae bacterium	2052164	Bacteria	Bacteria	170	1.35e-47	NR	HWG46097.1	2052164	g6276	i0	49.4	1.36703601108033	162	82	67.3	0	652	167	158	319	HWG46097.1 SRPBCC family protein [Gemmataceae bacterium]	diamond	987	170	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27884180	27884180	PRJNA788929_P_NODE_39705_length_247_cov_0.885057_g39044_i0	PRJNA788929	39705	247	0.885057	2.18609079	Planctomycetia	203683	Bacteria	Bacteria	116	5.500000000000001e-28	NR	WP_145270110.1	2527974	g39044	i0	61.7	1.96761133603239	81	31	98.4	0	1	243	331	411	WP_145270110.1 phage tail protein [Tautonia plasticadhaerens]	diamond	486	117	0.991452991452991	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
27938215	27938215	PRJNA788929_P_NODE_25525_length_316_cov_25.485597_g24864_i0	PRJNA788929	25525	316	25.485597	80.53448652	Novipirellula caenicola	1536901	Bacteria	Bacteria	65.9	6.48e-10	NR	WP_345688334.1	1536901	g24864	i0	40.2	1.60443037974684	87	52	82.6	0	1	261	355	441	WP_345688334.1 Coenzyme F420 hydrogenase/dehydrogenase, beta subunit C-terminal domain [Novipirellula caenicola]	diamond	507	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Novipirellula	Novipirellula caenicola
28821891	28821891	PRJNA788929_P_NODE_31428_length_280_cov_6.536232_g30767_i0	PRJNA788929	31428	280	6.536232	18.3014496	Isosphaera sp.	41672	Bacteria	Bacteria	43.1	0.0443	NR	MBA4066593.1	41672	g30767	i0	71.9	0.342857142857143	32	8	33.2	1	163	71	12	43	MBA4066593.1 chemotaxis protein CheR [Isosphaera sp.]	diamond	96	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp.
29011976	29011976	PRJNA788929_P_NODE_31788_length_278_cov_9.507317_g31127_i0	PRJNA788929	31788	278	9.507317	26.43034126	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	118	5.28e-29	NR	MBJ7423871.1	2562705	g31127	i0	68.4	1.7158273381295	79	25	85.3	0	25	261	53	131	MBJ7423871.1 condensation domain protein [Akkermansiaceae bacterium]	diamond	477	118	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
29021204	29021204	PRJNA788929_P_NODE_39928_length_246_cov_15.317919_g39267_i0	PRJNA788929	39928	246	15.317919	37.68208074	Candidatus Protochlamydia	282132	Bacteria	Bacteria	134	9.06e-36	NR	WP_213106441.1	362787	g39267	i0	83.1	1.8780487804878	77	13	93.9	0	3	233	194	270	WP_213106441.1 amino acid permease [Candidatus Protochlamydia amoebophila]	diamond	462	135	0.992592592592593	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
30148290	30148290	PRJNA788929_P_NODE_44372_length_232_cov_6.559748_g43711_i0	PRJNA788929	44372	232	6.559748	15.21861536	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	90.5	7.68e-20	NR	MEI7928632.1	2026801	g43711	i0	65.2	2.63793103448276	69	23	87.9	1	209	6	192	260	MEI7928632.1 DUF692 family multinuclear iron-containing protein [Verrucomicrobiales bacterium]	diamond	612	90.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30306978	30306978	PRJNA788929_P_NODE_10532_length_547_cov_10.597046_g9879_i0	PRJNA788929	10532	547	10.597046	57.96584162	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	148	1.22e-41	NR	HIB68404.1	2052180	g9879	i0	53.8	0.712979890310786	130	59	70.7	1	531	145	42	171	HIB68404.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Phycisphaerales bacterium]	diamond	390	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30527605	30527605	PRJNA788929_P_NODE_49733_length_200_cov_5.590551_g49072_i0	PRJNA788929	49733	200	5.590551	11.181102	Limnoglobus roseus	2598579	Bacteria	Bacteria	87.4	3.83e-18	NR	WP_149108296.1	2598579	g49072	i0	75	2.37	52	13	78	0	176	21	557	608	WP_149108296.1 flagellar biosynthesis protein FlhA [Limnoglobus roseus]	diamond	474	87.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
30590760	30590760	PRJNA788929_P_NODE_44713_length_230_cov_12.171975_g44052_i0	PRJNA788929	44713	230	12.171975	27.9955425	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	65.5	1.24e-11	NR	HEX3446947.1	2691532	g44052	i0	66	1.26521739130435	50	17	65.2	0	24	173	59	108	HEX3446947.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	291	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae 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);;