metadata: contig_metadata: 10 rows where bioproject = "PRJNA630877" and tax

10 rows where bioproject = "PRJNA630877" 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_genus	tax_species
22280224	22280224	PRJNA630877_S_NODE_107038_length_212_cov_1.450292_g87901_i0	PRJNA630877	107038	212	1.450292	3.07461904	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	248	2.2099999999999997e-61	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g87901	i0	97.26	296.358490566038	146	4	69	0	67	212	565435	565580	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	62828	248	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
26700849	26700849	PRJNA630877_S_NODE_157201_length_152_cov_1.612613_g138064_i0	PRJNA630877	157201	152	1.612613	2.45117176	Candidatus Aquidulcis sp.	2802963	Bacteria	Bacteria	40.8	0.0297	NR	NBO52226.1	2802963	g138064	i0	52.6	0.75	38	15	71.1	2	2	109	7	43	NBO52226.1 HNH endonuclease [Candidatus Aquidulcis sp.]	diamond	114	40.8	1	Bacteria		Bacillati	Chloroflexota	Candidatus Limnocylindria		Candidatus Aquidulcis	Candidatus Aquidulcis sp.
26827833	26827833	PRJNA630877_S_NODE_152341_length_156_cov_1.530435_g133204_i0	PRJNA630877	152341	156	1.530435	2.3874786	Chloroflexota bacterium	2026724	Bacteria	Bacteria	41.6	0.0293	NR	HEB65195.1	2026724	g133204	i0	40	0.769230769230769	40	24	76.9	0	30	149	588	627	HEB65195.1 PAS domain S-box protein [Chloroflexota bacterium]	diamond	120	41.6	1	Bacteria		Bacillati	Chloroflexota				Chloroflexota bacterium
27397079	27397079	PRJNA630877_S_NODE_26963_length_1158_cov_12.126231_g104_i1	PRJNA630877	26963	1158	12.126231	140.42175498	Anaerolineales bacterium	2073117	Bacteria	Bacteria	48.5	0.0472	NR	HTP01629.1	2073117	g104	i1	40.3	0.173575129533679	67	39	17.1	1	280	83	479	545	HTP01629.1 aldehyde dehydrogenase family protein [Anaerolineales bacterium]	diamond	201	48.5	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
27681423	27681423	PRJNA630877_S_NODE_150884_length_157_cov_2.043103_g131747_i0	PRJNA630877	150884	157	2.043103	3.20767171	Anaerolineales bacterium	2073117	Bacteria	Bacteria	41.6	0.0305	NR	MEJ2301431.1	2073117	g131747	i0	46.2	0.745222929936306	39	21	74.5	0	25	141	365	403	MEJ2301431.1 histidine kinase [Anaerolineales bacterium]	diamond	117	41.6	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
28091497	28091497	PRJNA630877_S_NODE_128405_length_179_cov_1.913043_g109268_i0	PRJNA630877	128405	179	1.913043	3.42434697	SAR2	1926618	Bacteria	Bacteria	45.1	0.0024	NR	PKB78937.1	1926618	g109268	i0	44.2	0.720670391061452	43	24	72.1	0	19	147	9	51	PKB78937.1 MAG: hypothetical protein BZY88_15910 [SAR202 cluster bacterium Io17-Chloro-G9]	diamond	129	45.1	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia			SAR202 cluster bacterium Io17-Chloro-G9
28533760	28533760	PRJNA630877_S_NODE_125387_length_183_cov_1.401408_g106250_i0	PRJNA630877	125387	183	1.401408	2.56457664	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	42	0.0331	NR	HLZ24877.1	2306968	g106250	i0	41.2	0.836065573770492	51	26	77	1	171	31	1424	1474	HLZ24877.1 DUF4011 domain-containing protein [Ktedonobacterales bacterium]	diamond	153	42	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales		Ktedonobacterales bacterium
29070538	29070538	PRJNA630877_S_NODE_44628_length_667_cov_12.814696_g26914_i0	PRJNA630877	44628	667	12.814696	85.47402232	Chloroflexia bacterium	2448782	Bacteria	Bacteria	47	0.0409	NR	HEX2911476.1	2448782	g26914	i0	34.6	0.36431784107946	81	50	35.5	2	296	60	139	218	HEX2911476.1 hypothetical protein [Chloroflexia bacterium]	diamond	243	47	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia			Chloroflexia bacterium
30491668	30491668	PRJNA630877_S_NODE_122253_length_187_cov_1.506849_g103116_i0	PRJNA630877	122253	187	1.506849	2.81780763	Anaerolineales bacterium	2073117	Bacteria	Bacteria	43.9	0.00696	NR	MFN2297793.1	2073117	g103116	i0	36.8	0.914438502673797	57	35	91.4	1	174	4	216	271	MFN2297793.1 glycosyltransferase [Anaerolineales bacterium]	diamond	171	43.9	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
31692699	31692699	PRJNA630877_S_NODE_90017_length_255_cov_2.056075_g70880_i0	PRJNA630877	90017	255	2.056075	5.24299125	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.5	0.0234	NR	MEW6179088.1	2026724	g70880	i0	40	1.04705882352941	50	30	58.8	0	87	236	866	915	MEW6179088.1 NAD(P)-dependent oxidoreductase [Chloroflexota bacterium]	diamond	267	43.5	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);;