metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA975724" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA975724" 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
946171	946171	PRJNA975724_S_NODE_42121_length_315_cov_0.954545_g41940_i0	PRJNA975724	42121	315	0.954545	3.00681675	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	505	1.8799999999999995e-138	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g41940	i0	95.847	129.793650793651	313	12	99	1	1	312	4467217	4466905	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	40885	505	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
946280	946280	PRJNA975724_S_NODE_46161_length_305_cov_2.224138_g45980_i0	PRJNA975724	46161	305	2.224138	6.7836209	Phycisphaera mikurensis	547188	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|381385343\|dbj\|AP012338.1\|	1142394	g45980	i0	92.5	0.222950819672131	40	2	13	1	26	65	3653611	3653573	Phycisphaera mikurensis NBRC 102666 DNA, complete genome	blastn	68	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
2542439	2542439	PRJNA975724_S_NODE_18222_length_395_cov_2.062112_g18041_i0	PRJNA975724	18222	395	2.062112	8.1453424	Candidatus Protochlamydia	282132	Bacteria	Bacteria	604	2.309999999999999e-168	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g18041	i0	95.276	186.643037974684	381	18	96	0	15	395	1249125	1249505	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	73724	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
3497271	3497271	PRJNA975724_S_NODE_60783_length_277_cov_2.132353_g60602_i0	PRJNA975724	60783	277	2.132353	5.90661781	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	440	4.6499999999999983e-119	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g60602	i0	95.341	155.447653429603	279	9	100	3	1	277	654468	654192	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	43059	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
5095128	5095128	PRJNA975724_S_NODE_5064_length_521_cov_2.537946_g4885_i0	PRJNA975724	5064	521	2.537946	13.22269866	Pseudomonadati	3379134	Bacteria	Bacteria	669	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g4885	i0	91.111	118.268714011516	495	43	95	1	27	520	1728837	1728343	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	61618	669	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6049860	6049860	PRJNA975724_S_NODE_60145_length_278_cov_2.629268_g59964_i0	PRJNA975724	60145	278	2.629268	7.30936504	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	316	8.22e-82	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g59964	i0	87.544	69.9820143884892	281	25	99	9	3	278	4469489	4469214	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	19455	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
7323845	7323845	PRJNA975724_S_NODE_31806_length_342_cov_2.003717_g31625_i0	PRJNA975724	31806	342	2.003717	6.85271214	Estrella lausannensis	483423	Bacteria	Bacteria	302	2.91e-77	NTclustered	gi\|343183590\|gb\|JN201889.1\|	483423	g31625	i0	82.659	169.72514619883	346	54	100	6	1	342	1574	1231	Estrella lausannensis 23S ribosomal RNA gene, complete sequence	blastn	58046	302	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
9874489	9874489	PRJNA975724_S_NODE_47828_length_302_cov_1.008734_g47647_i0	PRJNA975724	47828	302	1.008734	3.04637668	Horticoccus luteus	2862869	Bacteria	Bacteria	73.1	2.16e-8	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g47647	i0	92.157	0.311258278145695	51	4	17	0	15	65	1994866	1994916	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	94	73.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
11149945	11149945	PRJNA975724_S_NODE_4909_length_525_cov_1.703540_g4730_i0	PRJNA975724	4909	525	1.70354	8.943585	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	582	1.4799999999999999e-161	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g4730	i0	86.932	78.8190476190476	528	58	99	10	3	525	1867784	1867263	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	41380	582	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11470596	11470596	PRJNA975724_S_NODE_12029_length_433_cov_4.822222_g11848_i0	PRJNA975724	12029	433	4.822222	20.88022126	Planctopirus	1649480	Bacteria	Bacteria	544	5.66e-150	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g11848	i0	89.401	94.4965357967668	434	43	99	2	1	432	1616	1184	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	40917	544	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
12425695	12425695	PRJNA975724_S_NODE_55050_length_287_cov_42.383178_g54869_i0	PRJNA975724	55050	287	42.383178	121.63972086	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	351	2.34e-92	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g54869	i0	90.84	43.0174216027875	262	24	91	0	1	262	173622	173361	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	12346	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
14974537	14974537	PRJNA975724_S_NODE_6072_length_501_cov_1.619159_g5893_i0	PRJNA975724	6072	501	1.619159	8.11198659	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	604	2.9999999999999985e-168	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g5893	i0	89.979	270.916167664671	469	45	93	2	1	468	2363973	2364440	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	135729	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
16569312	16569312	PRJNA975724_S_NODE_53573_length_290_cov_2.129032_g53392_i0	PRJNA975724	53573	290	2.129032	6.1741928	Parachlamydiales	1963360	Bacteria	Bacteria	331	3.0800000000000006e-86	NTclustered	gi\|5042360\|gb\|U68460.2\|SSU68460	83561	g53392	i0	87.543	108.931034482759	289	32	99	4	3	289	3414	3700	Simkania negevensis 16S and 23S ribosomal RNA operon, complete sequence; and putative endonuclease homodimer gene, complete cds	blastn	31590	333	0.993993993993994	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
17523567	17523567	PRJNA975724_S_NODE_18594_length_393_cov_2.037500_g18413_i0	PRJNA975724	18594	393	2.0375	8.007375	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	464	4.07e-126	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g18413	i0	89.067	251.089058524173	375	40	95	1	15	389	2191019	2190646	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	98678	464	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
17523797	17523797	PRJNA975724_S_NODE_27234_length_357_cov_2.982394_g27053_i0	PRJNA975724	27234	357	2.982394	10.64714658	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	499	1e-136	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g27053	i0	91.899	178.086834733894	358	27	100	2	1	357	2362895	2363251	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	63577	499	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
17524284	17524284	PRJNA975724_S_NODE_46154_length_305_cov_2.280172_g45973_i0	PRJNA975724	46154	305	2.280172	6.9545246	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	322	1.96e-83	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g45973	i0	87.544	66.0360655737705	281	32	91	3	15	293	1250339	1250618	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	20141	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
18797208	18797208	PRJNA975724_S_NODE_1095_length_782_cov_8.662906_g950_i0	PRJNA975724	1095	782	8.662906	67.74392492	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	1018	0	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g950	i0	90.114	120.695652173913	789	70	100	7	1	782	4469230	4468443	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	94384	1018	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
18797768	18797768	PRJNA975724_S_NODE_33195_length_338_cov_1.520755_g33014_i0	PRJNA975724	33195	338	1.520755	5.1401519	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	135	3.0800000000000004e-27	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g33014	i0	76.744	2.45562130177515	301	35	86	24	26	315	112016	111740	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	830	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
20073121	20073121	PRJNA975724_S_NODE_53916_length_290_cov_1.018433_g53735_i0	PRJNA975724	53916	290	1.018433	2.9534557	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	329	1.1099999999999998e-85	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g53735	i0	87.119	113.451724137931	295	32	100	5	1	290	654929	655222	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	32901	329	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21349086	21349086	PRJNA975724_S_NODE_73797_length_257_cov_1.673913_g73616_i0	PRJNA975724	73797	257	1.673913	4.30195641	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	296	9.78e-76	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g73616	i0	87.938	72.3035019455253	257	23	97	7	8	257	7051926	7051671	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	18582	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21349190	21349190	PRJNA975724_S_NODE_77_length_1765_cov_69.332151_g69_i0	PRJNA975724	77	1765	69.332151	1223.71246515	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	2403	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g69	i0	91.487	181.873654390935	1762	128	99	17	3	1756	1728992	1727245	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	321007	2403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21669159	21669159	PRJNA975724_S_NODE_67577_length_266_cov_1.860104_g67396_i0	PRJNA975724	67577	266	1.860104	4.94787664	Chlamydiia	204429	Bacteria	Bacteria	407	4.509999999999999e-109	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g67396	i0	94.361	114.53007518797	266	14	100	1	1	266	2363602	2363866	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	30465	407	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
22622663	22622663	PRJNA975724_S_NODE_18_length_2943_cov_7.134146_g17_i0	PRJNA975724	18	2943	7.134146	209.95791678	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1290	0	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g17	i0	76.214	180.427454977914	2678	500	93	115	3	2631	2620694	2623283	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	530998	1290	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
23898769	23898769	PRJNA975724_S_NODE_47159_length_303_cov_1.673913_g46978_i0	PRJNA975724	47159	303	1.673913	5.07195639	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	272	1.99e-68	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g46978	i0	84.397	663.425742574257	282	38	92	6	20	297	2364438	2364159	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	201018	272	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales 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);;