metadata: contig_metadata: 15 rows where bioproject = "PRJNA1025141", tax_phylum = "Chloroflexota" and tax

15 rows where bioproject = "PRJNA1025141", 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
11641400	11641400	PRJNA1025141_P_NODE_4090_length_402_cov_0.826748_g4029_i0	PRJNA1025141	4090	402	0.826748	3.32352696	Thermobaculum terrenum	166501	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|269790643\|gb\|CP001826.1\|	525904	g4029	i0	100	0.0696517412935323	28	0	7	0	76	103	749466	749493	Thermobaculum terrenum ATCC BAA-798 chromosome 2, complete sequence	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
15465583	15465583	PRJNA1025141_P_NODE_4513_length_382_cov_1.902913_g4452_i0	PRJNA1025141	4513	382	1.902913	7.26912766	Bacteria	2	Bacteria	Bacteria	154	1.53e-43	NR	MBG94835.1	2026724	g4452	i0	56.8	7.85340314136126	125	54	98.2	0	380	6	15	139	MBG94835.1 polyamine aminopropyltransferase [Chloroflexota bacterium]	diamond	3000	155	0.993548387096774	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
18014677	18014677	PRJNA1025141_P_NODE_4735_length_373_cov_1.026667_g4674_i0	PRJNA1025141	4735	373	1.026667	3.82946791	Anaerolineae bacterium	2052143	Bacteria	Bacteria	186	7.579999999999998e-55	NR	PWH13212.1	2052143	g4674	i0	70.7	6.91689008042895	123	35	98.9	1	371	3	53	174	PWH13212.1 MAG: ATP-binding protein [Anaerolineae bacterium]	diamond	2580	186	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
26813518	26813518	PRJNA1025141_P_NODE_4821_length_370_cov_0.932660_g4760_i0	PRJNA1025141	4821	370	0.93266	3.450842	Anaerolineales bacterium	2073117	Bacteria	Bacteria	76.3	2.97e-13	NR	MCA9992201.1	2073117	g4760	i0	37.8	0.9	111	65	90	1	368	36	1294	1400	MCA9992201.1 tandem-95 repeat protein [Anaerolineales bacterium]	diamond	333	76.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
26939926	26939926	PRJNA1025141_P_NODE_12442_length_243_cov_0.905882_g12381_i0	PRJNA1025141	12442	243	0.905882	2.20129326	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	89.7	3.87e-20	NR	MEO7295221.1	3047546	g12381	i0	57.3	1.01234567901235	82	33	98.8	1	1	240	62	143	MEO7295221.1 NAD(P)H-dependent oxidoreductase [Candidatus Limnocylindria bacterium]	diamond	246	89.7	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
27280093	27280093	PRJNA1025141_P_NODE_8723_length_263_cov_1.215789_g8662_i0	PRJNA1025141	8723	263	1.215789	3.19752507	Chloroflexota	200795	Bacteria	Bacteria	45.1	0.00626	NR	HRI55767.1	2052143	g8662	i0	50	1.53992395437262	44	22	50.2	0	228	97	71	114	HRI55767.1 histidine phosphatase family protein [Anaerolineae bacterium]	diamond	405	45.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28140740	28140740	PRJNA1025141_P_NODE_6525_length_313_cov_1.091667_g6464_i0	PRJNA1025141	6525	313	1.091667	3.41691771	Kouleothrix sp.	2779161	Bacteria	Bacteria	68.6	2.95e-11	NR	WP_409570441.1	2779161	g6464	i0	36	0.958466453674121	100	61	94.9	2	309	13	79	176	WP_409570441.1 class I SAM-dependent methyltransferase [Kouleothrix sp.]	diamond	300	68.6	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix sp.
28701084	28701084	PRJNA1025141_P_NODE_8307_length_272_cov_1.095477_g8246_i0	PRJNA1025141	8307	272	1.095477	2.97969744	Bacteria	2	Bacteria	Bacteria	94.4	3.84e-20	NR	MFC2015854.1	2026724	g8246	i0	48.9	2.98897058823529	90	46	99.3	0	2	271	314	403	MFC2015854.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Chloroflexota bacterium]	diamond	813	94.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29561177	29561177	PRJNA1025141_P_NODE_9290_length_252_cov_0.938547_g9229_i0	PRJNA1025141	9290	252	0.938547	2.36513844	Anaerolineae bacterium	2052143	Bacteria	Bacteria	42.7	0.0386	NR	MDH7487302.1	2052143	g9229	i0	33.3	1.03571428571429	87	50	96.4	4	252	10	18	102	MDH7487302.1 exodeoxyribonuclease III [Anaerolineae bacterium]	diamond	261	42.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29932569	29932569	PRJNA1025141_P_NODE_9491_length_251_cov_0.865169_g9430_i0	PRJNA1025141	9491	251	0.865169	2.17157419	PVC group	1783257	Bacteria	Bacteria	47	2.65e-4	NR	MBC7237740.1	2026724	g9430	i0	38.7	2.64143426294821	75	40	82.5	2	7	213	2	76	MBC7237740.1 RNA-binding protein [Chloroflexota bacterium]	diamond	663	47.4	0.991561181434599	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30098109	30098109	PRJNA1025141_P_NODE_5972_length_328_cov_0.905882_g5911_i0	PRJNA1025141	5972	328	0.905882	2.97129296	Anaerolineae bacterium	2052143	Bacteria	Bacteria	50.4	2.08e-4	NR	HFD39026.1	2052143	g5911	i0	40.6	2.34146341463415	64	36	58.5	1	246	55	1131	1192	HFD39026.1 PKD domain-containing protein [Anaerolineae bacterium]	diamond	768	50.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31290927	31290927	PRJNA1025141_P_NODE_3955_length_409_cov_0.916667_g3894_i0	PRJNA1025141	3955	409	0.916667	3.74916803	Bacteria	2	Bacteria	Bacteria	161	9.01e-45	NR	HZQ06020.1	2052143	g3894	i0	58.1	10.2762836185819	129	47	92.4	2	379	2	9	133	HZQ06020.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Anaerolineae bacterium]	diamond	4203	162	0.993827160493827	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31646694	31646694	PRJNA1025141_P_NODE_6757_length_307_cov_0.987179_g6696_i0	PRJNA1025141	6757	307	0.987179	3.03063953	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	62	1.37e-8	NR	MFM7679418.1	2762507	g6696	i0	40.9	0.644951140065147	66	39	64.5	0	200	3	675	740	MFM7679418.1 ImpA family metalloprotease [Roseiflexaceae bacterium]	diamond	198	62	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
31670565	31670565	PRJNA1025141_P_NODE_10357_length_249_cov_0.875000_g10296_i0	PRJNA1025141	10357	249	0.875	2.17875	Candidatus Villigracilis	3140593	Bacteria	Bacteria	70.1	9.03e-12	NR	MCA0456117.1	2026724	g10296	i0	45.8	2.85542168674699	72	37	84.3	1	2	211	12	83	MCA0456117.1 recombinase family protein [Chloroflexota bacterium]	diamond	711	70.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32026497	32026497	PRJNA1025141_P_NODE_10458_length_248_cov_0.880000_g10397_i0	PRJNA1025141	10458	248	0.88	2.1824	Anaerolineales bacterium	2073117	Bacteria	Bacteria	133	6.33e-34	NR	HZM22316.1	2073117	g10397	i0	73.2	0.991935483870968	82	22	99.2	0	247	2	34	115	HZM22316.1 PAS domain S-box protein [Anaerolineales bacterium]	diamond	246	133	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales 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);;