metadata: contig_metadata: 9 rows where bioproject = "PRJNA382357", tax_clade = "ac1 cluster" and tax

9 rows where bioproject = "PRJNA382357", tax_clade = "ac1 cluster" and tax_kingdom = "Bacillati"

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_species
23354991	23354991	PRJNA382357_P_NODE_141219_length_208_cov_1.251701_g140480_i0	PRJNA382357	141219	208	1.251701	2.60353808	ac1 cluster	1655545	Bacteria	Bacteria	62	2.25e-9	NR	KRO43633.1	1655569	g140480	i0	96.7	12.9807692307692	30	1	43.3	0	146	57	105	134	KRO43633.1 MAG: 6-phosphofructokinase, partial [Actinobacteria bacterium BACL2 MAG-120813-bin23]	diamond	2700	62.4	0.993589743589744	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes	Actinobacteria bacterium BACL2 MAG-120813-bin23
26933832	26933832	PRJNA382357_P_NODE_163542_length_189_cov_5.851562_g162803_i0	PRJNA382357	163542	189	5.851562	11.05945218	Bacteria	2	Bacteria	Bacteria	73.2	5.1e-14	NR	KRO31622.1	1655572	g162803	i0	97.2	4.09523809523809	36	1	57.1	0	129	22	36	71	KRO31622.1 MAG: thymidylate kinase [Actinobacteria bacterium BACL2 MAG-121001-bin67]	diamond	774	73.2	1	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes	Actinobacteria bacterium BACL2 MAG-121001-bin67
27724228	27724228	PRJNA382357_P_NODE_112204_length_230_cov_1.538462_g111465_i0	PRJNA382357	112204	230	1.538462	3.5384626	Bacteria	2	Bacteria	Bacteria	110	4.91e-29	NR	KRO30819.1	1655568	g111465	i0	92.7	1.43478260869565	55	4	71.7	0	165	1	39	93	KRO30819.1 MAG: 50S ribosomal protein L15, partial [Actinobacteria bacterium BACL2 MAG-120802-bin41]	diamond	330	111	0.990990990990991	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes	Actinobacteria bacterium BACL2 MAG-120802-bin41
30534339	30534339	PRJNA382357_P_NODE_172073_length_166_cov_2.933333_g171334_i0	PRJNA382357	172073	166	2.933333	4.86933278	Candidatus Planktophila	622681	Bacteria	Bacteria	53.5	2.06e-6	NR	KRO35625.1	1655562	g171334	i0	95.7	9.14457831325301	23	1	41.6	0	162	94	309	331	KRO35625.1 MAG: DNA topoisomerase I, partial [Actinobacteria bacterium BACL15 MAG-120619-bin91]	diamond	1518	53.5	1	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes	Actinobacteria bacterium BACL15 MAG-120619-bin91
30548915	30548915	PRJNA382357_P_NODE_110693_length_231_cov_5.458824_g109954_i0	PRJNA382357	110693	231	5.458824	12.60988344	Actinobacteria bacterium BACL15 MAG-12	2900548	Bacteria	Bacteria	88.6	1.18e-19	NR	KRO36135.1	1655562	g109954	i0	97.7	0.558441558441558	43	1	55.8	0	129	1	89	131	KRO36135.1 MAG: para-aminobenzoate synthase [Actinobacteria bacterium BACL15 MAG-120619-bin91]	diamond	129	88.6	1	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes	Actinobacteria bacterium BACL15 MAG-120619-bin91
31008333	31008333	PRJNA382357_P_NODE_122954_length_220_cov_5.811321_g122215_i0	PRJNA382357	122954	220	5.811321	12.7849062	Bacteria	2	Bacteria	Bacteria	81.3	3.34e-17	NR	KRO32570.1	1655572	g122215	i0	64.2	3.21818181818182	67	17	81.8	1	180	1	107	173	KRO32570.1 MAG: hypothetical protein ABR64_00650 [Actinobacteria bacterium BACL2 MAG-121001-bin67]	diamond	708	81.3	1	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes	Actinobacteria bacterium BACL2 MAG-121001-bin67
31165996	31165996	PRJNA382357_P_NODE_159015_length_197_cov_2.433824_g158276_i0	PRJNA382357	159015	197	2.433824	4.79463328	Bacteria	2	Bacteria	Bacteria	85.9	2.3e-18	NR	KRO35820.1	1655563	g158276	i0	78.2	11.741116751269	55	12	83.8	0	33	197	166	220	KRO35820.1 MAG: ABC transporter ATP-binding protein [Actinobacteria bacterium BACL15 MAG-120823-bin78]	diamond	2313	86.3	0.995365005793743	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes	Actinobacteria bacterium BACL15 MAG-120823-bin78
32210171	32210171	PRJNA382357_P_NODE_151978_length_203_cov_2.908451_g151239_i0	PRJNA382357	151978	203	2.908451	5.90415553	ac1 cluster	1655545	Bacteria	Bacteria	79.3	2.7e-15	NR	KRO31116.1	1655568	g151239	i0	97.6	7.95073891625616	41	1	60.6	0	185	63	74	114	KRO31116.1 MAG: methylmalonate-semialdehyde dehydrogenase [Actinobacteria bacterium BACL2 MAG-120802-bin41]	diamond	1614	79.7	0.994981179422836	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes	Actinobacteria bacterium BACL2 MAG-120802-bin41
32400139	32400139	PRJNA382357_P_NODE_70439_length_282_cov_1.692308_g69700_i0	PRJNA382357	70439	282	1.692308	4.77230856	Candidatus Planktophila	622681	Bacteria	Bacteria	52.8	4.9e-6	NR	KRO36571.1	1655562	g69700	i0	49	0.925531914893617	49	25	52.1	0	2	148	33	81	KRO36571.1 MAG: hypothetical protein ABR54_00955 [Actinobacteria bacterium BACL15 MAG-120619-bin91]	diamond	261	53.1	0.994350282485876	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes	Actinobacteria bacterium BACL15 MAG-120619-bin91

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);;