metadata: contig_metadata: 6 rows where bioproject = "PRJNA1104180", tax_clade = "FCB group" and tax

6 rows where bioproject = "PRJNA1104180", 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
27162294	27162294	PRJNA1104180_P_NODE_20382_length_251_cov_0.865169_g20239_i0	PRJNA1104180	20382	251	0.865169	2.17157419	Longimicrobium sp.	2029185	Bacteria	Bacteria	98.2	2.73e-22	NR	HEU4557893.1	2029185	g20239	i0	84.9	1.24302788844622	53	8	63.3	0	159	1	191	243	HEU4557893.1 toll/interleukin-1 receptor domain-containing protein [Longimicrobium sp.]	diamond	312	98.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
27825922	27825922	PRJNA1104180_P_NODE_14644_length_279_cov_1.922330_g14502_i0	PRJNA1104180	14644	279	1.92233	5.3633007	Gemmatimonas sp.	1962908	Bacteria	Bacteria	75.9	1.22e-13	NR	MQA89887.1	1962908	g14502	i0	95.1	0.881720430107527	41	2	44.1	0	1	123	413	453	MQA89887.1 response regulator [Gemmatimonas sp.]	diamond	246	75.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
28141773	28141773	PRJNA1104180_P_NODE_13865_length_284_cov_1.407583_g13723_i0	PRJNA1104180	13865	284	1.407583	3.99753572	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	130	1.18e-32	NR	MBV9772695.1	2026742	g13723	i0	67.4	0.971830985915493	92	30	97.2	0	278	3	251	342	MBV9772695.1 FdhF/YdeP family oxidoreductase [Gemmatimonadota bacterium]	diamond	276	130	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29404538	29404538	PRJNA1104180_P_NODE_12049_length_296_cov_3.161435_g11907_i0	PRJNA1104180	12049	296	3.161435	9.3578476	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	108	2.86e-27	NR	GJG85058.1	2839016	g11907	i0	58.1	1.18581081081081	117	9	78	1	3	233	55	171	GJG85058.1 50S ribosomal protein L10 [Gemmatimonadetes bacterium T265]	diamond	351	108	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
30825949	30825949	PRJNA1104180_P_NODE_27294_length_232_cov_2.276730_g27151_i0	PRJNA1104180	27294	232	2.27673	5.2820136	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	83.2	1.8e-16	NR	CAA9357910.1	246130	g27151	i0	62	0.918103448275862	71	26	91.8	1	4	216	115	184	CAA9357910.1 MAG: hypothetical protein AVDCRST_MAG40-3281, partial [uncultured Gemmatimonadaceae bacterium]	diamond	213	83.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
31837549	31837549	PRJNA1104180_P_NODE_25677_length_242_cov_0.911243_g25534_i0	PRJNA1104180	25677	242	0.911243	2.20520806	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	79.7	3.52e-15	NR	HEY3013006.1	2448054	g25534	i0	73.7	2.35537190082645	57	15	70.7	0	171	1	6	62	HEY3013006.1 PAS domain S-box protein [Gemmatimonadales bacterium]	diamond	570	79.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;