metadata: contig_metadata: 14 rows where bioproject = "PRJNA890871" and tax

14 rows where bioproject = "PRJNA890871" 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
22541450	22541450	PRJNA890871_P_NODE_48278_length_269_cov_1.505102_g48143_i0	PRJNA890871	48278	269	1.505102	4.04872438	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	173	7.36e-50	NR	HMS34157.1	2053306	g48143	i0	91	5.95539033457249	89	8	99.3	0	268	2	26	114	HMS34157.1 dihydrolipoyl dehydrogenase [Ignavibacteria bacterium]	diamond	1602	173	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
26643888	26643888	PRJNA890871_P_NODE_69441_length_248_cov_1.360000_g69306_i0	PRJNA890871	69441	248	1.36	3.3728	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	149	1.3e-40	NR	HWA05074.1	2053306	g69306	i0	81.7	0.991935483870968	82	15	99.2	0	3	248	219	300	HWA05074.1 hypothetical protein [Ignavibacteria bacterium]	diamond	246	149	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
26897471	26897471	PRJNA890871_P_NODE_3701_length_789_cov_6.072626_g3571_i0	PRJNA890871	3701	789	6.072626	47.91301914	Melioribacter sp.	2052167	Bacteria	Bacteria	47.4	0.0189	NR	MCX7797202.1	2052167	g3571	i0	41.3	0.239543726235741	63	37	24	0	204	16	1	63	MCX7797202.1 DUF502 domain-containing protein [Melioribacter sp.]	diamond	189	47.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacter	Melioribacter sp.
27118519	27118519	PRJNA890871_P_NODE_4162_length_743_cov_2.541791_g4028_i0	PRJNA890871	4162	743	2.541791	18.88550713	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	233	1.06e-72	NR	HED37266.1	2053306	g4028	i0	66.9	4.65545087483176	166	52	67	1	236	733	1	163	HED37266.1 Dam family site-specific DNA-(adenine-N6)-methyltransferase [Ignavibacteria bacterium]	diamond	3459	233	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
27592812	27592812	PRJNA890871_P_NODE_67964_length_249_cov_0.875000_g67829_i0	PRJNA890871	67964	249	0.875	2.17875	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	92.4	2.98e-21	NR	MBI3257902.1	2026749	g67829	i0	65.1	1.48192771084337	63	22	75.9	0	4	192	125	187	MBI3257902.1 RNA polymerase sigma factor [Ignavibacteriota bacterium]	diamond	369	92.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
28350399	28350399	PRJNA890871_P_NODE_85866_length_241_cov_0.916667_g85731_i0	PRJNA890871	85866	241	0.916667	2.20916747	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	93.2	2.46e-20	NR	MBK7987182.1	2053306	g85731	i0	53.8	1.94190871369295	78	36	97.1	0	241	8	105	182	MBK7987182.1 glycosyltransferase family 9 protein [Ignavibacteria bacterium]	diamond	468	93.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
28958372	28958372	PRJNA890871_P_NODE_64548_length_250_cov_1.740113_g64413_i0	PRJNA890871	64548	250	1.740113	4.3502825	Pseudomonadati	3379134	Bacteria	Bacteria	119	3.51e-29	NR	MBK7988491.1	2053306	g64413	i0	75.6	2.952	82	20	98.4	0	249	4	386	467	MBK7988491.1 hypothetical protein [Ignavibacteria bacterium]	diamond	738	119	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29486864	29486864	PRJNA890871_P_NODE_22750_length_346_cov_3.073260_g22615_i0	PRJNA890871	22750	346	3.07326	10.6334796	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	52	6.62e-5	NR	MFA5010493.1	2053306	g22615	i0	49	1.86416184971098	49	24	41.6	1	55	198	423	471	MFA5010493.1 cysteine--tRNA ligase [Ignavibacteria bacterium]	diamond	645	52	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29589297	29589297	PRJNA890871_P_NODE_63710_length_251_cov_0.865169_g63575_i0	PRJNA890871	63710	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	53.9	4.84e-6	NR	MBK7986490.1	2053306	g63575	i0	36.6	2.9402390438247	82	49	96.8	2	251	9	1274	1353	MBK7986490.1 choice-of-anchor D domain-containing protein [Ignavibacteria bacterium]	diamond	738	53.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30253165	30253165	PRJNA890871_P_NODE_71412_length_247_cov_1.678161_g71277_i0	PRJNA890871	71412	247	1.678161	4.14505767	Pseudomonadati	3379134	Bacteria	Bacteria	108	2.05e-25	NR	MBK7987883.1	2053306	g71277	i0	59.8	6.98380566801619	82	33	99.6	0	246	1	1545	1626	MBK7987883.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium]	diamond	1725	109	0.990825688073395	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30750742	30750742	PRJNA890871_P_NODE_78134_length_244_cov_1.637427_g77999_i0	PRJNA890871	78134	244	1.637427	3.99532188	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	115	6.28e-28	NR	MBK7987386.1	2053306	g77999	i0	66.7	0.995901639344262	81	27	99.6	0	1	243	351	431	MBK7987386.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Ignavibacteria bacterium]	diamond	243	115	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31256239	31256239	PRJNA890871_P_NODE_92835_length_222_cov_4.308725_g92700_i0	PRJNA890871	92835	222	4.308725	9.5653695	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	89.7	8.3e-19	NR	MBP9097018.1	2053306	g92700	i0	54.8	2.97297297297297	73	33	98.6	0	1	219	45	117	MBP9097018.1 primosomal protein N' [Ignavibacteria bacterium]	diamond	660	89.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31422192	31422192	PRJNA890871_P_NODE_86016_length_241_cov_0.916667_g85881_i0	PRJNA890871	86016	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	115	9.72e-28	NR	MBK7985455.1	2053306	g85881	i0	77.2	1.96680497925311	79	17	97.1	1	6	239	224	302	MBK7985455.1 DUF4397 domain-containing protein [Ignavibacteria bacterium]	diamond	474	116	0.991379310344828	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31952032	31952032	PRJNA890871_P_NODE_4397_length_720_cov_4.089645_g4263_i0	PRJNA890871	4397	720	4.089645	29.445444	Ignavibacteria bacterium GWA2_35_8	1798417	Bacteria	Bacteria	65.9	2.05e-8	NR	OGU17463.1	1798417	g4263	i0	53.7	1.80833333333333	54	25	22.5	0	589	428	361	414	OGU17463.1 MAG: histidine--tRNA ligase [Ignavibacteria bacterium GWA2_35_8]	diamond	1302	65.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium GWA2_35_8

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