metadata: contig_metadata: 30 rows where analysis = "diamond", bioproject = "PRJNA1047551" and tax

30 rows where analysis = "diamond", bioproject = "PRJNA1047551" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
9102282	9102282	PRJNA1047551_S_NODE_6408_length_197_cov_1.925926_g6281_i0	PRJNA1047551	6408	197	1.925926	3.79407422	Anaerococcus ihuae	2899519	Bacteria	Bacteria	122	2.54e-30	NR	WP_236786589.1	2899519	g6281	i0	93.8	0.989847715736041	65	4	99	0	2	196	1263	1327	WP_236786589.1 SHIRT domain-containing protein [Anaerococcus ihuae]	diamond	195	122	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus ihuae
10377930	10377930	PRJNA1047551_S_NODE_6369_length_198_cov_1.079755_g6242_i0	PRJNA1047551	6369	198	1.079755	2.1379149	Anaerococcus vaginimassiliensis	2042308	Bacteria	Bacteria	77.8	1.12e-15	NR	WP_130819264.1	2042308	g6242	i0	92.3	0.984848484848485	65	2	98.5	1	3	197	33	94	WP_130819264.1 PepSY domain-containing protein [Anaerococcus vaginimassiliensis]	diamond	195	77.8	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginimassiliensis
15477469	15477469	PRJNA1047551_S_NODE_7473_length_186_cov_1.834437_g7346_i0	PRJNA1047551	7473	186	1.834437	3.41205282	Corynebacterium suicordis	203264	Bacteria	Bacteria	122	4.6e-31	NR	MBF4554160.1	1121369	g7346	i0	96.7	0.983870967741935	61	2	98.4	0	4	186	387	447	MBF4554160.1 PepSY domain-containing protein [Corynebacterium suicordis DSM 45110]	diamond	183	122	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium suicordis
19300421	19300421	PRJNA1047551_S_NODE_5036_length_216_cov_1.464088_g4909_i0	PRJNA1047551	5036	216	1.464088	3.16243008	Leptodesmis sichuanensis	2906798	Bacteria	Bacteria	75.5	6.5e-14	NR	WP_233747641.1	2906798	g4909	i0	97.4	2.63888888888889	38	1	52.8	0	15	128	369	406	WP_233747641.1 phosphoglycerate kinase [Leptodesmis sichuanensis]	diamond	570	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptodesmis	Leptodesmis sichuanensis
19300521	19300521	PRJNA1047551_S_NODE_9376_length_172_cov_1.350365_g9249_i0	PRJNA1047551	9376	172	1.350365	2.3226278	Kocuria carniphila	262208	Bacteria	Bacteria	114	3.87e-28	NR	WP_129699457.1	262208	g9249	i0	94.7	0.994186046511628	57	3	99.4	0	2	172	59	115	WP_129699457.1 anthranilate synthase component I [Kocuria carniphila]	diamond	171	114	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria carniphila
23126858	23126858	PRJNA1047551_S_NODE_2319_length_298_cov_1.920152_g2192_i0	PRJNA1047551	2319	298	1.920152	5.72205296	Cohnella sp.	1883426	Bacteria	Bacteria	165	6.96e-47	NR	WP_373231060.1	1883426	g2192	i0	80.6	0.936241610738255	93	18	93.6	0	285	7	159	251	WP_373231060.1 serine--tRNA ligase [Cohnella sp.]	diamond	279	165	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella sp.
26782207	26782207	PRJNA1047551_S_NODE_10201_length_167_cov_1.098485_g10074_i0	PRJNA1047551	10201	167	1.098485	1.83446995	Listeria monocytogenes	1639	Bacteria	Bacteria	112	1.07e-30	NR	WP_171840388.1	1639	g10074	i0	100	0.988023952095808	55	0	98.8	0	1	165	53	107	WP_171840388.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	165	112	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
27825126	27825126	PRJNA1047551_S_NODE_6224_length_199_cov_2.719512_g6097_i0	PRJNA1047551	6224	199	2.719512	5.41182888	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	87.4	3.81e-18	NR	HEX2102415.1	2586742	g6097	i0	56.1	2.95477386934673	66	29	99.5	0	198	1	502	567	HEX2102415.1 phosphoenolpyruvate carboxykinase (GTP) [Solirubrobacteraceae bacterium]	diamond	588	87.4	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
28425028	28425028	PRJNA1047551_S_NODE_8306_length_179_cov_4.576389_g8179_i0	PRJNA1047551	8306	179	4.576389	8.19173631	Staphylococcus hominis	1290	Bacteria	Bacteria	96.7	7.05e-25	NR	WP_186301786.1	1290	g8179	i0	97.8	0.770949720670391	46	1	77.1	0	40	177	1	46	WP_186301786.1 hypothetical protein [Staphylococcus hominis]	diamond	138	96.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
28488144	28488144	PRJNA1047551_S_NODE_8687_length_176_cov_6.758865_g8560_i0	PRJNA1047551	8687	176	6.758865	11.8956024	Staphylococcus aureus	1280	Bacteria	Bacteria	63.5	2.35e-11	NR	MCS4580470.1	1280	g8560	i0	100	0.715909090909091	42	0	71.6	0	9	134	1	42	MCS4580470.1 hypothetical protein [Staphylococcus aureus]	diamond	126	63.5	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
29017076	29017076	PRJNA1047551_S_NODE_9588_length_170_cov_3.162963_g9461_i0	PRJNA1047551	9588	170	3.162963	5.3770371	Actinomadura	1988	Bacteria	Bacteria	41.2	0.0354	NR	WP_176403677.1	2745202	g9461	i0	40.9	1.53529411764706	44	26	77.6	0	4	135	29	72	WP_176403677.1 GNAT family N-acetyltransferase [Actinomadura sp. BRA 177]	diamond	261	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura sp. BRA 177
29048429	29048429	PRJNA1047551_S_NODE_8788_length_176_cov_1.439716_g8661_i0	PRJNA1047551	8788	176	1.439716	2.53390016	root	1	Root_unresolved	Root_unresolved	104	3.97e-25	NR	QHG77598.1	1280	g8661	i0	98.1	1.80681818181818	53	1	90.3	0	159	1	33	85	QHG77598.1 hypothetical protein EAX85_13915 [Staphylococcus aureus]	diamond	318	104	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
29490202	29490202	PRJNA1047551_S_NODE_12190_length_156_cov_1.793388_g12063_i0	PRJNA1047551	12190	156	1.793388	2.79768528	Actinomycetes	1760	Bacteria	Bacteria	76.3	1.77e-14	NR	MEO6714109.1	1957017	g12063	i0	70.6	3.90384615384615	51	15	98.1	0	156	4	107	157	MEO6714109.1 PAS domain-containing protein [Mycobacteriales bacterium]	diamond	609	77	0.990909090909091	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales			Mycobacteriales bacterium
29750762	29750762	PRJNA1047551_S_NODE_11511_length_159_cov_2.620968_g11384_i0	PRJNA1047551	11511	159	2.620968	4.16733912	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.9	7.33e-9	NR	MBU6358537.1	2026724	g11384	i0	63.9	2.71698113207547	36	13	67.9	0	5	112	150	185	MBU6358537.1 peptidylprolyl isomerase [Chloroflexota bacterium]	diamond	432	58.9	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29909051	29909051	PRJNA1047551_S_NODE_10311_length_166_cov_1.557252_g10184_i0	PRJNA1047551	10311	166	1.557252	2.58503832	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	42.4	0.0161	NR	MBQ6039711.1	2485925	g10184	i0	50	0.686746987951807	38	19	68.7	0	143	30	163	200	MBQ6039711.1 DNA repair protein [Oscillospiraceae bacterium]	diamond	114	42.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
30224791	30224791	PRJNA1047551_S_NODE_12412_length_155_cov_1.816667_g12285_i0	PRJNA1047551	12412	155	1.816667	2.81583385	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	73.2	1.88e-14	NR	MCB9150722.1	2614250	g12285	i0	75.6	0.870967741935484	45	11	87.1	0	13	147	7	51	MCB9150722.1 hypothetical protein [Caldilineaceae bacterium]	diamond	135	73.2	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
30406691	30406691	PRJNA1047551_S_NODE_11473_length_160_cov_1.160000_g11346_i0	PRJNA1047551	11473	160	1.16	1.856	root	1	Root_unresolved	Root_unresolved	40.8	0.035	NR	WP_084666862.1	161154	g11346	i0	50	10.78125	46	23	86.3	0	6	143	24	69	WP_084666862.1 50S ribosomal protein L9 [Thermanaeromonas toyohensis]	diamond	1725	41.2	0.990291262135922	Bacteria		Bacillati	Bacillota	Clostridia	Neomoorellales	Neomoorellaceae	Thermanaeromonas	Thermanaeromonas toyohensis
30406692	30406692	PRJNA1047551_S_NODE_1473_length_366_cov_4.027190_g1346_i0	PRJNA1047551	1473	366	4.02719	14.7395154	root	1	Root_unresolved	Root_unresolved	135	2.64e-37	NR	MFN4968560.1	1153	g1346	i0	84.9	5.5327868852459	73	11	59.8	0	366	148	110	182	MFN4968560.1 peroxiredoxin [Pseudanabaena sp.]	diamond	2025	136	0.992647058823529	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
30603894	30603894	PRJNA1047551_S_NODE_7453_length_186_cov_2.264901_g7326_i0	PRJNA1047551	7453	186	2.264901	4.21271586	Amycolatopsis suaedae	2510978	Bacteria	Bacteria	42.4	0.0233	NR	WP_130474293.1	2510978	g7326	i0	39.7	0.935483870967742	58	35	93.5	0	9	182	117	174	WP_130474293.1 aldose 1-epimerase family protein [Amycolatopsis suaedae]	diamond	174	42.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis suaedae
30635408	30635408	PRJNA1047551_S_NODE_11873_length_158_cov_1.186992_g11746_i0	PRJNA1047551	11873	158	1.186992	1.87544736	Corynebacterium bouchesdurhonense	1720192	Bacteria	Bacteria	54.7	6.94e-8	NR	WP_078056841.1	1720192	g11746	i0	96.7	0.569620253164557	30	1	57	0	109	20	1	30	WP_078056841.1 DUF2516 family protein [Corynebacterium bouchesdurhonense]	diamond	90	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium bouchesdurhonense
31046614	31046614	PRJNA1047551_S_NODE_3755_length_243_cov_1.543269_g3628_i0	PRJNA1047551	3755	243	1.543269	3.75014367	Varibaculum cambriense	184870	Bacteria	Bacteria	43.1	0.0277	NR	WP_060920419.1	184870	g3628	i0	39.5	0.530864197530864	43	25	51.9	1	209	84	1457	1499	WP_060920419.1 InlB B-repeat-containing protein [Varibaculum cambriense]	diamond	129	43.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Varibaculum	Varibaculum cambriense
31299179	31299179	PRJNA1047551_S_NODE_7835_length_183_cov_1.756757_g7708_i0	PRJNA1047551	7835	183	1.756757	3.21486531	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	42	0.0326	NR	MEN6570425.1	2024896	g7708	i0	37.9	0.950819672131147	58	35	93.4	1	10	180	148	205	MEN6570425.1 copper-translocating P-type ATPase [Anaerolineaceae bacterium]	diamond	174	42	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
31330745	31330745	PRJNA1047551_S_NODE_2736_length_277_cov_2.227273_g2609_i0	PRJNA1047551	2736	277	2.227273	6.16954621	unclassified Modestobacter	2643866	Bacteria	Bacteria	44.3	0.0156	NR	WP_269172644.1	2643866	g2609	i0	36.8	1.02888086642599	95	40	83.4	4	34	264	263	355	WP_269172644.1 MULTISPECIES: DUF1015 domain-containing protein [unclassified Modestobacter]	diamond	285	44.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter
32335329	32335329	PRJNA1047551_S_NODE_1819_length_332_cov_3.845118_g1692_i0	PRJNA1047551	1819	332	3.845118	12.76579176	FCB group	1783270	Bacteria	Bacteria	49.3	4.63e-4	NR	WP_299721421.1	2023260	g1692	i0	46.2	3.31626506024096	52	28	47	0	309	154	152	203	WP_299721421.1 ankyrin repeat domain-containing protein [Megasphaera sp.]	diamond	1101	49.3	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera sp.
32533220	32533220	PRJNA1047551_S_NODE_9919_length_168_cov_2.240602_g9792_i0	PRJNA1047551	9919	168	2.240602	3.76421136	Acidimicrobiaceae bacterium	2024894	Bacteria	Bacteria	43.9	0.00516	NR	MEY2588768.1	2024894	g9792	i0	46.3	0.732142857142857	41	21	71.4	1	14	133	70	110	MEY2588768.1 hypothetical protein [Acidimicrobiaceae bacterium]	diamond	123	43.9	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Acidimicrobiaceae		Acidimicrobiaceae bacterium
32596237	32596237	PRJNA1047551_S_NODE_5420_length_210_cov_1.834286_g5293_i0	PRJNA1047551	5420	210	1.834286	3.8520006	Priestia flexa	86664	Bacteria	Bacteria	51.6	2.93e-6	NR	WP_025910747.1	86664	g5293	i0	51.3	2.72857142857143	39	19	55.7	0	16	132	70	108	WP_025910747.1 hypothetical protein [Priestia flexa]	diamond	573	51.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia flexa
32722122	32722122	PRJNA1047551_S_NODE_7400_length_187_cov_1.434211_g7273_i0	PRJNA1047551	7400	187	1.434211	2.68197457	Kitasatospora sp. NPDC	1871188	Bacteria	Bacteria	40.8	0.0171	NR	WP_380269986.1	3346001	g7273	i0	48.6	0.593582887700535	37	19	59.4	0	60	170	42	78	WP_380269986.1 NUDIX domain-containing protein [Kitasatospora sp. NPDC057015]	diamond	111	40.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora sp. NPDC057015
32753555	32753555	PRJNA1047551_S_NODE_2420_length_292_cov_7.210117_g2293_i0	PRJNA1047551	2420	292	7.210117	21.05354164	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	45.8	0.001	NR	HYU73127.1	2740538	g2293	i0	42.6	0.626712328767123	61	32	59.6	1	60	233	35	95	HYU73127.1 hypothetical protein [Ktedonobacteraceae bacterium]	diamond	183	45.8	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
32816489	32816489	PRJNA1047551_S_NODE_8460_length_178_cov_2.573427_g8333_i0	PRJNA1047551	8460	178	2.573427	4.58070006	Bacillus	1386	Bacteria	Bacteria	42.7	0.0118	NR	WP_061687875.1	1386	g8333	i0	54.8	0.52247191011236	31	14	52.2	0	1	93	91	121	WP_061687875.1 MULTISPECIES: lecithin retinol acyltransferase family protein [Bacillus]	diamond	93	42.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
32847979	32847979	PRJNA1047551_S_NODE_13060_length_152_cov_4.623932_g12933_i0	PRJNA1047551	13060	152	4.623932	7.02837664	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	46.2	3.34e-4	NR	HEY4608371.1	2497619	g12933	i0	88	0.493421052631579	25	3	49.3	0	151	77	137	161	HEY4608371.1 OsmC family peroxiredoxin [Ilumatobacteraceae bacterium]	diamond	75	46.2	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium

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