metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA630162" 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
601491	601491	PRJNA630162_P_NODE_118081_length_175_cov_2.301587_g116558_i0	PRJNA630162	118081	175	2.301587	4.02777725	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	243	8.15e-60	NTclustered	gi\|1858604176\|gb\|CP054675.1\|	2053306	g116558	i0	93.293	405.182857142857	164	11	94	0	3	166	871946	872109	Ignavibacteria bacterium isolate Ch128a chromosome, complete genome	blastn	70907	243	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
602626	602626	PRJNA630162_P_NODE_78921_length_202_cov_3.810458_g77398_i0	PRJNA630162	78921	202	3.810458	7.69712516	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	113	7.95e-21	NTclustered	gi\|1858604176\|gb\|CP054675.1\|	2053306	g77398	i0	79.429	95.1138613861386	175	25	84	10	1	170	873894	874062	Ignavibacteria bacterium isolate Ch128a chromosome, complete genome	blastn	19213	113	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
3153664	3153664	PRJNA630162_P_NODE_88983_length_192_cov_2.804196_g87460_i0	PRJNA630162	88983	192	2.804196	5.38405632	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	255	1.17e-63	NTclustered	gi\|2621786307\|emb\|OY782765.1\|	2614255	g87460	i0	91.005	25.2135416666667	189	17	98	0	4	192	2843705	2843517	MAG: Melioribacteraceae bacterium isolate b49f5fa7-6043-4eb4-88a3-53a29b1f0925 genome assembly, chromosome: 1	blastn	4841	255	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
5705866	5705866	PRJNA630162_P_NODE_36865_length_294_cov_3.710204_g35342_i0	PRJNA630162	36865	294	3.710204	10.90799976	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	331	3.13e-86	NTclustered	gi\|1850839647\|gb\|CP053446.1\|	2026749	g35342	i0	87.543	40.4387755102041	289	32	98	4	8	294	2155712	2155998	Ignavibacteriae bacterium isolate IGN2 chromosome	blastn	11889	331	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
5705906	5705906	PRJNA630162_P_NODE_40245_length_280_cov_2.770563_g38722_i0	PRJNA630162	40245	280	2.770563	7.7575764	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	165	3.18e-36	NTclustered	gi\|2874253742\|emb\|OY969585.1\|	2026749	g38722	i0	86.164	85.6321428571429	159	15	55	4	107	260	458886	458730	MAG: Ignavibacteriota bacterium isolate MFD03726.bin.c.11 genome assembly, chromosome: 1	blastn	23977	165	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
6255369	6255369	PRJNA630162_P_NODE_96565_length_187_cov_9.028986_g95042_i0	PRJNA630162	96565	187	9.028986	16.88420382	Pseudomonadati	3379134	Bacteria	Bacteria	202	1.4999999999999996e-47	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g95042	i0	88.957	787.07486631016	163	18	87	0	22	184	1603067	1602905	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	147183	202	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
7528944	7528944	PRJNA630162_P_NODE_112246_length_178_cov_2.658915_g110723_i0	PRJNA630162	112246	178	2.658915	4.7328687	Pseudomonadati	3379134	Bacteria	Bacteria	254	3.85e-63	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g110723	i0	93.103	245.398876404494	174	11	97	1	6	178	1604065	1604238	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	43681	254	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
10080062	10080062	PRJNA630162_P_NODE_77208_length_205_cov_1.173077_g75685_i0	PRJNA630162	77208	205	1.173077	2.40480785	Bacteria	2	Bacteria	Bacteria	82.4	2.28e-11	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g75685	i0	91.525	18.3170731707317	59	5	29	0	139	197	430311	430253	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	3755	82.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
10806164	10806164	PRJNA630162_P_NODE_169989_length_154_cov_2.961905_g168466_i0	PRJNA630162	169989	154	2.961905	4.5613337	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	121	3.4199999999999996e-23	NTclustered	gi\|1858604176\|gb\|CP054675.1\|	2053306	g168466	i0	87.037	2.33116883116883	108	12	69	2	8	114	873045	872939	Ignavibacteria bacterium isolate Ch128a chromosome, complete genome	blastn	359	121	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
12080935	12080935	PRJNA630162_P_NODE_122190_length_173_cov_1.935484_g120667_i0	PRJNA630162	122190	173	1.935484	3.34838732	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	169	1.38e-37	NTclustered	gi\|1858604176\|gb\|CP054675.1\|	2053306	g120667	i0	86.452	13.2080924855491	155	20	89	1	20	173	873719	873565	Ignavibacteria bacterium isolate Ch128a chromosome, complete genome	blastn	2285	169	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
13355641	13355641	PRJNA630162_P_NODE_109771_length_180_cov_1.274809_g108248_i0	PRJNA630162	109771	180	1.274809	2.2946562	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	195	2.4e-45	NTclustered	gi\|2621786307\|emb\|OY782765.1\|	2614255	g108248	i0	87.209	334	172	21	96	1	7	178	2843297	2843127	MAG: Melioribacteraceae bacterium isolate b49f5fa7-6043-4eb4-88a3-53a29b1f0925 genome assembly, chromosome: 1	blastn	60120	195	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
14630932	14630932	PRJNA630162_P_NODE_18072_length_438_cov_2.848329_g16564_i0	PRJNA630162	18072	438	2.848329	12.47568102	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	472	2.7399999999999996e-128	NTclustered	gi\|2874253742\|emb\|OY969585.1\|	2026749	g16564	i0	89.062	166.981735159817	384	36	87	6	53	433	459617	459997	MAG: Ignavibacteriota bacterium isolate MFD03726.bin.c.11 genome assembly, chromosome: 1	blastn	73138	472	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
15904792	15904792	PRJNA630162_P_NODE_163893_length_160_cov_2.576577_g162370_i0	PRJNA630162	163893	160	2.576577	4.1225232	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	137	3.56e-28	NTclustered	gi\|2556928988\|gb\|CP129490.1\|	2614255	g162370	i0	84.286	4.24375	140	22	88	0	18	157	884502	884363	MAG: Melioribacteraceae bacterium isolate cMAG.6 chromosome, complete genome	blastn	679	137	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
17179538	17179538	PRJNA630162_P_NODE_125894_length_171_cov_2.311475_g124371_i0	PRJNA630162	125894	171	2.311475	3.95262225	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	104	3.9e-18	NTclustered	gi\|2556928988\|gb\|CP129490.1\|	2614255	g124371	i0	83.051	36.2163742690058	118	17	68	3	47	163	884635	884520	MAG: Melioribacteraceae bacterium isolate cMAG.6 chromosome, complete genome	blastn	6193	104	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
17729274	17729274	PRJNA630162_P_NODE_35934_length_298_cov_4.489960_g34411_i0	PRJNA630162	35934	298	4.48996	13.3800808	Ignavibacterium	795750	Bacteria	Bacteria	126	1.6099999999999997e-24	NTclustered	gi\|470490116\|ref\|NR_076968.1\|	591197	g34411	i0	93.023	42.8724832214765	86	6	29	0	211	296	266	181	Ignavibacterium album strain Mat9-16 23S ribosomal RNA gene, complete sequence	blastn	12776	126	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium album
19002884	19002884	PRJNA630162_P_NODE_37095_length_293_cov_3.233607_g35572_i0	PRJNA630162	37095	293	3.233607	9.47446851	Pseudomonadati	3379134	Bacteria	Bacteria	348	3.09e-91	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g35572	i0	89.247	217.98976109215	279	28	95	2	1	278	1602718	1602441	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	63871	348	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
19728982	19728982	PRJNA630162_P_NODE_52916_length_242_cov_2.269430_g51393_i0	PRJNA630162	52916	242	2.26943	5.4920206	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	233	7.25e-57	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g51393	i0	85.65	103.652892561983	223	31	92	1	20	242	430097	430318	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	25084	233	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
19729148	19729148	PRJNA630162_P_NODE_68816_length_213_cov_3.829268_g67293_i0	PRJNA630162	68816	213	3.829268	8.15634084	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	121	5.069999999999999e-23	NTclustered	gi\|2621704225\|emb\|OY761615.1\|	2651163	g67293	i0	84.677	242.427230046948	124	16	57	2	2	123	3101825	3101703	MAG: Ignavibacteriaceae bacterium isolate 0c874fb2-9291-49ee-bde1-826c4484edf3 genome assembly, chromosome: 1	blastn	51637	121	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
21553222	21553222	PRJNA630162_P_NODE_163857_length_160_cov_2.639640_g162334_i0	PRJNA630162	163857	160	2.63964	4.223424	Melioribacter	1134403	Bacteria	Bacteria	159	7.599999999999998e-35	NTclustered	gi\|470490269\|ref\|NR_076978.1\|	1134405	g162334	i0	86.301	34.39375	146	20	91	0	2	147	303	158	Melioribacter roseus strain P3M-2 23S ribosomal RNA gene, complete sequence	blastn	5503	159	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacter	Melioribacter roseus
22278450	22278450	PRJNA630162_P_NODE_100378_length_185_cov_2.352941_g98855_i0	PRJNA630162	100378	185	2.352941	4.35294085	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	176	8.98e-40	NTclustered	gi\|2874253742\|emb\|OY969585.1\|	2026749	g98855	i0	84.53	97.4054054054054	181	25	97	3	5	184	460542	460364	MAG: Ignavibacteriota bacterium isolate MFD03726.bin.c.11 genome assembly, chromosome: 1	blastn	18020	176	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
25377956	25377956	PRJNA630162_P_NODE_63400_length_222_cov_1.705202_g61877_i0	PRJNA630162	63400	222	1.705202	3.78554844	Pseudomonadati	3379134	Bacteria	Bacteria	305	1.37e-78	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g61877	i0	92.202	357.175675675676	218	14	97	3	7	222	1602399	1602615	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	79293	305	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria 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);;