metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA888821" 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
862893	862893	PRJNA888821_P_NODE_34161_length_253_cov_1.283333_g34078_i0	PRJNA888821	34161	253	1.283333	3.24683249	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	424	4.22e-114	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g34078	i0	96.838	55.2134387351779	253	8	100	0	1	253	7630341	7630089	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	13969	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
1242093	1242093	PRJNA888821_P_NODE_541_length_680_cov_40.324547_g476_i0	PRJNA888821	541	680	40.324547	274.2069196	Bacteria	2	Bacteria	Bacteria	833	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g476	i0	88.857	201.616176470588	691	59	100	17	1	680	2001631	2002314	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	137099	833	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2138512	2138512	PRJNA888821_P_NODE_43922_length_225_cov_8.092105_g43839_i0	PRJNA888821	43922	225	8.092105	18.20723625	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	154	5.33e-33	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g43839	i0	81.818	16.4488888888889	187	30	82	4	41	225	7452066	7451882	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	3701	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
3413581	3413581	PRJNA888821_P_NODE_29663_length_271_cov_7.944444_g29580_i0	PRJNA888821	29663	271	7.944444	21.52944324	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	60.2	1.49e-4	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g29580	i0	94.737	1.17343173431734	38	2	14	0	171	208	3058155	3058192	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	318	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
3413592	3413592	PRJNA888821_P_NODE_30363_length_268_cov_6.912821_g30280_i0	PRJNA888821	30363	268	6.912821	18.52636028	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	337	6.05e-88	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g30280	i0	89.299	243.421641791045	271	26	100	3	1	268	7052491	7052221	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	65237	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3413969	3413969	PRJNA888821_P_NODE_52243_length_199_cov_15.103175_g52160_i0	PRJNA888821	52243	199	15.103175	30.05531825	Aureliella helgolandensis	2527968	Bacteria	Bacteria	204	4.51e-48	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g52160	i0	85.427	189.075376884422	199	25	99	3	3	199	6999081	6998885	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	37626	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
3794018	3794018	PRJNA888821_P_NODE_6483_length_311_cov_7.323529_g6401_i0	PRJNA888821	6483	311	7.323529	22.77617519	Planctomycetia	203683	Bacteria	Bacteria	147	1.3e-30	NTclustered	gi\|1238331385\|gb\|CP018477.1\|	1331910	g6401	i0	86.567	57.8617363344051	134	17	43	1	5	137	3642071	3641938	Thermogutta terrifontis strain R1 chromosome, complete genome	blastn	17995	148	0.993243243243243	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae	Thermogutta	Thermogutta terrifontis
4691474	4691474	PRJNA888821_P_NODE_44744_length_222_cov_7.926174_g44661_i0	PRJNA888821	44744	222	7.926174	17.59610628	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	252	1.8099999999999999e-62	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g44661	i0	87.33	120.288288288288	221	26	99	2	4	222	7050491	7050271	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	26704	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4691612	4691612	PRJNA888821_P_NODE_52924_length_198_cov_4.520000_g52841_i0	PRJNA888821	52924	198	4.52	8.9496	Gemmataceae bacterium	2052164	Bacteria	Bacteria	97.1	7.82e-16	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g52841	i0	78.571	134.257575757576	154	27	77	6	5	157	320357	320209	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	26583	97.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
5965808	5965808	PRJNA888821_P_NODE_13465_length_310_cov_7.725738_g13383_i0	PRJNA888821	13465	310	7.725738	23.9497878	Schlesneria sphaerica	3373610	Bacteria	Bacteria	167	9.909999999999998e-37	NTclustered	gi\|2844279856\|gb\|CP172346.1\|	3373610	g13383	i0	87.248	30.0161290322581	149	15	95	3	164	310	369026	369172	Schlesneria sp. T3-172 chromosome, complete genome	blastn	9305	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sphaerica
6346075	6346075	PRJNA888821_P_NODE_51485_length_201_cov_14.992188_g51402_i0	PRJNA888821	51485	201	14.992188	30.13429788	Schlesneria	656899	Bacteria	Bacteria	189	1.28e-43	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g51402	i0	84.236	48.9253731343284	203	22	100	5	1	201	194	388	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	9834	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
7240976	7240976	PRJNA888821_P_NODE_33206_length_256_cov_12.612022_g33123_i0	PRJNA888821	33206	256	12.612022	32.28677632	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	180	1.02e-40	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g33123	i0	85.799	0.66015625	169	24	66	0	4	172	3825004	3825172	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	169	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
7241131	7241131	PRJNA888821_P_NODE_4246_length_350_cov_12.729242_g4165_i0	PRJNA888821	4246	350	12.729242	44.552347	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	226	1.8399999999999998e-54	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g4165	i0	92.5	141.185714285714	160	9	45	3	193	350	4958937	4959095	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	49415	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
8515840	8515840	PRJNA888821_P_NODE_37767_length_244_cov_7.853801_g37684_i0	PRJNA888821	37767	244	7.853801	19.16327444	Humisphaera borealis	2807512	Bacteria	Bacteria	233	7.319999999999999e-57	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g37684	i0	84.082	508.184426229508	245	36	99	3	2	244	5062935	5062692	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	123997	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
8516018	8516018	PRJNA888821_P_NODE_48547_length_210_cov_4.992701_g48464_i0	PRJNA888821	48547	210	4.992701	10.4846721	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	239	1.32e-58	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g48464	i0	87.264	122.014285714286	212	24	99	2	1	209	7050481	7050692	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	25623	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8894716	8894716	PRJNA888821_P_NODE_32967_length_257_cov_10.603261_g32884_i0	PRJNA888821	32967	257	10.603261	27.25038077	Pirellulaceae	2691357	Bacteria	Bacteria	359	1.23e-94	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g32884	i0	91.892	52.1984435797665	259	18	100	2	1	257	3096996	3096739	Pirellula sp. SH-Sr6A, complete genome	blastn	13415	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
9790570	9790570	PRJNA888821_P_NODE_17408_length_310_cov_4.852321_g17326_i0	PRJNA888821	17408	310	4.852321	15.0421951	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	145	4.6399999999999994e-30	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g17326	i0	77.88	6.10645161290323	217	39	67	4	102	310	1575018	1574803	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1893	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
9790579	9790579	PRJNA888821_P_NODE_17788_length_310_cov_4.582278_g17706_i0	PRJNA888821	17788	310	4.582278	14.2050618	Gemmataceae bacterium	2052164	Bacteria	Bacteria	204	7.559999999999999e-48	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g17706	i0	79.167	4.7	312	47	99	10	3	310	1806175	1805878	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	1457	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
16165476	16165476	PRJNA888821_P_NODE_25953_length_288_cov_8.181395_g25871_i0	PRJNA888821	25953	288	8.181395	23.5624176	Saltatorellus ferox	2528018	Bacteria	Bacteria	102	2.61e-17	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g25871	i0	92.857	31.78125	70	5	24	0	219	288	7162911	7162842	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	9153	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
16165939	16165939	PRJNA888821_P_NODE_533_length_682_cov_31.811166_g468_i0	PRJNA888821	533	682	31.811166	216.95215212	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	1022	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g468	i0	93.723	197.83724340176	685	38	99	5	2	682	2003057	2002374	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	134925	1022	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17441004	17441004	PRJNA888821_P_NODE_31154_length_265_cov_3.041667_g31071_i0	PRJNA888821	31154	265	3.041667	8.06041755	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	226	1.3499999999999998e-54	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g31071	i0	84.188	257.22641509434	234	36	88	1	5	237	4345282	4345515	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	68165	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
18714343	18714343	PRJNA888821_P_NODE_40195_length_238_cov_6.430303_g40112_i0	PRJNA888821	40195	238	6.430303	15.30412114	Gemmataceae bacterium	2052164	Bacteria	Bacteria	261	3.26e-65	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g40112	i0	88.732	24.546218487395	213	24	89	0	24	236	1231455	1231667	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	5842	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
18714476	18714476	PRJNA888821_P_NODE_47235_length_214_cov_5.170213_g47152_i0	PRJNA888821	47235	214	5.170213	11.06425582	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	252	1.73e-62	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g47152	i0	87.907	5.96728971962617	215	24	100	2	1	214	7578265	7578052	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1277	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
21644096	21644096	PRJNA888821_P_NODE_40097_length_238_cov_11.624242_g40014_i0	PRJNA888821	40097	238	11.624242	27.66569596	Planctomycetaceae	126	Bacteria	Bacteria	261	3.26e-65	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g40014	i0	90.769	107.084033613445	195	18	82	0	44	238	1410	1216	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	25486	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
22539546	22539546	PRJNA888821_P_NODE_2658_length_406_cov_15.168168_g2579_i0	PRJNA888821	2658	406	15.168168	61.58276208	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	507	6.92e-139	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2579	i0	92.244	124.527093596059	361	22	100	6	51	406	2003082	2003441	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	50558	507	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23814931	23814931	PRJNA888821_P_NODE_25859_length_288_cov_21.897674_g25777_i0	PRJNA888821	25859	288	21.897674	63.06530112	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	322	1.84e-83	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g25777	i0	95.098	112.086805555556	204	10	71	0	1	204	4961391	4961594	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	32281	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
23815206	23815206	PRJNA888821_P_NODE_42139_length_231_cov_7.424051_g42056_i0	PRJNA888821	42139	231	7.424051	17.14955781	Humisphaera borealis	2807512	Bacteria	Bacteria	315	2.38e-81	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g42056	i0	91.379	108.060606060606	232	17	99	3	3	231	5064572	5064341	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	24962	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
25088622	25088622	PRJNA888821_P_NODE_14260_length_310_cov_7.105485_g14178_i0	PRJNA888821	14260	310	7.105485	22.0270035	Humisphaera borealis	2807512	Bacteria	Bacteria	174	5.92e-39	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g14178	i0	91.935	74.1516129032258	124	10	88	0	161	284	5063168	5063045	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	22987	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis

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