metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA951810" 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
937474	937474	PRJNA951810_P_NODE_48541_length_310_cov_5.957806_g48198_i0	PRJNA951810	48541	310	5.957806	18.4691986	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	121	7.83e-23	NTclustered	gi\|2531950174\|emb\|OY282494.1\|	498747	g48198	i0	93.75	38.8387096774194	80	5	26	0	53	132	3099673	3099594	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	12040	121	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
2212755	2212755	PRJNA951810_P_NODE_48062_length_310_cov_6.105485_g47719_i0	PRJNA951810	48062	310	6.105485	18.9270035	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	121	7.83e-23	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g47719	i0	85.47	12.141935483871	117	15	37	2	1	116	237041	236926	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	3764	121	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3487802	3487802	PRJNA951810_P_NODE_31223_length_358_cov_3.301754_g30881_i0	PRJNA951810	31223	358	3.301754	11.82027932	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	243	1.8700000000000001e-59	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g30881	i0	86.425	31.3882681564246	221	30	62	0	21	241	1513611	1513831	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	11237	243	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
3488935	3488935	PRJNA951810_P_NODE_95843_length_295_cov_3.522523_g95499_i0	PRJNA951810	95843	295	3.522523	10.39144285	Chloroflexota bacterium	2026724	Bacteria	Bacteria	65.8	3.52e-6	NTclustered	gi\|2891482054\|emb\|OZ219802.1\|	2026724	g95499	i0	100	25.0305084745763	35	0	14	0	208	242	1255808	1255774	MAG: Chloroflexota bacterium isolate 50a8419b-8e17-430b-920a-11f3287aca29 genome assembly, chromosome: 2	blastn	7384	65.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
4766057	4766057	PRJNA951810_P_NODE_60664_length_310_cov_3.468354_g60321_i0	PRJNA951810	60664	310	3.468354	10.7518974	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	100	1.02e-16	NTclustered	gi\|148566298\|gb\|CP000686.1\|	357808	g60321	i0	81.818	8.86451612903226	121	20	39	2	31	150	4092689	4092570	Roseiflexus sp. RS-1, complete genome	blastn	2748	100	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
6039566	6039566	PRJNA951810_P_NODE_165465_length_246_cov_1.335260_g165120_i0	PRJNA951810	165465	246	1.33526	3.2847396	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	137	5.96e-28	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g165120	i0	80.899	0.723577235772358	178	31	72	3	52	227	8011424	8011248	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	178	137	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
6041291	6041291	PRJNA951810_P_NODE_86685_length_298_cov_5.173333_g86341_i0	PRJNA951810	86685	298	5.173333	15.41653234	Chloroflexota bacterium	2026724	Bacteria	Bacteria	187	7.279999999999999e-43	NTclustered	gi\|2621701252\|emb\|OY759972.1\|	2026724	g86341	i0	78.929	0.939597315436242	280	55	93	4	21	298	3767043	3766766	MAG: Chloroflexota bacterium isolate 55c93f92-7b64-48b2-973a-1fcfb2e6d712 genome assembly, chromosome: 1	blastn	280	187	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
7314368	7314368	PRJNA951810_P_NODE_161046_length_249_cov_3.136364_g160701_i0	PRJNA951810	161046	249	3.136364	7.80954636	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	171	5.96e-38	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g160701	i0	80.93	79.8032128514056	215	41	86	0	1	215	6967523	6967309	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	19871	171	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9864484	9864484	PRJNA951810_P_NODE_168588_length_243_cov_5.529412_g168243_i0	PRJNA951810	168588	243	5.529412	13.43647116	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621704081\|emb\|OY761543.1\|	2026734	g168243	i0	100	0.11522633744856	28	0	12	0	188	215	497140	497167	MAG: Dehalococcoidia bacterium isolate d8cdd4bd-f85c-46d1-a80f-042a7445dbc9 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
9864598	9864598	PRJNA951810_P_NODE_176468_length_236_cov_2.858896_g176123_i0	PRJNA951810	176468	236	2.858896	6.74699456	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g176123	i0	100	0.11864406779661	28	0	12	0	168	195	873448	873421	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9866248	9866248	PRJNA951810_P_NODE_89408_length_297_cov_9.254464_g89064_i0	PRJNA951810	89408	297	9.254464	27.48575808	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	115	3.47e-21	NTclustered	gi\|2621703647\|emb\|OY762633.1\|	2026734	g89064	i0	94.595	18.959595959596	74	4	25	0	81	154	199721	199794	MAG: Dehalococcoidia bacterium isolate 17254eae-7cb3-4ac9-839e-465292e2b3d4 genome assembly, chromosome: 1	blastn	5631	115	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
11139630	11139630	PRJNA951810_P_NODE_139709_length_266_cov_1.715026_g139364_i0	PRJNA951810	139709	266	1.715026	4.56196916	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	69.4	2.42e-7	NTclustered	gi\|2891482139\|emb\|OZ219872.1\|	2026734	g139364	i0	83.784	0.556390977443609	74	10	27	2	194	266	170972	171044	MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 6	blastn	148	69.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
11140900	11140900	PRJNA951810_P_NODE_33689_length_342_cov_8.200743_g33346_i0	PRJNA951810	33689	342	8.200743	28.04654106	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	65.8	4.15e-6	NTclustered	gi\|2531976033\|emb\|OY282371.1\|	498747	g33346	i0	100	203.22514619883	35	0	17	0	265	299	1648847	1648881	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	69503	65.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
12415450	12415450	PRJNA951810_P_NODE_163970_length_247_cov_2.011494_g163625_i0	PRJNA951810	163970	247	2.011494	4.96839018	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	313	9.28e-81	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g163625	i0	89.474	1	247	26	100	0	1	247	3600212	3599966	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	247	313	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
12415955	12415955	PRJNA951810_P_NODE_195770_length_202_cov_4.968992_g195425_i0	PRJNA951810	195770	202	4.968992	10.03736384	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	241	3.5e-59	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g195425	i0	88.119	1	202	24	100	0	1	202	5259150	5259351	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	202	241	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
13689542	13689542	PRJNA951810_P_NODE_133631_length_270_cov_5.197970_g133286_i0	PRJNA951810	133631	270	5.19797	14.034519	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	58.4	5.32e-4	NTclustered	gi\|2621702714\|emb\|OY759598.1\|	2026734	g133286	i0	97.059	1.76296296296296	34	1	13	0	87	120	2969570	2969537	MAG: Dehalococcoidia bacterium isolate 9e3974e8-1b76-4a2a-ace1-a6b9f67a3735 genome assembly, chromosome: 1	blastn	476	58.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
13691836	13691836	PRJNA951810_P_NODE_93371_length_296_cov_4.035874_g93027_i0	PRJNA951810	93371	296	4.035874	11.94618704	Tepidiforma flava	3004094	Bacteria	Bacteria	163	1.22e-35	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g93027	i0	87.324	53.8243243243243	142	18	48	0	153	294	2377659	2377518	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	15932	163	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
16238946	16238946	PRJNA951810_P_NODE_149333_length_258_cov_6.286486_g148988_i0	PRJNA951810	149333	258	6.286486	16.21913388	Dehalogenimonas lykanthroporepellens	552810	Bacteria	Bacteria	82.4	3e-11	NTclustered	gi\|299526872\|gb\|CP002084.1\|	552811	g148988	i0	92.857	26.4186046511628	56	4	22	0	203	258	1373550	1373605	Dehalogenimonas lykanthroporepellens BL-DC-9, complete genome	blastn	6816	82.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalogenimonas	Dehalogenimonas lykanthroporepellens
17516039	17516039	PRJNA951810_P_NODE_72954_length_299_cov_10.185841_g72610_i0	PRJNA951810	72954	299	10.185841	30.45566459	Caldilinea aerophila	133453	Bacteria	Bacteria	93.5	1.64e-14	NTclustered	gi\|381381223\|dbj\|AP012337.1\|	926550	g72610	i0	90.141	0.782608695652174	71	7	24	0	22	92	2482470	2482400	Caldilinea aerophila DSM 14535 = NBRC 104270 DNA, complete genome	blastn	234	93.5	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
17840744	17840744	PRJNA951810_P_NODE_161034_length_249_cov_3.187500_g160689_i0	PRJNA951810	161034	249	3.1875	7.936875	Herpetosiphon	64	Bacteria	Bacteria	444	3.18e-120	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g160689	i0	98.795	6	249	3	100	0	1	249	1507	1259	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	1494	444	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
18787912	18787912	PRJNA951810_P_NODE_148455_length_259_cov_3.548387_g148110_i0	PRJNA951810	148455	259	3.548387	9.19032233	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	231	2.8199999999999997e-56	NTclustered	gi\|2893356066\|emb\|OZ220489.1\|	3022862	g148110	i0	86.047	20.8841698841699	215	30	83	0	27	241	141607	141821	MAG: Tepidiformaceae bacterium isolate fe7a5560-ebd3-4005-b60b-c4614588a40b genome assembly, chromosome: 1	blastn	5409	231	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
22612552	22612552	PRJNA951810_P_NODE_111478_length_286_cov_1.370892_g111134_i0	PRJNA951810	111478	286	1.370892	3.92075112	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	211	4.12e-50	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g111134	i0	81.061	3.73776223776224	264	50	92	0	23	286	1104105	1103842	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	1069	211	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
22612632	22612632	PRJNA951810_P_NODE_116518_length_282_cov_5.014354_g116174_i0	PRJNA951810	116518	282	5.014354	14.14047828	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	60.2	1.55e-4	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g116174	i0	92.683	0.145390070921986	41	3	15	0	165	205	1346967	1346927	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	41	60.2	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22613654	22613654	PRJNA951810_P_NODE_176398_length_236_cov_3.355828_g176053_i0	PRJNA951810	176398	236	3.355828	7.91975408	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	150	7.299999999999998e-32	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g176053	i0	86.014	12.0127118644068	143	16	60	4	2	142	1503981	1504121	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	2835	150	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22615004	22615004	PRJNA951810_P_NODE_71678_length_300_cov_11.625551_g71334_i0	PRJNA951810	71678	300	11.625551	34.876653	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g71334	i0	100	0.0933333333333333	28	0	9	0	206	233	734784	734811	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23890033	23890033	PRJNA951810_P_NODE_53899_length_310_cov_4.641350_g53556_i0	PRJNA951810	53899	310	4.64135	14.388185	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	67.6	1.03e-6	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g53556	i0	95.349	21.358064516129	43	0	13	2	168	208	2117160	2117202	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	6621	67.6	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota 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);;