metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA562549" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA562549" 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
1821468	1821468	PRJNA562549_P_NODE_32662_length_209_cov_0.878378_g32429_i0	PRJNA562549	32662	209	0.878378	1.83581002	Actinomycetota bacterium	2900548	Bacteria	Bacteria	117	1.7000000000000003e-28	NR	MBS1889877.1	2900548	g32429	i0	76.8	0.990430622009569	69	16	99	0	208	2	240	308	MBS1889877.1 hypothetical protein [Actinomycetota bacterium]	diamond	207	117	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
12024913	12024913	PRJNA562549_P_NODE_36010_length_203_cov_0.915493_g35777_i0	PRJNA562549	36010	203	0.915493	1.85845079	Chloroflexota bacterium	2026724	Bacteria	Bacteria	120	9.26e-30	NR	MEM7112781.1	2026724	g35777	i0	76.1	5.94088669950739	67	16	99	0	1	201	391	457	MEM7112781.1 NADP-dependent isocitrate dehydrogenase [Chloroflexota bacterium]	diamond	1206	120	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
22222851	22222851	PRJNA562549_P_NODE_32638_length_209_cov_0.878378_g32405_i0	PRJNA562549	32638	209	0.878378	1.83581002	Bacteria	2	Bacteria	Bacteria	106	1.18e-25	NR	WP_123304045.1	56055	g32405	i0	69.6	3.96172248803828	69	21	99	0	209	3	133	201	WP_123304045.1 malate dehydrogenase [Bogoriella caseilytica]	diamond	828	106	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Bogoriellaceae	Bogoriella	Bogoriella caseilytica
26826195	26826195	PRJNA562549_P_NODE_38181_length_190_cov_2.015504_g37948_i0	PRJNA562549	38181	190	2.015504	3.8294576	Moorena sp. SIO2I5	2607825	Bacteria	Bacteria	60.5	1.7e-9	NR	NEQ85256.1	2607825	g37948	i0	39.7	7.83157894736842	63	38	99.5	0	190	2	83	145	NEQ85256.1 protein kinase [Moorena sp. SIO2I5]	diamond	1488	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIO2I5
27079158	27079158	PRJNA562549_P_NODE_31122_length_212_cov_0.993377_g30889_i0	PRJNA562549	31122	212	0.993377	2.10595924	Actinomycetota bacterium	2900548	Bacteria	Bacteria	44.7	0.00514	NR	MDQ1548034.1	2900548	g30889	i0	43.1	1.42924528301887	51	28	72.2	1	50	202	23	72	MDQ1548034.1 hypothetical protein [Actinomycetota bacterium]	diamond	303	44.7	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
27110564	27110564	PRJNA562549_P_NODE_24222_length_238_cov_1.819209_g23989_i0	PRJNA562549	24222	238	1.819209	4.32971742	Luedemannella flava	349316	Bacteria	Bacteria	43.9	0.00426	NR	MFC7480816.1	349316	g23989	i0	34.7	1.81512605042017	72	39	90.8	2	237	22	28	91	MFC7480816.1 hypothetical protein [Luedemannella flava]	diamond	432	43.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Luedemannella	Luedemannella flava
27458537	27458537	PRJNA562549_P_NODE_20823_length_255_cov_2.505155_g20590_i0	PRJNA562549	20823	255	2.505155	6.38814525	Anaerolineae bacterium	2052143	Bacteria	Bacteria	45.1	0.00661	NR	MCB0164638.1	2052143	g20590	i0	34.3	0.823529411764706	70	45	82.4	1	221	12	276	344	MCB0164638.1 protein kinase [Anaerolineae bacterium]	diamond	210	45.1	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27616359	27616359	PRJNA562549_P_NODE_33204_length_208_cov_0.884354_g32971_i0	PRJNA562549	33204	208	0.884354	1.83945632	Bacillota bacterium	1879010	Bacteria	Bacteria	46.2	4.84e-4	NR	HYH05358.1	1879010	g32971	i0	56.3	0.461538461538462	32	13	44.7	1	10	102	84	115	HYH05358.1 hypothetical protein [Bacillota bacterium]	diamond	96	46.2	1	Bacteria		Bacillati	Bacillota					Bacillota bacterium
28310980	28310980	PRJNA562549_P_NODE_33886_length_207_cov_0.890411_g33653_i0	PRJNA562549	33886	207	0.890411	1.84315077	Propioniciclava sp.	2038686	Bacteria	Bacteria	68.9	1.37e-11	NR	WP_415103230.1	2038686	g33653	i0	58.5	0.942028985507246	65	24	94.2	2	1	195	491	552	WP_415103230.1 S-layer homology domain-containing protein [Propioniciclava sp.]	diamond	195	68.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propioniciclava	Propioniciclava sp.
28721429	28721429	PRJNA562549_P_NODE_35227_length_204_cov_1.580420_g34994_i0	PRJNA562549	35227	204	1.58042	3.2240568	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	94.4	3.4300000000000004e-21	NR	MBX9694561.1	2847862	g34994	i0	69.1	1	68	20	98.5	1	203	3	88	155	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	204	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28798153	28798153	PRJNA562549_P_NODE_36467_length_202_cov_0.921986_g36234_i0	PRJNA562549	36467	202	0.921986	1.86241172	root	1	Root_unresolved	Root_unresolved	53.9	1.37e-6	NR	WP_204516196.1	1125967	g36234	i0	43.4	5.64356435643564	53	30	78.7	0	172	14	106	158	WP_204516196.1 DsbA family oxidoreductase [Brevibacillus fulvus]	diamond	1140	53.9	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus
28974102	28974102	PRJNA562549_P_NODE_5068_length_510_cov_9.062361_g4843_i0	PRJNA562549	5068	510	9.062361	46.2180411	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	68.6	9.29e-12	NR	WP_252130143.1	1590	g4843	i0	80	2.11764705882353	40	8	23.5	0	510	391	50	89	WP_252130143.1 hypothetical protein, partial [Lactiplantibacillus plantarum]	diamond	1080	68.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
29068785	29068785	PRJNA562549_P_NODE_12588_length_323_cov_2.347328_g12355_i0	PRJNA562549	12588	323	2.347328	7.58186944	Amycolatopsis sp. lyj-23	2789283	Bacteria	Bacteria	45.1	0.0134	NR	WP_410591092.1	2789283	g12355	i0	38.3	0.891640866873065	47	29	43.7	0	250	110	81	127	WP_410591092.1 hypothetical protein [Amycolatopsis sp. lyj-23]	diamond	288	45.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. lyj-23
29226782	29226782	PRJNA562549_P_NODE_35929_length_203_cov_0.915493_g35696_i0	PRJNA562549	35929	203	0.915493	1.85845079	Actinomycetota bacterium	2900548	Bacteria	Bacteria	115	7.419999999999999e-31	NR	MBS1889790.1	2900548	g35696	i0	83.1	0.960591133004926	65	11	96.1	0	203	9	97	161	MBS1889790.1 MC/SLC25 family protein [Actinomycetota bacterium]	diamond	195	115	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
29289603	29289603	PRJNA562549_P_NODE_32069_length_210_cov_0.872483_g31836_i0	PRJNA562549	32069	210	0.872483	1.8322143	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	52.4	9.51e-6	NR	HEX2680356.1	2052315	g31836	i0	44.6	1.94285714285714	65	36	92.9	0	209	15	271	335	HEX2680356.1 hypothetical protein [Candidatus Dormiibacterota bacterium]	diamond	408	52.4	1	Bacteria		Bacillati	Candidatus Dormiibacterota					Candidatus Dormiibacterota bacterium
29636626	29636626	PRJNA562549_P_NODE_36410_length_202_cov_0.921986_g36177_i0	PRJNA562549	36410	202	0.921986	1.86241172	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	42	0.0414	NR	HLZ94079.1	2052315	g36177	i0	36.2	0.861386138613861	58	34	86.1	1	22	195	431	485	HLZ94079.1 phospholipid carrier-dependent glycosyltransferase [Candidatus Dormiibacterota bacterium]	diamond	174	42	1	Bacteria		Bacillati	Candidatus Dormiibacterota					Candidatus Dormiibacterota bacterium
29699691	29699691	PRJNA562549_P_NODE_14930_length_298_cov_1.097046_g14697_i0	PRJNA562549	14930	298	1.097046	3.26919708	Leptolyngbya sp. SIOISBB	2607771	Bacteria	Bacteria	47.8	9e-4	NR	NEQ45092.1	2607771	g14697	i0	41.3	1.22818791946309	63	36	63.4	1	54	242	145	206	NEQ45092.1 glutathione S-transferase family protein [Leptolyngbya sp. SIOISBB]	diamond	366	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIOISBB
29763142	29763142	PRJNA562549_P_NODE_34551_length_205_cov_2.277778_g34318_i0	PRJNA562549	34551	205	2.277778	4.6694449	Streptosporangium roseum	2001	Bacteria	Bacteria	42	0.0297	NR	WP_352036708.1	2001	g34318	i0	48.4	0.453658536585366	31	16	45.4	0	188	96	114	144	WP_352036708.1 hypothetical protein [Streptosporangium roseum]	diamond	93	42	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Streptosporangium	Streptosporangium roseum
30805897	30805897	PRJNA562549_P_NODE_32034_length_210_cov_0.872483_g31801_i0	PRJNA562549	32034	210	0.872483	1.8322143	Exiguobacterium mexicanum	340146	Bacteria	Bacteria	123	6.879999999999999e-34	NR	MFN3367734.1	340146	g31801	i0	97.1	1	70	2	100	0	210	1	89	158	MFN3367734.1 hypothetical protein [Exiguobacterium mexicanum]	diamond	210	123	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium mexicanum
31090161	31090161	PRJNA562549_P_NODE_15455_length_293_cov_1.607759_g15222_i0	PRJNA562549	15455	293	1.607759	4.71073387	Leucobacter sp. PH1c	1397278	Bacteria	Bacteria	62.8	6.16e-9	NR	WP_025134996.1	1397278	g15222	i0	39	0.839590443686007	82	47	80.9	2	260	24	400	481	WP_025134996.1 hypothetical protein [Leucobacter sp. PH1c]	diamond	246	62.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter sp. PH1c
31184735	31184735	PRJNA562549_P_NODE_34855_length_205_cov_0.902778_g34622_i0	PRJNA562549	34855	205	0.902778	1.8506949	Clostridium sp.	1506	Bacteria	Bacteria	45.1	0.00355	NR	WP_333887201.1	1506	g34622	i0	41.3	0.673170731707317	46	27	67.3	0	204	67	579	624	WP_333887201.1 hypothetical protein [Clostridium sp.]	diamond	138	45.1	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
31388764	31388764	PRJNA562549_P_NODE_28716_length_220_cov_1.635220_g28483_i0	PRJNA562549	28716	220	1.63522	3.597484	root	1	Root_unresolved	Root_unresolved	42	0.0128	NR	WP_209133263.1	1219	g28483	i0	37.5	6.04090909090909	48	30	65.5	0	144	1	22	69	WP_209133263.1 4a-hydroxytetrahydrobiopterin dehydratase [Prochlorococcus marinus]	diamond	1329	42.4	0.990566037735849	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
31501464	31501464	PRJNA562549_P_NODE_33816_length_207_cov_0.890411_g33583_i0	PRJNA562549	33816	207	0.890411	1.84315077	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	128	1.18e-33	NR	MBJ7460789.1	2497619	g33583	i0	98.5	0.985507246376812	68	1	98.6	0	3	206	209	276	MBJ7460789.1 ABC transporter substrate-binding protein [Ilumatobacteraceae bacterium]	diamond	204	128	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium
32387074	32387074	PRJNA562549_P_NODE_30159_length_215_cov_1.636364_g29926_i0	PRJNA562549	30159	215	1.636364	3.5181826	Clostridia bacterium	2044939	Bacteria	Bacteria	42	0.049	NR	MBR3739319.1	2044939	g29926	i0	41.7	0.669767441860465	48	27	65.6	1	44	184	506	553	MBR3739319.1 GNAT family N-acetyltransferase [Clostridia bacterium]	diamond	144	42	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
32387078	32387078	PRJNA562549_P_NODE_32119_length_210_cov_0.872483_g31886_i0	PRJNA562549	32119	210	0.872483	1.8322143	Cutibacterium granulosum	33011	Bacteria	Bacteria	118	1.38e-32	NR	PZP18157.1	33011	g31886	i0	98.2	0.814285714285714	57	1	81.4	0	39	209	1	57	PZP18157.1 MAG: hypothetical protein DI600_09895 [Cutibacterium granulosum]	diamond	171	118	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
32797031	32797031	PRJNA562549_P_NODE_24400_length_237_cov_2.215909_g24167_i0	PRJNA562549	24400	237	2.215909	5.25170433	Gordoniibacillus kamchatkensis	1590651	Bacteria	Bacteria	57	1.38e-7	NR	WP_041047251.1	1590651	g24167	i0	40.3	1.86075949367089	77	45	97.5	1	5	235	19	94	WP_041047251.1 hypothetical protein [Gordoniibacillus kamchatkensis]	diamond	441	57	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Gordoniibacillus	Gordoniibacillus kamchatkensis

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