metadata: contig_metadata: 30 rows where bioproject = "PRJEB75017", tax_clade = "PVC group" and tax

30 rows where bioproject = "PRJEB75017", tax_clade = "PVC group" 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
135318	135318	PRJEB75017_P_NODE_11361_length_276_cov_0.931034_g11232_i0	PRJEB75017	11361	276	0.931034	2.56965384	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g11232	i0	92.105	0.13768115942029	38	1	14	2	1	38	2581670	2581705	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	38	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
4823619	4823619	PRJEB75017_P_NODE_3284_length_483_cov_1.385366_g3155_i0	PRJEB75017	3284	483	1.385366	6.69131778	Planctomycetota bacterium	2026780	Bacteria	Bacteria	277	4.07e-93	NR	MBP8300214.1	2026780	g3155	i0	80.5	11.8385093167702	159	31	98.8	0	3	479	1	159	MBP8300214.1 peptidylprolyl isomerase [Planctomycetota bacterium]	diamond	5718	277	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
9062632	9062632	PRJEB75017_P_NODE_17628_length_244_cov_0.912281_g17499_i0	PRJEB75017	17628	244	0.912281	2.22596564	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g17499	i0	100	0.114754098360656	28	0	11	0	68	95	3272398	3272371	Gemmata sp. SH-PL17, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
14163721	14163721	PRJEB75017_P_NODE_12812_length_261_cov_1.909574_g12683_i0	PRJEB75017	12812	261	1.909574	4.98398814	Aquisphaera giovannonii	406548	Bacteria	Bacteria	198	2.89e-46	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g12683	i0	81.124	1.8735632183908	249	45	95	2	1	248	4479127	4479374	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	489	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
27002300	27002300	PRJEB75017_P_NODE_13462_length_255_cov_1.692308_g13333_i0	PRJEB75017	13462	255	1.692308	4.3153854	Gemmataceae bacterium	2052164	Bacteria	Bacteria	66.6	1.69e-10	NR	MCI0379621.1	2052164	g13333	i0	50.7	0.835294117647059	71	32	83.5	1	233	21	1226	1293	MCI0379621.1 DUF11 domain-containing protein [Gemmataceae bacterium]	diamond	213	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27192043	27192043	PRJEB75017_P_NODE_14222_length_252_cov_0.871508_g14093_i0	PRJEB75017	14222	252	0.871508	2.19620016	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	174	2.42e-53	NR	MFA6185856.1	2026778	g14093	i0	94	1.97619047619048	83	5	98.8	0	3	251	61	143	MFA6185856.1 flavoprotein [Phycisphaerae bacterium]	diamond	498	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27223588	27223588	PRJEB75017_P_NODE_14483_length_251_cov_2.466292_g14354_i0	PRJEB75017	14483	251	2.466292	6.19039292	Urbifossiella limnaea	2528023	Bacteria	Bacteria	52	2.36e-5	NR	WP_145234377.1	2528023	g14354	i0	52.4	4.99601593625498	63	29	75.3	1	1	189	5436	5497	WP_145234377.1 tandem-95 repeat protein [Urbifossiella limnaea]	diamond	1254	52	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
27223604	27223604	PRJEB75017_P_NODE_5323_length_381_cov_1.266234_g5194_i0	PRJEB75017	5323	381	1.266234	4.82435154	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.1	0.00229	NR	MBI4718081.1	2026780	g5194	i0	48.9	0.37007874015748	47	23	36.2	1	370	233	282	328	MBI4718081.1 S8 family serine peptidase [Planctomycetota bacterium]	diamond	141	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27223605	27223605	PRJEB75017_P_NODE_5643_length_371_cov_1.020134_g5514_i0	PRJEB75017	5643	371	1.020134	3.78469714	Planctomycetota bacterium	2026780	Bacteria	Bacteria	49.3	7.01e-4	NR	MEK7411798.1	2026780	g5514	i0	50	0.323450134770889	40	20	32.3	0	369	250	317	356	MEK7411798.1 hypothetical protein [Planctomycetota bacterium]	diamond	120	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27255321	27255321	PRJEB75017_P_NODE_1123_length_804_cov_2.080711_g1011_i0	PRJEB75017	1123	804	2.080711	16.72891644	Pirellulales bacterium	2715253	Bacteria	Bacteria	149	1.33e-36	NR	MFM8735234.1	2715253	g1011	i0	37.3	1	268	155	97.4	3	22	804	571	832	MFM8735234.1 FG-GAP-like repeat-containing protein [Pirellulales bacterium]	diamond	804	149	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27318755	27318755	PRJEB75017_P_NODE_4503_length_413_cov_0.870588_g4374_i0	PRJEB75017	4503	413	0.870588	3.59552844	Planctomycetota bacterium	2026780	Bacteria	Bacteria	86.7	5.04e-17	NR	MEK7411798.1	2026780	g4374	i0	41.9	0.900726392251816	124	72	90.1	0	39	410	42	165	MEK7411798.1 hypothetical protein [Planctomycetota bacterium]	diamond	372	86.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28297416	28297416	PRJEB75017_P_NODE_17506_length_244_cov_0.912281_g17377_i0	PRJEB75017	17506	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	72.8	1.02e-12	NR	HLX61050.1	2026780	g17377	i0	53.2	0.762295081967213	62	29	76.2	0	4	189	104	165	HLX61050.1 C25 family cysteine peptidase [Planctomycetota bacterium]	diamond	186	72.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28543095	28543095	PRJEB75017_P_NODE_13027_length_259_cov_1.677419_g12898_i0	PRJEB75017	13027	259	1.677419	4.34451521	Pseudomonadati	3379134	Bacteria	Bacteria	110	5.18e-26	NR	WP_237722494.1	466153	g12898	i0	63.1	14.7220077220077	84	31	97.3	0	4	255	44	127	WP_237722494.1 glycosyltransferase family 4 protein, partial [Singulisphaera acidiphila]	diamond	3813	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
28992430	28992430	PRJEB75017_P_NODE_16028_length_248_cov_0.891429_g15899_i0	PRJEB75017	16028	248	0.891429	2.21074392	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.8	0.00329	NR	MCB9883017.1	2026780	g15899	i0	44.4	2.14112903225806	63	33	76.2	1	3	191	647	707	MCB9883017.1 tetratricopeptide repeat protein [Planctomycetota bacterium]	diamond	531	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29150379	29150379	PRJEB75017_P_NODE_13049_length_259_cov_1.387097_g12920_i0	PRJEB75017	13049	259	1.387097	3.59258123	Planctomycetia bacterium	2052181	Bacteria	Bacteria	58.5	1.02e-8	NR	MBL8864092.1	2052181	g12920	i0	42.6	0.706563706563707	61	35	70.7	0	19	201	21	81	MBL8864092.1 hypothetical protein [Planctomycetia bacterium]	diamond	183	58.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
29276142	29276142	PRJEB75017_P_NODE_12369_length_266_cov_1.088083_g12240_i0	PRJEB75017	12369	266	1.088083	2.89430078	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.5	2.56e-8	NR	MBM4077794.1	2026780	g12240	i0	35.2	1.95112781954887	88	51	99.2	1	3	266	181	262	MBM4077794.1 hypothetical protein [Planctomycetota bacterium]	diamond	519	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29307811	29307811	PRJEB75017_P_NODE_489_length_1160_cov_2.116835_g419_i0	PRJEB75017	489	1160	2.116835	24.555286	Planctomycetota bacterium	2026780	Bacteria	Bacteria	80.5	3.25e-12	NR	MFK7739164.1	2026780	g419	i0	40.7	1.09137931034483	108	64	27.9	0	863	540	413	520	MFK7739164.1 von Willebrand factor type A domain-containing protein [Planctomycetota bacterium]	diamond	1266	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29679201	29679201	PRJEB75017_P_NODE_6850_length_340_cov_1.419476_g6721_i0	PRJEB75017	6850	340	1.419476	4.8262184	Adhaeretor	2862451	Bacteria	Bacteria	103	3.89e-23	NR	WP_246117737.1	1930276	g6721	i0	48.2	8.74411764705882	110	57	97.1	0	8	337	428	537	WP_246117737.1 peroxidase family protein [Adhaeretor mobilis]	diamond	2973	104	0.990384615384615	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
29774142	29774142	PRJEB75017_P_NODE_6891_length_339_cov_1.650376_g6762_i0	PRJEB75017	6891	339	1.650376	5.59477464	Bacteria	2	Bacteria	Bacteria	80.9	2.79e-15	NR	MFK7789309.1	2026777	g6762	i0	40.5	3.36283185840708	111	55	95.6	2	15	338	24	126	MFK7789309.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	1140	80.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
29837286	29837286	PRJEB75017_P_NODE_12891_length_261_cov_1.154255_g12762_i0	PRJEB75017	12891	261	1.154255	3.01260555	Bacteria	2	Bacteria	Bacteria	109	1.28e-25	NR	MBN1514046.1	2026778	g12762	i0	61.2	4.88505747126437	85	33	97.7	0	260	6	682	766	MBN1514046.1 alanine--tRNA ligase [Phycisphaerae bacterium]	diamond	1275	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30287353	30287353	PRJEB75017_P_NODE_17592_length_244_cov_0.912281_g17463_i0	PRJEB75017	17592	244	0.912281	2.22596564	Pirellulales bacterium	2715253	Bacteria	Bacteria	110	3.67e-26	NR	MBA3483279.1	2715253	g17463	i0	90.6	0.786885245901639	64	6	78.7	0	51	242	1	64	MBA3483279.1 DUF4340 domain-containing protein [Pirellulales bacterium]	diamond	192	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30350650	30350650	PRJEB75017_P_NODE_3152_length_493_cov_1.604762_g3023_i0	PRJEB75017	3152	493	1.604762	7.91147666	Planctomycetota bacterium	2026780	Bacteria	Bacteria	50.8	6.87e-4	NR	MBE7462671.1	2026780	g3023	i0	40.8	0.432048681541582	71	36	43.2	1	164	376	651	715	MBE7462671.1 hypothetical protein [Planctomycetota bacterium]	diamond	213	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30508099	30508099	PRJEB75017_P_NODE_3533_length_467_cov_0.791878_g3404_i0	PRJEB75017	3533	467	0.791878	3.69807026	Planctomycetota bacterium	2026780	Bacteria	Bacteria	125	1.7399999999999999e-31	NR	MEK7411798.1	2026780	g3404	i0	48.4	0.995717344753747	155	79	98.9	1	3	464	156	310	MEK7411798.1 hypothetical protein [Planctomycetota bacterium]	diamond	465	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30855589	30855589	PRJEB75017_P_NODE_13694_length_253_cov_1.644444_g13565_i0	PRJEB75017	13694	253	1.644444	4.16044332	Planctomycetota bacterium	2026780	Bacteria	Bacteria	115	1.11e-27	NR	MEO1129830.1	2026780	g13565	i0	59.5	0.99604743083004	84	33	98.4	1	1	249	373	456	MEO1129830.1 DUF5060 domain-containing protein [Planctomycetota bacterium]	diamond	252	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30855609	30855609	PRJEB75017_P_NODE_854_length_914_cov_3.464923_g757_i0	PRJEB75017	854	914	3.464923	31.66939622	Candidatus Brocadiales bacterium	2760054	Bacteria	Bacteria	123	7.89e-31	NR	MBC8550552.1	2760054	g757	i0	46.2	1.31291028446389	130	68	42.3	2	848	462	1	129	MBC8550552.1 hemin receptor [Candidatus Brocadiales bacterium]	diamond	1200	123	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales			Candidatus Brocadiales bacterium
30950630	30950630	PRJEB75017_P_NODE_15354_length_249_cov_1.318182_g15225_i0	PRJEB75017	15354	249	1.318182	3.28227318	Planctomycetota bacterium	2026780	Bacteria	Bacteria	103	1.2399999999999999e-23	NR	MEE2940486.1	2026780	g15225	i0	71.6	3.20481927710843	67	19	80.7	0	45	245	19	85	MEE2940486.1 acyl-CoA carboxylase subunit beta [Planctomycetota bacterium]	diamond	798	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31234680	31234680	PRJEB75017_P_NODE_16255_length_247_cov_0.896552_g16126_i0	PRJEB75017	16255	247	0.896552	2.21448344	Planctomycetota bacterium	2026780	Bacteria	Bacteria	54.3	3.32e-6	NR	MEM1447653.1	2026780	g16126	i0	58.9	1.36032388663968	56	15	68	2	169	2	1	48	MEM1447653.1 hypothetical protein [Planctomycetota bacterium]	diamond	336	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32619277	32619277	PRJEB75017_P_NODE_6300_length_352_cov_2.308244_g6171_i0	PRJEB75017	6300	352	2.308244	8.12501888	Bacteria	2	Bacteria	Bacteria	48.1	0.00159	NR	MFN5298747.1	2026779	g6171	i0	32.8	2.59943181818182	116	54	81.8	4	325	38	139	250	MFN5298747.1 PQQ-binding-like beta-propeller repeat protein [Planctomycetaceae bacterium]	diamond	915	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32689355	32689355	PRJEB75017_P_NODE_17500_length_244_cov_0.912281_g17371_i0	PRJEB75017	17500	244	0.912281	2.22596564	Phycisphaera sp.	2030824	Bacteria	Bacteria	42.7	0.0367	NR	MBI1336570.1	2030824	g17371	i0	56.7	0.368852459016393	30	10	33.2	1	65	145	16	45	MBI1336570.1 hypothetical protein [Phycisphaera sp.]	diamond	90	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
32846838	32846838	PRJEB75017_P_NODE_18280_length_242_cov_1.372781_g18151_i0	PRJEB75017	18280	242	1.372781	3.32213002	Gemmataceae bacterium	2052164	Bacteria	Bacteria	62	5.86e-9	NR	MCI0683985.1	2052164	g18151	i0	40.7	0.731404958677686	59	34	73.1	1	63	239	81	138	MCI0683985.1 serine/threonine-protein kinase [Gemmataceae bacterium]	diamond	177	62	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;