metadata: contig_metadata: 8 rows where bioproject = "PRJNA473201" and tax

8 rows where bioproject = "PRJNA473201" 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
23396330	23396330	PRJNA473201_P_NODE_58239_length_271_cov_1.166667_g57497_i0	PRJNA473201	58239	271	1.166667	3.16166757	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2814788352\|emb\|OY821663.2\|	2026734	g57497	i0	100	0.103321033210332	28	0	10	0	15	42	646140	646167	MAG: Dehalococcoidia bacterium isolate 04ec0ed8-798b-4585-a8de-e3c995a4e665 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27107594	27107594	PRJNA473201_P_NODE_74002_length_247_cov_0.885057_g73260_i0	PRJNA473201	74002	247	0.885057	2.18609079	Anaerolineae bacterium	2052143	Bacteria	Bacteria	57.8	2.16e-8	NR	MCW5848612.1	2052143	g73260	i0	44.9	0.838056680161943	69	38	83.8	0	27	233	56	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	207	57.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27392397	27392397	PRJNA473201_P_NODE_77163_length_245_cov_0.895349_g76421_i0	PRJNA473201	77163	245	0.895349	2.19360505	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	58.2	1.19e-7	NR	MEJ2739882.1	2026734	g76421	i0	45.3	1.37142857142857	53	29	64.9	0	86	244	13	65	MEJ2739882.1 polyamine aminopropyltransferase [Dehalococcoidia bacterium]	diamond	336	58.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27992281	27992281	PRJNA473201_P_NODE_81245_length_243_cov_0.905882_g80503_i0	PRJNA473201	81245	243	0.905882	2.20129326	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	44.7	0.00416	NR	HEU5011481.1	2762507	g80503	i0	36.1	0.753086419753086	61	39	75.3	0	214	32	8	68	HEU5011481.1 GNAT family N-acetyltransferase [Roseiflexaceae bacterium]	diamond	183	44.7	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
28150177	28150177	PRJNA473201_P_NODE_67665_length_250_cov_0.870056_g66923_i0	PRJNA473201	67665	250	0.870056	2.17514	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.9	0.0156	NR	MCL5999181.1	2026724	g66923	i0	45.9	0.444	37	20	44.4	0	195	85	257	293	MCL5999181.1 endo-1,4-beta-xylanase [Chloroflexota bacterium]	diamond	111	43.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31308431	31308431	PRJNA473201_P_NODE_88095_length_207_cov_25.298507_g87353_i0	PRJNA473201	88095	207	25.298507	52.36790949	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42	0.0427	NR	UCG23153.1	2026724	g87353	i0	53.1	0.463768115942029	32	15	46.4	0	21	116	264	295	UCG23153.1 MAG: acetyl ornithine aminotransferase family protein [Chloroflexota bacterium]	diamond	96	42	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31419523	31419523	PRJNA473201_P_NODE_84536_length_241_cov_0.916667_g83794_i0	PRJNA473201	84536	241	0.916667	2.20916747	Bacillati	1783272	Bacteria	Bacteria	47.8	6.35e-4	NR	WP_162179474.1	1382306	g83794	i0	39.1	2.37759336099585	69	39	82.2	1	223	26	655	723	WP_162179474.1 protein phosphatase 2C domain-containing protein [Thermogemmatispora carboxidivorans]	diamond	573	47.8	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Thermogemmatisporales	Thermogemmatisporaceae	Thermogemmatispora	Thermogemmatispora carboxidivorans
32542540	32542540	PRJNA473201_P_NODE_70479_length_249_cov_0.875000_g69737_i0	PRJNA473201	70479	249	0.875	2.17875	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	45.8	0.00314	NR	HEY6411723.1	2740538	g69737	i0	52.1	0.578313253012048	48	22	57.8	1	3	146	306	352	HEY6411723.1 ankyrin repeat domain-containing protein [Ktedonobacteraceae bacterium]	diamond	144	45.8	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae 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);;