metadata: contig_metadata: 4 rows where bioproject = "PRJNA770826", tax_clade = "FCB group" and tax

4 rows where bioproject = "PRJNA770826", 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_species
22884404	22884404	PRJNA770826_P_NODE_11878_length_234_cov_1.118919_g11707_i0	PRJNA770826	11878	234	1.118919	2.61827046	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	96.7	6.66e-22	NR	MBX3009837.1	2614255	g11707	i0	68.1	0.884615384615385	69	22	88.5	0	27	233	165	233	MBX3009837.1 EF-hand domain-containing protein [Melioribacteraceae bacterium]	diamond	207	96.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
28316664	28316664	PRJNA770826_P_NODE_38586_length_164_cov_0.904348_g38415_i0	PRJNA770826	38586	164	0.904348	1.48313072	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	71.6	6.97e-13	NR	MEO8666492.1	2053306	g38415	i0	68.5	1.97560975609756	54	17	98.8	0	3	164	1	54	MEO8666492.1 acetyl-CoA C-acetyltransferase [Ignavibacteria bacterium]	diamond	324	71.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
28474487	28474487	PRJNA770826_P_NODE_19006_length_186_cov_1.131387_g18835_i0	PRJNA770826	19006	186	1.131387	2.10437982	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	45.1	0.00273	NR	HPN39875.1	2614255	g18835	i0	36.7	3.25806451612903	60	38	96.8	0	7	186	87	146	HPN39875.1 choice-of-anchor A family protein [Melioribacteraceae bacterium]	diamond	606	45.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
28506047	28506047	PRJNA770826_P_NODE_5207_length_373_cov_1.123457_g5036_i0	PRJNA770826	5207	373	1.123457	4.19049461	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	64.3	4.44e-9	NR	MBI5402044.1	2026749	g5036	i0	43.6	0.627345844504021	78	36	62.7	2	366	133	220	289	MBI5402044.1 T9SS type A sorting domain-containing protein [Ignavibacteriota bacterium]	diamond	234	64.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota 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);;