metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA682078" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA682078" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1936406	1936406	PRJNA682078_P_NODE_215882_length_254_cov_1.342541_g214105_i0	PRJNA682078	215882	254	1.342541	3.41005414	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	287	5.81e-73	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g214105	i0	87.16	96.5236220472441	257	28	100	5	1	254	2270075	2270329	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	24517	287	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
1937329	1937329	PRJNA682078_P_NODE_253042_length_246_cov_2.520231_g251265_i0	PRJNA682078	253042	246	2.520231	6.19976826	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	399	6.889999999999999e-107	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g251265	i0	95.935	396.463414634146	246	10	100	0	1	246	670201	670446	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	97530	399	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4489015	4489015	PRJNA682078_P_NODE_242604_length_248_cov_0.880000_g240827_i0	PRJNA682078	242604	248	0.88	2.1824	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2814788352\|emb\|OY821663.2\|	2026734	g240827	i0	94.444	0.637096774193548	36	2	15	0	185	220	1776883	1776848	MAG: Dehalococcoidia bacterium isolate 04ec0ed8-798b-4585-a8de-e3c995a4e665 genome assembly, chromosome: 1	blastn	158	56.5	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
5763769	5763769	PRJNA682078_P_NODE_20625_length_751_cov_11.272861_g19017_i0	PRJNA682078	20625	751	11.272861	84.65918611	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	54.7	0.021	NTclustered	gi\|2531948656\|emb\|OY282446.1\|	3022862	g19017	i0	100	0.0386151797603196	29	0	4	0	524	552	1209822	1209850	MAG: Tepidiformaceae bacterium genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
7040279	7040279	PRJNA682078_P_NODE_265926_length_245_cov_0.895349_g264149_i0	PRJNA682078	265926	245	0.895349	2.19360505	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	298	2.57e-76	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g264149	i0	88.755	263.404081632653	249	21	100	7	1	245	672601	672356	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	64534	298	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8312569	8312569	PRJNA682078_P_NODE_176407_length_277_cov_1.132353_g174630_i0	PRJNA682078	176407	277	1.132353	3.13661781	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	60.2	1.52e-4	NTclustered	gi\|2893358428\|emb\|OZ220720.1\|	2026734	g174630	i0	94.737	0.252707581227437	38	2	14	0	2	39	1953156	1953193	MAG: Dehalococcoidia bacterium isolate c1ccb28d-03af-49da-9b48-84a9185dfe7a genome assembly, chromosome: 1	blastn	70	60.2	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
14688282	14688282	PRJNA682078_P_NODE_168592_length_281_cov_2.778846_g166815_i0	PRJNA682078	168592	281	2.778846	7.80855726	Chloroflexota bacterium	2026724	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2621702192\|emb\|OY760183.1\|	2026724	g166815	i0	100	0.099644128113879	28	0	10	0	22	49	580552	580579	MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
14689937	14689937	PRJNA682078_P_NODE_236112_length_249_cov_0.875000_g234335_i0	PRJNA682078	236112	249	0.875	2.17875	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	337	5.559999999999998e-88	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g234335	i0	91.165	102.706827309237	249	21	100	1	1	249	3495592	3495345	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	25574	337	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
23612504	23612504	PRJNA682078_P_NODE_183739_length_272_cov_2.381910_g181962_i0	PRJNA682078	183739	272	2.38191	6.4787952	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	497	2.67e-136	NTclustered	gi\|1028341205\|gb\|KU244603.1\|	166587	g181962	i0	99.632	99.8897058823529	272	1	100	0	1	272	138	409	Uncultured Chloroflexota bacterium isolate DGGE gel band 2a 16S ribosomal RNA gene, partial sequence	blastn	27170	497	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota 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);;