metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1249535" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1249535" 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
2909402	2909402	PRJNA1249535_S_NODE_6523_length_961_cov_14.905405_g489_i1	PRJNA1249535	6523	961	14.905405	143.24094205	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	56.5	0.008	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g489	i1	100	0.0915712799167534	30	0	3	0	655	684	1852334	1852363	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	88	56.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
4183608	4183608	PRJNA1249535_S_NODE_206604_length_303_cov_1.017391_g203221_i0	PRJNA1249535	206604	303	1.017391	3.08269473	Roseimaritima ulvae	980254	Bacteria	Bacteria	459	1.4199999999999996e-124	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g203221	i0	94.059	212.3300330033	303	16	99	1	3	303	6160309	6160007	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	64336	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae
5462572	5462572	PRJNA1249535_S_NODE_965_length_1925_cov_20.231641_g489_i0	PRJNA1249535	965	1925	20.231641	389.45908925	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	56.5	0.015	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g489	i0	100	0.0155844155844156	30	0	2	0	278	307	1852363	1852334	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
6735071	6735071	PRJNA1249535_S_NODE_275546_length_266_cov_2.720207_g272163_i0	PRJNA1249535	275546	266	2.720207	7.23575062	Stieleria varia	2528005	Bacteria	Bacteria	470	5.669999999999999e-128	NTclustered	gi\|2720418917\|gb\|CP151726.1\|	2528005	g272163	i0	98.496	141.868421052632	266	4	100	0	1	266	2278152	2278417	Stieleria varia strain Pla52n chromosome, complete genome	blastn	37737	470	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria varia
9283702	9283702	PRJNA1249535_S_NODE_132688_length_347_cov_2.076642_g129305_i0	PRJNA1249535	132688	347	2.076642	7.20594774	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	544	4.45e-150	NTclustered	gi\|338182594\|gb\|JF983102.1\|	156588	g129305	i0	96.914	95.2939481268012	324	10	93	0	1	324	198	521	Uncultured Verrucomicrobia bacterium clone Upland_75_2390 16S ribosomal RNA gene, partial sequence	blastn	33067	544	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9286814	9286814	PRJNA1249535_S_NODE_60188_length_445_cov_4.231183_g56819_i0	PRJNA1249535	60188	445	4.231183	18.82876435	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	60.2	2.57e-4	NTclustered	gi\|2621701142\|emb\|OY759675.1\|	2813034	g56819	i0	100	0.0719101123595506	32	0	7	0	314	345	3644773	3644742	MAG: Sedimentisphaerales bacterium isolate f0e5d044-1a19-4baf-a299-9636c83af3ad genome assembly, chromosome: 1	blastn	32	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
14385201	14385201	PRJNA1249535_S_NODE_180872_length_317_cov_1.553279_g177489_i0	PRJNA1249535	180872	317	1.553279	4.92389443	Chlamydiales bacterium QZY	2803004	Bacteria	Bacteria	418	2.5399999999999995e-112	NTclustered	gi\|1955632013\|gb\|MW471098.1\|	2803004	g177489	i0	90.596	116.141955835962	319	24	100	4	1	317	171	485	Chlamydiales bacterium QZY 16S ribosomal RNA gene, partial sequence	blastn	36817	418	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium QZY
15080111	15080111	PRJNA1249535_S_NODE_68912_length_422_cov_16.120344_g65532_i0	PRJNA1249535	68912	422	16.120344	68.02785168	Chlamydia	810	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|1032413971\|gb\|CP015840.1\|	1143323	g65532	i0	96.97	0.625592417061611	33	0	8	1	287	318	817081	817113	Chlamydia gallinacea 08-1274/3, complete genome	blastn	264	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia gallinacea
18207835	18207835	PRJNA1249535_S_NODE_180915_length_317_cov_1.303279_g177532_i0	PRJNA1249535	180915	317	1.303279	4.13139443	Candidatus Methylacidiphilum infernorum	511746	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1999105499\|gb\|CP065956.1\|	511746	g177532	i0	94.595	0.116719242902208	37	0	12	2	58	94	617559	617593	Candidatus Methylacidiphilum infernorum strain IT5 chromosome, complete genome	blastn	37	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Candidatus Methylacidiphilum infernorum
19483214	19483214	PRJNA1249535_S_NODE_260776_length_274_cov_2.706468_g257393_i0	PRJNA1249535	260776	274	2.706468	7.41572232	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	398	2.8099999999999998e-106	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g257393	i0	92.78	108.934306569343	277	17	100	3	1	274	7052242	7052518	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	29848	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20757081	20757081	PRJNA1249535_S_NODE_139777_length_342_cov_2.401487_g136394_i0	PRJNA1249535	139777	342	2.401487	8.21308554	Roseimaritima ulvae	980254	Bacteria	Bacteria	235	2.99e-57	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g136394	i0	87.624	19.7017543859649	202	25	59	0	141	342	6157414	6157615	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	6738	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae

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