metadata: contig_metadata: 25 rows where analysis = "diamond", bioproject = "PRJNA1136957" and tax

25 rows where analysis = "diamond", bioproject = "PRJNA1136957" 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
21961349	21961349	PRJNA1136957_S_NODE_1698_length_498_cov_19.769932_g1602_i0	PRJNA1136957	1698	498	19.769932	98.45426136	root	1	Root_unresolved	Root_unresolved	171	6.64e-51	NR	MDJ8942385.1	1502	g1602	i0	79.4	1.8433734939759	102	21	61.4	0	495	190	94	195	MDJ8942385.1 hypothetical protein [Clostridium perfringens]	diamond	918	171	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
24510525	24510525	PRJNA1136957_S_NODE_1560_length_510_cov_148.902439_g1465_i0	PRJNA1136957	1560	510	148.902439	759.4024389	root	1	Root_unresolved	Root_unresolved	187	3.2800000000000004e-58	NR	MRC56835.1	1428	g1465	i0	80	12.7117647058824	115	22	67.6	1	447	103	10	123	MRC56835.1 50S ribosomal protein L30e [Bacillus thuringiensis]	diamond	6483	188	0.99468085106383	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
26721759	26721759	PRJNA1136957_S_NODE_15341_length_222_cov_1.460123_g15244_i0	PRJNA1136957	15341	222	1.460123	3.24147306	unclassified Streptomyces	2593676	Bacteria	Bacteria	43.1	0.02	NR	WP_241842784.1	2593676	g15244	i0	46.9	0.662162162162162	49	24	63.5	1	199	59	26	74	WP_241842784.1 MULTISPECIES: hypothetical protein [unclassified Streptomyces]	diamond	147	43.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
26849038	26849038	PRJNA1136957_S_NODE_10201_length_267_cov_1.461538_g10104_i0	PRJNA1136957	10201	267	1.461538	3.90230646	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	73.6	2.07e-14	NR	WP_187150461.1	432608	g10104	i0	97.2	0.404494382022472	36	1	40.4	0	168	61	91	126	WP_187150461.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	108	73.6	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
26880710	26880710	PRJNA1136957_S_NODE_3381_length_404_cov_19.742029_g3284_i0	PRJNA1136957	3381	404	19.742029	79.75779716	Bacillus thuringiensis	1428	Bacteria	Bacteria	68.2	2.82e-12	NR	MRA94196.1	1428	g3284	i0	50.9	0.423267326732673	57	28	42.3	0	4	174	12	68	MRA94196.1 hypothetical protein [Bacillus thuringiensis]	diamond	171	68.2	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
27038720	27038720	PRJNA1136957_S_NODE_10302_length_266_cov_1.420290_g10205_i0	PRJNA1136957	10302	266	1.42029	3.7779714	Anaerolinea sp.	1872519	Bacteria	Bacteria	43.5	0.024	NR	MBA4181095.1	1872519	g10205	i0	37	0.518796992481203	46	29	51.9	0	129	266	10	55	MBA4181095.1 hypothetical protein [Anaerolinea sp.]	diamond	138	43.5	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea sp.
27575906	27575906	PRJNA1136957_S_NODE_3704_length_393_cov_7.449102_g3607_i0	PRJNA1136957	3704	393	7.449102	29.27497086	Anaerolineae bacterium	2052143	Bacteria	Bacteria	47	9.96e-4	NR	HJW83703.1	2052143	g3607	i0	28.3	1.54198473282443	99	66	74.8	2	367	74	6	100	HJW83703.1 DUF4286 family protein [Anaerolineae bacterium]	diamond	606	47	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28554863	28554863	PRJNA1136957_S_NODE_13847_length_232_cov_1.763006_g13750_i0	PRJNA1136957	13847	232	1.763006	4.09017392	Streptococcus agalactiae	1311	Bacteria	Bacteria	40.4	0.0445	NR	WP_341775314.1	1311	g13750	i0	57.1	0.362068965517241	28	12	36.2	0	86	169	25	52	WP_341775314.1 reverse transcriptase domain-containing protein, partial [Streptococcus agalactiae]	diamond	84	40.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
29059971	29059971	PRJNA1136957_S_NODE_21228_length_190_cov_2.160305_g21131_i0	PRJNA1136957	21228	190	2.160305	4.1045795	Syntrophomonadaceae bacterium	2093811	Bacteria	Bacteria	52.8	5.15e-6	NR	NLO21705.1	2093811	g21131	i0	57.9	2.4	38	16	60	0	188	75	13	50	NLO21705.1 DEAD/DEAH box helicase [Syntrophomonadaceae bacterium]	diamond	456	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae		Syntrophomonadaceae bacterium
29091573	29091573	PRJNA1136957_S_NODE_5568_length_340_cov_4.209964_g5471_i0	PRJNA1136957	5568	340	4.209964	14.3138776	Capsulimonadales bacterium	2971800	Bacteria	Bacteria	94	5.41e-22	NR	MDX1932757.1	2971800	g5471	i0	58.5	3.72352941176471	82	34	72.4	0	9	254	47	128	MDX1932757.1 Rid family detoxifying hydrolase [Capsulimonadales bacterium]	diamond	1266	94	1	Bacteria		Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales			Capsulimonadales bacterium
29344127	29344127	PRJNA1136957_S_NODE_14349_length_228_cov_2.526627_g14252_i0	PRJNA1136957	14349	228	2.526627	5.76070956	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	43.9	0.0117	NR	MAU55661.1	2026734	g14252	i0	38.3	0.789473684210526	60	34	75	2	218	48	304	363	MAU55661.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	180	43.9	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
29407122	29407122	PRJNA1136957_S_NODE_789_length_611_cov_2.594203_g711_i0	PRJNA1136957	789	611	2.594203	15.85058033	Bacillus thuringiensis	1428	Bacteria	Bacteria	82.8	1.24e-16	NR	MRA75726.1	1428	g711	i0	44.3	0.854337152209493	97	54	47.6	0	296	6	4	100	MRA75726.1 hypothetical protein [Bacillus thuringiensis]	diamond	522	82.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
29438374	29438374	PRJNA1136957_S_NODE_20350_length_195_cov_0.897059_g20253_i0	PRJNA1136957	20350	195	0.897059	1.74926505	Kitasatospora indigofera	67307	Bacteria	Bacteria	44.7	0.0042	NR	WP_355657059.1	67307	g20253	i0	33.3	0.969230769230769	63	41	96.9	1	7	195	49	110	WP_355657059.1 acyl-CoA thioesterase/bile acid-CoA:amino acid N-acyltransferase family protein [Kitasatospora indigofera]	diamond	189	44.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora indigofera
29691004	29691004	PRJNA1136957_S_NODE_10310_length_266_cov_1.178744_g10213_i0	PRJNA1136957	10310	266	1.178744	3.13545904	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	122	6.66e-30	NR	WP_187150616.1	432608	g10213	i0	75	0.992481203007519	88	22	99.2	0	1	264	192	279	WP_187150616.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	264	122	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
29691005	29691005	PRJNA1136957_S_NODE_10990_length_258_cov_1.226131_g10893_i0	PRJNA1136957	10990	258	1.226131	3.16341798	Armatimonadota bacterium	2033014	Bacteria	Bacteria	43.1	0.0331	NR	HIE51766.1	2033014	g10893	i0	37.1	0.720930232558139	62	39	72.1	0	5	190	166	227	HIE51766.1 rhamnosidase [Armatimonadota bacterium]	diamond	186	43.1	1	Bacteria		Bacillati	Armatimonadota					Armatimonadota bacterium
29881013	29881013	PRJNA1136957_S_NODE_18791_length_201_cov_1.119718_g18694_i0	PRJNA1136957	18791	201	1.119718	2.25063318	Hominilimicola	3073565	Bacteria	Bacteria	53.5	5.05e-7	NR	WP_022230028.1	3073565	g18694	i0	43.9	0.850746268656716	57	32	85.1	0	3	173	61	117	WP_022230028.1 MULTISPECIES: hypothetical protein [Hominilimicola]	diamond	171	53.5	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Hominilimicola
29881018	29881018	PRJNA1136957_S_NODE_2671_length_436_cov_2.442971_g2574_i0	PRJNA1136957	2671	436	2.442971	10.65135356	Streptomyces sp. Rer75	2750011	Bacteria	Bacteria	43.5	0.0313	NR	QLH27388.1	2750011	g2574	i0	42.1	0.784403669724771	57	31	37.8	1	281	117	53	109	QLH27388.1 MFS transporter [Streptomyces sp. Rer75]	diamond	342	43.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. Rer75
30544347	30544347	PRJNA1136957_S_NODE_16893_length_212_cov_1.196078_g16796_i0	PRJNA1136957	16893	212	1.196078	2.53568536	Microcystis viridis Mv_BB_P_19951	44822	Bacteria	Bacteria	140	6.93e-41	NR	TRU84291.1	2486268	g16796	i0	98.6	0.990566037735849	70	1	99.1	0	3	212	57	126	TRU84291.1 MAG: hypothetical protein EWV46_14875 [Microcystis viridis Mv_BB_P_19951000_S69D]	diamond	210	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
30817730	30817730	PRJNA1136957_S_NODE_20574_length_194_cov_1.200000_g20477_i0	PRJNA1136957	20574	194	1.2	2.328	Bacteria	2	Bacteria	Bacteria	102	1.88e-23	NR	TRU80155.1	2486268	g20477	i0	93.3	1.85567010309278	60	4	92.8	0	182	3	159	218	TRU80155.1 MAG: T9SS type A sorting domain-containing protein, partial [Microcystis viridis Mv_BB_P_19951000_S69D]	diamond	360	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
31397714	31397714	PRJNA1136957_S_NODE_1976_length_475_cov_3.278846_g1879_i0	PRJNA1136957	1976	475	3.278846	15.5745185	Ammoniphilus sp. YIM 78166	1644106	Bacteria	Bacteria	60.8	1.68e-7	NR	WP_134702773.1	1644106	g1879	i0	49.1	0.334736842105263	53	26	32.8	1	437	282	317	369	WP_134702773.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Ammoniphilus sp. YIM 78166]	diamond	159	60.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Ammoniphilus	Ammoniphilus sp. YIM 78166
31418225	31418225	PRJNA1136957_S_NODE_13516_length_235_cov_1.039773_g13419_i0	PRJNA1136957	13516	235	1.039773	2.44346655	Streptomyces	1883	Bacteria	Bacteria	80.5	1.72e-15	NR	WP_250402383.1	67285	g13419	i0	52.9	5.47659574468085	70	33	89.4	0	1	210	628	697	WP_250402383.1 neutral/alkaline ceramidase [Streptomyces cellostaticus]	diamond	1287	81.3	0.990159901599016	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces cellostaticus
31461085	31461085	PRJNA1136957_S_NODE_8916_length_283_cov_1.691964_g8819_i0	PRJNA1136957	8916	283	1.691964	4.78825812	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	62.8	1.72e-9	NR	MET0160153.1	2201156	g8819	i0	56.5	0.657243816254417	62	20	65.7	1	282	97	129	183	MET0160153.1 oligoribonuclease [Acidimicrobiales bacterium]	diamond	186	62.8	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
31808783	31808783	PRJNA1136957_S_NODE_20877_length_193_cov_0.910448_g20780_i0	PRJNA1136957	20877	193	0.910448	1.75716464	Mycoplasma wenyonii	65123	Bacteria	Bacteria	125	3.5799999999999997e-32	NR	WP_258393867.1	65123	g20780	i0	92.2	1.98963730569948	64	5	99.5	0	2	193	111	174	WP_258393867.1 phospholipase D-like domain-containing protein [Mycoplasma wenyonii]	diamond	384	125	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32220147	32220147	PRJNA1136957_S_NODE_9978_length_270_cov_1.146919_g9881_i0	PRJNA1136957	9978	270	1.146919	3.0966813	Anaerolinea thermophila	167964	Bacteria	Bacteria	73.2	4.42e-13	NR	WP_013561055.1	167964	g9881	i0	61	2.53333333333333	59	23	65.6	0	92	268	1	59	WP_013561055.1 aldo/keto reductase [Anaerolinea thermophila]	diamond	684	73.2	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila
32630881	32630881	PRJNA1136957_S_NODE_16300_length_216_cov_1.159236_g16203_i0	PRJNA1136957	16300	216	1.159236	2.50394976	Cyanobacteria bacterium P01_D01_bin.56	3023279	Bacteria	Bacteria	43.9	0.0103	NR	MEM9808643.1	3023279	g16203	i0	33.3	0.875	63	38	81.9	1	5	181	388	450	MEM9808643.1 zinc metalloprotease HtpX [Cyanobacteria bacterium P01_D01_bin.56]	diamond	189	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_D01_bin.56

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