metadata: contig_metadata: 5 rows where bioproject = "PRJNA1160211", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA1160211", 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
27672458	27672458	PRJNA1160211_S_NODE_70404_length_521_cov_0.930804_g69197_i0	PRJNA1160211	70404	521	0.930804	4.84948884	Ignavibacterium sp.	2651167	Bacteria	Bacteria	75.1	3.83e-12	NR	MEJ5263615.1	2651167	g69197	i0	28.5	0.990403071017274	172	118	97.3	3	4	510	379	548	MEJ5263615.1 ATP-binding protein [Ignavibacterium sp.]	diamond	516	75.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
30198165	30198165	PRJNA1160211_S_NODE_195212_length_316_cov_3.403292_g193979_i0	PRJNA1160211	195212	316	3.403292	10.75440272	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	101	2.62e-22	NR	HED37809.1	2053306	g193979	i0	68.1	0.655063291139241	69	22	65.5	0	26	232	1362	1430	HED37809.1 hypothetical protein [Ignavibacteria bacterium]	diamond	207	101	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30640566	30640566	PRJNA1160211_S_NODE_119793_length_421_cov_10.232759_g118564_i0	PRJNA1160211	119793	421	10.232759	43.07991539	Melioribacter sp.	2052167	Bacteria	Bacteria	96.3	7.209999999999999e-23	NR	NJD21331.1	2052167	g118564	i0	59.3	0.648456057007126	91	37	64.8	0	399	127	8	98	NJD21331.1 hypothetical protein [Melioribacter sp.]	diamond	273	96.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacter	Melioribacter sp.
31525904	31525904	PRJNA1160211_S_NODE_91296_length_474_cov_14.850374_g90073_i0	PRJNA1160211	91296	474	14.850374	70.39077276	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	112	1.4700000000000002e-27	NR	KAF0153903.1	2053306	g90073	i0	41.6	5.24683544303798	149	79	90.5	4	444	16	66	212	KAF0153903.1 MAG: hypothetical protein FD188_3329 [Ignavibacteria bacterium]	diamond	2487	112	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32063412	32063412	PRJNA1160211_S_NODE_157218_length_364_cov_29.914089_g155985_i0	PRJNA1160211	157218	364	29.914089	108.88728396	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	90.5	1.32e-19	NR	MDR3665912.1	2651163	g155985	i0	75.5	0.403846153846154	49	12	40.4	0	179	33	1	49	MDR3665912.1 CRISPR-associated endoribonuclease Cas6 [Ignavibacteriaceae bacterium]	diamond	147	90.5	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);;