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

24 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Ignavibacteriota"

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
128348	128348	PRJEB64798_P_NODE_240501_length_155_cov_2.915094_g238735_i0	PRJEB64798	240501	155	2.915094	4.5183957	uncultured Ignavibacteriales bacterium	1191687	Bacteria	Bacteria	100	4.49e-17	NTclustered	gi\|2874253946\|emb\|OY970271.1\|	1191687	g238735	i0	84.615	7.27741935483871	104	12	66	4	6	107	1261578	1261477	MAG: uncultured Ignavibacteriales bacterium isolate MFD02416.bin.c.14 genome assembly, chromosome: 1	blastn	1128	100	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			uncultured Ignavibacteriales bacterium
993526	993526	PRJEB64798_P_NODE_37061_length_324_cov_9.098182_g35301_i0	PRJEB64798	37061	324	9.098182	29.47810968	Pseudomonadati	3379134	Bacteria	Bacteria	346	1.25e-90	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g35301	i0	86.392	199.993827160494	316	43	98	0	7	322	1602036	1602351	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	64798	346	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
993617	993617	PRJEB64798_P_NODE_5121_length_857_cov_12.753713_g4074_i0	PRJEB64798	5121	857	12.753713	109.29932041000001	Pseudomonadati	3379134	Bacteria	Bacteria	889	0	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g4074	i0	85.83	287.621936989498	861	94	99	19	1	853	1603542	1602702	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	246492	889	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
1403049	1403049	PRJEB64798_P_NODE_246802_length_153_cov_2.634615_g245036_i0	PRJEB64798	246802	153	2.634615	4.03096095	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	110	7.33e-20	NTclustered	gi\|1858604176\|gb\|CP054675.1\|	2053306	g245036	i0	80	15.2549019607843	150	28	97	2	1	149	871958	872106	Ignavibacteria bacterium isolate Ch128a chromosome, complete genome	blastn	2334	110	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
2267893	2267893	PRJEB64798_P_NODE_104942_length_211_cov_21.858025_g103176_i0	PRJEB64798	104942	211	21.858025	46.12043275	Pseudomonadati	3379134	Bacteria	Bacteria	259	1.02e-64	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g103176	i0	89.32	174.890995260664	206	22	98	0	6	211	1604036	1604241	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	36902	259	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
2268205	2268205	PRJEB64798_P_NODE_168522_length_179_cov_5.823077_g166756_i0	PRJEB64798	168522	179	5.823077	10.42330783	Pseudomonadati	3379134	Bacteria	Bacteria	174	3.1e-39	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g166756	i0	93.913	49.4972067039106	115	7	64	0	63	177	1604954	1604840	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	8860	174	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
2678391	2678391	PRJEB64798_P_NODE_226683_length_160_cov_3.063063_g224917_i0	PRJEB64798	226683	160	3.063063	4.9009008	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	228	2.0499999999999995e-55	NTclustered	gi\|2621786307\|emb\|OY782765.1\|	2614255	g224917	i0	92.949	270.8375	156	11	98	0	1	156	2843219	2843374	MAG: Melioribacteraceae bacterium isolate b49f5fa7-6043-4eb4-88a3-53a29b1f0925 genome assembly, chromosome: 1	blastn	43334	228	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
3543378	3543378	PRJEB64798_P_NODE_137563_length_194_cov_15.593103_g135797_i0	PRJEB64798	137563	194	15.593103	30.25061982	Pseudomonadati	3379134	Bacteria	Bacteria	198	2.03e-46	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g135797	i0	90.667	45.8298969072165	150	13	77	1	46	194	1601870	1602019	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	8891	198	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
4821711	4821711	PRJEB64798_P_NODE_68804_length_233_cov_8.809783_g67039_i0	PRJEB64798	68804	233	8.809783	20.52679439	Pseudomonadati	3379134	Bacteria	Bacteria	246	8.909999999999999e-61	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g67039	i0	94.904	190.004291845494	157	8	83	0	2	158	1602712	1602556	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	44271	246	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
6096524	6096524	PRJEB64798_P_NODE_249365_length_152_cov_3.339806_g247599_i0	PRJEB64798	249365	152	3.339806	5.07650512	Ignavibacterium	795750	Bacteria	Bacteria	104	3.38e-18	NTclustered	gi\|470490116\|ref\|NR_076968.1\|	591197	g247599	i0	90.123	7.82894736842105	81	6	53	2	45	124	266	187	Ignavibacterium album strain Mat9-16 23S ribosomal RNA gene, complete sequence	blastn	1190	104	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium album
9921510	9921510	PRJEB64798_P_NODE_248548_length_152_cov_5.135922_g246782_i0	PRJEB64798	248548	152	5.135922	7.80660144	Pseudomonadati	3379134	Bacteria	Bacteria	134	4.31e-27	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g246782	i0	87.288	28.1513157894737	118	14	77	1	27	143	1007859	1007742	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	4279	134	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
13746669	13746669	PRJEB64798_P_NODE_218691_length_162_cov_6.522124_g216925_i0	PRJEB64798	218691	162	6.522124	10.56584088	Ignavibacteriales	795748	Bacteria	Bacteria	95.3	2.21e-15	NTclustered	gi\|2556928988\|gb\|CP129490.1\|	2614255	g216925	i0	85.263	87.3333333333333	95	10	57	4	1	92	886102	886009	MAG: Melioribacteraceae bacterium isolate cMAG.6 chromosome, complete genome	blastn	14148	95.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
14156521	14156521	PRJEB64798_P_NODE_216772_length_163_cov_1.456140_g215006_i0	PRJEB64798	216772	163	1.45614	2.3735082	uncultured Ignavibacteriales bacterium	1191687	Bacteria	Bacteria	217	4.5499999999999996e-52	NTclustered	gi\|2874253946\|emb\|OY970271.1\|	1191687	g215006	i0	90.741	285.503067484663	162	15	99	0	1	162	1263075	1263236	MAG: uncultured Ignavibacteriales bacterium isolate MFD02416.bin.c.14 genome assembly, chromosome: 1	blastn	46537	217	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			uncultured Ignavibacteriales bacterium
15021323	15021323	PRJEB64798_P_NODE_29612_length_361_cov_16.221154_g27856_i0	PRJEB64798	29612	361	16.221154	58.55836594	Pseudomonadati	3379134	Bacteria	Bacteria	372	2.31e-98	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g27856	i0	85.95	154.019390581717	363	33	100	10	1	361	1602374	1602720	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	55601	372	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
15429900	15429900	PRJEB64798_P_NODE_177033_length_175_cov_14.087302_g175267_i0	PRJEB64798	177033	175	14.087302	24.6527785	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	115	1.85e-21	NTclustered	gi\|1850839647\|gb\|CP053446.1\|	2026749	g175267	i0	95.833	0.411428571428571	72	2	41	1	100	171	1401186	1401116	Ignavibacteriae bacterium isolate IGN2 chromosome	blastn	72	115	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
15431115	15431115	PRJEB64798_P_NODE_30153_length_358_cov_18.245955_g28396_i0	PRJEB64798	30153	358	18.245955	65.3205189	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2621703088\|emb\|OY760517.1\|	2614255	g28396	i0	96.875	0.0893854748603352	32	0	9	1	7	37	2125978	2126009	MAG: Melioribacteraceae bacterium isolate c8b6aad9-4aa7-488e-baf1-dd4234e1cecc genome assembly, chromosome: 1	blastn	32	52.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
16704653	16704653	PRJEB64798_P_NODE_206534_length_165_cov_17.112069_g204768_i0	PRJEB64798	206534	165	17.112069	28.23491385	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	198	1.67e-46	NTclustered	gi\|1958088527\|gb\|CP065001.1\|	2049428	g204768	i0	90.604	9.64848484848485	149	14	90	0	15	163	607423	607571	Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome	blastn	1592	198	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
17980659	17980659	PRJEB64798_P_NODE_53155_length_268_cov_6.246575_g51390_i0	PRJEB64798	53155	268	6.246575	16.740821	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	211	3.8300000000000002e-50	NTclustered	gi\|2874253742\|emb\|OY969585.1\|	2026749	g51390	i0	81.955	85.884328358209	266	32	96	14	1	256	458740	458999	MAG: Ignavibacteriota bacterium isolate MFD03726.bin.c.11 genome assembly, chromosome: 1	blastn	23017	211	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
20527815	20527815	PRJEB64798_P_NODE_135077_length_196_cov_2.646259_g133311_i0	PRJEB64798	135077	196	2.646259	5.18666764	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	158	3.49e-34	NTclustered	gi\|2621703982\|emb\|OY762937.1\|	2651163	g133311	i0	82.353	79.4387755102041	187	27	94	6	7	190	3837532	3837349	MAG: Ignavibacteriaceae bacterium isolate 77385eac-16a0-46d9-9606-3f30544cc643 genome assembly, chromosome: 1	blastn	15570	158	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
20529396	20529396	PRJEB64798_P_NODE_242797_length_154_cov_4.200000_g241031_i0	PRJEB64798	242797	154	4.2	6.468	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	143	7.289999999999999e-30	NTclustered	gi\|1858604176\|gb\|CP054675.1\|	2053306	g241031	i0	85.926	301.850649350649	135	17	87	2	20	153	872774	872641	Ignavibacteria bacterium isolate Ch128a chromosome, complete genome	blastn	46485	143	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
21394883	21394883	PRJEB64798_P_NODE_127277_length_199_cov_13.906667_g125511_i0	PRJEB64798	127277	199	13.906667	27.67426733	Pseudomonadati	3379134	Bacteria	Bacteria	182	2.11e-41	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g125511	i0	83.673	9.89447236180905	196	29	98	2	2	196	1602932	1602739	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	1969	182	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
23078717	23078717	PRJEB64798_P_NODE_124659_length_202_cov_6.607843_g122893_i0	PRJEB64798	124659	202	6.607843	13.34784286	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	281	2.0600000000000002e-71	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g122893	i0	92.424	132.079207920792	198	13	97	2	2	197	430766	430569	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	26680	281	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
23946091	23946091	PRJEB64798_P_NODE_68899_length_233_cov_5.972826_g67134_i0	PRJEB64798	68899	233	5.972826	13.91668458	Pseudomonadati	3379134	Bacteria	Bacteria	353	5.1e-93	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g67134	i0	94.068	322.502145922747	236	9	100	4	1	233	1602606	1602373	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	75143	353	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
24352872	24352872	PRJEB64798_P_NODE_145460_length_190_cov_24.517730_g143694_i0	PRJEB64798	145460	190	24.51773	46.583687	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	82.4	2.08e-11	NTclustered	gi\|2621700951\|emb\|OY759785.1\|	2651163	g143694	i0	86.42	23.5473684210526	81	3	41	7	106	182	3551223	3551299	MAG: Ignavibacteriaceae bacterium isolate e3da2468-0b18-4b5b-bfd4-73ebec91e4fc genome assembly, chromosome: 1	blastn	4474	82.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae 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);;