metadata: contig_metadata: 11 rows where bioproject = "PRJEB7799", tax_clade = "FCB group" and tax

11 rows where bioproject = "PRJEB7799", 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
25800922	25800922	PRJEB7799p_S_NODE_13755_length_180_cov_2.751724_g13732_i0	PRJEB7799	13755	180	2.751724	4.9531032	Pelodictyon luteolum DSM 273	319225	Bacteria	Bacteria	228	2.3599999999999996e-55	NTclustered	gi\|78165794\|gb\|CP000096.1\|	319225	g13732	i0	89.444	61.2555555555556	180	19	100	0	1	180	746187	746008	Chlorobium luteolum DSM 273, complete genome	blastn	11026	228	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
32957577	32957577	PRJEB7799c_S_NODE_5370_length_195_cov_2.312500_g5347_i0	PRJEB7799	5370	195	2.3125	4.509375	Pseudomonadati	3379134	Bacteria	Bacteria	94.7	3.439999999999999e-23	NR	WP_303680833.1	1100	g5347	i0	88.5	3.2	52	6	80	0	40	195	1	52	WP_303680833.1 MarR family EPS-associated transcriptional regulator [Pelodictyon luteolum]	diamond	624	94.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
32964771	32964771	PRJEB7799l_S_NODE_122_length_870_cov_16.623952_g110_i0	PRJEB7799	122	870	16.623952	144.6283824	Pelodictyon luteolum	1100	Bacteria	Bacteria	206	1.63e-63	NR	WP_303680833.1	1100	g110	i0	87	0.424137931034483	123	16	42.4	0	716	348	1	123	WP_303680833.1 MarR family EPS-associated transcriptional regulator [Pelodictyon luteolum]	diamond	369	206	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
32981218	32981218	PRJEB7799a_S_NODE_12827_length_172_cov_1.379562_g12792_i0	PRJEB7799	12827	172	1.379562	2.37284664	Pelodictyon luteolum	1100	Bacteria	Bacteria	99.8	2.6e-25	NR	WP_303680833.1	1100	g12792	i0	89.1	2.84302325581395	55	6	95.9	0	171	7	4	58	WP_303680833.1 MarR family EPS-associated transcriptional regulator [Pelodictyon luteolum]	diamond	489	99.8	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
32991690	32991690	PRJEB7799a_S_NODE_10011_length_184_cov_1.590604_g9976_i0	PRJEB7799	10011	184	1.590604	2.92671136	Pseudomonadati	3379134	Bacteria	Bacteria	67.8	2.49e-11	NR	MEI7933563.1	2067991	g9976	i0	63.9	1.77717391304348	61	17	96.2	2	183	7	441	498	MEI7933563.1 hypothetical protein [Chlorobiaceae bacterium]	diamond	327	68.2	0.994134897360704	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae		Chlorobiaceae bacterium
32998824	32998824	PRJEB7799l_S_NODE_7011_length_192_cov_1.598726_g6982_i0	PRJEB7799	7011	192	1.598726	3.06955392	Chlorobium phaeobacteroides	1096	Bacteria	Bacteria	110	1.22e-28	NR	WP_011744526.1	1096	g6982	i0	76.6	1	64	15	100	0	192	1	20	83	WP_011744526.1 DUF1643 domain-containing protein [Chlorobium phaeobacteroides]	diamond	192	110	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeobacteroides
33033203	33033203	PRJEB7799n_S_NODE_4412_length_219_cov_4.114130_g4375_i0	PRJEB7799	4412	219	4.11413	9.0099447	Chlorobium phaeobacteroides	1096	Bacteria	Bacteria	120	2.01e-32	NR	WP_011744526.1	1096	g4375	i0	69	1.93150684931507	71	22	97.3	0	2	214	2	72	WP_011744526.1 DUF1643 domain-containing protein [Chlorobium phaeobacteroides]	diamond	423	120	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeobacteroides
33084592	33084592	PRJEB7799p_S_NODE_366_length_540_cov_17.764356_g350_i0	PRJEB7799	366	540	17.764356	95.9275224	Pelodictyon luteolum	1100	Bacteria	Bacteria	206	3.24e-65	NR	WP_303680833.1	1100	g350	i0	87	0.683333333333333	123	16	68.3	0	409	41	1	123	WP_303680833.1 MarR family EPS-associated transcriptional regulator [Pelodictyon luteolum]	diamond	369	206	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
33134934	33134934	PRJEB7799e_S_NODE_2295_length_288_cov_3.652174_g2218_i0	PRJEB7799	2295	288	3.652174	10.51826112	Pelodictyon luteolum	1100	Bacteria	Bacteria	129	3.41e-36	NR	WP_303680833.1	1100	g2218	i0	87.2	0.8125	78	10	81.3	0	2	235	46	123	WP_303680833.1 MarR family EPS-associated transcriptional regulator [Pelodictyon luteolum]	diamond	234	129	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
33169927	33169927	PRJEB7799p_S_NODE_7048_length_210_cov_3.525714_g7025_i0	PRJEB7799	7048	210	3.525714	7.4039994	Chlorobium phaeobacteroides	1096	Bacteria	Bacteria	117	2.8699999999999997e-31	NR	WP_011744526.1	1096	g7025	i0	74.2	0.942857142857143	66	17	94.3	0	202	5	7	72	WP_011744526.1 DUF1643 domain-containing protein [Chlorobium phaeobacteroides]	diamond	198	117	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeobacteroides
33179414	33179414	PRJEB7799e_S_NODE_6544_length_194_cov_8.880503_g6467_i0	PRJEB7799	6544	194	8.880503	17.22817582	Pseudomonadati	3379134	Bacteria	Bacteria	85.5	1.45e-19	NR	WP_303680833.1	1100	g6467	i0	87.2	3.60309278350515	47	6	72.7	0	143	3	1	47	WP_303680833.1 MarR family EPS-associated transcriptional regulator [Pelodictyon luteolum]	diamond	699	85.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum

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