metadata: contig_metadata: 29 rows where bioproject = "PRJNA816527" and tax

29 rows where bioproject = "PRJNA816527" 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
819415	819415	PRJNA816527_P_NODE_17381_length_250_cov_0.870056_g17331_i0	PRJNA816527	17381	250	0.870056	2.17514	Leifsonia xyli	1575	Bacteria	Bacteria	268	2.07e-67	NTclustered	gi\|1029984024\|gb\|CP014761.1\|	1575	g17331	i0	86.111	50.816	252	31	100	4	1	250	3534480	3534231	Leifsonia xyli strain SE134 chromosome, complete genome	blastn	12704	268	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia xyli
1227916	1227916	PRJNA816527_P_NODE_16261_length_256_cov_1.983607_g16211_i0	PRJNA816527	16261	256	1.983607	5.07803392	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	154	3.56e-41	NR	PZP88466.1	1528099	g16211	i0	100	1.96875	84	0	98.4	0	254	3	251	334	PZP88466.1 MAG: cation:proton antiporter [Lawsonella clevelandensis]	diamond	504	154	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
2094958	2094958	PRJNA816527_P_NODE_16502_length_253_cov_2.233333_g16452_i0	PRJNA816527	16502	253	2.233333	5.65033249	Actinomyces radicidentis	111015	Bacteria	Bacteria	392	1.1899999999999997e-104	NTclustered	gi\|987450852\|gb\|CP014228.1\|	111015	g16452	i0	94.531	3.68379446640316	256	11	100	1	1	253	1232330	1232585	Actinomyces radicidentis strain CCUG 36733 chromosome, complete genome	blastn	932	392	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces radicidentis
3779829	3779829	PRJNA816527_P_NODE_14503_length_275_cov_2.089109_g14453_i0	PRJNA816527	14503	275	2.089109	5.74504975	Rhodococcus	1827	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g14453	i0	99.636	56.2909090909091	275	1	100	0	1	275	1752283	1752557	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	15480	508	0.990157480314961	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
3779868	3779868	PRJNA816527_P_NODE_20383_length_241_cov_1.559524_g20333_i0	PRJNA816527	20383	241	1.559524	3.75845284	Corynebacterium	1716	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|171191170\|gb\|EU373370.1\|	1717	g20333	i0	99.585	190.03734439834	241	1	100	0	1	241	1320	1080	Corynebacterium diphtheriae strain TPL03 16S ribosomal RNA gene, partial sequence	blastn	45799	440	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium diphtheriae
7197506	7197506	PRJNA816527_P_NODE_14726_length_273_cov_1.505000_g14676_i0	PRJNA816527	14726	273	1.505	4.10865	Corynebacterium sp. ED61	2211360	Bacteria	Bacteria	150	4.32e-40	NR	WP_194186892.1	2211360	g14676	i0	92.5	0.879120879120879	80	6	87.9	0	33	272	1	80	WP_194186892.1 ATP-dependent DNA helicase UvrD2 [Corynebacterium sp. ED61]	diamond	240	150	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. ED61
7197565	7197565	PRJNA816527_P_NODE_16606_length_252_cov_1.446927_g16556_i0	PRJNA816527	16606	252	1.446927	3.64625604	Leifsonia sp. WHRI 6310E	3162562	Bacteria	Bacteria	294	3.44e-75	NTclustered	gi\|2801868331\|gb\|CP168169.1\|	3162562	g16556	i0	87.698	99.7619047619048	252	31	100	0	1	252	2437065	2436814	Leifsonia sp. WHRI 6310E chromosome, complete genome	blastn	25140	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. WHRI 6310E
9747555	9747555	PRJNA816527_P_NODE_20368_length_241_cov_1.833333_g20318_i0	PRJNA816527	20368	241	1.833333	4.41833253	Leifsonia shinshuensis	150026	Bacteria	Bacteria	137	1.91e-35	NR	WP_179604217.1	150026	g20318	i0	87.5	2.95020746887967	80	10	99.6	0	240	1	542	621	WP_179604217.1 flagellar biosynthesis protein FlhA [Leifsonia shinshuensis]	diamond	711	137	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis
11023112	11023112	PRJNA816527_P_NODE_14129_length_279_cov_2.135922_g14079_i0	PRJNA816527	14129	279	2.135922	5.95922238	Leifsonia shinshuensis	150026	Bacteria	Bacteria	285	2.3299999999999997e-72	NTclustered	gi\|1890941476\|gb\|CP043641.1\|	150026	g14079	i0	85.816	9.2831541218638	282	25	100	5	1	279	3508873	3509142	Leifsonia shinshuensis strain INR9 chromosome, complete genome	blastn	2590	285	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis
12298689	12298689	PRJNA816527_P_NODE_19990_length_242_cov_1.828402_g19940_i0	PRJNA816527	19990	242	1.828402	4.42473284	Microbacterium maritypicum	33918	Bacteria	Bacteria	226	1.2099999999999997e-54	NTclustered	gi\|2274432258\|gb\|CP101471.1\|	33918	g19940	i0	95.775	16.595041322314	142	3	58	2	102	241	1598023	1598163	Microbacterium maritypicum strain DND4 chromosome, complete genome	blastn	4016	226	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
15256038	15256038	PRJNA816527_P_NODE_7392_length_380_cov_2.524430_g7342_i0	PRJNA816527	7392	380	2.52443	9.592834	Corynebacterium	1716	Bacteria	Bacteria	697	0	NTclustered	gi\|2894611912\|gb\|PV018956.1\|	1720	g7342	i0	99.737	100	380	1	100	0	1	380	705	326	Corynebacterium sp. strain LMT-16 16S ribosomal RNA gene, partial sequence	blastn	38000	697	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp.
17397833	17397833	PRJNA816527_P_NODE_18954_length_245_cov_1.674419_g18904_i0	PRJNA816527	18954	245	1.674419	4.10232655	Citricoccus nitrophenolicus	863575	Bacteria	Bacteria	315	2.55e-81	NTclustered	gi\|2895617228\|gb\|CP063070.1\|	863575	g18904	i0	89.796	1	245	25	100	0	1	245	3109707	3109463	Citricoccus nitrophenolicus strain B1 chromosome, complete genome	blastn	245	315	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Citricoccus	Citricoccus nitrophenolicus
17397887	17397887	PRJNA816527_P_NODE_20794_length_228_cov_2.522581_g20744_i0	PRJNA816527	20794	228	2.522581	5.75148468	Micrococcus yunnanensis	566027	Bacteria	Bacteria	307	3.9300000000000005e-79	NTclustered	gi\|2506638323\|gb\|CP125290.1\|	566027	g20744	i0	91.15	49.7280701754386	226	20	99	0	1	226	800883	800658	Micrococcus yunnanensis strain TJPT4 chromosome, complete genome	blastn	11338	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus yunnanensis
19946065	19946065	PRJNA816527_P_NODE_19636_length_243_cov_2.652941_g19586_i0	PRJNA816527	19636	243	2.652941	6.44664663	Leifsonia shinshuensis	150026	Bacteria	Bacteria	272	1.5399999999999998e-68	NTclustered	gi\|1890941476\|gb\|CP043641.1\|	150026	g19586	i0	86.831	3.5843621399177	243	32	100	0	1	243	1328716	1328474	Leifsonia shinshuensis strain INR9 chromosome, complete genome	blastn	871	272	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis
21221436	21221436	PRJNA816527_P_NODE_15797_length_261_cov_2.015957_g15747_i0	PRJNA816527	15797	261	2.0159570000000002	5.26164777	Microbacterium proteolyticum	1572644	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|2482566189\|gb\|CP121274.1\|	1572644	g15747	i0	100	2	261	0	100	0	1	261	185126	184866	Microbacterium proteolyticum strain ustc chromosome, complete genome	blastn	522	483	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
22496161	22496161	PRJNA816527_P_NODE_16598_length_252_cov_1.720670_g16548_i0	PRJNA816527	16598	252	1.72067	4.3360884	Nakamurella multipartita	53461	Bacteria	Bacteria	239	1.6300000000000002e-58	NTclustered	gi\|258553496\|gb\|CP001737.1\|	479431	g16548	i0	83.73	100.615079365079	252	41	100	0	1	252	4403800	4404051	Nakamurella multipartita DSM 44233 chromosome, complete genome	blastn	25355	239	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Nakamurellales	Nakamurellaceae	Nakamurella	Nakamurella multipartita
25045621	25045621	PRJNA816527_P_NODE_13060_length_290_cov_1.419355_g13010_i0	PRJNA816527	13060	290	1.419355	4.1161295	Leifsonia sp. ZF2019	2781978	Bacteria	Bacteria	320	6.67e-83	NTclustered	gi\|2093112753\|gb\|CP065037.1\|	2781978	g13010	i0	89.412	35.2034482758621	255	26	88	1	37	290	2185897	2185643	Leifsonia sp. ZF2019 chromosome, complete genome	blastn	10209	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. ZF2019
25454549	25454549	PRJNA816527_P_NODE_14840_length_272_cov_1.266332_g14790_i0	PRJNA816527	14840	272	1.266332	3.44442304	Leifsonia	110932	Bacteria	Bacteria	289	1.75e-73	NTclustered	gi\|1890941476\|gb\|CP043641.1\|	150026	g14790	i0	92.195	72.3125	205	15	75	1	1	204	1010396	1010600	Leifsonia shinshuensis strain INR9 chromosome, complete genome	blastn	19669	289	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis
26642792	26642792	PRJNA816527_P_NODE_19561_length_244_cov_0.900585_g19511_i0	PRJNA816527	19561	244	0.900585	2.1974274	Microbacterium keratanolyticum	67574	Bacteria	Bacteria	138	1.86e-39	NR	WP_204938489.1	67574	g19511	i0	93.8	0.983606557377049	80	5	98.4	0	4	243	10	89	WP_204938489.1 PH domain-containing protein [Microbacterium keratanolyticum]	diamond	240	138	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium keratanolyticum
26999648	26999648	PRJNA816527_P_NODE_13622_length_284_cov_2.146919_g13572_i0	PRJNA816527	13622	284	2.146919	6.09724996	Leifsonia	110932	Bacteria	Bacteria	178	1.72e-49	NR	WP_208038931.1	2815212	g13572	i0	83.2	2.38732394366197	113	0	99.3	1	283	2	448	560	WP_208038931.1 lamin tail domain-containing protein [Leifsonia sp. TF02-11]	diamond	678	178	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
27433927	27433927	PRJNA816527_P_NODE_13843_length_282_cov_1.473684_g13793_i0	PRJNA816527	13843	282	1.473684	4.15578888	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	104	4.36e-26	NR	WP_252940792.1	2841670	g13793	i0	55.6	1.0531914893617	99	38	98.9	1	280	2	2	100	WP_252940792.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	297	104	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
27781109	27781109	PRJNA816527_P_NODE_13024_length_290_cov_2.124424_g12974_i0	PRJNA816527	13024	290	2.124424	6.1608296	Rubrobacter sp.	2036010	Bacteria	Bacteria	62.4	7.67e-9	NR	HEX5849274.1	2036010	g12974	i0	58.7	0.651724137931034	63	25	65.2	1	264	76	278	339	HEX5849274.1 choice-of-anchor P family protein [Rubrobacter sp.]	diamond	189	62.4	1	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter sp.
27875642	27875642	PRJNA816527_P_NODE_14345_length_277_cov_1.509804_g14295_i0	PRJNA816527	14345	277	1.509804	4.18215708	Bifidobacteriales bacterium	2478472	Bacteria	Bacteria	179	1.4699999999999995e-55	NR	MCT6839224.1	2478472	g14295	i0	100	0.985559566787004	91	0	98.6	0	275	3	81	171	MCT6839224.1 hypothetical protein [Bifidobacteriales bacterium]	diamond	273	179	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales			Bifidobacteriales bacterium
28538985	28538985	PRJNA816527_P_NODE_19307_length_244_cov_1.350877_g19257_i0	PRJNA816527	19307	244	1.350877	3.29613988	Leifsonia sp. TF	1870902	Bacteria	Bacteria	165	6.31e-47	NR	WP_208040258.1	2815212	g19257	i0	100	0.995901639344262	81	0	99.6	0	243	1	250	330	WP_208040258.1 Ig domain-containing protein [Leifsonia sp. TF02-11]	diamond	243	165	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
28642326	28642326	PRJNA816527_P_NODE_15887_length_260_cov_2.192513_g15837_i0	PRJNA816527	15887	260	2.192513	5.7005338	Microbacteriaceae	85023	Bacteria	Bacteria	148	2.39e-41	NR	WP_345834199.1	3144404	g15837	i0	90.7	2.97692307692308	86	8	99.2	0	2	259	189	274	WP_345834199.1 type VII secretion protein EssB [Microbacterium sp. X-17]	diamond	774	148	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. X-17
28831513	28831513	PRJNA816527_P_NODE_18748_length_246_cov_0.890173_g18698_i0	PRJNA816527	18748	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	157	8.009999999999998e-47	NR	MCT6837646.1	2478472	g18698	i0	100	1.8780487804878	77	0	93.9	0	3	233	102	178	MCT6837646.1 isoprenylcysteine carboxylmethyltransferase family protein [Bifidobacteriales bacterium]	diamond	462	157	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales			Bifidobacteriales bacterium
29021392	29021392	PRJNA816527_P_NODE_14708_length_273_cov_1.540000_g14658_i0	PRJNA816527	14708	273	1.54	4.2042	Leifsonia	110932	Bacteria	Bacteria	179	2.95e-51	NR	WP_243768796.1	2815212	g14658	i0	100	2	91	0	100	0	273	1	34	124	WP_243768796.1 amylo-alpha-1,6-glucosidase [Leifsonia sp. TF02-11]	diamond	546	179	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
29359791	29359791	PRJNA816527_P_NODE_19369_length_244_cov_0.900585_g19319_i0	PRJNA816527	19369	244	0.900585	2.1974274	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	145	2.03e-38	NR	WP_252941023.1	2841670	g19319	i0	79	0.995901639344262	81	17	99.6	0	244	2	16	96	WP_252941023.1 DUF7193 family protein [Streptomyces sp. CHB9.2]	diamond	243	145	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
29643512	29643512	PRJNA816527_P_NODE_17570_length_249_cov_0.875000_g17520_i0	PRJNA816527	17570	249	0.875	2.17875	Leifsonia sp. TF	1870902	Bacteria	Bacteria	86.3	1.09e-17	NR	WP_243768267.1	2815212	g17520	i0	100	0.457831325301205	38	0	45.8	0	1	114	333	370	WP_243768267.1 Lrp/AsnC family transcriptional regulator [Leifsonia sp. TF02-11]	diamond	114	86.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11

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