metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1160211" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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
1584623	1584623	PRJNA1160211_S_NODE_242362_length_268_cov_3.538462_g241129_i0	PRJNA1160211	242362	268	3.538462	9.48307816	Chloroflexus aggregans	152260	Bacteria	Bacteria	217	8.22e-52	NTclustered	gi\|219541215\|gb\|CP001337.1\|	326427	g241129	i0	83.471	169.384328358209	242	30	89	9	9	246	4139580	4139345	Chloroflexus aggregans DSM 9485, complete genome	blastn	45395	217	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
2860254	2860254	PRJNA1160211_S_NODE_158123_length_363_cov_6.862069_g156890_i0	PRJNA1160211	158123	363	6.862069	24.90931047	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	527	4.6899999999999984e-145	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g156890	i0	95.468	428.906336088154	331	13	91	2	13	342	17940	18269	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	155693	527	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
2861056	2861056	PRJNA1160211_S_NODE_267063_length_249_cov_2.096591_g265830_i0	PRJNA1160211	267063	249	2.096591	5.22051159	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	176	1.28e-39	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g265830	i0	81.034	88.9799196787149	232	35	92	7	1	228	3494814	3494588	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	22156	176	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
2861655	2861655	PRJNA1160211_S_NODE_82743_length_492_cov_8.326969_g81524_i0	PRJNA1160211	82743	492	8.326969	40.96868748	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	137	1.2900000000000002e-27	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g81524	i0	75.49	30.6077235772358	306	61	61	11	165	463	273343	273045	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	15059	137	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4136037	4136037	PRJNA1160211_S_NODE_135624_length_396_cov_3.643963_g134392_i0	PRJNA1160211	135624	396	3.643963	14.43009348	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	322	2.62e-83	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g134392	i0	83.333	208.058080808081	366	43	89	13	29	381	598807	598447	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	82391	322	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
4136734	4136734	PRJNA1160211_S_NODE_226364_length_283_cov_2.376190_g225131_i0	PRJNA1160211	226364	283	2.37619	6.7246177	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	270	6.619999999999999e-68	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g225131	i0	83.959	92.243816254417	293	35	100	9	1	283	7813	8103	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	26105	270	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
4137103	4137103	PRJNA1160211_S_NODE_279844_length_242_cov_6.236686_g278611_i0	PRJNA1160211	279844	242	6.236686	15.09278012	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	78.7	3.6e-10	NTclustered	gi\|2874253741\|emb\|OY969584.1\|	1672391	g278611	i0	74.51	30.9628099173554	204	41	81	10	30	226	1349444	1349643	MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1	blastn	7493	78.7	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5413059	5413059	PRJNA1160211_S_NODE_2465_length_1119_cov_29.972275_g2088_i0	PRJNA1160211	2465	1119	29.972275	335.38975725	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	878	0	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g2088	i0	93.189	72.1733690795353	602	33	98	8	6	603	1227820	1228417	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	80762	878	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
5413396	5413396	PRJNA1160211_S_NODE_30085_length_651_cov_20.262976_g28991_i0	PRJNA1160211	30085	651	20.262976	131.91197376	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	440	1.1799999999999996e-118	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g28991	i0	79.403	48.4039938556068	670	103	100	29	1	651	273234	273887	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	31511	440	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
6687979	6687979	PRJNA1160211_S_NODE_250646_length_261_cov_2.867021_g249413_i0	PRJNA1160211	250646	261	2.867021	7.48292481	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	122	1.79e-23	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g249413	i0	90.323	26.5938697318008	93	9	36	0	32	124	3520995	3521087	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	6941	122	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7962614	7962614	PRJNA1160211_S_NODE_162467_length_357_cov_5.415493_g161234_i0	PRJNA1160211	162467	357	5.415493	19.33331001	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	241	6.720000000000001e-59	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g161234	i0	79.501	32.5686274509804	361	56	99	15	3	357	273240	273588	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	11627	241	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7963583	7963583	PRJNA1160211_S_NODE_295247_length_221_cov_7.121622_g294014_i0	PRJNA1160211	295247	221	7.121622	15.73878462	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	315	2.26e-81	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g294014	i0	95.025	69.4841628959276	201	9	90	1	1	200	1026842	1026642	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	15356	315	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11241942	11241942	PRJNA1160211_S_NODE_27029_length_667_cov_5.708754_g25947_i0	PRJNA1160211	27029	667	5.708754	38.07738918	Caldilineaceae	475964	Bacteria	Bacteria	689	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g25947	i0	86.817	72.1784107946027	622	77	93	2	51	667	1304	1925	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	48143	689	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
11788228	11788228	PRJNA1160211_S_NODE_18370_length_721_cov_29.503086_g17400_i0	PRJNA1160211	18370	721	29.503086	212.71725006	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	625	3.3899999999999995e-174	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g17400	i0	82.778	103.930651872399	720	105	99	19	1	712	2202000	2202708	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	74934	625	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
11788997	11788997	PRJNA1160211_S_NODE_294250_length_225_cov_5.078947_g293017_i0	PRJNA1160211	294250	225	5.078947	11.42763075	Chloroflexota bacterium	2026724	Bacteria	Bacteria	145	3.21e-30	NTclustered	gi\|2621701252\|emb\|OY759972.1\|	2026724	g293017	i0	81.053	48.5733333333333	190	28	83	7	30	215	2444413	2444598	MAG: Chloroflexota bacterium isolate 55c93f92-7b64-48b2-973a-1fcfb2e6d712 genome assembly, chromosome: 1	blastn	10929	145	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
13792021	13792021	PRJNA1160211_S_NODE_27111_length_666_cov_41.510961_g26029_i0	PRJNA1160211	27111	666	41.510961	276.46300026	Caldilinea	233191	Bacteria	Bacteria	935	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g26029	i0	92.627	560.021021021021	651	46	98	2	17	666	2804	2155	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	372974	935	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
15611980	15611980	PRJNA1160211_S_NODE_136073_length_395_cov_6.515528_g134841_i0	PRJNA1160211	136073	395	6.515528	25.7363356	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	285	3.42e-72	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g134841	i0	81.572	28.8253164556962	369	47	90	19	4	360	382358	381999	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	11386	285	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
20711851	20711851	PRJNA1160211_S_NODE_40197_length_609_cov_3.201493_g39058_i0	PRJNA1160211	40197	609	3.201493	19.49709237	Litorilinea aerophila	1204385	Bacteria	Bacteria	608	2.849999999999998e-169	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g39058	i0	85.642	61.2660098522167	592	69	95	11	31	609	4570	3982	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	37311	608	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
20711881	20711881	PRJNA1160211_S_NODE_4437_length_974_cov_7.935627_g3905_i0	PRJNA1160211	4437	974	7.935627	77.29300698	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	824	0	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g3905	i0	88.235	418.44045174538	697	72	71	8	287	974	2827174	2827869	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	407561	824	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
21986683	21986683	PRJNA1160211_S_NODE_235238_length_275_cov_1.133663_g234005_i0	PRJNA1160211	235238	275	1.133663	3.11757325	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	228	3.9099999999999994e-55	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g234005	i0	85.455	20.5963636363636	220	31	80	1	45	263	861204	861423	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	5664	228	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23262204	23262204	PRJNA1160211_S_NODE_242659_length_268_cov_1.974359_g241426_i0	PRJNA1160211	242659	268	1.974359	5.29128212	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	115	3.0900000000000003e-21	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g241426	i0	77.626	300.291044776119	219	29	77	17	35	241	598744	598954	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	80478	115	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
23262524	23262524	PRJNA1160211_S_NODE_291279_length_230_cov_2.242038_g290046_i0	PRJNA1160211	291279	230	2.242038	5.1566874	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	342	1.0899999999999997e-89	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g290046	i0	94.57	262.965217391304	221	12	96	0	1	221	8319	8539	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	60482	342	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
24535416	24535416	PRJNA1160211_S_NODE_1660_length_1234_cov_8.089578_g1372_i0	PRJNA1160211	1660	1234	8.089578	99.82539252	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	1098	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g1372	i0	87.891	439.265802269044	958	84	76	22	294	1231	597502	598447	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	542054	1098	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
24536774	24536774	PRJNA1160211_S_NODE_83740_length_490_cov_6.597122_g82521_i0	PRJNA1160211	83740	490	6.597122	32.3258978	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	246	2.04e-60	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g82521	i0	85.654	106.467346938776	237	30	48	4	193	427	382112	381878	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	52169	246	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales 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);;