metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1009807" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1009807" 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
154817	154817	PRJNA1009807_S_NODE_2801_length_190_cov_4.529801_g2773_i0	PRJNA1009807	2801	190	4.529801	8.6066219	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	176	9.28e-40	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g2773	i0	83.871	438.257894736842	186	28	97	2	1	185	4345599	4345415	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	83269	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
1429612	1429612	PRJNA1009807_S_NODE_542_length_395_cov_5.342697_g514_i0	PRJNA1009807	542	395	5.342697	21.10365315	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	486	8.739999999999999e-133	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g514	i0	90.186	331.055696202532	377	32	95	5	18	391	2191487	2191113	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	130767	486	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
5257703	5257703	PRJNA1009807_S_NODE_1625_length_240_cov_2.194030_g1597_i0	PRJNA1009807	1625	240	2.19403	5.265672	Symmachiella dynata	2527995	Bacteria	Bacteria	230	9.29e-56	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g1597	i0	86.047	77.5125	215	29	89	1	1	214	1043154	1043368	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	18603	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
7807374	7807374	PRJNA1009807_S_NODE_447_length_425_cov_3.435233_g419_i0	PRJNA1009807	447	425	3.435233	14.59974025	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	396	1.64e-105	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g419	i0	84.3	196.127058823529	414	55	97	8	13	423	2190406	2190812	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	83354	396	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
7807385	7807385	PRJNA1009807_S_NODE_527_length_400_cov_3.775623_g499_i0	PRJNA1009807	527	400	3.775623	15.102492	Saltatorellus ferox	2528018	Bacteria	Bacteria	248	4.55e-61	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g499	i0	82.712	237.175	295	35	72	11	49	334	2930713	2931000	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	94870	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
8654521	8654521	PRJNA1009807_S_NODE_1347_length_260_cov_3.764706_g1319_i0	PRJNA1009807	1347	260	3.764706	9.7882356	Planctomycetia	203683	Bacteria	Bacteria	291	4.61e-74	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g1319	i0	86.923	152.492307692308	260	33	100	1	1	260	604	862	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	39648	292	0.996575342465753	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
9082275	9082275	PRJNA1009807_S_NODE_2028_length_218_cov_2.463687_g2000_i0	PRJNA1009807	2028	218	2.463687	5.37083766	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	309	1.04e-79	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g2000	i0	92.237	46.0733944954128	219	15	100	2	1	218	1599676	1599459	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	10044	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
9082278	9082278	PRJNA1009807_S_NODE_228_length_541_cov_4.266932_g204_i0	PRJNA1009807	228	541	4.266932	23.08410212	Urbifossiella limnaea	2528023	Bacteria	Bacteria	813	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g204	i0	93.761	75.1090573012939	545	28	100	6	1	541	2019260	2018718	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	40634	813	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9929415	9929415	PRJNA1009807_S_NODE_4708_length_155_cov_1.172414_g4680_i0	PRJNA1009807	4708	155	1.172414	1.8172417	Schlesneria	656899	Bacteria	Bacteria	220	3.2999999999999996e-53	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g4680	i0	93.289	167.909677419355	149	10	96	0	7	155	665	813	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	26026	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
11633436	11633436	PRJNA1009807_S_NODE_90_length_761_cov_3.596953_g74_i0	PRJNA1009807	90	761	3.596953	27.37281233	Urbifossiella limnaea	2528023	Bacteria	Bacteria	1223	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g74	i0	95.675	185.411300919842	763	29	100	4	1	761	4212453	4211693	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	141098	1223	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
12480200	12480200	PRJNA1009807_S_NODE_1490_length_248_cov_5.033493_g1462_i0	PRJNA1009807	1490	248	5.033493	12.48306264	Candidatus Uabimicrobium	2897349	Bacteria	Bacteria	202	2.0999999999999998e-47	NTclustered	gi\|1732437785\|dbj\|AP019860.1\|	2596890	g1462	i0	82.072	113.91935483871	251	31	98	13	1	244	4989715	4989958	Planctomycetes bacterium SRT547 DNA, complete genome	blastn	28252	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
14183475	14183475	PRJNA1009807_S_NODE_432_length_432_cov_8.407125_g404_i0	PRJNA1009807	432	432	8.407125	36.31878	Urbifossiella limnaea	2528023	Bacteria	Bacteria	385	3.62e-102	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g404	i0	83.333	234.69212962963	438	51	100	20	1	426	2018404	2018831	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	101387	385	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
18006569	18006569	PRJNA1009807_S_NODE_4315_length_160_cov_1.685950_g4287_i0	PRJNA1009807	4315	160	1.68595	2.69752	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	198	1.61e-46	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4287	i0	89.809	210.84375	157	13	96	3	1	154	2002185	2002341	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	33735	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19280329	19280329	PRJNA1009807_S_NODE_1196_length_277_cov_4.344538_g1168_i0	PRJNA1009807	1196	277	4.344538	12.03437026	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	424	4.69e-114	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g1168	i0	94.224	289.949458483755	277	16	100	0	1	277	2192169	2192445	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	80316	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
19280345	19280345	PRJNA1009807_S_NODE_2396_length_203_cov_2.597561_g2368_i0	PRJNA1009807	2396	203	2.597561	5.27304883	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	259	9.71e-65	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g2368	i0	93.296	68.5024630541872	179	7	87	4	28	203	1866474	1866650	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	13906	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20127872	20127872	PRJNA1009807_S_NODE_4676_length_155_cov_1.879310_g4648_i0	PRJNA1009807	4676	155	1.87931	2.9129305	Singulisphaera	466152	Bacteria	Bacteria	209	7.15e-50	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g4648	i0	92.517	41.8709677419355	147	9	95	1	8	154	913	769	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	6490	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
20555997	20555997	PRJNA1009807_S_NODE_937_length_309_cov_5.866667_g909_i0	PRJNA1009807	937	309	5.866667	18.12800103	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	385	2.499999999999999e-102	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g909	i0	89.508	63.8640776699029	305	30	98	2	1	304	2583886	2583583	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	19734	385	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21831597	21831597	PRJNA1009807_S_NODE_3978_length_165_cov_2.857143_g3950_i0	PRJNA1009807	3978	165	2.857143	4.71428595	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	182	1.6899999999999996e-41	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g3950	i0	95.575	5.6	113	5	68	0	3	115	2582890	2583002	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	924	182	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);;