metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1095825" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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
200228	200228	PRJNA1095825_P_NODE_197761_length_278_cov_1.478049_g194698_i0	PRJNA1095825	197761	278	1.478049	4.10897622	Rhodopirellula baltica	265606	Bacteria	Bacteria	63.9	1.18e-5	NTclustered	gi\|32445988\|emb\|BX294148.1\|	243090	g194698	i0	95	0.262589928057554	40	2	14	0	23	62	151993	152032	Rhodopirellula baltica SH 1 complete genome; segment 16/24	blastn	73	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
200571	200571	PRJNA1095825_P_NODE_234561_length_252_cov_1.256983_g231498_i0	PRJNA1095825	234561	252	1.256983	3.16759716	Gemmataceae bacterium	2052164	Bacteria	Bacteria	84.2	8.1e-12	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g231498	i0	81.481	2.19047619047619	108	15	42	5	130	236	6862032	6861929	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	552	84.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
2751911	2751911	PRJNA1095825_P_NODE_297883_length_241_cov_0.910714_g294820_i0	PRJNA1095825	297883	241	0.910714	2.19482074	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	329	8.95e-86	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g294820	i0	91.286	98.7551867219917	241	21	100	0	1	241	1831839	1832079	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	23800	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
3569944	3569944	PRJNA1095825_P_NODE_183643_length_288_cov_1.432558_g180580_i0	PRJNA1095825	183643	288	1.432558	4.12576704	Gemmata	113	Bacteria	Bacteria	104	7.25e-18	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g180580	i0	89.286	2.16319444444444	84	8	29	1	205	287	3994286	3994203	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	623	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
4847630	4847630	PRJNA1095825_P_NODE_267924_length_246_cov_0.890173_g264861_i0	PRJNA1095825	267924	246	0.890173	2.18982558	Planctomycetia	203683	Bacteria	Bacteria	209	1.25e-49	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g264861	i0	83.945	10.1016260162602	218	35	89	0	27	244	5027051	5027268	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	2485	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
7853502	7853502	PRJNA1095825_P_NODE_254767_length_248_cov_0.880000_g251704_i0	PRJNA1095825	254767	248	0.88	2.1824	Gemmata sp. 28IL	1278135	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|443298398\|gb\|KC169940.1\|	1278135	g251704	i0	100	99.1895161290323	248	0	100	0	1	248	519	766	Gemmata sp. 28IL 16S ribosomal RNA gene, partial sequence	blastn	24599	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. 28IL
9127917	9127917	PRJNA1095825_P_NODE_195948_length_279_cov_1.776699_g192885_i0	PRJNA1095825	195948	279	1.776699	4.95699021	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	165	3.16e-36	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g192885	i0	86.275	7.8673835125448	153	19	54	2	1	152	406119	405968	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	2195	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
12954727	12954727	PRJNA1095825_P_NODE_268571_length_246_cov_0.890173_g265508_i0	PRJNA1095825	268571	246	0.890173	2.18982558	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	196	9.7e-46	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g265508	i0	82.278	5.85772357723577	237	33	95	6	9	241	8180248	8180479	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1441	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14229720	14229720	PRJNA1095825_P_NODE_275152_length_244_cov_1.795322_g272089_i0	PRJNA1095825	275152	244	1.795322	4.38058568	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	322	1.52e-83	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g272089	i0	90.612	212.881147540984	245	19	100	3	1	244	7051061	7050820	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	51943	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14229942	14229942	PRJNA1095825_P_NODE_295372_length_241_cov_0.916667_g292309_i0	PRJNA1095825	295372	241	0.916667	2.20916747	Lignipirellula cremea	2528010	Bacteria	Bacteria	167	7.429999999999999e-37	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g292309	i0	79.424	1.85892116182573	243	44	99	3	2	241	2770415	2770654	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	448	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
15502962	15502962	PRJNA1095825_P_NODE_200473_length_276_cov_1.517241_g197410_i0	PRJNA1095825	200473	276	1.517241	4.18758516	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g197410	i0	94.444	0.130434782608696	36	2	13	0	2	37	3393313	3393348	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	36	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
15503772	15503772	PRJNA1095825_P_NODE_285313_length_243_cov_0.905882_g282250_i0	PRJNA1095825	285313	243	0.905882	2.20129326	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	274	4.29e-69	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g282250	i0	86.939	7.81893004115226	245	30	100	2	1	243	8814558	8814802	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1900	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16321955	16321955	PRJNA1095825_P_NODE_242673_length_250_cov_0.870056_g239610_i0	PRJNA1095825	242673	250	0.870056	2.17514	Botrimarina	2795782	Bacteria	Bacteria	209	1.27e-49	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g239610	i0	81.855	1.984	248	45	99	0	3	250	972906	973153	Planctomycetes bacterium K2D chromosome, complete genome	blastn	496	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
20145907	20145907	PRJNA1095825_P_NODE_253736_length_248_cov_0.880000_g250673_i0	PRJNA1095825	253736	248	0.88	2.1824	Planctomycetia	203683	Bacteria	Bacteria	152	2.15e-32	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g250673	i0	85.333	25.2096774193548	150	18	60	4	101	248	3899640	3899787	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	6252	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
20601907	20601907	PRJNA1095825_P_NODE_252357_length_248_cov_1.582857_g249294_i0	PRJNA1095825	252357	248	1.582857	3.92548536	Tuwongella immobilis	692036	Bacteria	Bacteria	135	2.17e-27	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g249294	i0	87.288	4.18145161290323	118	15	48	0	130	247	246476	246593	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	1037	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
20602287	20602287	PRJNA1095825_P_NODE_290297_length_242_cov_0.911243_g287234_i0	PRJNA1095825	290297	242	0.911243	2.20520806	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	250	7.2e-62	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g287234	i0	85.477	7.37603305785124	241	33	99	2	1	240	4658605	4658366	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	1785	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
25245873	25245873	PRJNA1095825_P_NODE_255720_length_248_cov_0.880000_g252657_i0	PRJNA1095825	255720	248	0.88	2.1824	Gemmata	113	Bacteria	Bacteria	171	5.94e-38	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g252657	i0	81.429	6.02822580645161	210	37	84	2	3	211	5328607	5328815	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1495	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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