metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA1193541" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA1193541" 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
1595437	1595437	PRJNA1193541_P_NODE_9082_length_289_cov_1.236111_g8944_i0	PRJNA1193541	9082	289	1.236111	3.57236079	Nocardioides sp.	35761	Bacteria	Bacteria	115	2.2599999999999996e-31	NR	HSU03064.1	35761	g8944	i0	79.1	0.892733564013841	86	17	88.2	1	288	34	9	94	HSU03064.1 hypothetical protein [Nocardioides sp.]	diamond	258	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp.
2871368	2871368	PRJNA1193541_P_NODE_12903_length_249_cov_0.875000_g12765_i0	PRJNA1193541	12903	249	0.875	2.17875	Microbacterium sp.	51671	Bacteria	Bacteria	141	5.3399999999999997e-39	NR	WP_287271212.1	51671	g12765	i0	97.3	0.903614457831325	75	2	90.4	0	23	247	1	75	WP_287271212.1 SDR family oxidoreductase [Microbacterium sp.]	diamond	225	141	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp.
6698448	6698448	PRJNA1193541_P_NODE_13146_length_248_cov_0.880000_g13008_i0	PRJNA1193541	13146	248	0.88	2.1824	Micrococcales	85006	Bacteria	Bacteria	76.3	3.16e-16	NR	WP_144589453.1	85006	g13008	i0	86.4	0.532258064516129	44	6	53.2	0	248	117	25	68	WP_144589453.1 MULTISPECIES: heavy-metal-associated domain-containing protein [Micrococcales]	diamond	132	76.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales
18172405	18172405	PRJNA1193541_P_NODE_9315_length_286_cov_1.774648_g9177_i0	PRJNA1193541	9315	286	1.774648	5.07549328	Arthrobacter russicus	172040	Bacteria	Bacteria	136	4.5399999999999994e-35	NR	WP_309798714.1	172040	g9177	i0	100	0.723776223776224	69	0	72.4	0	3	209	606	674	WP_309798714.1 MFS transporter [Arthrobacter russicus]	diamond	207	136	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter russicus
20722148	20722148	PRJNA1193541_P_NODE_9357_length_286_cov_1.183099_g9219_i0	PRJNA1193541	9357	286	1.183099	3.38366314	Streptomyces benahoarensis	2595054	Bacteria	Bacteria	164	1.7099999999999998e-48	NR	TSB06748.1	2595054	g9219	i0	98.9	1.97202797202797	94	1	98.6	0	3	284	55	148	TSB06748.1 flagellin, partial [Streptomyces benahoarensis]	diamond	564	164	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces benahoarensis
26648066	26648066	PRJNA1193541_P_NODE_8301_length_303_cov_1.039130_g8163_i0	PRJNA1193541	8301	303	1.03913	3.1485639	Bacteria	2	Bacteria	Bacteria	197	6.680000000000001e-63	NR	WP_316316563.1	28447	g8163	i0	99	3.96039603960396	100	1	99	0	302	3	41	140	WP_316316563.1 hypothetical protein, partial [Clavibacter michiganensis]	diamond	1200	197	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis
27198572	27198572	PRJNA1193541_P_NODE_13722_length_246_cov_0.890173_g13584_i0	PRJNA1193541	13722	246	0.890173	2.18982558	Acidimicrobiaceae bacterium	2024894	Bacteria	Bacteria	43.9	0.0144	NR	MDQ1445562.1	2024894	g13584	i0	34.2	0.963414634146341	79	43	90.2	3	8	229	165	239	MDQ1445562.1 hypothetical protein [Acidimicrobiaceae bacterium]	diamond	237	43.9	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Acidimicrobiaceae		Acidimicrobiaceae bacterium
27356988	27356988	PRJNA1193541_P_NODE_10983_length_266_cov_1.383420_g10845_i0	PRJNA1193541	10983	266	1.38342	3.6798972	uncultured Williamsia sp.	259311	Bacteria	Bacteria	159	1.13e-46	NR	WP_299575155.1	259311	g10845	i0	96.6	0.992481203007519	88	3	99.2	0	264	1	67	154	WP_299575155.1 hypothetical protein [uncultured Williamsia sp.]	diamond	264	159	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	uncultured Williamsia sp.
27483177	27483177	PRJNA1193541_P_NODE_11703_length_256_cov_0.907104_g11565_i0	PRJNA1193541	11703	256	0.907104	2.32218624	Streptomyces bobili	67280	Bacteria	Bacteria	41.2	0.0298	NR	MEV4230570.1	67280	g11565	i0	42.1	0.890625	76	34	80.9	3	30	236	13	85	MEV4230570.1 protein kinase [Streptomyces bobili]	diamond	228	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces bobili
27641226	27641226	PRJNA1193541_P_NODE_12544_length_250_cov_0.870056_g12406_i0	PRJNA1193541	12544	250	0.870056	2.17514	Cutibacterium acnes	1747	Bacteria	Bacteria	144	3.87e-41	NR	MES6530788.1	1747	g12406	i0	100	1.608	67	0	80.4	0	202	2	1	67	MES6530788.1 helix-turn-helix domain-containing protein [Cutibacterium acnes]	diamond	402	144	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
27988395	27988395	PRJNA1193541_P_NODE_13925_length_245_cov_0.895349_g13787_i0	PRJNA1193541	13925	245	0.895349	2.19360505	Streptomyces zhihengii	1818004	Bacteria	Bacteria	45.8	0.00288	NR	MFD0431479.1	1818004	g13787	i0	42.3	1.2734693877551	52	25	62.4	2	16	168	121	168	MFD0431479.1 hypothetical protein [Streptomyces zhihengii]	diamond	312	45.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces zhihengii
28777583	28777583	PRJNA1193541_P_NODE_6667_length_336_cov_1.171103_g6529_i0	PRJNA1193541	6667	336	1.171103	3.93490608	Kocuria rosea	1275	Bacteria	Bacteria	164	1.09e-49	NR	WP_323661510.1	1275	g6529	i0	100	0.785714285714286	88	0	78.6	0	71	334	1	88	WP_323661510.1 hypothetical protein, partial [Kocuria rosea]	diamond	264	164	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rosea
29062009	29062009	PRJNA1193541_P_NODE_12688_length_249_cov_0.875000_g12550_i0	PRJNA1193541	12688	249	0.875	2.17875	Candidatus Nanopelagicales bacterium	2518612	Bacteria	Bacteria	140	3.83e-38	NR	MCU0301509.1	2518612	g12550	i0	87.8	0.987951807228916	82	10	98.8	0	3	248	102	183	MCU0301509.1 signal recognition particle-docking protein FtsY [Candidatus Nanopelagicales bacterium]	diamond	246	140	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales			Candidatus Nanopelagicales bacterium
29062010	29062010	PRJNA1193541_P_NODE_13048_length_248_cov_0.880000_g12910_i0	PRJNA1193541	13048	248	0.88	2.1824	Corynebacterium amycolatum	43765	Bacteria	Bacteria	160	1.58e-44	NR	WP_284805957.1	43765	g12910	i0	96.3	0.991935483870968	82	3	99.2	0	1	246	274	355	WP_284805957.1 DUF7373 family lipoprotein [Corynebacterium amycolatum]	diamond	246	160	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium amycolatum
29238859	29238859	PRJNA1193541_P_NODE_14909_length_242_cov_0.911243_g14771_i0	PRJNA1193541	14909	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	117	4.41e-31	NR	WP_043602627.1	1386092	g14771	i0	75	5.44214876033058	72	18	89.3	0	21	236	90	161	WP_043602627.1 GNAT family N-acetyltransferase [Cellulomonas carbonis]	diamond	1317	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas carbonis
29377597	29377597	PRJNA1193541_P_NODE_14089_length_244_cov_1.619883_g13951_i0	PRJNA1193541	14089	244	1.619883	3.95251452	Micrococcus endophyticus	455343	Bacteria	Bacteria	160	8.149999999999998e-48	NR	WP_248193540.1	455343	g13951	i0	98.8	0.995901639344262	81	1	99.6	0	244	2	113	193	WP_248193540.1 DsbA family protein [Micrococcus endophyticus]	diamond	243	160	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus endophyticus
29819440	29819440	PRJNA1193541_P_NODE_9971_length_279_cov_1.315534_g9833_i0	PRJNA1193541	9971	279	1.315534	3.67033986	Streptomyces parvulus	146923	Bacteria	Bacteria	58.5	1.37e-7	NR	WP_360014455.1	146923	g9833	i0	42.9	3.61290322580645	84	40	90.3	2	2	253	134	209	WP_360014455.1 amidohydrolase family protein [Streptomyces parvulus]	diamond	1008	58.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces parvulus
30166989	30166989	PRJNA1193541_P_NODE_13272_length_247_cov_0.885057_g13134_i0	PRJNA1193541	13272	247	0.885057	2.18609079	Amycolatopsis	1813	Bacteria	Bacteria	43.1	0.00358	NR	WP_067584873.1	1813	g13134	i0	38	0.607287449392713	50	29	58.3	1	245	102	9	58	WP_067584873.1 MULTISPECIES: hypothetical protein [Amycolatopsis]	diamond	150	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis
31177927	31177927	PRJNA1193541_P_NODE_15095_length_241_cov_0.916667_g14957_i0	PRJNA1193541	15095	241	0.916667	2.20916747	Williamsia serinedens	391736	Bacteria	Bacteria	159	7.139999999999999e-47	NR	WP_253652929.1	391736	g14957	i0	95	1.99170124481328	80	4	99.6	0	1	240	23	102	WP_253652929.1 dienelactone hydrolase family protein [Williamsia serinedens]	diamond	480	159	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	Williamsia serinedens
31241298	31241298	PRJNA1193541_P_NODE_10315_length_275_cov_0.881188_g10177_i0	PRJNA1193541	10315	275	0.881188	2.423267	Piscicoccus intestinalis	746033	Bacteria	Bacteria	45.8	0.00417	NR	WP_068430052.1	746033	g10177	i0	46.3	0.447272727272727	41	22	44.7	0	36	158	205	245	WP_068430052.1 universal stress protein [Piscicoccus intestinalis]	diamond	123	45.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae	Piscicoccus	Piscicoccus intestinalis
31557947	31557947	PRJNA1193541_P_NODE_11496_length_259_cov_0.827957_g11358_i0	PRJNA1193541	11496	259	0.827957	2.14440863	Microbacterium hydrocarbonoxydans	273678	Bacteria	Bacteria	43.9	0.00919	NR	WP_067353876.1	273678	g11358	i0	38.5	0.752895752895753	65	35	73	2	38	226	86	147	WP_067353876.1 hypothetical protein [Microbacterium hydrocarbonoxydans]	diamond	195	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium hydrocarbonoxydans
31715876	31715876	PRJNA1193541_P_NODE_13217_length_247_cov_1.568966_g13079_i0	PRJNA1193541	13217	247	1.568966	3.87534602	Kocuria rhizophila	72000	Bacteria	Bacteria	42.7	0.0066	NR	WHF22087.1	72000	g13079	i0	60	0.364372469635628	30	11	35.2	1	56	142	16	45	WHF22087.1 hypothetical protein QJS66_18350 [Kocuria rhizophila]	diamond	90	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
32127367	32127367	PRJNA1193541_P_NODE_11958_length_252_cov_1.005587_g11820_i0	PRJNA1193541	11958	252	1.005587	2.53407924	Nocardioides sp.	35761	Bacteria	Bacteria	112	2.4199999999999998e-27	NR	WP_296602529.1	35761	g11820	i0	90.6	0.761904761904762	64	6	76.2	0	60	251	1	64	WP_296602529.1 hypothetical protein [Nocardioides sp.]	diamond	192	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp.
32178012	32178012	PRJNA1193541_P_NODE_9658_length_283_cov_1.076190_g9520_i0	PRJNA1193541	9658	283	1.07619	3.0456177	Actinomycetes	1760	Bacteria	Bacteria	43.9	0.0237	NR	WP_285757755.1	1670832	g9520	i0	30	2.03533568904594	100	57	94.3	2	1	267	325	422	WP_285757755.1 dolichyl-phosphate-mannose--protein mannosyltransferase [Nocardiopsis ansamitocini]	diamond	576	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis ansamitocini
32222102	32222102	PRJNA1193541_P_NODE_12078_length_251_cov_0.865169_g11940_i0	PRJNA1193541	12078	251	0.865169	2.17157419	Micrococcus	1269	Bacteria	Bacteria	71.2	1.26e-12	NR	WP_258299975.1	1269	g11940	i0	72.1	0.51394422310757	43	12	51.4	0	131	3	40	82	WP_258299975.1 MULTISPECIES: hypothetical protein [Micrococcus]	diamond	129	71.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus
32443861	32443861	PRJNA1193541_P_NODE_13699_length_246_cov_0.890173_g13561_i0	PRJNA1193541	13699	246	0.890173	2.18982558	Lawsonella	1847725	Bacteria	Bacteria	88.6	1.46e-18	NR	WP_290598470.1	1847725	g13561	i0	100	0.5	41	0	50	0	1	123	328	368	WP_290598470.1 MULTISPECIES: endonuclease/exonuclease/phosphatase family protein [Lawsonella]	diamond	123	88.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella

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