metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA720429" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA720429" 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
1193570	1193570	PRJNA720429_P_NODE_3761_length_248_cov_0.880000_g3704_i0	PRJNA720429	3761	248	0.88	2.1824	Janibacter massiliensis	2058291	Bacteria	Bacteria	176	2.84e-54	NR	WP_106818472.1	2058291	g3704	i0	100	0.991935483870968	82	0	99.2	0	2	247	57	138	WP_106818472.1 phosphoribulokinase [Janibacter massiliensis]	diamond	246	176	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter massiliensis
5813587	5813587	PRJNA720429_P_NODE_4985_length_241_cov_1.684524_g4928_i0	PRJNA720429	4985	241	1.684524	4.05970284	Gemelliphila asaccharolytica	502393	Bacteria	Bacteria	155	1.86e-43	NR	WP_066129019.1	502393	g4928	i0	87.3	21.6224066390042	79	10	98.3	0	239	3	174	252	WP_066129019.1 glycine--tRNA ligase [Gemelliphila asaccharolytica]	diamond	5211	155	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemelliphila	Gemelliphila asaccharolytica
10914045	10914045	PRJNA720429_P_NODE_5049_length_241_cov_0.916667_g4992_i0	PRJNA720429	5049	241	0.916667	2.20916747	Brevibacterium ammoniilyticum	1046555	Bacteria	Bacteria	157	1.9e-44	NR	WP_342039112.1	1046555	g4992	i0	100	0.995850622406639	80	0	99.6	0	241	2	303	382	WP_342039112.1 FAD/NAD(P)-binding oxidoreductase [Brevibacterium ammoniilyticum]	diamond	240	157	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium ammoniilyticum
13463784	13463784	PRJNA720429_P_NODE_5071_length_241_cov_0.916667_g5014_i0	PRJNA720429	5071	241	0.916667	2.20916747	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	166	1.11e-48	NR	MBK7841815.1	2711154	g5014	i0	95	0.995850622406639	80	4	99.6	0	241	2	123	202	MBK7841815.1 prolyl aminopeptidase [Candidatus Obscuribacter sp.]	diamond	240	166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
13947402	13947402	PRJNA720429_P_NODE_3191_length_251_cov_0.865169_g3134_i0	PRJNA720429	3191	251	0.865169	2.17157419	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	119	4.55e-32	NR	MEB3284465.1	2762020	g3134	i0	76	7.72111553784861	75	18	89.6	0	26	250	2	76	MEB3284465.1 nucleoside-diphosphate kinase [Candidatus Sericytochromatia bacterium]	diamond	1938	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
14739018	14739018	PRJNA720429_P_NODE_3512_length_250_cov_0.870056_g3455_i0	PRJNA720429	3512	250	0.870056	2.17514	Pseudoclavibacter sp.	1915061	Bacteria	Bacteria	157	3.03e-44	NR	HHW50759.1	1915061	g3455	i0	97.6	0.996	83	2	99.6	0	250	2	102	184	HHW50759.1 PLP-dependent aminotransferase family protein [Pseudoclavibacter sp.]	diamond	249	157	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudoclavibacter	Pseudoclavibacter sp.
16012542	16012542	PRJNA720429_P_NODE_4613_length_244_cov_0.900585_g4556_i0	PRJNA720429	4613	244	0.900585	2.1974274	Lawsonella	1847725	Bacteria	Bacteria	157	1.1799999999999999e-43	NR	WP_290598351.1	1847725	g4556	i0	100	0.983606557377049	80	0	98.4	0	3	242	301	380	WP_290598351.1 MULTISPECIES: NADH-quinone oxidoreductase subunit M [Lawsonella]	diamond	240	157	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
18561836	18561836	PRJNA720429_P_NODE_4175_length_246_cov_0.890173_g4118_i0	PRJNA720429	4175	246	0.890173	2.18982558	Lawsonella sp.	2041415	Bacteria	Bacteria	154	6.6899999999999985e-43	NR	WP_290595769.1	2041415	g4118	i0	100	0.98780487804878	81	0	98.8	0	3	245	194	274	WP_290595769.1 preprotein translocase subunit SecY [Lawsonella sp.]	diamond	243	154	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella sp.
19836921	19836921	PRJNA720429_P_NODE_4156_length_246_cov_0.890173_g4099_i0	PRJNA720429	4156	246	0.890173	2.18982558	Thermoleophilia bacterium	2026888	Bacteria	Bacteria	113	7.66e-29	NR	MBY0395625.1	2026888	g4099	i0	81	0.768292682926829	63	12	76.8	0	244	56	139	201	MBY0395625.1 hypothetical protein [Thermoleophilia bacterium]	diamond	189	113	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia				Thermoleophilia bacterium
22387423	22387423	PRJNA720429_P_NODE_3538_length_249_cov_1.397727_g3481_i0	PRJNA720429	3538	249	1.397727	3.48034023	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	108	9e-28	NR	MBX9724270.1	2364082	g3481	i0	85.2	1.46987951807229	61	9	73.5	0	1	183	110	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	366	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27209892	27209892	PRJNA720429_P_NODE_3142_length_252_cov_2.039106_g3085_i0	PRJNA720429	3142	252	2.039106	5.13854712	Microbacterium sp. NPDC016588	3364185	Bacteria	Bacteria	148	2.34e-41	NR	MFF8188021.1	3364185	g3085	i0	100	0.988095238095238	83	0	98.8	0	3	251	257	339	MFF8188021.1 daptide biosynthesis RiPP recognition protein [Microbacterium sp. NPDC016588]	diamond	249	148	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. NPDC016588
27431559	27431559	PRJNA720429_P_NODE_2543_length_275_cov_1.336634_g2486_i0	PRJNA720429	2543	275	1.336634	3.6757435	Galactobacter valiniphilus	2676122	Bacteria	Bacteria	94	5.53e-20	NR	WP_407645689.1	2676122	g2486	i0	53.3	1.96363636363636	90	38	93.8	1	6	263	1266	1355	WP_407645689.1 DEAD/DEAH box helicase [Galactobacter valiniphilus]	diamond	540	94	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Galactobacter	Galactobacter valiniphilus
27778772	27778772	PRJNA720429_P_NODE_4544_length_244_cov_0.900585_g4487_i0	PRJNA720429	4544	244	0.900585	2.1974274	Peptoniphilus lacydonensis	1673725	Bacteria	Bacteria	157	2.38e-46	NR	WP_288151060.1	1673725	g4487	i0	100	0.983606557377049	80	0	98.4	0	242	3	111	190	WP_288151060.1 methionine ABC transporter permease [Peptoniphilus lacydonensis]	diamond	240	157	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus lacydonensis
27810360	27810360	PRJNA720429_P_NODE_2464_length_278_cov_1.443902_g2407_i0	PRJNA720429	2464	278	1.443902	4.01404756	Janibacter endophyticus	2806261	Bacteria	Bacteria	175	6.5199999999999996e-52	NR	WP_204142335.1	2806261	g2407	i0	98.9	0.992805755395683	92	1	99.3	0	276	1	127	218	WP_204142335.1 NAD(P)H-binding protein [Janibacter endophyticus]	diamond	276	175	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter endophyticus
28262520	28262520	PRJNA720429_P_NODE_5126_length_241_cov_0.916667_g5069_i0	PRJNA720429	5126	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	89.4	1.31e-18	NR	MBA4077470.1	2067979	g5069	i0	65	1.99170124481328	80	27	99.6	1	2	241	83	161	MBA4077470.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	480	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
28925634	28925634	PRJNA720429_P_NODE_4028_length_247_cov_0.885057_g3971_i0	PRJNA720429	4028	247	0.885057	2.18609079	PVC group	1783257	Bacteria	Bacteria	100	6.25e-23	NR	MEE8386575.1	2026734	g3971	i0	62.5	9.77732793522267	72	27	87.4	0	217	2	44	115	MEE8386575.1 glutamine--tRNA ligase [Dehalococcoidia bacterium]	diamond	2415	100	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
29389022	29389022	PRJNA720429_P_NODE_3889_length_248_cov_0.880000_g3832_i0	PRJNA720429	3889	248	0.88	2.1824	uncultured Microbacterium sp.	191216	Bacteria	Bacteria	63.5	1.83e-9	NR	WP_296195279.1	191216	g3832	i0	97.1	0.423387096774194	35	1	42.3	0	107	3	464	498	WP_296195279.1 Stk1 family PASTA domain-containing Ser/Thr kinase [uncultured Microbacterium sp.]	diamond	105	63.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	uncultured Microbacterium sp.
29483375	29483375	PRJNA720429_P_NODE_3630_length_249_cov_0.875000_g3573_i0	PRJNA720429	3630	249	0.875	2.17875	Pseudarthrobacter sp. NPDC	1934409	Bacteria	Bacteria	139	1.78e-38	NR	WP_387552850.1	3346448	g3573	i0	79.5	1	83	17	100	0	1	249	183	265	WP_387552850.1 sugar phosphate isomerase/epimerase family protein [Pseudarthrobacter sp. NPDC058329]	diamond	249	139	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter sp. NPDC058329
29873025	29873025	PRJNA720429_P_NODE_4631_length_243_cov_1.800000_g4574_i0	PRJNA720429	4631	243	1.8	4.374	Pseudalkalibacillus	2893058	Bacteria	Bacteria	74.3	5.55e-14	NR	WP_257350261.1	163879	g4574	i0	53.3	2.74074074074074	75	34	92.6	1	243	19	107	180	WP_257350261.1 ComF family protein [Pseudalkalibacillus decolorationis]	diamond	666	74.3	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Fictibacillaceae	Pseudalkalibacillus	Pseudalkalibacillus decolorationis
29904692	29904692	PRJNA720429_P_NODE_3511_length_250_cov_0.870056_g3454_i0	PRJNA720429	3511	250	0.870056	2.17514	Microbacterium	33882	Bacteria	Bacteria	77	2.74e-14	NR	WP_292891659.1	51671	g3454	i0	91.1	1.068	45	4	54	0	114	248	248	292	WP_292891659.1 tyrosine-type recombinase/integrase [Microbacterium sp.]	diamond	267	77	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp.
30252288	30252288	PRJNA720429_P_NODE_4552_length_244_cov_0.900585_g4495_i0	PRJNA720429	4552	244	0.900585	2.1974274	Effusibacillus	1502725	Bacteria	Bacteria	72.4	8.51e-14	NR	WP_096182519.1	1348429	g4495	i0	64	1.20491803278689	50	18	61.5	0	9	158	103	152	WP_096182519.1 8-oxo-dGTP diphosphatase [Effusibacillus lacus]	diamond	294	72.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Effusibacillus	Effusibacillus lacus
30747213	30747213	PRJNA720429_P_NODE_5134_length_241_cov_0.916667_g5077_i0	PRJNA720429	5134	241	0.916667	2.20916747	uncultured Microbacterium sp.	191216	Bacteria	Bacteria	132	7.58e-34	NR	WP_298012668.1	191216	g5077	i0	95.8	0.896265560165975	72	3	89.6	0	3	218	386	457	WP_298012668.1 aconitate hydratase AcnA [uncultured Microbacterium sp.]	diamond	216	132	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	uncultured Microbacterium sp.
30778792	30778792	PRJNA720429_P_NODE_4334_length_245_cov_0.895349_g4277_i0	PRJNA720429	4334	245	0.895349	2.19360505	Rubrobacteraceae bacterium	2740537	Bacteria	Bacteria	62	3.22e-9	NR	MBA2712418.1	2740537	g4277	i0	68.9	0.551020408163265	45	14	55.1	0	9	143	200	244	MBA2712418.1 CpsD/CapB family tyrosine-protein kinase [Rubrobacteraceae bacterium]	diamond	135	62	1	Bacteria		Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae		Rubrobacteraceae bacterium
30936866	30936866	PRJNA720429_P_NODE_4734_length_243_cov_0.905882_g4677_i0	PRJNA720429	4734	243	0.905882	2.20129326	Scopulibacillus darangshiensis	442528	Bacteria	Bacteria	72.4	1.31e-12	NR	WP_132746929.1	442528	g4677	i0	63.6	0.679012345679012	55	20	67.9	0	3	167	670	724	WP_132746929.1 ribonuclease R [Scopulibacillus darangshiensis]	diamond	165	72.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Sporolactobacillaceae	Scopulibacillus	Scopulibacillus darangshiensis
31315981	31315981	PRJNA720429_P_NODE_3815_length_248_cov_0.880000_g3758_i0	PRJNA720429	3815	248	0.88	2.1824	Granulicatella elegans	137732	Bacteria	Bacteria	147	3.42e-41	NR	WP_006702678.1	137732	g3758	i0	96.4	1.00403225806452	83	2	99.2	1	247	2	126	208	WP_006702678.1 ADP-ribosylglycohydrolase family protein [Granulicatella elegans]	diamond	249	147	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
31885241	31885241	PRJNA720429_P_NODE_4037_length_247_cov_0.885057_g3980_i0	PRJNA720429	4037	247	0.885057	2.18609079	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	166	1.7499999999999999e-46	NR	WP_304161553.1	1528099	g3980	i0	100	0.995951417004049	82	0	99.6	0	246	1	194	275	WP_304161553.1 hypothetical protein [Lawsonella clevelandensis]	diamond	246	166	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
32201790	32201790	PRJNA720429_P_NODE_4938_length_242_cov_0.911243_g4881_i0	PRJNA720429	4938	242	0.911243	2.20520806	uncultured Microbacterium sp.	191216	Bacteria	Bacteria	158	2.71e-45	NR	WP_296198005.1	191216	g4881	i0	98.7	0.979338842975207	79	1	97.9	0	5	241	260	338	WP_296198005.1 sensor histidine kinase [uncultured Microbacterium sp.]	diamond	237	158	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	uncultured Microbacterium sp.

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