metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA695140" 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
4504155	4504155	PRJNA695140_S_NODE_504_length_790_cov_10.625498_g366_i0	PRJNA695140	504	790	10.625498	83.9414342	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	654	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g366	i0	82.214	75.773417721519	804	101	99	31	7	788	273045	273828	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	59861	654	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8329211	8329211	PRJNA695140_S_NODE_1327_length_463_cov_42.577465_g1148_i0	PRJNA695140	1327	463	42.577465	197.13366295	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	573	7.759999999999997e-159	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g1148	i0	89.009	199.533477321814	464	49	100	2	1	463	275042	275504	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	92384	573	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13429853	13429853	PRJNA695140_S_NODE_2691_length_318_cov_8.978648_g2510_i0	PRJNA695140	2691	318	8.978648	28.55210064	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	291	5.8e-74	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g2510	i0	83.987	162.679245283019	306	45	96	4	8	311	274932	274629	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	51732	291	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15210162	15210162	PRJNA695140_S_NODE_3832_length_267_cov_2.456522_g3651_i0	PRJNA695140	3832	267	2.456522	6.55891374	Roseiflexus	120961	Bacteria	Bacteria	209	1.37e-49	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g3651	i0	85.714	5.53183520599251	210	16	76	13	3	205	1427	1225	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	1477	209	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
16484469	16484469	PRJNA695140_S_NODE_8873_length_178_cov_2.446809_g8692_i0	PRJNA695140	8873	178	2.446809	4.35532002	Bacillati	1783272	Bacteria	Bacteria	128	2.43e-25	NTclustered	gi\|2621704004\|emb\|OY762959.1\|	2026734	g8692	i0	82.759	71.3707865168539	145	23	81	2	33	176	2495912	2495769	MAG: Dehalococcoidia bacterium isolate a8fc5444-7059-4be1-bdcb-92646be6befe genome assembly, chromosome: 1	blastn	12704	128	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
18528049	18528049	PRJNA695140_S_NODE_6915_length_200_cov_4.294479_g6734_i0	PRJNA695140	6915	200	4.294479	8.588958	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	263	7.369999999999999e-66	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g6734	i0	91.192	692.725	193	17	97	0	3	195	320254	320062	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	138545	263	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
19033344	19033344	PRJNA695140_S_NODE_5855_length_217_cov_3.583333_g5674_i0	PRJNA695140	5855	217	3.583333	7.77583261	Chloroflexus	1107	Bacteria	Bacteria	204	5e-48	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g5674	i0	88	35.4101382488479	175	17	80	4	13	185	591	419	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	7684	204	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
19802954	19802954	PRJNA695140_S_NODE_336_length_995_cov_9.321503_g218_i0	PRJNA695140	336	995	9.321503	92.74895485	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	939	0	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g218	i0	84.2	123.705527638191	1000	122	99	30	5	994	607	1580	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	123087	939	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1

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