metadata: contig_metadata: 6 rows where bioproject = "PRJNA1082072", tax_phylum = "Chloroflexota" and tax

6 rows where bioproject = "PRJNA1082072", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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_species
26687607	26687607	PRJNA1082072_P_NODE_1141_length_324_cov_1.047809_g1134_i0	PRJNA1082072	1141	324	1.047809	3.39490116	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	178	1.3699999999999995e-55	NR	MCB9430965.1	2614247	g1134	i0	85.3	0.944444444444444	102	15	94.4	0	17	322	1	102	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	306	178	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
27090605	27090605	PRJNA1082072_P_NODE_382_length_492_cov_1.210024_g375_i0	PRJNA1082072	382	492	1.210024	5.95331808	FCB group	1783270	Bacteria	Bacteria	75.9	1.33e-12	NR	TMD30105.1	2026724	g375	i0	37.7	2.60975609756098	146	80	86.6	3	65	490	14	152	TMD30105.1 MAG: vanadium-dependent haloperoxidase [Chloroflexota bacterium]	diamond	1284	76.6	0.990861618798956	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27193812	27193812	PRJNA1082072_P_NODE_2582_length_246_cov_0.890173_g2575_i0	PRJNA1082072	2582	246	0.890173	2.18982558	Thermoflexales bacterium	2497639	Bacteria	Bacteria	59.7	3.96e-8	NR	MBN1888234.1	2497639	g2575	i0	39.7	0.951219512195122	78	47	95.1	0	236	3	176	253	MBN1888234.1 oligosaccharide flippase family protein [Thermoflexales bacterium]	diamond	234	59.7	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales		Thermoflexales bacterium
30280531	30280531	PRJNA1082072_P_NODE_592_length_409_cov_0.866071_g585_i0	PRJNA1082072	592	409	0.866071	3.54223039	PVC group	1783257	Bacteria	Bacteria	99.4	4.09e-21	NR	MCL4264506.1	2052143	g585	i0	48.4	3.7921760391198	126	63	91.7	2	35	409	1669	1793	MCL4264506.1 tandem-95 repeat protein [Anaerolineae bacterium]	diamond	1551	99.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
31047262	31047262	PRJNA1082072_P_NODE_1815_length_268_cov_1.317949_g1808_i0	PRJNA1082072	1815	268	1.317949	3.53210332	Chloroflexota bacterium	2026724	Bacteria	Bacteria	53.9	3.43e-6	NR	MCP4140454.1	2026724	g1808	i0	42	2.29477611940298	69	39	76.1	1	63	266	9	77	MCP4140454.1 M48 family metallopeptidase [Chloroflexota bacterium]	diamond	615	53.9	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31426288	31426288	PRJNA1082072_P_NODE_1736_length_273_cov_1.170000_g1729_i0	PRJNA1082072	1736	273	1.17	3.1941	Chloroflexota bacterium	2026724	Bacteria	Bacteria	142	1.82e-41	NR	MEZ4515128.1	2026724	g1729	i0	72.5	1	91	25	100	0	273	1	9	99	MEZ4515128.1 coactosin family protein [Chloroflexota bacterium]	diamond	273	142	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);;