metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA800053" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA800053" 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
796265	796265	PRJNA800053_P_NODE_9961_length_308_cov_1.957447_g9797_i0	PRJNA800053	9961	308	1.957447	6.02893676	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	531	3.0299999999999998e-146	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g9797	i0	97.727	62.1428571428571	308	7	100	0	1	308	1250761	1250454	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	19140	531	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
2072063	2072063	PRJNA800053_P_NODE_8042_length_335_cov_3.011450_g7878_i0	PRJNA800053	8042	335	3.01145	10.0883575	Lentisphaera profundi	1658616	Bacteria	Bacteria	263	1.34e-65	NTclustered	gi\|2445967839\|gb\|CP117812.1\|	1658616	g7878	i0	81.081	417.137313432836	333	59	99	3	1	332	2073898	2074227	Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence	blastn	139741	263	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera profundi
3347199	3347199	PRJNA800053_P_NODE_14103_length_272_cov_1.070352_g13939_i0	PRJNA800053	14103	272	1.070352	2.91135744	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	307	4.8200000000000006e-79	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g13939	i0	87.361	219.202205882353	269	32	99	2	1	269	913079	913345	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	59623	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3347212	3347212	PRJNA800053_P_NODE_17243_length_251_cov_1.724719_g17079_i0	PRJNA800053	17243	251	1.724719	4.32904469	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	322	1.57e-83	NTclustered	gi\|91221255\|gb\|DQ450803.1\|	120965	g17079	i0	91.489	92.3426294820717	235	19	94	1	13	247	1	234	Uncultured planctomycete clone D01_WMSP1 16S ribosomal RNA gene, partial sequence	blastn	23178	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
3771634	3771634	PRJNA800053_P_NODE_9183_length_318_cov_1.571429_g9019_i0	PRJNA800053	9183	318	1.571429	4.99714422	Gemmata	113	Bacteria	Bacteria	385	2.59e-102	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g9019	i0	88.854	179.839622641509	314	33	98	2	3	315	2022235	2021923	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	57189	385	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
4624607	4624607	PRJNA800053_P_NODE_15764_length_260_cov_2.363636_g15600_i0	PRJNA800053	15764	260	2.363636	6.1454536	Candidatus Piscichlamydia sp.	1977145	Bacteria	Bacteria	390	4.419999999999999e-104	NTclustered	gi\|1175896721\|gb\|KY380088.1\|	1977145	g15600	i0	93.87	78.0615384615385	261	12	99	3	2	260	357	615	Candidatus Piscichlamydia sp. strain EP 16S ribosomal RNA gene, partial sequence	blastn	20296	390	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Piscichlamydiaceae	Candidatus Piscichlamydia	Candidatus Piscichlamydia sp.
9724296	9724296	PRJNA800053_P_NODE_18928_length_249_cov_0.875000_g18764_i0	PRJNA800053	18928	249	0.875	2.17875	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	84.2	7.99e-12	NTclustered	gi\|2621701202\|emb\|OY759724.1\|	2035772	g18764	i0	75.127	2.21686746987952	197	39	77	9	50	241	34451	34642	MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1	blastn	552	84.2	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
10148384	10148384	PRJNA800053_P_NODE_16048_length_259_cov_1.026882_g15884_i0	PRJNA800053	16048	259	1.026882	2.65962438	root	1	Root_unresolved	Root_unresolved	364	2.669999999999999e-96	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g15884	i0	92.578	84.6988416988417	256	15	98	3	2	256	5179139	5178887	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	21937	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
11000079	11000079	PRJNA800053_P_NODE_17649_length_251_cov_0.865169_g17485_i0	PRJNA800053	17649	251	0.865169	2.17157419	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	383	7.099999999999999e-102	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g17485	i0	94.758	108.219123505976	248	9	98	4	5	250	4956771	4956526	Planctomyces sp. SH-PL14, complete genome	blastn	27163	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
12275609	12275609	PRJNA800053_P_NODE_12850_length_281_cov_0.807692_g12686_i0	PRJNA800053	12850	281	0.807692	2.26961452	Humisphaera borealis	2807512	Bacteria	Bacteria	224	5.1899999999999997e-54	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g12686	i0	89.503	121.964412811388	181	14	63	4	1	178	5063963	5064141	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	34272	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
12275739	12275739	PRJNA800053_P_NODE_7090_length_353_cov_1.553571_g6926_i0	PRJNA800053	7090	353	1.553571	5.48410563	Gemmata massiliana	1210884	Bacteria	Bacteria	516	9.85e-142	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g6926	i0	93.201	235.750708215297	353	21	100	2	1	353	3633797	3633448	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	83220	516	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
14824517	14824517	PRJNA800053_P_NODE_11332_length_293_cov_1.254545_g11168_i0	PRJNA800053	11332	293	1.254545	3.67581685	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	470	6.33e-128	NTclustered	gi\|576295676\|gb\|KF787065.1\|	100233	g11168	i0	97.794	93.1843003412969	272	6	93	0	4	275	522	793	Uncultured Planctomycetaceae bacterium clone S2-10-026 16S ribosomal RNA gene, partial sequence	blastn	27303	470	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14824652	14824652	PRJNA800053_P_NODE_3272_length_486_cov_3.232446_g3109_i0	PRJNA800053	3272	486	3.232446	15.70968756	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	512	1.81e-140	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g3109	i0	85.979	108.413580246914	485	60	99	7	6	486	557363	557843	Gemmata sp. SH-PL17, complete genome	blastn	52689	512	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
16098814	16098814	PRJNA800053_P_NODE_9313_length_316_cov_1.938272_g9149_i0	PRJNA800053	9313	316	1.938272	6.12493952	Humisphaera borealis	2807512	Bacteria	Bacteria	257	5.8400000000000005e-64	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g9149	i0	81.651	40.7278481012658	327	45	99	4	1	313	5063492	5063167	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	12870	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
22897462	22897462	PRJNA800053_P_NODE_6618_length_363_cov_1.575862_g6454_i0	PRJNA800053	6618	363	1.575862	5.72037906	Gemmata	113	Bacteria	Bacteria	303	8.61e-78	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g6454	i0	82.222	86.831955922865	360	56	99	7	1	357	4797994	4798348	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	31520	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
23748840	23748840	PRJNA800053_P_NODE_1079_length_759_cov_3.403790_g942_i0	PRJNA800053	1079	759	3.40379	25.8347661	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1380	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g942	i0	99.604	124.484848484848	757	2	99	1	1	757	1249642	1250397	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	94484	1380	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23748938	23748938	PRJNA800053_P_NODE_23519_length_241_cov_1.470238_g23355_i0	PRJNA800053	23519	241	1.470238	3.54327358	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	267	7.12e-67	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g23355	i0	87.288	105.248962655602	236	27	98	3	4	239	267177	267409	Tautonia plasticadhaerens strain ElP chromosome	blastn	25365	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
23748960	23748960	PRJNA800053_P_NODE_4919_length_408_cov_6.304478_g4756_i0	PRJNA800053	4919	408	6.304478	25.72227024	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	745	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g4756	i0	99.754	115.941176470588	406	1	99	0	1	406	1251516	1251111	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	47304	745	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
24171526	24171526	PRJNA800053_P_NODE_6019_length_376_cov_2.244224_g5856_i0	PRJNA800053	6019	376	2.244224	8.43828224	Gemmata	113	Bacteria	Bacteria	579	1.3299999999999997e-160	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g5856	i0	94.638	124.438829787234	373	20	99	0	2	374	3634344	3633972	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	46789	579	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
25022828	25022828	PRJNA800053_P_NODE_21160_length_245_cov_0.895349_g20996_i0	PRJNA800053	21160	245	0.895349	2.19360505	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	263	9.38e-66	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g20996	i0	86.122	2.43265306122449	245	32	99	2	2	245	1012623	1012866	Luteolibacter sp. Populi chromosome, complete genome	blastn	596	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi

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