metadata: contig_metadata: 11 rows where bioproject = "PRJNA631796", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJNA631796", 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
3154279	3154279	PRJNA631796_P_NODE_6263_length_274_cov_1.408451_g5985_i0	PRJNA631796	6263	274	1.408451	3.85915574	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	252	2.31e-62	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g5985	i0	83.813	248.587591240876	278	31	100	9	1	274	3521475	3521208	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	68113	252	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4431101	4431101	PRJNA631796_P_NODE_1944_length_512_cov_3.853659_g1669_i0	PRJNA631796	1944	512	3.853659	19.73073408	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	512	1.91e-140	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g1669	i0	84.884	512.376953125	516	69	99	9	3	512	4993353	4992841	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	262337	512	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
9531935	9531935	PRJNA631796_P_NODE_8528_length_233_cov_2.906977_g8250_i0	PRJNA631796	8528	233	2.906977	6.77325641	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	403	4.9999999999999985e-108	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g8250	i0	97.854	759.570815450644	233	5	100	0	1	233	2092756	2092524	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	176980	403	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12082805	12082805	PRJNA631796_P_NODE_12530_length_203_cov_1.169014_g12252_i0	PRJNA631796	12530	203	1.169014	2.37309842	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	315	2.04e-81	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g12252	i0	95	231.743842364532	200	10	99	0	4	203	2092893	2092694	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	47044	315	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17729865	17729865	PRJNA631796_P_NODE_10474_length_213_cov_4.671053_g10196_i0	PRJNA631796	10474	213	4.671053	9.94934289	Chloroflexota	200795	Bacteria	Bacteria	217	6.279999999999999e-52	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g10196	i0	85.047	249.131455399061	214	30	100	2	1	213	2829461	2829673	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	53065	217	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
21005804	21005804	PRJNA631796_P_NODE_5537_length_293_cov_1.103448_g5259_i0	PRJNA631796	5537	293	1.103448	3.23310264	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	494	3.76e-135	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g5259	i0	96.959	663.928327645051	296	6	100	3	1	293	2093829	2093534	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	194531	494	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23555963	23555963	PRJNA631796_P_NODE_3619_length_367_cov_3.009804_g3342_i0	PRJNA631796	3619	367	3.009804	11.04598068	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	335	3.089999999999999e-87	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g3342	i0	83.558	815.027247956403	371	48	100	7	1	367	320355	319994	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	299115	335	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
24829660	24829660	PRJNA631796_P_NODE_14280_length_174_cov_5.035398_g14002_i0	PRJNA631796	14280	174	5.035398	8.76159252	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	283	4.769999999999999e-72	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g14002	i0	96	135.011494252874	175	5	100	2	1	174	319522	319349	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	23492	283	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
25378425	25378425	PRJNA631796_P_NODE_9880_length_219_cov_1.620253_g9602_i0	PRJNA631796	9880	219	1.620253	3.54835407	Caldilinea	233191	Bacteria	Bacteria	287	4.88e-73	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g9602	i0	91.08	130.826484018265	213	17	97	2	8	219	1481	1270	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	28651	287	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
27523241	27523241	PRJNA631796_P_NODE_5243_length_301_cov_1.066667_g4965_i0	PRJNA631796	5243	301	1.066667	3.21066767	Chloroflexota bacterium	2026724	Bacteria	Bacteria	44.3	0.02	NR	MBI5033844.1	2026724	g4965	i0	29.9	0.867109634551495	87	58	83.7	1	286	35	179	265	MBI5033844.1 SagB/ThcOx family dehydrogenase [Chloroflexota bacterium]	diamond	261	44.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29039067	29039067	PRJNA631796_P_NODE_12108_length_205_cov_0.888889_g11830_i0	PRJNA631796	12108	205	0.888889	1.82222245	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.9	4.52e-8	NR	MBU6359599.1	2026724	g11830	i0	49.3	2.01951219512195	69	34	99.5	1	204	1	1055	1123	MBU6359599.1 hypothetical protein [Chloroflexota bacterium]	diamond	414	58.9	1	Bacteria	Bacillati	Chloroflexota					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);;