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

5 rows where bioproject = "PRJNA1122875", 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_species
26869774	26869774	PRJNA1122875_P_NODE_17681_length_397_cov_1.425926_g17457_i0	PRJNA1122875	17681	397	1.425926	5.66092622	Bacteria	2	Bacteria	Bacteria	82.4	1.13e-16	NR	MBK7868770.1	2049428	g17457	i0	39.7	6.53652392947103	121	66	91.4	3	2	364	31	144	MBK7868770.1 thermonuclease family protein [Ignavibacteriales bacterium]	diamond	2595	82.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriales bacterium
27344088	27344088	PRJNA1122875_P_NODE_28303_length_309_cov_1.305085_g28079_i0	PRJNA1122875	28303	309	1.305085	4.03271265	root	1	Root_unresolved	Root_unresolved	122	6.73e-30	NR	RPI05473.1	2026749	g28079	i0	57	6.79611650485437	100	43	97.1	0	304	5	321	420	RPI05473.1 MAG: alpha-keto acid decarboxylase family protein [Ignavibacteriota bacterium]	diamond	2100	122	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
29186139	29186139	PRJNA1122875_P_NODE_249_length_1718_cov_2.479635_g210_i0	PRJNA1122875	249	1718	2.479635	42.6001293	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	162	9.44e-41	NR	MBM4159664.1	2053306	g210	i0	38.6	1.534924330617	280	135	48.9	7	430	1269	102	344	MBM4159664.1 hypothetical protein [Ignavibacteria bacterium]	diamond	2637	162	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria		Ignavibacteria bacterium
31397500	31397500	PRJNA1122875_P_NODE_37256_length_272_cov_1.276382_g37032_i0	PRJNA1122875	37256	272	1.276382	3.47175904	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	54.3	4.51e-6	NR	MBL8005904.1	2053306	g37032	i0	37.9	2.92279411764706	87	48	94.9	2	263	6	365	446	MBL8005904.1 right-handed parallel beta-helix repeat-containing protein [Ignavibacteria bacterium]	diamond	795	54.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria		Ignavibacteria bacterium
31492415	31492415	PRJNA1122875_P_NODE_39416_length_264_cov_1.612565_g39192_i0	PRJNA1122875	39416	264	1.612565	4.2571716	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	55.5	1.57e-6	NR	MBS4029186.1	2049428	g39192	i0	38.6	4.21590909090909	83	46	89.8	2	253	17	444	525	MBS4029186.1 hypothetical protein [Ignavibacteriales bacterium]	diamond	1113	55.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriales 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);;