metadata: contig_metadata: 14 rows where bioproject = "PRJNA454503", tax_kingdom = "Bacillati" and tax

14 rows where bioproject = "PRJNA454503", 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_species
15744702	15744702	PRJNA454503_P_NODE_16313_length_289_cov_1.135965_g15984_i0	PRJNA454503	16313	289	1.135965	3.28293885	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	213	1.16e-50	NTclustered	gi\|2814788337\|emb\|OY760908.2\|	2026734	g15984	i0	80.479	131.515570934256	292	45	99	9	2	289	1155805	1155522	MAG: Dehalococcoidia bacterium isolate 99511b8e-fdeb-40b8-a9fc-769d5cc020c2 genome assembly, chromosome: 1	blastn	38008	213	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
17019874	17019874	PRJNA454503_P_NODE_47754_length_218_cov_1.496815_g47425_i0	PRJNA454503	47754	218	1.496815	3.2630567	Bacteria	2	Bacteria	Bacteria	135	2.02e-36	NR	MEA2578722.1	2026724	g47425	i0	86.1	3.96330275229358	72	10	99.1	0	3	218	147	218	MEA2578722.1 aspartate-semialdehyde dehydrogenase [Chloroflexota bacterium]	diamond	864	136	0.992647058823529	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
17020209	17020209	PRJNA454503_P_NODE_76834_length_204_cov_1.818182_g76505_i0	PRJNA454503	76834	204	1.818182	3.70909128	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	196	7.77e-46	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g76505	i0	84.236	1.13235294117647	203	30	99	2	3	204	785010	784809	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	231	196	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
23394813	23394813	PRJNA454503_P_NODE_54959_length_211_cov_0.866667_g54630_i0	PRJNA454503	54959	211	0.866667	1.82866737	Chloroflexota bacterium	2026724	Bacteria	Bacteria	96.3	1.42e-22	NR	MEP7378232.1	2026724	g54630	i0	87.5	1.40758293838863	48	6	68.2	0	37	180	182	229	MEP7378232.1 hypothetical protein [Chloroflexota bacterium]	diamond	297	96.3	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
23395223	23395223	PRJNA454503_P_NODE_90399_length_177_cov_4.982759_g90070_i0	PRJNA454503	90399	177	4.982759	8.81948343	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	110	8.75e-20	NTclustered	gi\|2893358404\|emb\|OZ220695.1\|	3022862	g90070	i0	86.735	0.553672316384181	98	13	55	0	68	165	1121660	1121757	MAG: Tepidiformaceae bacterium isolate d5d77930-af5a-4506-8b4e-3340c6a42e1f genome assembly, chromosome: 1	blastn	98	110	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiformaceae bacterium
27929039	27929039	PRJNA454503_P_NODE_80445_length_203_cov_1.704225_g80116_i0	PRJNA454503	80445	203	1.704225	3.45957675	Chloroflexota bacterium	2026724	Bacteria	Bacteria	77.8	1.56e-16	NR	MDP9370967.1	2026724	g80116	i0	63.6	1.95073891625616	66	24	97.5	0	5	202	15	80	MDP9370967.1 hypothetical protein [Chloroflexota bacterium]	diamond	396	77.8	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
28560583	28560583	PRJNA454503_P_NODE_74407_length_205_cov_0.902778_g74078_i0	PRJNA454503	74407	205	0.902778	1.8506949	Chloroflexia bacterium	2448782	Bacteria	Bacteria	53.1	3.54e-6	NR	MBA2289232.1	2448782	g74078	i0	44.3	1.81463414634146	61	34	89.3	0	21	203	117	177	MBA2289232.1 ABC transporter permease [Chloroflexia bacterium]	diamond	372	53.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			Chloroflexia bacterium
28939466	28939466	PRJNA454503_P_NODE_14908_length_299_cov_1.474790_g14579_i0	PRJNA454503	14908	299	1.47479	4.4096221	Anaerolineae bacterium	2052143	Bacteria	Bacteria	45.1	0.0102	NR	MCB0164326.1	2052143	g14579	i0	31.6	0.762541806020067	76	44	70.2	2	279	70	45	118	MCB0164326.1 polysaccharide deacetylase family protein [Anaerolineae bacterium]	diamond	228	45.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
29665166	29665166	PRJNA454503_P_NODE_34630_length_233_cov_1.796512_g34301_i0	PRJNA454503	34630	233	1.796512	4.18587296	Chloroflexota bacterium	2026724	Bacteria	Bacteria	100	2.12e-23	NR	MCH7656529.1	2026724	g34301	i0	59.7	1.85407725321888	72	29	92.7	0	18	233	203	274	MCH7656529.1 NAD(P)-dependent alcohol dehydrogenase [Chloroflexota bacterium]	diamond	432	100	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29918334	29918334	PRJNA454503_P_NODE_76891_length_204_cov_1.818182_g76562_i0	PRJNA454503	76891	204	1.818182	3.70909128	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	97.1	1.68e-21	NR	MEO8956901.1	2740538	g76562	i0	71.6	5.91176470588235	67	19	98.5	0	2	202	1117	1183	MEO8956901.1 hypothetical protein [Ktedonobacteraceae bacterium]	diamond	1206	97.1	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonobacteraceae bacterium
30107651	30107651	PRJNA454503_P_NODE_69932_length_206_cov_1.793103_g69603_i0	PRJNA454503	69932	206	1.793103	3.69379218	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	84.7	3.66e-17	NR	MFA4836702.1	2026734	g69603	i0	67.7	0.946601941747573	65	21	94.7	0	205	11	507	571	MFA4836702.1 TaqI-like C-terminal specificity domain-containing protein [Dehalococcoidia bacterium]	diamond	195	84.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
30739615	30739615	PRJNA454503_P_NODE_68234_length_207_cov_0.890411_g67905_i0	PRJNA454503	68234	207	0.890411	1.84315077	Chloroflexota bacterium	2026724	Bacteria	Bacteria	84.7	1.68e-17	NR	NLX10909.1	2026724	g67905	i0	62.3	2	69	26	100	0	1	207	133	201	NLX10909.1 N-acetyl-gamma-glutamyl-phosphate reductase [Chloroflexota bacterium]	diamond	414	84.7	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30960932	30960932	PRJNA454503_P_NODE_70114_length_206_cov_1.793103_g69785_i0	PRJNA454503	70114	206	1.793103	3.69379218	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	67.4	4.53e-11	NR	MFA7407698.1	2024896	g69785	i0	53.7	0.975728155339806	67	29	97.6	1	205	5	95	159	MFA7407698.1 MoxR family ATPase [Anaerolineaceae bacterium]	diamond	201	67.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
31118546	31118546	PRJNA454503_P_NODE_54695_length_211_cov_0.866667_g54366_i0	PRJNA454503	54695	211	0.866667	1.82866737	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	83.6	4.52e-17	NR	HET9540931.1	3047546	g54366	i0	94.7	0.540284360189573	38	2	54	0	3	116	296	333	HET9540931.1 magnesium/cobalt transporter CorA [Candidatus Limnocylindria bacterium]	diamond	114	83.6	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria			Candidatus Limnocylindria 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);;