metadata: contig_metadata: 29 rows where bioproject = "PRJNA1136505", tax_clade = "PVC group" and tax

29 rows where bioproject = "PRJNA1136505", 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
1559110	1559110	PRJNA1136505_P_NODE_60122_length_388_cov_2.250794_g53262_i0	PRJNA1136505	60122	388	2.250794	8.73308072	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	122	2.21e-31	NR	MBY0307716.1	2052180	g53262	i0	50.4	0.966494845360825	125	60	95.9	2	373	2	2	125	MBY0307716.1 S10 family peptidase [Phycisphaerales bacterium]	diamond	375	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
2835138	2835138	PRJNA1136505_P_NODE_122123_length_260_cov_1.625668_g115263_i0	PRJNA1136505	122123	260	1.625668	4.2267368	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	361	3.469999999999999e-95	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g115263	i0	92.188	221.05	256	18	98	2	1	254	2002593	2002848	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	57473	361	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2835157	2835157	PRJNA1136505_P_NODE_141003_length_247_cov_0.885057_g134143_i0	PRJNA1136505	141003	247	0.885057	2.18609079	Gemmataceae bacterium	2052164	Bacteria	Bacteria	143	1.29e-29	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g134143	i0	94.624	7.11740890688259	93	4	38	1	46	138	4154675	4154584	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	1758	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
11235342	11235342	PRJNA1136505_P_NODE_70549_length_351_cov_1.672662_g63689_i0	PRJNA1136505	70549	351	1.672662	5.87104362	Pseudomonadati	3379134	Bacteria	Bacteria	139	2.939999999999999e-38	NR	WP_077022365.1	1891926	g63689	i0	60.2	12.7094017094017	113	45	96.6	0	1	339	76	188	WP_077022365.1 SDR family NAD(P)-dependent oxidoreductase [Fuerstiella marisgermanici]	diamond	4461	140	0.992857142857143	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
12510732	12510732	PRJNA1136505_P_NODE_66070_length_366_cov_1.389078_g59210_i0	PRJNA1136505	66070	366	1.389078	5.08402548	Gemmata	113	Bacteria	Bacteria	593	4.599999999999998e-165	NTclustered	gi\|307591227\|gb\|GQ889438.1\|	886811	g59210	i0	95.902	99.3770491803279	366	15	100	0	1	366	849	484	Gemmata sp. Io3-3 16S ribosomal RNA gene, partial sequence	blastn	36372	593	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. Io3-3
14313471	14313471	PRJNA1136505_P_NODE_81172_length_324_cov_1.203187_g74312_i0	PRJNA1136505	81172	324	1.203187	3.89832588	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	268	2.7799999999999998e-67	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g74312	i0	92.973	77.6851851851852	185	11	57	2	141	324	2003008	2002825	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	25170	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19410442	19410442	PRJNA1136505_P_NODE_73516_length_343_cov_1.140741_g66656_i0	PRJNA1136505	73516	343	1.140741	3.91274163	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	109	5.75e-28	NR	HYF16044.1	2052180	g66656	i0	57.1	3.27113702623907	91	39	79.6	0	63	335	2	92	HYF16044.1 GNAT family N-acetyltransferase [Phycisphaerales bacterium]	diamond	1122	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
20158428	20158428	PRJNA1136505_P_NODE_75176_length_338_cov_2.524528_g68316_i0	PRJNA1136505	75176	338	2.524528	8.53290464	Gemmata	113	Bacteria	Bacteria	475	1.5999999999999995e-129	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g68316	i0	92.059	160.872781065089	340	24	100	3	1	338	2029	2367	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	54375	475	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
20685939	20685939	PRJNA1136505_P_NODE_82677_length_321_cov_0.931452_g75817_i0	PRJNA1136505	82677	321	0.931452	2.98996092	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	173	4.75e-49	NR	HLL89427.1	2876886	g75817	i0	79.2	2.97196261682243	106	21	99.1	1	2	319	356	460	HLL89427.1 glucose-6-phosphate isomerase [Tepidisphaeraceae bacterium]	diamond	954	173	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27091083	27091083	PRJNA1136505_P_NODE_150782_length_243_cov_0.905882_g143922_i0	PRJNA1136505	150782	243	0.905882	2.20129326	Pseudomonadati	3379134	Bacteria	Bacteria	58.9	7.58e-8	NR	MEE8105887.1	2026780	g143922	i0	42	3.34567901234568	69	40	85.2	0	25	231	15	83	MEE8105887.1 M1 family aminopeptidase [Planctomycetota bacterium]	diamond	813	58.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27133216	27133216	PRJNA1136505_P_NODE_62182_length_380_cov_1.755700_g55322_i0	PRJNA1136505	62182	380	1.7557	6.67166	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	100	6.51e-22	NR	HEX8325890.1	2876886	g55322	i0	52.9	4.06578947368421	85	38	67.1	1	377	123	462	544	HEX8325890.1 sulfite reductase subunit alpha [Tepidisphaeraceae bacterium]	diamond	1545	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27702507	27702507	PRJNA1136505_P_NODE_102844_length_284_cov_1.966825_g95984_i0	PRJNA1136505	102844	284	1.966825	5.585783	Gimesia sp.	2024833	Bacteria	Bacteria	69.3	2.84e-11	NR	WP_350191802.1	2024833	g95984	i0	44.8	0.919014084507042	87	46	89.8	2	26	280	836	922	WP_350191802.1 Ig-like domain-containing protein [Gimesia sp.]	diamond	261	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia sp.
27923166	27923166	PRJNA1136505_P_NODE_12905_length_1906_cov_24.964539_g8955_i0	PRJNA1136505	12905	1906	24.964539	475.82411334	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	72.8	4.62e-9	NR	MFN0136844.1	2026778	g8955	i0	38.4	0.311647429171039	198	91	28.8	11	880	1428	1092	1276	MFN0136844.1 choice-of-anchor tandem repeat NxxGxxAF-containing protein [Phycisphaerae bacterium]	diamond	594	72.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28460149	28460149	PRJNA1136505_P_NODE_110746_length_274_cov_1.532338_g103886_i0	PRJNA1136505	110746	274	1.532338	4.19860612	Phycisphaera sp.	2030824	Bacteria	Bacteria	51.6	4.36e-5	NR	MBI1371809.1	2030824	g103886	i0	44.3	1.76277372262774	79	43	85.4	1	2	235	1511	1589	MBI1371809.1 tandem-95 repeat protein [Phycisphaera sp.]	diamond	483	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
28649529	28649529	PRJNA1136505_P_NODE_152747_length_242_cov_0.911243_g145887_i0	PRJNA1136505	152747	242	0.911243	2.20520806	Planctomycetes bacterium Pan216	2527975	Bacteria	Bacteria	55.1	1.63e-6	NR	QDU63528.1	2527975	g145887	i0	51.1	0.557851239669422	45	22	55.8	0	237	103	499	543	QDU63528.1 Protease 4 [Planctomycetes bacterium Pan216]	diamond	135	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
29059962	29059962	PRJNA1136505_P_NODE_42488_length_505_cov_1.666667_g35633_i0	PRJNA1136505	42488	505	1.666667	8.41666835	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	159	1.72e-41	NR	NLX13706.1	2052180	g35633	i0	50.6	2.94059405940594	168	83	99.8	0	505	2	280	447	NLX13706.1 response regulator [Phycisphaerales bacterium]	diamond	1485	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29280731	29280731	PRJNA1136505_P_NODE_91689_length_302_cov_1.781659_g84829_i0	PRJNA1136505	91689	302	1.781659	5.38061018	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	55.8	1.91e-6	NR	MBL8745440.1	2026778	g84829	i0	36.1	0.963576158940397	97	53	96.4	3	294	4	796	883	MBL8745440.1 proprotein convertase P-domain-containing protein [Phycisphaerae bacterium]	diamond	291	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29627736	29627736	PRJNA1136505_P_NODE_120750_length_262_cov_1.291005_g113890_i0	PRJNA1136505	120750	262	1.291005	3.3824331	Planctomycetota bacterium	2026780	Bacteria	Bacteria	98.6	3.8300000000000002e-22	NR	MCG3133530.1	2026780	g113890	i0	67.2	8.12977099236641	64	21	73.3	0	194	3	4	67	MCG3133530.1 Cystathionine beta-lyase [Planctomycetota bacterium]	diamond	2130	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29627737	29627737	PRJNA1136505_P_NODE_122870_length_259_cov_1.655914_g116010_i0	PRJNA1136505	122870	259	1.655914	4.28881726	Gemmataceae bacterium	2052164	Bacteria	Bacteria	97.8	2.01e-21	NR	HTU21258.1	2052164	g116010	i0	65.1	1.99227799227799	86	30	99.6	0	2	259	952	1037	HTU21258.1 immunoglobulin domain-containing protein [Gemmataceae bacterium]	diamond	516	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29964743	29964743	PRJNA1136505_P_NODE_6771_length_3108_cov_5.001318_g4765_i0	PRJNA1136505	6771	3108	5.001318	155.44096344	Pseudomonadati	3379134	Bacteria	Bacteria	197	1.7599999999999999e-47	NR	WP_339674628.1	1678688	g4765	i0	29.3	2.67181467181467	888	531	81.9	33	27	2570	489	1319	WP_339674628.1 Ig-like domain-containing protein, partial [uncultured Gimesia sp.]	diamond	8304	197	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	uncultured Gimesia sp.
30196573	30196573	PRJNA1136505_P_NODE_119732_length_263_cov_1.563158_g112872_i0	PRJNA1136505	119732	263	1.563158	4.11110554	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	43.1	0.033	NR	MFA5795513.1	2517210	g112872	i0	38.5	0.593155893536122	52	32	59.3	0	2	157	29	80	MFA5795513.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	156	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
30323693	30323693	PRJNA1136505_P_NODE_70252_length_352_cov_1.616487_g63392_i0	PRJNA1136505	70252	352	1.616487	5.69003424	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	61.6	1.95e-9	NR	QOJ16793.1	2026777	g63392	i0	40.5	0.673295454545455	79	41	65.6	2	283	53	28	102	QOJ16793.1 MAG: hypothetical protein HRU76_03980 [Phycisphaeraceae bacterium]	diamond	237	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
30607381	30607381	PRJNA1136505_P_NODE_80313_length_326_cov_1.217391_g73453_i0	PRJNA1136505	80313	326	1.217391	3.96869466	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	43.9	0.0396	NR	MFN0136844.1	2026778	g73453	i0	40.2	0.800613496932515	87	43	75.5	2	40	285	1145	1227	MFN0136844.1 choice-of-anchor tandem repeat NxxGxxAF-containing protein [Phycisphaerae bacterium]	diamond	261	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30702234	30702234	PRJNA1136505_P_NODE_151794_length_242_cov_1.366864_g144934_i0	PRJNA1136505	151794	242	1.366864	3.30781088	Planctomycetota bacterium	2026780	Bacteria	Bacteria	69.3	1.58e-11	NR	MCP5007393.1	2026780	g144934	i0	52.9	0.867768595041322	70	30	83.1	1	3	203	44	113	MCP5007393.1 hypothetical protein [Planctomycetota bacterium]	diamond	210	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30986792	30986792	PRJNA1136505_P_NODE_58894_length_394_cov_1.333333_g52034_i0	PRJNA1136505	58894	394	1.333333	5.25333202	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	57	2.12e-6	NR	MDO8629540.1	2052180	g52034	i0	45.7	0.974619289340102	70	31	53.3	1	2	211	338	400	MDO8629540.1 tandem-95 repeat protein [Phycisphaerales bacterium]	diamond	384	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31164959	31164959	PRJNA1136505_P_NODE_103195_length_284_cov_1.336493_g96335_i0	PRJNA1136505	103195	284	1.336493	3.79564012	PVC group	1783257	Bacteria	Bacteria	89.4	3.44e-20	NR	WP_254053252.1	1882752	g96335	i0	66.2	2.97887323943662	65	22	68.7	0	197	3	4	68	WP_254053252.1 hypothetical protein [Singulisphaera sp. GP187]	diamond	846	89.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. GP187
32030323	32030323	PRJNA1136505_P_NODE_149998_length_243_cov_0.905882_g143138_i0	PRJNA1136505	149998	243	0.905882	2.20129326	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	48.5	3.34e-4	NR	TVS14604.1	2026779	g143138	i0	35	0.987654320987654	80	46	96.3	3	235	2	530	605	TVS14604.1 MAG: hypothetical protein EA424_18755 [Planctomycetaceae bacterium]	diamond	240	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32061818	32061818	PRJNA1136505_P_NODE_40598_length_526_cov_1.189845_g33753_i0	PRJNA1136505	40598	526	1.189845	6.2585847	Gimesia sp.	2024833	Bacteria	Bacteria	152	5.68e-39	NR	MBN67933.1	2024833	g33753	i0	52.1	0.94106463878327	165	77	93	1	512	24	227	391	MBN67933.1 hypothetical protein [Gimesia sp.]	diamond	495	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia sp.
32441861	32441861	PRJNA1136505_P_NODE_143739_length_245_cov_1.790698_g136879_i0	PRJNA1136505	143739	245	1.790698	4.3872101	Gemmataceae bacterium	2052164	Bacteria	Bacteria	99.8	1.6000000000000002e-23	NR	HEY1377607.1	2052164	g136879	i0	62.3	1.88571428571429	77	29	94.3	0	13	243	2	78	HEY1377607.1 ATP-binding cassette domain-containing protein [Gemmataceae bacterium]	diamond	462	99.8	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);;