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

28 rows where analysis = "blastn", bioproject = "PRJEB30004" 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
27990	27990	PRJEB30004_P_NODE_125581_length_532_cov_2.137931_g110166_i0	PRJEB30004	125581	532	2.137931	11.37379292	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	660	0	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g110166	i0	89.484	115.795112781955	523	53	98	2	1	522	5362485	5363006	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	61603	660	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
35823	35823	PRJEB30004_P_NODE_298961_length_282_cov_2.543210_g283334_i0	PRJEB30004	298961	282	2.54321	7.1718522	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	403	6.23e-108	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g283334	i0	93.116	173.804964539007	276	17	98	2	1	275	5364507	5364781	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	49013	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
1323881	1323881	PRJEB30004_P_NODE_585862_length_170_cov_1.251908_g570235_i0	PRJEB30004	585862	170	1.251908	2.1282436	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	270	3.61e-68	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g570235	i0	95.349	10.0352941176471	172	4	100	3	1	170	1868485	1868316	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1706	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
2581403	2581403	PRJEB30004_P_NODE_204803_length_372_cov_1.942943_g189178_i0	PRJEB30004	204803	372	1.942943	7.22774796	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	553	7.959999999999998e-153	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g189178	i0	93.369	85.1801075268817	377	20	100	5	1	372	2003148	2002772	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	31687	553	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2593263	2593263	PRJEB30004_P_NODE_456343_length_205_cov_1.951807_g440716_i0	PRJEB30004	456343	205	1.951807	4.00120435	Urbifossiella limnaea	2528023	Bacteria	Bacteria	337	4.41e-88	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g440716	i0	96.569	41.5951219512195	204	5	100	1	4	205	2018881	2018678	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	8527	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
5141685	5141685	PRJEB30004_P_NODE_371605_length_240_cov_1.835821_g355978_i0	PRJEB30004	371605	240	1.835821	4.4059704	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	370	5.249999999999999e-98	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g355978	i0	94.561	15.9666666666667	239	13	99	0	1	239	1866752	1866990	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	3832	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
5149192	5149192	PRJEB30004_P_NODE_528125_length_184_cov_1.124138_g512498_i0	PRJEB30004	528125	184	1.124138	2.06841392	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	198	1.9e-46	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g512498	i0	86.264	125.961956521739	182	25	99	0	1	182	7052566	7052385	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	23177	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6428427	6428427	PRJEB30004_P_NODE_598826_length_167_cov_1.367188_g583199_i0	PRJEB30004	598826	167	1.367188	2.28320396	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g583199	i0	98.204	49.6467065868263	167	3	100	0	1	167	1155272	1155438	Planctomyces sp. SH-PL62, complete genome	blastn	8291	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
7699124	7699124	PRJEB30004_P_NODE_529367_length_183_cov_2.027778_g513740_i0	PRJEB30004	529367	183	2.027778	3.71083374	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	176	8.86e-40	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g513740	i0	84.53	55.4207650273224	181	25	98	3	2	181	2711125	2710947	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	10142	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
9916931	9916931	PRJEB30004_P_NODE_669268_length_153_cov_2.421053_g653641_i0	PRJEB30004	669268	153	2.421053	3.70421109	Planctomycetia	203683	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|914848\|emb\|X81957.1\|	114	g653641	i0	100	114	153	0	100	0	1	153	333	181	G.obscuriglobus partial 16S rRNA gene (Schlesner 633)	blastn	17442	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
10238941	10238941	PRJEB30004_P_NODE_306629_length_277_cov_2.067227_g291002_i0	PRJEB30004	306629	277	2.067227	5.72621879	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	462	9.929999999999999e-126	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g291002	i0	96.751	45.0938628158845	277	9	100	0	1	277	559842	560118	Gemmata sp. SH-PL17, complete genome	blastn	12491	462	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
10255271	10255271	PRJEB30004_P_NODE_646749_length_157_cov_3.440678_g631122_i0	PRJEB30004	646749	157	3.440678	5.40186446	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	287	3.26e-73	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g631122	i0	100	312.452229299363	155	0	99	0	3	157	4961328	4961174	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	49055	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
12791378	12791378	PRJEB30004_P_NODE_341951_length_255_cov_9.175926_g326324_i0	PRJEB30004	341951	255	9.175926	23.3986113	Rohdeia mirabilis	2528008	Bacteria	Bacteria	222	1.67e-53	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g326324	i0	82.869	377.611764705882	251	39	98	4	1	249	3892674	3892426	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	96291	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
12798345	12798345	PRJEB30004_P_NODE_487031_length_195_cov_2.102564_g471404_i0	PRJEB30004	487031	195	2.102564	4.0999998	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	355	1.15e-93	NTclustered	gi\|443301411\|emb\|HE613588.1\|	120965	g471404	i0	99.487	99.774358974359	195	1	100	0	1	195	671	477	Uncultured planctomycete partial 16S rRNA gene, clone H100B0W9	blastn	19456	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
14078967	14078967	PRJEB30004_P_NODE_608472_length_165_cov_1.357143_g592845_i0	PRJEB30004	608472	165	1.357143	2.23928595	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	278	2.09e-70	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g592845	i0	96.97	309.321212121212	165	5	100	0	1	165	1157505	1157669	Planctomyces sp. SH-PL62, complete genome	blastn	51038	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
15334636	15334636	PRJEB30004_P_NODE_228213_length_344_cov_2.006557_g212586_i0	PRJEB30004	228213	344	2.006557	6.90255608	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	619	7.109999999999999e-173	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g212586	i0	99.128	178.011627906977	344	3	100	0	1	344	1155657	1156000	Planctomyces sp. SH-PL62, complete genome	blastn	61236	619	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
15339836	15339836	PRJEB30004_P_NODE_339593_length_257_cov_1.541284_g323966_i0	PRJEB30004	339593	257	1.541284	3.96109988	Rohdeia mirabilis	2528008	Bacteria	Bacteria	222	1.68e-53	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g323966	i0	82.422	5.91439688715953	256	43	99	2	3	257	3895070	3894816	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	1520	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
15341611	15341611	PRJEB30004_P_NODE_376993_length_237_cov_2.989899_g361366_i0	PRJEB30004	376993	237	2.989899	7.08606063	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	433	6.5e-117	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g361366	i0	99.578	165.10970464135	237	1	100	0	1	237	2003957	2003721	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	39131	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15346603	15346603	PRJEB30004_P_NODE_481253_length_197_cov_1.582278_g465626_i0	PRJEB30004	481253	197	1.582278	3.11708766	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g465626	i0	100	28.5431472081218	197	0	100	0	1	197	5171074	5170878	Lacipirellula limnantheis strain I41 chromosome	blastn	5623	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
16627133	16627133	PRJEB30004_P_NODE_599834_length_167_cov_1.281250_g584207_i0	PRJEB30004	599834	167	1.28125	2.1396875	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	115	1.76e-21	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g584207	i0	87.255	19.2335329341317	102	12	60	1	66	166	3083036	3082935	Stratiformator vulcanicus strain Pan189 chromosome	blastn	3212	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
17892450	17892450	PRJEB30004_P_NODE_404655_length_225_cov_1.446237_g389028_i0	PRJEB30004	404655	225	1.446237	3.25403325	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	388	1.34e-103	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g389028	i0	97.778	199.72	225	5	100	0	1	225	1155658	1155434	Planctomyces sp. SH-PL62, complete genome	blastn	44937	388	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
18840251	18840251	PRJEB30004_P_NODE_394435_length_229_cov_2.242105_g378808_i0	PRJEB30004	394435	229	2.242105	5.13442045	Planctomycetia	203683	Bacteria	Bacteria	364	2.309999999999999e-96	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g378808	i0	95.238	223.436681222707	231	9	100	2	1	229	5179987	5179757	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	51167	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
20115009	20115009	PRJEB30004_P_NODE_292836_length_287_cov_1.362903_g277209_i0	PRJEB30004	292836	287	1.362903	3.91153161	Gemmata	113	Bacteria	Bacteria	492	1.32e-134	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g277209	i0	97.561	149.216027874564	287	7	100	0	1	287	3634137	3634423	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	42825	492	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
20437901	20437901	PRJEB30004_P_NODE_328397_length_263_cov_2.839286_g312770_i0	PRJEB30004	328397	263	2.839286	7.46732218	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	331	2.75e-86	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g312770	i0	89.513	180.444866920152	267	20	99	7	1	262	2002212	2002475	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	47457	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20451637	20451637	PRJEB30004_P_NODE_612657_length_164_cov_1.640000_g597030_i0	PRJEB30004	612657	164	1.64	2.6896	Rohdeia mirabilis	2528008	Bacteria	Bacteria	248	1.63e-61	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g597030	i0	93.902	71.4878048780488	164	10	100	0	1	164	3892486	3892649	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	11724	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
21709852	21709852	PRJEB30004_P_NODE_240738_length_331_cov_1.821918_g225111_i0	PRJEB30004	240738	331	1.821918	6.03054858	Gemmata massiliana	1210884	Bacteria	Bacteria	466	9.39e-127	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g225111	i0	92.857	346.80664652568	322	21	97	2	10	329	3633677	3633998	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	114793	466	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
23941033	23941033	PRJEB30004_P_NODE_550799_length_178_cov_1.273381_g535172_i0	PRJEB30004	550799	178	1.273381	2.26661818	Planctomycetia	203683	Bacteria	Bacteria	213	6.53e-51	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g535172	i0	89.759	241.769662921348	166	17	93	0	1	166	2340	2175	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	43035	215	0.990697674418605	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
24269439	24269439	PRJEB30004_P_NODE_463100_length_203_cov_1.487805_g447473_i0	PRJEB30004	463100	203	1.487805	3.02024415	Rohdeia mirabilis	2528008	Bacteria	Bacteria	255	1.26e-63	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g447473	i0	89.95	7.10837438423645	199	19	98	1	4	202	3894693	3894496	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	1443	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis

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