metadata: contig_metadata: 31 rows where bioproject = "PRJEB12237" and tax

31 rows where bioproject = "PRJEB12237" 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
2570562	2570562	PRJEB12237_P_NODE_1823_length_532_cov_1.668008_g1639_i0	PRJEB12237	1823	532	1.668008	8.87380256	Pseudomonadati	3379134	Bacteria	Bacteria	194	1.99e-57	NR	MEY4484424.1	2026799	g1639	i0	62.2	11.046992481203	164	58	92.5	2	492	1	5	164	MEY4484424.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	5877	194	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
3846936	3846936	PRJEB12237_P_NODE_9564_length_173_cov_2.384058_g9368_i0	PRJEB12237	9564	173	2.384058	4.12442034	Lacipirellula parvula	2650471	Bacteria	Bacteria	292	7.87e-75	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g9368	i0	97.11	310.387283236994	173	5	100	0	1	173	5164135	5163963	Lacipirellula parvula PX69 DNA, complete genome	blastn	53697	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
5123106	5123106	PRJEB12237_P_NODE_9185_length_178_cov_1.853147_g8989_i0	PRJEB12237	9185	178	1.853147	3.29860166	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	318	1.34e-82	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g8989	i0	98.876	7.2752808988764	178	2	100	0	1	178	5171560	5171737	Lacipirellula limnantheis strain I41 chromosome	blastn	1295	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
11498706	11498706	PRJEB12237_P_NODE_3910_length_328_cov_1.740614_g3714_i0	PRJEB12237	3910	328	1.740614	5.70921392	Aquisphaera giovannonii	406548	Bacteria	Bacteria	388	2.07e-103	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g3714	i0	89.644	126.359756097561	309	26	97	4	1	305	5179354	5179660	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	41446	388	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
11498728	11498728	PRJEB12237_P_NODE_6890_length_217_cov_1.335165_g6694_i0	PRJEB12237	6890	217	1.335165	2.89730805	Pirellulimonas nuda	2528009	Bacteria	Bacteria	235	1.77e-57	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g6694	i0	86.175	99.7880184331797	217	30	100	0	1	217	1067460	1067676	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	21654	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
11498729	11498729	PRJEB12237_P_NODE_6970_length_215_cov_1.777778_g6774_i0	PRJEB12237	6970	215	1.777778	3.8222227	Gemmataceae	1914233	Bacteria	Bacteria	130	1.93e-36	NR	HEY1188054.1	1914242	g6774	i0	84.5	11.8883720930233	71	11	99.1	0	215	3	80	150	HEY1188054.1 peptidylprolyl isomerase [Gemmata sp.]	diamond	2556	131	0.99236641221374	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
12774283	12774283	PRJEB12237_P_NODE_2151_length_485_cov_1.415556_g1962_i0	PRJEB12237	2151	485	1.415556	6.8654466	Bacteria	2	Bacteria	Bacteria	166	3.42e-45	NR	MBA3846121.1	2026780	g1962	i0	67.8	1.42268041237113	115	37	71.1	0	1	345	433	547	MBA3846121.1 glucose-6-phosphate isomerase [Planctomycetota bacterium]	diamond	690	166	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
14048839	14048839	PRJEB12237_P_NODE_8352_length_189_cov_3.012987_g8156_i0	PRJEB12237	8352	189	3.012987	5.69454543	Lacipirellula parvula	2650471	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g8156	i0	100	358.349206349206	189	0	100	0	1	189	5163124	5163312	Lacipirellula parvula PX69 DNA, complete genome	blastn	67728	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
16597464	16597464	PRJEB12237_P_NODE_1274_length_642_cov_3.705107_g1109_i0	PRJEB12237	1274	642	3.705107	23.78678694	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	665	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g1109	i0	85.496	194.007788161994	655	76	99	16	2	642	2002300	2001651	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	124553	665	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19146175	19146175	PRJEB12237_P_NODE_4596_length_292_cov_3.428016_g4400_i0	PRJEB12237	4596	292	3.428016	10.00980672	Gemmataceae bacterium	2052164	Bacteria	Bacteria	405	1.7999999999999997e-108	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g4400	i0	91.781	81.9760273972603	292	23	100	1	1	292	318057	317767	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	23937	405	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
21697417	21697417	PRJEB12237_P_NODE_6438_length_227_cov_2.098958_g6242_i0	PRJEB12237	6438	227	2.098958	4.76463466	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	231	2.4199999999999997e-56	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g6242	i0	87.94	48.784140969163	199	20	87	3	28	225	3083081	3082886	Stratiformator vulcanicus strain Pan189 chromosome	blastn	11074	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
22662544	22662544	PRJEB12237_P_NODE_5158_length_268_cov_6.291845_g4962_i0	PRJEB12237	5158	268	6.291845	16.8621446	Lacipirellula	2691417	Bacteria	Bacteria	448	2.6799999999999997e-121	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g4962	i0	96.992	168.80223880597	266	8	99	0	3	268	5169115	5169380	Lacipirellula limnantheis strain I41 chromosome	blastn	45239	448	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
22662560	22662560	PRJEB12237_P_NODE_6998_length_214_cov_5.262570_g6802_i0	PRJEB12237	6998	214	5.26257	11.2618998	Gemmata	113	Bacteria	Bacteria	305	1.31e-78	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g6802	i0	92.488	49.3878504672897	213	16	99	0	2	214	2241	2029	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	10569	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
25211642	25211642	PRJEB12237_P_NODE_10200_length_166_cov_2.129771_g10004_i0	PRJEB12237	10200	166	2.129771	3.53541986	Candidatus Protochlamydia	282132	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g10004	i0	100	80.9879518072289	166	0	100	0	1	166	1250601	1250436	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	13444	307	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
26621430	26621430	PRJEB12237_P_NODE_5601_length_251_cov_2.384259_g5405_i0	PRJEB12237	5601	251	2.384259	5.98449009	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	134	4.77e-36	NR	RYD81270.1	2026800	g5405	i0	75.9	0.99203187250996006	83	20	99.2	0	1	249	73	155	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	249	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28132283	28132283	PRJEB12237_P_NODE_11765_length_153_cov_1.279661_g11569_i0	PRJEB12237	11765	153	1.279661	1.95788133	Bacteria	2	Bacteria	Bacteria	46.6	4.68e-4	NR	MES2571580.1	2026799	g11569	i0	47.1	2	51	24	94.1	2	146	3	228	278	MES2571580.1 phosphatidylinositol-specific phospholipase C domain-containing protein [Verrucomicrobiota bacterium]	diamond	306	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28391045	28391045	PRJEB12237_P_NODE_6306_length_231_cov_1.428571_g6110_i0	PRJEB12237	6306	231	1.428571	3.29999901	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	60.1	1.76e-8	NR	MCU0794900.1	2562705	g6110	i0	38.4	0.948051948051948	73	45	94.8	0	13	231	5	77	MCU0794900.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	219	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
28422843	28422843	PRJEB12237_P_NODE_2046_length_499_cov_3.040948_g1858_i0	PRJEB12237	2046	499	3.040948	15.17433052	Chlamydiales bacterium	2047757	Bacteria	Bacteria	147	5.139999999999999e-42	NR	MCP5470421.1	2047757	g1858	i0	51.9	3.60120240480962	156	69	92.6	2	488	27	6	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1797	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28801350	28801350	PRJEB12237_P_NODE_7408_length_205_cov_2.652941_g7212_i0	PRJEB12237	7408	205	2.652941	5.43852905	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.0125	NR	MAB79605.1	2026780	g7212	i0	43.9	1.68292682926829	57	29	83.4	1	177	7	94	147	MAB79605.1 hypothetical protein [Planctomycetota bacterium]	diamond	345	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29085834	29085834	PRJEB12237_P_NODE_1588_length_572_cov_5.543762_g1409_i0	PRJEB12237	1588	572	5.543762	31.71031864	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	111	1.5e-25	NR	RYD71398.1	2026800	g1409	i0	52.3	0.582167832167832	111	52	57.7	1	572	243	251	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	333	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30159126	30159126	PRJEB12237_P_NODE_252_length_1352_cov_6.288535_g186_i0	PRJEB12237	252	1352	6.288535	85.0209932	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	440	4.6199999999999996e-150	NR	RYD65414.1	2026800	g186	i0	77	0.627958579881657	283	63	62.8	1	334	1182	56	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	849	440	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30222500	30222500	PRJEB12237_P_NODE_4692_length_288_cov_1.458498_g4496_i0	PRJEB12237	4692	288	1.458498	4.20047424	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	86.3	1.62e-17	NR	RYD71398.1	2026800	g4496	i0	48.1	0.822916666666667	79	41	82.3	0	5	241	124	202	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	237	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30222502	30222502	PRJEB12237_P_NODE_9052_length_180_cov_1.241379_g8856_i0	PRJEB12237	9052	180	1.241379	2.2344822	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42	0.0312	NR	MCD6050459.1	2026799	g8856	i0	39.2	0.85	51	29	81.7	1	28	174	538	588	MCD6050459.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	153	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30917845	30917845	PRJEB12237_P_NODE_5614_length_251_cov_1.453704_g5418_i0	PRJEB12237	5614	251	1.453704	3.64879704	Prosthecobacter sp.	1965333	Bacteria	Bacteria	124	6e-32	NR	WP_322282923.1	1965333	g5418	i0	72.3	2.96414342629482	83	23	99.2	0	249	1	250	332	WP_322282923.1 alkene reductase [Prosthecobacter sp.]	diamond	744	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31265314	31265314	PRJEB12237_P_NODE_10515_length_163_cov_1.875000_g10319_i0	PRJEB12237	10515	163	1.875	3.05625	Gemmata algarum	2975278	Bacteria	Bacteria	67.4	1.11e-11	NR	WP_320685713.1	2975278	g10319	i0	72.7	0.809815950920245	44	12	81	0	134	3	113	156	WP_320685713.1 glucose 1-dehydrogenase [Gemmata algarum]	diamond	132	67.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata algarum
31486913	31486913	PRJEB12237_P_NODE_4656_length_290_cov_1.113725_g4460_i0	PRJEB12237	4656	290	1.113725	3.2298025	Gemmataceae bacterium	2052164	Bacteria	Bacteria	56.2	1.18e-6	NR	MCI0456322.1	2052164	g4460	i0	53.6	0.579310344827586	56	25	57.9	1	265	98	613	667	MCI0456322.1 choice-of-anchor E domain-containing protein [Gemmataceae bacterium]	diamond	168	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31543736	31543736	PRJEB12237_P_NODE_4696_length_288_cov_1.173913_g4500_i0	PRJEB12237	4696	288	1.173913	3.38086944	Pseudomonadati	3379134	Bacteria	Bacteria	117	2.7699999999999997e-30	NR	MBN9117911.1	2026780	g4500	i0	65.3	3.95833333333333	95	33	99	0	286	2	17	111	MBN9117911.1 glucose 1-dehydrogenase [Planctomycetota bacterium]	diamond	1140	118	0.991525423728814	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31581728	31581728	PRJEB12237_P_NODE_8596_length_186_cov_1.854305_g8400_i0	PRJEB12237	8596	186	1.854305	3.4490073	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.3	0.00473	NR	MFK5922826.1	2026799	g8400	i0	35	0.967741935483871	60	37	95.2	2	8	184	207	265	MFK5922826.1 sulfotransferase family 2 domain-containing protein [Verrucomicrobiota bacterium]	diamond	180	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31613203	31613203	PRJEB12237_P_NODE_11916_length_152_cov_1.119658_g11720_i0	PRJEB12237	11916	152	1.119658	1.70188016	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	46.6	1.48e-4	NR	MCS7338380.1	2499141	g11720	i0	79.3	0.572368421052632	29	6	57.2	0	129	43	99	127	MCS7338380.1 RidA family protein [Verrucomicrobiia bacterium]	diamond	87	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31897887	31897887	PRJEB12237_P_NODE_3877_length_330_cov_1.149153_g3681_i0	PRJEB12237	3877	330	1.149153	3.7922049	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	50.1	2.83e-4	NR	HHM12983.1	2026779	g3681	i0	39.2	2.05454545454545	74	35	67.3	2	225	4	659	722	HHM12983.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	678	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32056056	32056056	PRJEB12237_P_NODE_7298_length_208_cov_1.387283_g7102_i0	PRJEB12237	7298	208	1.387283	2.88554864	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	46.2	0.00133	NR	MBX3315538.1	2026777	g7102	i0	45.8	0.850961538461538	59	26	80.8	2	194	27	268	323	MBX3315538.1 choice-of-anchor A family protein [Phycisphaeraceae bacterium]	diamond	177	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;