metadata: contig_metadata: 16 rows where bioproject = "PRJNA752572", tax_kingdom = "Bacillati" and tax

16 rows where bioproject = "PRJNA752572", 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
21131135	21131135	PRJNA752572_P_NODE_128597_length_236_cov_3.308458_g128090_i0	PRJNA752572	128597	236	3.308458	7.80796088	PVC group	1783257	Bacteria	Bacteria	108	3.19e-25	NR	MYD35627.1	2026734	g128090	i0	84.1	25.6271186440678	63	10	80.1	0	236	48	773	835	MYD35627.1 aconitate hydratase AcnA [Dehalococcoidia bacterium]	diamond	6048	109	0.990825688073395	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
24955137	24955137	PRJNA752572_P_NODE_19180_length_615_cov_3.008621_g18743_i0	PRJNA752572	19180	615	3.008621	18.50301915	PVC group	1783257	Bacteria	Bacteria	290	6.04e-97	NR	NDJ78859.1	2026724	g18743	i0	69.7	29.2829268292683	188	57	91.7	0	585	22	3	190	NDJ78859.1 DJ-1/PfpI family protein [Chloroflexota bacterium]	diamond	18009	290	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26831404	26831404	PRJNA752572_P_NODE_154941_length_215_cov_1.355556_g154434_i0	PRJNA752572	154941	215	1.355556	2.9144454	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42	0.0371	NR	MBI3943329.1	2026724	g154434	i0	36.7	0.683720930232558	49	31	68.4	0	61	207	52	100	MBI3943329.1 hypothetical protein [Chloroflexota bacterium]	diamond	147	42	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27084522	27084522	PRJNA752572_P_NODE_103662_length_265_cov_2.078261_g103155_i0	PRJNA752572	103662	265	2.078261	5.50739165	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.5	2.32e-9	NR	RLC97578.1	2026724	g103155	i0	49.3	1.5622641509434	69	33	77	2	250	47	571	638	RLC97578.1 MAG: aminotransferase [Chloroflexota bacterium]	diamond	414	63.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27463812	27463812	PRJNA752572_P_NODE_64383_length_340_cov_1.701639_g63876_i0	PRJNA752572	64383	340	1.701639	5.7855726	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	79.3	5.35e-16	NR	HEX9038999.1	2306968	g63876	i0	54.8	2.54117647058824	73	33	64.4	0	122	340	53	125	HEX9038999.1 NADAR family protein [Ktedonobacterales bacterium]	diamond	864	79.3	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
27937388	27937388	PRJNA752572_P_NODE_236965_length_172_cov_1.751825_g236458_i0	PRJNA752572	236965	172	1.751825	3.013139	Chloroflexota bacterium	2026724	Bacteria	Bacteria	67.4	6.3e-12	NR	TAH50597.1	2026724	g236458	i0	46.3	1.55232558139535	54	29	94.2	0	170	9	90	143	TAH50597.1 MAG: carbonate dehydratase [Chloroflexota bacterium]	diamond	267	67.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28158550	28158550	PRJNA752572_P_NODE_75885_length_312_cov_2.490975_g75378_i0	PRJNA752572	75885	312	2.490975	7.771842	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	74.3	6.6e-13	NR	MSQ41648.1	2026734	g75378	i0	39.5	0.826923076923077	86	52	82.7	0	305	48	301	386	MSQ41648.1 aminopeptidase N [Dehalococcoidia bacterium]	diamond	258	74.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
28347710	28347710	PRJNA752572_P_NODE_127706_length_237_cov_2.678218_g127199_i0	PRJNA752572	127706	237	2.678218	6.34737666	Dictyobacter vulcani	2607529	Bacteria	Bacteria	59.7	3.78e-8	NR	WP_151756709.1	2607529	g127199	i0	42.1	0.962025316455696	76	43	96.2	1	10	237	902	976	WP_151756709.1 bifunctional cytochrome P450/NADPH--P450 reductase [Dictyobacter vulcani]	diamond	228	59.7	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Dictyobacteraceae	Dictyobacter	Dictyobacter vulcani
28537403	28537403	PRJNA752572_P_NODE_203547_length_186_cov_2.377483_g203040_i0	PRJNA752572	203547	186	2.377483	4.42211838	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	42.4	0.0244	NR	MBX3052446.1	2614250	g203040	i0	50	0.645161290322581	40	20	64.5	0	49	168	130	169	MBX3052446.1 trypsin-like peptidase domain-containing protein [Caldilineaceae bacterium]	diamond	120	42.4	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
28632128	28632128	PRJNA752572_P_NODE_251667_length_168_cov_1.503759_g251160_i0	PRJNA752572	251667	168	1.503759	2.52631512	Chloroflexota bacterium	2026724	Bacteria	Bacteria	79.7	6.92e-16	NR	MDA1127084.1	2026724	g251160	i0	60	0.982142857142857	55	22	98.2	0	2	166	96	150	MDA1127084.1 methyltransferase [Chloroflexota bacterium]	diamond	165	79.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28852715	28852715	PRJNA752572_P_NODE_163868_length_209_cov_1.143678_g163361_i0	PRJNA752572	163868	209	1.143678	2.39028702	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	53.5	2.53e-6	NR	MDP7619880.1	2026734	g163361	i0	42	0.990430622009569	69	37	99	1	1	207	66	131	MDP7619880.1 MIP/aquaporin family protein [Dehalococcoidia bacterium]	diamond	207	53.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
30621467	30621467	PRJNA752572_P_NODE_268253_length_164_cov_1.139535_g267746_i0	PRJNA752572	268253	164	1.139535	1.8688374	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42	0.0237	NR	MDI9547353.1	2026724	g267746	i0	44.4	0.658536585365854	36	20	65.9	0	15	122	214	249	MDI9547353.1 (Fe-S)-binding protein [Chloroflexota bacterium]	diamond	108	42	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30716255	30716255	PRJNA752572_P_NODE_216934_length_180_cov_1.634483_g216427_i0	PRJNA752572	216934	180	1.634483	2.9420694	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.8	0.00128	NR	MEM7799523.1	2026724	g216427	i0	64.5	0.516666666666667	31	11	51.7	0	83	175	308	338	MEM7799523.1 hypothetical protein [Chloroflexota bacterium]	diamond	93	45.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30947613	30947613	PRJNA752572_P_NODE_266514_length_164_cov_2.046512_g266007_i0	PRJNA752572	266514	164	2.046512	3.35627968	Bacteria	2	Bacteria	Bacteria	100	3.789999999999999e-23	NR	HXY00860.1	2952938	g266007	i0	83.3	4.90243902439024	54	9	98.8	0	163	2	377	430	HXY00860.1 GMC family oxidoreductase [Candidatus Limnocylindrales bacterium]	diamond	804	100	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
31126743	31126743	PRJNA752572_P_NODE_213895_length_181_cov_2.986301_g213388_i0	PRJNA752572	213895	181	2.986301	5.40520481	Chloroflexota bacterium	2026724	Bacteria	Bacteria	51.6	7.85e-6	NR	NLE50383.1	2026724	g213388	i0	50	5.28729281767956	46	22	74.6	1	42	176	83	128	NLE50383.1 CDP-archaeol synthase [Chloroflexota bacterium]	diamond	957	51.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31674473	31674473	PRJNA752572_P_NODE_68917_length_328_cov_1.907850_g68410_i0	PRJNA752572	68917	328	1.90785	6.257748	Bacillati	1783272	Bacteria	Bacteria	77	3.67e-14	NR	MEA2684704.1	2026724	g68410	i0	36.1	2.96341463414634	108	69	98.8	0	4	327	94	201	MEA2684704.1 hypothetical protein [Chloroflexota bacterium]	diamond	972	77	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);;