metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA1182301" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA1182301" and tax_clade = "PVC group"

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
1593270	1593270	PRJNA1182301_P_NODE_36622_length_266_cov_2.098446_g36497_i0	PRJNA1182301	36622	266	2.098446	5.58186636	Gemmataceae bacterium	2052164	Bacteria	Bacteria	414	2.69e-111	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g36497	i0	94.737	44.4473684210526	266	14	100	0	1	266	320242	319977	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	11823	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
1593737	1593737	PRJNA1182301_P_NODE_56402_length_246_cov_0.890173_g56277_i0	PRJNA1182301	56402	246	0.890173	2.18982558	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	71.3	6.13e-8	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g56277	i0	81.818	0.357723577235772	88	12	35	3	1	86	2528822	2528737	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	88	71.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2869536	2869536	PRJNA1182301_P_NODE_42403_length_259_cov_1.430108_g42278_i0	PRJNA1182301	42403	259	1.430108	3.70397972	Gemmataceae bacterium	2052164	Bacteria	Bacteria	335	2.089999999999999e-87	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g42278	i0	89.961	88.2393822393822	259	26	100	0	1	259	7219228	7218970	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	22854	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
4144963	4144963	PRJNA1182301_P_NODE_13804_length_310_cov_5.257384_g13679_i0	PRJNA1182301	13804	310	5.257384	16.2978904	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	82.4	3.69e-11	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g13679	i0	96	1.26774193548387	50	2	16	0	26	75	3338490	3338441	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	393	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
5421619	5421619	PRJNA1182301_P_NODE_34445_length_269_cov_1.571429_g34320_i0	PRJNA1182301	34445	269	1.571429	4.22714401	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	206	1.7899999999999998e-48	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g34320	i0	82.857	13.2379182156134	245	27	87	10	9	243	385971	385732	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	3561	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5421871	5421871	PRJNA1182301_P_NODE_44545_length_256_cov_1.683060_g44420_i0	PRJNA1182301	44545	256	1.68306	4.3086336	Phycisphaera sp.	2030824	Bacteria	Bacteria	100	8.19e-17	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g44420	i0	81.452	0.484375	124	21	48	2	5	127	3336144	3336022	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	124	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
7971540	7971540	PRJNA1182301_P_NODE_24027_length_283_cov_1.914286_g23902_i0	PRJNA1182301	24027	283	1.914286	5.41742938	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	348	2.97e-91	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g23902	i0	88.968	0.992932862190813	281	31	99	0	1	281	1665798	1666078	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	281	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
11797579	11797579	PRJNA1182301_P_NODE_52150_length_249_cov_0.875000_g52025_i0	PRJNA1182301	52150	249	0.875	2.17875	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	344	3.32e-90	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g52025	i0	91.633	22.3935742971888	251	18	100	3	1	249	9440888	9441137	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	5576	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11797767	11797767	PRJNA1182301_P_NODE_59630_length_243_cov_2.423529_g59505_i0	PRJNA1182301	59630	243	2.423529	5.88917547	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	158	4.51e-34	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g59505	i0	79.268	5.90123456790123	246	35	99	14	1	240	3294298	3294533	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1434	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11797792	11797792	PRJNA1182301_P_NODE_60870_length_242_cov_3.402367_g60745_i0	PRJNA1182301	60870	242	3.402367	8.23372814	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	193	1.23e-44	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g60745	i0	81.224	98.4214876033058	245	40	100	5	1	242	1507032	1506791	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	23818	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
13071741	13071741	PRJNA1182301_P_NODE_17511_length_294_cov_4.280543_g17386_i0	PRJNA1182301	17511	294	4.280543	12.58479642	Limnoglobus roseus	2598579	Bacteria	Bacteria	265	3.22e-66	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g17386	i0	82.951	20.8503401360544	305	41	100	5	1	294	3207892	3208196	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	6130	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
14348073	14348073	PRJNA1182301_P_NODE_55952_length_246_cov_0.890173_g55827_i0	PRJNA1182301	55952	246	0.890173	2.18982558	Urbifossiella limnaea	2528023	Bacteria	Bacteria	67.6	7.94e-7	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g55827	i0	91.837	0.361788617886179	49	3	20	1	13	60	7142696	7142744	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	89	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
15621196	15621196	PRJNA1182301_P_NODE_28633_length_277_cov_1.475490_g28508_i0	PRJNA1182301	28633	277	1.47549	4.0871073000000004	Phycisphaera sp.	2030824	Bacteria	Bacteria	169	2.4299999999999997e-37	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g28508	i0	85.714	1.15162454873646	161	21	58	2	113	272	96483	96324	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	319	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
16895554	16895554	PRJNA1182301_P_NODE_28634_length_277_cov_1.470588_g28509_i0	PRJNA1182301	28634	277	1.470588	4.07352876	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	89.8	1.94e-13	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g28509	i0	98.039	27.2707581227437	51	1	18	0	1	51	949796	949846	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	7554	89.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
18169926	18169926	PRJNA1182301_P_NODE_22975_length_285_cov_1.136792_g22850_i0	PRJNA1182301	22975	285	1.136792	3.2398572	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	411	3.769999999999999e-110	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g22850	i0	92.908	5.64210526315789	282	20	100	0	4	285	2591483	2591202	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1608	411	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
18170366	18170366	PRJNA1182301_P_NODE_41055_length_260_cov_2.807487_g40930_i0	PRJNA1182301	41055	260	2.807487	7.2994662	Paludisphaera borealis	1387353	Bacteria	Bacteria	309	1.2700000000000002e-79	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g40930	i0	88.123	31.7923076923077	261	29	100	2	1	260	1666335	1666076	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	8266	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
18170937	18170937	PRJNA1182301_P_NODE_65715_length_234_cov_2.403727_g65590_i0	PRJNA1182301	65715	234	2.403727	5.62472118	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	156	1.55e-33	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g65590	i0	85.906	10.2393162393162	149	17	63	3	14	160	3747994	3748140	Planctomyces sp. SH-PL62, complete genome	blastn	2396	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
18171005	18171005	PRJNA1182301_P_NODE_68455_length_209_cov_4.257353_g68330_i0	PRJNA1182301	68455	209	4.257353	8.89786777	Planctomycetota bacterium	2026780	Bacteria	Bacteria	97.1	8.35e-16	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g68330	i0	90.411	0.349282296650718	73	7	35	0	122	194	1930170	1930098	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	73	97.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
19444730	19444730	PRJNA1182301_P_NODE_41156_length_260_cov_2.336898_g41031_i0	PRJNA1182301	41156	260	2.336898	6.0759348	Paludisphaera borealis	1387353	Bacteria	Bacteria	156	1.76e-33	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g41031	i0	83.626	2.25769230769231	171	22	65	6	1	168	260332	260499	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	587	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
20720016	20720016	PRJNA1182301_P_NODE_39457_length_262_cov_3.243386_g39332_i0	PRJNA1182301	39457	262	3.243386	8.49767132	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	191	4.86e-44	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g39332	i0	82.949	9.52671755725191	217	31	82	4	1	214	2286506	2286719	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	2496	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23270393	23270393	PRJNA1182301_P_NODE_20459_length_288_cov_1.925581_g20334_i0	PRJNA1182301	20459	288	1.925581	5.54567328	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	198	3.2299999999999993e-46	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g20334	i0	84.058	0.920138888888889	207	31	72	2	6	211	3870331	3870536	Tautonia plasticadhaerens strain ElP chromosome	blastn	265	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
24545127	24545127	PRJNA1182301_P_NODE_59540_length_243_cov_2.705882_g59415_i0	PRJNA1182301	59540	243	2.705882	6.57529326	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	167	7.5e-37	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g59415	i0	79.574	0.967078189300412	235	46	96	2	1	234	5076124	5075891	Planctomyces sp. SH-PL14, complete genome	blastn	235	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14

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