metadata: contig_metadata: 5 rows where bioproject = "PRJNA1136957", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA1136957", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
9212622	9212622	PRJNA1136957_S_NODE_5008_length_354_cov_2.715254_g4911_i0	PRJNA1136957	5008	354	2.715254	9.61199916	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g4911	i0	100	0.0790960451977401	28	0	8	0	210	237	7263647	7263620	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
27038720	27038720	PRJNA1136957_S_NODE_10302_length_266_cov_1.420290_g10205_i0	PRJNA1136957	10302	266	1.42029	3.7779714	Anaerolinea sp.	1872519	Bacteria	Bacteria	43.5	0.024	NR	MBA4181095.1	1872519	g10205	i0	37	0.518796992481203	46	29	51.9	0	129	266	10	55	MBA4181095.1 hypothetical protein [Anaerolinea sp.]	diamond	138	43.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea sp.
27575906	27575906	PRJNA1136957_S_NODE_3704_length_393_cov_7.449102_g3607_i0	PRJNA1136957	3704	393	7.449102	29.27497086	Anaerolineae bacterium	2052143	Bacteria	Bacteria	47	9.96e-4	NR	HJW83703.1	2052143	g3607	i0	28.3	1.54198473282443	99	66	74.8	2	367	74	6	100	HJW83703.1 DUF4286 family protein [Anaerolineae bacterium]	diamond	606	47	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29344127	29344127	PRJNA1136957_S_NODE_14349_length_228_cov_2.526627_g14252_i0	PRJNA1136957	14349	228	2.526627	5.76070956	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	43.9	0.0117	NR	MAU55661.1	2026734	g14252	i0	38.3	0.789473684210526	60	34	75	2	218	48	304	363	MAU55661.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	180	43.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32220147	32220147	PRJNA1136957_S_NODE_9978_length_270_cov_1.146919_g9881_i0	PRJNA1136957	9978	270	1.146919	3.0966813	Anaerolinea thermophila	167964	Bacteria	Bacteria	73.2	4.42e-13	NR	WP_013561055.1	167964	g9881	i0	61	2.53333333333333	59	23	65.6	0	92	268	1	59	WP_013561055.1 aldo/keto reductase [Anaerolinea thermophila]	diamond	684	73.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila

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