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

5 rows where bioproject = "PRJNA1102048", 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
3570511	3570511	PRJNA1102048_P_NODE_13903_length_249_cov_0.875000_g13799_i0	PRJNA1102048	13903	249	0.875	2.17875	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	158	3.24e-44	NR	MBM3899139.1	2026742	g13799	i0	97.5	2.92771084337349	81	2	97.6	0	5	247	1	81	MBM3899139.1 DEAD/DEAH box helicase [Gemmatimonadota bacterium]	diamond	729	158	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27604945	27604945	PRJNA1102048_P_NODE_9484_length_284_cov_1.459716_g9380_i0	PRJNA1102048	9484	284	1.459716	4.14559344	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	105	1.16e-24	NR	RMH69234.1	2026742	g9380	i0	51.6	3.92957746478873	93	44	98.2	1	283	5	70	161	RMH69234.1 MAG: lipase [Gemmatimonadota bacterium]	diamond	1116	105	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28615214	28615214	PRJNA1102048_P_NODE_3007_length_485_cov_3.798544_g2903_i0	PRJNA1102048	3007	485	3.798544	18.4229384	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	159	1.15e-45	NR	HVQ46153.1	2448054	g2903	i0	55.3	14.9628865979381	150	66	92.8	1	8	457	21	169	HVQ46153.1 NAD(P)-dependent oxidoreductase [Gemmatimonadales bacterium]	diamond	7257	159	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30920938	30920938	PRJNA1102048_P_NODE_10634_length_271_cov_1.555556_g10530_i0	PRJNA1102048	10634	271	1.555556	4.21555676	Longimicrobium sp.	2029185	Bacteria	Bacteria	76.3	1.41e-14	NR	HEX2080112.1	2029185	g10530	i0	43.3	2.87822878228782	90	49	97.4	1	269	6	115	204	HEX2080112.1 hypothetical protein [Longimicrobium sp.]	diamond	780	76.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31227860	31227860	PRJNA1102048_P_NODE_14135_length_248_cov_0.880000_g14031_i0	PRJNA1102048	14135	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	49.3	1.53e-4	NR	MEX2283865.1	2026742	g14031	i0	51.1	2.00806451612903	47	23	56.9	0	145	5	133	179	MEX2283865.1 aquaporin [Gemmatimonadota bacterium]	diamond	498	49.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;