metadata: contig_metadata: 25 rows where bioproject = "PRJEB49404" and tax

25 rows where bioproject = "PRJEB49404" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2664766	2664766	PRJEB49404_P_NODE_583703_length_162_cov_2.951220_g569902_i0	PRJEB49404	583703	162	2.95122	4.7809764	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	154	3.5900000000000004e-33	NTclustered	gi\|2893358404\|emb\|OZ220695.1\|	3022862	g569902	i0	84.663	153.382716049383	163	15	97	9	4	160	1223774	1223616	MAG: Tepidiformaceae bacterium isolate d5d77930-af5a-4506-8b4e-3340c6a42e1f genome assembly, chromosome: 1	blastn	24848	154	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
3932502	3932502	PRJEB49404_P_NODE_411464_length_209_cov_2.411765_g397663_i0	PRJEB49404	411464	209	2.411765	5.04058885	Chloroflexota bacterium	2026724	Bacteria	Bacteria	124	4.649999999999999e-31	NR	HEX6506913.1	2026724	g397663	i0	89.9	4.95215311004785	69	7	99	0	3	209	510	578	HEX6506913.1 PAS domain S-box protein [Chloroflexota bacterium]	diamond	1035	124	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
7368527	7368527	PRJEB49404_P_NODE_359106_length_231_cov_2.854167_g345305_i0	PRJEB49404	359106	231	2.854167	6.59312577	Caldilinea	233191	Bacteria	Bacteria	294	3.11e-75	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g345305	i0	89.956	108.311688311688	229	22	99	1	4	231	2937	2709	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	25020	294	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
8644097	8644097	PRJEB49404_P_NODE_361287_length_230_cov_2.638743_g347486_i0	PRJEB49404	361287	230	2.638743	6.0691089	Roseiflexus	120961	Bacteria	Bacteria	270	5.21e-68	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g347486	i0	91.045	116.808695652174	201	17	87	1	31	230	893	693	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	26866	272	0.992647058823529	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
11595604	11595604	PRJEB49404_P_NODE_638090_length_152_cov_1.814159_g624289_i0	PRJEB49404	638090	152	1.814159	2.75752168	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	126	7.22e-25	NTclustered	gi\|2893356069\|emb\|OZ220492.1\|	2614250	g624289	i0	81.818	5.06578947368421	154	25	100	3	1	152	2778094	2778246	MAG: Caldilineaceae bacterium isolate e886e3b1-96bd-41d4-96ed-8e2f365de7fb genome assembly, chromosome: 1	blastn	770	126	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
14132919	14132919	PRJEB49404_P_NODE_373372_length_225_cov_1.537634_g359571_i0	PRJEB49404	373372	225	1.537634	3.4596765	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	195	3.14e-45	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g359571	i0	88.679	331.884444444444	159	18	71	0	42	200	274850	274692	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	74674	195	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14145408	14145408	PRJEB49404_P_NODE_633152_length_153_cov_1.526316_g619351_i0	PRJEB49404	633152	153	1.526316	2.33526348	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	147	5.589999999999999e-31	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g619351	i0	90.826	149.78431372549	109	10	71	0	12	120	3495469	3495577	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	22917	147	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
16685474	16685474	PRJEB49404_P_NODE_460714_length_193_cov_1.396104_g446913_i0	PRJEB49404	460714	193	1.396104	2.69448072	Chloroflexota bacterium	2026724	Bacteria	Bacteria	102	7.93e-25	NR	MCC6178170.1	2026724	g446913	i0	78.3	6.45077720207254	60	13	93.3	0	14	193	22	81	MCC6178170.1 polyphosphate kinase 2 [Chloroflexota bacterium]	diamond	1245	102	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
16690259	16690259	PRJEB49404_P_NODE_559594_length_167_cov_2.843750_g545793_i0	PRJEB49404	559594	167	2.84375	4.7490625	Ardenticatenales bacterium	2614248	Bacteria	Bacteria	86.7	4.47e-18	NR	MBA3530781.1	2614248	g545793	i0	70.4	11.748502994012	54	16	97	0	1	162	274	327	MBA3530781.1 amino acid adenylation domain-containing protein [Ardenticatenales bacterium]	diamond	1962	86.7	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales			Ardenticatenales bacterium
17568825	17568825	PRJEB49404_P_NODE_345034_length_238_cov_2.623116_g331233_i0	PRJEB49404	345034	238	2.623116	6.24301608	Caldilinea	233191	Bacteria	Bacteria	119	2.08e-22	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g331233	i0	79.032	116.894957983193	186	29	74	8	62	238	321	505	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	27821	119	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
17956223	17956223	PRJEB49404_P_NODE_374835_length_224_cov_2.064865_g361034_i0	PRJEB49404	374835	224	2.064865	4.6252976	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	167	6.81e-37	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g361034	i0	84.615	24.7544642857143	169	24	75	2	12	178	64228	64396	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	5545	167	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17962515	17962515	PRJEB49404_P_NODE_504995_length_180_cov_2.503546_g491194_i0	PRJEB49404	504995	180	2.503546	4.5063828	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	261	2.33e-65	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g491194	i0	92.778	109.111111111111	180	13	100	0	1	180	275372	275551	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	19640	261	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21772809	21772809	PRJEB49404_P_NODE_193438_length_360_cov_2.542056_g179639_i0	PRJEB49404	193438	360	2.542056	9.1514016	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	291	6.64e-74	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g179639	i0	86.989	36.5638888888889	269	21	74	8	94	360	1398	1142	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	13163	291	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
24338187	24338187	PRJEB49404_P_NODE_533800_length_173_cov_2.022388_g519999_i0	PRJEB49404	533800	173	2.022388	3.49873124	uncultured Aggregatilineales bacterium	3063736	Bacteria	Bacteria	111	2.36e-20	NTclustered	gi\|2550423267\|gb\|OR335971.1\|	3063736	g519999	i0	92.308	0.901734104046243	78	6	45	0	96	173	2408	2331	Uncultured Aggregatilineales bacterium clone ASV-503 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	156	111	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Aggregatilineaceae		uncultured Aggregatilineales bacterium
26843826	26843826	PRJEB49404_P_NODE_351501_length_235_cov_1.933673_g337700_i0	PRJEB49404	351501	235	1.933673	4.54413155	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	122	4.33e-30	NR	HXH67943.1	2952938	g337700	i0	77.6	2.92340425531915	76	17	97	0	232	5	319	394	HXH67943.1 Ig-like domain-containing protein [Candidatus Limnocylindrales bacterium]	diamond	687	122	1	Bacteria		Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
26931898	26931898	PRJEB49404_P_NODE_331522_length_245_cov_2.388350_g317721_i0	PRJEB49404	331522	245	2.38835	5.8514575	Bacteria	2	Bacteria	Bacteria	69.3	4.08e-13	NR	HEY1292831.1	2026724	g317721	i0	50	2.20408163265306	64	32	78.4	0	16	207	30	93	HEY1292831.1 endonuclease [Chloroflexota bacterium]	diamond	540	69.7	0.994261119081779	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
28359832	28359832	PRJEB49404_P_NODE_324706_length_249_cov_1.866667_g310905_i0	PRJEB49404	324706	249	1.866667	4.64800083	Chloroflexota bacterium	2026724	Bacteria	Bacteria	95.5	7.06e-21	NR	MXX79737.1	2026724	g310905	i0	58.7	2.73493975903614	75	31	90.4	0	229	5	73	147	MXX79737.1 diaminopimelate decarboxylase [Chloroflexota bacterium]	diamond	681	95.5	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
28486325	28486325	PRJEB49404_P_NODE_518027_length_177_cov_1.782609_g504226_i0	PRJEB49404	518027	177	1.782609	3.15521793	Anaerolineae bacterium	2052143	Bacteria	Bacteria	97.1	1.18e-21	NR	MCD6289033.1	2052143	g504226	i0	66.1	1.94915254237288	59	20	100	0	177	1	180	238	MCD6289033.1 glycoside hydrolase family 78 protein [Anaerolineae bacterium]	diamond	345	97.1	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29552869	29552869	PRJEB49404_P_NODE_574190_length_164_cov_2.384000_g560389_i0	PRJEB49404	574190	164	2.384	3.90976	FCB group	1783270	Bacteria	Bacteria	70.5	2.06e-12	NR	MBN2549712.1	2073117	g560389	i0	57.4	3.95121951219512	54	23	98.8	0	2	163	136	189	MBN2549712.1 beta-lactamase family protein [Anaerolineales bacterium]	diamond	648	71.2	0.990168539325843	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29559676	29559676	PRJEB49404_P_NODE_488730_length_185_cov_1.342466_g474929_i0	PRJEB49404	488730	185	1.342466	2.4835621	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	43.1	0.0127	NR	HKS69084.1	2306968	g474929	i0	82.1	0.454054054054054	28	5	45.4	0	101	184	1	28	HKS69084.1 hydrogenase 4 subunit B [Ktedonobacterales bacterium]	diamond	84	43.1	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
29780789	29780789	PRJEB49404_P_NODE_239411_length_310_cov_1.653137_g225610_i0	PRJEB49404	239411	310	1.653137	5.1247247	Chloroflexota bacterium	2026724	Bacteria	Bacteria	195	3.019999999999999e-55	NR	MDQ6673653.1	2026724	g225610	i0	83.5	2.97096774193548	103	17	99.7	0	310	2	719	821	MDQ6673653.1 LLM class flavin-dependent oxidoreductase [Chloroflexota bacterium]	diamond	921	195	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29938870	29938870	PRJEB49404_P_NODE_351591_length_235_cov_1.882653_g337790_i0	PRJEB49404	351591	235	1.882653	4.42423455	Chloroflexota bacterium	2026724	Bacteria	Bacteria	102	2.3399999999999994e-23	NR	HLZ07472.1	2026724	g337790	i0	71.8	3.01276595744681	78	22	99.6	0	234	1	526	603	HLZ07472.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Chloroflexota bacterium]	diamond	708	102	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
30279996	30279996	PRJEB49404_P_NODE_574432_length_164_cov_2.264000_g560631_i0	PRJEB49404	574432	164	2.264	3.71296	root	1	Root_unresolved	Root_unresolved	53.9	5.45e-7	NR	OGO42623.1	1797654	g560631	i0	48	4.57317073170732	50	22	84.1	2	3	140	80	129	OGO42623.1 MAG: hypothetical protein A2W36_01520 [Chloroflexi bacterium RBG_16_58_14]	diamond	750	54.3	0.992633517495396	Bacteria		Bacillati	Chloroflexota					Chloroflexi bacterium RBG_16_58_14
31613714	31613714	PRJEB49404_P_NODE_276156_length_280_cov_1.593361_g262355_i0	PRJEB49404	276156	280	1.593361	4.4614108	Chloroflexota bacterium	2026724	Bacteria	Bacteria	169	1.41e-48	NR	HEX6508864.1	2026724	g262355	i0	80.6	0.996428571428571	93	18	99.6	0	280	2	191	283	HEX6508864.1 long-chain-fatty-acid--CoA ligase [Chloroflexota bacterium]	diamond	279	169	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
32404765	32404765	PRJEB49404_P_NODE_429879_length_203_cov_1.329268_g416078_i0	PRJEB49404	429879	203	1.329268	2.69841404	Anaerolineae bacterium	2052143	Bacteria	Bacteria	94	3.17e-21	NR	MCL6509822.1	2052143	g416078	i0	66.7	0.975369458128079	66	22	97.5	0	1	198	111	176	MCL6509822.1 zeta toxin family protein [Anaerolineae bacterium]	diamond	198	94	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);;