metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA929922" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA929922" 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
906853	906853	PRJNA929922_P_NODE_31441_length_370_cov_1.555556_g30901_i0	PRJNA929922	31441	370	1.555556	5.7555572	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	599	9.999999999999997e-167	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g30901	i0	96.927	479.8	358	9	97	2	1	358	558389	558744	Gemmata sp. SH-PL17, complete genome	blastn	177526	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
2181306	2181306	PRJNA929922_P_NODE_128622_length_247_cov_0.885057_g128082_i0	PRJNA929922	128622	247	0.885057	2.18609079	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	100	7.86e-17	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g128082	i0	89.744	3.48582995951417	78	8	32	0	137	214	4468573	4468650	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	861	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
3456394	3456394	PRJNA929922_P_NODE_107723_length_251_cov_0.865169_g107183_i0	PRJNA929922	107723	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.2	1.36e-4	NTclustered	gi\|2107958177\|gb\|CP070790.1\|	2026780	g107183	i0	100	0.127490039840637	32	0	13	0	83	114	467355	467324	MAG: Planctomycetota bacterium isolate bin1449 chromosome	blastn	32	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
4734756	4734756	PRJNA929922_P_NODE_146124_length_244_cov_0.900585_g145584_i0	PRJNA929922	146124	244	0.900585	2.1974274	Limnoglobus roseus	2598579	Bacteria	Bacteria	294	3.31e-75	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g145584	i0	88.525	9.17622950819672	244	26	99	2	2	244	410627	410869	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	2239	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
6009921	6009921	PRJNA929922_P_NODE_164865_length_241_cov_0.886905_g164325_i0	PRJNA929922	164865	241	0.886905	2.13744105	Singulisphaera acidiphila	466153	Bacteria	Bacteria	230	9.34e-56	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g164325	i0	85.52	2.62655601659751	221	30	91	2	22	241	3565600	3565381	Singulisphaera acidiphila DSM 18658, complete genome	blastn	633	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
7284150	7284150	PRJNA929922_P_NODE_135046_length_246_cov_0.890173_g134506_i0	PRJNA929922	135046	246	0.890173	2.18982558	Pirellula staleyi	125	Bacteria	Bacteria	259	1.22e-64	NTclustered	gi\|283436255\|gb\|CP001848.1\|	530564	g134506	i0	85.714	65.0528455284553	245	35	99	0	2	246	3665547	3665791	Pirellula staleyi DSM 6068 chromosome, complete genome	blastn	16003	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
7284169	7284169	PRJNA929922_P_NODE_135886_length_246_cov_0.890173_g135346_i0	PRJNA929922	135886	246	0.890173	2.18982558	Urbifossiella limnaea	2528023	Bacteria	Bacteria	278	3.37e-70	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g135346	i0	86.992	83.5691056910569	246	32	100	0	1	246	3156856	3157101	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	20558	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
8559340	8559340	PRJNA929922_P_NODE_152487_length_243_cov_0.905882_g151947_i0	PRJNA929922	152487	243	0.905882	2.20129326	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	320	5.44e-83	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g151947	i0	90.496	42.8312757201646	242	23	99	0	1	242	2847075	2847316	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	10408	320	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
9834470	9834470	PRJNA929922_P_NODE_155988_length_242_cov_0.911243_g155448_i0	PRJNA929922	155988	242	0.911243	2.20520806	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	206	1.58e-48	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g155448	i0	86.631	59.5123966942149	187	24	77	1	56	242	9399982	9399797	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	14402	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
11109097	11109097	PRJNA929922_P_NODE_107549_length_251_cov_0.865169_g107009_i0	PRJNA929922	107549	251	0.865169	2.17157419	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	196	9.93e-46	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g107009	i0	81.78	2.34661354581673	236	41	94	2	1	235	7889062	7889296	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	589	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13659502	13659502	PRJNA929922_P_NODE_123791_length_248_cov_0.880000_g123251_i0	PRJNA929922	123791	248	0.88	2.1824	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	182	2.74e-41	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g123251	i0	84.916	55	179	27	72	0	16	194	6458414	6458236	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	13640	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
13660027	13660027	PRJNA929922_P_NODE_150211_length_243_cov_0.905882_g149671_i0	PRJNA929922	150211	243	0.905882	2.20129326	Urbifossiella limnaea	2528023	Bacteria	Bacteria	224	4.3899999999999996e-54	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g149671	i0	85.714	2.8641975308642	217	25	89	5	20	236	1345922	1345712	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	696	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
13660240	13660240	PRJNA929922_P_NODE_159431_length_242_cov_0.869822_g158891_i0	PRJNA929922	159431	242	0.869822	2.10496924	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	259	1.2e-64	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g158891	i0	86.192	1.88842975206612	239	33	99	0	2	240	5210596	5210358	Tautonia plasticadhaerens strain ElP chromosome	blastn	457	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
14934645	14934645	PRJNA929922_P_NODE_164912_length_241_cov_0.880952_g164372_i0	PRJNA929922	164912	241	0.880952	2.12309432	Aquisphaera giovannonii	406548	Bacteria	Bacteria	128	3.4999999999999997e-25	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g164372	i0	81.481	0.672199170124481	162	24	66	6	8	166	9041557	9041399	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	162	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
16208550	16208550	PRJNA929922_P_NODE_111973_length_250_cov_0.870056_g111433_i0	PRJNA929922	111973	250	0.870056	2.17514	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	195	3.55e-45	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g111433	i0	83.412	1.308	211	33	84	2	34	243	8449509	8449300	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	327	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20032801	20032801	PRJNA929922_P_NODE_139136_length_245_cov_0.895349_g138596_i0	PRJNA929922	139136	245	0.895349	2.19360505	Aeoliella mucimassa	2527972	Bacteria	Bacteria	159	1.27e-34	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g138596	i0	80.976	73.2244897959184	205	35	83	3	14	216	6173091	6172889	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	17940	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
22583579	22583579	PRJNA929922_P_NODE_156058_length_242_cov_0.911243_g155518_i0	PRJNA929922	156058	242	0.911243	2.20520806	Urbifossiella limnaea	2528023	Bacteria	Bacteria	244	3.3499999999999997e-60	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g155518	i0	87.619	1.49173553719008	210	26	87	0	33	242	7716437	7716646	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	361	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
23858851	23858851	PRJNA929922_P_NODE_153899_length_243_cov_0.870588_g153359_i0	PRJNA929922	153899	243	0.870588	2.11552884	Bremerella sp. P1	3026424	Bacteria	Bacteria	128	3.54e-25	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g153359	i0	88.571	2.7283950617284	105	12	43	0	21	125	4838600	4838496	Bremerella sp. P1 chromosome, complete genome	blastn	663	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
23858948	23858948	PRJNA929922_P_NODE_158839_length_242_cov_0.911243_g158299_i0	PRJNA929922	158839	242	0.911243	2.20520806	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	326	1.16e-84	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g158299	i0	90.947	1.00413223140496	243	20	100	2	1	242	5072559	5072800	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	243	326	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08

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