metadata: contig_metadata: 8 rows where bioproject = "PRJNA1008624" and tax

8 rows where bioproject = "PRJNA1008624" 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
6104504	6104504	PRJNA1008624_P_NODE_27845_length_169_cov_0.866667_g27657_i0	PRJNA1008624	27845	169	0.866667	1.46466723	Chloroflexota	200795	Bacteria	Bacteria	110	1.1e-27	NR	MCY4246423.1	2026724	g27657	i0	94.5	64.491124260355	55	3	97.6	0	5	169	150	204	MCY4246423.1 sigma-70 family RNA polymerase sigma factor [Chloroflexota bacterium]	diamond	10899	111	0.990990990990991	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26971074	26971074	PRJNA1008624_P_NODE_29682_length_167_cov_0.881356_g29494_i0	PRJNA1008624	29682	167	0.881356	1.47186452	Chloroflexi bacterium ADurb.Bin36	1852861	Bacteria	Bacteria	94.4	4.2e-23	NR	OQA14461.1	1852861	g29494	i0	88.5	0.934131736526946	52	6	93.4	0	164	9	82	133	OQA14461.1 MAG: hypothetical protein BWY63_03165 [Chloroflexi bacterium ADurb.Bin360]	diamond	156	94.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium ADurb.Bin360
27792792	27792792	PRJNA1008624_P_NODE_27584_length_169_cov_0.866667_g27396_i0	PRJNA1008624	27584	169	0.866667	1.46466723	Candidatus Villigracilis saccharophilus	3140684	Bacteria	Bacteria	72	3.06e-14	NR	WP_345307764.1	3140684	g27396	i0	64.8	0.958579881656805	54	19	95.9	0	166	5	74	127	WP_345307764.1 hypothetical protein [Candidatus Villigracilis saccharophilus]	diamond	162	72	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Candidatus Villigracilaceae	Candidatus Villigracilis	Candidatus Villigracilis saccharophilus
28961170	28961170	PRJNA1008624_P_NODE_37268_length_160_cov_2.297297_g37080_i0	PRJNA1008624	37268	160	2.297297	3.6756752	Anaerolineae bacterium	2052143	Bacteria	Bacteria	53.5	9.66e-8	NR	MBZ0308115.1	2052143	g37080	i0	50	0.975	52	21	97.5	1	158	3	5	51	MBZ0308115.1 NAD-dependent epimerase/dehydratase family protein [Anaerolineae bacterium]	diamond	156	53.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29206217	29206217	PRJNA1008624_P_NODE_28169_length_168_cov_1.310924_g27981_i0	PRJNA1008624	28169	168	1.310924	2.20235232	Bacteria	2	Bacteria	Bacteria	52.4	5.35e-6	NR	MDD5190975.1	2026733	g27981	i0	51	2.69642857142857	49	24	87.5	0	165	19	152	200	MDD5190975.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	453	52.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
30192410	30192410	PRJNA1008624_P_NODE_30992_length_166_cov_0.888889_g30804_i0	PRJNA1008624	30992	166	0.888889	1.47555574	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.5	0.00148	NR	MBU0703773.1	2026724	g30804	i0	46.2	0.704819277108434	39	21	70.5	0	158	42	54	92	MBU0703773.1 hypothetical protein [Chloroflexota bacterium]	diamond	117	43.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31709641	31709641	PRJNA1008624_P_NODE_34397_length_164_cov_0.904348_g34209_i0	PRJNA1008624	34397	164	0.904348	1.48313072	Thermoflexales bacterium	2497639	Bacteria	Bacteria	45.4	0.00143	NR	MBP8240854.1	2497639	g34209	i0	62.5	0.731707317073171	40	15	73.2	0	122	3	407	446	MBP8240854.1 hypothetical protein [Thermoflexales bacterium]	diamond	120	45.4	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales			Thermoflexales bacterium
32752811	32752811	PRJNA1008624_P_NODE_24460_length_177_cov_1.179688_g24272_i0	PRJNA1008624	24460	177	1.179688	2.08804776	Chloroflexota bacterium	2026724	Bacteria	Bacteria	75.1	5.87e-14	NR	RLC68539.1	2026724	g24272	i0	61.4	0.966101694915254	57	22	96.6	0	173	3	485	541	RLC68539.1 MAG: hypothetical protein DRH97_02810 [Chloroflexota bacterium]	diamond	171	75.1	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);;