metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA949785" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA949785" 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
4761615	4761615	PRJNA949785_P_NODE_18084_length_244_cov_0.859649_g17887_i0	PRJNA949785	18084	244	0.859649	2.09754356	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	115	8.98e-29	NR	HEX6759164.1	2021380	g17887	i0	64.9	5.54508196721311	74	26	91	0	244	23	251	324	HEX6759164.1 ArsR family transcriptional regulator [Propionibacteriaceae bacterium]	diamond	1353	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
18784945	18784945	PRJNA949785_P_NODE_18235_length_243_cov_0.905882_g18038_i0	PRJNA949785	18235	243	0.905882	2.20129326	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	167	1.27e-49	NR	HEY8059502.1	2201156	g18038	i0	91.4	1	81	7	100	0	243	1	44	124	HEY8059502.1 glycoside hydrolase family 43 protein [Acidimicrobiales bacterium]	diamond	243	167	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
27063719	27063719	PRJNA949785_P_NODE_10722_length_315_cov_1.442149_g10525_i0	PRJNA949785	10722	315	1.442149	4.54276935	Streptomyces	1883	Bacteria	Bacteria	46.2	0.00429	NR	WP_190131485.1	33904	g10525	i0	41.8	1.04761904761905	55	29	49.5	1	8	163	103	157	WP_190131485.1 phosphatase PAP2 family protein [Streptomyces mashuensis]	diamond	330	46.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces mashuensis
27151521	27151521	PRJNA949785_P_NODE_19102_length_241_cov_0.916667_g18905_i0	PRJNA949785	19102	241	0.916667	2.20916747	Janibacter massiliensis	2058291	Bacteria	Bacteria	149	3.82e-44	NR	WP_325027425.1	2058291	g18905	i0	100	0.995850622406639	80	0	99.6	0	240	1	23	102	WP_325027425.1 MFS transporter [Janibacter massiliensis]	diamond	240	149	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter massiliensis
27436617	27436617	PRJNA949785_P_NODE_8723_length_356_cov_1.876325_g8526_i0	PRJNA949785	8723	356	1.876325	6.679717	Microbacterium lushaniae	2614639	Bacteria	Bacteria	67.8	3.83e-12	NR	WP_150926382.1	2614639	g8526	i0	42.5	1.18820224719101	73	41	60.7	1	316	101	8	80	WP_150926382.1 TM2 domain-containing protein [Microbacterium lushaniae]	diamond	423	67.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium lushaniae
27941646	27941646	PRJNA949785_P_NODE_15665_length_251_cov_0.865169_g15468_i0	PRJNA949785	15665	251	0.865169	2.17157419	uncultured Rothia sp.	316088	Bacteria	Bacteria	86.7	1.3e-17	NR	WP_346843744.1	316088	g15468	i0	97.7	0.51394422310757	43	1	51.4	0	249	121	444	486	WP_346843744.1 hypothetical protein [uncultured Rothia sp.]	diamond	129	86.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	uncultured Rothia sp.
28131160	28131160	PRJNA949785_P_NODE_18365_length_243_cov_0.905882_g18168_i0	PRJNA949785	18365	243	0.905882	2.20129326	Brevibacterium ihuae	1631743	Bacteria	Bacteria	65.5	2.74e-10	NR	WP_101650537.1	1631743	g18168	i0	75	1.90123456790123	52	12	63	1	241	89	257	308	WP_101650537.1 EamA family transporter [Brevibacterium ihuae]	diamond	462	65.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium ihuae
29022029	29022029	PRJNA949785_P_NODE_17188_length_246_cov_0.890173_g16991_i0	PRJNA949785	17188	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	165	2.47e-45	NR	MEZ5178689.1	2201156	g16991	i0	86.6	2	82	11	100	0	246	1	425	506	MEZ5178689.1 radical SAM protein [Acidimicrobiales bacterium]	diamond	492	165	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
29236192	29236192	PRJNA949785_P_NODE_18789_length_242_cov_0.869822_g18592_i0	PRJNA949785	18789	242	0.869822	2.10496924	Nesterenkonia populi	1591087	Bacteria	Bacteria	90.9	7.39e-20	NR	WP_246126123.1	1591087	g18592	i0	63.2	0.942148760330578	76	27	93	1	18	242	113	188	WP_246126123.1 glycerophosphodiester phosphodiesterase [Nesterenkonia populi]	diamond	228	90.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia populi
29267446	29267446	PRJNA949785_P_NODE_18569_length_242_cov_0.911243_g18372_i0	PRJNA949785	18569	242	0.911243	2.20520806	Microbacterium sp. NPDC	51671	Bacteria	Bacteria	104	1.35e-24	NR	WP_366374718.1	3155063	g18372	i0	66.3	0.991735537190083	80	27	99.2	0	240	1	96	175	WP_366374718.1 site-specific integrase [Microbacterium sp. NPDC089190]	diamond	240	104	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. NPDC089190
29274106	29274106	PRJNA949785_P_NODE_6969_length_410_cov_1.370920_g6772_i0	PRJNA949785	6969	410	1.37092	5.620772	Bacteria	2	Bacteria	Bacteria	96.3	2.15e-20	NR	MBH01636.1	2024894	g6772	i0	34.1	5.06341463414634	138	89	99.5	1	3	410	49	186	MBH01636.1 hypothetical protein [Acidimicrobiaceae bacterium]	diamond	2076	96.7	0.995863495346432	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Acidimicrobiaceae		Acidimicrobiaceae bacterium
29299258	29299258	PRJNA949785_P_NODE_16309_length_249_cov_0.875000_g16112_i0	PRJNA949785	16309	249	0.875	2.17875	Bifidobacteriaceae bacterium	2291324	Bacteria	Bacteria	92.8	2.08e-20	NR	MDR1186045.1	2291324	g16112	i0	62.2	1.97590361445783	82	27	98.8	2	3	248	7	84	MDR1186045.1 hypothetical protein [Bifidobacteriaceae bacterium]	diamond	492	92.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae		Bifidobacteriaceae bacterium
29772649	29772649	PRJNA949785_P_NODE_15531_length_251_cov_0.865169_g15334_i0	PRJNA949785	15531	251	0.865169	2.17157419	Actinomycetota bacterium	2900548	Bacteria	Bacteria	154	5.649999999999999e-47	NR	MEY4401614.1	2900548	g15334	i0	93.3	0.896414342629482	75	5	89.6	0	225	1	7	81	MEY4401614.1 hypothetical protein [Actinomycetota bacterium]	diamond	225	154	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30594142	30594142	PRJNA949785_P_NODE_17073_length_246_cov_1.439306_g16876_i0	PRJNA949785	17073	246	1.439306	3.54069276	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	148	7.45e-40	NR	HEU4841853.1	2497619	g16876	i0	90.1	3.95121951219512	81	8	98.8	0	2	244	244	324	HEU4841853.1 AMP-binding protein [Ilumatobacteraceae bacterium]	diamond	972	148	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium
31005033	31005033	PRJNA949785_P_NODE_17954_length_244_cov_0.900585_g17757_i0	PRJNA949785	17954	244	0.900585	2.1974274	unclassified Microbacterium	2609290	Bacteria	Bacteria	170	8.599999999999999e-49	NR	WP_138174728.1	2609290	g17757	i0	100	0.995901639344262	81	0	99.6	0	1	243	243	323	WP_138174728.1 MULTISPECIES: amidohydrolase family protein [unclassified Microbacterium]	diamond	243	170	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium
31194177	31194177	PRJNA949785_P_NODE_16395_length_248_cov_1.651429_g16198_i0	PRJNA949785	16395	248	1.651429	4.09554392	Microbacterium lacticum	33885	Bacteria	Bacteria	175	6.36e-49	NR	WP_196323173.1	33885	g16198	i0	100	0.991935483870968	82	0	99.2	0	2	247	98	179	WP_196323173.1 DEAD/DEAH box helicase [Microbacterium lacticum]	diamond	246	175	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium lacticum
31194193	31194193	PRJNA949785_P_NODE_9375_length_341_cov_0.735075_g9178_i0	PRJNA949785	9375	341	0.735075	2.50660575	Solirubrobacterales bacterium	1909295	Bacteria	Bacteria	43.5	0.05	NR	HWA53238.1	1909295	g9178	i0	36.8	0.501466275659824	57	35	50.1	1	21	191	144	199	HWA53238.1 class I tRNA ligase family protein [Solirubrobacterales bacterium]	diamond	171	43.5	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			Solirubrobacterales bacterium
32806774	32806774	PRJNA949785_P_NODE_17820_length_244_cov_0.900585_g17623_i0	PRJNA949785	17820	244	0.900585	2.1974274	Nocardia terpenica	455432	Bacteria	Bacteria	82	3.72e-16	NR	WP_098697447.1	455432	g17623	i0	55.6	0.774590163934426	63	28	77.5	0	225	37	42	104	WP_098697447.1 class II histone deacetylase [Nocardia terpenica]	diamond	189	82	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia terpenica
32901167	32901167	PRJNA949785_P_NODE_13640_length_273_cov_1.320000_g13443_i0	PRJNA949785	13640	273	1.32	3.6036	Parenemella sanctibonifatiensis	2016505	Bacteria	Bacteria	179	4.16e-51	NR	WP_094452102.1	2016505	g13443	i0	97.8	0.989010989010989	90	2	98.9	0	271	2	430	519	WP_094452102.1 alpha-glucosidase [Parenemella sanctibonifatiensis]	diamond	270	179	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Parenemella	Parenemella sanctibonifatiensis

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