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

4 rows where bioproject = "PRJEB56027", 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
27760476	27760476	PRJEB56027_P_NODE_123144_length_246_cov_1.433526_g120335_i0	PRJEB56027	123144	246	1.433526	3.52647396	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	56.2	6.69e-7	NR	PYO90632.1	2026742	g120335	i0	44.4	0.98780487804878	81	42	95.1	2	246	13	152	232	PYO90632.1 MAG: hypothetical protein DMD66_01990 [Gemmatimonadota bacterium]	diamond	243	56.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28865202	28865202	PRJEB56027_P_NODE_117328_length_249_cov_1.715909_g114519_i0	PRJEB56027	117328	249	1.715909	4.27261341	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42.7	0.0396	NR	MBT3341496.1	2026742	g114519	i0	66.7	0.289156626506024	24	8	28.9	0	19	90	139	162	MBT3341496.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	72	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29774014	29774014	PRJEB56027_P_NODE_103591_length_264_cov_1.225131_g100782_i0	PRJEB56027	103591	264	1.225131	3.23434584	Roseisolibacter	2093335	Bacteria	Bacteria	134	7.31e-36	NR	WP_284351890.1	2014610	g100782	i0	71.3	3.95454545454545	87	25	98.9	0	3	263	251	337	WP_284351890.1 radical SAM family heme chaperone HemW [Roseisolibacter agri]	diamond	1044	135	0.992592592592593	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri
32088313	32088313	PRJEB56027_P_NODE_92178_length_279_cov_2.932039_g89369_i0	PRJEB56027	92178	279	2.932039	8.18038881	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	102	1.6500000000000002e-26	NR	HEX8904273.1	3047548	g89369	i0	76.9	0.698924731182796	65	15	69.9	0	3	197	10	74	HEX8904273.1 LysR substrate-binding domain-containing protein [Longimicrobiaceae bacterium]	diamond	195	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae 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);;