metadata: contig_metadata: 34 rows where bioproject = "PRJDB4470", tax_clade = "PVC group" and tax

34 rows where bioproject = "PRJDB4470", 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
981202	981202	PRJDB4470_P_NODE_109281_length_166_cov_0.863248_g108126_i0	PRJDB4470	109281	166	0.863248	1.43299168	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	75.5	3.79e-14	NR	MBA4192120.1	2026779	g108126	i0	63.6	4.96987951807229	55	20	99.4	0	2	166	643	697	MBA4192120.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	825	75.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
1284059	1284059	PRJDB4470_P_NODE_76182_length_206_cov_3.560510_g75027_i0	PRJDB4470	76182	206	3.56051	7.3346506	Polystyrenella longa	2528007	Bacteria	Bacteria	215	2.17e-51	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g75027	i0	87.912	42.9708737864078	182	22	88	0	4	185	1415656	1415475	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	8852	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
6387971	6387971	PRJDB4470_P_NODE_66066_length_231_cov_1.401099_g64911_i0	PRJDB4470	66066	231	1.401099	3.23653869	Bremerella sp. P1	3026424	Bacteria	Bacteria	222	1.4899999999999999e-53	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g64911	i0	93.333	1.94805194805195	150	10	65	0	66	215	2122794	2122645	Bremerella sp. P1 chromosome, complete genome	blastn	450	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
8936460	8936460	PRJDB4470_P_NODE_41128_length_337_cov_1.625000_g39976_i0	PRJDB4470	41128	337	1.625	5.47625	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	335	2.819999999999999e-87	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g39976	i0	85.583	208.522255192878	326	40	97	4	1	326	1867539	1867221	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	70272	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10212695	10212695	PRJDB4470_P_NODE_83289_length_193_cov_1.416667_g82134_i0	PRJDB4470	83289	193	1.416667	2.73416731	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	228	2.579999999999999e-55	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g82134	i0	90.698	30.5233160621762	172	14	89	2	1	171	5085671	5085501	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	5891	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
12762855	12762855	PRJDB4470_P_NODE_22491_length_502_cov_1.962472_g21370_i0	PRJDB4470	22491	502	1.962472	9.85160944	Bremerella sp. P1	3026424	Bacteria	Bacteria	640	8.229999999999999e-179	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g21370	i0	91.102	2.77290836653386	472	42	94	0	17	488	318591	318120	Bremerella sp. P1 chromosome, complete genome	blastn	1392	640	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
12762926	12762926	PRJDB4470_P_NODE_30231_length_417_cov_2.548913_g29089_i0	PRJDB4470	30231	417	2.548913	10.62896721	Gemmataceae bacterium	2052164	Bacteria	Bacteria	141	9.01e-37	NR	HKI37508.1	2052164	g29089	i0	70.6	2.30215827338129	109	29	76.3	2	1	318	356	464	HKI37508.1 sigma 54-interacting transcriptional regulator [Gemmataceae bacterium]	diamond	960	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
15009186	15009186	PRJDB4470_P_NODE_36092_length_370_cov_1.535826_g34940_i0	PRJDB4470	36092	370	1.535826	5.6825562	Bremerella	2714594	Bacteria	Bacteria	231	4.209999999999998e-56	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g34940	i0	78.628	166.745945945946	379	59	99	19	1	363	2674318	2674690	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	61696	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
15311805	15311805	PRJDB4470_P_NODE_56433_length_263_cov_1.144860_g55278_i0	PRJDB4470	56433	263	1.14486	3.0109818	Gemmataceae bacterium	2052164	Bacteria	Bacteria	248	2.8499999999999997e-61	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g55278	i0	83.955	140.285171102662	268	34	100	9	1	263	320151	320414	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	36895	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
15311830	15311830	PRJDB4470_P_NODE_59693_length_251_cov_1.514851_g58538_i0	PRJDB4470	59693	251	1.514851	3.80227601	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	375	1.1899999999999998e-99	NTclustered	gi\|2921913114\|gb\|CP182803.1\|	2026777	g58538	i0	93.625	161.99203187251	251	16	100	0	1	251	1301779	1302029	MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome	blastn	40660	375	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
15312044	15312044	PRJDB4470_P_NODE_85793_length_189_cov_1.407143_g84638_i0	PRJDB4470	85793	189	1.407143	2.65950027	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	233	5.399999999999999e-57	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g84638	i0	88.889	188.936507936508	189	21	100	0	1	189	4467690	4467502	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	35709	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
19134725	19134725	PRJDB4470_P_NODE_124936_length_162_cov_0.893805_g123781_i0	PRJDB4470	124936	162	0.893805	1.4479641	Bacteria	2	Bacteria	Bacteria	108	2.02e-26	NR	MEZ0266800.1	2026778	g123781	i0	96.3	2	54	2	100	0	1	162	25	78	MEZ0266800.1 FAD-dependent oxidoreductase [Phycisphaerae bacterium]	diamond	324	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
21686585	21686585	PRJDB4470_P_NODE_99058_length_170_cov_5.041322_g97903_i0	PRJDB4470	99058	170	5.041322	8.5702474	Planctomycetota bacterium	2026780	Bacteria	Bacteria	105	3.45e-27	NR	MEY4945789.1	2026780	g97903	i0	100	0.864705882352941	49	0	86.5	0	168	22	72	120	MEY4945789.1 hypothetical protein [Planctomycetota bacterium]	diamond	147	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
22658326	22658326	PRJDB4470_P_NODE_49278_length_293_cov_1.934426_g48125_i0	PRJDB4470	49278	293	1.934426	5.66786818	Phycisphaerae	666505	Bacteria	Bacteria	375	1.4199999999999998e-99	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g48125	i0	89.796	88.5529010238908	294	28	100	2	1	293	1831011	1831303	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	25946	377	0.994694960212202	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
22961113	22961113	PRJDB4470_P_NODE_120339_length_163_cov_0.894737_g119184_i0	PRJDB4470	120339	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	87	3e-18	NR	MEZ6185982.1	2026780	g119184	i0	75.5	3.90184049079755	53	13	97.5	0	161	3	356	408	MEZ6185982.1 serine/threonine-protein kinase [Planctomycetota bacterium]	diamond	636	87	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27158581	27158581	PRJDB4470_P_NODE_117162_length_164_cov_0.878261_g116007_i0	PRJDB4470	117162	164	0.878261	1.44034804	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	50.1	2.9e-5	NR	HYE21340.1	2876886	g116007	i0	89.7	0.530487804878049	29	3	53	0	77	163	1	29	HYE21340.1 chlorite dismutase family protein [Tepidisphaeraceae bacterium]	diamond	87	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27601416	27601416	PRJDB4470_P_NODE_57944_length_257_cov_1.884615_g56789_i0	PRJDB4470	57944	257	1.884615	4.84346055	Gemmataceae bacterium	2052164	Bacteria	Bacteria	85.1	1.09e-17	NR	HEV3235783.1	2052164	g56789	i0	84.1	2.56809338521401	44	7	51.4	0	114	245	1	44	HEV3235783.1 ThiF family adenylyltransferase [Gemmataceae bacterium]	diamond	660	85.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27727847	27727847	PRJDB4470_P_NODE_95244_length_175_cov_2.849206_g94089_i0	PRJDB4470	95244	175	2.849206	4.9861105	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0388	NR	NLF30847.1	2026780	g94089	i0	37	0.788571428571429	46	29	78.9	0	5	142	175	220	NLF30847.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium]	diamond	138	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27916748	27916748	PRJDB4470_P_NODE_120665_length_163_cov_0.885965_g119510_i0	PRJDB4470	120665	163	0.885965	1.44412295	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	48.1	5.47e-5	NR	GJQ28925.1	2026778	g119510	i0	52.1	0.883435582822086	48	23	88.3	0	147	4	24	71	GJQ28925.1 MAG: hypothetical protein HBSAPP03_08090 [Phycisphaerae bacterium]	diamond	144	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27948504	27948504	PRJDB4470_P_NODE_122465_length_162_cov_0.920354_g121310_i0	PRJDB4470	122465	162	0.920354	1.49097348	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	65.1	1.66e-10	NR	MAO25460.1	2026778	g121310	i0	70.7	0.759259259259259	41	12	75.9	0	132	10	341	381	MAO25460.1 hypothetical protein [Phycisphaerae bacterium]	diamond	123	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28100311	28100311	PRJDB4470_P_NODE_84025_length_192_cov_1.069930_g82870_i0	PRJDB4470	84025	192	1.06993	2.0542656	Pirellulaceae	2691357	Bacteria	Bacteria	72	8.97e-13	NR	WP_105352055.1	124	g82870	i0	88.9	2.25	36	4	56.3	0	190	83	104	139	WP_105352055.1 GEVED domain-containing protein [Blastopirellula marina]	diamond	432	72.4	0.994475138121547	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
28422316	28422316	PRJDB4470_P_NODE_95506_length_175_cov_1.603175_g94351_i0	PRJDB4470	95506	175	1.603175	2.80555625	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.00316	NR	MBL4845551.1	2026780	g94351	i0	37.8	0.771428571428571	45	28	77.1	0	41	175	166	210	MBL4845551.1 ferric reductase-like transmembrane domain-containing protein [Planctomycetota bacterium]	diamond	135	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28611584	28611584	PRJDB4470_P_NODE_114087_length_164_cov_1.452174_g112932_i0	PRJDB4470	114087	164	1.452174	2.38156536	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	76.6	1.42e-14	NR	MDR3636703.1	2691532	g112932	i0	66.7	0.98780487804878	54	17	98.8	1	164	3	480	532	MDR3636703.1 HAD-IC family P-type ATPase [Isosphaeraceae bacterium]	diamond	162	76.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
29268505	29268505	PRJDB4470_P_NODE_110289_length_165_cov_1.706897_g109134_i0	PRJDB4470	110289	165	1.706897	2.81638005	Planctomycetia	203683	Bacteria	Bacteria	71.6	8.52e-13	NR	OJW05286.1	1895807	g109134	i0	64.8	1.98181818181818	54	19	98.2	0	1	162	195	248	OJW05286.1 MAG: hypothetical protein BGO49_31150 [Planctomycetales bacterium 71-10]	diamond	327	72	0.994444444444444	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 71-10
29331815	29331815	PRJDB4470_P_NODE_115629_length_164_cov_0.886957_g114474_i0	PRJDB4470	115629	164	0.886957	1.45460948	Pseudomonadati	3379134	Bacteria	Bacteria	86.3	4.86e-18	NR	MDA1051405.1	2026780	g114474	i0	70.4	5.92682926829268	54	16	98.8	0	2	163	59	112	MDA1051405.1 FAD-dependent oxidoreductase [Planctomycetota bacterium]	diamond	972	86.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29432200	29432200	PRJDB4470_P_NODE_98130_length_172_cov_1.130081_g96975_i0	PRJDB4470	98130	172	1.130081	1.94373932	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	54.3	3.98e-7	NR	MDP1797172.1	2026779	g96975	i0	86.7	0.523255813953488	30	4	52.3	0	22	111	111	140	MDP1797172.1 biotin/lipoyl-binding protein [Planctomycetaceae bacterium]	diamond	90	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29937790	29937790	PRJDB4470_P_NODE_115871_length_164_cov_0.886957_g114716_i0	PRJDB4470	115871	164	0.886957	1.45460948	Gemmataceae bacterium	2052164	Bacteria	Bacteria	53.1	2.69e-6	NR	MCX7666926.1	2052164	g114716	i0	88.5	0.475609756097561	26	3	47.6	0	85	162	1	26	MCX7666926.1 glucose-6-phosphate isomerase [Gemmataceae bacterium]	diamond	78	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30317371	30317371	PRJDB4470_P_NODE_61952_length_243_cov_2.912371_g60797_i0	PRJDB4470	61952	243	2.912371	7.07706153	Sedimentisphaeraceae bacterium JB056	3342865	Bacteria	Bacteria	43.1	0.0275	NR	MFI4911821.1	3342865	g60797	i0	28.2	1.04938271604938	85	48	88.9	2	225	10	65	149	MFI4911821.1 sodium:solute symporter [Sedimentisphaeraceae bacterium JB056]	diamond	255	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Sedimentisphaeraceae		Sedimentisphaeraceae bacterium JB056
30506477	30506477	PRJDB4470_P_NODE_82813_length_194_cov_1.075862_g81658_i0	PRJDB4470	82813	194	1.075862	2.08717228	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	119	2.76e-29	NR	WP_075095406.1	1632864	g81658	i0	85.9	0.989690721649485	64	9	99	0	194	3	396	459	WP_075095406.1 methionine--tRNA ligase [Planctomyces sp. SH-PL14]	diamond	192	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
30601077	30601077	PRJDB4470_P_NODE_127193_length_152_cov_2.815534_g126038_i0	PRJDB4470	127193	152	2.815534	4.27961168	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	49.3	4.3e-5	NR	HIB69427.1	2052180	g126038	i0	61	0.809210526315789	41	16	80.9	0	5	127	77	117	HIB69427.1 hypothetical protein [Phycisphaerales bacterium]	diamond	123	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30664386	30664386	PRJDB4470_P_NODE_74713_length_210_cov_0.950311_g73558_i0	PRJDB4470	74713	210	0.950311	1.9956531	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	43.1	0.0169	NR	MBN1556090.1	2026778	g73558	i0	34.4	0.914285714285714	64	39	90	3	8	196	231	292	MBN1556090.1 dihydroorotate dehydrogenase electron transfer subunit [Phycisphaerae bacterium]	diamond	192	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31327959	31327959	PRJDB4470_P_NODE_122196_length_162_cov_0.920354_g121041_i0	PRJDB4470	122196	162	0.920354	1.49097348	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	41.2	0.0279	NR	MBM4113471.1	2026778	g121041	i0	58.6	0.537037037037037	29	11	53.7	1	130	44	16	43	MBM4113471.1 YkgJ family cysteine cluster protein [Phycisphaerae bacterium]	diamond	87	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31707554	31707554	PRJDB4470_P_NODE_87097_length_187_cov_1.413043_g85942_i0	PRJDB4470	87097	187	1.413043	2.64239041	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	80.1	1.22e-15	NR	HTN01509.1	2026779	g85942	i0	54.8	1.98930481283422	62	28	99.5	0	2	187	93	154	HTN01509.1 DUF1592 domain-containing protein [Planctomycetaceae bacterium]	diamond	372	80.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32055517	32055517	PRJDB4470_P_NODE_99338_length_170_cov_1.719008_g98183_i0	PRJDB4470	99338	170	1.719008	2.9223136	Gemmataceae bacterium	2052164	Bacteria	Bacteria	85.5	6.73e-18	NR	HEV3237927.1	2052164	g98183	i0	73.2	2.94705882352941	56	15	98.8	0	168	1	202	257	HEV3237927.1 sigma-54 dependent transcriptional regulator [Gemmataceae bacterium]	diamond	501	85.5	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);;