metadata: contig_metadata: 28 rows where analysis = "diamond", bioproject = "PRJNA807347" and tax

28 rows where analysis = "diamond", bioproject = "PRJNA807347" 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
4634679	4634679	PRJNA807347_P_NODE_10284_length_265_cov_1.536458_g10181_i0	PRJNA807347	10284	265	1.536458	4.0716137	Pseudomonadati	3379134	Bacteria	Bacteria	98.2	1.1699999999999997e-23	NR	MEW6306307.1	2026799	g10181	i0	56.6	4.93584905660377	83	36	94	0	3	251	79	161	MEW6306307.1 DoxX family protein [Verrucomicrobiota bacterium]	diamond	1308	98.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
5909677	5909677	PRJNA807347_P_NODE_13505_length_249_cov_0.880682_g13402_i0	PRJNA807347	13505	249	0.880682	2.19289818	Prosthecobacter sp.	1965333	Bacteria	Bacteria	142	1.44e-38	NR	MCA1963998.1	1965333	g13402	i0	77.8	0.975903614457831	81	18	97.6	0	248	6	316	396	MCA1963998.1 DUF1552 domain-containing protein [Prosthecobacter sp.]	diamond	243	142	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
11010150	11010150	PRJNA807347_P_NODE_15369_length_245_cov_0.906977_g15266_i0	PRJNA807347	15369	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	61.2	1.16e-8	NR	MDZ4818058.1	2026780	g15266	i0	63.3	1.48163265306122	49	18	60	0	3	149	744	792	MDZ4818058.1 ribonuclease R [Planctomycetota bacterium]	diamond	363	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
13976398	13976398	PRJNA807347_P_NODE_16991_length_242_cov_0.923077_g16888_i0	PRJNA807347	16991	242	0.923077	2.23384634	Planctomycetota bacterium	2026780	Bacteria	Bacteria	87.8	6.55e-20	NR	RMH30670.1	2026780	g16888	i0	60.8	1.83471074380165	74	25	91.7	1	222	1	1	70	RMH30670.1 MAG: CBS domain-containing protein [Planctomycetota bacterium]	diamond	444	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
21208598	21208598	PRJNA807347_P_NODE_17757_length_228_cov_2.258065_g17654_i0	PRJNA807347	17757	228	2.258065	5.1483882	Roseibacillus sp. TMED18	1986590	Bacteria	Bacteria	110	3.3300000000000003e-26	NR	RPF84718.1	1986590	g17654	i0	72	1.97368421052632	75	21	98.7	0	228	4	932	1006	RPF84718.1 MAG: DUF1553 domain-containing protein [Roseibacillus sp. TMED18]	diamond	450	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseibacillus	Roseibacillus sp. TMED18
26610805	26610805	PRJNA807347_P_NODE_16841_length_242_cov_0.923077_g16738_i0	PRJNA807347	16841	242	0.923077	2.23384634	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	70.1	7.96e-12	NR	HEY5041677.1	2499141	g16738	i0	47.3	1.7603305785124	74	38	91.7	1	226	5	101	173	HEY5041677.1 serine hydrolase domain-containing protein [Verrucomicrobiia bacterium]	diamond	426	70.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26746145	26746145	PRJNA807347_P_NODE_16261_length_243_cov_1.511765_g16158_i0	PRJNA807347	16261	243	1.511765	3.67358895	Pseudomonadati	3379134	Bacteria	Bacteria	140	1.16e-37	NR	TVR50058.1	2026784	g16158	i0	77.5	1.97530864197531	80	17	98.8	1	241	2	143	221	TVR50058.1 MAG: sulfatase [Puniceicoccaceae bacterium]	diamond	480	141	0.99290780141844	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Puniceicoccaceae		Puniceicoccaceae bacterium
27307181	27307181	PRJNA807347_P_NODE_8103_length_289_cov_1.222222_g8000_i0	PRJNA807347	8103	289	1.222222	3.53222158	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	57.8	3.23e-7	NR	MBP5787086.1	2212473	g8000	i0	47.6	0.653979238754325	63	33	65.4	0	234	46	137	199	MBP5787086.1 IS110 family transposase [Kiritimatiellia bacterium]	diamond	189	57.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27568456	27568456	PRJNA807347_P_NODE_7704_length_295_cov_1.036036_g7601_i0	PRJNA807347	7704	295	1.036036	3.0563062	Pseudomonadati	3379134	Bacteria	Bacteria	101	1.9300000000000001e-22	NR	MCZ6573397.1	2026780	g7601	i0	52.6	2.96949152542373	97	46	98.6	0	1	291	363	459	MCZ6573397.1 5-methyltetrahydropteroyltriglutamate--homocysteine S-methyltransferase [Planctomycetota bacterium]	diamond	876	101	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27906751	27906751	PRJNA807347_P_NODE_15865_length_244_cov_0.912281_g15762_i0	PRJNA807347	15865	244	0.912281	2.22596564	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	43.5	0.0187	NR	MBX3393132.1	2026777	g15762	i0	33.3	0.774590163934426	63	39	73.8	2	197	18	10	72	MBX3393132.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	189	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
28231352	28231352	PRJNA807347_P_NODE_11826_length_252_cov_2.385475_g11723_i0	PRJNA807347	11826	252	2.385475	6.011397	Candidatus Brocadia	380240	Bacteria	Bacteria	149	1.6e-39	NR	WP_052564505.1	380240	g11723	i0	80	5.05952380952381	85	16	100	1	1	252	345	429	WP_052564505.1 MULTISPECIES: hypothetical protein [Candidatus Brocadia]	diamond	1275	150	0.993333333333333	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Brocadia
28538699	28538699	PRJNA807347_P_NODE_16967_length_242_cov_0.923077_g16864_i0	PRJNA807347	16967	242	0.923077	2.23384634	Limisphaerales bacterium	2052186	Bacteria	Bacteria	112	9.86e-28	NR	MFN7138329.1	2052186	g16864	i0	72.2	1.97107438016529	79	22	97.9	0	239	3	65	143	MFN7138329.1 fibronectin type III domain-containing protein [Limisphaerales bacterium]	diamond	477	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
29517157	29517157	PRJNA807347_P_NODE_17290_length_241_cov_3.863095_g17187_i0	PRJNA807347	17290	241	3.863095	9.31005895	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	102	3.33e-23	NR	HMB03686.1	2691532	g17187	i0	74.3	2.75103734439834	70	16	87.1	1	30	239	413	480	HMB03686.1 cytochrome b N-terminal domain-containing protein [Isosphaeraceae bacterium]	diamond	663	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
29643251	29643251	PRJNA807347_P_NODE_13930_length_248_cov_0.885714_g13827_i0	PRJNA807347	13930	248	0.885714	2.19657072	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	87.8	5.51e-18	NR	MBL8870221.1	2026779	g13827	i0	57.3	0.991935483870968	82	35	99.2	0	246	1	692	773	MBL8870221.1 DUF1553 domain-containing protein [Planctomycetaceae bacterium]	diamond	246	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29810191	29810191	PRJNA807347_P_NODE_11571_length_253_cov_1.750000_g11468_i0	PRJNA807347	11571	253	1.75	4.4275	PVC group	1783257	Bacteria	Bacteria	133	5.1999999999999994e-36	NR	NDF17525.1	2026799	g11468	i0	85.5	2.78656126482213	69	10	81.8	0	6	212	94	162	NDF17525.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	705	134	0.992537313432836	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30148740	30148740	PRJNA807347_P_NODE_12412_length_251_cov_0.876404_g12309_i0	PRJNA807347	12412	251	0.876404	2.19977404	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	46.2	0.0024	NR	HCG24971.1	2053569	g12309	i0	60	0.776892430278884	40	15	46.6	1	118	2	2	41	HCG24971.1 hypothetical protein [Lentisphaeria bacterium]	diamond	195	46.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
30211965	30211965	PRJNA807347_P_NODE_11032_length_258_cov_1.578378_g10929_i0	PRJNA807347	11032	258	1.578378	4.07221524	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	136	5.979999999999998e-35	NR	MEY4244251.1	2026799	g10929	i0	89.4	0.988372093023256	85	9	98.8	0	2	256	310	394	MEY4244251.1 Multidrug export protein AcrF [Verrucomicrobiota bacterium]	diamond	255	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30465271	30465271	PRJNA807347_P_NODE_6673_length_317_cov_1.569672_g6570_i0	PRJNA807347	6673	317	1.569672	4.97586024	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	52.4	3.54e-5	NR	MEI6425623.1	1932692	g6570	i0	51.2	0.406940063091483	43	21	40.7	0	113	241	104	146	MEI6425623.1 hypothetical protein [Lentisphaerota bacterium]	diamond	129	52.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
30591231	30591231	PRJNA807347_P_NODE_15773_length_244_cov_0.912281_g15670_i0	PRJNA807347	15773	244	0.912281	2.22596564	Opitutaceae bacterium	2006848	Bacteria	Bacteria	89.4	2.54e-21	NR	MFM8335803.1	2006848	g15670	i0	95.2	1.54918032786885	42	2	51.6	0	3	128	38	79	MFM8335803.1 DUF4266 domain-containing protein [Opitutaceae bacterium]	diamond	378	89.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30780845	30780845	PRJNA807347_P_NODE_8634_length_282_cov_2.315789_g8531_i0	PRJNA807347	8634	282	2.315789	6.53052498	Gemmataceae bacterium	2052164	Bacteria	Bacteria	75.5	1.4e-14	NR	HEY7422863.1	2052164	g8531	i0	47.1	0.925531914893617	87	38	84	1	1	237	91	177	HEY7422863.1 serpin family protein [Gemmataceae bacterium]	diamond	261	75.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31002129	31002129	PRJNA807347_P_NODE_16314_length_243_cov_0.917647_g16211_i0	PRJNA807347	16314	243	0.917647	2.22988221	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	141	3.0699999999999997e-37	NR	MBL8874085.1	2026779	g16211	i0	81.3	0.987654320987654	80	15	98.8	0	241	2	24	103	MBL8874085.1 DEAD/DEAH box helicase family protein [Planctomycetaceae bacterium]	diamond	240	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31476392	31476392	PRJNA807347_P_NODE_12036_length_252_cov_0.871508_g11933_i0	PRJNA807347	12036	252	0.871508	2.19620016	Phycisphaera sp.	2030824	Bacteria	Bacteria	165	2.52e-45	NR	MBI1302998.1	2030824	g11933	i0	98.8	0.988095238095238	83	1	98.8	0	3	251	602	684	MBI1302998.1 hypothetical protein [Phycisphaera sp.]	diamond	249	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
31539644	31539644	PRJNA807347_P_NODE_14416_length_247_cov_0.890805_g14313_i0	PRJNA807347	14416	247	0.890805	2.20028835	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	146	7.12e-39	NR	MBL0870494.1	2052180	g14313	i0	98.6	0.862348178137652	71	1	86.2	0	247	35	613	683	MBL0870494.1 ShlB/FhaC/HecB family hemolysin secretion/activation protein [Phycisphaerales bacterium]	diamond	213	146	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31697663	31697663	PRJNA807347_P_NODE_8777_length_281_cov_0.889423_g8674_i0	PRJNA807347	8777	281	0.889423	2.49927863	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0451	NR	MBI4614341.1	2026780	g8674	i0	33.8	0.725978647686833	68	39	69.4	2	50	244	21	85	MBI4614341.1 UPF0175 family protein [Planctomycetota bacterium]	diamond	204	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31887366	31887366	PRJNA807347_P_NODE_14517_length_247_cov_0.885057_g14414_i0	PRJNA807347	14517	247	0.885057	2.18609079	Gemmataceae bacterium	2052164	Bacteria	Bacteria	42.7	0.0352	NR	HKB40427.1	2052164	g14414	i0	36	1.08097165991903	89	45	93.5	3	245	15	78	166	HKB40427.1 methyltransferase domain-containing protein [Gemmataceae bacterium]	diamond	267	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32045757	32045757	PRJNA807347_P_NODE_17558_length_234_cov_2.012422_g17455_i0	PRJNA807347	17558	234	2.012422	4.70906748	Chlamydiia bacterium	2052156	Bacteria	Bacteria	75.1	5.1e-14	NR	MEI8329982.1	2052156	g17455	i0	63.8	0.743589743589744	58	19	73.1	2	233	63	204	260	MEI8329982.1 tRNA(His) guanylyltransferase Thg1 family protein [Chlamydiia bacterium]	diamond	174	75.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32140666	32140666	PRJNA807347_P_NODE_10178_length_266_cov_1.492228_g10075_i0	PRJNA807347	10178	266	1.492228	3.96932648	Opitutaceae bacterium	2006848	Bacteria	Bacteria	112	1.57e-26	NR	MBL9213736.1	2006848	g10075	i0	65.8	1.78195488721805	79	27	89.1	0	264	28	583	661	MBL9213736.1 TonB-dependent receptor plug domain-containing protein [Opitutaceae bacterium]	diamond	474	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32140669	32140669	PRJNA807347_P_NODE_16758_length_242_cov_1.781065_g16655_i0	PRJNA807347	16758	242	1.781065	4.3101773	Sedimentisphaera salicampi	1941349	Bacteria	Bacteria	57	3.32e-7	NR	WP_094759418.1	1941349	g16655	i0	68.4	1.88429752066116	38	12	47.1	0	145	32	318	355	WP_094759418.1 tryptophan synthase subunit beta [Sedimentisphaera salicampi]	diamond	456	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Sedimentisphaeraceae	Sedimentisphaera	Sedimentisphaera salicampi

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