metadata: contig_metadata: 29 rows where bioproject = "PRJNA792582", tax_kingdom = "Bacillati" and tax

29 rows where bioproject = "PRJNA792582", 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
3328153	3328153	PRJNA792582_P_NODE_40463_length_276_cov_2.285714_g39649_i0	PRJNA792582	40463	276	2.285714	6.30857064	Chloroflexota bacterium	2026724	Bacteria	Bacteria	75	5.42e-9	NTclustered	gi\|2621701252\|emb\|OY759972.1\|	2026724	g39649	i0	95.652	16.3731884057971	46	2	17	0	6	51	4246314	4246359	MAG: Chloroflexota bacterium isolate 55c93f92-7b64-48b2-973a-1fcfb2e6d712 genome assembly, chromosome: 1	blastn	4519	75	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
3766945	3766945	PRJNA792582_P_NODE_1343_length_1334_cov_3.737510_g972_i0	PRJNA792582	1343	1334	3.73751	49.8583834	Chloroflexus	1107	Bacteria	Bacteria	632	3.8299999999999994e-176	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g972	i0	76.357	517.436281859071	1345	220	98	79	26	1334	24	1306	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	690260	632	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
4605535	4605535	PRJNA792582_P_NODE_56444_length_244_cov_0.900585_g55630_i0	PRJNA792582	56444	244	0.900585	2.1974274	Bacillati	1783272	Bacteria	Bacteria	162	3.33e-44	NR	WP_029215479.1	1325125	g55630	i0	90	15.7377049180328	80	8	98.4	0	3	242	500	579	WP_029215479.1 leucine--tRNA ligase [Kallotenue papyrolyticum]	diamond	3840	162	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Kallotenuales	Kallotenuaceae	Kallotenue	Kallotenue papyrolyticum
5880327	5880327	PRJNA792582_P_NODE_27425_length_330_cov_1.198444_g26611_i0	PRJNA792582	27425	330	1.198444	3.9548652	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	108	6.54e-19	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g26611	i0	73.746	11.9787878787879	339	61	98	22	1	325	1333495	1333819	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	3953	108	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5880702	5880702	PRJNA792582_P_NODE_58285_length_242_cov_0.911243_g57471_i0	PRJNA792582	58285	242	0.911243	2.20520806	Chloroflexota bacterium	2026724	Bacteria	Bacteria	122	1.3199999999999999e-31	NR	MBI5949993.1	2026724	g57471	i0	77.5	0.991735537190083	80	18	99.2	0	241	2	70	149	MBI5949993.1 ABC transporter permease [Chloroflexota bacterium]	diamond	240	122	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
7593764	7593764	PRJNA792582_P_NODE_7306_length_619_cov_6.054945_g6520_i0	PRJNA792582	7306	619	6.054945	37.48010955	Chloroflexus	1107	Bacteria	Bacteria	228	9.499999999999999e-55	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g6520	i0	83.019	37.5961227786753	265	32	42	12	1	259	1905	1648	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	23272	228	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
8429919	8429919	PRJNA792582_P_NODE_15447_length_438_cov_2.000000_g14633_i0	PRJNA792582	15447	438	2	8.76	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	122	3.179999999999999e-23	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g14633	i0	90.323	14.5159817351598	93	9	21	0	165	257	3520995	3521087	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	6358	122	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9705385	9705385	PRJNA792582_P_NODE_50888_length_250_cov_0.870056_g50074_i0	PRJNA792582	50888	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	90.1	8.79e-19	NR	MCC6629104.1	2026724	g50074	i0	53	1.992	83	39	99.6	0	249	1	3	85	MCC6629104.1 aminoglycoside phosphotransferase family protein [Chloroflexota bacterium]	diamond	498	90.9	0.991199119911991	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
16079362	16079362	PRJNA792582_P_NODE_26953_length_333_cov_1.019231_g26139_i0	PRJNA792582	26953	333	1.019231	3.39403923	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	374	5.9e-99	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g26139	i0	87.164	81.3423423423423	335	36	99	6	2	333	274725	275055	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	27087	374	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17355231	17355231	PRJNA792582_P_NODE_35794_length_289_cov_1.180556_g34980_i0	PRJNA792582	35794	289	1.180556	3.41180684	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	324	5.13e-84	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g34980	i0	86.851	4.0242214532872	289	38	100	0	1	289	3623416	3623128	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	1163	324	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17355252	17355252	PRJNA792582_P_NODE_37414_length_284_cov_3.184834_g36600_i0	PRJNA792582	37414	284	3.184834	9.04492856	Chloroflexota bacterium	2026724	Bacteria	Bacteria	100	1.33e-22	NR	MDQ2743941.1	2026724	g36600	i0	71.1	0.802816901408451	76	22	80.3	0	45	272	24	99	MDQ2743941.1 YbfB/YjiJ family MFS transporter [Chloroflexota bacterium]	diamond	228	100	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
18628367	18628367	PRJNA792582_P_NODE_19555_length_389_cov_1.889241_g18741_i0	PRJNA792582	19555	389	1.889241	7.34914749	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	198	4.51e-46	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g18741	i0	78.947	1.34447300771208	304	55	77	9	89	389	3522299	3522002	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	523	198	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19904036	19904036	PRJNA792582_P_NODE_60716_length_228_cov_2.425806_g59902_i0	PRJNA792582	60716	228	2.425806	5.53083768	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	148	2.52e-31	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g59902	i0	92.381	37.0131578947368	105	6	46	2	1	104	273647	273544	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	8439	148	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21179484	21179484	PRJNA792582_P_NODE_40317_length_277_cov_1.250000_g39503_i0	PRJNA792582	40317	277	1.25	3.4625	Chloroflexus aggregans	152260	Bacteria	Bacteria	163	1.13e-35	NTclustered	gi\|219541215\|gb\|CP001337.1\|	326427	g39503	i0	79.216	67.7653429602888	255	38	92	9	24	277	805099	805339	Chloroflexus aggregans DSM 9485, complete genome	blastn	18771	163	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
24166872	24166872	PRJNA792582_P_NODE_21659_length_370_cov_1.744108_g20845_i0	PRJNA792582	21659	370	1.744108	6.4531996	Roseiflexus	120961	Bacteria	Bacteria	281	4.120000000000001e-71	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g20845	i0	80.789	441.691891891892	380	55	100	17	1	370	608	979	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	163426	281	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
26927208	26927208	PRJNA792582_P_NODE_43342_length_269_cov_1.020408_g42528_i0	PRJNA792582	43342	269	1.020408	2.74489752	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	131	9.799999999999999e-35	NR	CAA9278610.1	1672391	g42528	i0	78.2	0.970260223048327	87	19	97	0	263	3	244	330	CAA9278610.1 MAG: diguanylate cyclase/phosphodiesterase (GGDEF & EAL domains) with PAS/PAC sensor(s) [uncultured Chloroflexia bacterium]	diamond	261	131	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
28285263	28285263	PRJNA792582_P_NODE_37106_length_285_cov_1.924528_g36292_i0	PRJNA792582	37106	285	1.924528	5.4849048	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	84.7	5.97e-17	NR	MDP3768807.1	2026734	g36292	i0	61.9	0.663157894736842	63	21	63.2	1	181	2	18	80	MDP3768807.1 acyl-CoA dehydrogenase family protein [Dehalococcoidia bacterium]	diamond	189	84.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
28989568	28989568	PRJNA792582_P_NODE_52168_length_249_cov_0.875000_g51354_i0	PRJNA792582	52168	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	101	4.5899999999999996e-23	NR	MFO7539337.1	2026724	g51354	i0	63.3	2.90361445783133	79	29	95.2	0	2	238	213	291	MFO7539337.1 glutamine synthetase family protein [Chloroflexota bacterium]	diamond	723	101	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29359091	29359091	PRJNA792582_P_NODE_41449_length_274_cov_1.268657_g40635_i0	PRJNA792582	41449	274	1.268657	3.47612018	Chloroflexota bacterium	2026724	Bacteria	Bacteria	159	1.95e-47	NR	NLD71977.1	2026724	g40635	i0	98.7	0.843065693430657	77	1	84.3	0	43	273	1	77	NLD71977.1 flavin reductase family protein [Chloroflexota bacterium]	diamond	231	159	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29737644	29737644	PRJNA792582_P_NODE_20630_length_379_cov_1.359477_g19816_i0	PRJNA792582	20630	379	1.359477	5.15241783	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	99.8	9.59e-23	NR	MCL2141044.1	2026734	g19816	i0	46.8	2.05013192612137	124	56	98.2	2	379	8	1	114	MCL2141044.1 InlB B-repeat-containing protein [Dehalococcoidia bacterium]	diamond	777	99.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
30559063	30559063	PRJNA792582_P_NODE_29553_length_317_cov_2.598361_g28739_i0	PRJNA792582	29553	317	2.598361	8.23680437	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	84	2.61e-17	NR	MBA3946010.1	2720503	g28739	i0	46.2	1.00315457413249	106	51	96.5	2	311	6	1	104	MBA3946010.1 hypothetical protein [Herpetosiphonaceae bacterium]	diamond	318	84	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
30717155	30717155	PRJNA792582_P_NODE_47114_length_258_cov_1.664865_g46300_i0	PRJNA792582	47114	258	1.664865	4.2953517	Anaerolineae bacterium	2052143	Bacteria	Bacteria	135	5.01e-35	NR	MCC6893451.1	2052143	g46300	i0	89.3	0.872093023255814	75	8	87.2	0	34	258	7	81	MCC6893451.1 DUF3987 domain-containing protein [Anaerolineae bacterium]	diamond	225	135	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31001725	31001725	PRJNA792582_P_NODE_40954_length_275_cov_1.524752_g40140_i0	PRJNA792582	40954	275	1.524752	4.193068	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	88.6	3.92e-18	NR	HEX6288285.1	2720503	g40140	i0	59.5	0.916363636363636	84	34	91.6	0	274	23	13	96	HEX6288285.1 molybdopterin-dependent oxidoreductase [Herpetosiphonaceae bacterium]	diamond	252	88.6	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
31105464	31105464	PRJNA792582_P_NODE_35735_length_289_cov_1.342593_g34921_i0	PRJNA792582	35735	289	1.342593	3.88009377	Bacteria	2	Bacteria	Bacteria	61.2	3.8e-9	NR	MES2210575.1	2026724	g34921	i0	43.2	1.4636678200692	95	43	89.3	3	31	288	15	107	MES2210575.1 rhodanese-like domain-containing protein [Chloroflexota bacterium]	diamond	423	61.6	0.993506493506494	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31507672	31507672	PRJNA792582_P_NODE_38456_length_282_cov_1.138756_g37642_i0	PRJNA792582	38456	282	1.138756	3.21129192	Anaerolineales bacterium	2073117	Bacteria	Bacteria	45.8	8.97e-4	NR	MBE7551093.1	2073117	g37642	i0	46.8	0.5	47	16	46.8	3	15	146	49	89	MBE7551093.1 hypothetical protein [Anaerolineales bacterium]	diamond	141	45.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31602524	31602524	PRJNA792582_P_NODE_37796_length_283_cov_3.038095_g36982_i0	PRJNA792582	37796	283	3.038095	8.59780885	Anaerolineae bacterium	2052143	Bacteria	Bacteria	43.1	0.044	NR	HUW96660.1	2052143	g36982	i0	34.7	0.795053003533569	75	47	77.4	1	37	255	332	406	HUW96660.1 DNA mismatch repair endonuclease MutL [Anaerolineae bacterium]	diamond	225	43.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31728792	31728792	PRJNA792582_P_NODE_50277_length_251_cov_0.865169_g49463_i0	PRJNA792582	50277	251	0.865169	2.17157419	Chloroflexota bacterium	2026724	Bacteria	Bacteria	122	1.75e-32	NR	PLS79625.1	2026724	g49463	i0	77.1	0.99203187250996006	83	19	99.2	0	3	251	14	96	PLS79625.1 MAG: sulfite exporter TauE/SafE family protein, partial [Chloroflexota bacterium]	diamond	249	122	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32045328	32045328	PRJNA792582_P_NODE_32338_length_304_cov_1.311688_g31524_i0	PRJNA792582	32338	304	1.311688	3.98753152	Anaerolineae bacterium	2052143	Bacteria	Bacteria	72.4	1.7e-12	NR	RMF40899.1	2052143	g31524	i0	50.7	2.24013157894737	69	34	68.1	0	3	209	46	114	RMF40899.1 MAG: ribokinase [Anaerolineae bacterium]	diamond	681	72.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32488402	32488402	PRJNA792582_P_NODE_42259_length_272_cov_1.175879_g41445_i0	PRJNA792582	42259	272	1.175879	3.19839088	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	42.7	0.0495	NR	MEZ4639958.1	2614250	g41445	i0	36.1	0.672794117647059	61	32	66.2	2	206	27	217	271	MEZ4639958.1 hypothetical protein [Caldilineaceae bacterium]	diamond	183	42.7	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae 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);;