metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA546018" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA546018" 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
510733	510733	PRJNA546018_S_NODE_18501_length_379_cov_2.037736_g18176_i0	PRJNA546018	18501	379	2.037736	7.72301944	Humisphaera borealis	2807512	Bacteria	Bacteria	289	2.5299999999999996e-73	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g18176	i0	86.194	7.34828496042216	268	35	70	2	29	295	2679061	2679327	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	2785	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
511374	511374	PRJNA546018_S_NODE_60821_length_181_cov_4.683333_g60496_i0	PRJNA546018	60821	181	4.683333	8.47683273	Gemmataceae bacterium	2052164	Bacteria	Bacteria	60.2	9.19e-5	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g60496	i0	92.857	2.33149171270718	42	1	23	1	63	104	4381411	4381372	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	422	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
1119202	1119202	PRJNA546018_S_NODE_5321_length_791_cov_10.461644_g5066_i0	PRJNA546018	5321	791	10.461644	82.75160404	Gemmata	113	Bacteria	Bacteria	1290	0	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g5066	i0	96.883	291.465233881163	770	24	97	0	22	791	2941802	2942571	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	230549	1290	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
3062297	3062297	PRJNA546018_S_NODE_61103_length_175_cov_4.675439_g60778_i0	PRJNA546018	61103	175	4.675439	8.18201825	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	183	5.0099999999999996e-42	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g60778	i0	88.742	7.32	151	15	86	1	1	151	4469502	4469650	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	1281	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
4337637	4337637	PRJNA546018_S_NODE_13804_length_451_cov_1.384615_g13480_i0	PRJNA546018	13804	451	1.384615	6.24461365	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	420	1.0399999999999995e-112	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g13480	i0	85.266	3.13747228381375	414	53	91	8	11	419	10012737	10013147	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1415	420	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4947261	4947261	PRJNA546018_S_NODE_12824_length_471_cov_7.609756_g12500_i0	PRJNA546018	12824	471	7.609756	35.84195076	Gemmata	113	Bacteria	Bacteria	475	2.2899999999999993e-129	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g12500	i0	86.775	5.49469214437367	431	51	91	6	23	450	1957416	1956989	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	2588	475	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
6222828	6222828	PRJNA546018_S_NODE_26785_length_306_cov_6.473469_g26460_i0	PRJNA546018	26785	306	6.473469	19.80881514	Gemmata	113	Bacteria	Bacteria	281	3.34e-71	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g26460	i0	86.381	5.09477124183007	257	35	84	0	28	284	8660559	8660303	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1559	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
6222966	6222966	PRJNA546018_S_NODE_51765_length_210_cov_3.697987_g51440_i0	PRJNA546018	51765	210	3.697987	7.7657727	Gemmata	113	Bacteria	Bacteria	357	3.49e-94	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g51440	i0	99.49	109.790476190476	196	1	93	0	15	210	1038230	1038035	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	23056	357	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
8163735	8163735	PRJNA546018_S_NODE_29847_length_288_cov_1.039648_g29522_i0	PRJNA546018	29847	288	1.039648	2.99418624	Gemmataceae bacterium	2052164	Bacteria	Bacteria	313	1.11e-80	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g29522	i0	88.716	19.2916666666667	257	27	89	2	1	256	1640624	1640879	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	5556	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
8772270	8772270	PRJNA546018_S_NODE_45647_length_226_cov_1.739394_g45322_i0	PRJNA546018	45647	226	1.739394	3.93103044	Gemmata	113	Bacteria	Bacteria	222	1.45e-53	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g45322	i0	86.275	3.63716814159292	204	28	90	0	21	224	8661563	8661766	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	822	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
10047545	10047545	PRJNA546018_S_NODE_15388_length_422_cov_4.346260_g15063_i0	PRJNA546018	15388	422	4.34626	18.3412172	Gemmata	113	Bacteria	Bacteria	183	1.38e-41	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g15063	i0	89.474	2.53080568720379	152	7	35	7	255	400	2199138	2198990	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1068	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
10714895	10714895	PRJNA546018_S_NODE_20669_length_355_cov_2.482993_g20344_i0	PRJNA546018	20669	355	2.482993	8.81462515	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	250	1.11e-61	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g20344	i0	80.723	1.85070422535211	332	54	91	6	13	336	1819014	1819343	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	657	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
10715350	10715350	PRJNA546018_S_NODE_49929_length_214_cov_4.320261_g49604_i0	PRJNA546018	49929	214	4.320261	9.24535854	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	303	4.71e-78	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g49604	i0	94.845	38.107476635514	194	10	91	0	1	194	2003748	2003555	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	8155	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10715601	10715601	PRJNA546018_S_NODE_9749_length_555_cov_4.641700_g9429_i0	PRJNA546018	9749	555	4.6417	25.761435	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	614	5.559999999999998e-171	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g9429	i0	91.991	63.9801801801802	437	35	79	0	94	530	2259487	2259923	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	35509	614	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
12598219	12598219	PRJNA546018_S_NODE_32970_length_271_cov_5.057143_g32645_i0	PRJNA546018	32970	271	5.057143	13.70485753	Gemmata	113	Bacteria	Bacteria	416	7.649999999999999e-112	NTclustered	gi\|307591264\|gb\|GQ889461.1\|	886803	g32645	i0	95.753	107.350553505535	259	9	95	2	1	258	703	960	Gemmata sp. Ha1-1 16S ribosomal RNA gene, partial sequence	blastn	29092	416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. Ha1-1
13265117	13265117	PRJNA546018_S_NODE_51751_length_210_cov_4.416107_g51426_i0	PRJNA546018	51751	210	4.416107	9.2738247	Humisphaera borealis	2807512	Bacteria	Bacteria	152	1.77e-32	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g51426	i0	84.768	9.42380952380952	151	23	72	0	24	174	5062833	5062683	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	1979	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13873022	13873022	PRJNA546018_S_NODE_21991_length_343_cov_1.382979_g21666_i0	PRJNA546018	21991	343	1.382979	4.74361797	Gemmata	113	Bacteria	Bacteria	335	2.879999999999999e-87	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g21666	i0	85.938	4.65889212827988	320	37	92	8	23	339	906647	906961	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1598	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
13873255	13873255	PRJNA546018_S_NODE_6651_length_696_cov_12.042520_g6368_i0	PRJNA546018	6651	696	12.04252	83.8159392	Gemmata	113	Bacteria	Bacteria	745	0	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g6368	i0	88.707	24.5847701149425	611	67	88	2	15	624	2291596	2292205	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	17111	745	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
15813554	15813554	PRJNA546018_S_NODE_22333_length_340_cov_1.630824_g22008_i0	PRJNA546018	22333	340	1.630824	5.5448016	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	462	1.25e-125	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g22008	i0	91.617	7.83235294117647	334	28	98	0	7	340	2473421	2473754	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2663	462	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16422017	16422017	PRJNA546018_S_NODE_37513_length_253_cov_0.947917_g37188_i0	PRJNA546018	37513	253	0.947917	2.39823001	Gemmata	113	Bacteria	Bacteria	207	4.63e-49	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g37188	i0	83.262	12.7272727272727	233	31	91	6	18	246	5762615	5762387	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	3220	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
18363040	18363040	PRJNA546018_S_NODE_9255_length_572_cov_5.232877_g8939_i0	PRJNA546018	9255	572	5.232877	29.93205644	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	545	2.12e-150	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g8939	i0	85.178	2.51573426573427	533	77	93	2	23	554	1232927	1232396	Planctomyces sp. SH-PL62, complete genome	blastn	1439	545	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19637440	19637440	PRJNA546018_S_NODE_51136_length_211_cov_3.426667_g50811_i0	PRJNA546018	51136	211	3.426667	7.23026737	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	82.4	2.36e-11	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g50811	i0	89.231	1.24170616113744	65	7	31	0	73	137	5986285	5986221	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	262	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
20245554	20245554	PRJNA546018_S_NODE_12916_length_469_cov_6.627451_g12592_i0	PRJNA546018	12916	469	6.627451	31.08274519	Gemmata	113	Bacteria	Bacteria	571	2.8299999999999995e-158	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g12592	i0	90.389	8.80383795309169	437	39	93	3	22	456	1107887	1107452	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	4129	571	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
20912786	20912786	PRJNA546018_S_NODE_18837_length_375_cov_2.538217_g18512_i0	PRJNA546018	18837	375	2.538217	9.51831375	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	459	1.8e-124	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g18512	i0	92.025	0.869333333333333	326	26	87	0	22	347	1623519	1623844	Lacipirellula limnantheis strain I41 chromosome	blastn	326	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
21521127	21521127	PRJNA546018_S_NODE_11697_length_498_cov_6.109840_g11373_i0	PRJNA546018	11697	498	6.10984	30.4270032	Gemmata	113	Bacteria	Bacteria	399	1.5099999999999995e-106	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g11373	i0	85.64	5.22289156626506	383	52	77	3	23	403	6719498	6719879	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	2601	399	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
21521137	21521137	PRJNA546018_S_NODE_12497_length_479_cov_2.514354_g12173_i0	PRJNA546018	12497	479	2.514354	12.04375566	Gemmata	113	Bacteria	Bacteria	409	2.4e-109	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g12173	i0	83.827	8.46972860125261	439	61	91	8	25	458	7661704	7662137	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	4057	409	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
22187866	22187866	PRJNA546018_S_NODE_38318_length_249_cov_3.755319_g37993_i0	PRJNA546018	38318	249	3.755319	9.35074431	Rohdeia mirabilis	2528008	Bacteria	Bacteria	104	6.13e-18	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g37993	i0	94.118	0.429718875502008	68	4	27	0	182	249	2920875	2920942	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	107	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
24071330	24071330	PRJNA546018_S_NODE_8619_length_599_cov_1.414498_g8305_i0	PRJNA546018	8619	599	1.414498	8.47284302	Gemmata	113	Bacteria	Bacteria	676	0	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g8305	i0	87.958	4.98163606010017	573	69	96	0	22	594	1803298	1803870	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	2984	676	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
24737099	24737099	PRJNA546018_S_NODE_42040_length_237_cov_1.556818_g41715_i0	PRJNA546018	42040	237	1.556818	3.68965866	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	204	5.549999999999999e-48	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g41715	i0	83.721	0.907172995780591	215	35	91	0	20	234	3458622	3458836	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	215	204	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);;