metadata: contig_metadata: 35 rows where analysis = "diamond", bioproject = "PRJNA781196" and tax

35 rows where analysis = "diamond", bioproject = "PRJNA781196" 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
4587990	4587990	PRJNA781196_P_NODE_63764_length_244_cov_0.912281_g63387_i0	PRJNA781196	63764	244	0.912281	2.22596564	Microbacterium festucae	2977531	Bacteria	Bacteria	78.2	2.67e-15	NR	WP_261578256.1	2977531	g63387	i0	61	0.94672131147541	77	28	94.7	1	238	8	127	201	WP_261578256.1 CPBP family intramembrane glutamic endopeptidase [Microbacterium festucae]	diamond	231	78.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium festucae
10963779	10963779	PRJNA781196_P_NODE_60449_length_246_cov_0.901734_g60072_i0	PRJNA781196	60449	246	0.901734	2.21826564	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	133	4.24e-36	NR	HEY3942248.1	2201156	g60072	i0	74.7	1.95121951219512	79	20	96.3	0	245	9	133	211	HEY3942248.1 LLM class F420-dependent oxidoreductase [Acidimicrobiales bacterium]	diamond	480	133	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
16062068	16062068	PRJNA781196_P_NODE_55633_length_249_cov_1.369318_g55256_i0	PRJNA781196	55633	249	1.369318	3.40960182	Streptomyces sp. S1	718288	Bacteria	Bacteria	159	3.47e-48	NR	WP_163014109.1	718288	g55256	i0	85.5	1	83	12	100	0	1	249	54	136	WP_163014109.1 DDE-type integrase/transposase/recombinase, partial [Streptomyces sp. S1]	diamond	249	159	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. S1
26641948	26641948	PRJNA781196_P_NODE_47361_length_260_cov_1.251337_g46984_i0	PRJNA781196	47361	260	1.251337	3.2534762	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	137	5.72e-40	NR	MFN8051629.1	2201156	g46984	i0	74.7	14.5846153846154	83	21	95.8	0	4	252	4	86	MFN8051629.1 hypothetical protein [Acidimicrobiales bacterium]	diamond	3792	137	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
26768622	26768622	PRJNA781196_P_NODE_44261_length_269_cov_1.530612_g43884_i0	PRJNA781196	44261	269	1.530612	4.11734628	unclassified Streptomyces	2593676	Bacteria	Bacteria	42.4	0.0166	NR	WP_365997040.1	2593676	g43884	i0	38.5	0.869888475836431	78	48	87	0	20	253	18	95	WP_365997040.1 MULTISPECIES: hypothetical protein [unclassified Streptomyces]	diamond	234	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
26841620	26841620	PRJNA781196_P_NODE_60101_length_246_cov_1.352601_g59724_i0	PRJNA781196	60101	246	1.352601	3.32739846	Rubrobacter	42255	Bacteria	Bacteria	99	7.429999999999999e-23	NR	MBD0356271.1	2036010	g59724	i0	66.7	5.5	75	25	91.5	0	229	5	18	92	MBD0356271.1 4-hydroxy-tetrahydrodipicolinate synthase [Rubrobacter sp.]	diamond	1353	100	0.99	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter sp.
26864024	26864024	PRJNA781196_P_NODE_60661_length_246_cov_0.901734_g60284_i0	PRJNA781196	60661	246	0.901734	2.21826564	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	42.7	0.0394	NR	HVM55903.1	2838783	g60284	i0	42	0.609756097560976	50	26	61	1	211	62	951	997	HVM55903.1 Ig-like domain-containing protein [Gaiellaceae bacterium]	diamond	150	42.7	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae bacterium
26936275	26936275	PRJNA781196_P_NODE_23662_length_352_cov_1.344086_g23285_i0	PRJNA781196	23662	352	1.344086	4.73118272	Bacteria	2	Bacteria	Bacteria	102	2.17e-22	NR	MCB1017082.1	2201156	g23285	i0	47.8	3.92045454545455	115	59	98	1	7	351	139	252	MCB1017082.1 carboxypeptidase regulatory-like domain-containing protein [Acidimicrobiales bacterium]	diamond	1380	102	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
27053614	27053614	PRJNA781196_P_NODE_65422_length_243_cov_0.917647_g65045_i0	PRJNA781196	65422	243	0.917647	2.22988221	Streptomyces sp. S5	1456735	Bacteria	Bacteria	74.3	2.22e-14	NR	WP_163008933.1	1456735	g65045	i0	69.1	0.679012345679012	55	16	67.9	1	69	233	3	56	WP_163008933.1 integrase zinc binding domain-containing protein, partial [Streptomyces sp. S5]	diamond	165	74.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. S5
27211337	27211337	PRJNA781196_P_NODE_35942_length_296_cov_1.399103_g35565_i0	PRJNA781196	35942	296	1.399103	4.14134488	Actinomycetota bacterium	2900548	Bacteria	Bacteria	104	1.5899999999999995e-23	NR	MEY3356943.1	2900548	g35565	i0	50	5.625	94	47	95.3	0	284	3	276	369	MEY3356943.1 hypothetical protein [Actinomycetota bacterium]	diamond	1665	104	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27211365	27211365	PRJNA781196_P_NODE_57742_length_248_cov_0.891429_g57365_i0	PRJNA781196	57742	248	0.891429	2.21074392	Streptomyces sp. S1	718288	Bacteria	Bacteria	101	2.9e-25	NR	WP_163014109.1	718288	g57365	i0	68.1	0.834677419354839	69	22	83.5	0	248	42	51	119	WP_163014109.1 DDE-type integrase/transposase/recombinase, partial [Streptomyces sp. S1]	diamond	207	101	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. S1
27653912	27653912	PRJNA781196_P_NODE_15184_length_423_cov_2.000000_g14807_i0	PRJNA781196	15184	423	2	8.46	Amycolatopsis pigmentata	450801	Bacteria	Bacteria	74.7	1.8e-12	NR	WP_378261409.1	450801	g14807	i0	39.7	0.893617021276596	126	72	88.7	2	11	385	287	409	WP_378261409.1 Ig-like domain repeat protein [Amycolatopsis pigmentata]	diamond	378	74.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis pigmentata
28001298	28001298	PRJNA781196_P_NODE_67265_length_242_cov_0.923077_g66888_i0	PRJNA781196	67265	242	0.923077	2.23384634	Micromonospora auratinigra	261654	Bacteria	Bacteria	42.4	0.0491	NR	WP_091660258.1	261654	g66888	i0	39.4	0.818181818181818	66	36	80.6	2	12	206	337	399	WP_091660258.1 flavin-containing monooxygenase [Micromonospora auratinigra]	diamond	198	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora auratinigra
28443319	28443319	PRJNA781196_P_NODE_54546_length_250_cov_0.881356_g54169_i0	PRJNA781196	54546	250	0.881356	2.20339	Blastococcus sp. CT_GayMR19	2559608	Bacteria	Bacteria	116	1.03e-30	NR	WP_135137406.1	2559608	g54169	i0	81.3	1.86	80	15	96	0	250	11	102	181	WP_135137406.1 Na+/H+ antiporter subunit E [Blastococcus sp. CT_GayMR19]	diamond	465	116	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus sp. CT_GayMR19
28506259	28506259	PRJNA781196_P_NODE_20167_length_376_cov_2.066007_g19790_i0	PRJNA781196	20167	376	2.066007	7.76818632	Actinoplanes subglobosus	1547892	Bacteria	Bacteria	45.1	0.0248	NR	WP_378069542.1	1547892	g19790	i0	36.2	0.462765957446808	58	25	36.7	1	238	375	155	212	WP_378069542.1 acyltransferase family protein [Actinoplanes subglobosus]	diamond	174	45.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Actinoplanes	Actinoplanes subglobosus
28727300	28727300	PRJNA781196_P_NODE_2867_length_881_cov_1.987624_g2566_i0	PRJNA781196	2867	881	1.987624	17.51096744	Actinomycetota bacterium	2900548	Bacteria	Bacteria	206	1.44e-60	NR	TMK82035.1	2900548	g2566	i0	46.2	8.29511918274688	238	116	79	5	707	12	46	277	TMK82035.1 MAG: PQQ-dependent sugar dehydrogenase [Actinomycetota bacterium]	diamond	7308	206	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
29327079	29327079	PRJNA781196_P_NODE_34469_length_302_cov_0.982533_g34092_i0	PRJNA781196	34469	302	0.982533	2.96724966	Nocardioides stalactiti	2755356	Bacteria	Bacteria	64.7	7.56e-11	NR	WP_183095203.1	2755356	g34092	i0	41.1	0.943708609271523	95	52	94.4	1	301	17	2	92	WP_183095203.1 DUF4267 domain-containing protein [Nocardioides stalactiti]	diamond	285	64.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides stalactiti
29399680	29399680	PRJNA781196_P_NODE_67449_length_241_cov_2.226190_g67072_i0	PRJNA781196	67449	241	2.22619	5.3651179	Bacillati	1783272	Bacteria	Bacteria	81.6	5.97e-16	NR	WP_326416905.1	3046309	g67072	i0	52.9	2.16597510373444	87	32	98.3	3	1	237	295	380	WP_326416905.1 aspartate aminotransferase family protein [Amycolatopsis sp. H20-H5]	diamond	522	82.4	0.990291262135922	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. H20-H5
29516498	29516498	PRJNA781196_P_NODE_49870_length_253_cov_0.977778_g49493_i0	PRJNA781196	49870	253	0.977778	2.47377834	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	44.3	0.0121	NR	HUP71266.1	2201156	g49493	i0	40.7	0.960474308300395	81	42	96	2	4	246	166	240	HUP71266.1 O-antigen ligase family protein [Acidimicrobiales bacterium]	diamond	243	44.3	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
29620268	29620268	PRJNA781196_P_NODE_36950_length_293_cov_1.063636_g36573_i0	PRJNA781196	36950	293	1.063636	3.11645348	Saccharopolyspora	1835	Bacteria	Bacteria	94.7	6.7e-21	NR	WP_132682992.1	2530386	g36573	i0	50.5	3.9419795221843	97	45	96.2	2	282	1	194	290	WP_132682992.1 endonuclease/exonuclease/phosphatase family protein [Saccharopolyspora karakumensis]	diamond	1155	94.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora karakumensis
29705658	29705658	PRJNA781196_P_NODE_64670_length_243_cov_1.329412_g64293_i0	PRJNA781196	64670	243	1.329412	3.23047116	Bifidobacteriaceae bacterium	2291324	Bacteria	Bacteria	62	6.26e-9	NR	MDR1426576.1	2291324	g64293	i0	48.3	4.62962962962963	60	31	74.1	0	189	10	34	93	MDR1426576.1 Ig-like domain-containing protein [Bifidobacteriaceae bacterium]	diamond	1125	62	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae		Bifidobacteriaceae bacterium
29863954	29863954	PRJNA781196_P_NODE_61551_length_245_cov_1.377907_g61174_i0	PRJNA781196	61551	245	1.377907	3.37587215	Actinomycetota bacterium	2900548	Bacteria	Bacteria	70.9	2.03e-12	NR	MFM7046896.1	2900548	g61174	i0	70.2	1.48163265306122	47	14	57.6	0	97	237	1	47	MFM7046896.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Actinomycetota bacterium]	diamond	363	70.9	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30053350	30053350	PRJNA781196_P_NODE_45231_length_266_cov_1.616580_g44854_i0	PRJNA781196	45231	266	1.61658	4.3001028	Mycobacteroides abscessus subsp. massiliense	1962118	Bacteria	Bacteria	42.7	0.0393	NR	SKO10704.1	1962118	g44854	i0	27.4	0.947368421052632	84	53	85.7	1	39	266	106	189	SKO10704.1 Uncharacterised protein [Mycobacteroides abscessus subsp. massiliense]	diamond	252	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides abscessus
30189223	30189223	PRJNA781196_P_NODE_31592_length_313_cov_1.300000_g31215_i0	PRJNA781196	31592	313	1.3	4.069	PVC group	1783257	Bacteria	Bacteria	46.6	0.00396	NR	MBI2692544.1	1909295	g31215	i0	34.7	1.89776357827476	101	62	95.8	2	300	1	384	481	MBI2692544.1 thrombospondin type 3 repeat-containing protein [Solirubrobacterales bacterium]	diamond	594	47	0.991489361702128	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			Solirubrobacterales bacterium
30211301	30211301	PRJNA781196_P_NODE_44932_length_267_cov_1.520619_g44555_i0	PRJNA781196	44932	267	1.520619	4.06005273	Actinomycetota bacterium	2900548	Bacteria	Bacteria	52	2.77e-5	NR	MFM9136703.1	2900548	g44555	i0	69.7	0.674157303370786	33	10	37.1	0	267	169	183	215	MFM9136703.1 RCC1 domain-containing protein [Actinomycetota bacterium]	diamond	180	52	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30338306	30338306	PRJNA781196_P_NODE_10692_length_492_cov_0.918854_g10316_i0	PRJNA781196	10692	492	0.918854	4.52076168	Aquihabitans sp. G128	2849779	Bacteria	Bacteria	45.1	0.0345	NR	WP_216997612.1	2849779	g10316	i0	28.7	0.701219512195122	115	56	62.2	4	120	425	73	174	WP_216997612.1 hypothetical protein [Aquihabitans sp. G128]	diamond	345	45.1	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Iamiaceae	Aquihabitans	Aquihabitans sp. G128
30464668	30464668	PRJNA781196_P_NODE_43813_length_270_cov_2.101523_g43436_i0	PRJNA781196	43813	270	2.101523	5.6741121	Microlunatus sp.	39595	Bacteria	Bacteria	135	4.05e-38	NR	HEY5979367.1	39595	g43436	i0	86.1	0.8	72	10	80	0	49	264	4	75	HEY5979367.1 tail fiber protein [Microlunatus sp.]	diamond	216	135	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sp.
30590542	30590542	PRJNA781196_P_NODE_29293_length_323_cov_1.808000_g28916_i0	PRJNA781196	29293	323	1.808	5.83984	Micromonospora polyrhachis	1282883	Bacteria	Bacteria	57.4	6.84e-7	NR	WP_184536256.1	1282883	g28916	i0	37.8	0.835913312693498	90	48	81.7	4	310	47	628	711	WP_184536256.1 carbohydrate-binding module family 20 domain-containing protein [Micromonospora polyrhachis]	diamond	270	57.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora polyrhachis
30875003	30875003	PRJNA781196_P_NODE_58714_length_247_cov_1.137931_g58337_i0	PRJNA781196	58714	247	1.137931	2.81068957	Cutibacterium acnes	1747	Bacteria	Bacteria	175	7.22e-52	NR	MES6521686.1	1747	g58337	i0	98.8	0.983805668016194	81	1	98.4	0	245	3	33	113	MES6521686.1 reverse transcriptase family protein [Cutibacterium acnes]	diamond	243	175	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
31349211	31349211	PRJNA781196_P_NODE_43136_length_273_cov_1.170000_g42759_i0	PRJNA781196	43136	273	1.17	3.1941	Streptomyces olivoverticillatus	66427	Bacteria	Bacteria	44.7	0.011	NR	GAA3053825.1	66427	g42759	i0	42.6	0.516483516483517	47	22	46.2	1	139	14	593	639	GAA3053825.1 hypothetical protein GCM10020000_39720 [Streptomyces olivoverticillatus]	diamond	141	44.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces olivoverticillatus
31380908	31380908	PRJNA781196_P_NODE_67356_length_242_cov_0.899408_g66979_i0	PRJNA781196	67356	242	0.899408	2.17656736	Microbacteriaceae bacterium	1873462	Bacteria	Bacteria	45.4	0.00401	NR	MCU1423714.1	1873462	g66979	i0	51.2	0.508264462809917	41	20	50.8	0	139	17	126	166	MCU1423714.1 Sortase [Microbacteriaceae bacterium]	diamond	123	45.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae		Microbacteriaceae bacterium
32022800	32022800	PRJNA781196_P_NODE_50938_length_253_cov_0.866667_g50561_i0	PRJNA781196	50938	253	0.866667	2.19266751	Actinomycetes	1760	Bacteria	Bacteria	117	3.24e-28	NR	WP_290468161.1	1275	g50561	i0	62.7	13.7786561264822	83	31	98.4	0	252	4	986	1068	WP_290468161.1 helicase-related protein [Kocuria rosea]	diamond	3486	118	0.991525423728814	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rosea
32497560	32497560	PRJNA781196_P_NODE_41139_length_279_cov_1.514563_g40762_i0	PRJNA781196	41139	279	1.514563	4.22563077	Pseudonocardia	1847	Bacteria	Bacteria	44.7	0.0118	NR	WP_103382666.1	240495	g40762	i0	41.5	1.13978494623656	53	25	50.5	2	244	104	533	585	WP_103382666.1 PHA/PHB synthase family protein [Pseudonocardia dioxanivorans]	diamond	318	45.1	0.991130820399113	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia dioxanivorans
32583008	32583008	PRJNA781196_P_NODE_52839_length_251_cov_0.876404_g52462_i0	PRJNA781196	52839	251	0.876404	2.19977404	Lentzea sp. NPDC	56099	Bacteria	Bacteria	42.4	0.0184	NR	WP_382455149.1	3347103	g52462	i0	46.5	0.51394422310757	43	21	51.4	1	156	28	68	108	WP_382455149.1 hypothetical protein [Lentzea sp. NPDC060358]	diamond	129	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Lentzea	Lentzea sp. NPDC060358
32645451	32645451	PRJNA781196_P_NODE_19060_length_385_cov_1.250000_g18683_i0	PRJNA781196	19060	385	1.25	4.8125	Mycobacterium pinniadriaticum	2994102	Bacteria	Bacteria	67.8	3.23e-10	NR	WP_265998440.1	2994102	g18683	i0	40.3	1.00519480519481	129	64	91.9	2	7	360	296	422	WP_265998440.1 chitinase [Mycobacterium pinniadriaticum]	diamond	387	67.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium pinniadriaticum

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