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

12 rows where analysis = "blastn", bioproject = "PRJNA1093380" and tax_phylum = "Planctomycetota"

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
2749917	2749917	PRJNA1093380_P_NODE_6423_length_283_cov_1.100000_g6317_i0	PRJNA1093380	6423	283	1.1	3.113	Urbifossiella limnaea	2528023	Bacteria	Bacteria	276	1.4199999999999999e-69	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6317	i0	87.045	78.3003533568905	247	28	87	4	1	245	2018907	2019151	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	22159	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
5302102	5302102	PRJNA1093380_P_NODE_925_length_575_cov_1.735060_g822_i0	PRJNA1093380	925	575	1.73506	9.976595	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	830	0	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g822	i0	92.696	207.737391304348	575	42	100	0	1	575	3454218	3453644	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	119449	830	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
7851856	7851856	PRJNA1093380_P_NODE_1727_length_428_cov_1.636620_g1621_i0	PRJNA1093380	1727	428	1.63662	7.0047336	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	791	0	NTclustered	gi\|55975911\|gb\|AY802942.1\|	120965	g1621	i0	100	99.6144859813084	428	0	100	0	1	428	76	503	Uncultured planctomycete clone FPln-22 16S ribosomal RNA gene, partial sequence	blastn	42635	791	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
9126822	9126822	PRJNA1093380_P_NODE_2388_length_375_cov_3.728477_g2282_i0	PRJNA1093380	2388	375	3.728477	13.98178875	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	649	0	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g2282	i0	97.878	158.173333333333	377	4	100	4	1	375	3454589	3454215	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	59315	649	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
14227838	14227838	PRJNA1093380_P_NODE_16752_length_241_cov_1.833333_g16646_i0	PRJNA1093380	16752	241	1.833333	4.41833253	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	307	4.1900000000000005e-79	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g16646	i0	90	6.51452282157676	250	7	100	13	1	241	1830896	1830656	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	1570	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
14227870	14227870	PRJNA1093380_P_NODE_2692_length_360_cov_3.027875_g2586_i0	PRJNA1093380	2692	360	3.027875	10.90035	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	593	4.519999999999998e-165	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g2586	i0	96.893	116.333333333333	354	11	98	0	1	354	7628522	7628875	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	41880	593	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
16776248	16776248	PRJNA1093380_P_NODE_2014_length_402_cov_2.577508_g1908_i0	PRJNA1093380	2014	402	2.577508	10.36158216	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	616	1.0899999999999995e-171	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g1908	i0	94.71	476.310945273632	397	19	99	2	1	396	3454578	3454973	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	191477	616	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
20600198	20600198	PRJNA1093380_P_NODE_2037_length_400_cov_1.853211_g1931_i0	PRJNA1093380	2037	400	1.853211	7.412844	Urbifossiella limnaea	2528023	Bacteria	Bacteria	575	1.8399999999999994e-159	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g1931	i0	92.556	128.4825	403	26	100	4	1	400	2019829	2019428	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	51393	575	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20600212	20600212	PRJNA1093380_P_NODE_3117_length_343_cov_1.140741_g3011_i0	PRJNA1093380	3117	343	1.140741	3.91274163	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	449	9.84e-122	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g3011	i0	90.23	158.00583090379	348	29	100	3	1	343	7050955	7050608	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	54196	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23151322	23151322	PRJNA1093380_P_NODE_10199_length_261_cov_1.079787_g10093_i0	PRJNA1093380	10199	261	1.079787	2.81824407	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	359	1.25e-94	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10093	i0	92.157	183.528735632184	255	18	97	2	8	261	2002781	2002528	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	47901	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24425089	24425089	PRJNA1093380_P_NODE_4440_length_304_cov_8.086580_g4334_i0	PRJNA1093380	4440	304	8.08658	24.5832032	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	318	2.53e-82	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g4334	i0	87.868	145.118421052632	272	31	89	2	2	271	7053161	7053432	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	44116	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24425131	24425131	PRJNA1093380_P_NODE_7280_length_277_cov_1.544118_g7174_i0	PRJNA1093380	7280	277	1.544118	4.27720686	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	222	1.84e-53	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g7174	i0	82.182	12.8158844765343	275	33	99	7	1	275	1831181	1831439	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	3550	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales 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);;