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

6 rows where bioproject = "PRJDB3785", 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
24234790	24234790	PRJDB3785_S_NODE_5440_length_324_cov_3.654545_g5287_i0	PRJDB3785	5440	324	3.654545	11.8407258	Chloroflexota	200795	Bacteria	Bacteria	108	5.1e-26	NR	WP_126580281.1	2014871	g5287	i0	50.5	6.83333333333333	99	47	89.8	1	4	294	50	148	WP_126580281.1 alpha/beta fold hydrolase [Tengunoibacter tsumagoiensis]	diamond	2214	108	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Dictyobacteraceae	Tengunoibacter	Tengunoibacter tsumagoiensis
27790718	27790718	PRJDB3785_S_NODE_23624_length_166_cov_1.307692_g23471_i0	PRJDB3785	23624	166	1.307692	2.17076872	Chloroflexota bacterium	2026724	Bacteria	Bacteria	68.9	7.61e-12	NR	NJD28121.1	2026724	g23471	i0	50	1.93373493975904	52	26	94	0	166	11	158	209	NJD28121.1 S9 family peptidase [Chloroflexota bacterium]	diamond	321	68.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28895548	28895548	PRJDB3785_S_NODE_16268_length_194_cov_1.310345_g16115_i0	PRJDB3785	16268	194	1.310345	2.5420693	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	43.1	0.0142	NR	MBV9257174.1	2740538	g16115	i0	33.9	0.958762886597938	62	41	95.9	0	189	4	64	125	MBV9257174.1 hypothetical protein [Ktedonobacteraceae bacterium]	diamond	186	43.1	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
29684722	29684722	PRJDB3785_S_NODE_26870_length_161_cov_1.794643_g26717_i0	PRJDB3785	26870	161	1.794643	2.88937523	Chloroflexota bacterium	2026724	Bacteria	Bacteria	57.4	1.52e-8	NR	MEZ4515128.1	2026724	g26717	i0	60	0.838509316770186	45	18	83.9	0	136	2	1	45	MEZ4515128.1 coactosin family protein [Chloroflexota bacterium]	diamond	135	57.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29995143	29995143	PRJDB3785_S_NODE_27111_length_161_cov_0.910714_g26958_i0	PRJDB3785	27111	161	0.910714	1.46624954	FCB group	1783270	Bacteria	Bacteria	42.7	0.0124	NR	WP_054493609.1	872965	g26958	i0	58.6	2.06832298136646	29	12	54	0	4	90	109	137	WP_054493609.1 long-chain fatty acid--CoA ligase [Ardenticatena maritima]	diamond	333	43.1	0.990719257540603	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatena	Ardenticatena maritima
30253899	30253899	PRJDB3785_S_NODE_23232_length_167_cov_0.864407_g23079_i0	PRJDB3785	23232	167	0.864407	1.44355969	Chloroflexota bacterium	2026724	Bacteria	Bacteria	79.3	9.56e-17	NR	MEP6895085.1	2026724	g23079	i0	67.9	6.73652694610778	53	16	95.2	1	161	3	52	103	MEP6895085.1 phytoene desaturase [Chloroflexota bacterium]	diamond	1125	79.3	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);;