metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA688931" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA688931" 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
1178071	1178071	PRJNA688931_P_NODE_30501_length_183_cov_3.000000_g30288_i0	PRJNA688931	30501	183	3	5.49	Planctomycetia	203683	Bacteria	Bacteria	169	1.4799999999999998e-37	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g30288	i0	83.799	27.3879781420765	179	27	97	2	1	178	4955332	4955509	Planctomyces sp. SH-PL14, complete genome	blastn	5012	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
1944702	1944702	PRJNA688931_P_NODE_7562_length_393_cov_4.747093_g7349_i0	PRJNA688931	7562	393	4.747093	18.65607549	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	592	1.7899999999999993e-164	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g7349	i0	93.893	149.989821882952	393	23	100	1	1	393	2621069	2620678	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	58946	592	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
3729964	3729964	PRJNA688931_P_NODE_40343_length_164_cov_1.765217_g40130_i0	PRJNA688931	40343	164	1.765217	2.89495588	Gemmata	113	Bacteria	Bacteria	128	2.21e-25	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g40130	i0	81.437	19.3292682926829	167	21	100	9	1	164	1953	2112	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	3170	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
4496713	4496713	PRJNA688931_P_NODE_7504_length_395_cov_3.057803_g7291_i0	PRJNA688931	7504	395	3.057803	12.07832185	planctomycete str. 449	79870	Bacteria	Bacteria	457	6.86e-124	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g7291	i0	88.144	109.589873417722	388	40	97	6	3	387	1841	1457	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	43288	457	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
5772091	5772091	PRJNA688931_P_NODE_2725_length_692_cov_2.903577_g2545_i0	PRJNA688931	2725	692	2.903577	20.09275284	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	1260	0	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g2545	i0	99.566	283.184971098266	691	3	99	0	2	692	3097075	3097765	Pirellula sp. SH-Sr6A, complete genome	blastn	195964	1260	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
6282099	6282099	PRJNA688931_P_NODE_42505_length_163_cov_0.903509_g42292_i0	PRJNA688931	42505	163	0.903509	1.47271967	Engelhardtia	139931	Bacteria	Bacteria	154	3.62e-33	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g42292	i0	84.472	41.9877300613497	161	20	98	5	5	163	5249162	5249005	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	6844	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
7047181	7047181	PRJNA688931_P_NODE_3706_length_583_cov_3.486891_g3508_i0	PRJNA688931	3706	583	3.486891	20.32857453	Lignipirellula cremea	2528010	Bacteria	Bacteria	704	0	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g3508	i0	88.679	139.241852487136	583	59	99	6	1	580	1144278	1144856	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	81178	704	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
8321696	8321696	PRJNA688931_P_NODE_3627_length_591_cov_3.468635_g3430_i0	PRJNA688931	3627	591	3.468635	20.49963285	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	797	0	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g3430	i0	91.511	122.543147208122	589	35	99	8	1	589	3097030	3096457	Pirellula sp. SH-Sr6A, complete genome	blastn	72423	797	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
10872576	10872576	PRJNA688931_P_NODE_30569_length_183_cov_1.723881_g30356_i0	PRJNA688931	30569	183	1.723881	3.15470223	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	337	3.84e-88	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g30356	i0	100	71.2513661202186	182	0	99	0	1	182	3096673	3096492	Pirellula sp. SH-Sr6A, complete genome	blastn	13039	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
10872597	10872597	PRJNA688931_P_NODE_33989_length_172_cov_1.682927_g33776_i0	PRJNA688931	33989	172	1.682927	2.89463444	Limnoglobus roseus	2598579	Bacteria	Bacteria	228	2.2299999999999997e-55	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g33776	i0	90.643	322.761627906977	171	16	99	0	1	171	2956406	2956576	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	55515	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
12147749	12147749	PRJNA688931_P_NODE_18970_length_235_cov_1.865591_g18757_i0	PRJNA688931	18970	235	1.865591	4.38413885	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	385	1.83e-102	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g18757	i0	96.186	130.71914893617	236	8	100	1	1	235	4317606	4317371	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	30719	385	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
12147831	12147831	PRJNA688931_P_NODE_29250_length_188_cov_1.122302_g29037_i0	PRJNA688931	29250	188	1.122302	2.10992776	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	226	8.969999999999998e-55	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g29037	i0	88.298	81.6595744680851	188	22	100	0	1	188	7630888	7631075	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	15352	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
13422392	13422392	PRJNA688931_P_NODE_26291_length_199_cov_1.366667_g26078_i0	PRJNA688931	26291	199	1.366667	2.71966733	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	315	1.99e-81	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g26078	i0	95.455	110.21608040201	198	8	99	1	1	197	2002461	2002658	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	21933	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13422399	13422399	PRJNA688931_P_NODE_27771_length_193_cov_1.444444_g27558_i0	PRJNA688931	27771	193	1.444444	2.78777692	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	283	5.42e-72	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g27558	i0	93.229	159.948186528497	192	13	99	0	1	192	3454353	3454544	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	30870	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
15206725	15206725	PRJNA688931_P_NODE_5032_length_495_cov_2.354260_g4820_i0	PRJNA688931	5032	495	2.35426	11.653587	Pirellula	123	Bacteria	Bacteria	525	2.369999999999999e-144	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g4820	i0	85.855	155.272727272727	509	55	100	12	1	495	213	718	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	76860	525	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
15971114	15971114	PRJNA688931_P_NODE_14293_length_274_cov_0.888889_g14080_i0	PRJNA688931	14293	274	0.888889	2.43555586	Urbifossiella limnaea	2528023	Bacteria	Bacteria	374	4.7299999999999984e-99	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g14080	i0	91.241	161.164233576642	274	24	100	0	1	274	2019071	2019344	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	44159	374	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
16480885	16480885	PRJNA688931_P_NODE_1493_length_922_cov_6.057274_g1354_i0	PRJNA688931	1493	922	6.057274	55.84806628	PVC group	1783257	Bacteria	Bacteria	1615	0	NTclustered	gi\|339646435\|gb\|JN038824.1\|	120965	g1354	i0	98.265	97.7396963123644	922	16	100	0	1	922	937	16	Uncultured planctomycete clone P-R37 16S ribosomal RNA gene, partial sequence	blastn	90116	1615	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
17755937	17755937	PRJNA688931_P_NODE_26874_length_197_cov_1.108108_g26661_i0	PRJNA688931	26874	197	1.108108	2.18297276	Phycisphaerae	666505	Bacteria	Bacteria	204	4.449999999999999e-48	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g26661	i0	88.068	78.8274111675127	176	15	88	5	15	188	1831374	1831545	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	15529	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
18520600	18520600	PRJNA688931_P_NODE_33235_length_174_cov_3.472000_g33022_i0	PRJNA688931	33235	174	3.472	6.04128	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	298	1.7e-76	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g33022	i0	97.688	102.82183908046	173	4	99	0	1	173	3096477	3096305	Pirellula sp. SH-Sr6A, complete genome	blastn	17891	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
19029718	19029718	PRJNA688931_P_NODE_12655_length_293_cov_0.991803_g12442_i0	PRJNA688931	12655	293	0.991803	2.90598279	Gemmata	113	Bacteria	Bacteria	361	3.97e-95	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g12442	i0	97.619	105.931740614334	210	5	72	0	1	210	3635057	3634848	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	31038	361	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
21070852	21070852	PRJNA688931_P_NODE_17757_length_243_cov_3.484536_g17544_i0	PRJNA688931	17757	243	3.484536	8.46742248	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	377	3.18e-100	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g17544	i0	95	120.827160493827	240	12	99	0	4	243	7628794	7628555	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	29361	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
22855402	22855402	PRJNA688931_P_NODE_12478_length_295_cov_1.365854_g12265_i0	PRJNA688931	12478	295	1.365854	4.0292693	Urbifossiella	2807415	Bacteria	Bacteria	398	3.0499999999999995e-106	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g12265	i0	91.126	145.874576271186	293	26	99	0	1	293	7052640	7052348	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	43033	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23621264	23621264	PRJNA688931_P_NODE_10319_length_328_cov_5.397849_g10106_i0	PRJNA688931	10319	328	5.397849	17.70494472	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	540	5.3999999999999985e-149	NTclustered	gi\|339646435\|gb\|JN038824.1\|	120965	g10106	i0	98.371	95.3170731707317	307	5	94	0	1	307	1180	1486	Uncultured planctomycete clone P-R37 16S ribosomal RNA gene, partial sequence	blastn	31264	540	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
23621268	23621268	PRJNA688931_P_NODE_11339_length_312_cov_1.600760_g11126_i0	PRJNA688931	11339	312	1.60076	4.9943712	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	390	5.439999999999999e-104	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g11126	i0	89.206	195.266025641026	315	31	100	2	1	312	2002890	2002576	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	60923	390	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23621293	23621293	PRJNA688931_P_NODE_14499_length_271_cov_2.306306_g14286_i0	PRJNA688931	14499	271	2.306306	6.25008926	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g14286	i0	100	233.933579335793	271	0	100	0	1	271	3094886	3095156	Pirellula sp. SH-Sr6A, complete genome	blastn	63396	501	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
25404593	25404593	PRJNA688931_P_NODE_43180_length_162_cov_0.920354_g42967_i0	PRJNA688931	43180	162	0.920354	1.49097348	Gimesia	1649453	Bacteria	Bacteria	178	2.13e-40	NTclustered	gi\|1712569666\|gb\|CP037422.1\|	2527964	g42967	i0	86.792	72.5246913580247	159	21	98	0	1	159	3955050	3955208	Gimesia aquarii strain V202 chromosome	blastn	11749	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia aquarii

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