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

26 rows where analysis = "blastn", bioproject = "PRJNA864829" 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
847276	847276	PRJNA864829_S_NODE_3521_length_299_cov_3.644000_g3435_i0	PRJNA864829	3521	299	3.644	10.89556	Anaerolineales bacterium	2073117	Bacteria	Bacteria	422	1.84e-113	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g3435	i0	94.545	504.314381270903	275	12	92	3	26	299	1234029	1234301	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	150790	422	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
2122675	2122675	PRJNA864829_S_NODE_722_length_542_cov_4.139959_g639_i0	PRJNA864829	722	542	4.139959	22.43857778	Anaerolineales bacterium	2073117	Bacteria	Bacteria	734	0	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g639	i0	92.278	222.667896678967	518	38	95	2	27	542	1233744	1234261	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	120686	734	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
3398020	3398020	PRJNA864829_S_NODE_3923_length_288_cov_1.820084_g3837_i0	PRJNA864829	3923	288	1.820084	5.24184192	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	252	2.45e-62	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g3837	i0	82.414	12.2881944444444	290	49	100	1	1	288	3495078	3495367	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	3539	252	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
4675703	4675703	PRJNA864829_S_NODE_13504_length_175_cov_1.015873_g13418_i0	PRJNA864829	13504	175	1.015873	1.77777775	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	167	5.05e-37	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g13418	i0	84.091	84.1371428571429	176	25	99	3	1	174	3494884	3495058	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	14724	167	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
4675728	4675728	PRJNA864829_S_NODE_3804_length_291_cov_2.165289_g3718_i0	PRJNA864829	3804	291	2.165289	6.30099099	Chloroflexota bacterium	2026724	Bacteria	Bacteria	161	4.29e-35	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g3718	i0	77.558	109.103092783505	303	45	98	17	6	289	1474746	1474448	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	31749	161	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
5950603	5950603	PRJNA864829_S_NODE_7565_length_224_cov_2.360000_g7479_i0	PRJNA864829	7565	224	2.36	5.2864	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	141	4.13e-29	NTclustered	gi\|2575803493\|emb\|OY729430.1\|	2614250	g7479	i0	88.793	50.2678571428571	116	12	52	1	1	116	1509977	1509863	MAG: Caldilineaceae bacterium isolate ee78b5b4-03fb-4fb3-b3ee-46148e6ffba5 genome assembly, chromosome: 1	blastn	11260	141	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
8500171	8500171	PRJNA864829_S_NODE_1247_length_440_cov_2.652174_g1161_i0	PRJNA864829	1247	440	2.652174	11.6695656	Anaerolineales bacterium	2073117	Bacteria	Bacteria	440	7.769999999999997e-119	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g1161	i0	84.855	255.697727272727	449	54	100	12	1	440	1574943	1575386	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	112507	440	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
9775300	9775300	PRJNA864829_S_NODE_3108_length_313_cov_4.147727_g3022_i0	PRJNA864829	3108	313	4.147727	12.98238551	Anaerolineales bacterium	2073117	Bacteria	Bacteria	339	2.01e-88	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g3022	i0	86.306	149.961661341853	314	40	100	3	1	313	2028756	2029067	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	46938	339	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
11050999	11050999	PRJNA864829_S_NODE_1409_length_420_cov_3.293801_g1323_i0	PRJNA864829	1409	420	3.293801	13.8339642	Anaerolineales bacterium	2073117	Bacteria	Bacteria	324	7.76e-84	NTclustered	gi\|2814788355\|emb\|OY776212.2\|	2073117	g1323	i0	81.818	39.1809523809524	396	63	94	8	2	394	1139246	1138857	MAG: Anaerolineales bacterium isolate db28be52-e32f-4f71-9c49-3cbd2ddbe7d1 genome assembly, chromosome: 1	blastn	16456	324	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
12326406	12326406	PRJNA864829_S_NODE_11030_length_191_cov_2.661972_g10944_i0	PRJNA864829	11030	191	2.661972	5.08436652	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	63.9	7.59e-6	NTclustered	gi\|2893358394\|emb\|OZ220685.1\|	2026734	g10944	i0	91.304	0.408376963350785	46	4	24	0	94	139	2774385	2774340	MAG: Dehalococcoidia bacterium isolate 2a27cef4-6af2-4f96-82a3-29fad4755a7e genome assembly, chromosome: 1	blastn	78	63.9	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
16149958	16149958	PRJNA864829_S_NODE_193_length_915_cov_15.045035_g11_i3	PRJNA864829	193	915	15.045035	137.66207025	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	710	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g11	i3	85.014	458.326775956284	714	89	77	13	190	897	597856	597155	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	419369	710	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
17425484	17425484	PRJNA864829_S_NODE_594_length_586_cov_12.990689_g514_i0	PRJNA864829	594	586	12.990689	76.12543754	Chloroflexota bacterium	2026724	Bacteria	Bacteria	401	4.989999999999999e-107	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g514	i0	80	55.4522184300341	575	89	95	20	31	585	1474915	1474347	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	32495	401	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
17425487	17425487	PRJNA864829_S_NODE_6414_length_240_cov_3.910995_g6328_i0	PRJNA864829	6414	240	3.9109950000000002	9.386388	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	122	1.62e-23	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g6328	i0	92.857	69.3125	84	6	35	0	157	240	7870	7787	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	16635	122	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
17425499	17425499	PRJNA864829_S_NODE_94_length_1175_cov_12.873890_g11_i2	PRJNA864829	94	1175	12.87389	151.2682075	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	1031	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g11	i2	83.333	452.564255319149	1140	166	96	19	26	1157	598278	597155	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	531763	1031	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
18698632	18698632	PRJNA864829_S_NODE_5055_length_263_cov_1.789720_g4969_i0	PRJNA864829	5055	263	1.78972	4.7069636	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	219	2.24e-52	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g4969	i0	84.188	10.2965779467681	234	28	89	5	26	259	3495543	3495767	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	2708	219	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
18698639	18698639	PRJNA864829_S_NODE_7515_length_225_cov_1.272727_g7429_i0	PRJNA864829	7515	225	1.272727	2.86363575	Litorilinea aerophila	1204385	Bacteria	Bacteria	228	3.0999999999999996e-55	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g7429	i0	86.829	460.484444444444	205	26	91	1	22	225	4891	5095	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	103609	228	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
19973864	19973864	PRJNA864829_S_NODE_10396_length_196_cov_1.972789_g10310_i0	PRJNA864829	10396	196	1.972789	3.86666644	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	139	1.27e-28	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g10310	i0	81.871	85.5714285714286	171	25	86	6	25	192	2202447	2202280	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	16772	139	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
19973893	19973893	PRJNA864829_S_NODE_3656_length_295_cov_3.764228_g3570_i0	PRJNA864829	3656	295	3.764228	11.1044726	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	278	4.15e-70	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g3570	i0	85.294	119.813559322034	272	36	92	4	1	270	2062890	2063159	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	35345	278	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21249423	21249423	PRJNA864829_S_NODE_12657_length_180_cov_1.389313_g12571_i0	PRJNA864829	12657	180	1.389313	2.5007634	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	58.4	3.28e-4	NTclustered	gi\|2531950174\|emb\|OY282494.1\|	498747	g12571	i0	77.119	0.655555555555556	118	16	62	8	69	180	1152615	1152503	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	118	58.4	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
22523971	22523971	PRJNA864829_S_NODE_12838_length_179_cov_1.230769_g12752_i0	PRJNA864829	12838	179	1.230769	2.20307651	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	119	1.47e-22	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g12752	i0	79.121	22.6424581005587	182	31	100	7	1	179	2202337	2202160	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	4053	119	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
22523993	22523993	PRJNA864829_S_NODE_4618_length_272_cov_6.780269_g4532_i0	PRJNA864829	4618	272	6.780269	18.44233168	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	422	1.65e-113	NTclustered	gi\|1187200905\|gb\|KY993933.1\|	166587	g4532	i0	97.951	89.3014705882353	244	4	89	1	30	272	28	271	Uncultured Chloroflexi bacterium clone ACTEW21 16S ribosomal RNA gene, partial sequence	blastn	24290	422	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
22523996	22523996	PRJNA864829_S_NODE_538_length_605_cov_5.066547_g459_i0	PRJNA864829	538	605	5.066547	30.65260935	Anaerolineales bacterium	2073117	Bacteria	Bacteria	1002	0	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g459	i0	96.54	268.533884297521	607	17	100	4	1	605	1575582	1576186	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	162463	1002	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
22524015	22524015	PRJNA864829_S_NODE_9858_length_200_cov_3.735099_g9772_i0	PRJNA864829	9858	200	3.735099	7.470198	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	353	4.25e-93	NTclustered	gi\|159234367\|emb\|AM902609.1\|	166587	g9772	i0	98.5	99.325	200	3	100	0	1	200	1144	1343	Uncultured Chloroflexi bacterium partial 16S rRNA gene, isolate OTU17/APA	blastn	19865	353	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23799531	23799531	PRJNA864829_S_NODE_2739_length_326_cov_4.227437_g2653_i0	PRJNA864829	2739	326	4.227437	13.78144462	Anaerolineales bacterium	2073117	Bacteria	Bacteria	248	3.64e-61	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g2653	i0	80.967	235.757668711656	331	48	100	13	1	326	3065803	3065483	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	76857	248	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
25073351	25073351	PRJNA864829_S_NODE_10840_length_193_cov_0.937500_g10754_i0	PRJNA864829	10840	193	0.9375	1.809375	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	239	1.19e-58	NTclustered	gi\|2893358382\|emb\|OZ220676.1\|	2614250	g10754	i0	92.262	42.8134715025907	168	13	87	0	1	168	357453	357286	MAG: Caldilineaceae bacterium isolate 6911f4b3-f793-4dac-9473-b80504ec0e1d genome assembly, chromosome: 1	blastn	8263	239	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
25073391	25073391	PRJNA864829_S_NODE_700_length_550_cov_4.163673_g617_i0	PRJNA864829	700	550	4.163673	22.9002015	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	407	1e-108	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g617	i0	80.791	92.3	531	92	95	10	1	525	3494941	3494415	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	50765	407	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.

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