metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJEB8827" and tax

25 rows where analysis = "blastn", bioproject = "PRJEB8827" 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
25529479	25529479	PRJEB8827b_S_NODE_37353_length_165_cov_1.846154_g37301_i0	PRJEB8827	37353	165	1.846154	3.0461541	Limnoglobus roseus	2598579	Bacteria	Bacteria	244	2.12e-60	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g37301	i0	93.333	91.4484848484849	165	11	100	0	1	165	2958270	2958434	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	15089	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
25529638	25529638	PRJEB8827e_S_NODE_29329_length_168_cov_3.796992_g29301_i0	PRJEB8827	29329	168	3.796992	6.37894656	Polystyrenella longa	2528007	Bacteria	Bacteria	195	2.22e-45	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g29301	i0	87.5	22.9642857142857	168	21	100	0	1	168	1415640	1415473	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	3858	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
25530053	25530053	PRJEB8827f_S_NODE_3905_length_228_cov_58.772021_g3885_i0	PRJEB8827	3905	228	58.772021	134.00020788	Rubinisphaera brasiliensis DSM 53	119	Bacteria	Bacteria	174	4.16e-39	NTclustered	gi\|324966854\|gb\|CP002546.1\|	756272	g3885	i0	86.624	156.328947368421	157	21	69	0	39	195	103576	103420	Rubinisphaera brasiliensis DSM 5305 chromosome, complete genome	blastn	35643	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera brasiliensis
25530138	25530138	PRJEB8827f_S_NODE_7185_length_192_cov_2.751592_g7165_i0	PRJEB8827	7185	192	2.751592	5.28305664	Limnoglobus roseus	2598579	Bacteria	Bacteria	193	9.34e-45	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g7165	i0	87.135	28.6302083333333	171	21	89	1	1	171	2958716	2958885	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	5497	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
25530360	25530360	PRJEB8827h_S_NODE_449_length_381_cov_3.372832_g430_i0	PRJEB8827	449	381	3.372832	12.85048992	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	281	4.26e-71	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g430	i0	80.829	44.2755905511811	386	50	97	19	1	371	57763	58139	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	16869	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
25530398	25530398	PRJEB8827i_S_NODE_257_length_318_cov_5.501767_g252_i0	PRJEB8827	257	318	5.501767	17.49561906	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	549	8.669999999999997e-152	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g252	i0	100	125.377358490566	297	0	93	0	1	297	1249368	1249072	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	39870	549	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25530401	25530401	PRJEB8827i_S_NODE_489_length_264_cov_1087.829694_g484_i0	PRJEB8827	489	264	1087.829694	2871.87039216	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	394	3.48e-105	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g484	i0	99.537	79.0492424242424	216	1	82	0	3	218	1251043	1250828	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	20869	394	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25617861	25617861	PRJEB8827i_S_NODE_281_length_309_cov_6.587591_g276_i0	PRJEB8827	281	309	6.587591	20.35565619	Candidatus Protochlamydia	282132	Bacteria	Bacteria	531	3.0399999999999998e-146	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g276	i0	99.655	95.3495145631068	290	1	94	0	1	290	2475198	2474909	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	29463	531	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25665685	25665685	PRJEB8827e_S_NODE_41674_length_154_cov_7.210084_g41646_i0	PRJEB8827	41674	154	7.210084	11.10352936	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	106	9.56e-19	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g41646	i0	81.481	3.12987012987013	135	19	84	5	26	154	560116	559982	Gemmata sp. SH-PL17, complete genome	blastn	482	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
25666047	25666047	PRJEB8827f_S_NODE_5194_length_208_cov_1.589595_g5174_i0	PRJEB8827	5194	208	1.589595	3.3063576	Planctomycetes bacterium Pan216	2527975	Bacteria	Bacteria	213	7.9e-51	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g5174	i0	87.234	31.6346153846154	188	22	90	2	22	208	1829288	1829474	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	6580	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
25802523	25802523	PRJEB8827i_S_NODE_1547_length_199_cov_2.353659_g1542_i0	PRJEB8827	1547	199	2.353659	4.68378141	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	355	1.18e-93	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1542	i0	98.995	149.869346733668	199	1	100	1	1	199	1249919	1249722	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	29824	355	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25889769	25889769	PRJEB8827h_S_NODE_1195_length_276_cov_4679.543568_g1176_i0	PRJEB8827	1195	276	4679.543568	12915.54024768	Engelhardtia	139931	Bacteria	Bacteria	228	3.9299999999999985e-55	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g1176	i0	85.78	33.5688405797101	218	28	78	3	61	276	5248967	5249183	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	9265	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
25938409	25938409	PRJEB8827f_S_NODE_380_length_481_cov_7.959641_g361_i0	PRJEB8827	380	481	7.959641	38.28587321	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	156	3.47e-33	NTclustered	gi\|2621705104\|emb\|OY763327.1\|	2026777	g361	i0	82.486	22.024948024948	177	31	37	0	59	235	3235899	3235723	MAG: Phycisphaeraceae bacterium isolate 55aab3a5-de4e-4c55-acd5-ede7382e386b genome assembly, chromosome: 1	blastn	10594	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25938759	25938759	PRJEB8827i_S_NODE_60_length_449_cov_12.780193_g55_i0	PRJEB8827	60	449	12.780193	57.38306657	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	819	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g55	i0	99.555	125.320712694877	449	2	100	0	1	449	1250041	1250489	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	56269	819	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26025998	26025998	PRJEB8827f_S_NODE_27364_length_159_cov_1.419355_g27344_i0	PRJEB8827	27364	159	1.419355	2.25677445	Frigoriglobus	2774146	Bacteria	Bacteria	200	4.439999999999999e-47	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g27344	i0	95.276	53.1194968553459	127	4	79	2	2	127	2002405	2002530	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	8446	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26074110	26074110	PRJEB8827e_S_NODE_93_length_906_cov_4.159587_g90_i0	PRJEB8827	93	906	4.159587	37.68585822	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	1214	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g90	i0	91.573	376.164459161148	890	59	97	16	5	883	2003118	2002234	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	340805	1214	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26074721	26074721	PRJEB8827i_S_NODE_4821_length_171_cov_3.772059_g4816_i0	PRJEB8827	4821	171	3.772059	6.45022089	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	283	4.67e-72	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g4816	i0	96.491	2.00584795321637	171	6	100	0	1	171	2281086	2281256	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	343	283	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26162092	26162092	PRJEB8827f_S_NODE_10957_length_179_cov_2.104167_g10937_i0	PRJEB8827	10957	179	2.104167	3.76645893	Isosphaera	127	Bacteria	Bacteria	180	6.67e-41	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g10937	i0	87.037	36.9329608938547	162	17	90	4	18	178	1239	1081	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	6611	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
26162105	26162105	PRJEB8827f_S_NODE_15173_length_171_cov_1.845588_g15153_i0	PRJEB8827	15173	171	1.845588	3.15595548	Telmatocola	1382832	Bacteria	Bacteria	241	2.85e-59	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g15153	i0	94.805	43.0701754385965	154	8	90	0	1	154	3722199	3722352	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	7365	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
26210250	26210250	PRJEB8827e_S_NODE_37414_length_161_cov_1.476190_g37386_i0	PRJEB8827	37414	161	1.47619	2.3766659	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	219	1.2499999999999996e-52	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g37386	i0	96.241	289.590062111801	133	5	83	0	1	133	4960230	4960362	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	46624	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
26210700	26210700	PRJEB8827f_S_NODE_686_length_403_cov_9.823370_g666_i0	PRJEB8827	686	403	9.82337	39.5881811	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	366	1.2199999999999996e-96	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g666	i0	85.593	105.436724565757	354	45	87	6	53	403	2002169	2001819	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	42491	366	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26210956	26210956	PRJEB8827i_S_NODE_2670_length_184_cov_5.832215_g2665_i0	PRJEB8827	2670	184	5.832215	10.7312756	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	327	2.3299999999999996e-85	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g2665	i0	98.907	221.032608695652	183	2	99	0	1	183	1249572	1249390	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	40670	327	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26297896	26297896	PRJEB8827f_S_NODE_134_length_631_cov_3.402685_g121_i0	PRJEB8827	134	631	3.402685	21.47094235	Frigoriglobus	2774146	Bacteria	Bacteria	806	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g121	i0	91.29	352.231378763867	597	43	94	9	42	631	2003097	2002503	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	222258	809	0.996291718170581	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26346087	26346087	PRJEB8827e_S_NODE_3071_length_247_cov_2.867925_g3043_i0	PRJEB8827	3071	247	2.867925	7.08377475	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	274	4.38e-69	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g3043	i0	86.8	117.198380566802	250	28	100	5	1	247	2002104	2001857	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	28948	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26482840	26482840	PRJEB8827g_S_NODE_1168_length_278_cov_3.308642_g1147_i0	PRJEB8827	1168	278	3.308642	9.19802476	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	414	2.83e-111	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1147	i0	99.559	131.73381294964	227	1	82	0	22	248	1250182	1250408	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	36622	414	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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