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

27 rows where analysis = "diamond", bioproject = "PRJNA656952" and tax_phylum = "Bacillota"

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
7001038	7001038	PRJNA656952_P_NODE_34286_length_249_cov_0.875000_g34099_i0	PRJNA656952	34286	249	0.875	2.17875	Bacillus timonensis	1033734	Bacteria	Bacteria	164	1.03e-49	NR	WP_136381851.1	1033734	g34099	i0	98.8	1.97590361445783	82	1	98.8	0	3	248	29	110	WP_136381851.1 GTP cyclohydrolase I FolE [Bacillus timonensis]	diamond	492	164	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus timonensis
9550791	9550791	PRJNA656952_P_NODE_24168_length_282_cov_1.215311_g23981_i0	PRJNA656952	24168	282	1.215311	3.42717702	Faecalicatena contorta	39482	Bacteria	Bacteria	144	5.39e-38	NR	WP_235415780.1	39482	g23981	i0	89.3	3.12765957446809	75	8	79.8	0	281	57	478	552	WP_235415780.1 [FeFe] hydrogenase, group A [Faecalicatena contorta]	diamond	882	144	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Faecalicatena	Faecalicatena contorta
14651087	14651087	PRJNA656952_P_NODE_21212_length_297_cov_1.375000_g21025_i0	PRJNA656952	21212	297	1.375	4.08375	Lactobacillus helveticus	1587	Bacteria	Bacteria	148	2.17e-44	NR	WP_320493255.1	1587	g21025	i0	98.6	0.737373737373737	73	1	73.7	0	264	46	1	73	WP_320493255.1 hypothetical protein [Lactobacillus helveticus]	diamond	219	148	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus helveticus
23574641	23574641	PRJNA656952_P_NODE_13379_length_354_cov_1.096085_g13192_i0	PRJNA656952	13379	354	1.096085	3.8801409	Enterococcus florum	2480627	Bacteria	Bacteria	226	1.82e-67	NR	WP_146621082.1	2480627	g13192	i0	94.9	0.991525423728814	117	6	99.2	0	3	353	537	653	WP_146621082.1 alpha-galactosidase [Enterococcus florum]	diamond	351	226	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus florum
27397571	27397571	PRJNA656952_P_NODE_29843_length_256_cov_1.300546_g29656_i0	PRJNA656952	29843	256	1.300546	3.32939776	Bacillus cereus	1396	Bacteria	Bacteria	122	3.09e-30	NR	WP_098521997.1	1396	g29656	i0	91.9	0.7265625	62	5	72.7	0	2	187	303	364	WP_098521997.1 reverse transcriptase domain-containing protein [Bacillus cereus]	diamond	186	122	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
27586945	27586945	PRJNA656952_P_NODE_42804_length_242_cov_0.911243_g42617_i0	PRJNA656952	42804	242	0.911243	2.20520806	Bacillus sp. HNG	2293325	Bacteria	Bacteria	145	1.81e-41	NR	WP_116353867.1	2293325	g42617	i0	96.3	0.991735537190083	80	3	99.2	0	3	242	25	104	WP_116353867.1 sulfite exporter TauE/SafE family protein [Bacillus sp. HNG]	diamond	240	145	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. HNG
28029015	28029015	PRJNA656952_P_NODE_39465_length_244_cov_1.397661_g39278_i0	PRJNA656952	39465	244	1.397661	3.41029284	Abyssicoccus albus	1817405	Bacteria	Bacteria	161	1.33e-45	NR	WP_123808293.1	1817405	g39278	i0	96.3	0.995901639344262	81	3	99.6	0	2	244	159	239	WP_123808293.1 hypothetical protein [Abyssicoccus albus]	diamond	243	161	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Abyssicoccaceae	Abyssicoccus	Abyssicoccus albus
28167524	28167524	PRJNA656952_P_NODE_40985_length_243_cov_0.905882_g40798_i0	PRJNA656952	40985	243	0.905882	2.20129326	Clostridium	1485	Bacteria	Bacteria	137	2.42e-35	NR	MCC8128022.1	1898207	g40798	i0	73.8	3.91358024691358	80	21	98.8	0	2	241	315	394	MCC8128022.1 FAD binding domain-containing protein [Clostridiales bacterium]	diamond	951	137	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
28281278	28281278	PRJNA656952_P_NODE_39306_length_245_cov_0.895349_g39119_i0	PRJNA656952	39306	245	0.895349	2.19360505	unclassified Sutcliffiella	2837532	Bacteria	Bacteria	68.2	3.16e-11	NR	WP_339147979.1	2837532	g39119	i0	75.6	0.502040816326531	41	10	50.2	0	3	125	289	329	WP_339147979.1 MULTISPECIES: glycosyltransferase family 2 protein [unclassified Sutcliffiella]	diamond	123	68.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Sutcliffiella
28439478	28439478	PRJNA656952_P_NODE_42806_length_242_cov_0.911243_g42619_i0	PRJNA656952	42806	242	0.911243	2.20520806	Bacillales bacterium	1904864	Bacteria	Bacteria	103	3.18e-25	NR	MDF2534124.1	1904864	g42619	i0	62.5	0.991735537190083	80	29	99.2	1	3	242	66	144	MDF2534124.1 hypothetical protein [Bacillales bacterium]	diamond	240	103	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales			Bacillales bacterium
28534265	28534265	PRJNA656952_P_NODE_41927_length_242_cov_1.798817_g41740_i0	PRJNA656952	41927	242	1.798817	4.35313714	Niallia sp.	2837523	Bacteria	Bacteria	118	1e-31	NR	WP_312098635.1	2837523	g41740	i0	97	0.830578512396694	67	1	81.8	1	44	241	1	67	WP_312098635.1 hypothetical protein [Niallia sp.]	diamond	201	118	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia sp.
28660460	28660460	PRJNA656952_P_NODE_25627_length_275_cov_1.524752_g25440_i0	PRJNA656952	25627	275	1.524752	4.193068	Paenibacillaceae bacterium	2003592	Bacteria	Bacteria	42	0.0411	NR	RXZ81751.1	2003592	g25440	i0	30.3	0.72	66	46	72	0	259	62	54	119	RXZ81751.1 VOC family protein [Paenibacillaceae bacterium]	diamond	198	42	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae		Paenibacillaceae bacterium
29544304	29544304	PRJNA656952_P_NODE_42430_length_242_cov_0.911243_g42243_i0	PRJNA656952	42430	242	0.911243	2.20520806	Bacillota bacterium	1879010	Bacteria	Bacteria	97.4	1.13e-21	NR	HIY98179.1	1879010	g42243	i0	87	0.669421487603306	54	7	66.9	0	164	3	1	54	HIY98179.1 metallophosphoesterase [Bacillota bacterium]	diamond	162	97.4	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
30176012	30176012	PRJNA656952_P_NODE_44172_length_241_cov_0.916667_g43985_i0	PRJNA656952	44172	241	0.916667	2.20916747	Fredinandcohnia	2837501	Bacteria	Bacteria	169	2.1e-49	NR	WP_304215572.1	2837501	g43985	i0	100	1.99170124481328	80	0	99.6	0	240	1	261	340	WP_304215572.1 MULTISPECIES: 1-deoxy-D-xylulose-5-phosphate reductoisomerase [Fredinandcohnia]	diamond	480	169	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Fredinandcohnia
30251731	30251731	PRJNA656952_P_NODE_30032_length_255_cov_1.598901_g29845_i0	PRJNA656952	30032	255	1.598901	4.07719755	Bacillaceae	186817	Bacteria	Bacteria	131	5.209999999999999e-38	NR	PGR28881.1	1404	g29845	i0	87.2	1.78823529411765	78	10	91.8	0	253	20	3	80	PGR28881.1 hypothetical protein COC52_07950 [Priestia megaterium]	diamond	456	132	0.992424242424242	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
30460911	30460911	PRJNA656952_P_NODE_30013_length_255_cov_1.692308_g29826_i0	PRJNA656952	30013	255	1.692308	4.3153854	Bacillus mobilis	2026190	Bacteria	Bacteria	160	2.5799999999999997e-45	NR	WP_270606136.1	2026190	g29826	i0	100	1	85	0	100	0	1	255	142	226	WP_270606136.1 flippase [Bacillus mobilis]	diamond	255	160	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mobilis
30555080	30555080	PRJNA656952_P_NODE_38093_length_246_cov_0.890173_g37906_i0	PRJNA656952	38093	246	0.890173	2.18982558	Megasphaera lornae	1000568	Bacteria	Bacteria	168	3.8300000000000002e-50	NR	WP_009381282.1	1000568	g37906	i0	98.8	0.98780487804878	81	1	98.8	0	3	245	155	235	WP_009381282.1 EFR1 family ferrodoxin [Megasphaera lornae]	diamond	243	168	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera lornae
30713216	30713216	PRJNA656952_P_NODE_37294_length_246_cov_0.890173_g37107_i0	PRJNA656952	37294	246	0.890173	2.18982558	Streptococcus infantis	68892	Bacteria	Bacteria	164	4.92e-50	NR	WP_414253437.1	68892	g37107	i0	92.7	1	82	6	100	0	1	246	54	135	WP_414253437.1 GNAT family N-acetyltransferase [Streptococcus infantis]	diamond	246	164	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantis
30883411	30883411	PRJNA656952_P_NODE_33954_length_249_cov_0.875000_g33767_i0	PRJNA656952	33954	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	70.1	3.03e-12	NR	WP_052036055.1	1157490	g33767	i0	46.8	1.91566265060241	79	38	94	3	235	2	32	107	WP_052036055.1 hypothetical protein [Tumebacillus flagellatus]	diamond	477	70.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Tumebacillus	Tumebacillus flagellatus
30934523	30934523	PRJNA656952_P_NODE_42194_length_242_cov_0.911243_g42007_i0	PRJNA656952	42194	242	0.911243	2.20520806	Paenibacillus chitinolyticus	79263	Bacteria	Bacteria	72.8	5.16e-14	NR	MBV6717237.1	79263	g42007	i0	60.3	1.43801652892562	58	23	71.9	0	3	176	93	150	MBV6717237.1 hypothetical protein [Paenibacillus chitinolyticus]	diamond	348	72.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus chitinolyticus
31104494	31104494	PRJNA656952_P_NODE_14555_length_343_cov_1.140741_g14368_i0	PRJNA656952	14555	343	1.140741	3.91274163	Enterococcus	1350	Bacteria	Bacteria	202	1.94e-60	NR	WP_301182167.1	1352	g14368	i0	100	4.94169096209913	113	0	98.8	0	3	341	180	292	WP_301182167.1 ABC transporter transmembrane domain-containing protein [Enterococcus faecium]	diamond	1695	202	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
31104497	31104497	PRJNA656952_P_NODE_40135_length_244_cov_0.900585_g39948_i0	PRJNA656952	40135	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	42.7	0.0141	NR	NEU46650.1	1352	g39948	i0	95.3	1.57377049180328	64	3	78.7	0	25	216	1	64	NEU46650.1 hypothetical protein [Enterococcus faecium]	diamond	384	42.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
31673713	31673713	PRJNA656952_P_NODE_26577_length_271_cov_1.414141_g26390_i0	PRJNA656952	26577	271	1.414141	3.83232211	Brevibacillus	55080	Bacteria	Bacteria	112	8.81e-30	NR	WP_007786134.1	55080	g26390	i0	55.3	1.8929889298893	85	38	94.1	0	260	6	24	108	WP_007786134.1 MULTISPECIES: thioredoxin family protein [Brevibacillus]	diamond	513	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus
31724762	31724762	PRJNA656952_P_NODE_31057_length_251_cov_0.865169_g30870_i0	PRJNA656952	31057	251	0.865169	2.17157419	Eubacterium sp.	142586	Bacteria	Bacteria	137	3.4200000000000003e-36	NR	MEG0377741.1	142586	g30870	i0	78.3	2.97609561752988	83	18	99.2	0	3	251	151	233	MEG0377741.1 amidophosphoribosyltransferase [Eubacterium sp.]	diamond	747	137	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium sp.
32021866	32021866	PRJNA656952_P_NODE_43638_length_241_cov_0.916667_g43451_i0	PRJNA656952	43638	241	0.916667	2.20916747	Bacillota	1239	Bacteria	Bacteria	122	2.5199999999999997e-30	NR	WP_028988306.1	94009	g43451	i0	78.8	1.99170124481328	80	17	99.6	0	241	2	239	318	WP_028988306.1 heavy metal translocating P-type ATPase [Thermicanus aegyptius]	diamond	480	122	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
32294710	32294710	PRJNA656952_P_NODE_14079_length_347_cov_1.686131_g13892_i0	PRJNA656952	14079	347	1.686131	5.85087457	Shouchella clausii	79880	Bacteria	Bacteria	49.7	4.51e-4	NR	WP_212930074.1	79880	g13892	i0	39.1	0.596541786743516	69	40	59.7	1	111	317	110	176	WP_212930074.1 tail fiber domain-containing protein [Shouchella clausii]	diamond	207	49.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Shouchella	Shouchella clausii
32704862	32704862	PRJNA656952_P_NODE_34980_length_248_cov_0.880000_g34793_i0	PRJNA656952	34980	248	0.88	2.1824	Rossellomorea marisflavi	189381	Bacteria	Bacteria	144	7.669999999999999e-38	NR	WP_367259604.1	189381	g34793	i0	82.9	0.991935483870968	82	14	99.2	0	248	3	310	391	WP_367259604.1 ATP-dependent helicase [Rossellomorea marisflavi]	diamond	246	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Rossellomorea	Rossellomorea marisflavi

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