metadata: contig_metadata: 19 rows where bioproject = "PRJNA724039", tax_kingdom = "Bacillati" and tax

19 rows where bioproject = "PRJNA724039", 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
711095	711095	PRJNA724039_S_NODE_16001_length_159_cov_2.950820_g15794_i0	PRJNA724039	16001	159	2.95082	4.6918038	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	150	4.54e-32	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g15794	i0	89.344	4.60377358490566	122	10	75	3	5	124	1349	1229	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	732	150	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
8364405	8364405	PRJNA724039_S_NODE_1487_length_654_cov_29.102107_g1314_i0	PRJNA724039	1487	654	29.102107	190.32777978	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	658	0	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g1314	i0	85.191	1097.42201834862	655	81	99	12	1	651	320394	319752	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	717714	658	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
10915227	10915227	PRJNA724039_S_NODE_2709_length_450_cov_2.341404_g2503_i0	PRJNA724039	2709	450	2.341404	10.536318	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	152	4.1799999999999996e-32	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g2503	i0	84.516	1.16444444444444	155	22	34	2	240	393	3522299	3522146	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	524	152	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13948003	13948003	PRJNA724039_S_NODE_17151_length_154_cov_1.555556_g16944_i0	PRJNA724039	17151	154	1.555556	2.39555624	Chloroflexus	1107	Bacteria	Bacteria	171	3.34e-38	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g16944	i0	90.698	136.064935064935	129	11	83	1	1	128	1782	1654	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	20954	171	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
13948056	13948056	PRJNA724039_S_NODE_8031_length_234_cov_2.060914_g7824_i0	PRJNA724039	8031	234	2.060914	4.82253876	Roseiflexus	120961	Bacteria	Bacteria	134	7.28e-27	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g7824	i0	79.293	7.38034188034188	198	35	83	6	40	234	1527	1333	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	1727	134	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
16013630	16013630	PRJNA724039_S_NODE_15273_length_163_cov_2.285714_g15066_i0	PRJNA724039	15273	163	2.285714	3.72571382	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	128	2.1899999999999998e-25	NTclustered	gi\|2893356069\|emb\|OZ220492.1\|	2614250	g15066	i0	86.555	224.288343558282	119	12	72	3	44	161	2776803	2776688	MAG: Caldilineaceae bacterium isolate e886e3b1-96bd-41d4-96ed-8e2f365de7fb genome assembly, chromosome: 1	blastn	36559	128	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
16497196	16497196	PRJNA724039_S_NODE_9353_length_213_cov_4.346591_g9146_i0	PRJNA724039	9353	213	4.346591	9.25823883	Candidatus Brevifilum	2019482	Bacteria	Bacteria	250	6.19e-62	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g9146	i0	88.208	507.699530516432	212	21	99	3	1	211	678851	679059	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	108140	250	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans
18562971	18562971	PRJNA724039_S_NODE_5495_length_296_cov_5.362934_g5288_i0	PRJNA724039	5495	296	5.362934	15.87428464	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	298	3.2e-76	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g5288	i0	85.382	181.209459459459	301	28	100	11	1	296	2828226	2827937	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	53638	298	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
18563036	18563036	PRJNA724039_S_NODE_8895_length_220_cov_1.928962_g8688_i0	PRJNA724039	8895	220	1.928962	4.2437164	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	156	1.44e-33	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g8688	i0	82.199	6.01363636363636	191	24	84	10	36	220	598356	598170	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	1323	156	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
21113612	21113612	PRJNA724039_S_NODE_10817_length_196_cov_3.220126_g10610_i0	PRJNA724039	10817	196	3.220126	6.31144696	Anaerolineales bacterium	2073117	Bacteria	Bacteria	200	5.719999999999998e-47	NTclustered	gi\|2556910457\|gb\|CP129484.1\|	2073117	g10610	i0	86.559	28.030612244898	186	20	93	5	15	196	919466	919282	MAG: Anaerolineales bacterium isolate cMAG.12 chromosome, complete genome	blastn	5494	200	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
21113643	21113643	PRJNA724039_S_NODE_12737_length_180_cov_1.503497_g12530_i0	PRJNA724039	12737	180	1.503497	2.7062946	Chloroflexota bacterium	2026724	Bacteria	Bacteria	158	3.1499999999999993e-34	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g12530	i0	87.143	189.1	140	17	78	1	40	179	1474295	1474157	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	34038	158	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
22871694	22871694	PRJNA724039_S_NODE_8658_length_223_cov_4.806452_g8451_i0	PRJNA724039	8658	223	4.806452	10.71838796	Caldilinea	233191	Bacteria	Bacteria	363	8.049999999999997e-96	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g8451	i0	95.964	324.892376681614	223	9	100	0	1	223	2276	2498	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	72451	363	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
23664186	23664186	PRJNA724039_S_NODE_17819_length_151_cov_2.315789_g17612_i0	PRJNA724039	17819	151	2.315789	3.49684139	uncultured Ktedonobacterales bacterium	444456	Bacteria	Bacteria	261	1.88e-65	NTclustered	gi\|1489024535\|gb\|MK040708.1\|	444456	g17612	i0	98	86.1920529801324	150	3	99	0	1	150	290	439	Uncultured Ktedonobacterales bacterium clone OTU4012-CR 16S ribosomal RNA gene, partial sequence	blastn	13015	261	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			uncultured Ktedonobacterales bacterium
24145753	24145753	PRJNA724039_S_NODE_8919_length_219_cov_96.532967_g8712_i0	PRJNA724039	8919	219	96.532967	211.40719773	Chloroflexus	1107	Bacteria	Bacteria	267	6.359999999999999e-67	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g8712	i0	89.952	205.65296803653	209	17	95	3	13	219	2177	1971	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	45038	267	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
24937651	24937651	PRJNA724039_S_NODE_17760_length_151_cov_4.008772_g17553_i0	PRJNA724039	17760	151	4.008772	6.05324572	Chloroflexota bacterium	2026724	Bacteria	Bacteria	70.9	7.2e-13	NR	HEY8286704.1	2026724	g17553	i0	67.3	2.9205298013245	49	14	93.4	1	149	9	71	119	HEY8286704.1 methyltransferase domain-containing protein [Chloroflexota bacterium]	diamond	441	70.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29451872	29451872	PRJNA724039_S_NODE_11510_length_190_cov_1.470588_g11303_i0	PRJNA724039	11510	190	1.470588	2.7941172	Candidatus Chloroploca asiatica	1506545	Bacteria	Bacteria	44.3	0.00538	NR	WP_172451194.1	1506545	g11303	i0	46.8	0.742105263157895	47	25	74.2	0	141	1	596	642	WP_172451194.1 diguanylate cyclase [Candidatus Chloroploca asiatica]	diamond	141	44.3	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Oscillochloridaceae	Candidatus Chloroploca	Candidatus Chloroploca asiatica
29641312	29641312	PRJNA724039_S_NODE_16910_length_155_cov_1.915254_g16703_i0	PRJNA724039	16910	155	1.915254	2.9686437	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	57.8	5.52e-8	NR	HEX8997723.1	2306968	g16703	i0	55.1	0.948387096774194	49	21	94.8	1	8	154	364	411	HEX8997723.1 NADH-quinone oxidoreductase subunit N [Ktedonobacterales bacterium]	diamond	147	57.8	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
30305458	30305458	PRJNA724039_S_NODE_12452_length_182_cov_1.586207_g12245_i0	PRJNA724039	12452	182	1.586207	2.88689674	Anaerolineales bacterium	2073117	Bacteria	Bacteria	42.4	0.0233	NR	MCB9436685.1	2073117	g12245	i0	41.9	1.02197802197802	62	31	95.6	2	177	4	154	214	MCB9436685.1 DUF11 domain-containing protein [Anaerolineales bacterium]	diamond	186	42.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30557529	30557529	PRJNA724039_S_NODE_15553_length_162_cov_1.224000_g15346_i0	PRJNA724039	15553	162	1.224	1.98288	Anaerolineae bacterium	2052143	Bacteria	Bacteria	47	1.18e-4	NR	MCW5848612.1	2052143	g15346	i0	47.2	0.981481481481482	53	28	98.1	0	159	1	66	118	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	159	47	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);;