metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1197996" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1197996" 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
324173	324173	PRJNA1197996_S_NODE_26861_length_244_cov_1.350877_g26807_i0	PRJNA1197996	26861	244	1.350877	3.29613988	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	379	8.889999999999998e-101	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g26807	i0	94.672	145.196721311475	244	13	100	0	1	244	654211	654454	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	35428	379	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
1598715	1598715	PRJNA1197996_S_NODE_22842_length_254_cov_0.856354_g22788_i0	PRJNA1197996	22842	254	0.856354	2.17513916	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	453	5.41e-123	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g22788	i0	98.819	133.897637795276	254	3	100	0	1	254	573	320	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	34010	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
4871763	4871763	PRJNA1197996_S_NODE_2744_length_503_cov_1.786047_g2692_i0	PRJNA1197996	2744	503	1.786047	8.98381641	Bremerella	2714594	Bacteria	Bacteria	381	5.519999999999999e-101	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g2692	i0	81.857	448.900596421471	474	67	92	17	4	465	2674640	2674174	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	225797	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
5427241	5427241	PRJNA1197996_S_NODE_21825_length_258_cov_1.578378_g21771_i0	PRJNA1197996	21825	258	1.578378	4.07221524	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	287	5.910000000000001e-73	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g21771	i0	87.121	166.562015503876	264	20	99	9	4	258	7051284	7051542	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	42973	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6146529	6146529	PRJNA1197996_S_NODE_665_length_820_cov_4.752343_g630_i0	PRJNA1197996	665	820	4.752343	38.9692126	Planctomycetia	203683	Bacteria	Bacteria	1482	0	NTclustered	gi\|10436091\|gb\|AF239696.1\|AF239696	121118	g630	i0	99.269	118.723170731707	821	4	100	2	1	820	39	858	Gemmata-like str. JW11-2f5 16S ribosomal RNA gene, partial sequence	blastn	97353	1482	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Gemmata-like str. JW11-2f5
7421592	7421592	PRJNA1197996_S_NODE_5606_length_400_cov_3.318043_g5552_i0	PRJNA1197996	5606	400	3.318043	13.272172	Zavarzinella	600332	Bacteria	Bacteria	712	0	NTclustered	gi\|576901496\|gb\|KF827089.1\|	120965	g5552	i0	98.75	98.0625	400	5	100	0	1	400	787	388	Uncultured planctomycete clone C-5-14 16S ribosomal RNA gene, partial sequence	blastn	39225	712	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
10527842	10527842	PRJNA1197996_S_NODE_22569_length_255_cov_1.159341_g22515_i0	PRJNA1197996	22569	255	1.159341	2.95631955	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	350	7.34e-92	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g22515	i0	91.373	423.152941176471	255	22	100	0	1	255	2583676	2583930	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	107904	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11802705	11802705	PRJNA1197996_S_NODE_28350_length_241_cov_1.482143_g28296_i0	PRJNA1197996	28350	241	1.482143	3.57196463	Limnoglobus roseus	2598579	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g28296	i0	90.417	158.709543568465	240	16	98	7	5	241	2956646	2956411	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	38249	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
14353340	14353340	PRJNA1197996_S_NODE_7932_length_359_cov_1.527972_g7878_i0	PRJNA1197996	7932	359	1.527972	5.48541948	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	132	4.25e-26	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g7878	i0	84.962	2.78551532033426	133	17	36	3	156	286	1592840	1592971	Luteolibacter sp. Populi chromosome, complete genome	blastn	1000	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
15071405	15071405	PRJNA1197996_S_NODE_4032_length_444_cov_2.601078_g3978_i0	PRJNA1197996	4032	444	2.601078	11.54878632	Gemmata	113	Bacteria	Bacteria	699	0	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g3978	i0	95.045	171.369369369369	444	22	100	0	1	444	2327	1884	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	76088	699	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
15626665	15626665	PRJNA1197996_S_NODE_14053_length_300_cov_1.696035_g13999_i0	PRJNA1197996	14053	300	1.696035	5.088105	Candidatus Rubidus massiliensis	1444712	Bacteria	Bacteria	555	1.7399999999999995e-153	NTclustered	gi\|565666443\|emb\|HG726047.1\|	1444712	g13999	i0	100	107.84	300	0	100	0	1	300	583	284	Candidatus Rubidus massiliensis partial 16S rRNA gene, strain Rubis	blastn	32352	555	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Candidatus Rubidus	Candidatus Rubidus massiliensis
23276270	23276270	PRJNA1197996_S_NODE_22679_length_254_cov_1.784530_g22625_i0	PRJNA1197996	22679	254	1.78453	4.5327062	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	305	1.6e-78	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g22625	i0	88.627	161.606299212598	255	23	99	5	1	251	7052246	7052498	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	41048	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;