metadata: contig_metadata: 14 rows where bioproject = "PRJNA438687", tax_kingdom = "Bacillati" and tax

14 rows where bioproject = "PRJNA438687", 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6813107	6813107	PRJNA438687_S_NODE_5646_length_186_cov_1.589404_g5556_i0	PRJNA438687	5646	186	1.589404	2.95629144	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	145	2.55e-30	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g5556	i0	88.43	0.650537634408602	121	12	64	1	9	127	2202107	2202227	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	121	145	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
6813141	6813141	PRJNA438687_S_NODE_7066_length_164_cov_1.015504_g6976_i0	PRJNA438687	7066	164	1.015504	1.66542656	Chloroflexota bacterium	2026724	Bacteria	Bacteria	272	9.65e-69	NTclustered	gi\|1861039503\|dbj\|LC546414.1\|	2026724	g6976	i0	97.484	99.6707317073171	159	4	97	0	6	164	68	226	Chloroflexi bacterium BA-149 gene for 16S ribosomal RNA, partial sequence	blastn	16346	272	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
10639206	10639206	PRJNA438687_S_NODE_4689_length_205_cov_1.641176_g4599_i0	PRJNA438687	4689	205	1.641176	3.3644108	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	220	4.64e-53	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g4599	i0	86.341	46.8829268292683	205	25	99	3	1	203	3495967	3496170	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	9611	220	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
11914101	11914101	PRJNA438687_S_NODE_6970_length_165_cov_1.707692_g6880_i0	PRJNA438687	6970	165	1.707692	2.8176918	Dehalogenimonas sp. WBC-2	943347	Bacteria	Bacteria	115	1.73e-21	NTclustered	gi\|819627869\|gb\|CP011392.1\|	943347	g6880	i0	89.888	201.375757575758	89	9	54	0	68	156	1536997	1537085	Dehalogenimonas sp. WBC-2, complete genome	blastn	33227	115	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalogenimonas	Dehalogenimonas sp. WBC-2
13188957	13188957	PRJNA438687_S_NODE_2431_length_284_cov_3.104418_g2341_i0	PRJNA438687	2431	284	3.104418	8.81654712	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	246	1.1199999999999999e-60	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g2341	i0	87.215	112.545774647887	219	24	76	3	28	244	2202367	2202583	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	31963	246	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
16393808	16393808	PRJNA438687_S_NODE_6853_length_166_cov_6.603053_g6763_i0	PRJNA438687	6853	166	6.603053	10.96106798	Chloroflexota	200795	Bacteria	Bacteria	204	3.629999999999999e-48	NTclustered	gi\|2874253736\|emb\|OY969578.1\|	1672391	g6763	i0	98.276	244.981927710843	116	2	70	0	51	166	3178986	3179101	MAG: uncultured Chloroflexia bacterium isolate MFD05674.bin.c.2 genome assembly, chromosome: 1	blastn	40667	204	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19561259	19561259	PRJNA438687_S_NODE_576_length_437_cov_31.935323_g489_i0	PRJNA438687	576	437	31.935323	139.55736151	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	658	0	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g489	i0	93.836	168.716247139588	438	26	100	1	1	437	672122	671685	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	73729	658	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20836889	20836889	PRJNA438687_S_NODE_4217_length_216_cov_1.961326_g4127_i0	PRJNA438687	4217	216	1.961326	4.23646416	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	200	6.429999999999999e-47	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g4127	i0	83.71	9.18518518518519	221	26	100	9	1	216	3495740	3495955	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1984	200	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
20836964	20836964	PRJNA438687_S_NODE_977_length_381_cov_3.234104_g888_i0	PRJNA438687	977	381	3.234104	12.32193624	Anaerolineales bacterium	2073117	Bacteria	Bacteria	636	7.879999999999998e-178	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g888	i0	96.85	179.900262467192	381	11	100	1	1	381	1233903	1233524	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	68542	636	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
23387464	23387464	PRJNA438687_S_NODE_2179_length_297_cov_27.213740_g2089_i0	PRJNA438687	2179	297	27.21374	80.8248078	Anaerolineales bacterium	2073117	Bacteria	Bacteria	505	1.7599999999999995e-138	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g2089	i0	97.306	190.912457912458	297	8	100	0	1	297	1576056	1575760	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	56701	505	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
23387468	23387468	PRJNA438687_S_NODE_2319_length_290_cov_8.647059_g2229_i0	PRJNA438687	2319	290	8.647059	25.0764711	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	291	5.23e-74	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g2229	i0	85.274	159.644827586207	292	32	100	8	1	290	1073	1355	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	46297	291	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23387470	23387470	PRJNA438687_S_NODE_2519_length_279_cov_16.377049_g2429_i0	PRJNA438687	2519	279	16.377049	45.69196671	Anaerolineales bacterium	2073117	Bacteria	Bacteria	455	1.68e-123	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g2429	i0	96.057	288.387096774194	279	11	100	0	1	279	2028542	2028820	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	80460	455	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
23387555	23387555	PRJNA438687_S_NODE_6519_length_171_cov_2.919118_g6429_i0	PRJNA438687	6519	171	2.919118	4.99169178	Anaerolineales bacterium	2073117	Bacteria	Bacteria	289	1e-73	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g6429	i0	97.076	30.9181286549708	171	5	100	0	1	171	1233970	1234140	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	5287	289	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
24661562	24661562	PRJNA438687_S_NODE_3880_length_226_cov_1.429319_g3790_i0	PRJNA438687	3880	226	1.429319	3.23026094	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	265	2.37e-66	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g3790	i0	88.053	549.619469026549	226	23	99	4	1	224	598288	598065	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	124214	265	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve

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