metadata: contig_metadata: 10 rows where bioproject = "PRJEB39269", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJEB39269", 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
3883171	3883171	PRJEB39269_P_NODE_22084_length_298_cov_3.444015_g21679_i0	PRJEB39269	22084	298	3.444015	10.2631647	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	86.1	2.73e-12	NTclustered	gi\|2621703574\|emb\|OY761449.1\|	2026734	g21679	i0	88.732	7.06375838926174	71	7	23	1	95	164	1957832	1957762	MAG: Dehalococcoidia bacterium isolate 8faaec51-6d46-4fc3-9050-60b85d5760d4 genome assembly, chromosome: 1	blastn	2105	86.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
4817108	4817108	PRJEB39269_P_NODE_34864_length_234_cov_1.123077_g34459_i0	PRJEB39269	34864	234	1.123077	2.62800018	Thermobaculum	262406	Bacteria	Bacteria	206	1.52e-48	NTclustered	gi\|470485526\|ref\|NR_076705.1\|	166501	g34459	i0	83.7	78.4230769230769	227	27	94	10	14	234	662	884	Thermobaculum terrenum strain ATCC BAA-798 23S ribosomal RNA gene, complete sequence	blastn	18351	206	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
10259876	10259876	PRJEB39269_P_NODE_76289_length_161_cov_3.401639_g75884_i0	PRJEB39269	76289	161	3.401639	5.47663879	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	104	3.64e-18	NTclustered	gi\|2621703287\|emb\|OY762444.1\|	2026734	g75884	i0	90.909	1.16149068322981	77	7	48	0	83	159	2695633	2695709	MAG: Dehalococcoidia bacterium isolate 1bd329a7-1418-4194-a07e-3fe2e7ca1f7c genome assembly, chromosome: 1	blastn	187	104	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26843672	26843672	PRJEB39269_P_NODE_85801_length_154_cov_1.530435_g85396_i0	PRJEB39269	85801	154	1.530435	2.3568699	Chloroflexota bacterium	2026724	Bacteria	Bacteria	101	1.99e-23	NR	MDQ6673653.1	2026724	g85396	i0	90	1.96753246753247	50	5	97.4	0	2	151	789	838	MDQ6673653.1 LLM class flavin-dependent oxidoreductase [Chloroflexota bacterium]	diamond	303	101	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27026711	27026711	PRJEB39269_P_NODE_82702_length_157_cov_1.042373_g82297_i0	PRJEB39269	82702	157	1.042373	1.63652561	Bacteria	2	Bacteria	Bacteria	47.4	2.62e-4	NR	MEA3377224.1	2026724	g82297	i0	44.9	2.82802547770701	49	26	93.6	1	3	149	674	721	MEA3377224.1 NBR1-Ig-like domain-containing protein [Chloroflexota bacterium]	diamond	444	47.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27349679	27349679	PRJEB39269_P_NODE_74383_length_163_cov_1.983871_g73978_i0	PRJEB39269	74383	163	1.983871	3.23370973	Chloroflexales bacterium	2725990	Bacteria	Bacteria	47.4	7.61e-5	NR	MEI8165616.1	2725990	g73978	i0	54.5	1.78527607361963	44	20	81	0	134	3	11	54	MEI8165616.1 DUF4844 domain-containing protein [Chloroflexales bacterium]	diamond	291	47.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales			Chloroflexales bacterium
29395229	29395229	PRJEB39269_P_NODE_71709_length_166_cov_1.614173_g71304_i0	PRJEB39269	71709	166	1.614173	2.67952718	PVC group	1783257	Bacteria	Bacteria	103	5.75e-25	NR	MBF6605010.1	2026724	g71304	i0	89.1	22.8614457831325	55	6	99.4	0	2	166	67	121	MBF6605010.1 transketolase family protein [Chloroflexota bacterium]	diamond	3795	104	0.990384615384615	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30089844	30089844	PRJEB39269_P_NODE_80592_length_158_cov_2.739496_g80187_i0	PRJEB39269	80592	158	2.739496	4.32840368	Bacteria	2	Bacteria	Bacteria	75.1	4.11e-14	NR	MBN1660975.1	2052143	g80187	i0	57.7	6.87341772151899	52	22	98.7	0	2	157	145	196	MBN1660975.1 beta-lactamase family protein [Anaerolineae bacterium]	diamond	1086	75.5	0.994701986754967	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31771675	31771675	PRJEB39269_P_NODE_57297_length_182_cov_1.433566_g56892_i0	PRJEB39269	57297	182	1.433566	2.60909012	Chloroflexota bacterium	2026724	Bacteria	Bacteria	85.1	9.41e-20	NR	MCH7580248.1	2026724	g56892	i0	72	1.64835164835165	50	14	82.4	0	2	151	48	97	MCH7580248.1 DUF1330 domain-containing protein [Chloroflexota bacterium]	diamond	300	85.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32556444	32556444	PRJEB39269_P_NODE_11599_length_410_cov_20.107817_g11194_i0	PRJEB39269	11599	410	20.107817	82.4420497	Chloroflexota	200795	Bacteria	Bacteria	45.1	0.0313	NR	PMP78997.1	152260	g11194	i0	29.2	3.25609756097561	89	47	65.1	2	404	138	299	371	PMP78997.1 MAG: transporter, partial [Chloroflexus aggregans]	diamond	1335	45.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans

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);;