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

19 rows where analysis = "blastn", bioproject = "PRJNA624323" 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
596356	596356	PRJNA624323_P_NODE_4161_length_358_cov_1.347368_g3999_i0	PRJNA624323	4161	358	1.347368	4.82357744	Aureliella helgolandensis	2527968	Bacteria	Bacteria	446	1.33e-120	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g3999	i0	90.351	115.005586592179	342	29	95	4	7	346	6999664	7000003	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	41172	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
2425371	2425371	PRJNA624323_P_NODE_1102_length_680_cov_1.802306_g948_i0	PRJNA624323	1102	680	1.802306	12.2556808	Limnoglobus	2731450	Bacteria	Bacteria	787	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g948	i0	88.45	501.463235294118	658	68	96	7	3	654	2002890	2002235	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	340995	787	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3147223	3147223	PRJNA624323_P_NODE_2383_length_477_cov_2.123762_g2222_i0	PRJNA624323	2383	477	2.123762	10.13034474	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	241	9.23e-59	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g2222	i0	76.299	260.115303983229	481	96	99	15	7	476	3454047	3453574	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	124075	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
3147235	3147235	PRJNA624323_P_NODE_7763_length_254_cov_1.276243_g7601_i0	PRJNA624323	7763	254	1.276243	3.24165722	Limnoglobus roseus	2598579	Bacteria	Bacteria	359	1.21e-94	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g7601	i0	93.75	150.688976377953	240	13	94	2	16	254	2958209	2958447	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	38275	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
3147253	3147253	PRJNA624323_P_NODE_9723_length_235_cov_2.277778_g9561_i0	PRJNA624323	9723	235	2.277778	5.3527783	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	255	1.5e-63	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g9561	i0	86.383	30.3021276595745	235	30	99	2	3	235	7050764	7050530	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	7121	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4423965	4423965	PRJNA624323_P_NODE_6864_length_272_cov_2.130653_g6702_i0	PRJNA624323	6864	272	2.130653	5.79537616	Rohdeia mirabilis	2528008	Bacteria	Bacteria	337	6.15e-88	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g6702	i0	89.051	436.893382352941	274	26	100	4	1	272	3894209	3893938	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	118835	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
6974811	6974811	PRJNA624323_P_NODE_3126_length_418_cov_1.626087_g2965_i0	PRJNA624323	3126	418	1.626087	6.79704366	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	536	9.109999999999999e-148	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g2965	i0	89.786	103.961722488038	421	39	100	4	1	418	1599231	1599650	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	43456	536	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
6974822	6974822	PRJNA624323_P_NODE_7506_length_259_cov_1.817204_g7344_i0	PRJNA624323	7506	259	1.817204	4.70655836	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	294	3.55e-75	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g7344	i0	87.405	224.266409266409	262	25	100	7	1	259	2583402	2583146	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	58085	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
13350538	13350538	PRJNA624323_P_NODE_3671_length_383_cov_3.319355_g3509_i0	PRJNA624323	3671	383	3.319355	12.71312965	Planctomycetota bacterium	2026780	Bacteria	Bacteria	453	8.570000000000001e-123	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g3509	i0	88.083	237.610966057441	386	41	100	4	1	383	721619	722002	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	91005	453	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
14625290	14625290	PRJNA624323_P_NODE_6032_length_293_cov_1.400000_g5870_i0	PRJNA624323	6032	293	1.4	4.102	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	279	1.14e-70	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g5870	i0	84	38.7508532423208	300	39	100	7	1	293	7051545	7051842	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	11354	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15899296	15899296	PRJNA624323_P_NODE_2173_length_501_cov_1.537383_g2013_i0	PRJNA624323	2173	501	1.537383	7.70228883	Limnoglobus roseus	2598579	Bacteria	Bacteria	769	0	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g2013	i0	94.422	167.417165668663	502	25	100	3	1	501	2956500	2956999	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	83876	769	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
15899327	15899327	PRJNA624323_P_NODE_9133_length_243_cov_1.811765_g8971_i0	PRJNA624323	9133	243	1.811765	4.40258895	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	335	1.9399999999999993e-87	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8971	i0	91.736	168.045267489712	242	19	99	1	3	243	2002298	2002057	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	40835	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17174258	17174258	PRJNA624323_P_NODE_8214_length_249_cov_1.369318_g8052_i0	PRJNA624323	8214	249	1.369318	3.40960182	Gemmataceae bacterium	2052164	Bacteria	Bacteria	327	3.34e-85	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g8052	i0	91.02	91.8674698795181	245	19	98	2	7	249	318278	318521	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	22875	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
19001597	19001597	PRJNA624323_P_NODE_3055_length_424_cov_1.569801_g2894_i0	PRJNA624323	3055	424	1.569801	6.65595624	Engelhardtia	139931	Bacteria	Bacteria	505	2.6099999999999995e-138	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g2894	i0	88.235	58.2028301886792	425	46	100	4	1	424	5247475	5247896	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	24678	505	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
19722973	19722973	PRJNA624323_P_NODE_596_length_888_cov_1.831902_g473_i0	PRJNA624323	596	888	1.831902	16.26728976	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1173	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g473	i0	90.429	346.685810810811	909	61	100	8	4	888	5936934	5936028	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	307857	1173	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20998687	20998687	PRJNA624323_P_NODE_8237_length_249_cov_0.875000_g8075_i0	PRJNA624323	8237	249	0.875	2.17875	Gemmataceae bacterium	2052164	Bacteria	Bacteria	303	5.63e-78	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g8075	i0	89.113	206.168674698795	248	22	99	5	2	247	319286	319530	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	51336	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23548861	23548861	PRJNA624323_P_NODE_5299_length_315_cov_2.504132_g5137_i0	PRJNA624323	5299	315	2.504132	7.8880158	Anaerohalosphaeraceae bacterium	2873829	Bacteria	Bacteria	326	1.57e-84	NTclustered	gi\|2621717560\|emb\|OY775912.1\|	2873829	g5137	i0	87.162	136.04126984127	296	27	92	9	26	315	1322189	1322479	MAG: Anaerohalosphaeraceae bacterium isolate 978f9c3d-91dc-4e11-95ec-8fa255ba7f00 genome assembly, chromosome: 1	blastn	42853	326	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Anaerohalosphaeraceae		Anaerohalosphaeraceae bacterium
23548863	23548863	PRJNA624323_P_NODE_5499_length_308_cov_1.800000_g5337_i0	PRJNA624323	5499	308	1.8	5.544	Rohdeia mirabilis	2528008	Bacteria	Bacteria	342	1.5199999999999999e-89	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g5337	i0	86.688	325.730519480519	308	41	100	0	1	308	3894304	3894611	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	100325	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
25376565	25376565	PRJNA624323_P_NODE_3260_length_408_cov_1.779104_g3099_i0	PRJNA624323	3260	408	1.779104	7.25874432	Gemmataceae	1914233	Bacteria	Bacteria	627	5.12e-175	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g3099	i0	94.39	145.757352941176	410	20	100	3	1	408	3634343	3634751	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	59469	632	0.992088607594937	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana

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