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

4 rows where bioproject = "PRJNA376117", 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
4227281	4227281	PRJNA376117_P_NODE_43944_length_241_cov_1.375000_g43642_i0	PRJNA376117	43944	241	1.375	3.31375	Chloroherpeton thalassium	100716	Bacteria	Bacteria	60.2	1.3e-4	NTclustered	gi\|193087197\|gb\|CP001100.1\|	517418	g43642	i0	94.737	0.157676348547718	38	2	16	0	202	239	1858985	1858948	Chloroherpeton thalassium ATCC 35110, complete genome	blastn	38	60.2	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chloroherpetonaceae	Chloroherpeton	Chloroherpeton thalassium
27296144	27296144	PRJNA376117_P_NODE_23043_length_289_cov_1.425926_g22741_i0	PRJNA376117	23043	289	1.425926	4.12092614	Chlorobiota bacterium	2268192	Bacteria	Bacteria	50.4	1.32e-4	NR	NOY36184.1	2268192	g22741	i0	33	0.975778546712803	94	55	95.5	2	4	279	1276	1363	NOY36184.1 T9SS type A sorting domain-containing protein [Chlorobiota bacterium]	diamond	282	50.4	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
29523525	29523525	PRJNA376117_P_NODE_18710_length_319_cov_2.186992_g18408_i0	PRJNA376117	18710	319	2.186992	6.97650448	Chlorobium	1091	Bacteria	Bacteria	70.5	1.24e-11	NR	WP_160460220.1	1094	g18408	i0	38.3	1.49529780564263	81	50	76.2	0	313	71	263	343	WP_160460220.1 SDR family oxidoreductase [Chlorobium phaeovibrioides]	diamond	477	70.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeovibrioides
32003155	32003155	PRJNA376117_P_NODE_32318_length_256_cov_1.661202_g32016_i0	PRJNA376117	32318	256	1.661202	4.25267712	Chlorobiota bacterium	2268192	Bacteria	Bacteria	48.9	7.12e-5	NR	NOY06377.1	2268192	g32016	i0	38	0.92578125	79	47	90.2	2	18	248	1	79	NOY06377.1 peptidase M28 family protein [Chlorobiota bacterium]	diamond	237	48.9	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota 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);;