metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA561138" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA561138" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27742767	27742767	PRJNA561138_P_NODE_10204_length_401_cov_1.185976_g10009_i0	PRJNA561138	10204	401	1.185976	4.75576376	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	143	4.559999999999999e-40	NR	HET9740137.1	2586742	g10009	i0	53.4	4.90773067331671	131	60	98	1	4	396	8	137	HET9740137.1 polysaccharide deacetylase family protein [Solirubrobacteraceae bacterium]	diamond	1968	143	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
27805790	27805790	PRJNA561138_P_NODE_11844_length_377_cov_1.266447_g11649_i0	PRJNA561138	11844	377	1.266447	4.77450519	Nocardioides coralli	2872154	Bacteria	Bacteria	80.1	9.770000000000001e-16	NR	WP_222896540.1	2872154	g11649	i0	47.1	0.946949602122016	119	57	91.5	4	14	358	62	178	WP_222896540.1 hypothetical protein [Nocardioides coralli]	diamond	357	80.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides coralli
28689915	28689915	PRJNA561138_P_NODE_19347_length_295_cov_1.040541_g19152_i0	PRJNA561138	19347	295	1.040541	3.06959595	Mycobacteriales bacterium	1957017	Bacteria	Bacteria	42.7	0.0347	NR	HTW18877.1	1957017	g19152	i0	36.4	0.783050847457627	77	47	76.3	1	236	12	2	78	HTW18877.1 GNAT family N-acetyltransferase [Mycobacteriales bacterium]	diamond	231	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales			Mycobacteriales bacterium
28892900	28892900	PRJNA561138_P_NODE_17888_length_309_cov_0.978814_g17693_i0	PRJNA561138	17888	309	0.978814	3.02453526	Bacteria	2	Bacteria	Bacteria	166	8.559999999999999e-48	NR	MCT6839135.1	2478472	g17693	i0	100	2.44660194174757	84	0	81.6	0	57	308	284	367	MCT6839135.1 CHASE3 domain-containing protein [Bifidobacteriales bacterium]	diamond	756	166	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales			Bifidobacteriales bacterium
28942526	28942526	PRJNA561138_P_NODE_10088_length_403_cov_0.933333_g9893_i0	PRJNA561138	10088	403	0.933333	3.76133199	Candidatus Solirubrobacter pratensis	1298857	Bacteria	Bacteria	47	0.0067	NR	WP_028057745.1	1298857	g9893	i0	39.8	1.94292803970223	83	48	60.3	2	14	256	74	156	WP_028057745.1 FG-GAP repeat domain-containing protein [Candidatus Solirubrobacter pratensis]	diamond	783	47	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae	Solirubrobacter	Candidatus Solirubrobacter pratensis
30710960	30710960	PRJNA561138_P_NODE_24594_length_251_cov_0.865169_g24399_i0	PRJNA561138	24594	251	0.865169	2.17157419	Actinomycetota bacterium	2900548	Bacteria	Bacteria	42.7	0.00529	NR	MEA2510206.1	2900548	g24399	i0	57.1	0.418326693227092	35	13	40.6	2	117	218	17	50	MEA2510206.1 hypothetical protein [Actinomycetota bacterium]	diamond	105	42.7	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30774334	30774334	PRJNA561138_P_NODE_17874_length_309_cov_1.072034_g17679_i0	PRJNA561138	17874	309	1.072034	3.31258506	Kutzneria sp. 744	345341	Bacteria	Bacteria	52	4.47e-5	NR	WP_052395479.1	345341	g17679	i0	44.3	0.766990291262136	79	38	72.8	3	298	74	553	629	WP_052395479.1 MFS transporter [Kutzneria sp. 744]	diamond	237	52	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Kutzneria	Kutzneria sp. 744
31311299	31311299	PRJNA561138_P_NODE_18075_length_307_cov_1.316239_g17880_i0	PRJNA561138	18075	307	1.316239	4.04085373	Streptomyces	1883	Bacteria	Bacteria	192	6.72e-61	NR	WP_392036314.1	1883	g17880	i0	100	0.996742671009772	102	0	99.7	0	306	1	3	104	WP_392036314.1 MULTISPECIES: hypothetical protein [Streptomyces]	diamond	306	192	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
32007342	32007342	PRJNA561138_P_NODE_17978_length_308_cov_1.208511_g17783_i0	PRJNA561138	17978	308	1.208511	3.72221388	Streptomyces ficellus	1977088	Bacteria	Bacteria	43.9	0.0305	NR	QGV79309.1	1977088	g17783	i0	37.2	0.915584415584416	94	55	89.6	2	299	24	97	188	QGV79309.1 DUF2786 domain-containing protein [Streptomyces ficellus]	diamond	282	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces ficellus
32038992	32038992	PRJNA561138_P_NODE_30098_length_241_cov_0.916667_g29903_i0	PRJNA561138	30098	241	0.916667	2.20916747	Ilumatobacter fluminis	467091	Bacteria	Bacteria	154	3.9e-42	NR	WP_243839136.1	467091	g29903	i0	100	1.96680497925311	79	0	98.3	0	3	239	100	178	WP_243839136.1 proteasome ATPase [Ilumatobacter fluminis]	diamond	474	154	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae	Ilumatobacter	Ilumatobacter fluminis
32134002	32134002	PRJNA561138_P_NODE_26958_length_247_cov_0.885057_g26763_i0	PRJNA561138	26958	247	0.885057	2.18609079	Streptomyces sp. ms191	1827978	Bacteria	Bacteria	43.5	0.0188	NR	TXS09982.1	1827978	g26763	i0	50	0.631578947368421	52	24	63.2	1	82	237	107	156	TXS09982.1 hypothetical protein EAO71_36615, partial [Streptomyces sp. ms191]	diamond	156	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. ms191
32197227	32197227	PRJNA561138_P_NODE_25758_length_249_cov_0.875000_g25563_i0	PRJNA561138	25758	249	0.875	2.17875	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	157	1.9699999999999998e-42	NR	MFQ5555457.1	2080302	g25563	i0	84	9.79518072289157	81	13	97.6	0	2	244	519	599	MFQ5555457.1 2-oxoacid:acceptor oxidoreductase family protein [Acidimicrobiia bacterium]	diamond	2439	157	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
32639483	32639483	PRJNA561138_P_NODE_11720_length_379_cov_1.006536_g11525_i0	PRJNA561138	11720	379	1.006536	3.81477144	Ilumatobacter fluminis	467091	Bacteria	Bacteria	206	3.08e-65	NR	WP_133869404.1	467091	g11525	i0	99	0.767810026385224	97	1	76.8	0	292	2	1	97	WP_133869404.1 HAD family hydrolase [Ilumatobacter fluminis]	diamond	291	206	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae	Ilumatobacter	Ilumatobacter fluminis
32860145	32860145	PRJNA561138_P_NODE_12220_length_372_cov_1.287625_g12025_i0	PRJNA561138	12220	372	1.287625	4.789965	Dactylosporangium sp. NPDC	60453	Bacteria	Bacteria	79.3	1.1e-14	NR	WP_360378265.1	3155647	g12025	i0	72.5	0.814516129032258	51	14	41.1	0	219	371	1	51	WP_360378265.1 NAD(P)-dependent alcohol dehydrogenase [Dactylosporangium sp. NPDC049140]	diamond	303	79.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium sp. NPDC049140

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