metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1145574" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1145574" and tax_phylum = "Actinomycetota"

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
27438988	27438988	PRJNA1145574_P_NODE_14243_length_244_cov_0.912281_g14059_i0	PRJNA1145574	14243	244	0.912281	2.22596564	Bacteria	2	Bacteria	Bacteria	162	1.96e-48	NR	KRO30988.1	1655568	g14059	i0	98.8	1.9672131147541	80	1	98.4	0	242	3	79	158	KRO30988.1 MAG: ubiquinone biosynthesis methyltransferase UbiE [Actinobacteria bacterium BACL2 MAG-120802-bin41]	diamond	480	162	1	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes				Actinobacteria bacterium BACL2 MAG-120802-bin41
27817791	27817791	PRJNA1145574_P_NODE_14804_length_242_cov_0.923077_g14620_i0	PRJNA1145574	14804	242	0.923077	2.23384634	Clavibacter	1573	Bacteria	Bacteria	156	1.84e-44	NR	MFO0196973.1	1871044	g14620	i0	100	5.9504132231405	80	0	99.2	0	242	3	59	138	MFO0196973.1 lysine--tRNA ligase [Clavibacter sp.]	diamond	1440	156	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter sp.
27943959	27943959	PRJNA1145574_P_NODE_13765_length_245_cov_0.906977_g13581_i0	PRJNA1145574	13765	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	166	3.36e-50	NR	KRO30986.1	1655568	g13581	i0	97.5	22.7755102040816	81	2	99.2	0	1	243	63	143	KRO30986.1 MAG: NADH dehydrogenase [Actinobacteria bacterium BACL2 MAG-120802-bin41]	diamond	5580	166	1	Bacteria	ac1 cluster	Bacillati	Actinomycetota	Actinomycetes				Actinobacteria bacterium BACL2 MAG-120802-bin41
29565189	29565189	PRJNA1145574_P_NODE_14010_length_244_cov_1.368421_g13826_i0	PRJNA1145574	14010	244	1.368421	3.33894724	Sciscionella sediminilitoris	1445613	Bacteria	Bacteria	76.3	4.82e-14	NR	WP_031469109.1	1445613	g13826	i0	47.5	2.00409836065574	80	38	97.1	2	243	7	252	328	WP_031469109.1 NAD-dependent epimerase/dehydratase family protein [Sciscionella sediminilitoris]	diamond	489	76.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Sciscionella	Sciscionella sediminilitoris
29722814	29722814	PRJNA1145574_P_NODE_11290_length_252_cov_0.871508_g11106_i0	PRJNA1145574	11290	252	0.871508	2.19620016	Actinomycetota bacterium	2900548	Bacteria	Bacteria	144	1.52e-40	NR	NBY82603.1	2900548	g11106	i0	89.2	4.94047619047619	83	9	98.8	0	2	250	207	289	NBY82603.1 TIGR01777 family protein [Actinomycetota bacterium]	diamond	1245	144	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
29817678	29817678	PRJNA1145574_P_NODE_11211_length_253_cov_0.866667_g11027_i0	PRJNA1145574	11211	253	0.866667	2.19266751	Amycolatopsis sp. NPDC	37632	Bacteria	Bacteria	126	2.3e-34	NR	WP_364623099.1	3155800	g11027	i0	87	0.91304347826087	77	10	91.3	0	251	21	125	201	WP_364623099.1 TetR/AcrR family transcriptional regulator [Amycolatopsis sp. NPDC051371]	diamond	231	126	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. NPDC051371
30260381	30260381	PRJNA1145574_P_NODE_9232_length_283_cov_1.261905_g9048_i0	PRJNA1145574	9232	283	1.261905	3.57119115	Microbacteriaceae bacterium	1873462	Bacteria	Bacteria	121	1.25e-33	NR	MDQ1532072.1	1873462	g9048	i0	59.1	0.985865724381625	93	38	98.6	0	1	279	5	97	MDQ1532072.1 hypothetical protein [Microbacteriaceae bacterium]	diamond	279	121	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae		Microbacteriaceae bacterium
31366325	31366325	PRJNA1145574_P_NODE_13176_length_247_cov_0.896552_g12992_i0	PRJNA1145574	13176	247	0.896552	2.21448344	Solirubrobacterales bacterium	1909295	Bacteria	Bacteria	43.9	0.0151	NR	HEX3562609.1	1909295	g12992	i0	40	0.607287449392713	50	30	60.7	0	152	3	745	794	HEX3562609.1 Coagulation factor 5/8 type domain-containing protein [Solirubrobacterales bacterium]	diamond	150	43.9	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			Solirubrobacterales bacterium
31650618	31650618	PRJNA1145574_P_NODE_11977_length_250_cov_0.881356_g11793_i0	PRJNA1145574	11977	250	0.881356	2.20339	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	43.9	0.0148	NR	HVM03280.1	2201156	g11793	i0	37.5	0.864	72	37	76.8	1	12	203	292	363	HVM03280.1 glycosyltransferase [Acidimicrobiales bacterium]	diamond	216	43.9	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales 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);;