metadata: contig_metadata: 29 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax

29 rows where analysis = "diamond", bioproject = "PRJEB7799" 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
25662855	25662855	PRJEB7799d_S_NODE_5346_length_172_cov_1.635036_g5336_i0	PRJEB7799	5346	172	1.635036	2.81226192	Micromonospora deserti	2070366	Bacteria	Bacteria	117	5.23e-32	NR	WP_146604124.1	2070366	g5336	i0	93	2.98255813953488	57	4	99.4	0	171	1	17	73	WP_146604124.1 6-pyruvoyl trahydropterin synthase family protein, partial [Micromonospora deserti]	diamond	513	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora deserti
25753241	25753241	PRJEB7799i_S_NODE_9386_length_163_cov_3.156250_g9356_i0	PRJEB7799	9386	163	3.15625	5.1446875	Bacteria	2	Bacteria	Bacteria	102	2.56e-26	NR	MCW2858282.1	1909296	g9356	i0	94.2	8.66871165644172	52	3	95.7	0	163	8	67	118	MCW2858282.1 family transposase [Marmoricola sp.]	diamond	1413	102	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Marmoricola	Marmoricola sp.
32913489	32913489	PRJEB7799n_S_NODE_4241_length_223_cov_2.670213_g4204_i0	PRJEB7799	4241	223	2.670213	5.95457499	unclassified Streptomyces	2593676	Bacteria	Bacteria	42.7	0.0288	NR	WP_398017753.1	2593676	g4204	i0	45.7	0.618834080717489	46	22	61.9	1	22	159	132	174	WP_398017753.1 MULTISPECIES: IS110 family transposase [unclassified Streptomyces]	diamond	138	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
32930848	32930848	PRJEB7799p_S_NODE_19161_length_166_cov_10.709924_g19138_i0	PRJEB7799	19161	166	10.709924000000001	17.77847384	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	40.8	0.0402	NR	WP_403514069.1	3366045	g19138	i0	56.1	0.740963855421687	41	15	68.7	1	6	119	87	127	WP_403514069.1 hypothetical protein [Streptomyces sp. NPDC093595]	diamond	123	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC093595
32940453	32940453	PRJEB7799n_S_NODE_7345_length_181_cov_5.582192_g7308_i0	PRJEB7799	7345	181	5.582192	10.10376752	Bacteria	2	Bacteria	Bacteria	84.7	8.27e-18	NR	WP_334666726.1	66883	g7308	i0	97.8	11.4198895027624	46	1	76.2	0	180	43	184	229	WP_334666726.1 Hsp70 family protein, partial [Streptomyces cyaneofuscatus]	diamond	2067	84.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces cyaneofuscatus
32948101	32948101	PRJEB7799p_S_NODE_24602_length_154_cov_1.840336_g24579_i0	PRJEB7799	24602	154	1.840336	2.83411744	Streptomyces sp. CNS654	1506995	Bacteria	Bacteria	58.5	2.97e-8	NR	WP_050486703.1	1506995	g24579	i0	61.2	1.90909090909091	49	19	95.5	0	153	7	1202	1250	WP_050486703.1 SDR family NAD(P)-dependent oxidoreductase [Streptomyces sp. CNS654]	diamond	294	58.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CNS654
32964267	32964267	PRJEB7799a_S_NODE_4402_length_233_cov_5.449495_g4367_i0	PRJEB7799	4402	233	5.449495	12.69732335	Sinosporangium album	504805	Bacteria	Bacteria	42.4	0.0459	NR	WP_093171417.1	504805	g4367	i0	37.9	0.849785407725322	66	39	85	1	232	35	465	528	WP_093171417.1 S8 family serine peptidase [Sinosporangium album]	diamond	198	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Sinosporangium	Sinosporangium album
32974627	32974627	PRJEB7799a_S_NODE_14154_length_167_cov_3.939394_g14119_i0	PRJEB7799	14154	167	3.939394	6.57878798	Bacillati	1783272	Bacteria	Bacteria	42	0.0255	NR	WP_246277784.1	1076125	g14119	i0	53.8	3.52095808383234	39	13	70.1	1	118	2	80	113	WP_246277784.1 type I polyketide synthase [Phytohabitans rumicis]	diamond	588	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Phytohabitans	Phytohabitans rumicis
32982414	32982414	PRJEB7799p_S_NODE_7267_length_208_cov_6.843931_g7244_i0	PRJEB7799	7267	208	6.843931	14.23537648	Baekduia sp.	2600305	Bacteria	Bacteria	42.4	0.0326	NR	MDX6730041.1	2600305	g7244	i0	45.6	0.822115384615385	57	21	72.1	2	23	172	429	482	MDX6730041.1 hypothetical protein [Baekduia sp.]	diamond	171	42.4	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Baekduiaceae	Baekduia	Baekduia sp.
32999104	32999104	PRJEB7799o_S_NODE_1595_length_200_cov_2.181818_g1587_i0	PRJEB7799	1595	200	2.181818	4.363636	Rhodococcus gannanensis	1960308	Bacteria	Bacteria	43.1	0.0152	NR	WP_378486398.1	1960308	g1587	i0	50	0.69	46	21	66	1	68	199	260	305	WP_378486398.1 M24 family metallopeptidase [Rhodococcus gannanensis]	diamond	138	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus gannanensis
33015205	33015205	PRJEB7799a_S_NODE_12188_length_174_cov_3.151079_g12153_i0	PRJEB7799	12188	174	3.151079	5.48287746	Actinomycetota bacterium	2900548	Bacteria	Bacteria	47.8	2.56e-4	NR	HEU4398904.1	2900548	g12153	i0	71.9	0.551724137931034	32	9	55.2	0	40	135	372	403	HEU4398904.1 peroxidase [Actinomycetota bacterium]	diamond	96	47.8	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
33042825	33042825	PRJEB7799i_S_NODE_6476_length_190_cov_1.767742_g6446_i0	PRJEB7799	6476	190	1.767742	3.3587098	Actinomycetota	201174	Bacteria	Bacteria	45.1	0.00293	NR	WP_262841363.1	1441875	g6446	i0	40.4	2.58947368421053	52	30	80.5	1	172	20	1128	1179	WP_262841363.1 RHS repeat-associated core domain-containing protein [Sphaerisporangium corydalis]	diamond	492	45.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Sphaerisporangium	Sphaerisporangium corydalis
33049728	33049728	PRJEB7799i_S_NODE_3717_length_237_cov_3.569307_g3687_i0	PRJEB7799	3717	237	3.569307	8.45925759	Nocardia niigatensis	209249	Bacteria	Bacteria	42.4	0.0406	NR	WP_063711131.1	209249	g3687	i0	45.2	0.531645569620253	42	23	53.2	0	206	81	186	227	WP_063711131.1 TetR/AcrR family transcriptional regulator [Nocardia niigatensis]	diamond	126	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia niigatensis
33059831	33059831	PRJEB7799i_S_NODE_3893_length_233_cov_1.858586_g3863_i0	PRJEB7799	3893	233	1.858586	4.33050538	Bacteria	2	Bacteria	Bacteria	64.3	8.26e-10	NR	WP_082087682.1	1263625	g3863	i0	43.4	3.50214592274678	76	38	91.4	2	6	218	130	205	WP_082087682.1 DEAD/DEAH box helicase [Microbacterium sp. SA39]	diamond	816	64.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. SA39
33059901	33059901	PRJEB7799p_S_NODE_5853_length_222_cov_10.294118_g5830_i0	PRJEB7799	5853	222	10.294118	22.85294196	Bacteria	2	Bacteria	Bacteria	142	3.22e-40	NR	HMS72338.1	2600305	g5830	i0	95.9	2	74	3	100	0	1	222	1	74	HMS72338.1 sigma-70 family RNA polymerase sigma factor [Baekduia sp.]	diamond	444	142	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Baekduiaceae	Baekduia	Baekduia sp.
33066768	33066768	PRJEB7799i_S_NODE_3925_length_232_cov_1.994924_g3895_i0	PRJEB7799	3925	232	1.994924	4.62822368	Actinomycetota bacterium	2900548	Bacteria	Bacteria	103	1.64e-26	NR	NDF24014.1	2900548	g3895	i0	93.1	1.5	58	4	75	0	204	31	1	58	NDF24014.1 hypothetical protein [Actinomycetota bacterium]	diamond	348	103	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
33093984	33093984	PRJEB7799a_S_NODE_15110_length_164_cov_1.449612_g15075_i0	PRJEB7799	15110	164	1.449612	2.37736368	Bacteria	2	Bacteria	Bacteria	58.9	2.39e-8	NR	WP_083371052.1	199592	g15075	i0	54.2	5.21341463414634	48	22	87.8	0	2	145	285	332	WP_083371052.1 glycosyltransferase family protein [Microbacterium paraoxydans]	diamond	855	59.3	0.993254637436762	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium paraoxydans
33100847	33100847	PRJEB7799i_S_NODE_1230_length_414_cov_3.791557_g1200_i0	PRJEB7799	1230	414	3.791557	15.69704598	Longispora fulva	619741	Bacteria	Bacteria	45.8	0.0195	NR	WP_203787600.1	619741	g1200	i0	50	0.304347826086957	42	21	30.4	0	404	279	506	547	WP_203787600.1 tetratricopeptide repeat protein [Longispora fulva]	diamond	126	45.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Longispora	Longispora fulva
33117654	33117654	PRJEB7799a_S_NODE_4743_length_228_cov_4.129534_g4708_i0	PRJEB7799	4743	228	4.129534	9.41533752	Corynebacterium sp. P3-F1	3059080	Bacteria	Bacteria	42.4	0.0428	NR	WP_302007808.1	3059080	g4708	i0	39.6	0.631578947368421	48	29	63.2	0	16	159	395	442	WP_302007808.1 FtsW/RodA/SpoVE family cell cycle protein [Corynebacterium sp. P3-F1]	diamond	144	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. P3-F1
33117672	33117672	PRJEB7799a_S_NODE_647_length_429_cov_7.824873_g612_i0	PRJEB7799	647	429	7.824873	33.56870517	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	45.1	0.0408	NR	MDH3302797.1	2080302	g612	i0	43.9	0.398601398601399	57	32	39.9	0	140	310	958	1014	MDH3302797.1 carbamoyl-phosphate synthase large subunit [Acidimicrobiia bacterium]	diamond	171	45.1	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
33118521	33118521	PRJEB7799o_S_NODE_2303_length_182_cov_3.659864_g2295_i0	PRJEB7799	2303	182	3.659864	6.66095248	Mycobacterium avium	1764	Bacteria	Bacteria	39.7	0.0448	NR	WP_342314589.1	1764	g2295	i0	40.9	0.725274725274725	44	26	72.5	0	44	175	19	62	WP_342314589.1 hypothetical protein [Mycobacterium avium]	diamond	132	39.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium avium
33118524	33118524	PRJEB7799o_S_NODE_3207_length_169_cov_2.686567_g3199_i0	PRJEB7799	3207	169	2.686567	4.54029823	Adlercreutzia equolifaciens	446660	Bacteria	Bacteria	47.4	2.21e-5	NR	GJC77151.1	446660	g3199	i0	55.3	0.674556213017751	38	17	67.5	0	152	39	4	41	GJC77151.1 hypothetical protein Aeq9CBH6_24860 [Adlercreutzia equolifaciens]	diamond	114	47.4	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Eggerthellales	Eggerthellaceae	Adlercreutzia	Adlercreutzia equolifaciens
33134852	33134852	PRJEB7799c_S_NODE_2727_length_233_cov_0.969697_g2704_i0	PRJEB7799	2727	233	0.969697	2.25939401	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	74.7	9.12e-15	NR	MCP3885490.1	2021380	g2704	i0	61.7	0.772532188841202	60	23	77.3	0	232	53	92	151	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	180	74.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
33135781	33135781	PRJEB7799p_S_NODE_5663_length_225_cov_3.400000_g5640_i0	PRJEB7799	5663	225	3.4	7.65	unclassified Streptomyces	2593676	Bacteria	Bacteria	46.6	0.00121	NR	WP_099279182.1	2593676	g5640	i0	44.4	1.88	63	32	81.3	2	32	214	170	231	WP_099279182.1 MULTISPECIES: RICIN domain-containing protein [unclassified Streptomyces]	diamond	423	46.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
33145270	33145270	PRJEB7799p_S_NODE_11143_length_188_cov_1.529412_g11120_i0	PRJEB7799	11143	188	1.529412	2.87529456	Streptomyces	1883	Bacteria	Bacteria	43.5	0.0099	NR	WP_351468492.1	1971	g11120	i0	50	1.34042553191489	42	21	67	0	168	43	6537	6578	WP_351468492.1 SDR family NAD(P)-dependent oxidoreductase [Streptomyces noursei]	diamond	252	43.9	0.990888382687927	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces noursei
33151767	33151767	PRJEB7799a_S_NODE_19632_length_150_cov_9.939130_g19597_i0	PRJEB7799	19632	150	9.93913	14.908695	Streptosporangiaceae bacterium	2339230	Bacteria	Bacteria	41.6	0.0238	NR	HEY7430273.1	2339230	g19597	i0	54.3	1.4	35	15	68	1	110	9	110	144	HEY7430273.1 acetamidase/formamidase family protein [Streptosporangiaceae bacterium]	diamond	210	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae		Streptosporangiaceae bacterium
33151991	33151991	PRJEB7799f_S_NODE_424_length_339_cov_1.802632_g408_i0	PRJEB7799	424	339	1.802632	6.11092248	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	44.7	0.0241	NR	WP_351411637.1	3154401	g408	i0	50	0.353982300884956	40	20	35.4	0	335	216	824	863	WP_351411637.1 tetratricopeptide repeat protein [Streptomyces sp. NPDC001868]	diamond	120	44.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC001868
33168685	33168685	PRJEB7799a_S_NODE_12968_length_171_cov_5.639706_g12933_i0	PRJEB7799	12968	171	5.639706	9.64389726	Naumannella cuiyingiana	1347891	Bacteria	Bacteria	41.6	0.036	NR	WP_179445017.1	1347891	g12933	i0	38.6	0.771929824561403	44	27	77.2	0	33	164	166	209	WP_179445017.1 ATP-dependent DNA ligase [Naumannella cuiyingiana]	diamond	132	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Naumannella	Naumannella cuiyingiana
33179485	33179485	PRJEB7799p_S_NODE_1984_length_321_cov_3.657343_g1961_i0	PRJEB7799	1984	321	3.657343	11.74007103	Bacteria	2	Bacteria	Bacteria	79	2.3e-15	NR	WP_172831408.1	1790	g1961	i0	55.4	2.81308411214953	74	33	69.2	0	252	31	1	74	WP_172831408.1 acetyltransferase [Mycobacterium asiaticum]	diamond	903	79	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium asiaticum

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