metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1112809" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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
219058	219058	PRJNA1112809_P_NODE_129901_length_284_cov_2.800948_g126626_i0	PRJNA1112809	129901	284	2.800948	7.95469232	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	431	2.88e-116	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g126626	i0	94.035	633.971830985916	285	16	100	1	1	284	671826	671542	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	180048	431	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
221738	221738	PRJNA1112809_P_NODE_97061_length_337_cov_1.924242_g93786_i0	PRJNA1112809	97061	337	1.924242	6.48469554	Chloroflexota bacterium	2026724	Bacteria	Bacteria	217	1.07e-51	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g93786	i0	79.412	24.2344213649852	306	63	91	0	2	307	1378909	1378604	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	8167	217	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
1496201	1496201	PRJNA1112809_P_NODE_79862_length_383_cov_2.396774_g76587_i0	PRJNA1112809	79862	383	2.396774	9.17964442	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	691	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g76587	i0	99.217	740.185378590078	383	3	100	0	1	383	597889	598271	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	283491	691	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
4045728	4045728	PRJNA1112809_P_NODE_117664_length_300_cov_2.374449_g114389_i0	PRJNA1112809	117664	300	2.374449	7.123347	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	525	1.3699999999999995e-144	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g114389	i0	98.976	390.36	293	3	98	0	8	300	18706	18414	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	117108	525	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5322738	5322738	PRJNA1112809_P_NODE_171325_length_248_cov_2.920000_g168050_i0	PRJNA1112809	171325	248	2.92	7.2416	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	414	2.48e-111	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g168050	i0	96.774	56.508064516129	248	8	100	0	1	248	597696	597449	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	14014	414	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
5324432	5324432	PRJNA1112809_P_NODE_81125_length_379_cov_2.264706_g77850_i0	PRJNA1112809	81125	379	2.264706	8.58323574	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	634	2.819999999999999e-177	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g77850	i0	96.842	111.174142480211	380	10	100	2	1	379	3034212	3034590	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	42135	634	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5324530	5324530	PRJNA1112809_P_NODE_86125_length_364_cov_2.147766_g82850_i0	PRJNA1112809	86125	364	2.147766	7.81786824	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	250	1.14e-61	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g82850	i0	79.722	94.6318681318681	360	62	97	10	9	362	2269227	2268873	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	34446	250	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
6126628	6126628	PRJNA1112809_P_NODE_94485_length_343_cov_1.933333_g91210_i0	PRJNA1112809	94485	343	1.933333	6.63133219	Chloroflexus	1107	Bacteria	Bacteria	348	3.690000000000001e-91	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g91210	i0	88.66	172.784256559767	291	25	84	7	57	343	2874	2588	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	59265	348	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
6598459	6598459	PRJNA1112809_P_NODE_200966_length_210_cov_4.255474_g197691_i0	PRJNA1112809	200966	210	4.255474	8.9364954	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	307	3.5600000000000005e-79	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g197691	i0	93.689	115.485714285714	206	11	98	2	2	206	776769	776973	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	24252	307	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
7873069	7873069	PRJNA1112809_P_NODE_192407_length_241_cov_1.250000_g189132_i0	PRJNA1112809	192407	241	1.25	3.0125	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	396	8.7e-106	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g189132	i0	96.281	456.780082987552	242	7	100	2	1	241	19754	19514	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	110084	396	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9146445	9146445	PRJNA1112809_P_NODE_109968_length_312_cov_2.790795_g106693_i0	PRJNA1112809	109968	312	2.790795	8.7072804	uncultured Chloroflexi bacterium HF0200_09I09	710736	Bacteria	Bacteria	329	1.2e-85	NTclustered	gi\|297181775\|gb\|GU474878.1\|	710736	g106693	i0	85.804	24.9423076923077	317	38	99	4	2	312	9830	10145	Uncultured Chloroflexi bacterium HF0200_09I09 genomic sequence	blastn	7782	329	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexi bacterium HF0200_09I09
9146816	9146816	PRJNA1112809_P_NODE_129868_length_284_cov_3.180095_g126593_i0	PRJNA1112809	129868	284	3.180095	9.0314698	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	459	1.3199999999999998e-124	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g126593	i0	95.789	29.3485915492958	285	11	100	1	1	284	597228	597512	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	8335	459	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
10423492	10423492	PRJNA1112809_P_NODE_176729_length_247_cov_0.885057_g173454_i0	PRJNA1112809	176729	247	0.885057	2.18609079	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	200	7.529999999999999e-47	NTclustered	gi\|2621703475\|emb\|OY762538.1\|	3022862	g173454	i0	89.091	27.9716599190283	165	12	66	5	86	247	2554508	2554347	MAG: Tepidiformaceae bacterium isolate 22918afd-2252-4b5b-9d47-9fe66d5d45bf genome assembly, chromosome: 1	blastn	6909	200	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
11697914	11697914	PRJNA1112809_P_NODE_133370_length_280_cov_6.748792_g130095_i0	PRJNA1112809	133370	280	6.748792	18.8966176	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	243	1.4300000000000001e-59	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g130095	i0	85.532	53.2464285714286	235	30	83	4	3	235	3520855	3521087	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	14909	243	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11699688	11699688	PRJNA1112809_P_NODE_51630_length_528_cov_2.235165_g48365_i0	PRJNA1112809	51630	528	2.235165	11.8016712	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	881	0	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g48365	i0	96.786	360.056818181818	529	16	100	1	1	528	19599	19071	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	190110	881	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11700435	11700435	PRJNA1112809_P_NODE_90570_length_352_cov_3.702509_g87295_i0	PRJNA1112809	90570	352	3.702509	13.03283168	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	289	2.3299999999999996e-73	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g87295	i0	84.365	37.1392045454545	307	34	86	13	4	302	778739	778439	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	13073	289	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
12972784	12972784	PRJNA1112809_P_NODE_120651_length_296_cov_1.578475_g117376_i0	PRJNA1112809	120651	296	1.578475	4.672286	Chloroflexota bacterium	2026724	Bacteria	Bacteria	104	7.48e-18	NTclustered	gi\|2891482054\|emb\|OZ219802.1\|	2026724	g117376	i0	86.957	1.48648648648649	92	12	31	0	1	92	1748119	1748210	MAG: Chloroflexota bacterium isolate 50a8419b-8e17-430b-920a-11f3287aca29 genome assembly, chromosome: 2	blastn	440	104	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
12973006	12973006	PRJNA1112809_P_NODE_131891_length_282_cov_1.779904_g128616_i0	PRJNA1112809	131891	282	1.779904	5.01932928	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	255	1.85e-63	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g128616	i0	83.099	46.4964539007092	284	44	100	4	1	282	3522873	3523154	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	13112	255	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12973894	12973894	PRJNA1112809_P_NODE_181811_length_245_cov_0.895349_g178536_i0	PRJNA1112809	181811	245	0.895349	2.19360505	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	150	7.62e-32	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g178536	i0	78.661	34.7877551020408	239	42	97	5	6	243	2265056	2264826	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	8523	150	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
15522865	15522865	PRJNA1112809_P_NODE_194293_length_240_cov_4.479042_g191018_i0	PRJNA1112809	194293	240	4.479042	10.7497008	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	339	1.48e-88	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g191018	i0	92.437	453.145833333333	238	16	98	1	5	240	2202690	2202453	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	108755	339	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
15522965	15522965	PRJNA1112809_P_NODE_199833_length_226_cov_3.725490_g196558_i0	PRJNA1112809	199833	226	3.72549	8.4196074	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	296	8.42e-76	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g196558	i0	90.351	120.991150442478	228	18	100	4	1	226	2428117	2427892	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	27344	296	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15524345	15524345	PRJNA1112809_P_NODE_94433_length_343_cov_2.274074_g91158_i0	PRJNA1112809	94433	343	2.274074	7.80007382	Tepidiforma flava	3004094	Bacteria	Bacteria	529	1.2299999999999994e-145	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g91158	i0	94.461	94.6151603498542	343	19	100	0	1	343	248507	248165	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	32453	529	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
18072866	18072866	PRJNA1112809_P_NODE_66875_length_434_cov_2.329640_g63601_i0	PRJNA1112809	66875	434	2.32964	10.1106376	Chloroflexota bacterium	2026724	Bacteria	Bacteria	276	2.2799999999999999e-69	NTclustered	gi\|2621702192\|emb\|OY760183.1\|	2026724	g63601	i0	79.545	17.9470046082949	396	73	90	8	7	398	2733249	2733640	MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1	blastn	7789	276	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
20620733	20620733	PRJNA1112809_P_NODE_158037_length_256_cov_1.573770_g154762_i0	PRJNA1112809	158037	256	1.57377	4.0288512	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	176	1.32e-39	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g154762	i0	85.294	1.328125	170	25	66	0	44	213	274473	274304	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	340	176	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21897843	21897843	PRJNA1112809_P_NODE_53798_length_511_cov_3.251142_g50530_i0	PRJNA1112809	53798	511	3.251142	16.61333562	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	763	0	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g50530	i0	93.713	301.74168297456	509	32	99	0	1	509	2203159	2202651	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	154190	763	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae

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