metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
392491	392491	PRJNA340009_P_NODE_65501_length_165_cov_60.275862_g65194_i0	PRJNA340009	65501	165	60.275862	99.4551723	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	152	1.3199999999999998e-32	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g65194	i0	84.177	65.9090909090909	158	23	95	2	7	163	7050392	7050236	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	10875	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2345414	2345414	PRJNA340009_P_NODE_44462_length_192_cov_2.608392_g44155_i0	PRJNA340009	44462	192	2.608392	5.00811264	Pirellula	123	Bacteria	Bacteria	305	1.15e-78	NTclustered	gi\|18092164\|gb\|AF399914.1\|	125	g44155	i0	97.238	94.625	181	4	94	1	1	181	1265	1444	Pirellula staleyi strain ATCC 35122 16S ribosomal RNA gene, partial sequence	blastn	18168	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
2345452	2345452	PRJNA340009_P_NODE_53022_length_179_cov_1.300000_g52715_i0	PRJNA340009	53022	179	1.3	2.327	Symmachiella	2795780	Bacteria	Bacteria	171	4.01e-38	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g52715	i0	85.294	21.5810055865922	170	20	94	5	11	178	2663933	2663767	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	3863	172	0.994186046511628	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2345518	2345518	PRJNA340009_P_NODE_67202_length_165_cov_0.879310_g66895_i0	PRJNA340009	67202	165	0.87931	1.4508615	Planctomycetia	203683	Bacteria	Bacteria	198	1.67e-46	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g66895	i0	90.132	23.4545454545455	152	15	92	0	5	156	4421807	4421958	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	3870	200	0.99	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2942547	2942547	PRJNA340009_P_NODE_18283_length_281_cov_0.836207_g17976_i0	PRJNA340009	18283	281	0.836207	2.34974167	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	303	6.48e-78	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g17976	i0	92.453	102.021352313167	212	16	75	0	11	222	3455298	3455087	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	28668	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
6770085	6770085	PRJNA340009_P_NODE_65926_length_165_cov_1.913793_g65619_i0	PRJNA340009	65926	165	1.913793	3.15775845	Symmachiella dynata	2527995	Bacteria	Bacteria	185	1.3e-42	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g65619	i0	89.262	68.8181818181818	149	14	90	2	1	148	1042274	1042127	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	11355	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
8045674	8045674	PRJNA340009_P_NODE_61287_length_167_cov_3.220339_g60980_i0	PRJNA340009	61287	167	3.220339	5.37796613	Planctomycetia bacterium	2052181	Bacteria	Bacteria	95.3	2.29e-15	NTclustered	gi\|1938772707\|gb\|CP054190.1\|	2052181	g60980	i0	91.304	0.413173652694611	69	6	41	0	1	69	791238	791306	MAG: Planctomycetia bacterium isolate H1_PLA3 chromosome, complete genome	blastn	69	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
8045707	8045707	PRJNA340009_P_NODE_63967_length_166_cov_1.418803_g63660_i0	PRJNA340009	63967	166	1.418803	2.35521298	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	63.9	6.42e-6	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g63660	i0	97.368	52.144578313253	38	0	22	1	124	160	865382	865419	Pirellula sp. SH-Sr6A, complete genome	blastn	8656	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
8722597	8722597	PRJNA340009_P_NODE_42307_length_196_cov_5.095238_g42000_i0	PRJNA340009	42307	196	5.095238	9.98666648	Candidatus Jettenia	360731	Bacteria	Bacteria	106	1.28e-18	NTclustered	gi\|2556874801\|gb\|CP129467.1\|	247490	g42000	i0	94.203	42.8571428571429	69	4	35	0	89	157	3320184	3320252	MAG: Candidatus Jettenia caeni isolate YC-1 chromosome, complete genome	blastn	8400	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Jettenia	Candidatus Jettenia caeni
8722677	8722677	PRJNA340009_P_NODE_59887_length_169_cov_2.533333_g59580_i0	PRJNA340009	59887	169	2.533333	4.28133277	Gimesia	1649453	Bacteria	Bacteria	206	1.02e-48	NTclustered	gi\|1727531535\|gb\|CP042910.1\|	122	g59580	i0	90.385	162.585798816568	156	15	92	0	14	169	2182987	2182832	Gimesia maris strain DSM 8797 chromosome, complete genome	blastn	27477	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
9320321	9320321	PRJNA340009_P_NODE_50508_length_182_cov_15.796992_g50201_i0	PRJNA340009	50508	182	15.796992	28.75052544	Gimesia algae	2527971	Bacteria	Bacteria	137	4.15e-28	NTclustered	gi\|1712549334\|gb\|CP036343.1\|	2527971	g50201	i0	83.673	103.181318681319	147	23	81	1	36	182	2345374	2345229	Gimesia algae strain Pan161 chromosome	blastn	18779	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia algae
9320626	9320626	PRJNA340009_P_NODE_80888_length_151_cov_11.529412_g80581_i0	PRJNA340009	80888	151	11.529412	17.40941212	planctomycete str. 658	149590	Bacteria	Bacteria	165	1.52e-36	NTclustered	gi\|12583971\|gb\|AF245375.1\|AF245375	149590	g80581	i0	87.248	91.6490066225166	149	14	97	4	5	151	1832	1687	Planctomycete str. 658 23S ribosomal RNA gene, partial sequence	blastn	13839	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 658
10596282	10596282	PRJNA340009_P_NODE_76369_length_161_cov_0.910714_g76062_i0	PRJNA340009	76369	161	0.910714	1.46624954	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	89.8	1.02e-13	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g76062	i0	98.039	0.316770186335404	51	1	32	0	3	53	4010176	4010126	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	51	89.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
13145443	13145443	PRJNA340009_P_NODE_14251_length_312_cov_82.847909_g13944_i0	PRJNA340009	14251	312	82.847909	258.48547608	Aureliella helgolandensis	2527968	Bacteria	Bacteria	278	4.42e-70	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g13944	i0	91.919	8.78525641025641	198	16	63	0	96	293	6998810	6999007	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	2741	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
13823388	13823388	PRJNA340009_P_NODE_17831_length_284_cov_1.217021_g17524_i0	PRJNA340009	17831	284	1.217021	3.45633964	Gemmata	113	Bacteria	Bacteria	62.1	4.36e-5	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g17524	i0	97.297	0.77112676056338	37	0	13	1	246	282	6667418	6667453	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	219	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
15097929	15097929	PRJNA340009_P_NODE_60632_length_168_cov_2.495798_g60325_i0	PRJNA340009	60632	168	2.495798	4.19294064	Botrimarina	2795782	Bacteria	Bacteria	145	2.26e-30	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g60325	i0	84.967	5.42857142857143	153	12	88	11	10	156	4244962	4244815	Planctomycetes bacterium K2D chromosome, complete genome	blastn	912	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
18244151	18244151	PRJNA340009_P_NODE_76755_length_161_cov_0.910714_g76448_i0	PRJNA340009	76755	161	0.910714	1.46624954	Adhaeretor mobilis	1930276	Bacteria	Bacteria	169	1.27e-37	NTclustered	gi\|1712449852\|gb\|CP036263.1\|	1930276	g76448	i0	86.755	132.254658385093	151	20	94	0	1	151	3976235	3976085	Adhaeretor mobilis strain HG15A2 chromosome, complete genome	blastn	21293	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
19518311	19518311	PRJNA340009_P_NODE_67836_length_164_cov_51.826087_g67529_i0	PRJNA340009	67836	164	51.826087	84.99478268	planctomycete str. 449	79870	Bacteria	Bacteria	193	7.73e-45	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g67529	i0	89.103	130.951219512195	156	16	95	1	7	162	189	35	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	21476	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
20793359	20793359	PRJNA340009_P_NODE_21297_length_263_cov_1.228972_g20990_i0	PRJNA340009	21297	263	1.228972	3.23219636	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	331	2.75e-86	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g20990	i0	91.057	160.840304182509	246	21	93	1	9	253	2002805	2002560	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	42301	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20793827	20793827	PRJNA340009_P_NODE_63237_length_166_cov_181.991453_g62930_i0	PRJNA340009	63237	166	181.991453	302.10581198	Symmachiella dynata	2527995	Bacteria	Bacteria	115	1.75e-21	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g62930	i0	90	86.921686746988	90	7	72	2	33	120	1040599	1040688	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	14429	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
22068658	22068658	PRJNA340009_P_NODE_41238_length_198_cov_111.664430_g40931_i0	PRJNA340009	41238	198	111.66443	221.0955714	Humisphaera borealis	2807512	Bacteria	Bacteria	207	3.46e-49	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g40931	i0	86.387	255.020202020202	191	25	96	1	2	192	5062694	5062883	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	50494	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
22069009	22069009	PRJNA340009_P_NODE_72218_length_163_cov_0.894737_g71911_i0	PRJNA340009	72218	163	0.894737	1.45842131	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	84.2	4.82e-12	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g71911	i0	82.292	1.2760736196319	96	17	59	0	38	133	3323084	3323179	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	208	84.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22746882	22746882	PRJNA340009_P_NODE_30718_length_225_cov_1.090909_g30411_i0	PRJNA340009	30718	225	1.090909	2.45454525	Bacteria	2	Bacteria	Bacteria	296	8.37e-76	NTclustered	gi\|2916408352\|gb\|CP170455.1\|	2052180	g30411	i0	90.308	162.395555555556	227	20	100	2	1	225	1077344	1077570	MAG: Phycisphaerales bacterium isolate tig00000072 chromosome, complete genome	blastn	36539	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
23344312	23344312	PRJNA340009_P_NODE_58159_length_171_cov_36.729508_g57852_i0	PRJNA340009	58159	171	36.729508	62.80745868	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	183	4.869999999999999e-42	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g57852	i0	85.965	8.32748538011696	171	24	100	0	1	171	3097750	3097580	Pirellula sp. SH-Sr6A, complete genome	blastn	1424	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
24618004	24618004	PRJNA340009_P_NODE_14900_length_306_cov_12.649805_g14593_i0	PRJNA340009	14900	306	12.649805	38.7084033	Symmachiella dynata	2527995	Bacteria	Bacteria	231	3.42e-56	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g14593	i0	85.022	43.2614379084967	227	34	74	0	62	288	1040908	1041134	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	13238	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata

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