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

5 rows where bioproject = "PRJNA741997", tax_clade = "FCB group" and tax_phylum = "Chlorobiota"

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
27968497	27968497	PRJNA741997_P_NODE_41785_length_336_cov_1.463878_g40665_i0	PRJNA741997	41785	336	1.463878	4.91863008	Chlorobiota bacterium	2268192	Bacteria	Bacteria	54.3	4.55e-6	NR	MCI0450382.1	2268192	g40665	i0	33.3	0.9375	105	65	93.8	1	18	332	13	112	MCI0450382.1 aquaporin family protein [Chlorobiota bacterium]	diamond	315	54.3	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
28578627	28578627	PRJNA741997_P_NODE_27907_length_417_cov_1.186047_g26787_i0	PRJNA741997	27907	417	1.186047	4.94581599	Pseudomonadati	3379134	Bacteria	Bacteria	83.2	1.83e-15	NR	MDT7923550.1	2268192	g26787	i0	40.9	5.35251798561151	127	64	89.9	4	376	2	14	131	MDT7923550.1 V-type H(+)-translocating pyrophosphatase [Chlorobiota bacterium]	diamond	2232	83.2	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
29042243	29042243	PRJNA741997_P_NODE_59648_length_279_cov_1.116505_g58528_i0	PRJNA741997	59648	279	1.116505	3.11504895	Chlorobiales bacterium	2723030	Bacteria	Bacteria	147	4.9399999999999986e-40	NR	MCG8375199.1	2723030	g58528	i0	73.9	2.96774193548387	92	24	98.9	0	278	3	218	309	MCG8375199.1 phosphoketolase family protein [Chlorobiales bacterium]	diamond	828	147	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales			Chlorobiales bacterium
30441943	30441943	PRJNA741997_P_NODE_35673_length_364_cov_0.769759_g34553_i0	PRJNA741997	35673	364	0.769759	2.80192276	Chlorobiaceae	191412	Bacteria	Bacteria	160	4.13e-43	NR	WP_011890465.1	1094	g34553	i0	64	9.3956043956044	114	37	94	1	343	2	48	157	WP_011890465.1 glutamine synthetase III [Chlorobium phaeovibrioides]	diamond	3420	161	0.993788819875776	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeovibrioides
32180839	32180839	PRJNA741997_P_NODE_44538_length_325_cov_1.424603_g43418_i0	PRJNA741997	44538	325	1.424603	4.62995975	Bacteria	2	Bacteria	Bacteria	77	9.46e-14	NR	WP_012498897.1	100716	g43418	i0	45.1	3.50769230769231	91	50	84	0	10	282	109	199	WP_012498897.1 choice-of-anchor I family protein [Chloroherpeton thalassium]	diamond	1140	77	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chloroherpetonaceae	Chloroherpeton	Chloroherpeton thalassium

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