metadata: contig_metadata: 13 rows where bioproject = "PRJEB10320", tax_kingdom = "Bacillati" and tax

13 rows where bioproject = "PRJEB10320", 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
14041649	14041649	PRJEB10320_P_NODE_28352_length_151_cov_1.163793_g28094_i0	PRJEB10320	28352	151	1.163793	1.75732743	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	75.1	3.96e-14	NR	HZB94681.1	2720503	g28094	i0	69.4	6.79470198675497	49	15	97.4	0	149	3	24	72	HZB94681.1 phosphoenolpyruvate carboxykinase (GTP) [Herpetosiphonaceae bacterium]	diamond	1026	75.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
26621158	26621158	PRJEB10320_P_NODE_5101_length_469_cov_1.516129_g4855_i0	PRJEB10320	5101	469	1.516129	7.11064501	Chloroflexota bacterium	2026724	Bacteria	Bacteria	216	9.22e-65	NR	MDQ2887095.1	2026724	g4855	i0	61.6	1.90618336886994	151	58	96.6	0	15	467	260	410	MDQ2887095.1 phosphoesterase [Chloroflexota bacterium]	diamond	894	216	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27000877	27000877	PRJEB10320_P_NODE_18122_length_206_cov_2.345029_g17864_i0	PRJEB10320	18122	206	2.345029	4.83075974	Anaerolineales bacterium	2073117	Bacteria	Bacteria	40.4	0.0326	NR	HEU0292488.1	2073117	g17864	i0	85	0.29126213592233	20	3	29.1	0	138	197	25	44	HEU0292488.1 alpha/beta fold hydrolase [Anaerolineales bacterium]	diamond	60	40.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27437715	27437715	PRJEB10320_P_NODE_24783_length_165_cov_1.476923_g24525_i0	PRJEB10320	24783	165	1.476923	2.43692295	Bacillati	1783272	Bacteria	Bacteria	54.7	7.7e-7	NR	MDB5058896.1	2026724	g24525	i0	60	6.34545454545455	50	20	90.9	0	151	2	160	209	MDB5058896.1 hypothetical protein [Chloroflexota bacterium]	diamond	1047	54.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27633117	27633117	PRJEB10320_P_NODE_4124_length_527_cov_2.193089_g3891_i0	PRJEB10320	4124	527	2.193089	11.55757903	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	75.5	2.53e-12	NR	HZU01136.1	2740538	g3891	i0	43.3	2.70967741935484	97	53	55.2	2	505	215	377	471	HZU01136.1 MFS transporter [Ktedonobacteraceae bacterium]	diamond	1428	75.5	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
27853996	27853996	PRJEB10320_P_NODE_18145_length_206_cov_1.865497_g17887_i0	PRJEB10320	18145	206	1.865497	3.84292382	Chloroflexota bacterium	2026724	Bacteria	Bacteria	49.3	1.1e-4	NR	MEM7531733.1	2026724	g17887	i0	40.6	0.932038834951456	64	38	93.2	0	1	192	378	441	MEM7531733.1 hypothetical protein [Chloroflexota bacterium]	diamond	192	49.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27980359	27980359	PRJEB10320_P_NODE_14985_length_236_cov_1.074627_g14727_i0	PRJEB10320	14985	236	1.074627	2.53611972	Anaerolineales bacterium	2073117	Bacteria	Bacteria	114	9.44e-28	NR	MCS7010599.1	2073117	g14727	i0	71.1	0.966101694915254	76	22	96.6	0	8	235	353	428	MCS7010599.1 transketolase [Anaerolineales bacterium]	diamond	228	114	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29621705	29621705	PRJEB10320_P_NODE_24090_length_168_cov_1.736842_g23832_i0	PRJEB10320	24090	168	1.736842	2.91789456	Longilinea arvoryzae	360412	Bacteria	Bacteria	54.3	9e-7	NR	WP_075075167.1	360412	g23832	i0	52.8	0.946428571428571	53	14	94.6	1	161	3	217	258	WP_075075167.1 alpha/beta fold hydrolase [Longilinea arvoryzae]	diamond	159	54.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Longilinea	Longilinea arvoryzae
29653384	29653384	PRJEB10320_P_NODE_24650_length_165_cov_9.161538_g24392_i0	PRJEB10320	24650	165	9.161538	15.1165377	Anaerolineales bacterium	2073117	Bacteria	Bacteria	41.6	0.032	NR	HET9588558.1	2073117	g24392	i0	47.4	1.45454545454545	38	20	69.1	0	32	145	139	176	HET9588558.1 ABC-2 family transporter protein [Anaerolineales bacterium]	diamond	240	41.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29906528	29906528	PRJEB10320_P_NODE_24551_length_166_cov_1.526718_g24293_i0	PRJEB10320	24551	166	1.526718	2.53435188	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	66.2	9.27e-12	NR	HEU5438112.1	2306968	g24293	i0	67.4	7.98795180722892	46	15	83.1	0	138	1	84	129	HEU5438112.1 NADAR family protein [Ktedonobacterales bacterium]	diamond	1326	66.2	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
30152777	30152777	PRJEB10320_P_NODE_11152_length_289_cov_1.767717_g10894_i0	PRJEB10320	11152	289	1.767717	5.10870213	Bacteria	2	Bacteria	Bacteria	85.9	4.06e-17	NR	TDI88824.1	2026724	g10894	i0	41.2	4.68166089965398	97	55	98.6	1	288	4	312	408	TDI88824.1 MAG: proline--tRNA ligase [Chloroflexota bacterium]	diamond	1353	85.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30879648	30879648	PRJEB10320_P_NODE_10094_length_308_cov_2.047619_g9836_i0	PRJEB10320	10094	308	2.047619	6.30666652	PVC group	1783257	Bacteria	Bacteria	103	1.24e-24	NR	WP_007916255.1	363277	g9836	i0	51.5	6.88636363636364	101	49	98.4	0	2	304	14	114	WP_007916255.1 glucose 1-dehydrogenase [Ktedonobacter racemifer]	diamond	2121	104	0.990384615384615	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonobacter	Ktedonobacter racemifer
32239810	32239810	PRJEB10320_P_NODE_20018_length_193_cov_0.993671_g19760_i0	PRJEB10320	20018	193	0.993671	1.91778503	FCB group	1783270	Bacteria	Bacteria	52	1.05e-5	NR	MCP4418544.1	2026724	g19760	i0	49.1	5.00518134715026	55	28	85.5	0	192	28	148	202	MCP4418544.1 long-chain fatty acid--CoA ligase [Chloroflexota bacterium]	diamond	966	52	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);;