metadata: contig_metadata: 33 rows where analysis = "diamond", bioproject = "PRJNA1200128" and tax

33 rows where analysis = "diamond", bioproject = "PRJNA1200128" 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
27514950	27514950	PRJNA1200128_S_NODE_42183_length_159_cov_1.215517_g42074_i0	PRJNA1200128	42183	159	1.215517	1.93267203	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	41.2	0.0405	NR	WP_355359340.1	3154442	g42074	i0	41	0.735849056603774	39	23	73.6	0	35	151	186	224	WP_355359340.1 universal stress protein [Streptomyces sp. NPDC003036]	diamond	117	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC003036
27628758	27628758	PRJNA1200128_S_NODE_12744_length_234_cov_1.418848_g12635_i0	PRJNA1200128	12744	234	1.418848	3.32010432	Bacillati	1783272	Bacteria	Bacteria	106	2.54e-27	NR	PYC99492.1	57043	g12635	i0	76.7	1.87179487179487	73	17	93.6	0	14	232	79	151	PYC99492.1 hypothetical protein B4U78_016815, partial [Microbacterium esteraromaticum]	diamond	438	106	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
28083179	28083179	PRJNA1200128_S_NODE_42045_length_159_cov_1.284483_g41936_i0	PRJNA1200128	42045	159	1.284483	2.04232797	Corynebacterium pseudokroppenstedtii	2804917	Bacteria	Bacteria	41.6	0.0218	NR	WP_337448933.1	2804917	g41936	i0	47.2	1	53	27	98.1	1	2	157	31	83	WP_337448933.1 endonuclease/exonuclease/phosphatase family protein, partial [Corynebacterium pseudokroppenstedtii]	diamond	159	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudokroppenstedtii
28177747	28177747	PRJNA1200128_S_NODE_11046_length_245_cov_0.856436_g10937_i0	PRJNA1200128	11046	245	0.856436	2.0982682	Pseudokineococcus sp. 1T1Z-3	3132745	Bacteria	Bacteria	43.9	0.014	NR	WP_339566650.1	3132745	g10937	i0	40.8	0.869387755102041	71	39	84.5	3	238	32	25	94	WP_339566650.1 hypothetical protein [Pseudokineococcus sp. 1T1Z-3]	diamond	213	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kineosporiales	Kineosporiaceae	Pseudokineococcus	Pseudokineococcus sp. 1T1Z-3
28209410	28209410	PRJNA1200128_S_NODE_34786_length_170_cov_1.196850_g34677_i0	PRJNA1200128	34786	170	1.19685	2.034645	Kitasatospora sp. NPDC	1871188	Bacteria	Bacteria	41.2	0.0318	NR	WP_350793998.1	3154519	g34677	i0	48.6	0.652941176470588	37	14	65.3	1	129	19	63	94	WP_350793998.1 hypothetical protein [Kitasatospora sp. NPDC001527]	diamond	111	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora sp. NPDC001527
28209411	28209411	PRJNA1200128_S_NODE_37806_length_165_cov_1.540984_g37697_i0	PRJNA1200128	37806	165	1.540984	2.5426236	Pseudonocardiaceae bacterium	1873463	Bacteria	Bacteria	41.2	0.0457	NR	MPZ64837.1	1873463	g37697	i0	45.1	0.927272727272727	51	21	92.7	1	8	160	333	376	MPZ64837.1 arabinosyltransferase [Pseudonocardiaceae bacterium]	diamond	153	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae		Pseudonocardiaceae bacterium
28240957	28240957	PRJNA1200128_S_NODE_34246_length_171_cov_1.101562_g34137_i0	PRJNA1200128	34246	171	1.101562	1.88367102	Actinomadura algeriensis	1679523	Bacteria	Bacteria	41.2	0.0489	NR	WP_192763136.1	1679523	g34137	i0	42.5	0.701754385964912	40	22	68.4	1	38	154	13	52	WP_192763136.1 AAA family ATPase [Actinomadura algeriensis]	diamond	120	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura algeriensis
28430705	28430705	PRJNA1200128_S_NODE_34486_length_170_cov_2.960630_g34377_i0	PRJNA1200128	34486	170	2.96063	5.033071	Streptomyces avermitilis	33903	Bacteria	Bacteria	41.2	0.0494	NR	WP_387688296.1	33903	g34377	i0	41.5	0.723529411764706	41	24	72.4	0	27	149	41	81	WP_387688296.1 SagB family peptide dehydrogenase [Streptomyces avermitilis]	diamond	123	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces avermitilis
28557029	28557029	PRJNA1200128_S_NODE_33527_length_172_cov_1.457364_g33418_i0	PRJNA1200128	33527	172	1.457364	2.50666608	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	41.6	0.0191	NR	WP_361906206.1	3155616	g33418	i0	48.7	1.18604651162791	39	13	61	2	56	160	13	48	WP_361906206.1 hypothetical protein [Streptomyces sp. NPDC046876]	diamond	204	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC046876
28967496	28967496	PRJNA1200128_S_NODE_12728_length_234_cov_1.476440_g12619_i0	PRJNA1200128	12728	234	1.47644	3.4548696	unclassified Streptomyces	2593676	Bacteria	Bacteria	45.1	0.00517	NR	WP_362207484.1	2593676	g12619	i0	45	0.935897435897436	40	22	51.3	0	108	227	2007	2046	WP_362207484.1 MULTISPECIES: polymorphic toxin-type HINT domain-containing protein [unclassified Streptomyces]	diamond	219	45.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
28967500	28967500	PRJNA1200128_S_NODE_32548_length_174_cov_1.076336_g32439_i0	PRJNA1200128	32548	174	1.076336	1.87282464	Streptomyces sp.	1931	Bacteria	Bacteria	64.7	1.47e-11	NR	WP_411115477.1	2789261	g32439	i0	71.7	3.13793103448276	46	13	79.3	0	138	1	25	70	WP_411115477.1 hypothetical protein [Streptomyces sp. 029-5]	diamond	546	64.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. 029-5
29282922	29282922	PRJNA1200128_S_NODE_6589_length_288_cov_1.587755_g6480_i0	PRJNA1200128	6589	288	1.587755	4.5727344	Kitasatospora saccharophila	407973	Bacteria	Bacteria	48.5	3.89e-4	NR	WP_380276580.1	407973	g6480	i0	47.2	0.552083333333333	53	22	49	3	7	147	38	90	WP_380276580.1 haloacid dehalogenase-like hydrolase [Kitasatospora saccharophila]	diamond	159	48.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora saccharophila
29504010	29504010	PRJNA1200128_S_NODE_15070_length_222_cov_1.351955_g14961_i0	PRJNA1200128	15070	222	1.351955	3.0013401	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	42.7	0.0214	NR	WP_385709974.1	3346891	g14961	i0	50	0.567567567567568	42	21	56.8	0	36	161	50	91	WP_385709974.1 TetR/AcrR family transcriptional regulator [Streptomyces sp. NPDC059639]	diamond	126	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC059639
29567126	29567126	PRJNA1200128_S_NODE_7410_length_278_cov_1.600000_g7301_i0	PRJNA1200128	7410	278	1.6	4.448	Microlunatus sp.	39595	Bacteria	Bacteria	44.3	0.0155	NR	HEU4545390.1	39595	g7301	i0	32.4	0.798561151079137	74	40	69.1	2	3	194	77	150	HEU4545390.1 MFS transporter [Microlunatus sp.]	diamond	222	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sp.
29788108	29788108	PRJNA1200128_S_NODE_32231_length_174_cov_3.503817_g32122_i0	PRJNA1200128	32231	174	3.503817	6.09664158	Streptomyces sp. HC3	1931	Bacteria	Bacteria	40.8	0.0415	NR	WP_409467246.1	3385496	g32122	i0	42.6	0.810344827586207	47	24	81	1	3	143	87	130	WP_409467246.1 hypothetical protein [Streptomyces sp. HC307]	diamond	141	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces flavusporus
29819629	29819629	PRJNA1200128_S_NODE_9671_length_255_cov_2.584906_g9562_i0	PRJNA1200128	9671	255	2.584906	6.5915103	Streptomyces albidus (ex Kaewkla and Franco 2	722709	Bacteria	Bacteria	43.5	0.0228	NR	WP_181764711.1	722709	g9562	i0	33.3	0.952941176470588	81	43	82.4	3	21	230	136	216	WP_181764711.1 DUF5107 domain-containing protein [Streptomyces albidus (ex Kaewkla and Franco 2022)]	diamond	243	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albidus (ex Kaewkla and Franco 2022)
29838646	29838646	PRJNA1200128_S_NODE_32291_length_174_cov_2.511450_g32182_i0	PRJNA1200128	32291	174	2.51145	4.369923	Nocardiopsis	2013	Bacteria	Bacteria	43.1	0.0106	NR	WP_017600072.1	53441	g32182	i0	41.5	1.82758620689655	53	31	91.4	0	4	162	143	195	WP_017600072.1 M48 family metalloprotease, partial [Nocardiopsis lucentensis]	diamond	318	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis lucentensis
29851566	29851566	PRJNA1200128_S_NODE_16271_length_217_cov_1.080460_g16162_i0	PRJNA1200128	16271	217	1.08046	2.3445982	Cutibacterium acnes	1747	Bacteria	Bacteria	43.5	0.00921	NR	MES6385480.1	1747	g16162	i0	43.9	0.788018433179724	57	29	74.7	2	32	193	23	79	MES6385480.1 hypothetical protein [Cutibacterium acnes]	diamond	171	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
30483378	30483378	PRJNA1200128_S_NODE_8493_length_266_cov_2.950673_g8384_i0	PRJNA1200128	8493	266	2.950673	7.84879018	Corynebacterium diphtheriae	1717	Bacteria	Bacteria	44.3	0.0133	NR	WP_241807322.1	1717	g8384	i0	38.2	1.2406015037594	55	34	62	0	83	247	13	67	WP_241807322.1 FAD/NAD(P)-binding protein [Corynebacterium diphtheriae]	diamond	330	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium diphtheriae
30514890	30514890	PRJNA1200128_S_NODE_48353_length_151_cov_2.425926_g48244_i0	PRJNA1200128	48353	151	2.425926	3.66314826	Mycobacteriales bacterium	1957017	Bacteria	Bacteria	41.2	0.0361	NR	HVU73321.1	1957017	g48244	i0	48.4	0.615894039735099	31	16	61.6	0	36	128	204	234	HVU73321.1 glycosyltransferase family 2 protein [Mycobacteriales bacterium]	diamond	93	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales			Mycobacteriales bacterium
30533729	30533729	PRJNA1200128_S_NODE_15253_length_221_cov_1.584270_g15144_i0	PRJNA1200128	15253	221	1.58427	3.5012367	Bacillati	1783272	Bacteria	Bacteria	159	2.12e-46	NR	PYC99595.1	57043	g15144	i0	100	1.98190045248869	73	0	99.1	0	2	220	44	116	PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum]	diamond	438	159	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
30799134	30799134	PRJNA1200128_S_NODE_15194_length_221_cov_2.601124_g15085_i0	PRJNA1200128	15194	221	2.601124	5.74848404	Streptosporangiaceae bacterium	2339230	Bacteria	Bacteria	42	0.0298	NR	HUZ53221.1	2339230	g15085	i0	45.7	0.624434389140271	46	25	62.4	0	68	205	76	121	HUZ53221.1 DUF6703 family protein [Streptosporangiaceae bacterium]	diamond	138	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae		Streptosporangiaceae bacterium
30925891	30925891	PRJNA1200128_S_NODE_7414_length_278_cov_1.400000_g7305_i0	PRJNA1200128	7414	278	1.4	3.892	Lawsonella	1847725	Bacteria	Bacteria	89.7	5.99e-19	NR	WP_290599182.1	1847725	g7305	i0	97.7	0.464028776978417	43	1	46.4	0	276	148	295	337	WP_290599182.1 MULTISPECIES: metal ABC transporter solute-binding protein, Zn/Mn family [Lawsonella]	diamond	129	89.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
31039624	31039624	PRJNA1200128_S_NODE_25855_length_188_cov_0.675862_g25746_i0	PRJNA1200128	25855	188	0.675862	1.27062056	root	1	Root_unresolved	Root_unresolved	41.6	0.0417	NR	WP_066463791.1	60921	g25746	i0	40.8	1.38829787234043	49	27	78.2	1	10	156	36	82	WP_066463791.1 class I SAM-dependent methyltransferase [Sanguibacter suarezii]	diamond	261	42	0.990476190476191	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Sanguibacteraceae	Sanguibacter	Sanguibacter suarezii
31052296	31052296	PRJNA1200128_S_NODE_10835_length_246_cov_2.408867_g10726_i0	PRJNA1200128	10835	246	2.408867	5.92581282	Brevibacterium aurantiacum	273384	Bacteria	Bacteria	43.5	0.0166	NR	SMX72075.1	273384	g10726	i0	35.1	1.39024390243902	57	36	68.3	1	77	244	77	133	SMX72075.1 hypothetical protein BAURA86_00385 [Brevibacterium aurantiacum]	diamond	342	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium aurantiacum
31716085	31716085	PRJNA1200128_S_NODE_7057_length_282_cov_2.041841_g6948_i0	PRJNA1200128	7057	282	2.041841	5.75799162	Streptomyces cellulosae	1968	Bacteria	Bacteria	42.7	0.0195	NR	WP_030665478.1	1968	g6948	i0	36.3	0.851063829787234	80	44	85.1	2	37	276	14	86	WP_030665478.1 DUF952 domain-containing protein [Streptomyces cellulosae]	diamond	240	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces cellulosae
31874186	31874186	PRJNA1200128_S_NODE_7577_length_276_cov_1.759657_g7468_i0	PRJNA1200128	7577	276	1.759657	4.85665332	Streptomyces incarnatus	665007	Bacteria	Bacteria	42.7	0.0402	NR	WP_244189165.1	665007	g7468	i0	41.7	0.782608695652174	72	34	73.9	4	40	243	97	164	WP_244189165.1 lamin tail domain-containing protein [Streptomyces incarnatus]	diamond	216	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces incarnatus
31987993	31987993	PRJNA1200128_S_NODE_7698_length_274_cov_42.649351_g7589_i0	PRJNA1200128	7698	274	42.649351	116.85922174	Streptomyces	1883	Bacteria	Bacteria	43.1	0.0332	NR	WP_362359711.1	1048205	g7589	i0	41.5	0.897810218978102	41	24	44.9	0	95	217	129	169	WP_362359711.1 DNA polymerase ligase N-terminal domain-containing protein [Streptomyces uncialis]	diamond	246	43.5	0.990804597701149	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces uncialis
32190728	32190728	PRJNA1200128_S_NODE_11578_length_241_cov_2.095960_g11469_i0	PRJNA1200128	11578	241	2.09596	5.0512636	Streptomyces tanashiensis	67367	Bacteria	Bacteria	43.5	0.00902	NR	WP_361734467.1	67367	g11469	i0	40.5	0.921161825726141	74	33	79.7	4	47	238	1	73	WP_361734467.1 hypothetical protein [Streptomyces tanashiensis]	diamond	222	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces tanashiensis
32273045	32273045	PRJNA1200128_S_NODE_5918_length_298_cov_2.258824_g5809_i0	PRJNA1200128	5918	298	2.258824	6.73129552	Bacillati	1783272	Bacteria	Bacteria	60.1	2.13e-9	NR	PYC99602.1	57043	g5809	i0	46.3	1.3489932885906	67	36	67.4	0	59	259	19	85	PYC99602.1 hypothetical protein B4U78_015825 [Microbacterium esteraromaticum]	diamond	402	60.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
32380594	32380594	PRJNA1200128_S_NODE_40439_length_161_cov_1.593220_g40330_i0	PRJNA1200128	40439	161	1.59322	2.5650842	Microbacterium esteraromaticum	57043	Bacteria	Bacteria	70.5	1.68e-13	NR	PYC99516.1	57043	g40330	i0	65.4	0.968944099378882	52	18	96.9	0	158	3	97	148	PYC99516.1 NgoFVII family restriction endonuclease [Microbacterium esteraromaticum]	diamond	156	70.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
32790505	32790505	PRJNA1200128_S_NODE_37200_length_166_cov_1.357724_g37091_i0	PRJNA1200128	37200	166	1.357724	2.25382184	Cutibacterium acnes	1747	Bacteria	Bacteria	46.6	3.4e-4	NR	MES9148562.1	1747	g37091	i0	70.6	1.28313253012048	34	9	59.6	1	3	101	68	101	MES9148562.1 reverse transcriptase family protein [Cutibacterium acnes]	diamond	213	46.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
32853615	32853615	PRJNA1200128_S_NODE_19940_length_204_cov_1.341615_g19831_i0	PRJNA1200128	19940	204	1.341615	2.7368946	Streptomyces niveus	193462	Bacteria	Bacteria	43.1	0.0161	NR	WP_401927724.1	193462	g19831	i0	41	0.897058823529412	61	32	83.8	2	176	6	54	114	WP_401927724.1 hypothetical protein [Streptomyces niveus]	diamond	183	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces niveus

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