metadata: contig_metadata: 16 rows where bioproject = "PRJNA1031674", tax_kingdom = "Bacillati" and tax

16 rows where bioproject = "PRJNA1031674", tax_kingdom = "Bacillati" 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
1441453	1441453	PRJNA1031674_P_NODE_21502_length_253_cov_1.277778_g21291_i0	PRJNA1031674	21502	253	1.277778	3.23277834	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	115	2.89e-21	NTclustered	gi\|2107920693\|gb\|CP070810.1\|	2026734	g21291	i0	91.566	51.7391304347826	83	7	33	0	2	84	971988	972070	MAG: Dehalococcoidia bacterium isolate bin1219 chromosome	blastn	13090	115	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
2282079	2282079	PRJNA1031674_P_NODE_27742_length_241_cov_1.642857_g27531_i0	PRJNA1031674	27742	241	1.642857	3.95928537	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	135	1.4199999999999998e-37	NR	HTE21657.1	3047546	g27531	i0	77.5	1.99170124481328	80	18	99.6	0	240	1	21	100	HTE21657.1 flavodoxin family protein [Candidatus Limnocylindria bacterium]	diamond	480	135	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
6544676	6544676	PRJNA1031674_P_NODE_13946_length_280_cov_2.338164_g13735_i0	PRJNA1031674	13946	280	2.338164	6.5468592	Candidatus Flexifilum breve	3140694	Bacteria	Bacteria	142	3.47e-41	NR	WP_343421693.1	3140694	g13735	i0	78.7	0.953571428571429	89	19	95.4	0	2	268	61	149	WP_343421693.1 Hsp20/alpha crystallin family protein [Candidatus Flexifilum breve]	diamond	267	142	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Candidatus Flexifilaceae	Candidatus Flexifilum	Candidatus Flexifilum breve
12920488	12920488	PRJNA1031674_P_NODE_24451_length_247_cov_0.885057_g24240_i0	PRJNA1031674	24451	247	0.885057	2.18609079	Chloroflexales bacterium	2725990	Bacteria	Bacteria	154	8.5e-45	NR	MBC8076393.1	2725990	g24240	i0	95.1	0.995951417004049	82	4	99.6	0	1	246	80	161	MBC8076393.1 amino acid ABC transporter permease [Chloroflexales bacterium]	diamond	246	154	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales			Chloroflexales bacterium
15469677	15469677	PRJNA1031674_P_NODE_4953_length_377_cov_2.299342_g4743_i0	PRJNA1031674	4953	377	2.299342	8.66851934	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	180	1.58e-40	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g4743	i0	78.317	1.63925729442971	309	46	79	15	30	326	274604	274305	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	618	180	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
27066615	27066615	PRJNA1031674_P_NODE_15182_length_276_cov_2.458128_g14971_i0	PRJNA1031674	15182	276	2.458128	6.78443328	Chloroflexota bacterium	2026724	Bacteria	Bacteria	47.4	0.0012	NR	HLH25674.1	2026724	g14971	i0	40.9	0.717391304347826	66	34	71.7	2	275	78	59	119	HLH25674.1 DPP IV N-terminal domain-containing protein [Chloroflexota bacterium]	diamond	198	47.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28329920	28329920	PRJNA1031674_P_NODE_7886_length_315_cov_3.157025_g7675_i0	PRJNA1031674	7886	315	3.157025	9.94462875	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	56.2	8.77e-7	NR	MBI9051853.1	2024896	g7675	i0	48.1	0.495238095238095	52	27	49.5	0	296	141	174	225	MBI9051853.1 peptidase E [Anaerolineaceae bacterium]	diamond	156	56.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
28551223	28551223	PRJNA1031674_P_NODE_8747_length_310_cov_2.341772_g8536_i0	PRJNA1031674	8747	310	2.341772	7.2594932	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	79	1.34e-14	NR	HEU5437684.1	2306968	g8536	i0	78	1.45161290322581	50	11	48.4	0	161	310	123	172	HEU5437684.1 transposase [Ktedonobacterales bacterium]	diamond	450	79	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
28669518	28669518	PRJNA1031674_P_NODE_6707_length_338_cov_0.833962_g6496_i0	PRJNA1031674	6707	338	0.833962	2.81879156	Chloroflexota	200795	Bacteria	Bacteria	140	2.16e-39	NR	KXK12723.1	1617415	g6496	i0	70.1	3.0887573964497	87	26	77.2	0	1	261	23	109	KXK12723.1 MAG: hypothetical protein UZ14_CFX002002168 [Chloroflexi bacterium OLB14]	diamond	1044	141	0.99290780141844	Bacteria	Bacillati	Chloroflexota	Tepidiformia				Chloroflexi bacterium OLB14
28764019	28764019	PRJNA1031674_P_NODE_17407_length_269_cov_1.326531_g17196_i0	PRJNA1031674	17407	269	1.326531	3.56836839	Kouleothrix	186475	Bacteria	Bacteria	69.3	1.37e-11	NR	MBS1966284.1	2807729	g17196	i0	84.6	0.869888475836431	39	6	43.5	0	152	268	1	39	MBS1966284.1 proline dehydrogenase family protein [Chloroflexi bacterium SZAS-1]	diamond	234	69.7	0.994261119081779	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium SZAS-1
28835191	28835191	PRJNA1031674_P_NODE_17788_length_267_cov_2.113402_g17577_i0	PRJNA1031674	17788	267	2.113402	5.64278334	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	147	2.28e-41	NR	HEU5016173.1	2762507	g17577	i0	80.7	0.98876404494382	88	17	98.9	0	1	264	167	254	HEU5016173.1 sugar ABC transporter permease [Roseiflexaceae bacterium]	diamond	264	147	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
28898211	28898211	PRJNA1031674_P_NODE_21888_length_251_cov_1.730337_g21677_i0	PRJNA1031674	21888	251	1.730337	4.34314587	Chloroflexota bacterium	2026724	Bacteria	Bacteria	138	6.18e-38	NR	MDQ2655522.1	2026724	g21677	i0	84.8	1.88844621513944	79	12	94.4	0	239	3	1	79	MDQ2655522.1 YafY family transcriptional regulator [Chloroflexota bacterium]	diamond	474	138	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29237835	29237835	PRJNA1031674_P_NODE_20709_length_256_cov_1.672131_g20498_i0	PRJNA1031674	20709	256	1.672131	4.28065536	Kouleothrix	186475	Bacteria	Bacteria	144	8.339999999999999e-38	NR	NTU78301.1	2725990	g20498	i0	80.5	5.4609375	82	16	96.1	0	254	9	76	157	NTU78301.1 molybdopterin-dependent oxidoreductase [Chloroflexales bacterium]	diamond	1398	145	0.993103448275862	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales			Chloroflexales bacterium
30027298	30027298	PRJNA1031674_P_NODE_13651_length_281_cov_2.134615_g13440_i0	PRJNA1031674	13651	281	2.134615	5.99826815	Bacillati	1783272	Bacteria	Bacteria	136	5.899999999999999e-36	NR	RYF28483.1	2026724	g13440	i0	67.7	3.97153024911032	93	30	99.3	0	280	2	211	303	RYF28483.1 MAG: nicotinate phosphoribosyltransferase [Chloroflexota bacterium]	diamond	1116	136	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31140548	31140548	PRJNA1031674_P_NODE_15635_length_275_cov_1.524752_g15424_i0	PRJNA1031674	15635	275	1.524752	4.193068	Chloroflexota bacterium	2026724	Bacteria	Bacteria	171	2.55e-50	NR	RYF28839.1	2026724	g15424	i0	90	1.96363636363636	90	9	98.2	0	4	273	90	179	RYF28839.1 MAG: thioredoxin reductase [Chloroflexota bacterium]	diamond	540	171	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32682312	32682312	PRJNA1031674_P_NODE_18000_length_266_cov_2.476684_g17789_i0	PRJNA1031674	18000	266	2.476684	6.58797944	root	1	Root_unresolved	Root_unresolved	42.7	0.0495	NR	MEO8392489.1	2026724	g17789	i0	35.7	1.18421052631579	70	39	72.2	2	30	221	455	524	MEO8392489.1 hypothetical protein [Chloroflexota bacterium]	diamond	315	43.1	0.990719257540603	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);;