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

4 rows where bioproject = "PRJNA1166865", 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
19439991	19439991	PRJNA1166865_P_NODE_91096_length_243_cov_0.905882_g90855_i0	PRJNA1166865	91096	243	0.905882	2.20129326	Chlorobiaceae	191412	Bacteria	Bacteria	121	6.68e-30	NR	WP_012466267.1	1092	g90855	i0	68.3	5.06172839506173	82	25	100	1	1	243	347	428	WP_012466267.1 phosphoketolase [Chlorobium limicola]	diamond	1230	121	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium limicola
24539529	24539529	PRJNA1166865_P_NODE_70920_length_260_cov_1.647059_g70679_i0	PRJNA1166865	70920	260	1.647059	4.2823534	root	1	Root_unresolved	Root_unresolved	91.7	2.24e-19	NR	MEI6691626.1	1095	g70679	i0	48.3	14.4692307692308	87	44	99.2	1	3	260	92	178	MEI6691626.1 aldehyde dehydrogenase family protein [Chlorobium sp.]	diamond	3762	92.4	0.992424242424242	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium sp.
27767281	27767281	PRJNA1166865_P_NODE_83204_length_247_cov_0.885057_g82963_i0	PRJNA1166865	83204	247	0.885057	2.18609079	Chlorobiota bacterium	2268192	Bacteria	Bacteria	65.9	2.54e-10	NR	MCI0448925.1	2268192	g82963	i0	36.5	5.85425101214575	74	44	89.9	1	11	232	10	80	MCI0448925.1 NAD(P)H-dependent oxidoreductase [Chlorobiota bacterium]	diamond	1446	65.9	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
29188106	29188106	PRJNA1166865_P_NODE_75769_length_251_cov_0.865169_g75528_i0	PRJNA1166865	75769	251	0.865169	2.17157419	Chlorobium sp. KB	1095	Bacteria	Bacteria	63.5	1.93e-9	NR	WP_076790820.1	1917528	g75528	i0	51.5	1.57768924302789	66	31	78.9	1	49	246	397	461	WP_076790820.1 PAS domain S-box protein [Chlorobium sp. KB01]	diamond	396	63.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium sp. KB01

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