metadata: contig_metadata: 18 rows where bioproject = "PRJNA859990", tax_phylum = "Chloroflexota" and tax

18 rows where bioproject = "PRJNA859990", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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
845842	845842	PRJNA859990_S_NODE_18161_length_250_cov_1.163842_g17900_i0	PRJNA859990	18161	250	1.163842	2.909605	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	307	4.3800000000000005e-79	NTclustered	gi\|146141798\|gb\|EF522302.1\|	166587	g17900	i0	89.2	100.984	250	21	100	4	1	250	519	762	Uncultured Chloroflexi bacterium clone FQSS082 16S ribosomal RNA gene, partial sequence	blastn	25246	307	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
845928	845928	PRJNA859990_S_NODE_5021_length_435_cov_1.406077_g4760_i0	PRJNA859990	5021	435	1.406077	6.11643495	Anaerolineae bacterium	2052143	Bacteria	Bacteria	287	1.06e-72	NTclustered	gi\|2621780275\|emb\|OY776562.1\|	2052143	g4760	i0	79.803	122.025287356322	406	72	92	9	35	435	2246394	2246794	MAG: Anaerolineae bacterium isolate f6896fb1-f4fb-4b0c-86b4-943ec43acfa7 genome assembly, chromosome: 1	blastn	53081	287	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
2121261	2121261	PRJNA859990_S_NODE_15622_length_265_cov_1.453125_g15361_i0	PRJNA859990	15622	265	1.453125	3.85078125	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	219	2.2599999999999998e-52	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g15361	i0	91.772	463.769811320755	158	11	80	2	54	210	319752	319908	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	122899	219	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
2121285	2121285	PRJNA859990_S_NODE_17422_length_253_cov_1.122222_g17161_i0	PRJNA859990	17422	253	1.122222	2.83922166	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	337	5.659999999999998e-88	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g17161	i0	90.837	176.146245059289	251	23	99	0	1	251	3495588	3495338	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	44565	337	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
2121432	2121432	PRJNA859990_S_NODE_9162_length_333_cov_2.773077_g8901_i0	PRJNA859990	9162	333	2.773077	9.23434641	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	268	2.8599999999999994e-67	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g8901	i0	82.099	148.981981981982	324	48	95	7	16	331	2827894	2828215	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	49611	268	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
4674251	4674251	PRJNA859990_S_NODE_11824_length_299_cov_1.022124_g11563_i0	PRJNA859990	11824	299	1.022124	3.05615076	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	318	2.48e-82	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g11563	i0	87.324	331.953177257525	284	29	94	7	15	294	320232	319952	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	99254	318	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
8498760	8498760	PRJNA859990_S_NODE_16067_length_261_cov_2.090426_g15806_i0	PRJNA859990	16067	261	2.090426	5.45601186	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	342	1.26e-89	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g15806	i0	90.421	28.6819923371648	261	24	100	1	1	261	3496191	3495932	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	7486	342	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
11049518	11049518	PRJNA859990_S_NODE_17769_length_251_cov_1.370787_g17508_i0	PRJNA859990	17769	251	1.370787	3.44067537	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	387	5.489999999999998e-103	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g17508	i0	94.422	132.701195219124	251	14	100	0	1	251	3497381	3497131	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	33308	387	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
11049561	11049561	PRJNA859990_S_NODE_20589_length_244_cov_1.239766_g20328_i0	PRJNA859990	20589	244	1.239766	3.02502904	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	244	3.3799999999999997e-60	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g20328	i0	86.147	193.97131147541	231	26	94	5	1	230	320652	320427	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	47329	244	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
11439836	11439836	PRJNA859990_S_NODE_16089_length_261_cov_1.670213_g15828_i0	PRJNA859990	16089	261	1.670213	4.35925593	Anaerolinea	233189	Bacteria	Bacteria	372	1.61e-98	NTclustered	gi\|374851800\|dbj\|AP011699.1\|	166587	g15828	i0	92.337	110.934865900383	261	20	100	0	1	261	23507	23247	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF019_G07	blastn	28954	372	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
13599486	13599486	PRJNA859990_S_NODE_10331_length_316_cov_1.790123_g10070_i0	PRJNA859990	10331	316	1.790123	5.65678868	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	388	1.99e-103	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g10070	i0	89.137	87.3955696202532	313	32	98	2	6	316	3494926	3494614	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	27617	388	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
17424163	17424163	PRJNA859990_S_NODE_9274_length_332_cov_1.081081_g9013_i0	PRJNA859990	9274	332	1.081081	3.58918892	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	470	7.289999999999999e-128	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g9013	i0	92.401	83.1987951807229	329	25	99	0	4	332	3495856	3495528	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	27622	470	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
18697171	18697171	PRJNA859990_S_NODE_12315_length_294_cov_0.932127_g12054_i0	PRJNA859990	12315	294	0.932127	2.74045338	Tepidiforma flava	3004094	Bacteria	Bacteria	425	1.39e-114	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g12054	i0	92.881	107.482993197279	295	18	100	3	1	294	248987	248695	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	31600	425	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
22522754	22522754	PRJNA859990_S_NODE_7678_length_360_cov_1.735192_g7417_i0	PRJNA859990	7678	360	1.735192	6.2466912	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	438	2.24e-118	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g7417	i0	88.643	131.405555555556	361	40	100	1	1	360	3494958	3494598	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	47306	438	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
23798144	23798144	PRJNA859990_S_NODE_21739_length_242_cov_0.911243_g21478_i0	PRJNA859990	21739	242	0.911243	2.20520806	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	187	5.73e-43	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g21478	i0	83.824	195.198347107438	204	25	81	6	47	242	2828068	2827865	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	47238	187	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
25071941	25071941	PRJNA859990_S_NODE_11720_length_300_cov_1.088106_g11459_i0	PRJNA859990	11720	300	1.088106	3.264318	Leptolinea sp. HRD-7	2830982	Bacteria	Bacteria	555	1.7399999999999995e-153	NTclustered	gi\|2250018340\|dbj\|AP024710.1\|	2830982	g11459	i0	100	341.783333333333	300	0	100	0	1	300	1244227	1244526	Leptolinea sp. HRD-7 DNA, complete genome	blastn	102535	555	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Leptolinea	Leptolinea sp. HRD-7
29707217	29707217	PRJNA859990_S_NODE_17790_length_251_cov_1.286517_g17529_i0	PRJNA859990	17790	251	1.286517	3.22915767	Anaerolineae bacterium	2052143	Bacteria	Bacteria	137	1.1199999999999999e-38	NR	MCK6629985.1	2052143	g17529	i0	79.5	5.95219123505976	83	17	99.2	0	2	250	45	127	MCK6629985.1 ADP-ribosylation factor-like protein [Anaerolineae bacterium]	diamond	1494	137	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31540529	31540529	PRJNA859990_S_NODE_19896_length_246_cov_0.890173_g19635_i0	PRJNA859990	19896	246	0.890173	2.18982558	Anaerolineae bacterium	2052143	Bacteria	Bacteria	85.9	1.41e-17	NR	MBX3065691.1	2052143	g19635	i0	62.5	0.780487804878049	64	24	78	0	246	55	41	104	MBX3065691.1 tyrosine-protein phosphatase [Anaerolineae bacterium]	diamond	192	85.9	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;