metadata: contig_metadata: 8 rows where bioproject = "PRJNA879067", tax_clade = "FCB group" and tax

8 rows where bioproject = "PRJNA879067", tax_clade = "FCB group" 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
14881796	14881796	PRJNA879067_P_NODE_105752_length_248_cov_0.880000_g102266_i0	PRJNA879067	105752	248	0.88	2.1824	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	129	2.65e-34	NR	HPS65019.1	2053306	g102266	i0	72	0.991935483870968	82	23	99.2	0	1	246	73	154	HPS65019.1 GTPase ObgE [Ignavibacteria bacterium]	diamond	246	129	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
21257382	21257382	PRJNA879067_P_NODE_51277_length_514_cov_4.582766_g47793_i0	PRJNA879067	51277	514	4.582766	23.55541724	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	152	4.82e-32	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g47793	i0	75.066	19.272373540856	381	67	71	24	134	497	428918	429287	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	9906	152	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
23807501	23807501	PRJNA879067_P_NODE_50579_length_520_cov_2.796421_g47097_i0	PRJNA879067	50579	520	2.796421	14.5413892	Bacteria	2	Bacteria	Bacteria	252	8.84e-82	NR	NJD21315.1	2052167	g47097	i0	77.9	15.5769230769231	149	33	86	0	448	2	76	224	NJD21315.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Melioribacter sp.]	diamond	8100	254	0.992125984251969	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacter	Melioribacter sp.
28286798	28286798	PRJNA879067_P_NODE_47526_length_546_cov_2.701903_g44052_i0	PRJNA879067	47526	546	2.701903	14.75239038	Ignavibacterium sp.	2651167	Bacteria	Bacteria	103	4.74e-22	NR	MCX7610381.1	2651167	g44052	i0	31.6	0.972527472527473	177	115	94.5	3	2	517	1335	1510	MCX7610381.1 hypothetical protein [Ignavibacterium sp.]	diamond	531	103	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
30750460	30750460	PRJNA879067_P_NODE_35574_length_678_cov_11.646281_g32172_i0	PRJNA879067	35574	678	11.646281	78.96178518	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	422	1.25e-142	NR	HPS65748.1	2053306	g32172	i0	88.4	0.955752212389381	216	25	95.6	0	25	672	354	569	HPS65748.1 TonB-dependent receptor [Ignavibacteria bacterium]	diamond	648	422	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31160755	31160755	PRJNA879067_P_NODE_62015_length_436_cov_2.432507_g58530_i0	PRJNA879067	62015	436	2.432507	10.60573052	Ignavibacteria bacterium RBG_16_34_14	1798433	Bacteria	Bacteria	101	3.98e-22	NR	OGU73788.1	1798433	g58530	i0	41	0.839449541284404	122	71	83.9	1	367	2	240	360	OGU73788.1 MAG: hypothetical protein A2V93_02850 [Ignavibacteria bacterium RBG_16_34_14]	diamond	366	101	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium RBG_16_34_14
31603956	31603956	PRJNA879067_P_NODE_90636_length_296_cov_1.381166_g87150_i0	PRJNA879067	90636	296	1.381166	4.08825136	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	152	1.17e-45	NR	HOP50147.1	2049428	g87150	i0	98.8	0.820945945945946	81	1	82.1	0	269	27	26	106	HOP50147.1 hypothetical protein [Ignavibacteriales bacterium]	diamond	243	152	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
32268427	32268427	PRJNA879067_P_NODE_6018_length_2055_cov_38.867306_g4453_i0	PRJNA879067	6018	2055	38.867306	798.7231383	Ignavibacteriales bacterium CG18_big_fil_WC_8_21_14_2_5	2049428	Bacteria	Bacteria	45.4	0.0326	NR	PIQ11508.1	1974047	g4453	i0	63.6	0.0481751824817518	33	12	4.8	0	167	265	43	75	PIQ11508.1 MAG: AbrB/MazE/SpoVT family DNA-binding domain-containing protein [Ignavibacteriales bacterium CG18_big_fil_WC_8_21_14_2_50_31_20]	diamond	99	45.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium CG18_big_fil_WC_8_21_14_2_50_31_20

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