metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA488043" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA488043" 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
3000771	3000771	PRJNA488043_S_NODE_123_length_436_cov_13.267813_g112_i0	PRJNA488043	123	436	13.267813	57.84766468	Phycisphaerae bacterium RAS2	2528035	Bacteria	Bacteria	507	7.48e-139	NTclustered	gi\|1712788464\|gb\|CP036352.1\|	2528035	g112	i0	87.64	72.5481651376147	445	43	100	8	1	436	3961702	3962143	Phycisphaerae bacterium RAS2 chromosome, complete genome	blastn	31631	507	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium RAS2
3000780	3000780	PRJNA488043_S_NODE_443_length_277_cov_44.721774_g432_i0	PRJNA488043	443	277	44.721774	123.87931398	Saltatorellus ferox	2528018	Bacteria	Bacteria	207	5.14e-49	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g432	i0	81.022	305.862815884477	274	40	97	11	1	269	2931217	2931483	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	84724	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
3649172	3649172	PRJNA488043_S_NODE_1343_length_166_cov_79.138686_g1332_i0	PRJNA488043	1343	166	79.138686	131.37021876	Planctomycetota	203682	Bacteria	Bacteria	274	2.73e-69	NTclustered	gi\|1702190059\|gb\|CP030884.1\|	2026779	g1332	i0	96.386	138.05421686747	166	6	100	0	1	166	437280	437445	Planctomycetaceae bacterium isolate ECT2AJA-110-A chromosome	blastn	22917	276	0.992753623188406	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
3649178	3649178	PRJNA488043_S_NODE_1643_length_150_cov_11.380165_g1632_i0	PRJNA488043	1643	150	11.380165	17.0702475	Planctomycetota	203682	Bacteria	Bacteria	169	1.16e-37	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g1632	i0	87.162	252.306666666667	148	19	99	0	3	150	4345446	4345593	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	37846	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
4277092	4277092	PRJNA488043_S_NODE_64_length_531_cov_11.693227_g53_i0	PRJNA488043	64	531	11.693227	62.09103537	Phycisphaerae bacterium RAS2	2528035	Bacteria	Bacteria	715	0	NTclustered	gi\|1712788464\|gb\|CP036352.1\|	2528035	g53	i0	91.011	321.065913370998	534	43	100	5	1	531	3962659	3963190	Phycisphaerae bacterium RAS2 chromosome, complete genome	blastn	170486	715	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium RAS2
4277095	4277095	PRJNA488043_S_NODE_764_length_214_cov_3.735135_g753_i0	PRJNA488043	764	214	3.735135	7.9931889	Planctomycetia bacterium	2052181	Bacteria	Bacteria	124	3.94e-24	NTclustered	gi\|1938772707\|gb\|CP054190.1\|	2052181	g753	i0	81.132	18.2196261682243	159	26	74	3	56	214	792673	792519	MAG: Planctomycetia bacterium isolate H1_PLA3 chromosome, complete genome	blastn	3899	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
4926179	4926179	PRJNA488043_S_NODE_1204_length_175_cov_13.342466_g1193_i0	PRJNA488043	1204	175	13.342466	23.3493155	Bacteria	2	Bacteria	Bacteria	254	3.77e-63	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g1193	i0	93.103	13.0171428571429	174	11	99	1	3	175	1866712	1866539	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	2278	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
4926192	4926192	PRJNA488043_S_NODE_544_length_253_cov_18.419643_g533_i0	PRJNA488043	544	253	18.419643	46.60169679	Planctomycetota	203682	Bacteria	Bacteria	366	7.22e-97	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g533	i0	92.885	294.687747035573	253	17	100	1	1	253	1881288	1881539	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	74556	366	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
5553591	5553591	PRJNA488043_S_NODE_145_length_417_cov_15.028351_g134_i0	PRJNA488043	145	417	15.028351	62.66822367	Planctomycetia bacterium	2052181	Bacteria	Bacteria	518	3.29e-142	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g134	i0	89.095	140.94964028777	431	28	100	13	1	417	1882093	1882518	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	58776	518	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
6827596	6827596	PRJNA488043_S_NODE_286_length_331_cov_13.096026_g275_i0	PRJNA488043	286	331	13.096026	43.34784606	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	405	2.08e-108	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g275	i0	89.124	89.2296072507553	331	28	100	5	1	331	1867924	1867602	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	29535	405	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
6827599	6827599	PRJNA488043_S_NODE_606_length_239_cov_18.185714_g595_i0	PRJNA488043	606	239	18.185714	43.46385646	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	353	5.26e-93	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g595	i0	93.305	154.497907949791	239	16	100	0	1	239	1868793	1868555	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	36925	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
7476059	7476059	PRJNA488043_S_NODE_1466_length_160_cov_19.351145_g1455_i0	PRJNA488043	1466	160	19.351145	30.961832	Bacteria	2	Bacteria	Bacteria	278	2.01e-70	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g1455	i0	98.113	156.96875	159	3	99	0	1	159	1867959	1868117	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	25115	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
7476068	7476068	PRJNA488043_S_NODE_346_length_307_cov_17.956835_g335_i0	PRJNA488043	346	307	17.956835	55.12748345	Planctomycetota	203682	Bacteria	Bacteria	412	1.1399999999999997e-110	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g335	i0	90.879	191.899022801303	307	28	100	0	1	307	1881506	1881812	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	58913	412	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
10653691	10653691	PRJNA488043_P_NODE_9469_length_357_cov_16.621951_g7239_i0	PRJNA488043	9469	357	16.621951	59.34036507	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	169	3.22e-37	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g7239	i0	80.617	32.921568627451	227	37	62	7	25	247	1454572	1454349	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	11753	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11928676	11928676	PRJNA488043_S_NODE_330_length_311_cov_10.769504_g319_i0	PRJNA488043	330	311	10.769504	33.49315744	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	407	5.379999999999999e-109	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g319	i0	94.656	97.6816720257235	262	14	84	0	1	262	1867924	1867663	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	30379	407	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
14478568	14478568	PRJNA488043_P_NODE_7452_length_442_cov_24.414044_g5303_i0	PRJNA488043	7452	442	24.414044	107.91007448	Saltatorellus ferox	2528018	Bacteria	Bacteria	433	1.31e-116	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g5303	i0	84.828	352.968325791855	435	61	98	5	10	442	2933046	2932615	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	156012	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
14478605	14478605	PRJNA488043_S_NODE_32_length_648_cov_16.172859_g25_i0	PRJNA488043	32	648	16.172859	104.80012632	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	802	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g25	i0	89.13	265.720679012346	644	70	99	0	1	644	1867255	1866612	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	172187	802	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
14478608	14478608	PRJNA488043_S_NODE_412_length_287_cov_9.174419_g401_i0	PRJNA488043	412	287	9.174419	26.33058253	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	180	1.17e-40	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g401	i0	78.694	371.574912891986	291	47	100	11	1	287	4346147	4345868	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	106642	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
15752714	15752714	PRJNA488043_S_NODE_633_length_233_cov_8.431373_g622_i0	PRJNA488043	633	233	8.431373	19.64509909	Phycisphaerae bacterium RAS2	2528035	Bacteria	Bacteria	268	1.9e-67	NTclustered	gi\|1712788464\|gb\|CP036352.1\|	2528035	g622	i0	88.688	153.639484978541	221	24	95	1	13	233	3960890	3961109	Phycisphaerae bacterium RAS2 chromosome, complete genome	blastn	35798	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium RAS2
15752718	15752718	PRJNA488043_S_NODE_93_length_464_cov_55.719540_g82_i0	PRJNA488043	93	464	55.71954	258.5386656	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	316	1.45e-81	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g82	i0	80.471	338.933189655172	425	74	91	9	1	422	4345593	4345175	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	157265	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
17027316	17027316	PRJNA488043_S_NODE_34_length_646_cov_43.103728_g25_i1	PRJNA488043	34	646	43.103728	278.45008288	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	784	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g25	i1	88.682	274.482972136223	645	69	99	4	1	642	1867255	1866612	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	177316	784	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20851673	20851673	PRJNA488043_S_NODE_377_length_298_cov_45.342007_g366_i0	PRJNA488043	377	298	45.342007	135.11918086	Phycisphaerae bacterium RAS2	2528035	Bacteria	Bacteria	357	5.24e-94	NTclustered	gi\|1712788464\|gb\|CP036352.1\|	2528035	g366	i0	88.294	258.523489932886	299	34	100	1	1	298	3962190	3962488	Phycisphaerae bacterium RAS2 chromosome, complete genome	blastn	77040	357	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium RAS2
22126488	22126488	PRJNA488043_S_NODE_278_length_335_cov_11.549020_g267_i0	PRJNA488043	278	335	11.54902	38.689217	Planctomycetia bacterium	2052181	Bacteria	Bacteria	257	6.24e-64	NTclustered	gi\|1938772707\|gb\|CP054190.1\|	2052181	g267	i0	86.192	206.280597014925	239	31	71	2	98	335	792054	792291	MAG: Planctomycetia bacterium isolate H1_PLA3 chromosome, complete genome	blastn	69104	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
22775075	22775075	PRJNA488043_S_NODE_378_length_298_cov_20.278810_g367_i0	PRJNA488043	378	298	20.27881	60.4308538	Engelhardtia	139931	Bacteria	Bacteria	193	1.56e-44	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g367	i0	79.195	97.0771812080537	298	47	99	12	3	298	5248802	5248518	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	28929	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia 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);;