metadata: contig_metadata: 25 rows where bioproject = "PRJNA1174207" and tax

25 rows where bioproject = "PRJNA1174207" 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
315791	315791	PRJNA1174207_P_NODE_33201_length_251_cov_1.730337_g32672_i0	PRJNA1174207	33201	251	1.730337	4.34314587	Litorilinea aerophila	1204385	Bacteria	Bacteria	366	7.15e-97	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g32672	i0	93.2	251.143426294821	250	16	99	1	3	251	3701	3950	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	63037	366	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
316005	316005	PRJNA1174207_P_NODE_43581_length_211_cov_6.384058_g43052_i0	PRJNA1174207	43581	211	6.384058	13.47036238	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	257	3.66e-64	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g43052	i0	88.679	18.1469194312796	212	22	100	2	1	211	276000	275790	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	3829	257	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
2316127	2316127	PRJNA1174207_P_NODE_6022_length_679_cov_1.665017_g5511_i0	PRJNA1174207	6022	679	1.665017	11.30546543	Bacteria	2	Bacteria	Bacteria	510	9.29e-140	NTclustered	gi\|2531946085\|emb\|OY282385.1\|	498747	g5511	i0	81.069	96.9469808541973	655	110	95	12	2	646	1885067	1884417	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	65827	510	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
6693829	6693829	PRJNA1174207_P_NODE_42826_length_230_cov_2.828025_g42297_i0	PRJNA1174207	42826	230	2.828025	6.5044575	Chloroflexota bacterium	2026724	Bacteria	Bacteria	207	4.14e-49	NTclustered	gi\|2621702192\|emb\|OY760183.1\|	2026724	g42297	i0	84.259	119.430434782609	216	30	93	4	1	214	2633147	2632934	MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1	blastn	27469	207	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
6693915	6693915	PRJNA1174207_P_NODE_8266_length_548_cov_5.012632_g7742_i0	PRJNA1174207	8266	548	5.012632	27.46922336	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	649	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g7742	i0	89.231	192.082116788321	520	55	95	1	1	520	273761	274279	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	105261	649	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7418560	7418560	PRJNA1174207_P_NODE_35406_length_248_cov_3.325714_g34877_i0	PRJNA1174207	35406	248	3.325714	8.24777072	Chloroflexota	200795	Bacteria	Bacteria	211	3.5e-50	NTclustered	gi\|2531946085\|emb\|OY282385.1\|	498747	g34877	i0	82.661	148.576612903226	248	34	98	5	7	248	1885640	1885884	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	36847	211	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
10518967	10518967	PRJNA1174207_P_NODE_12009_length_429_cov_1.039326_g11482_i0	PRJNA1174207	12009	429	1.039326	4.45870854	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	261	6.32e-65	NTclustered	gi\|2874253741\|emb\|OY969584.1\|	1672391	g11482	i0	81.703	166.589743589744	317	54	74	4	111	426	1351132	1351445	MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1	blastn	71467	261	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10519316	10519316	PRJNA1174207_P_NODE_31429_length_258_cov_3.881081_g30900_i0	PRJNA1174207	31429	258	3.881081	10.01318898	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	302	2.11e-77	NTclustered	gi\|2531946085\|emb\|OY282385.1\|	498747	g30900	i0	88.755	236.244186046512	249	24	95	2	1	246	1883916	1884163	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	60951	302	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
15068338	15068338	PRJNA1174207_P_NODE_30732_length_261_cov_3.776596_g30203_i0	PRJNA1174207	30732	261	3.776596	9.85691556	Bacteria	2	Bacteria	Bacteria	248	2.8299999999999997e-61	NTclustered	gi\|297181775\|gb\|GU474878.1\|	710736	g30203	i0	85.957	70.8888888888889	235	29	89	4	29	261	9514	9746	Uncultured Chloroflexi bacterium HF0200_09I09 genomic sequence	blastn	18502	250	0.992	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexi bacterium HF0200_09I09
15618392	15618392	PRJNA1174207_P_NODE_27353_length_276_cov_0.896552_g26824_i0	PRJNA1174207	27353	276	0.896552	2.47448352	Litorilinea aerophila	1204385	Bacteria	Bacteria	353	6.21e-93	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g26824	i0	91.221	126.70652173913	262	20	95	3	10	270	4036	4295	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	34971	353	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
21992549	21992549	PRJNA1174207_P_NODE_5198_length_744_cov_4.737705_g4700_i0	PRJNA1174207	5198	744	4.737705	35.2485252	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	651	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g4700	i0	82.79	197.524193548387	767	94	100	30	1	744	273052	273803	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	146958	651	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
27514512	27514512	PRJNA1174207_P_NODE_32083_length_256_cov_1.398907_g31554_i0	PRJNA1174207	32083	256	1.398907	3.58120192	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	117	2.78e-30	NR	HZM79502.1	2952938	g31554	i0	87.9	1.53515625	66	8	77.3	0	198	1	28	93	HZM79502.1 CPBP family glutamic-type intramembrane protease [Candidatus Limnocylindrales bacterium]	diamond	393	117	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
27798833	27798833	PRJNA1174207_P_NODE_35424_length_248_cov_2.782857_g34895_i0	PRJNA1174207	35424	248	2.782857	6.90148536	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	77.4	2.5e-16	NR	MCB8942763.1	2614247	g34895	i0	70.9	2.6491935483871	55	16	66.5	0	3	167	46	100	MCB8942763.1 PAAR domain-containing protein [Ardenticatenaceae bacterium]	diamond	657	77.4	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
29743637	29743637	PRJNA1174207_P_NODE_28870_length_269_cov_1.964286_g28341_i0	PRJNA1174207	28870	269	1.964286	5.28392934	Bacillati	1783272	Bacteria	Bacteria	79	3.48e-15	NR	HOU23501.1	2052143	g28341	i0	66.7	3.37918215613383	60	20	66.9	0	88	267	1	60	HOU23501.1 nucleoside triphosphate pyrophosphohydrolase family protein [Anaerolineae bacterium]	diamond	909	79	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30040537	30040537	PRJNA1174207_P_NODE_27751_length_274_cov_1.398010_g27222_i0	PRJNA1174207	27751	274	1.39801	3.8305474	Chloroflexota bacterium	2026724	Bacteria	Bacteria	77	4.78e-14	NR	MBV9791606.1	2026724	g27222	i0	46.2	1.01824817518248	93	40	90.9	3	273	25	172	264	MBV9791606.1 hypothetical protein [Chloroflexota bacterium]	diamond	279	77	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30040540	30040540	PRJNA1174207_P_NODE_36971_length_247_cov_0.885057_g36442_i0	PRJNA1174207	36971	247	0.885057	2.18609079	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	155	9.279999999999999e-47	NR	MEZ4552387.1	2026734	g36442	i0	90.1	0.983805668016194	81	8	98.4	0	4	246	32	112	MEZ4552387.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	243	155	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
30640682	30640682	PRJNA1174207_P_NODE_30893_length_261_cov_1.425532_g30364_i0	PRJNA1174207	30893	261	1.425532	3.72063852	Chloroflexota bacterium	2026724	Bacteria	Bacteria	163	2e-45	NR	MQC18835.1	2026724	g30364	i0	96.5	0.988505747126437	86	3	98.9	0	259	2	178	263	MQC18835.1 dihydroxy-acid dehydratase [Chloroflexota bacterium]	diamond	258	163	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30861985	30861985	PRJNA1174207_P_NODE_36574_length_247_cov_0.885057_g36045_i0	PRJNA1174207	36574	247	0.885057	2.18609079	Anaerolineales bacterium	2073117	Bacteria	Bacteria	122	1.34e-30	NR	MFN2121797.1	2073117	g36045	i0	74.1	0.983805668016194	81	21	98.4	0	2	244	340	420	MFN2121797.1 IS110 family transposase [Anaerolineales bacterium]	diamond	243	122	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31020073	31020073	PRJNA1174207_P_NODE_25155_length_285_cov_1.367925_g24626_i0	PRJNA1174207	25155	285	1.367925	3.89858625	Chloroflexota bacterium	2026724	Bacteria	Bacteria	59.7	6.42e-8	NR	NLW71622.1	2026724	g24626	i0	41.3	0.789473684210526	75	44	78.9	0	9	233	233	307	NLW71622.1 hypothetical protein [Chloroflexota bacterium]	diamond	225	59.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31020078	31020078	PRJNA1174207_P_NODE_36615_length_247_cov_0.885057_g36086_i0	PRJNA1174207	36615	247	0.885057	2.18609079	Bellilinea sp.	2838785	Bacteria	Bacteria	148	3.7e-40	NR	HMN11892.1	2838785	g36086	i0	100	0.995951417004049	82	0	99.6	0	246	1	395	476	HMN11892.1 ABC transporter permease [Bellilinea sp.]	diamond	246	148	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Bellilinea	Bellilinea sp.
31083201	31083201	PRJNA1174207_P_NODE_20015_length_317_cov_1.262295_g19486_i0	PRJNA1174207	20015	317	1.262295	4.00147515	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	68.9	6.48e-12	NR	TAJ20127.1	2026734	g19486	i0	64.9	0.539432176656151	57	20	53.9	0	173	3	1	57	TAJ20127.1 MAG: hypothetical protein EPO65_04725, partial [Dehalococcoidia bacterium]	diamond	171	68.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
31450309	31450309	PRJNA1174207_P_NODE_28576_length_270_cov_2.157360_g28047_i0	PRJNA1174207	28576	270	2.15736	5.824872	Bacteria	2	Bacteria	Bacteria	101	2.1499999999999994e-23	NR	MCH8186582.1	2026724	g28047	i0	57.8	7.92222222222222	90	38	100	0	270	1	191	280	MCH8186582.1 2-dehydropantoate 2-reductase [Chloroflexota bacterium]	diamond	2139	101	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31968630	31968630	PRJNA1174207_P_NODE_42378_length_235_cov_2.104938_g41849_i0	PRJNA1174207	42378	235	2.104938	4.9466043	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	116	1.0599999999999998e-31	NR	HYJ14097.1	3047546	g41849	i0	73.2	2.71914893617021	71	19	90.6	0	234	22	47	117	HYJ14097.1 hypothetical protein [Candidatus Limnocylindria bacterium]	diamond	639	116	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
32380163	32380163	PRJNA1174207_P_NODE_27679_length_274_cov_1.532338_g27150_i0	PRJNA1174207	27679	274	1.532338	4.19860612	Kouleothrix aurantiaca	186479	Bacteria	Bacteria	107	1.14e-27	NR	KPV48230.1	186479	g27150	i0	100	0.613138686131387	56	0	61.3	0	78	245	1	56	KPV48230.1 hypothetical protein SE17_39190, partial [Kouleothrix aurantiaca]	diamond	168	107	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix aurantiaca
32538458	32538458	PRJNA1174207_P_NODE_40379_length_242_cov_1.597633_g39850_i0	PRJNA1174207	40379	242	1.597633	3.86627186	Chloroflexota bacterium	2026724	Bacteria	Bacteria	71.2	2.63e-12	NR	MCC7371887.1	2026724	g39850	i0	91.4	0.867768595041322	35	3	43.4	0	1	105	322	356	MCC7371887.1 amidohydrolase [Chloroflexota bacterium]	diamond	210	71.2	1	Bacteria	Bacillati	Chloroflexota					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);;