metadata: contig_metadata: 26 rows where bioproject = "PRJNA857143", tax_kingdom = "Bacillati" and tax

26 rows where bioproject = "PRJNA857143", 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
4672982	4672982	PRJNA857143_S_NODE_88164_length_327_cov_4.255906_g87071_i0	PRJNA857143	88164	327	4.255906	13.91681262	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	239	2.1999999999999993e-58	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g87071	i0	80.606	29.5443425076453	330	46	98	11	6	327	2202080	2202399	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	9661	239	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
5947506	5947506	PRJNA857143_S_NODE_63205_length_367_cov_1.707483_g62112_i0	PRJNA857143	63205	367	1.707483	6.26646261	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	346	1.4299999999999999e-90	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g62112	i0	83.957	275.920980926431	374	47	99	8	5	367	4992830	4993201	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	101263	346	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
7222049	7222049	PRJNA857143_S_NODE_23526_length_503_cov_3.200000_g22439_i0	PRJNA857143	23526	503	3.2	16.096	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	346	2.01e-90	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g22439	i0	80.421	100.085487077535	475	76	93	14	37	502	597203	597669	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	50343	346	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
8496155	8496155	PRJNA857143_S_NODE_141927_length_273_cov_1.280000_g140834_i0	PRJNA857143	141927	273	1.28	3.4944	Anaerolineae bacterium	2052143	Bacteria	Bacteria	78.2	1e-14	NR	MBN8583441.1	2052143	g140834	i0	48.7	0.857142857142857	78	33	85.7	1	1	234	228	298	MBN8583441.1 PAS domain S-box protein [Anaerolineae bacterium]	diamond	234	78.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
12322652	12322652	PRJNA857143_S_NODE_165090_length_255_cov_2.368132_g163997_i0	PRJNA857143	165090	255	2.368132	6.0387366	Bacteria	2	Bacteria	Bacteria	85.1	2.82e-17	NR	MDI9548804.1	2026724	g163997	i0	82.2	1.6	45	8	52.9	0	253	119	307	351	MDI9548804.1 S-methyl-5-thioribose-1-phosphate isomerase [Chloroflexota bacterium]	diamond	408	85.5	0.9953216374269	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
13596953	13596953	PRJNA857143_S_NODE_139311_length_275_cov_1.544554_g138218_i0	PRJNA857143	139311	275	1.544554	4.2475235	Anaerolineae bacterium	2052143	Bacteria	Bacteria	65.9	2.52e-10	NR	MCG3208090.1	2052143	g138218	i0	45.2	0.916363636363636	84	42	91.6	2	274	23	209	288	MCG3208090.1 Elongation factor Ts [Anaerolineae bacterium]	diamond	252	65.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
19970429	19970429	PRJNA857143_S_NODE_200996_length_227_cov_2.019481_g199903_i0	PRJNA857143	200996	227	2.019481	4.58422187	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	302	1.82e-77	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g199903	i0	92.788	180.118942731278	208	15	92	0	13	220	2827816	2828023	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	40887	302	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
26738095	26738095	PRJNA857143_S_NODE_175741_length_250_cov_1.322034_g174648_i0	PRJNA857143	175741	250	1.322034	3.305085	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	90.9	3e-19	NR	MBX3053525.1	2614250	g174648	i0	67.2	1.608	67	22	80.4	0	244	44	345	411	MBX3053525.1 hypothetical protein [Caldilineaceae bacterium]	diamond	402	90.9	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
26959983	26959983	PRJNA857143_S_NODE_181802_length_247_cov_2.241379_g180709_i0	PRJNA857143	181802	247	2.241379	5.53620613	Phototrophicales bacterium	2364211	Bacteria	Bacteria	42.4	0.0377	NR	PJF41087.1	2364211	g180709	i0	58.1	0.376518218623482	31	13	37.7	0	8	100	146	176	PJF41087.1 MAG: protein phosphatase [Phototrophicales bacterium]	diamond	93	42.4	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales			Phototrophicales bacterium
27339695	27339695	PRJNA857143_S_NODE_198683_length_233_cov_2.375000_g197590_i0	PRJNA857143	198683	233	2.375	5.53375	Anaerolineae bacterium	2052143	Bacteria	Bacteria	66.2	1.51e-10	NR	MFN8422079.1	2052143	g197590	i0	51.7	1.41630901287554	60	29	77.3	0	35	214	252	311	MFN8422079.1 hypothetical protein [Anaerolineae bacterium]	diamond	330	66.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27884470	27884470	PRJNA857143_S_NODE_80965_length_337_cov_2.446970_g79872_i0	PRJNA857143	80965	337	2.44697	8.2462889	Bacteria	2	Bacteria	Bacteria	65.9	2.8e-11	NR	MFN8620447.1	2026724	g79872	i0	43.8	3.08902077151335	73	40	65	1	1	219	33	104	MFN8620447.1 FHA domain-containing protein [Chloroflexota bacterium]	diamond	1041	66.2	0.995468277945619	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28223478	28223478	PRJNA857143_S_NODE_118346_length_294_cov_1.411765_g117253_i0	PRJNA857143	118346	294	1.411765	4.1505891	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	72	3.23e-13	NR	HEX8681735.1	2614247	g117253	i0	53.7	3.18367346938776	67	31	68.4	0	2	202	106	172	HEX8681735.1 MogA/MoaB family molybdenum cofactor biosynthesis protein [Ardenticatenaceae bacterium]	diamond	936	72	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
28326393	28326393	PRJNA857143_S_NODE_134966_length_279_cov_1.135922_g133873_i0	PRJNA857143	134966	279	1.135922	3.16922238	Bacteria	2	Bacteria	Bacteria	63.9	2.41e-10	NR	HEV7213643.1	2026724	g133873	i0	35.1	3.32258064516129	77	50	82.8	0	279	49	75	151	HEV7213643.1 hypothetical protein [Chloroflexota bacterium]	diamond	927	63.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28673904	28673904	PRJNA857143_S_NODE_197447_length_236_cov_2.975460_g196354_i0	PRJNA857143	197447	236	2.97546	7.0220856	Bacteria	2	Bacteria	Bacteria	45.4	0.00346	NR	UCC17859.1	2026733	g196354	i0	31.3	4.19491525423729	67	46	85.2	0	5	205	34	100	UCC17859.1 MAG: two pore domain potassium channel family protein [Dehalococcoidales bacterium]	diamond	990	45.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
28854962	28854962	PRJNA857143_S_NODE_64388_length_365_cov_1.428082_g63295_i0	PRJNA857143	64388	365	1.428082	5.2124993	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	99.4	9.59e-23	NR	HET7738775.1	3022862	g63295	i0	50.9	1.61917808219178	110	50	88.8	2	1	324	136	243	HET7738775.1 phosphoribosylanthranilate isomerase [Tepidiformaceae bacterium]	diamond	591	99.4	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
29013311	29013311	PRJNA857143_S_NODE_20788_length_524_cov_3.736142_g19706_i0	PRJNA857143	20788	524	3.736142	19.57738408	Anaerolineae bacterium	2052143	Bacteria	Bacteria	48.1	0.00708	NR	MDX9952643.1	2052143	g19706	i0	37.1	1.79198473282443	62	39	35.5	0	1	186	467	528	MDX9952643.1 protein kinase [Anaerolineae bacterium]	diamond	939	48.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29273585	29273585	PRJNA857143_S_NODE_184449_length_246_cov_1.763006_g183356_i0	PRJNA857143	184449	246	1.763006	4.33699476	Bacteria	2	Bacteria	Bacteria	55.1	3.47e-7	NR	WP_322802397.1	1969742	g183356	i0	48.1	2.19512195121951	52	27	63.4	0	242	87	81	132	WP_322802397.1 MaoC family dehydratase [Thermoflexus sp.]	diamond	540	55.1	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales	Thermoflexaceae	Thermoflexus	Thermoflexus sp.
29991934	29991934	PRJNA857143_S_NODE_190971_length_243_cov_2.611765_g189878_i0	PRJNA857143	190971	243	2.611765	6.34658895	Anaerolineales bacterium	2073117	Bacteria	Bacteria	70.9	4.02e-12	NR	MCJ7567654.1	2073117	g189878	i0	44.8	1.18518518518519	96	38	100	3	1	243	272	367	MCJ7567654.1 amino acid ABC transporter substrate-binding protein [Anaerolineales bacterium]	diamond	288	70.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30181379	30181379	PRJNA857143_S_NODE_110132_length_302_cov_1.703057_g109039_i0	PRJNA857143	110132	302	1.703057	5.14323214	Ornatilinea apprima	1134406	Bacteria	Bacteria	69.7	1.25e-11	NR	WP_075063735.1	1134406	g109039	i0	41.4	0.983443708609272	99	51	96.4	3	294	4	131	224	WP_075063735.1 CPBP family intramembrane glutamic endopeptidase [Ornatilinea apprima]	diamond	297	69.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Ornatilinea	Ornatilinea apprima
30276561	30276561	PRJNA857143_S_NODE_14932_length_587_cov_5.379377_g13881_i0	PRJNA857143	14932	587	5.379377	31.57694299	Anaerolineae bacterium	2052143	Bacteria	Bacteria	52.4	4.78e-5	NR	MCW5848612.1	2052143	g13881	i0	36.9	0.567291311754685	111	64	56.7	3	564	232	20	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	333	52.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31951566	31951566	PRJNA857143_S_NODE_133237_length_280_cov_1.961353_g132144_i0	PRJNA857143	133237	280	1.961353	5.4917884	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	63.9	2.04e-9	NR	MDO9332954.1	2026733	g132144	i0	37.6	0.996428571428571	93	58	99.6	0	2	280	465	557	MDO9332954.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	279	63.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
31951573	31951573	PRJNA857143_S_NODE_183337_length_247_cov_0.896552_g182244_i0	PRJNA857143	183337	247	0.896552	2.21448344	Chloroflexota bacterium	2026724	Bacteria	Bacteria	60.1	8.24e-9	NR	HZR97695.1	2026724	g182244	i0	44.7	0.923076923076923	76	31	91.1	2	3	227	108	173	HZR97695.1 carboxypeptidase regulatory-like domain-containing protein [Chloroflexota bacterium]	diamond	228	60.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32078166	32078166	PRJNA857143_S_NODE_103078_length_310_cov_0.987342_g101985_i0	PRJNA857143	103078	310	0.987342	3.0607602	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.2	2.78e-7	NR	MBM4406944.1	2026724	g101985	i0	44.4	0.696774193548387	72	36	69.7	1	310	95	266	333	MBM4406944.1 D-2-hydroxyacid dehydrogenase [Chloroflexota bacterium]	diamond	216	58.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32458046	32458046	PRJNA857143_S_NODE_147379_length_269_cov_1.000000_g146286_i0	PRJNA857143	147379	269	1	2.69	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	44.7	0.01	NR	HJM88204.1	2026734	g146286	i0	34.9	0.702602230483271	63	41	70.3	0	17	205	244	306	HJM88204.1 phosphotransferase [Dehalococcoidia bacterium]	diamond	189	44.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32458053	32458053	PRJNA857143_S_NODE_49299_length_398_cov_0.960000_g48206_i0	PRJNA857143	49299	398	0.96	3.8208	Anaerolineae bacterium	2052143	Bacteria	Bacteria	50.4	3.95e-4	NR	MCG3210812.1	2052143	g48206	i0	35.3	2.09547738693467	85	49	64.1	2	123	377	155	233	MCG3210812.1 hypothetical protein [Anaerolineae bacterium]	diamond	834	50.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32804695	32804695	PRJNA857143_S_NODE_129260_length_284_cov_1.109005_g128167_i0	PRJNA857143	129260	284	1.109005	3.1495742	Kouleothrix aurantiaca	186479	Bacteria	Bacteria	65.1	5.53e-10	NR	KPV48358.1	186479	g128167	i0	41	2.08098591549296	100	48	98.2	3	2	280	94	189	KPV48358.1 hypothetical protein SE17_38495, partial [Kouleothrix aurantiaca]	diamond	591	65.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix aurantiaca

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