metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA681822" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA681822" 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
654977	654977	PRJNA681822_P_NODE_385981_length_251_cov_0.865169_g384492_i0	PRJNA681822	385981	251	0.865169	2.17157419	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	235	2.1e-57	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g384492	i0	83.794	105.852589641434	253	35	99	5	3	251	274536	274786	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	26569	235	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
1928694	1928694	PRJNA681822_P_NODE_185362_length_317_cov_1.262295_g183874_i0	PRJNA681822	185362	317	1.262295	4.00147515	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	263	1.26e-65	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g183874	i0	82.143	71.01261829653	308	53	97	2	11	317	8777178	8776872	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	22511	263	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
1932084	1932084	PRJNA681822_P_NODE_461082_length_243_cov_0.905882_g459592_i0	PRJNA681822	461082	243	0.905882	2.20129326	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	141	4.54e-29	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g459592	i0	78.97	172.362139917695	233	30	92	15	1	224	274533	274755	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	41884	141	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3205629	3205629	PRJNA681822_P_NODE_361843_length_257_cov_1.472826_g360354_i0	PRJNA681822	361843	257	1.472826	3.78516282	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	209	1.31e-49	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g360354	i0	81.538	1.01167315175097	260	42	100	5	1	257	9800703	9800959	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	260	209	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3205675	3205675	PRJNA681822_P_NODE_365303_length_256_cov_1.469945_g363814_i0	PRJNA681822	365303	256	1.469945	3.7630592	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2893358439\|emb\|OZ220731.1\|	2026734	g363814	i0	100	0.109375	28	0	11	0	77	104	2846511	2846538	MAG: Dehalococcoidia bacterium isolate 4e89fbe3-e5a8-4f6c-a4f9-b322f53a0d40 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
3207227	3207227	PRJNA681822_P_NODE_492043_length_228_cov_2.670968_g490553_i0	PRJNA681822	492043	228	2.670968	6.08980704	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	217	6.81e-52	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g490553	i0	84.071	18.7719298245614	226	34	99	2	1	225	8812017	8812241	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	4280	217	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4481424	4481424	PRJNA681822_P_NODE_245324_length_287_cov_2.705607_g243835_i0	PRJNA681822	245324	287	2.705607	7.76509209	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	226	1.48e-54	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g243835	i0	81.25	1.00348432055749	288	46	99	8	3	286	1405720	1405437	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	288	226	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
4481523	4481523	PRJNA681822_P_NODE_255964_length_285_cov_1.400943_g254475_i0	PRJNA681822	255964	285	1.400943	3.99268755	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	272	1.86e-68	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g254475	i0	84.028	79.1122807017544	288	41	100	5	1	285	6067190	6067475	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	22547	272	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4481548	4481548	PRJNA681822_P_NODE_257864_length_284_cov_2.819905_g256375_i0	PRJNA681822	257864	284	2.819905	8.0085302	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	401	2.2599999999999993e-107	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g256375	i0	92.527	91.9366197183099	281	19	99	2	1	280	6685327	6685606	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	26110	401	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4484264	4484264	PRJNA681822_P_NODE_480104_length_241_cov_0.916667_g478614_i0	PRJNA681822	480104	241	0.916667	2.20916747	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	145	3.48e-30	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g478614	i0	78.761	0.937759336099585	226	40	92	6	1	222	9558700	9558921	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	226	145	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5755697	5755697	PRJNA681822_P_NODE_153985_length_338_cov_2.705660_g152497_i0	PRJNA681822	153985	338	2.70566	9.1451308	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	586	7.07e-163	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g152497	i0	97.935	528.062130177515	339	6	100	1	1	338	2094034	2094372	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	178485	586	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5756790	5756790	PRJNA681822_P_NODE_225405_length_294_cov_0.968326_g223916_i0	PRJNA681822	225405	294	0.968326	2.84687844	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	350	8.64e-92	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g223916	i0	88.095	101.62925170068	294	35	100	0	1	294	5347032	5346739	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	29879	350	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7033559	7033559	PRJNA681822_P_NODE_377266_length_252_cov_1.720670_g375777_i0	PRJNA681822	377266	252	1.72067	4.3360884	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|1061024832\|gb\|CP017039.1\|	1889813	g375777	i0	99.603	1	252	1	100	0	1	252	507807	508058	Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome	blastn	252	460	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
7547653	7547653	PRJNA681822_P_NODE_106246_length_383_cov_3.861290_g104761_i0	PRJNA681822	106246	383	3.86129	14.7887407	Tepidiforma	2682228	Bacteria	Bacteria	592	1.7399999999999993e-164	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g104761	i0	94.517	100.853785900783	383	21	100	0	1	383	2204483	2204101	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	38627	593	0.998313659359191	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
9582916	9582916	PRJNA681822_P_NODE_325528_length_267_cov_1.587629_g324039_i0	PRJNA681822	325528	267	1.587629	4.23896943	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	191	4.96e-44	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g324039	i0	80.695	88.7790262172285	259	38	94	9	15	264	273771	273516	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	23704	191	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10859131	10859131	PRJNA681822_P_NODE_393309_length_250_cov_0.870056_g391820_i0	PRJNA681822	393309	250	0.870056	2.17514	Anaerolineae bacterium	2052143	Bacteria	Bacteria	243	1.25e-59	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g391820	i0	84.937	4.704	239	36	96	0	6	244	1750766	1750528	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	1176	243	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
11373392	11373392	PRJNA681822_P_NODE_12529_length_1077_cov_2.222112_g11526_i0	PRJNA681822	12529	1077	2.222112	23.93214624	Tepidiforma	2682228	Bacteria	Bacteria	1550	0	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g11526	i0	92.685	111.72051996286	1080	72	100	6	1	1077	2202835	2203910	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	120323	1550	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
12131497	12131497	PRJNA681822_P_NODE_155470_length_337_cov_2.034091_g153982_i0	PRJNA681822	155470	337	2.034091	6.85488667	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	368	2.78e-97	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g153982	i0	86.589	167.056379821958	343	34	100	12	1	337	3522040	3521704	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	56298	368	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12134337	12134337	PRJNA681822_P_NODE_376310_length_252_cov_2.988827_g374821_i0	PRJNA681822	376310	252	2.988827	7.53184404	Roseiflexus castenholzii	120962	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|156231356\|gb\|CP000804.1\|	383372	g374821	i0	96.774	0.123015873015873	31	1	12	0	109	139	1206856	1206826	Roseiflexus castenholzii DSM 13941, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
12136070	12136070	PRJNA681822_P_NODE_57870_length_491_cov_1.045455_g56401_i0	PRJNA681822	57870	491	1.045455	5.13318405	Anaerolineae bacterium	2052143	Bacteria	Bacteria	315	5.53e-81	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g56401	i0	83.483	5.13238289205703	333	55	68	0	1	333	1750052	1749720	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	2520	315	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
15957361	15957361	PRJNA681822_P_NODE_344213_length_262_cov_1.603175_g342724_i0	PRJNA681822	344213	262	1.603175	4.2003185	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	285	2.1699999999999997e-72	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g342724	i0	86.26	2.80152671755725	262	36	100	0	1	262	7145351	7145090	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	734	285	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17232845	17232845	PRJNA681822_P_NODE_366894_length_255_cov_2.346154_g365405_i0	PRJNA681822	366894	255	2.346154	5.9826927	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	213	1e-50	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g365405	i0	84.444	7.14117647058824	225	26	87	9	23	243	1448	1229	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	1821	213	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
18506705	18506705	PRJNA681822_P_NODE_341415_length_263_cov_1.294737_g339926_i0	PRJNA681822	341415	263	1.294737	3.40515831	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	145	3.85e-30	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g339926	i0	100	39.0228136882129	78	0	30	0	5	82	276201	276278	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	10263	145	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19779582	19779582	PRJNA681822_P_NODE_193376_length_312_cov_1.242678_g191888_i0	PRJNA681822	193376	312	1.242678	3.87715536	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	231	3.4899999999999997e-56	NTclustered	gi\|2814788335\|emb\|OY760861.2\|	3022862	g191888	i0	84.519	99.0833333333333	239	31	76	5	4	239	374892	374657	MAG: Tepidiformaceae bacterium isolate 815c9385-4915-413f-8b4b-d9ebc7d9cf62 genome assembly, chromosome: 1	blastn	30914	231	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
19780453	19780453	PRJNA681822_P_NODE_259316_length_284_cov_1.459716_g257827_i0	PRJNA681822	259316	284	1.459716	4.14559344	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	230	1.1299999999999995e-55	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g257827	i0	82.143	70.3767605633803	280	38	96	7	8	281	152768	152495	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	19987	230	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21054818	21054818	PRJNA681822_P_NODE_160137_length_334_cov_1.283525_g158649_i0	PRJNA681822	160137	334	1.283525	4.2869735	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	348	3.5900000000000003e-91	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g158649	i0	86.42	231.610778443114	324	37	96	7	1	320	2827480	2827800	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	77358	348	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
21058946	21058946	PRJNA681822_P_NODE_490417_length_231_cov_2.436709_g488927_i0	PRJNA681822	490417	231	2.436709	5.62879779	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	270	5.2299999999999984e-68	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g488927	i0	87.879	206.30303030303	231	27	100	1	1	231	2202993	2202764	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	47656	270	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
22331410	22331410	PRJNA681822_P_NODE_294098_length_276_cov_0.778325_g292609_i0	PRJNA681822	294098	276	0.778325	2.148177	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	375	1.3299999999999998e-99	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g292609	i0	91.882	54.1884057971015	271	19	98	3	1	270	20137	20405	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	14956	375	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22333020	22333020	PRJNA681822_P_NODE_427538_length_247_cov_0.885057_g426049_i0	PRJNA681822	427538	247	0.885057	2.18609079	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	180	9.82e-41	NTclustered	gi\|148566298\|gb\|CP000686.1\|	357808	g426049	i0	80.162	16.8663967611336	247	44	99	5	1	245	4270628	4270385	Roseiflexus sp. RS-1, complete genome	blastn	4166	180	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
22848663	22848663	PRJNA681822_P_NODE_77438_length_431_cov_1.868715_g75960_i0	PRJNA681822	77438	431	1.868715	8.05416165	Chloroflexus	1107	Bacteria	Bacteria	303	1.04e-77	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g75960	i0	80.576	120.447795823666	417	62	95	14	21	429	1317	912	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	51913	303	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
23604745	23604745	PRJNA681822_P_NODE_137619_length_351_cov_3.848921_g136131_i0	PRJNA681822	137619	351	3.848921	13.50971271	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	510	4.55e-140	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g136131	i0	92.877	317.809116809117	351	25	100	0	1	351	2202616	2202266	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	111551	510	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);;