metadata: contig_metadata: 17 rows where bioproject = "PRJNA694557", tax_kingdom = "Bacillati" and tax

17 rows where bioproject = "PRJNA694557", 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
673433	673433	PRJNA694557_P_NODE_26181_length_237_cov_2.597561_g25961_i0	PRJNA694557	26181	237	2.597561	6.15621957	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	91.6	4.51e-14	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g25961	i0	91.176	4.85654008438819	68	4	28	2	164	230	3497239	3497173	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1151	91.6	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
7051774	7051774	PRJNA694557_P_NODE_11006_length_407_cov_1.353293_g10786_i0	PRJNA694557	11006	407	1.353293	5.50790251	Bacteria	2	Bacteria	Bacteria	216	1.07e-66	NR	MBV9786774.1	2026724	g10786	i0	78.1	1.88697788697789	128	28	94.3	0	5	388	64	191	MBV9786774.1 acyl-CoA dehydrogenase family protein [Chloroflexota bacterium]	diamond	768	218	0.990825688073395	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
9602010	9602010	PRJNA694557_P_NODE_9888_length_435_cov_1.701657_g9668_i0	PRJNA694557	9888	435	1.701657	7.40220795	Chloroflexota bacterium	2026724	Bacteria	Bacteria	202	2.62e-63	NR	MEO8608650.1	2026724	g9668	i0	94	0.689655172413793	100	6	69	0	302	3	1	100	MEO8608650.1 3-isopropylmalate dehydratase small subunit [Chloroflexota bacterium]	diamond	300	202	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
27367340	27367340	PRJNA694557_P_NODE_10243_length_425_cov_7.670455_g10023_i0	PRJNA694557	10243	425	7.670455	32.59943375	Chloroflexota bacterium	2026724	Bacteria	Bacteria	46.6	0.0117	NR	MEI7988042.1	2026724	g10023	i0	40	0.352941176470588	50	30	35.3	0	266	415	23	72	MEI7988042.1 FHA domain-containing protein [Chloroflexota bacterium]	diamond	150	46.6	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
28377339	28377339	PRJNA694557_P_NODE_4866_length_676_cov_2.457711_g4650_i0	PRJNA694557	4866	676	2.457711	16.61412636	Chloroflexota bacterium	2026724	Bacteria	Bacteria	88.6	4e-16	NR	MCH8875637.1	2026724	g4650	i0	49.4	1.17159763313609	87	44	38.6	0	2	262	3280	3366	MCH8875637.1 right-handed parallel beta-helix repeat-containing protein [Chloroflexota bacterium]	diamond	792	88.6	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
28913956	28913956	PRJNA694557_P_NODE_23768_length_249_cov_2.017045_g23548_i0	PRJNA694557	23768	249	2.017045	5.02244205	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.9	0.0028	NR	MFO1540928.1	2026724	g23548	i0	48	0.602409638554217	50	22	60.2	1	85	234	37	82	MFO1540928.1 hypothetical protein [Chloroflexota bacterium]	diamond	150	43.9	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29324579	29324579	PRJNA694557_P_NODE_18849_length_290_cov_2.129032_g18629_i0	PRJNA694557	18849	290	2.129032	6.1741928	Chloroflexota bacterium	2026724	Bacteria	Bacteria	95.1	3.08e-21	NR	PLS78341.1	2026724	g18629	i0	64.1	1.61379310344828	78	27	79.7	1	58	288	1	78	PLS78341.1 MAG: dTDP-4-dehydrorhamnose reductase [Chloroflexota bacterium]	diamond	468	95.1	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29556851	29556851	PRJNA694557_P_NODE_9950_length_433_cov_2.438889_g9730_i0	PRJNA694557	9950	433	2.438889	10.56038937	Kallotenue	1508537	Bacteria	Bacteria	240	2.86e-77	NR	WP_026370935.1	1325125	g9730	i0	77.5	3.9284064665127	142	32	98.4	0	431	6	87	228	WP_026370935.1 dTDP-4-dehydrorhamnose reductase [Kallotenue papyrolyticum]	diamond	1701	240	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Kallotenuales	Kallotenuaceae	Kallotenue	Kallotenue papyrolyticum
30019557	30019557	PRJNA694557_P_NODE_8251_length_487_cov_3.528986_g8031_i0	PRJNA694557	8251	487	3.528986	17.18616182	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	130	6.71e-36	NR	HEY0736493.1	2720503	g8031	i0	70.5	0.991786447638604	78	23	48	0	24	257	31	108	HEY0736493.1 thioredoxin [Herpetosiphonaceae bacterium]	diamond	483	130	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
30599282	30599282	PRJNA694557_P_NODE_7953_length_498_cov_3.811765_g7733_i0	PRJNA694557	7953	498	3.811765	18.9825897	Bacillati	1783272	Bacteria	Bacteria	176	2.17e-51	NR	MBE2200426.1	1872519	g7733	i0	57.3	4.67469879518072	164	50	94	4	480	13	45	196	MBE2200426.1 phage Gp37/Gp68 family protein [Anaerolinea sp.]	diamond	2328	176	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea sp.
30967389	30967389	PRJNA694557_P_NODE_13754_length_354_cov_2.192171_g13534_i0	PRJNA694557	13754	354	2.192171	7.76028534	Anaerolineae bacterium	2052143	Bacteria	Bacteria	226	8.14e-70	NR	MBZ0290516.1	2052143	g13534	i0	93.2	0.991525423728814	117	8	99.2	0	3	353	259	375	MBZ0290516.1 3-isopropylmalate dehydratase large subunit [Anaerolineae bacterium]	diamond	351	226	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31568206	31568206	PRJNA694557_P_NODE_13156_length_363_cov_3.662069_g12936_i0	PRJNA694557	13156	363	3.662069	13.29331047	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	196	4.18e-60	NR	HEY0601991.1	2720503	g12936	i0	80.9	0.950413223140496	115	22	95	0	346	2	126	240	HEY0601991.1 CPBP family intramembrane glutamic endopeptidase [Herpetosiphonaceae bacterium]	diamond	345	196	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
31832125	31832125	PRJNA694557_P_NODE_12117_length_383_cov_1.490323_g11897_i0	PRJNA694557	12117	383	1.490323	5.70793709	PVC group	1783257	Bacteria	Bacteria	176	9.53e-53	NR	MEA2632534.1	2026724	g11897	i0	75.4	2.93733681462141	126	31	98.7	0	2	379	65	190	MEA2632534.1 magnesium transporter [Chloroflexota bacterium]	diamond	1125	176	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31852523	31852523	PRJNA694557_P_NODE_18297_length_296_cov_1.591928_g18077_i0	PRJNA694557	18297	296	1.591928	4.71210688	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	51.6	3.03e-5	NR	HEX3642862.1	2740538	g18077	i0	58.1	0.435810810810811	43	16	41.6	1	123	1	3	45	HEX3642862.1 hypothetical protein [Ktedonobacteraceae bacterium]	diamond	129	51.6	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
31884176	31884176	PRJNA694557_P_NODE_1897_length_1167_cov_2.883912_g1760_i0	PRJNA694557	1897	1167	2.883912	33.65525304	Chloroflexota bacterium	2026724	Bacteria	Bacteria	560	1.13e-198	NR	MFM2193446.1	2026724	g1760	i0	87.5	0.763496143958869	297	37	76.3	0	1165	275	29	325	MFM2193446.1 hypothetical protein [Chloroflexota bacterium]	diamond	891	560	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
32517333	32517333	PRJNA694557_P_NODE_19839_length_281_cov_1.480769_g19619_i0	PRJNA694557	19839	281	1.480769	4.16096089	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.9	1.22e-7	NR	MBL1138380.1	2026724	g19619	i0	74.4	0.416370106761566	39	10	41.6	0	121	5	1079	1117	MBL1138380.1 hypothetical protein [Chloroflexota bacterium]	diamond	117	58.9	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
32769109	32769109	PRJNA694557_P_NODE_19260_length_286_cov_2.460094_g19040_i0	PRJNA694557	19260	286	2.460094	7.03586884	Chloroflexota bacterium	2026724	Bacteria	Bacteria	83.2	4.36e-17	NR	RIK41727.1	2026724	g19040	i0	100	0.43006993006993	41	0	43	0	286	164	190	230	RIK41727.1 MAG: zinc metallopeptidase [Chloroflexota bacterium]	diamond	123	83.2	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);;