metadata: contig_metadata: 34 rows where analysis = "diamond", bioproject = "PRJNA675638" and tax

34 rows where analysis = "diamond", bioproject = "PRJNA675638" 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
19775336	19775336	PRJNA675638_P_NODE_10076_length_221_cov_0.889535_g9879_i0	PRJNA675638	10076	221	0.889535	1.96587235	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	138	4.78e-36	NR	WP_306516796.1	2841670	g9879	i0	100	0.990950226244344	73	0	99.1	0	221	3	466	538	WP_306516796.1 family B DNA polymerase [Streptomyces sp. CHB9.2]	diamond	219	138	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
26638719	26638719	PRJNA675638_P_NODE_8681_length_236_cov_0.775401_g8484_i0	PRJNA675638	8681	236	0.775401	1.82994636	Propionicimonas sp.	1955623	Bacteria	Bacteria	43.1	0.0243	NR	MDQ7991660.1	1955623	g8484	i0	39.7	2.4406779661017	63	30	77.5	3	222	40	352	408	MDQ7991660.1 MFS transporter [Propionicimonas sp.]	diamond	576	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Propionicimonas	Propionicimonas sp.
26701915	26701915	PRJNA675638_P_NODE_21021_length_163_cov_0.894737_g20824_i0	PRJNA675638	21021	163	0.894737	1.45842131	Actinomadura meridiana	559626	Bacteria	Bacteria	43.9	5.11e-4	NR	WP_344890488.1	559626	g20824	i0	77.8	2.61349693251534	27	6	49.7	0	146	66	7	33	WP_344890488.1 hypothetical protein [Actinomadura meridiana]	diamond	426	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura meridiana
26986897	26986897	PRJNA675638_P_NODE_5162_length_298_cov_1.433735_g4965_i0	PRJNA675638	5162	298	1.433735	4.2725303	Streptomyces turgidiscabies	85558	Bacteria	Bacteria	54.3	4.17e-7	NR	WP_409101490.1	85558	g4965	i0	35.3	0.684563758389262	68	43	67.4	1	17	217	1	68	WP_409101490.1 hypothetical protein, partial [Streptomyces turgidiscabies]	diamond	204	54.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces turgidiscabies
27062095	27062095	PRJNA675638_S_NODE_1782_length_328_cov_37.777778_g1720_i0	PRJNA675638	1782	328	37.777778	123.91111184	Bifidobacterium	1678	Bacteria	Bacteria	43.9	0.0356	NR	WP_291526982.1	1946112	g1720	i0	39.6	0.878048780487805	48	29	43.9	0	173	30	203	250	WP_291526982.1 glycosyltransferase family 2 protein [Bifidobacterium sp. UBA744]	diamond	288	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium sp. UBA744
27219939	27219939	PRJNA675638_P_NODE_4922_length_304_cov_2.960784_g4725_i0	PRJNA675638	4922	304	2.960784	9.00078336	Actinomycetes	1760	Bacteria	Bacteria	44.3	0.0215	NR	WP_246243941.1	182220	g4725	i0	33.7	1.64802631578947	83	48	81.9	1	6	254	452	527	WP_246243941.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Mycolicibacterium murale]	diamond	501	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium murale
27239893	27239893	PRJNA675638_P_NODE_12323_length_203_cov_0.980519_g12126_i0	PRJNA675638	12323	203	0.980519	1.99045357	Thermoleophilaceae bacterium	2732252	Bacteria	Bacteria	41.2	0.0263	NR	MFL5826453.1	2732252	g12126	i0	37	0.798029556650246	54	26	75.4	3	8	160	22	70	MFL5826453.1 hypothetical protein [Thermoleophilaceae bacterium]	diamond	162	41.2	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Thermoleophilales	Thermoleophilaceae		Thermoleophilaceae bacterium
27334949	27334949	PRJNA675638_P_NODE_22243_length_161_cov_0.910714_g22046_i0	PRJNA675638	22243	161	0.910714	1.46624954	Mycobacteroides abscessus subsp. abscessus	1185650	Bacteria	Bacteria	40	0.02	NR	SIN51877.1	1185650	g22046	i0	51.2	0.763975155279503	41	20	76.4	0	141	19	5	45	SIN51877.1 Uncharacterised protein [Mycobacteroides abscessus subsp. abscessus]	diamond	123	40	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides abscessus
27650716	27650716	PRJNA675638_S_NODE_7824_length_166_cov_0.871795_g7762_i0	PRJNA675638	7824	166	0.871795	1.4471797	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	46.2	7.87e-4	NR	WP_252941101.1	2841670	g7762	i0	40.7	0.975903614457831	54	32	97.6	0	1	162	75	128	WP_252941101.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	162	46.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
27871568	27871568	PRJNA675638_P_NODE_9445_length_227_cov_0.977528_g9248_i0	PRJNA675638	9445	227	0.977528	2.21898856	Streptomyces atratus	1893	Bacteria	Bacteria	43.1	0.022	NR	WP_382301690.1	1893	g9248	i0	57.1	1.11013215859031	42	17	54.2	1	15	137	21	62	WP_382301690.1 non-ribosomal peptide synthetase [Streptomyces atratus]	diamond	252	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces atratus
27934831	27934831	PRJNA675638_P_NODE_16065_length_179_cov_1.446154_g15868_i0	PRJNA675638	16065	179	1.446154	2.58861566	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	125	1.54e-31	NR	WP_252941025.1	2841670	g15868	i0	100	0.988826815642458	59	0	98.9	0	2	178	80	138	WP_252941025.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	177	125	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
27934832	27934832	PRJNA675638_P_NODE_18225_length_167_cov_0.864407_g18028_i0	PRJNA675638	18225	167	0.864407	1.44355969	Bifidobacterium xylocopae	2493119	Bacteria	Bacteria	51.2	1.36e-5	NR	WP_236632644.1	2493119	g18028	i0	62	1.72455089820359	50	19	89.8	0	3	152	366	415	WP_236632644.1 apolipoprotein A1/A4/E family protein [Bifidobacterium xylocopae]	diamond	288	51.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium xylocopae
28641364	28641364	PRJNA675638_S_NODE_2547_length_271_cov_0.918919_g2485_i0	PRJNA675638	2547	271	0.918919	2.49027049	Bacteria	2	Bacteria	Bacteria	82.8	3.77e-16	NR	WP_258004163.1	2702	g2485	i0	45.3	6.69741697416974	86	46	95.2	1	1	258	201	285	WP_258004163.1 PhoH family protein [Gardnerella vaginalis]	diamond	1815	83.6	0.990430622009569	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Gardnerella	Gardnerella vaginalis
28818501	28818501	PRJNA675638_P_NODE_15248_length_184_cov_1.133333_g15051_i0	PRJNA675638	15248	184	1.133333	2.08533272	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	128	1.82e-33	NR	WP_252940734.1	2841670	g15051	i0	100	0.994565217391304	61	0	99.5	0	2	184	368	428	WP_252940734.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	183	128	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
28850210	28850210	PRJNA675638_P_NODE_18728_length_166_cov_0.871795_g18531_i0	PRJNA675638	18728	166	0.871795	1.4471797	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	62	4.24e-10	NR	WP_252940949.1	2841670	g18531	i0	96.6	0.524096385542169	29	1	52.4	0	165	79	141	169	WP_252940949.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	87	62	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
28881898	28881898	PRJNA675638_S_NODE_2048_length_304_cov_1.031373_g1986_i0	PRJNA675638	2048	304	1.031373	3.13537392	Streptomyces sp. NBC_	1931	Bacteria	Bacteria	43.5	0.0398	NR	WP_329460327.1	2903885	g1986	i0	39.8	0.868421052631579	88	48	82.9	3	254	3	445	531	WP_329460327.1 acetyl/propionyl/methylcrotonyl-CoA carboxylase subunit alpha [Streptomyces sp. NBC_01497]	diamond	264	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01497
29607815	29607815	PRJNA675638_P_NODE_19690_length_165_cov_0.879310_g19493_i0	PRJNA675638	19690	165	0.87931	1.4508615	Rhodococcus baikonurensis	172041	Bacteria	Bacteria	112	5.8099999999999994e-30	NR	GAA3131059.1	172041	g19493	i0	98.1	0.981818181818182	54	1	98.2	0	2	163	21	74	GAA3131059.1 hypothetical protein GCM10020255_004830 [Rhodococcus baikonurensis]	diamond	162	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus baikonurensis
29860778	29860778	PRJNA675638_S_NODE_4131_length_216_cov_0.844311_g4069_i0	PRJNA675638	4131	216	0.844311	1.82371176	Rothia terrae	396015	Bacteria	Bacteria	42.7	0.0256	NR	WP_363576044.1	396015	g4069	i0	43.2	0.513888888888889	37	21	51.4	0	45	155	346	382	WP_363576044.1 CHAP domain-containing protein [Rothia terrae]	diamond	111	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia terrae
30018922	30018922	PRJNA675638_P_NODE_17931_length_168_cov_1.168067_g17734_i0	PRJNA675638	17931	168	1.168067	1.96235256	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	109	9.51e-28	NR	WP_252940766.1	2841670	g17734	i0	94.5	0.982142857142857	55	3	98.2	0	3	167	79	133	WP_252940766.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	165	109	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
30061996	30061996	PRJNA675638_P_NODE_11171_length_211_cov_1.888889_g10974_i0	PRJNA675638	11171	211	1.888889	3.98555579	Leucobacter	55968	Bacteria	Bacteria	86.7	1.48e-18	NR	WP_017793668.1	664638	g10974	i0	60.7	2.40284360189573	56	22	79.6	0	2	169	214	269	WP_017793668.1 thymidylate synthase [Leucobacter salsicius]	diamond	507	86.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter salsicius
30378483	30378483	PRJNA675638_P_NODE_6772_length_264_cov_0.916279_g6575_i0	PRJNA675638	6772	264	0.916279	2.41897656	Streptomyces	1883	Bacteria	Bacteria	47.4	0.00109	NR	WP_141357448.1	2585753	g6575	i0	35.3	1.54545454545455	68	30	61.4	2	226	65	270	337	WP_141357448.1 MFS transporter [Streptomyces sp. 6-11-2]	diamond	408	47.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. 6-11-2
30492728	30492728	PRJNA675638_P_NODE_9193_length_230_cov_0.812155_g8996_i0	PRJNA675638	9193	230	0.812155	1.8679565	Actinomycetota bacterium	2900548	Bacteria	Bacteria	42.7	0.0304	NR	MDQ2837222.1	2900548	g8996	i0	40.5	0.482608695652174	37	22	48.3	0	155	45	1	37	MDQ2837222.1 flippase-like domain-containing protein [Actinomycetota bacterium]	diamond	111	42.7	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30567336	30567336	PRJNA675638_S_NODE_8813_length_163_cov_0.894737_g8751_i0	PRJNA675638	8813	163	0.894737	1.45842131	Corynebacterium	1716	Bacteria	Bacteria	88.2	4.5500000000000006e-21	NR	WP_284587248.1	37637	g8751	i0	77.8	1.98773006134969	54	12	99.4	0	163	2	12	65	WP_284587248.1 helix-turn-helix transcriptional regulator [Corynebacterium pseudodiphtheriticum]	diamond	324	89	0.991011235955056	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudodiphtheriticum
30871782	30871782	PRJNA675638_P_NODE_21754_length_162_cov_0.858407_g21557_i0	PRJNA675638	21754	162	0.858407	1.39061934	Actinomycetota bacterium	2900548	Bacteria	Bacteria	42	0.0241	NR	MBE0447282.1	2900548	g21557	i0	37.5	0.740740740740741	40	25	74.1	0	150	31	367	406	MBE0447282.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Actinomycetota bacterium]	diamond	120	42	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
31218997	31218997	PRJNA675638_P_NODE_22455_length_161_cov_0.901786_g22258_i0	PRJNA675638	22455	161	0.901786	1.45187546	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	103	2.01e-24	NR	WP_252940730.1	2841670	g22258	i0	94.2	0.968944099378882	52	3	96.9	0	160	5	150	201	WP_252940730.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	156	103	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
31250970	31250970	PRJNA675638_P_NODE_15055_length_185_cov_1.191176_g14858_i0	PRJNA675638	15055	185	1.191176	2.2036756	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	121	1.84e-30	NR	WP_252940955.1	2841670	g14858	i0	100	0.989189189189189	61	0	98.9	0	185	3	374	434	WP_252940955.1 RNase H family protein [Streptomyces sp. CHB9.2]	diamond	183	121	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
31409235	31409235	PRJNA675638_P_NODE_19076_length_166_cov_0.871795_g18879_i0	PRJNA675638	19076	166	0.871795	1.4471797	Brachybacterium endophyticum	2182385	Bacteria	Bacteria	81.3	2.25e-17	NR	WP_109276656.1	2182385	g18879	i0	72.3	0.849397590361446	47	13	84.9	0	3	143	139	185	WP_109276656.1 hypothetical protein [Brachybacterium endophyticum]	diamond	141	81.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium endophyticum
31693790	31693790	PRJNA675638_P_NODE_18497_length_167_cov_0.864407_g18300_i0	PRJNA675638	18497	167	0.864407	1.44355969	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	63.5	1.79e-11	NR	WP_368858039.1	2841670	g18300	i0	100	0.538922155688623	30	0	53.9	0	78	167	1	30	WP_368858039.1 PAAR domain-containing protein [Streptomyces sp. CHB9.2]	diamond	90	63.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
31958633	31958633	PRJNA675638_P_NODE_6137_length_276_cov_2.039648_g5940_i0	PRJNA675638	6137	276	2.039648	5.62942848	Bacteria	2	Bacteria	Bacteria	85.1	2.66e-17	NR	CDD67454.1	1262877	g5940	i0	41.9	51.5217391304348	86	50	93.5	0	258	1	173	258	CDD67454.1 phosphate starvation-inducible protein PhoH predicted ATPase [Eggerthella sp. CAG:368]	diamond	14220	85.9	0.990686845168801	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Eggerthellales	Eggerthellaceae	Eggerthella	Eggerthella sp. CAG:368
32168599	32168599	PRJNA675638_P_NODE_13238_length_196_cov_1.768707_g13041_i0	PRJNA675638	13238	196	1.768707	3.46666572	Actinomycetota bacterium	2900548	Bacteria	Bacteria	40	0.0332	NR	MDQ1546642.1	2900548	g13041	i0	49	0.780612244897959	51	22	78.1	2	158	6	16	62	MDQ1546642.1 hypothetical protein [Actinomycetota bacterium]	diamond	153	40	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
32295320	32295320	PRJNA675638_S_NODE_8919_length_162_cov_0.902655_g8857_i0	PRJNA675638	8919	162	0.902655	1.4623011	Rothia sp. LK2588	3114369	Bacteria	Bacteria	41.6	0.0317	NR	WP_368550543.1	3114369	g8857	i0	39.5	0.796296296296296	43	26	79.6	0	131	3	1	43	WP_368550543.1 prolyl oligopeptidase family serine peptidase [Rothia sp. LK2588]	diamond	129	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia sp. LK2588
32484957	32484957	PRJNA675638_P_NODE_8499_length_238_cov_1.079365_g8302_i0	PRJNA675638	8499	238	1.079365	2.5688887	Actinomycetota bacterium	2900548	Bacteria	Bacteria	62.8	3.06e-9	NR	MSY43459.1	2900548	g8302	i0	42.7	0.945378151260504	75	42	94.5	1	5	229	603	676	MSY43459.1 NAD-dependent DNA ligase LigA [Actinomycetota bacterium]	diamond	225	62.8	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
32673922	32673922	PRJNA675638_P_NODE_16120_length_179_cov_0.900000_g15923_i0	PRJNA675638	16120	179	0.9	1.611	Phytoactinopolyspora alkaliphila	1783498	Bacteria	Bacteria	41.2	0.0355	NR	WP_163818150.1	1783498	g15923	i0	39.2	0.854748603351955	51	28	80.4	1	21	164	11	61	WP_163818150.1 DUF3180 family protein [Phytoactinopolyspora alkaliphila]	diamond	153	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Jiangellales	Jiangellaceae	Phytoactinopolyspora	Phytoactinopolyspora alkaliphila
32737239	32737239	PRJNA675638_P_NODE_20900_length_163_cov_0.894737_g20703_i0	PRJNA675638	20900	163	0.894737	1.45842131	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	110	1.29e-26	NR	WP_252941025.1	2841670	g20703	i0	100	0.993865030674847	54	0	99.4	0	2	163	441	494	WP_252941025.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	162	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2

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