metadata: contig_metadata: 30 rows where bioproject = "PRJNA915212" and tax

30 rows where bioproject = "PRJNA915212" 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
3446049	3446049	PRJNA915212_P_NODE_7743_length_210_cov_0.950311_g7705_i0	PRJNA915212	7743	210	0.950311	1.9956531	Clostridium botulinum	1491	Bacteria	Bacteria	58.4	3.96e-4	NTclustered	gi\|2331077869\|dbj\|AP025140.1\|	1491	g7705	i0	97.059	0.161904761904762	34	1	16	0	79	112	2996489	2996522	Clostridium botulinum Osaka2020 DNA, complete genome	blastn	34	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
3446058	3446058	PRJNA915212_P_NODE_9243_length_191_cov_1.246479_g9205_i0	PRJNA915212	9243	191	1.246479	2.38077489	Halothermothrix orenii	31909	Bacteria	Bacteria	143	9.479999999999999e-30	NTclustered	gi\|219992160\|gb\|CP001098.1\|	373903	g9205	i0	83.019	20.7643979057592	159	25	83	2	11	168	1689024	1689181	Halothermothrix orenii H 168, complete genome	blastn	3966	143	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halothermotrichaceae	Halothermothrix	Halothermothrix orenii
4723643	4723643	PRJNA915212_P_NODE_12664_length_165_cov_1.310345_g12626_i0	PRJNA915212	12664	165	1.310345	2.16206925	Selenomonas sp.	2053611	Bacteria	Bacteria	124	2.88e-24	NTclustered	gi\|2913850746\|gb\|CP181254.1\|	2053611	g12626	i0	80.488	85.3090909090909	164	30	99	2	1	163	309614	309776	MAG: Selenomonas sp. isolate UW_FK_SELE1_1 chromosome	blastn	14076	124	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sp.
8903878	8903878	PRJNA915212_P_NODE_6667_length_227_cov_0.859551_g6629_i0	PRJNA915212	6667	227	0.859551	1.95118077	root	1	Root_unresolved	Root_unresolved	54.7	0.006	NTclustered	gi\|2513827645\|gb\|CP126446.1\|	265426	g6629	i0	96.875	0.295154185022026	32	1	14	0	191	222	3462833	3462802	Pontibacillus chungwhensis strain HN14 chromosome, complete genome	blastn	67	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Pontibacillus	Pontibacillus chungwhensis
11098685	11098685	PRJNA915212_P_NODE_6449_length_231_cov_1.093407_g6411_i0	PRJNA915212	6449	231	1.093407	2.52577017	Clostridiales bacterium	1898207	Bacteria	Bacteria	110	6.29e-26	NR	MDR3318981.1	1898207	g6411	i0	63.6	5.98701298701299	77	28	100	0	231	1	274	350	MDR3318981.1 glutamine synthetase III [Clostridiales bacterium]	diamond	1383	110	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
12374253	12374253	PRJNA915212_P_NODE_13210_length_164_cov_0.886957_g13172_i0	PRJNA915212	13210	164	0.886957	1.45460948	Paenibacillus sp. RC67	3039392	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2506068966\|gb\|CP125098.1\|	3039392	g13172	i0	100	0.170731707317073	28	0	17	0	18	45	287401	287428	Paenibacillus sp. RC67 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. RC67
16197988	16197988	PRJNA915212_P_NODE_11313_length_170_cov_1.264463_g11275_i0	PRJNA915212	11313	170	1.264463	2.1495871	Terribacillus sp. FSL K6-0262	2921447	Bacteria	Bacteria	159	8.139999999999998e-35	NTclustered	gi\|2709996983\|gb\|CP150277.1\|	2921447	g11275	i0	85.621	163.458823529412	153	20	89	2	1	152	1537701	1537852	Terribacillus sp. FSL K6-0262 chromosome, complete genome	blastn	27788	159	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Terribacillus	Terribacillus sp. FSL K6-0262
16198083	16198083	PRJNA915212_P_NODE_7073_length_220_cov_1.157895_g7035_i0	PRJNA915212	7073	220	1.157895	2.547369	Lactococcus garvieae	1363	Bacteria	Bacteria	60.2	1.16e-4	NTclustered	gi\|2706013729\|gb\|CP141717.1\|	1363	g7035	i0	100	0.145454545454545	32	0	15	0	109	140	112206	112237	Lactococcus garvieae strain R22-8 chromosome, complete genome	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus garvieae
16198099	16198099	PRJNA915212_P_NODE_9733_length_186_cov_1.116788_g9695_i0	PRJNA915212	9733	186	1.116788	2.07722568	Bacilli bacterium	1903720	Bacteria	Bacteria	82	1.73e-18	NR	MCR5349097.1	1903720	g9695	i0	60	0.967741935483871	60	24	96.8	0	186	7	4	63	MCR5349097.1 thioredoxin [Bacilli bacterium]	diamond	180	82	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
16553518	16553518	PRJNA915212_P_NODE_10273_length_180_cov_1.809160_g10235_i0	PRJNA915212	10273	180	1.80916	3.256488	root	1	Root_unresolved	Root_unresolved	69.4	1.52e-7	NTclustered	gi\|2049644612\|gb\|CP036059.1\|	1405	g10235	i0	82.143	8.47777777777778	84	12	45	2	17	97	53685	53768	Bacillus mycoides strain JAS06/1 plasmid p88	blastn	1526	69.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
21653193	21653193	PRJNA915212_P_NODE_14377_length_162_cov_0.902655_g14339_i0	PRJNA915212	14377	162	0.902655	1.4623011	Bacillati	1783272	Bacteria	Bacteria	88.6	8.57e-19	NR	MDR1100867.1	1898207	g14339	i0	73.1	12.6296296296296	52	14	96.3	0	3	158	63	114	MDR1100867.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Clostridiales bacterium]	diamond	2046	88.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
23847461	23847461	PRJNA915212_P_NODE_9419_length_189_cov_1.450000_g9381_i0	PRJNA915212	9419	189	1.45	2.7405	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2581474101\|gb\|CP134769.1\|	1590	g9381	i0	92.308	0.354497354497354	39	3	21	0	90	128	882489	882451	Lactiplantibacillus plantarum strain SYBC-SM2 chromosome, complete genome	blastn	67	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
26771370	26771370	PRJNA915212_P_NODE_11641_length_167_cov_1.364407_g11603_i0	PRJNA915212	11641	167	1.364407	2.27855969	Mahella australiensis	252966	Bacteria	Bacteria	47.8	2.27e-4	NR	WP_013781789.1	252966	g11603	i0	45.7	2.55089820359281	46	24	80.8	1	139	5	297	342	WP_013781789.1 ABC transporter ATP-binding protein [Mahella australiensis]	diamond	426	47.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacterales Family IV. Incertae Sedis	Mahella	Mahella australiensis
26961092	26961092	PRJNA915212_P_NODE_5662_length_249_cov_1.020000_g5624_i0	PRJNA915212	5662	249	1.02	2.5398	Cohnella panacarvi	400776	Bacteria	Bacteria	44.3	0.0106	NR	WP_027085127.1	400776	g5624	i0	40.4	1.75903614457831	52	31	62.7	0	26	181	196	247	WP_027085127.1 ArsR/SmtB family transcription factor [Cohnella panacarvi]	diamond	438	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella panacarvi
27024539	27024539	PRJNA915212_P_NODE_8762_length_197_cov_1.033784_g8724_i0	PRJNA915212	8762	197	1.033784	2.03655448	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	56.2	3.52e-7	NR	MBQ9437821.1	1898203	g8724	i0	65.8	1.72081218274112	38	13	57.9	0	195	82	641	678	MBQ9437821.1 sodium-translocating pyrophosphatase [Lachnospiraceae bacterium]	diamond	339	56.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
27277569	27277569	PRJNA915212_P_NODE_3423_length_339_cov_2.144828_g3386_i0	PRJNA915212	3423	339	2.144828	7.27096692	Paenibacillus sp. 1	198340	Bacteria	Bacteria	73.6	2.06e-13	NR	WP_119803096.1	1675787	g3386	i0	47	1.47787610619469	83	41	70.8	1	242	3	6	88	WP_119803096.1 DUF2589 domain-containing protein [Paenibacillus sp. 1011MAR3C5]	diamond	501	73.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. 1011MAR3C5
27530124	27530124	PRJNA915212_P_NODE_5703_length_248_cov_0.758794_g5665_i0	PRJNA915212	5703	248	0.758794	1.88180912	Candidatus Merdisoma sp. JLR.KK	3101169	Bacteria	Bacteria	44.7	0.00824	NR	WP_334337558.1	3114299	g5665	i0	41.2	0.616935483870968	51	30	61.7	0	155	3	362	412	WP_334337558.1 hypothetical protein [Candidatus Merdisoma sp. JLR.KK011]	diamond	153	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Candidatus Merdisoma	Candidatus Merdisoma sp. JLR.KK011
27720061	27720061	PRJNA915212_P_NODE_6104_length_238_cov_1.730159_g6066_i0	PRJNA915212	6104	238	1.730159	4.11777842	Clostridia bacterium	2044939	Bacteria	Bacteria	45.1	0.00542	NR	MBR6646490.1	2044939	g6066	i0	60	0.970588235294118	25	10	31.5	0	5	79	677	701	MBR6646490.1 glutamine synthetase III [Clostridia bacterium]	diamond	231	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
27853147	27853147	PRJNA915212_P_NODE_9604_length_187_cov_1.782609_g9566_i0	PRJNA915212	9604	187	1.782609	3.33347883	Clostridia	186801	Bacteria	Bacteria	99	1.32e-24	NR	WP_028051727.1	54265	g9566	i0	73.8	7.82887700534759	61	16	97.9	0	2	184	10	70	WP_028051727.1 nucleoside-diphosphate kinase [Carboxydothermus ferrireducens]	diamond	1464	100	0.99	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Carboxydothermus	Carboxydothermus ferrireducens
28035427	28035427	PRJNA915212_P_NODE_3005_length_368_cov_1.278997_g2969_i0	PRJNA915212	3005	368	1.278997	4.70670896	Agathobacter sp.	2021311	Bacteria	Bacteria	45.1	0.0227	NR	WP_287476171.1	2021311	g2969	i0	35.4	0.782608695652174	96	52	75.8	4	331	53	530	618	WP_287476171.1 ABC transporter ATP-binding protein, partial [Agathobacter sp.]	diamond	288	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter sp.
28192976	28192976	PRJNA915212_P_NODE_1886_length_482_cov_1.330254_g1851_i0	PRJNA915212	1886	482	1.330254	6.41182428	Bacillota bacterium	1879010	Bacteria	Bacteria	67.8	1.58e-10	NR	MTI81112.1	1879010	g1851	i0	33.5	1.05809128630705	170	100	97.7	4	482	12	32	201	MTI81112.1 DUF2589 domain-containing protein [Bacillota bacterium]	diamond	510	67.8	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
28863496	28863496	PRJNA915212_P_NODE_2128_length_452_cov_2.233251_g2093_i0	PRJNA915212	2128	452	2.233251	10.09429452	Paenibacillaceae	186822	Bacteria	Bacteria	141	3.3199999999999993e-40	NR	WP_239631023.1	185978	g2093	i0	61.2	7.67256637168142	116	45	77	0	43	390	1	116	WP_239631023.1 MULTISPECIES: group I truncated hemoglobin [unclassified Paenibacillus]	diamond	3468	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus
29211073	29211073	PRJNA915212_P_NODE_12889_length_165_cov_0.879310_g12851_i0	PRJNA915212	12889	165	0.87931	1.4508615	Bacillati	1783272	Bacteria	Bacteria	63.2	5.8e-10	NR	WP_098306788.1	2033491	g12851	i0	65.1	9.83636363636364	43	15	78.2	0	158	30	198	240	WP_098306788.1 3-hydroxyacyl-CoA dehydrogenase family protein [Bacillus sp. AFS018417]	diamond	1623	63.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. AFS018417
30024769	30024769	PRJNA915212_P_NODE_13531_length_164_cov_0.886957_g13493_i0	PRJNA915212	13531	164	0.886957	1.45460948	Sulfobacillus thermosulfidooxidans	28034	Bacteria	Bacteria	42.4	0.00505	NR	WP_053958383.1	28034	g13493	i0	45.7	0.640243902439024	35	17	60.4	1	30	128	54	88	WP_053958383.1 hypothetical protein [Sulfobacillus thermosulfidooxidans]	diamond	105	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiales Family XVII. Incertae Sedis	Sulfobacillus	Sulfobacillus thermosulfidooxidans
30214031	30214031	PRJNA915212_P_NODE_8312_length_202_cov_1.333333_g8274_i0	PRJNA915212	8312	202	1.333333	2.69333266	Paenibacillus sp. 1	198340	Bacteria	Bacteria	53.1	2.32e-6	NR	WP_119803096.1	1675787	g8274	i0	38.2	2.0049504950495	68	41	99.5	1	1	201	20	87	WP_119803096.1 DUF2589 domain-containing protein [Paenibacillus sp. 1011MAR3C5]	diamond	405	53.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. 1011MAR3C5
30821807	30821807	PRJNA915212_P_NODE_6574_length_228_cov_2.262570_g6536_i0	PRJNA915212	6574	228	2.26257	5.1586596	Aminicella	1637744	Bacteria	Bacteria	90.1	6.3e-19	NR	WP_133527411.1	433323	g6536	i0	53.3	13.7894736842105	75	35	98.7	0	3	227	212	286	WP_133527411.1 glutamine synthetase III [Aminicella lysinilytica]	diamond	3144	90.9	0.991199119911991	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Aminicella	Aminicella lysinilytica
30846096	30846096	PRJNA915212_P_NODE_13314_length_164_cov_0.886957_g13276_i0	PRJNA915212	13314	164	0.886957	1.45460948	Clostridia bacterium	2044939	Bacteria	Bacteria	40	0.0204	NR	MBQ7970924.1	2044939	g13276	i0	54.1	0.676829268292683	37	16	67.7	1	2	112	33	68	MBQ7970924.1 LicD family protein [Clostridia bacterium]	diamond	111	40	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
31004118	31004118	PRJNA915212_P_NODE_13634_length_163_cov_1.342105_g13596_i0	PRJNA915212	13634	163	1.342105	2.18763115	Tissierellia bacterium	2049431	Bacteria	Bacteria	41.2	0.0434	NR	NLI65279.1	2049431	g13596	i0	46.3	0.754601226993865	41	22	75.5	0	12	134	20	60	NLI65279.1 hypothetical protein [Tissierellia bacterium]	diamond	123	41.2	1	Bacteria	Bacillati	Bacillota	Tissierellia				Tissierellia bacterium
32624138	32624138	PRJNA915212_P_NODE_12480_length_166_cov_0.871795_g12442_i0	PRJNA915212	12480	166	0.871795	1.4471797	Bacteria	2	Bacteria	Bacteria	62	2.11e-9	NR	MFQ9717108.1	1955243	g12442	i0	52.7	6.92168674698795	55	26	99.4	0	1	165	146	200	MFQ9717108.1 bifunctional acetaldehyde-CoA/alcohol dehydrogenase [Blautia sp.]	diamond	1149	62.4	0.993589743589744	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia sp.
32750221	32750221	PRJNA915212_P_NODE_1460_length_553_cov_1.611111_g1426_i0	PRJNA915212	1460	553	1.611111	8.90944383	PVC group	1783257	Bacteria	Bacteria	80.9	5.13e-14	NR	WP_139085002.1	1850362	g1426	i0	30.2	4.95840867992767	182	122	98.2	3	543	1	61	238	WP_139085002.1 choice-of-anchor A family protein [Bacillus sp. FJAT-27264]	diamond	2742	80.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. FJAT-27264

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