metadata: contig_metadata: 11 rows where bioproject = "PRJNA400171" and tax

11 rows where bioproject = "PRJNA400171" 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
26854153	26854153	PRJNA400171_S_NODE_1101_length_328_cov_2.672241_g1011_i0	PRJNA400171	1101	328	2.672241	8.76495048	Chloroflexota bacterium	2026724	Bacteria	Bacteria	59.7	2.21e-8	NR	NLS80125.1	2026724	g1011	i0	54.2	0.896341463414634	48	22	43.9	0	146	3	3	50	NLS80125.1 NUDIX hydrolase [Chloroflexota bacterium]	diamond	294	59.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26917240	26917240	PRJNA400171_S_NODE_182_length_622_cov_5.895447_g109_i0	PRJNA400171	182	622	5.895447	36.66968034	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	57.4	4.48e-6	NR	MCL2706627.1	2026734	g109	i0	29.7	1.17202572347267	118	79	56.9	3	227	580	5	118	MCL2706627.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	729	57.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27787282	27787282	PRJNA400171_S_NODE_4544_length_202_cov_3.034682_g4454_i0	PRJNA400171	4544	202	3.034682	6.13005764	Bacteria	2	Bacteria	Bacteria	45.1	0.00345	NR	MFN8515611.1	2448782	g4454	i0	48.8	2.27227722772277	43	22	63.9	0	73	201	55	97	MFN8515611.1 DEAD/DEAH box helicase [Chloroflexia bacterium]	diamond	459	45.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
27833440	27833440	PRJNA400171_S_NODE_3124_length_232_cov_2.645320_g3034_i0	PRJNA400171	3124	232	2.64532	6.1371424	Chloroflexota bacterium	2026724	Bacteria	Bacteria	69.3	1.37e-11	NR	MCP4542426.1	2026724	g3034	i0	52.6	1.95258620689655	76	35	97	1	6	230	398	473	MCP4542426.1 DEAD/DEAH box helicase [Chloroflexota bacterium]	diamond	453	69.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28749175	28749175	PRJNA400171_S_NODE_3707_length_218_cov_2.793651_g3617_i0	PRJNA400171	3707	218	2.793651	6.09015918	Chloroflexota bacterium	2026724	Bacteria	Bacteria	49.3	1.32e-4	NR	MCP4542428.1	2026724	g3617	i0	40	0.825688073394495	60	35	82.6	1	208	29	679	737	MCP4542428.1 hypothetical protein [Chloroflexota bacterium]	diamond	180	49.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29727694	29727694	PRJNA400171_S_NODE_3450_length_223_cov_3.020619_g3360_i0	PRJNA400171	3450	223	3.020619	6.73598037	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	65.9	1.78e-10	NR	MCB8942536.1	2614247	g3360	i0	51.5	0.887892376681614	66	32	88.8	0	198	1	190	255	MCB8942536.1 hypothetical protein [Ardenticatenaceae bacterium]	diamond	198	65.9	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
30043743	30043743	PRJNA400171_S_NODE_3111_length_232_cov_3.359606_g3021_i0	PRJNA400171	3111	232	3.359606	7.79428592	Chloroflexaceae bacterium	2562117	Bacteria	Bacteria	42.4	0.0304	NR	NJK81358.1	2562117	g3021	i0	42.1	0.737068965517241	57	32	72.4	1	205	38	49	105	NJK81358.1 hypothetical protein [Chloroflexaceae bacterium]	diamond	171	42.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae		Chloroflexaceae bacterium
30439879	30439879	PRJNA400171_S_NODE_1653_length_289_cov_2.965385_g1563_i0	PRJNA400171	1653	289	2.965385	8.56996265	FCB group	1783270	Bacteria	Bacteria	84	2.1e-16	NR	MBE2197222.1	1872519	g1563	i0	46.7	3.58131487889273	92	49	95.5	0	8	283	184	275	MBE2197222.1 AAA family ATPase [Anaerolinea sp.]	diamond	1035	84.3	0.99644128113879	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea sp.
30675586	30675586	PRJNA400171_S_NODE_9333_length_150_cov_2.793388_g9243_i0	PRJNA400171	9333	150	2.793388	4.190082	Chloroflexota bacterium	2026724	Bacteria	Bacteria	48.5	6.91e-5	NR	MBI2847216.1	2026724	g9243	i0	55.3	0.94	47	18	90	2	1	135	86	131	MBI2847216.1 TlpA family protein disulfide reductase [Chloroflexota bacterium]	diamond	141	48.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30802050	30802050	PRJNA400171_S_NODE_5634_length_186_cov_3.343949_g5544_i0	PRJNA400171	5634	186	3.343949	6.21974514	Chloroflexota bacterium	2026724	Bacteria	Bacteria	46.6	7.96e-4	NR	MCP4542426.1	2026724	g5544	i0	43.3	1.88709677419355	60	30	90.3	2	180	13	265	324	MCP4542426.1 DEAD/DEAH box helicase [Chloroflexota bacterium]	diamond	351	46.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31276048	31276048	PRJNA400171_S_NODE_6975_length_171_cov_2.633803_g6885_i0	PRJNA400171	6975	171	2.633803	4.50380313	Chloroflexota bacterium	2026724	Bacteria	Bacteria	57	1.3e-7	NR	MBU1746437.1	2026724	g6885	i0	49.1	0.929824561403509	53	25	89.5	1	155	3	316	368	MBU1746437.1 DEAD/DEAH box helicase [Chloroflexota bacterium]	diamond	159	57	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);;