metadata: contig_metadata: 9 rows where bioproject = "PRJNA1240805", tax_kingdom = "Bacillati" and tax

9 rows where bioproject = "PRJNA1240805", 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_species
349312	349312	PRJNA1240805_P_NODE_3961_length_232_cov_2.907104_g3912_i0	PRJNA1240805	3961	232	2.907104	6.74448128	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	161	3.3e-35	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g3912	i0	89.683	39.7586206896552	126	13	54	0	24	149	2065233	2065108	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	9224	161	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	uncultured Chloroflexia bacterium
20750935	20750935	PRJNA1240805_P_NODE_217_length_994_cov_9.656085_g190_i0	PRJNA1240805	217	994	9.656085	95.9814849	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	262	2.7e-80	NR	HYV33438.1	3047546	g190	i0	75.3	1.8953722334004	158	37	47.1	1	993	526	324	481	HYV33438.1 sugar transferase [Candidatus Limnocylindria bacterium]	diamond	1884	262	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindria bacterium
26661746	26661746	PRJNA1240805_P_NODE_5161_length_201_cov_3.901316_g5112_i0	PRJNA1240805	5161	201	3.901316	7.84164516	Chloroflexota bacterium	2026724	Bacteria	Bacteria	125	1.9099999999999998e-31	NR	MCA0452847.1	2026724	g5112	i0	93.8	0.955223880597015	64	4	95.5	0	192	1	16	79	MCA0452847.1 type IIA DNA topoisomerase subunit B [Chloroflexota bacterium]	diamond	192	125	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
26806906	26806906	PRJNA1240805_P_NODE_7361_length_170_cov_2.347107_g7312_i0	PRJNA1240805	7361	170	2.347107	3.9900819	Bacteria	2	Bacteria	Bacteria	96.7	2.26e-22	NR	MFN8512607.1	2448782	g7312	i0	86.5	1.83529411764706	52	7	91.8	0	13	168	47	98	MFN8512607.1 tRNA lysidine(34) synthetase TilS [Chloroflexia bacterium]	diamond	312	96.7	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexia bacterium
26946922	26946922	PRJNA1240805_P_NODE_3522_length_246_cov_9.588832_g3473_i0	PRJNA1240805	3522	246	9.588832	23.58852672	Chloroflexota bacterium	2026724	Bacteria	Bacteria	85.9	1.59e-17	NR	MCA0456336.1	2026724	g3473	i0	82.4	1.20731707317073	51	9	62.2	0	86	238	115	165	MCA0456336.1 creatininase family protein [Chloroflexota bacterium]	diamond	297	85.9	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
27926391	27926391	PRJNA1240805_P_NODE_1805_length_361_cov_2.557692_g1756_i0	PRJNA1240805	1805	361	2.557692	9.23326812	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	44.3	0.0333	NR	HLE58549.1	3047546	g1756	i0	34	0.831024930747922	100	56	80.6	4	18	308	165	257	HLE58549.1 zinc ribbon domain-containing protein [Candidatus Limnocylindria bacterium]	diamond	300	44.3	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindria bacterium
29283894	29283894	PRJNA1240805_P_NODE_129_length_1213_cov_5.165808_g112_i0	PRJNA1240805	129	1213	5.165808	62.66125104	Anaerolineae bacterium CFX7	2575673	Bacteria	Bacteria	286	7.689999999999999e-89	NR	MDL1894855.1	2575673	g112	i0	52	3.46248969497115	294	132	71	2	332	1192	1	292	MDL1894855.1 transposase [Anaerolineae bacterium CFX7]	diamond	4200	286	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineae bacterium CFX7
29473239	29473239	PRJNA1240805_P_NODE_4350_length_220_cov_1.836257_g4301_i0	PRJNA1240805	4350	220	1.836257	4.0397654	Anaerolineae bacterium	2052143	Bacteria	Bacteria	67.8	3.95e-11	NR	MBL8165424.1	2052143	g4301	i0	55.4	0.886363636363636	65	29	88.6	0	18	212	82	146	MBL8165424.1 hypothetical protein [Anaerolineae bacterium]	diamond	195	67.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineae bacterium
30326868	30326868	PRJNA1240805_P_NODE_652_length_615_cov_7.556537_g606_i0	PRJNA1240805	652	615	7.556537	46.47270255	Chloroflexota bacterium	2026724	Bacteria	Bacteria	293	1.97e-93	NR	MCA0452932.1	2026724	g606	i0	90.1	0.790243902439024	162	16	79	0	116	601	158	319	MCA0452932.1 ABC transporter substrate-binding protein [Chloroflexota bacterium]	diamond	486	293	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);;