metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA928559" 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
902673	902673	PRJNA928559_P_NODE_152961_length_285_cov_0.834906_g151392_i0	PRJNA928559	152961	285	0.834906	2.3794821	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	156	1.95e-33	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g151392	i0	77.899	160.185964912281	276	43	93	16	2	267	239181	238914	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	45653	156	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
903392	903392	PRJNA928559_P_NODE_203201_length_246_cov_3.838150_g201632_i0	PRJNA928559	203201	246	3.83815	9.441849	Anaerolineales bacterium	2073117	Bacteria	Bacteria	359	1.1699999999999999e-94	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g201632	i0	93.724	221.89837398374	239	15	97	0	8	246	1232697	1232459	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	54587	359	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
4730673	4730673	PRJNA928559_P_NODE_124784_length_318_cov_2.510204_g123215_i0	PRJNA928559	124784	318	2.510204	7.98244872	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	187	7.83e-43	NTclustered	gi\|2891482138\|emb\|OZ219871.1\|	2026734	g123215	i0	81.659	1.44339622641509	229	39	71	2	93	318	1373393	1373165	MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 5	blastn	459	187	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
6005698	6005698	PRJNA928559_P_NODE_142945_length_295_cov_3.576577_g141376_i0	PRJNA928559	142945	295	3.576577	10.55090215	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	108	5.76e-19	NTclustered	gi\|2621704923\|emb\|OY762210.1\|	2026734	g141376	i0	86.735	7.72542372881356	98	11	33	2	179	276	1468963	1468868	MAG: Dehalococcoidia bacterium isolate 6876e8b5-2850-4095-a133-48836ebfd8cd genome assembly, chromosome: 1	blastn	2279	108	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7281378	7281378	PRJNA928559_P_NODE_200926_length_247_cov_2.689655_g199357_i0	PRJNA928559	200926	247	2.689655	6.64344785	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	281	2.62e-71	NTclustered	gi\|2891482139\|emb\|OZ219872.1\|	2026734	g199357	i0	87.059	18.3562753036437	255	25	100	4	1	247	448085	447831	MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 6	blastn	4534	281	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7281582	7281582	PRJNA928559_P_NODE_216326_length_240_cov_4.233533_g214757_i0	PRJNA928559	216326	240	4.233533	10.1604792	uncultured Chloroflexi bacterium HF0200_09I09	710736	Bacteria	Bacteria	344	3.18e-90	NTclustered	gi\|297181775\|gb\|GU474878.1\|	710736	g214757	i0	92.827	142.55	237	17	99	0	1	237	8988	9224	Uncultured Chloroflexi bacterium HF0200_09I09 genomic sequence	blastn	34212	344	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexi bacterium HF0200_09I09
7281963	7281963	PRJNA928559_P_NODE_35526_length_556_cov_1.020704_g33976_i0	PRJNA928559	35526	556	1.020704	5.67511424	Anaerolineales bacterium	2073117	Bacteria	Bacteria	470	1.28e-127	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g33976	i0	85.319	295.68345323741	470	52	83	15	6	468	3065930	3065471	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	164400	470	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
8554975	8554975	PRJNA928559_P_NODE_117607_length_328_cov_3.949020_g116038_i0	PRJNA928559	117607	328	3.94902	12.9527856	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	446	1.21e-120	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g116038	i0	91.385	195.966463414634	325	28	99	0	4	328	670041	670365	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	64277	446	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
8555385	8555385	PRJNA928559_P_NODE_147207_length_291_cov_1.064220_g145638_i0	PRJNA928559	147207	291	1.06422	3.0968802	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	183	9.16e-42	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g145638	i0	83.168	33.8762886597938	202	32	69	2	91	290	64396	64195	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	9858	183	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8555488	8555488	PRJNA928559_P_NODE_154487_length_283_cov_1.571429_g152918_i0	PRJNA928559	154487	283	1.571429	4.44714407	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	339	1.79e-88	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g152918	i0	88.612	426.420494699647	281	29	99	3	1	280	17649	17371	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	120677	339	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9829963	9829963	PRJNA928559_P_NODE_122688_length_321_cov_2.080645_g121119_i0	PRJNA928559	122688	321	2.080645	6.67887045	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	100	1.06e-16	NTclustered	gi\|2893358447\|emb\|OZ220739.1\|	3022862	g121119	i0	83.929	10.2803738317757	112	11	34	6	15	123	1096139	1096032	MAG: Tepidiformaceae bacterium isolate ddb3cf28-bb63-44a4-8fd1-08202229d10a genome assembly, chromosome: 1	blastn	3300	100	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
9830154	9830154	PRJNA928559_P_NODE_135548_length_304_cov_2.580087_g133979_i0	PRJNA928559	135548	304	2.580087	7.84346448	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	348	3.23e-91	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g133979	i0	87.879	14.1381578947368	297	35	98	1	3	299	3495597	3495892	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	4298	348	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
9830922	9830922	PRJNA928559_P_NODE_185708_length_254_cov_2.132597_g184139_i0	PRJNA928559	185708	254	2.132597	5.41679638	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	213	1e-50	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g184139	i0	89.017	14.8740157480315	173	17	68	2	83	254	2202583	2202412	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	3778	213	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
9832082	9832082	PRJNA928559_P_NODE_63288_length_439_cov_2.327869_g61719_i0	PRJNA928559	63288	439	2.327869	10.21934491	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	385	3.68e-102	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g61719	i0	82.989	541.71298405467	435	64	98	9	1	431	3521594	3522022	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	237812	385	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11106551	11106551	PRJNA928559_P_NODE_177029_length_261_cov_5.000000_g175460_i0	PRJNA928559	177029	261	5	13.05	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	248	2.8299999999999997e-61	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g175460	i0	84.328	156.92337164751	268	27	97	10	8	260	3494414	3494681	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	40957	248	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
12382855	12382855	PRJNA928559_P_NODE_227150_length_202_cov_5.410853_g225581_i0	PRJNA928559	227150	202	5.410853	10.92992306	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	119	1.71e-22	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g225581	i0	89.362	97.2079207920792	94	10	47	0	54	147	7869	7776	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	19636	119	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
12732039	12732039	PRJNA928559_P_NODE_108350_length_342_cov_4.505576_g106781_i0	PRJNA928559	108350	342	4.505576	15.40906992	Chloroflexus	1107	Bacteria	Bacteria	392	1.68e-104	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g106781	i0	88.82	398.605263157895	322	33	94	3	14	333	924	604	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	136323	392	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
13657534	13657534	PRJNA928559_P_NODE_29731_length_599_cov_1.937262_g28205_i0	PRJNA928559	29731	599	1.937262	11.60419938	uncultured Anaerolineaceae bacterium	310067	Bacteria	Bacteria	1042	0	NTclustered	gi\|1840537517\|gb\|MT457636.1\|	310067	g28205	i0	98.164	96.8213689482471	599	8	100	3	1	599	596	1	Uncultured Anaerolineaceae bacterium clone glass-SS_A-C7 16S ribosomal RNA gene, partial sequence	blastn	57996	1042	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		uncultured Anaerolineaceae bacterium
14931892	14931892	PRJNA928559_P_NODE_36252_length_551_cov_2.403766_g34702_i0	PRJNA928559	36252	551	2.403766	13.24475066	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	640	9.099999999999998e-179	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g34702	i0	87.862	860.662431941924	552	57	99	9	7	551	3495396	3494848	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	474225	640	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
16555416	16555416	PRJNA928559_P_NODE_197173_length_249_cov_0.886364_g195604_i0	PRJNA928559	197173	249	0.886364	2.20704636	Roseiflexus	120961	Bacteria	Bacteria	283	7.339999999999999e-72	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g195604	i0	87.251	252.694779116466	251	29	100	3	1	249	872	623	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	62921	283	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
17482062	17482062	PRJNA928559_P_NODE_32694_length_575_cov_2.717131_g31163_i0	PRJNA928559	32694	575	2.717131	15.62350325	Anaerolineales bacterium	2073117	Bacteria	Bacteria	863	0	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g31163	i0	93.739	154.074782608696	575	36	100	0	1	575	1576548	1575974	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	88593	863	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
18754411	18754411	PRJNA928559_P_NODE_168375_length_269_cov_3.122449_g166806_i0	PRJNA928559	168375	269	3.122449	8.39938781	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	305	1.71e-78	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g166806	i0	89.157	196.405204460967	249	21	91	6	17	262	964	1209	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	52833	305	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
19104036	19104036	PRJNA928559_P_NODE_100895_length_355_cov_2.085106_g99326_i0	PRJNA928559	100895	355	2.085106	7.4021263	Herpetosiphon	64	Bacteria	Bacteria	387	8.11e-103	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g99326	i0	86.957	5.83098591549296	345	43	97	2	6	348	1526	1182	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	2070	387	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
20029669	20029669	PRJNA928559_P_NODE_183996_length_256_cov_0.852459_g182427_i0	PRJNA928559	183996	256	0.852459	2.18229504	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	289	1.63e-73	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g182427	i0	87.16	362.6171875	257	29	100	3	1	256	2202755	2203008	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	92830	289	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
20029694	20029694	PRJNA928559_P_NODE_185596_length_254_cov_2.419890_g184027_i0	PRJNA928559	185596	254	2.41989	6.1465206	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	409	1.19e-109	NTclustered	gi\|2891482139\|emb\|OZ219872.1\|	2026734	g184027	i0	95.669	98.755905511811	254	11	100	0	1	254	446695	446948	MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 6	blastn	25084	409	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20379128	20379128	PRJNA928559_P_NODE_164856_length_273_cov_1.225000_g163287_i0	PRJNA928559	164856	273	1.225	3.34425	root	1	Root_unresolved	Root_unresolved	261	3.83e-65	NTclustered	gi\|2531949168\|emb\|OY282456.1\|	498747	g163287	i0	88.128	81.8461538461538	219	26	80	0	48	266	3081722	3081940	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	22344	263	0.992395437262357	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
22579890	22579890	PRJNA928559_P_NODE_159378_length_278_cov_1.634146_g157809_i0	PRJNA928559	159378	278	1.634146	4.54292588	Pelolinea submarina	913107	Bacteria	Bacteria	274	5.02e-69	NTclustered	gi\|1446038753\|dbj\|AP018437.1\|	913107	g157809	i0	85.992	23.3237410071942	257	35	92	1	1	257	3508262	3508517	Pelolinea submarina MO-CFX1 DNA, complete genome	blastn	6484	274	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Pelolinea	Pelolinea submarina
22580217	22580217	PRJNA928559_P_NODE_180798_length_258_cov_2.378378_g179229_i0	PRJNA928559	180798	258	2.378378	6.13621524	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	135	2.27e-27	NTclustered	gi\|2621702714\|emb\|OY759598.1\|	2026734	g179229	i0	87.826	48.5271317829457	115	14	45	0	22	136	1788940	1789054	MAG: Dehalococcoidia bacterium isolate 9e3974e8-1b76-4a2a-ace1-a6b9f67a3735 genome assembly, chromosome: 1	blastn	12520	135	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
25128395	25128395	PRJNA928559_P_NODE_130120_length_311_cov_2.193277_g128551_i0	PRJNA928559	130120	311	2.193277	6.82109147	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	248	3.45e-61	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g128551	i0	85.656	6.08360128617363	244	25	78	8	70	311	1399	1164	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	1892	248	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1

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