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

24 rows where analysis = "blastn", bioproject = "PRJNA1002570" and tax_phylum = "Elusimicrobiota"

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_kingdom	tax_phylum	tax_class	tax_species
1426952	1426952	PRJNA1002570_P_NODE_20922_length_288_cov_2.088372_g20727_i0	PRJNA1002570	20922	288	2.088372	6.01451136	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	305	1.85e-78	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g20727	i0	86.861	0.951388888888889	274	34	95	2	14	286	408339	408067	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	274	305	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
1427057	1427057	PRJNA1002570_P_NODE_27022_length_275_cov_1.237624_g26827_i0	PRJNA1002570	27022	275	1.237624	3.403466	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	193	1.43e-44	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g26827	i0	83.981	44.5927272727273	206	28	74	5	28	231	1713161	1713363	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	12263	193	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
6530395	6530395	PRJNA1002570_P_NODE_20946_length_288_cov_2.000000_g20751_i0	PRJNA1002570	20946	288	2	5.76	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	361	3.899999999999999e-95	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g20751	i0	89.236	86.6006944444444	288	31	100	0	1	288	3602439	3602726	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	24941	361	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
6530757	6530757	PRJNA1002570_P_NODE_42806_length_242_cov_3.065089_g42611_i0	PRJNA1002570	42806	242	3.065089	7.41751538	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	315	2.52e-81	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g42611	i0	90.377	69.8884297520661	239	23	99	0	1	239	3537771	3538009	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	16913	315	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
6530891	6530891	PRJNA1002570_P_NODE_9746_length_372_cov_1.481605_g9551_i0	PRJNA1002570	9746	372	1.481605	5.5115706	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	278	5.3600000000000005e-70	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g9551	i0	81.199	7.80376344086022	367	49	96	16	7	363	1688207	1687851	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	2903	278	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
11631276	11631276	PRJNA1002570_P_NODE_8230_length_396_cov_2.585139_g8035_i0	PRJNA1002570	8230	396	2.585139	10.23715044	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	359	1.99e-94	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g8035	i0	83.208	1.19949494949495	399	59	99	6	1	395	257326	256932	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	475	359	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
14180878	14180878	PRJNA1002570_P_NODE_22512_length_285_cov_1.448113_g22317_i0	PRJNA1002570	22512	285	1.448113	4.12712205	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	183	8.949999999999997e-42	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g22317	i0	78.671	1.00350877192982	286	53	99	6	1	282	435837	436118	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	286	183	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
14180974	14180974	PRJNA1002570_P_NODE_27512_length_273_cov_2.680000_g27317_i0	PRJNA1002570	27512	273	2.68	7.3164	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	305	1.74e-78	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g27317	i0	87.037	0.989010989010989	270	35	99	0	1	270	3506853	3507122	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	270	305	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
15455264	15455264	PRJNA1002570_P_NODE_44293_length_241_cov_0.916667_g44098_i0	PRJNA1002570	44293	241	0.916667	2.20916747	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	119	2.11e-22	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g44098	i0	95.89	42.7966804979253	73	3	34	0	130	202	1394963	1394891	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	10314	119	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	uncultured Elusimicrobia bacterium
16729205	16729205	PRJNA1002570_P_NODE_24634_length_280_cov_1.922705_g24439_i0	PRJNA1002570	24634	280	1.922705	5.383574	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	137	6.919999999999999e-28	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g24439	i0	82.249	53.225	169	20	59	8	115	278	633883	633720	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	14903	137	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
17578491	17578491	PRJNA1002570_P_NODE_20834_length_288_cov_3.395349_g20639_i0	PRJNA1002570	20834	288	3.395349	9.77860512	Pseudomonadati	3379134	Bacteria	Bacteria	75	5.69e-9	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g20639	i0	85.333	148.753472222222	75	7	26	2	170	244	2311965	2311895	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	42841	75	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	uncultured Elusimicrobia bacterium
18003940	18003940	PRJNA1002570_P_NODE_19615_length_291_cov_2.486239_g19420_i0	PRJNA1002570	19615	291	2.486239	7.23495549	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	207	5.44e-49	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g19420	i0	80	1.4639175257732	315	35	99	7	1	287	881891	881577	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	426	207	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
18004070	18004070	PRJNA1002570_P_NODE_27655_length_273_cov_1.690000_g27460_i0	PRJNA1002570	27655	273	1.69	4.6137	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	121	6.77e-23	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g27460	i0	78.977	0.644688644688645	176	37	64	0	14	189	2999545	2999370	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	176	121	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
18004113	18004113	PRJNA1002570_P_NODE_30035_length_267_cov_1.695876_g29840_i0	PRJNA1002570	30035	267	1.695876	4.52798892	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	73.1	1.88e-8	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g29840	i0	83.75	0.408239700374532	80	10	29	2	4	81	1232831	1232909	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	109	73.1	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
18004196	18004196	PRJNA1002570_P_NODE_34915_length_253_cov_3.405556_g34720_i0	PRJNA1002570	34915	253	3.405556	8.61605668	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	303	5.74e-78	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g34720	i0	88.98	1.26877470355731	245	27	97	0	2	246	3032380	3032624	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	321	303	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
19277728	19277728	PRJNA1002570_P_NODE_17956_length_299_cov_2.641593_g17761_i0	PRJNA1002570	17956	299	2.641593	7.89836307	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	171	7.36e-38	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g17761	i0	88.112	2.17391304347826	143	17	48	0	150	292	1988329	1988187	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	650	171	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
19277730	19277730	PRJNA1002570_P_NODE_18156_length_298_cov_3.613333_g17961_i0	PRJNA1002570	18156	298	3.613333	10.76773234	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	202	2.5999999999999997e-47	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g17961	i0	92.308	48.496644295302	143	9	47	2	150	290	748997	749139	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	14452	202	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
20553457	20553457	PRJNA1002570_P_NODE_24317_length_281_cov_1.451923_g24122_i0	PRJNA1002570	24317	281	1.451923	4.07990363	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	300	8.38e-77	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g24122	i0	86.447	1.17081850533808	273	37	97	0	1	273	2623913	2623641	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	329	300	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
20553584	20553584	PRJNA1002570_P_NODE_32617_length_260_cov_1.647059_g32422_i0	PRJNA1002570	32617	260	1.647059	4.2823534	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	244	3.6399999999999997e-60	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g32422	i0	84.524	17.6730769230769	252	34	96	5	9	258	505212	505460	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	4595	244	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
21402698	21402698	PRJNA1002570_P_NODE_15337_length_310_cov_3.531646_g15142_i0	PRJNA1002570	15337	310	3.531646	10.9481026	Bacteria	2	Bacteria	Bacteria	108	6.09e-19	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g15142	i0	83.478	1.53548387096774	115	19	37	0	36	150	248207	248093	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	476	108	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
23104416	23104416	PRJNA1002570_P_NODE_19559_length_291_cov_3.940367_g19364_i0	PRJNA1002570	19559	291	3.940367	11.46646797	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	106	2.04e-18	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g19364	i0	79.866	0.512027491408935	149	27	51	3	144	291	125506	125360	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	149	106	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
23104454	23104454	PRJNA1002570_P_NODE_21439_length_287_cov_2.023364_g21244_i0	PRJNA1002570	21439	287	2.023364	5.80705468	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	174	5.4299999999999997e-39	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g21244	i0	80.498	4.66202090592335	241	36	83	9	46	282	655423	655190	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	1338	174	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
23104560	23104560	PRJNA1002570_P_NODE_27939_length_272_cov_2.572864_g27744_i0	PRJNA1002570	27939	272	2.572864	6.99819008	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	117	8.73e-22	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g27744	i0	84.615	0.430147058823529	117	18	43	0	17	133	172468	172352	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	117	117	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium
24378112	24378112	PRJNA1002570_P_NODE_18300_length_298_cov_2.413333_g18105_i0	PRJNA1002570	18300	298	2.413333	7.19173234	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	95.3	4.54e-15	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g18105	i0	82.857	1.06375838926175	105	18	35	0	46	150	705208	705104	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	317	95.3	1	Bacteria	Pseudomonadati	Elusimicrobiota		Elusimicrobiota bacterium

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