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

4 rows where bioproject = "PRJNA382357", 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
6781393	6781393	PRJNA382357_P_NODE_36286_length_378_cov_3.536278_g35547_i0	PRJNA382357	36286	378	3.536278	13.36713084	Chlorobiota bacterium	2268192	Bacteria	Bacteria	96.3	1.46e-20	NR	NPA67584.1	2268192	g35547	i0	50	3.26984126984127	106	30	84.1	1	318	1	146	228	NPA67584.1 bifunctional phosphopantothenoylcysteine decarboxylase/phosphopantothenate--cysteine ligase CoaBC [Chlorobiota bacterium]	diamond	1236	96.3	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
29428605	29428605	PRJNA382357_P_NODE_106569_length_235_cov_2.551724_g105830_i0	PRJNA382357	106569	235	2.551724	5.9965514	Prosthecochloris	1101	Bacteria	Bacteria	66.6	8.14e-11	NR	ANT65139.1	1868325	g105830	i0	87.9	1.68510638297872	33	4	42.1	0	144	46	71	103	ANT65139.1 putative transposase OrfB [Prosthecochloris sp. CIB 2401]	diamond	396	66.6	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. CIB 2401
29822074	29822074	PRJNA382357_P_NODE_113831_length_228_cov_4.556886_g113092_i0	PRJNA382357	113831	228	4.556886	10.38970008	Chlorobiaceae bacterium	2067991	Bacteria	Bacteria	84.3	6.69e-17	NR	NTU53713.1	2067991	g113092	i0	80.9	1.23684210526316	47	9	61.8	0	181	41	165	211	NTU53713.1 AAA family ATPase [Chlorobiaceae bacterium]	diamond	282	84.3	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae		Chlorobiaceae bacterium
32066450	32066450	PRJNA382357_P_NODE_102898_length_239_cov_1.460674_g102159_i0	PRJNA382357	102898	239	1.460674	3.49101086	Chlorobium phaeovibrioides	1094	Bacteria	Bacteria	46.2	0.00207	NR	WP_126383989.1	1094	g102159	i0	46.5	0.539748953974895	43	23	54	0	1	129	249	291	WP_126383989.1 PfkB family carbohydrate kinase [Chlorobium phaeovibrioides]	diamond	129	46.2	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeovibrioides

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