metadata: contig_metadata: 18 rows where bioproject = "PRJNA541476", tax_kingdom = "Bacillati" and tax

18 rows where bioproject = "PRJNA541476", 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
4336237	4336237	PRJNA541476_P_NODE_7684_length_408_cov_2.214925_g7480_i0	PRJNA541476	7684	408	2.214925	9.036894	Bacteria	2	Bacteria	Bacteria	231	6.03e-71	NR	HEY48453.1	2026734	g7480	i0	79.4	25	136	28	100	0	1	408	61	196	HEY48453.1 catalase [Dehalococcoidia bacterium]	diamond	10200	233	0.991416309012876	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
11987169	11987169	PRJNA541476_P_NODE_13970_length_317_cov_2.106557_g13764_i0	PRJNA541476	13970	317	2.106557	6.67778569	PVC group	1783257	Bacteria	Bacteria	107	6.36e-26	NR	WP_007916255.1	363277	g13764	i0	52.9	3.82334384858044	102	48	96.5	0	11	316	4	105	WP_007916255.1 glucose 1-dehydrogenase [Ktedonobacter racemifer]	diamond	1212	107	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonobacter	Ktedonobacter racemifer
11988029	11988029	PRJNA541476_P_NODE_6870_length_431_cov_3.874302_g6666_i0	PRJNA541476	6870	431	3.874302	16.69824162	Chloroflexota	200795	Bacteria	Bacteria	230	5.11e-73	NR	WP_141612290.1	1204385	g6666	i0	81.8	39.7030162412993	143	26	99.5	0	431	3	125	267	WP_141612290.1 pyridoxal 5'-phosphate synthase lyase subunit PdxS [Litorilinea aerophila]	diamond	17112	231	0.995670995670996	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
26824859	26824859	PRJNA541476_P_NODE_14821_length_311_cov_1.000000_g14615_i0	PRJNA541476	14821	311	1	3.11	Anaerolineae bacterium	2052143	Bacteria	Bacteria	123	1.0599999999999998e-31	NR	HID54223.1	2052143	g14615	i0	58.3	3.96463022508039	103	43	99.4	0	2	310	37	139	HID54223.1 SDR family NAD(P)-dependent oxidoreductase [Anaerolineae bacterium]	diamond	1233	123	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27741588	27741588	PRJNA541476_P_NODE_20444_length_280_cov_1.637681_g20238_i0	PRJNA541476	20444	280	1.637681	4.5855068	Anaerolineae bacterium	2052143	Bacteria	Bacteria	70.1	1.06e-11	NR	MBE2221621.1	2052143	g20238	i0	39.1	0.985714285714286	92	51	98.6	1	278	3	259	345	MBE2221621.1 low-specificity L-threonine aldolase [Anaerolineae bacterium]	diamond	276	70.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28499186	28499186	PRJNA541476_P_NODE_1587_length_941_cov_4.831797_g1438_i0	PRJNA541476	1587	941	4.831797	45.46720977	Anaerolineales bacterium	2073117	Bacteria	Bacteria	86.7	4.84e-15	NR	MFP4396114.1	2073117	g1438	i0	38.8	1.53347502656748	121	64	38.6	2	106	468	78	188	MFP4396114.1 NBR1-Ig-like domain-containing protein [Anaerolineales bacterium]	diamond	1443	86.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29650137	29650137	PRJNA541476_P_NODE_37390_length_244_cov_0.912281_g37184_i0	PRJNA541476	37390	244	0.912281	2.22596564	Bacteria	2	Bacteria	Bacteria	99.8	3.38e-22	NR	MDQ3167681.1	2026724	g37184	i0	64.2	2.98770491803279	81	29	99.6	0	2	244	342	422	MDQ3167681.1 DNA polymerase I [Chloroflexota bacterium]	diamond	729	100	0.998	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30014770	30014770	PRJNA541476_P_NODE_2831_length_700_cov_3.599681_g2640_i0	PRJNA541476	2831	700	3.599681	25.197767	Anaerolineae bacterium	2052143	Bacteria	Bacteria	80.9	1.86e-15	NR	MCW5848612.1	2052143	g2640	i0	43.5	0.561428571428571	131	67	56.1	3	44	436	1	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	393	80.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30583201	30583201	PRJNA541476_P_NODE_41193_length_234_cov_2.360248_g40987_i0	PRJNA541476	41193	234	2.360248	5.52298032	Anaerolineae bacterium	2052143	Bacteria	Bacteria	73.2	2.93e-13	NR	MBC7811795.1	2052143	g40987	i0	50.7	7.01282051282051	75	36	96.2	1	9	233	16	89	MBC7811795.1 lysophospholipase [Anaerolineae bacterium]	diamond	1641	73.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30614908	30614908	PRJNA541476_P_NODE_41853_length_227_cov_3.058442_g41647_i0	PRJNA541476	41853	227	3.058442	6.94266334	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	61.6	1.37e-9	NR	HEY2887563.1	2952938	g41647	i0	61.2	4.09691629955947	49	19	64.8	0	37	183	1	49	HEY2887563.1 ACT domain-containing protein [Candidatus Limnocylindrales bacterium]	diamond	930	61.6	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
31120187	31120187	PRJNA541476_P_NODE_10155_length_358_cov_2.389474_g9949_i0	PRJNA541476	10155	358	2.389474	8.55431692	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	137	3.93e-39	NR	MCB0085749.1	2614250	g9949	i0	62.5	5.98324022346369	104	39	87.2	0	3	314	19	122	MCB0085749.1 S-methyl-5-thioribose-1-phosphate isomerase [Caldilineaceae bacterium]	diamond	2142	137	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
31151715	31151715	PRJNA541476_P_NODE_16655_length_299_cov_1.309735_g16449_i0	PRJNA541476	16655	299	1.309735	3.91610765	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	72.4	3.89e-13	NR	HXF62623.1	2614250	g16449	i0	44.9	2.67892976588629	89	46	89.3	2	31	297	79	164	HXF62623.1 translation elongation factor Ts [Caldilineaceae bacterium]	diamond	801	72.4	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
31183438	31183438	PRJNA541476_P_NODE_22555_length_272_cov_0.979899_g22349_i0	PRJNA541476	22555	272	0.979899	2.66532528	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	54.7	3.3e-6	NR	MBA2678022.1	2740538	g22349	i0	42.4	1.30147058823529	59	34	65.1	0	6	182	418	476	MBA2678022.1 hypothetical protein [Ktedonobacteraceae bacterium]	diamond	354	54.7	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
31246904	31246904	PRJNA541476_P_NODE_36015_length_245_cov_0.906977_g35809_i0	PRJNA541476	36015	245	0.906977	2.22209365	Chloroflexota bacterium	2026724	Bacteria	Bacteria	68.2	4.31e-11	NR	MBI5842518.1	2026724	g35809	i0	43.2	2.98775510204082	81	45	99.2	1	3	245	1140	1219	MBI5842518.1 cadherin domain-containing protein [Chloroflexota bacterium]	diamond	732	68.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31989275	31989275	PRJNA541476_P_NODE_4478_length_540_cov_8.922912_g4279_i0	PRJNA541476	4478	540	8.922912	48.1837248	Bacteria	2	Bacteria	Bacteria	98.2	1.75e-23	NR	MEO0563457.1	2026724	g4279	i0	73.8	2.46666666666667	61	16	33.9	0	135	317	3	63	MEO0563457.1 cold-shock protein [Chloroflexota bacterium]	diamond	1332	98.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32669970	32669970	PRJNA541476_P_NODE_35560_length_246_cov_0.774566_g35354_i0	PRJNA541476	35560	246	0.774566	1.90543236	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	58.9	7.67e-8	NR	MDO9334301.1	2026733	g35354	i0	45.2	0.75609756097561	62	34	75.6	0	230	45	774	835	MDO9334301.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	186	58.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
32701425	32701425	PRJNA541476_P_NODE_26060_length_259_cov_1.817204_g25854_i0	PRJNA541476	26060	259	1.817204	4.70655836	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	73.6	6.53e-13	NR	MFN8486049.1	2614250	g25854	i0	45.2	3.68339768339768	84	33	97.3	2	252	1	21	91	MFN8486049.1 ELWxxDGT repeat protein [Caldilineaceae bacterium]	diamond	954	73.6	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
32890323	32890323	PRJNA541476_P_NODE_3700_length_602_cov_4.561437_g3506_i0	PRJNA541476	3700	602	4.561437	27.45985074	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	92	1.21e-17	NR	MFA5379264.1	2026734	g3506	i0	33.1	0.901993355481728	181	72	89.2	5	8	544	1592	1725	MFA5379264.1 PKD domain-containing protein [Dehalococcoidia bacterium]	diamond	543	92	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia 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);;