metadata: contig_metadata: 28 rows where analysis = "diamond", bioproject = "PRJNA1156092" and tax

28 rows where analysis = "diamond", bioproject = "PRJNA1156092" 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
302954	302954	PRJNA1156092_P_NODE_32221_length_241_cov_0.916667_g32091_i0	PRJNA1156092	32221	241	0.916667	2.20916747	Frankiaceae bacterium	2654182	Bacteria	Bacteria	84	1.35e-17	NR	HEV2889195.1	2654182	g32091	i0	55.3	0.946058091286307	76	34	94.6	0	230	3	142	217	HEV2889195.1 DUF4129 domain-containing protein [Frankiaceae bacterium]	diamond	228	84	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Frankiales	Frankiaceae		Frankiaceae bacterium
1577581	1577581	PRJNA1156092_P_NODE_32162_length_241_cov_0.916667_g32032_i0	PRJNA1156092	32162	241	0.916667	2.20916747	Mycobacterium	1763	Bacteria	Bacteria	95.1	3.49e-23	NR	WP_065133552.1	1763	g32032	i0	93.9	0.609958506224066	49	3	61	0	240	94	66	114	WP_065133552.1 MULTISPECIES: ferredoxin [Mycobacterium]	diamond	147	95.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium
4129763	4129763	PRJNA1156092_P_NODE_25844_length_247_cov_1.109195_g25714_i0	PRJNA1156092	25844	247	1.109195	2.73971165	Actinomycetota	201174	Bacteria	Bacteria	125	2.3099999999999997e-31	NR	MEI7887162.1	1883427	g25714	i0	80.5	5.97570850202429	82	16	99.6	0	1	246	428	509	MEI7887162.1 DEAD/DEAH box helicase [Actinomycetes bacterium]	diamond	1476	125	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
9965354	9965354	PRJNA1156092_P_NODE_19908_length_264_cov_1.267016_g19778_i0	PRJNA1156092	19908	264	1.267016	3.34492224	Pseudolysinimonas sp.	2680009	Bacteria	Bacteria	104	1.0199999999999999e-23	NR	WP_395638722.1	2680009	g19778	i0	59.5	0.954545454545455	84	34	95.5	0	254	3	63	146	WP_395638722.1 transglutaminaseTgpA domain-containing protein [Pseudolysinimonas sp.]	diamond	252	104	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudolysinimonas	Pseudolysinimonas sp.
11240578	11240578	PRJNA1156092_P_NODE_30429_length_243_cov_0.905882_g30299_i0	PRJNA1156092	30429	243	0.905882	2.20129326	FCB group	1783270	Bacteria	Bacteria	112	1.18e-26	NR	WP_063813406.1	295585	g30299	i0	61.2	8.22222222222222	85	28	98.8	2	240	1	112	196	WP_063813406.1 lamin tail domain-containing protein [Herbidospora daliensis]	diamond	1998	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Herbidospora	Herbidospora daliensis
11781724	11781724	PRJNA1156092_P_NODE_8970_length_366_cov_1.709898_g8840_i0	PRJNA1156092	8970	366	1.709898	6.25822668	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	186	5.72e-58	NR	MCP3885490.1	2021380	g8840	i0	73.3	0.983606557377049	120	32	98.4	0	1	360	10	129	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	360	186	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
18154452	18154452	PRJNA1156092_P_NODE_16195_length_290_cov_1.304147_g16065_i0	PRJNA1156092	16195	290	1.304147	3.7820263	Lawsonella	1847725	Bacteria	Bacteria	199	5.57e-61	NR	WP_290598975.1	1847725	g16065	i0	100	0.993103448275862	96	0	99.3	0	2	289	84	179	WP_290598975.1 MULTISPECIES: tryptophan--tRNA ligase [Lawsonella]	diamond	288	199	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
27185928	27185928	PRJNA1156092_P_NODE_29102_length_244_cov_0.900585_g28972_i0	PRJNA1156092	29102	244	0.900585	2.1974274	Microbacterium	33882	Bacteria	Bacteria	153	4.17e-45	NR	WP_212743488.1	2609290	g28972	i0	100	1.99180327868852	81	0	99.6	0	2	244	25	105	WP_212743488.1 MULTISPECIES: GntR family transcriptional regulator [unclassified Microbacterium]	diamond	486	153	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium
27229892	27229892	PRJNA1156092_P_NODE_28803_length_244_cov_1.941520_g28673_i0	PRJNA1156092	28803	244	1.94152	4.7373088	Mycolicibacterium sp.	2320850	Bacteria	Bacteria	145	1.07e-42	NR	WP_293023750.1	2320850	g28673	i0	91.4	0.995901639344262	81	7	99.6	0	244	2	51	131	WP_293023750.1 AAA family ATPase [Mycolicibacterium sp.]	diamond	243	145	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium sp.
27261649	27261649	PRJNA1156092_P_NODE_22663_length_251_cov_0.865169_g22533_i0	PRJNA1156092	22663	251	0.865169	2.17157419	Mycolicibacterium sp. GF69	2267251	Bacteria	Bacteria	159	6.0999999999999996e-43	NR	RAV05809.1	2267251	g22533	i0	97.6	0.99203187250996006	83	2	99.2	0	250	2	216	298	RAV05809.1 helicase [Mycolicibacterium sp. GF69]	diamond	249	159	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium sp. GF69
27293179	27293179	PRJNA1156092_P_NODE_24663_length_249_cov_0.875000_g24533_i0	PRJNA1156092	24663	249	0.875	2.17875	Dermatobacter hominis	2884263	Bacteria	Bacteria	136	1.77e-35	NR	WP_227757977.1	2884263	g24533	i0	81.5	0.975903614457831	81	15	97.6	0	6	248	323	403	WP_227757977.1 aspartate--tRNA ligase [Dermatobacter hominis]	diamond	243	136	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Iamiaceae	Dermatobacter	Dermatobacter hominis
27482732	27482732	PRJNA1156092_P_NODE_28983_length_244_cov_0.900585_g28853_i0	PRJNA1156092	28983	244	0.900585	2.1974274	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	54.7	2.15e-6	NR	HEY5430972.1	2586742	g28853	i0	77.4	0.381147540983607	31	7	38.1	0	3	95	338	368	HEY5430972.1 HoxN/HupN/NixA family nickel/cobalt transporter [Solirubrobacteraceae bacterium]	diamond	93	54.7	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
28208740	28208740	PRJNA1156092_P_NODE_27306_length_246_cov_0.890173_g27176_i0	PRJNA1156092	27306	246	0.890173	2.18982558	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	44.7	0.00766	NR	HTK15169.1	2080302	g27176	i0	37.1	0.75609756097561	62	30	68.3	2	41	208	117	175	HTK15169.1 site-2 protease family protein [Acidimicrobiia bacterium]	diamond	186	44.7	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
28240293	28240293	PRJNA1156092_P_NODE_18866_length_271_cov_1.530303_g18736_i0	PRJNA1156092	18866	271	1.530303	4.14712113	Collinsella tanakaei	626935	Bacteria	Bacteria	182	6.56e-54	NR	WP_117678648.1	626935	g18736	i0	98.9	0.96309963099631	87	1	96.3	0	3	263	340	426	WP_117678648.1 D-alanyl-lipoteichoic acid biosynthesis protein DltD [Collinsella tanakaei]	diamond	261	182	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Coriobacteriaceae	Collinsella	Collinsella tanakaei
28619572	28619572	PRJNA1156092_P_NODE_4187_length_500_cov_1.065574_g4058_i0	PRJNA1156092	4187	500	1.065574	5.32787	Mycobacterium sp.	1785	Bacteria	Bacteria	44.3	0.0297	NR	WP_324396383.1	1785	g4058	i0	46.8	0.282	47	19	27	2	2	136	43	85	WP_324396383.1 hypothetical protein [Mycobacterium sp.]	diamond	141	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
28650977	28650977	PRJNA1156092_P_NODE_12487_length_323_cov_1.156000_g12357_i0	PRJNA1156092	12487	323	1.156	3.73388	Actinomycetota bacterium	2900548	Bacteria	Bacteria	72	4.74e-12	NR	MDQ3862596.1	2900548	g12357	i0	35.5	1.97832817337461	110	64	99.4	2	322	2	293	398	MDQ3862596.1 response regulator [Actinomycetota bacterium]	diamond	639	72	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
29459374	29459374	PRJNA1156092_P_NODE_30330_length_243_cov_0.905882_g30200_i0	PRJNA1156092	30330	243	0.905882	2.20129326	Bifidobacterium	1678	Bacteria	Bacteria	125	5.96e-32	NR	WP_004268685.1	1678	g30200	i0	70.4	2	81	24	100	0	1	243	192	272	WP_004268685.1 MULTISPECIES: C45 family autoproteolytic acyltransferase/hydolase [Bifidobacterium]	diamond	486	125	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium
29787455	29787455	PRJNA1156092_P_NODE_29651_length_244_cov_0.900585_g29521_i0	PRJNA1156092	29651	244	0.900585	2.1974274	Mycobacterium sp. SMC-8	2857060	Bacteria	Bacteria	55.1	1.2e-6	NR	WP_260758476.1	2857060	g29521	i0	76.5	0.418032786885246	34	8	41.8	0	244	143	216	249	WP_260758476.1 Fic/DOC family protein [Mycobacterium sp. SMC-8]	diamond	102	55.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. SMC-8
29850885	29850885	PRJNA1156092_P_NODE_28611_length_245_cov_0.895349_g28481_i0	PRJNA1156092	28611	245	0.895349	2.19360505	Microbacteriaceae bacterium	1873462	Bacteria	Bacteria	75.1	4.85e-15	NR	MCU1412684.1	1873462	g28481	i0	75.5	1.93469387755102	53	13	64.9	0	245	87	84	136	MCU1412684.1 transcriptional regulator, MarR family [Microbacteriaceae bacterium]	diamond	474	75.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae		Microbacteriaceae bacterium
30861807	30861807	PRJNA1156092_P_NODE_17354_length_282_cov_1.133971_g17224_i0	PRJNA1156092	17354	282	1.133971	3.19779822	Kitasatospora griseola	2064	Bacteria	Bacteria	42	0.0138	NR	WP_363484028.1	2064	g17224	i0	44	0.531914893617021	50	23	53.2	1	105	254	12	56	WP_363484028.1 hypothetical protein [Kitasatospora griseola]	diamond	150	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora griseola
31051665	31051665	PRJNA1156092_P_NODE_28115_length_245_cov_0.895349_g27985_i0	PRJNA1156092	28115	245	0.895349	2.19360505	Rothia nasimurium	85336	Bacteria	Bacteria	124	2.52e-32	NR	WP_237205873.1	85336	g27985	i0	71.3	0.979591836734694	80	23	98	0	2	241	261	340	WP_237205873.1 acyltransferase family protein [Rothia nasimurium]	diamond	240	124	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia nasimurium
31133659	31133659	PRJNA1156092_P_NODE_29175_length_244_cov_0.900585_g29045_i0	PRJNA1156092	29175	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	92.8	1.22e-20	NR	WP_073189279.1	72764	g29045	i0	63.9	6.36885245901639	72	26	88.5	0	1	216	59	130	WP_073189279.1 aldolase/citrate lyase family protein [Tessaracoccus bendigoensis]	diamond	1554	93.6	0.991452991452991	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Tessaracoccus	Tessaracoccus bendigoensis
31208900	31208900	PRJNA1156092_P_NODE_31095_length_242_cov_0.911243_g30965_i0	PRJNA1156092	31095	242	0.911243	2.20520806	Lawsonella	1847725	Bacteria	Bacteria	156	5.23e-46	NR	WP_290595484.1	1847725	g30965	i0	100	0.991735537190083	80	0	99.2	0	240	1	105	184	WP_290595484.1 MULTISPECIES: L-threonylcarbamoyladenylate synthase [Lawsonella]	diamond	240	156	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
32190033	32190033	PRJNA1156092_P_NODE_17378_length_282_cov_1.066986_g17248_i0	PRJNA1156092	17378	282	1.066986	3.00890052	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	44.3	0.00899	NR	MDO5533660.1	2021380	g17248	i0	46.7	1.09574468085106	45	23	46.8	1	138	7	48	92	MDO5533660.1 DUF2306 domain-containing protein [Propionibacteriaceae bacterium]	diamond	309	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
32272894	32272894	PRJNA1156092_P_NODE_24218_length_249_cov_0.875000_g24088_i0	PRJNA1156092	24218	249	0.875	2.17875	Nocardioides	1839	Bacteria	Bacteria	42.7	0.0316	NR	WP_056601398.1	1736408	g24088	i0	36.2	1.66265060240964	69	41	79.5	1	1	198	94	162	WP_056601398.1 hypothetical protein [Nocardioides sp. Soil774]	diamond	414	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. Soil774
32285235	32285235	PRJNA1156092_P_NODE_32879_length_241_cov_0.857143_g32749_i0	PRJNA1156092	32879	241	0.857143	2.06571463	Candidatus Nanopelagicales bacterium	2518612	Bacteria	Bacteria	76.3	5.76e-14	NR	MEZ5115667.1	2518612	g32749	i0	60.3	0.908713692946058	73	29	90.9	0	8	226	341	413	MEZ5115667.1 primosome assembly protein PriA [Candidatus Nanopelagicales bacterium]	diamond	219	76.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales			Candidatus Nanopelagicales bacterium
32336183	32336183	PRJNA1156092_P_NODE_27179_length_246_cov_0.890173_g27049_i0	PRJNA1156092	27179	246	0.890173	2.18982558	PVC group	1783257	Bacteria	Bacteria	88.2	3.75e-18	NR	WP_195893287.1	1187855	g27049	i0	51.9	3.03658536585366	81	36	95.1	1	236	3	60	140	WP_195893287.1 DUF4038 domain-containing protein [Nonomuraea cypriaca]	diamond	747	88.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Nonomuraea	Nonomuraea cypriaca
32443398	32443398	PRJNA1156092_P_NODE_27719_length_246_cov_0.890173_g27589_i0	PRJNA1156092	27719	246	0.890173	2.18982558	Streptomyces roseus	66430	Bacteria	Bacteria	42.4	0.0486	NR	WP_359172549.1	66430	g27589	i0	51.4	0.451219512195122	37	17	45.1	1	129	19	173	208	WP_359172549.1 hypothetical protein [Streptomyces roseus]	diamond	111	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces roseus

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