metadata: contig_metadata: 6 rows where bioproject = "PRJNA758087", tax_kingdom = "Bacillati" and tax

6 rows where bioproject = "PRJNA758087", 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_species
733198	733198	PRJNA758087_P_NODE_22661_length_552_cov_7.782881_g21346_i0	PRJNA758087	22661	552	7.782881	42.96150312	Chloroflexia bacterium	2448782	Bacteria	Bacteria	177	2.3099999999999993e-52	NR	MBA2277952.1	2448782	g21346	i0	62.8	0.847826086956522	156	57	84.8	1	509	42	1	155	MBA2277952.1 ferritin-like domain-containing protein [Chloroflexia bacterium]	diamond	468	177	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		Chloroflexia bacterium
5836564	5836564	PRJNA758087_P_NODE_14605_length_782_cov_4.912553_g13386_i0	PRJNA758087	14605	782	4.912553	38.41616446	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	490	2.319999999999999e-169	NR	HSL91706.1	2952938	g13386	i0	98.8	0.974424552429668	254	3	97.4	0	763	2	201	454	HSL91706.1 proline--tRNA ligase [Candidatus Limnocylindrales bacterium]	diamond	762	490	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales	Candidatus Limnocylindrales bacterium
10937854	10937854	PRJNA758087_P_NODE_43609_length_241_cov_4.011905_g42289_i0	PRJNA758087	43609	241	4.011905	9.66869105	Chloroflexota bacterium	2026724	Bacteria	Bacteria	76.6	3.61e-14	NR	RIK41952.1	2026724	g42289	i0	77.3	1.05809128630705	44	10	54.8	0	3	134	141	184	RIK41952.1 MAG: acetylornithine deacetylase [Chloroflexota bacterium]	diamond	255	76.6	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
12213338	12213338	PRJNA758087_P_NODE_42490_length_247_cov_0.885057_g41170_i0	PRJNA758087	42490	247	0.885057	2.18609079	Chloroflexota bacterium	2026724	Bacteria	Bacteria	144	5.35e-40	NR	MEW6226467.1	2026724	g41170	i0	86.6	0.995951417004049	82	11	99.6	0	2	247	89	170	MEW6226467.1 MFS transporter [Chloroflexota bacterium]	diamond	246	144	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
26736036	26736036	PRJNA758087_P_NODE_30181_length_408_cov_5.683582_g28861_i0	PRJNA758087	30181	408	5.683582	23.18901456	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	150	1.59e-39	NR	CAA9363711.1	1672391	g28861	i0	66.4	0.919117647058823	125	39	91.9	1	31	405	76	197	CAA9363711.1 MAG: helicase, SNF2 family, partial [uncultured Chloroflexia bacterium]	diamond	375	150	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
31453378	31453378	PRJNA758087_P_NODE_7056_length_1258_cov_93.581435_g6165_i0	PRJNA758087	7056	1258	93.581435	1177.2544523	Bacteria	2	Bacteria	Bacteria	145	1.44e-38	NR	MDQ4045121.1	2026724	g6165	i0	65.4	2.17726550079491	133	37	31.2	4	730	338	1	126	MDQ4045121.1 30S ribosomal protein S18 [Chloroflexota bacterium]	diamond	2739	145	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);;