metadata: contig_metadata: 6 rows where bioproject = "PRJEB66218", tax_clade = "FCB group" and tax

6 rows where bioproject = "PRJEB66218", 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
17983873	17983873	PRJEB66218_P_NODE_2035_length_3237_cov_5.239295_g1688_i0	PRJEB66218	2035	3237	5.239295	169.59597915	Chlorobium phaeovibrioides	1094	Bacteria	Bacteria	665	0	NTclustered	gi\|1746300117\|gb\|CP041698.1\|	1094	g1688	i0	72.246	6.66388631448872	2324	588	71	50	97	2389	1289938	1292235	Chlorobium phaeovibrioides strain PhvTcv-s14 chromosome, complete genome	blastn	21571	665	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeovibrioides
28202466	28202466	PRJEB66218_P_NODE_57466_length_437_cov_2.074468_g55046_i0	PRJEB66218	57466	437	2.074468	9.06542516	Chlorobiaceae bacterium	2067991	Bacteria	Bacteria	197	6.74e-60	NR	NTW70471.1	2067991	g55046	i0	73.2	0.871853546910755	127	34	87.2	0	382	2	5	131	NTW70471.1 NAD-dependent DNA ligase [Chlorobiaceae bacterium]	diamond	381	197	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae		Chlorobiaceae bacterium
29805692	29805692	PRJEB66218_P_NODE_139231_length_252_cov_0.989529_g136802_i0	PRJEB66218	139231	252	0.989529	2.49361308	Pseudomonadati	3379134	Bacteria	Bacteria	52.4	4.28e-6	NR	ABB24164.1	319225	g136802	i0	50.8	2.30952380952381	59	29	70.2	0	74	250	40	98	ABB24164.1 hypothetical protein Plut_1304 [Pelodictyon luteolum DSM 273]	diamond	582	52.4	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
29907847	29907847	PRJEB66218_P_NODE_246431_length_193_cov_2.068182_g243999_i0	PRJEB66218	246431	193	2.068182	3.99159126	Chloroherpeton thalassium	100716	Bacteria	Bacteria	58.2	6.9e-8	NR	WP_012499151.1	100716	g243999	i0	72.2	0.559585492227979	36	10	56	0	1	108	8	43	WP_012499151.1 tetratricopeptide repeat protein [Chloroherpeton thalassium]	diamond	108	58.2	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chloroherpetonaceae	Chloroherpeton	Chloroherpeton thalassium
30343382	30343382	PRJEB66218_P_NODE_206332_length_209_cov_0.878378_g203902_i0	PRJEB66218	206332	209	0.878378	1.83581002	Pseudomonadati	3379134	Bacteria	Bacteria	133	1.0400000000000001e-36	NR	WP_085659405.1	1974213	g203902	i0	92.8	2.97129186602871	69	5	99	0	2	208	138	206	WP_085659405.1 response regulator [Prosthecochloris sp. HL-130-GSB]	diamond	621	134	0.992537313432836	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. HL-130-GSB
31835449	31835449	PRJEB66218_P_NODE_181617_length_220_cov_1.295597_g179187_i0	PRJEB66218	181617	220	1.295597	2.8503134	Chlorobium ferrooxidans	84205	Bacteria	Bacteria	56.2	4.8e-7	NR	WP_006366551.1	84205	g179187	i0	64.1	1.06363636363636	39	14	53.2	0	3	119	734	772	WP_006366551.1 AVAST type 3 anti-phage nuclease/ATPase Avs3a [Chlorobium ferrooxidans]	diamond	234	56.2	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium ferrooxidans

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