metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA917598" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA917598" 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
2171065	2171065	PRJNA917598_P_NODE_28222_length_434_cov_1.157895_g27278_i0	PRJNA917598	28222	434	1.157895	5.0252643	Phycisphaera mikurensis	547188	Bacteria	Bacteria	172	3.08e-38	NTclustered	gi\|381385343\|dbj\|AP012338.1\|	1142394	g27278	i0	80.417	0.682027649769585	240	36	54	7	55	290	708823	709055	Phycisphaera mikurensis NBRC 102666 DNA, complete genome	blastn	296	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
2171326	2171326	PRJNA917598_P_NODE_38362_length_371_cov_0.758389_g37418_i0	PRJNA917598	38362	371	0.758389	2.81362319	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	460	4.95e-125	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g37418	i0	91.228	465.929919137466	342	25	91	4	34	370	1831257	1830916	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	172860	460	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
2171768	2171768	PRJNA917598_P_NODE_56522_length_302_cov_1.672489_g55578_i0	PRJNA917598	56522	302	1.672489	5.05091678	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	366	8.84e-97	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g55578	i0	93.173	94.5860927152318	249	17	82	0	54	302	2583002	2582754	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	28565	366	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
4724307	4724307	PRJNA917598_P_NODE_32084_length_406_cov_1.588589_g31140_i0	PRJNA917598	32084	406	1.588589	6.44967134	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	586	8.639999999999997e-163	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g31140	i0	92.647	122.495073891626	408	28	100	2	1	406	1867230	1866823	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	49733	586	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
6000408	6000408	PRJNA917598_P_NODE_92745_length_243_cov_0.905882_g91801_i0	PRJNA917598	92745	243	0.905882	2.20129326	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	340	4.169999999999999e-89	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g91801	i0	92.593	86.3333333333333	243	9	97	8	4	239	7051242	7051002	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	20979	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7274082	7274082	PRJNA917598_P_NODE_36166_length_382_cov_0.880259_g35222_i0	PRJNA917598	36166	382	0.880259	3.36258938	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	442	1.8499999999999992e-119	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g35222	i0	88.649	142.688481675393	370	33	96	8	1	366	2002251	2001887	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	54507	442	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7629753	7629753	PRJNA917598_P_NODE_79526_length_251_cov_0.865169_g78582_i0	PRJNA917598	79526	251	0.865169	2.17157419	Planctomycetia	203683	Bacteria	Bacteria	220	5.89e-53	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g78582	i0	88.235	89.7529880478088	187	18	74	4	61	245	7051659	7051475	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	22528	222	0.990990990990991	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9823606	9823606	PRJNA917598_P_NODE_31108_length_413_cov_1.111765_g30164_i0	PRJNA917598	31108	413	1.111765	4.59158945	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	512	1.51e-140	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g30164	i0	90	157.031476997579	400	34	96	6	18	413	7051408	7051011	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	64854	512	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11099543	11099543	PRJNA917598_P_NODE_42809_length_351_cov_1.500000_g41865_i0	PRJNA917598	42809	351	1.5	5.265	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	518	2.72e-142	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g41865	i0	93.429	120.336182336182	350	22	99	1	3	351	2002652	2002303	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	42238	518	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13649203	13649203	PRJNA917598_P_NODE_25231_length_460_cov_2.503876_g24288_i0	PRJNA917598	25231	460	2.503876	11.5178296	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	440	8.149999999999996e-119	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g24288	i0	86.408	91.095652173913	412	45	88	11	53	458	657299	656893	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	41904	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14005345	14005345	PRJNA917598_P_NODE_42051_length_354_cov_1.370107_g41107_i0	PRJNA917598	42051	354	1.370107	4.85017878	Engelhardtia	139931	Bacteria	Bacteria	228	5.1799999999999985e-55	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g41107	i0	85.586	87.228813559322	222	26	62	6	6	225	5247907	5247690	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	30879	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
14005392	14005392	PRJNA917598_P_NODE_47211_length_334_cov_1.176245_g46267_i0	PRJNA917598	47211	334	1.176245	3.9286583	Candidatus Protochlamydia	282132	Bacteria	Bacteria	484	2.6199999999999996e-132	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g46267	i0	92.836	174.928143712575	335	23	100	1	1	334	2154264	2153930	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	58426	484	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
14924100	14924100	PRJNA917598_P_NODE_48172_length_330_cov_2.031128_g47228_i0	PRJNA917598	48172	330	2.031128	6.7027224	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	433	9.499999999999999e-117	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g47228	i0	90.798	89.9666666666667	326	26	98	3	1	324	2002794	2003117	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	29689	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14924179	14924179	PRJNA917598_P_NODE_51272_length_320_cov_0.935223_g50328_i0	PRJNA917598	51272	320	0.935223	2.9927136	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	278	4.55e-70	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g50328	i0	82.515	121.78125	326	47	100	8	1	320	7052138	7051817	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	38970	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14924181	14924181	PRJNA917598_P_NODE_51312_length_319_cov_2.504065_g50368_i0	PRJNA917598	51312	319	2.504065	7.98796735	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	117	1.05e-21	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g50368	i0	79.532	0.536050156739812	171	29	53	6	2	170	2453295	2453129	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	171	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
16199343	16199343	PRJNA917598_P_NODE_59213_length_293_cov_2.077273_g58269_i0	PRJNA917598	59213	293	2.077273	6.08640989	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	294	4.09e-75	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g58269	i0	85.274	123.156996587031	292	36	99	7	1	289	3989696	3989983	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	36085	294	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
18747675	18747675	PRJNA917598_P_NODE_44535_length_344_cov_1.221402_g43591_i0	PRJNA917598	44535	344	1.221402	4.20162288	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	346	1.33e-90	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g43591	i0	91.304	81.046511627907	253	22	74	0	92	344	7629652	7629904	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	27880	346	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
18748014	18748014	PRJNA917598_P_NODE_57115_length_300_cov_1.414097_g56171_i0	PRJNA917598	57115	300	1.414097	4.242291	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	287	7.030000000000001e-73	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g56171	i0	87.451	205.396666666667	255	24	84	8	50	300	7051405	7051155	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	61619	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20377946	20377946	PRJNA917598_P_NODE_7676_length_868_cov_1.800000_g6860_i0	PRJNA917598	7676	868	1.8	15.624	Waddlia	71666	Bacteria	Bacteria	761	0	NTclustered	gi\|470485904\|ref\|NR_076723.1\|	71667	g6860	i0	82.809	191.44930875576	890	116	99	25	2	865	1842	964	Waddlia chondrophila strain WSU 86-1044 23S ribosomal RNA gene, complete sequence	blastn	166178	761	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
21298766	21298766	PRJNA917598_P_NODE_72057_length_268_cov_0.846154_g71113_i0	PRJNA917598	72057	268	0.846154	2.26769272	Pedosphaera parvula	1032527	Bacteria	Bacteria	388	1.65e-103	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g71113	i0	93.182	84.9365671641791	264	18	99	0	1	264	941	1204	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	22763	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
22573339	22573339	PRJNA917598_P_NODE_53498_length_312_cov_1.610879_g52554_i0	PRJNA917598	53498	312	1.610879	5.02594248	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	355	1.99e-93	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g52554	i0	87.987	36.6538461538462	308	27	97	8	9	311	2190447	2190145	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	11436	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
23848780	23848780	PRJNA917598_P_NODE_61859_length_287_cov_2.228972_g60915_i0	PRJNA917598	61859	287	2.228972	6.39714964	uncultured Ruficoccus sp.	2175960	Bacteria	Bacteria	279	1.12e-70	NTclustered	gi\|2907625921\|emb\|OZ223481.1\|	2175960	g60915	i0	85.874	105.435540069686	269	30	92	7	23	287	741277	741013	MAG: uncultured Ruficoccus sp. isolate b2a3d85c-2e17-47e2-9e32-7ac6437316b9 genome assembly, chromosome: 10	blastn	30260	279	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	uncultured Ruficoccus sp.
25121518	25121518	PRJNA917598_P_NODE_19300_length_531_cov_2.460699_g18363_i0	PRJNA917598	19300	531	2.460699	13.06631169	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	665	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g18363	i0	89.662	147.139359698682	532	42	99	11	3	527	1866748	1866223	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	78131	665	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);;