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

26 rows where analysis = "diamond", bioproject = "PRJNA853194" 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
4669742	4669742	PRJNA853194_S_NODE_9904_length_597_cov_74.070611_g8869_i0	PRJNA853194	9904	597	74.070611	442.20154767	root	1	Root_unresolved	Root_unresolved	215	4.08e-64	NR	WP_015360160.1	1510	g8869	i0	65.4	25.7185929648241	156	53	77.9	1	558	94	314	469	WP_015360160.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Thermoclostridium stercorarium]	diamond	15354	216	0.99537037037037	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Thermoclostridium	Thermoclostridium stercorarium
14867802	14867802	PRJNA853194_S_NODE_15532_length_495_cov_182.585308_g14444_i0	PRJNA853194	15532	495	182.585308	903.7972746	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	88.2	2.66e-19	NR	MBQ5561215.1	1898203	g14444	i0	40.7	1.13939393939394	86	51	52.1	0	333	76	16	101	MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium]	diamond	564	88.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
26801761	26801761	PRJNA853194_S_NODE_81121_length_246_cov_0.890173_g80030_i0	PRJNA853194	81121	246	0.890173	2.18982558	Lachnospiraceae bacterium TWA4	1392836	Bacteria	Bacteria	47	0.00107	NR	KIR01831.1	1392836	g80030	i0	42.6	0.658536585365854	54	26	59.8	2	68	214	158	211	KIR01831.1 hypothetical protein P261_00645 [Lachnospiraceae bacterium TWA4]	diamond	162	47	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium TWA4
26959936	26959936	PRJNA853194_S_NODE_6402_length_725_cov_8.929448_g5486_i0	PRJNA853194	6402	725	8.929448	64.738498	Ruminococcus sp.	41978	Bacteria	Bacteria	47.4	0.0301	NR	MCR5480202.1	41978	g5486	i0	29.9	0.52551724137931	127	85	50.9	2	324	692	219	345	MCR5480202.1 replication initiation protein [Ruminococcus sp.]	diamond	381	47.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
26991498	26991498	PRJNA853194_S_NODE_27622_length_394_cov_1.429907_g26531_i0	PRJNA853194	27622	394	1.429907	5.63383358	Streptococcus pyogenes	1314	Bacteria	Bacteria	42.7	0.0177	NR	WP_231494168.1	1314	g26531	i0	33.3	0.388324873096447	51	34	38.8	0	200	48	12	62	WP_231494168.1 hypothetical protein, partial [Streptococcus pyogenes]	diamond	153	42.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pyogenes
27465952	27465952	PRJNA853194_S_NODE_10343_length_586_cov_47.421053_g9302_i0	PRJNA853194	10343	586	47.421053	277.88737058	Allobacillus	1400133	Bacteria	Bacteria	46.6	0.0372	NR	WP_186279493.1	1400133	g9302	i0	37	0.373720136518771	73	42	35.3	1	267	61	4	76	WP_186279493.1 MULTISPECIES: ATP-dependent DNA helicase DinG [Allobacillus]	diamond	219	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Allobacillus
28255049	28255049	PRJNA853194_S_NODE_52966_length_299_cov_2.026549_g51875_i0	PRJNA853194	52966	299	2.026549	6.05938151	Lysinibacillus piscis	2518931	Bacteria	Bacteria	43.1	0.0431	NR	WP_264989672.1	2518931	g51875	i0	41.3	0.461538461538462	46	24	43.1	1	202	74	21	66	WP_264989672.1 GNAT family N-acetyltransferase [Lysinibacillus piscis]	diamond	138	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus piscis
28389608	28389608	PRJNA853194_S_NODE_29466_length_384_cov_2.157556_g28375_i0	PRJNA853194	29466	384	2.157556	8.28501504	Bacillota	1239	Bacteria	Bacteria	56.6	2.14e-6	NR	WP_414480535.1	2004500	g28375	i0	30.4	1.8515625	115	72	85.2	2	330	4	215	327	WP_414480535.1 lipoate--protein ligase [Caldicoprobacter sp.]	diamond	711	57	0.992982456140351	Bacteria	Bacillati	Bacillota	Clostridia	Caldicoprobacterales	Caldicoprobacteraceae	Caldicoprobacter	Caldicoprobacter sp.
28444745	28444745	PRJNA853194_S_NODE_14526_length_509_cov_13.316514_g13442_i0	PRJNA853194	14526	509	13.316514	67.78105626	Bacilli bacterium	1903720	Bacteria	Bacteria	46.6	0.0143	NR	MDD2681350.1	1903720	g13442	i0	23.7	0.548133595284872	93	70	54.8	1	30	308	38	129	MDD2681350.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Bacilli bacterium]	diamond	279	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
28507831	28507831	PRJNA853194_S_NODE_65807_length_270_cov_5.416244_g64716_i0	PRJNA853194	65807	270	5.416244	14.6238588	Clostridia bacterium	2044939	Bacteria	Bacteria	41.2	0.0335	NR	MBQ9429805.1	2044939	g64716	i0	33.9	1.24444444444444	56	35	60	1	78	239	8	63	MBQ9429805.1 membrane protein insertion efficiency factor YidD [Clostridia bacterium]	diamond	336	41.2	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28697375	28697375	PRJNA853194_S_NODE_45347_length_321_cov_1.467742_g44256_i0	PRJNA853194	45347	321	1.467742	4.71145182	Staphylococcus epidermidis	1282	Bacteria	Bacteria	66.6	5.79e-11	NR	WP_407046785.1	1282	g44256	i0	59.2	1.35514018691589	49	20	45.8	0	89	235	9	57	WP_407046785.1 reverse transcriptase domain-containing protein [Staphylococcus epidermidis]	diamond	435	66.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
29454606	29454606	PRJNA853194_S_NODE_64690_length_273_cov_1.140000_g63599_i0	PRJNA853194	64690	273	1.14	3.1122	Clostridia bacterium	2044939	Bacteria	Bacteria	43.9	0.0194	NR	MBQ7152845.1	2044939	g63599	i0	37.5	0.527472527472527	48	25	47.3	1	138	266	227	274	MBQ7152845.1 alpha-L-fucosidase [Clostridia bacterium]	diamond	144	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29518055	29518055	PRJNA853194_S_NODE_9150_length_619_cov_38.695971_g8128_i0	PRJNA853194	9150	619	38.695971	239.52806049	Allobacillus	1400133	Bacteria	Bacteria	46.6	0.0448	NR	WP_186279493.1	1400133	g8128	i0	37	0.353796445880452	73	42	33.4	1	267	61	4	76	WP_186279493.1 MULTISPECIES: ATP-dependent DNA helicase DinG [Allobacillus]	diamond	219	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Allobacillus
29549505	29549505	PRJNA853194_S_NODE_65970_length_270_cov_1.852792_g64879_i0	PRJNA853194	65970	270	1.852792	5.0025384	Oliverpabstia intestinalis	2606633	Bacteria	Bacteria	63.9	1.59e-9	NR	WP_154432953.1	2606633	g64879	i0	75	0.788888888888889	36	9	40	0	4	111	314	349	WP_154432953.1 DNA cytosine methyltransferase [Oliverpabstia intestinalis]	diamond	213	63.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Oliverpabstia	Oliverpabstia intestinalis
29589145	29589145	PRJNA853194_S_NODE_62810_length_277_cov_0.995098_g61719_i0	PRJNA853194	62810	277	0.995098	2.75642146	Virgibacillus	84406	Bacteria	Bacteria	44.3	0.0163	NR	WP_050351982.1	1473	g61719	i0	30.9	1.47292418772563	68	47	73.6	0	38	241	440	507	WP_050351982.1 BglG family transcription antiterminator [Virgibacillus pantothenticus]	diamond	408	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus pantothenticus
30181323	30181323	PRJNA853194_S_NODE_3252_length_959_cov_8.648984_g2579_i0	PRJNA853194	3252	959	8.648984	82.94375656	Bacilli bacterium	1903720	Bacteria	Bacteria	45.8	0.0208	NR	MBQ3308168.1	1903720	g2579	i0	29.5	0.24400417101147	78	52	23.5	1	695	919	13	90	MBQ3308168.1 hypothetical protein [Bacilli bacterium]	diamond	234	45.8	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
30403018	30403018	PRJNA853194_S_NODE_9773_length_601_cov_9.481061_g8738_i0	PRJNA853194	9773	601	9.481061	56.98117661	Bacillus cereus	1396	Bacteria	Bacteria	45.8	0.0315	NR	TKI00740.1	1396	g8738	i0	30.8	1.07321131447587	117	70	53.4	3	499	179	58	173	TKI00740.1 hypothetical protein FC693_02455, partial [Bacillus cereus]	diamond	645	46.2	0.991341991341991	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
30971398	30971398	PRJNA853194_S_NODE_10694_length_578_cov_62.506931_g9646_i0	PRJNA853194	10694	578	62.506931	361.29006118	Eubacteriales bacterium	2831996	Bacteria	Bacteria	48.1	0.00965	NR	MDY5512970.1	2831996	g9646	i0	38.6	0.86159169550173	83	36	42	3	576	334	61	130	MDY5512970.1 lamin tail domain-containing protein [Eubacteriales bacterium]	diamond	498	48.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
31192063	31192063	PRJNA853194_S_NODE_31055_length_376_cov_1.957096_g29964_i0	PRJNA853194	31055	376	1.957096	7.35868096	Blautia	572511	Bacteria	Bacteria	44.3	0.0339	NR	WP_288219173.1	572511	g29964	i0	42.3	0.414893617021277	52	23	41.5	1	312	157	152	196	WP_288219173.1 MULTISPECIES: glycosyltransferase family 2 protein [Blautia]	diamond	156	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia
31192069	31192069	PRJNA853194_S_NODE_61835_length_279_cov_1.014563_g60744_i0	PRJNA853194	61835	279	1.014563	2.83063077	Melghirimyces algeriensis	910412	Bacteria	Bacteria	45.4	0.00623	NR	WP_142504991.1	910412	g60744	i0	36.4	0.709677419354839	66	35	71	1	215	18	271	329	WP_142504991.1 recombinase family protein [Melghirimyces algeriensis]	diamond	198	45.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Melghirimyces	Melghirimyces algeriensis
31232078	31232078	PRJNA853194_S_NODE_37075_length_349_cov_8.202899_g35984_i0	PRJNA853194	37075	349	8.202899	28.62811751	Bacteria	2	Bacteria	Bacteria	87.4	2.69e-17	NR	MBQ9833994.1	1903720	g35984	i0	41.4	8.35530085959885	111	55	92	3	1	321	480	584	MBQ9833994.1 ABC transporter ATP-binding protein [Bacilli bacterium]	diamond	2916	87.4	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31603706	31603706	PRJNA853194_S_NODE_86936_length_233_cov_2.093750_g85845_i0	PRJNA853194	86936	233	2.09375	4.8784375	Planococcus glaciei	459472	Bacteria	Bacteria	42.4	0.0439	NR	QDY45686.1	459472	g85845	i0	32.1	1.00429184549356	78	43	96.6	3	225	1	132	202	QDY45686.1 hypothetical protein FK545_10465 [Planococcus glaciei]	diamond	234	42.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus glaciei
31856561	31856561	PRJNA853194_S_NODE_12657_length_539_cov_24.416309_g11585_i0	PRJNA853194	12657	539	24.416309	131.60390551	Bacillus sp. FJAT-2639	1743142	Bacteria	Bacteria	47	0.0172	NR	WP_065385009.1	1743142	g11585	i0	33.6	0.645640074211503	116	65	64	4	141	485	261	365	WP_065385009.1 AraC family transcriptional regulator [Bacillus sp. FJAT-26390]	diamond	348	47	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. FJAT-26390
32141485	32141485	PRJNA853194_S_NODE_82838_length_244_cov_0.900585_g81747_i0	PRJNA853194	82838	244	0.900585	2.1974274	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	44.3	0.0033	NR	MDR0937070.1	2485925	g81747	i0	36.8	0.836065573770492	68	43	83.6	0	226	23	52	119	MDR0937070.1 hypothetical protein [Oscillospiraceae bacterium]	diamond	204	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
32173279	32173279	PRJNA853194_S_NODE_50278_length_306_cov_4.175966_g49187_i0	PRJNA853194	50278	306	4.175966	12.77845596	Clostridium sp. LIBA-8841	2987530	Bacteria	Bacteria	43.9	0.0283	NR	WP_322502369.1	2987530	g49187	i0	34.7	0.931372549019608	95	49	90.2	3	13	288	92	176	WP_322502369.1 DUF6414 family protein [Clostridium sp. LIBA-8841]	diamond	285	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. LIBA-8841
32426247	32426247	PRJNA853194_S_NODE_56559_length_290_cov_2.995392_g55468_i0	PRJNA853194	56559	290	2.995392	8.6866368	Bacillota bacterium	1879010	Bacteria	Bacteria	42	0.0345	NR	HAB66126.1	1879010	g55468	i0	30	0.620689655172414	60	41	61	1	41	217	18	77	HAB66126.1 hypothetical protein [Bacillota bacterium]	diamond	180	42	1	Bacteria	Bacillati	Bacillota					Bacillota 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);;