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

5 rows where bioproject = "PRJNA914897", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

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
7273128	7273128	PRJNA914897_P_NODE_33306_length_269_cov_1.571429_g32882_i0	PRJNA914897	33306	269	1.571429	4.22714401	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	291	4.8000000000000006e-74	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g32882	i0	86.347	158.189591078067	271	32	100	5	1	269	3042328	3042595	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	42553	291	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
26620315	26620315	PRJNA914897_P_NODE_38301_length_248_cov_0.880000_g37877_i0	PRJNA914897	38301	248	0.88	2.1824	FCB group	1783270	Bacteria	Bacteria	66.6	1.74e-11	NR	HEX8361622.1	2029185	g37877	i0	40.3	6.41129032258065	77	45	91.9	1	235	8	30	106	HEX8361622.1 aquaporin [Longimicrobium sp.]	diamond	1590	66.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
27435637	27435637	PRJNA914897_P_NODE_4703_length_927_cov_1.512881_g4380_i0	PRJNA914897	4703	927	1.512881	14.02440687	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	49.7	0.0107	NR	HET9151876.1	2448054	g4380	i0	30	0.453074433656958	140	89	45.3	5	4	423	74	204	HET9151876.1 phosphoglycerate kinase [Gemmatimonadales bacterium]	diamond	420	49.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30593190	30593190	PRJNA914897_P_NODE_7573_length_706_cov_2.173776_g7179_i0	PRJNA914897	7573	706	2.173776	15.34685856	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	95.1	1.18e-19	NR	HEX7118166.1	2910168	g7179	i0	31.9	0.985835694050991	232	125	96.5	6	24	704	5	208	HEX7118166.1 aquaporin [Longimicrobiales bacterium]	diamond	696	95.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
31478416	31478416	PRJNA914897_P_NODE_21936_length_356_cov_2.505300_g21512_i0	PRJNA914897	21936	356	2.5053	8.918868	Longimicrobium terrae	1639882	Bacteria	Bacteria	78.2	2.9e-14	NR	WP_170037498.1	1639882	g21512	i0	40.4	0.960674157303371	114	64	96.1	2	344	3	87	196	WP_170037498.1 hydrolase [Longimicrobium terrae]	diamond	342	78.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium terrae

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