metadata: contig_metadata: 21 rows where bioproject = "PRJNA767802" and tax

21 rows where bioproject = "PRJNA767802" 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
1206039	1206039	PRJNA767802_P_NODE_6041_length_324_cov_2.018182_g5968_i0	PRJNA767802	6041	324	2.018182	6.53890968	Bacillus	1386	Bacteria	Bacteria	551	2.4599999999999992e-152	NTclustered	gi\|1339799779\|gb\|CP026522.1\|	1402	g5968	i0	98.107	97.8364197530864	317	5	98	1	1	316	3447019	3446703	Bacillus licheniformis strain MBGJa67 chromosome	blastn	31699	551	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus licheniformis
2481502	2481502	PRJNA767802_P_NODE_2502_length_570_cov_12.500960_g2435_i0	PRJNA767802	2502	570	12.50096	71.255472	Bacillati	1783272	Bacteria	Bacteria	989	0	NTclustered	gi\|1227448785\|gb\|CP016766.1\|	1601	g2435	i0	99.814	503.073684210526	538	1	94	0	13	550	53794	53257	Ligilactobacillus agilis strain La3 chromosome, complete genome	blastn	286752	989	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus agilis
3757864	3757864	PRJNA767802_P_NODE_8223_length_261_cov_1.948113_g8150_i0	PRJNA767802	8223	261	1.948113	5.08457493	root	1	Root_unresolved	Root_unresolved	472	1.54e-128	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g8150	i0	99.234	98.7356321839081	261	2	100	0	1	261	2741333	2741593	Staphylococcus aureus strain WH3018 chromosome	blastn	25770	472	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8398340	8398340	PRJNA767802_P_NODE_1407_length_774_cov_2.750345_g1357_i0	PRJNA767802	1407	774	2.750345	21.2876703	Clostridium carnis	1530	Bacteria	Bacteria	1140	0	NTclustered	gi\|301051466\|gb\|FJ498870.2\|	1530	g1357	i0	93.299	965.005167958656	776	46	100	6	1	774	421	1192	Clostridium carnis 23S ribosomal RNA gene, partial sequence	blastn	746914	1140	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium carnis
9673663	9673663	PRJNA767802_P_NODE_5288_length_354_cov_4.013115_g5215_i0	PRJNA767802	5288	354	4.013115	14.2064271	Thermoanaerobacterium sp. RBIITD	1550240	Bacteria	Bacteria	612	1.2199999999999996e-170	NTclustered	gi\|1239558912\|emb\|LT906662.1\|	1550240	g5215	i0	98.834	1.94067796610169	343	4	97	0	1	343	3249117	3249459	Thermoanaerobacterium sp. RBIITD genome assembly, chromosome: I	blastn	687	612	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium sp. RBIITD
12224834	12224834	PRJNA767802_P_NODE_16390_length_166_cov_1.307692_g16317_i0	PRJNA767802	16390	166	1.307692	2.17076872	Thermoanaerobacterium thermosaccharolyticum	1517	Bacteria	Bacteria	257	2.7400000000000003e-64	NTclustered	gi\|302777039\|gb\|CP002171.1\|	580327	g16317	i0	94.578	7.01807228915663	166	9	100	0	1	166	2269182	2269017	Thermoanaerobacterium thermosaccharolyticum DSM 571, complete genome	blastn	1165	257	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium thermosaccharolyticum
13960060	13960060	PRJNA767802_P_NODE_5771_length_334_cov_1.880702_g5698_i0	PRJNA767802	5771	334	1.880702	6.28154468	Sporomusa	2375	Bacteria	Bacteria	217	1.06e-51	NTclustered	gi\|2790662264\|gb\|CP155574.1\|	2376	g5698	i0	80.565	3.67964071856287	283	53	84	2	28	309	1993934	1993653	Sporomusa paucivorans strain DSM 3697 chromosome, complete genome	blastn	1229	217	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Sporomusa	Sporomusa paucivorans
17783667	17783667	PRJNA767802_P_NODE_3274_length_490_cov_3.061224_g3203_i0	PRJNA767802	3274	490	3.061224	14.9999976	Staphylococcus	1279	Bacteria	Bacteria	900	0	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g3203	i0	99.796	473.132653061225	490	1	100	0	1	490	708498	708009	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	231835	900	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
19057825	19057825	PRJNA767802_P_NODE_5555_length_342_cov_3.757679_g5482_i0	PRJNA767802	5555	342	3.757679	12.85126218	Geobacillus	129337	Bacteria	Bacteria	592	1.54e-164	NTclustered	gi\|2529062746\|gb\|CP128458.1\|	1422	g5482	i0	99.69	24.1432748538012	323	1	94	0	20	342	3056735	3057057	Geobacillus stearothermophilus strain EF60133 chromosome, complete genome	blastn	8257	592	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
21147780	21147780	PRJNA767802_P_NODE_4777_length_382_cov_2.417417_g4704_i0	PRJNA767802	4777	382	2.417417	9.23453294	Neomoorella thermoacetica	1525	Bacteria	Bacteria	658	0	NTclustered	gi\|1101494508\|gb\|CP017237.1\|	1525	g4704	i0	98.143	11.6178010471204	377	7	99	0	6	382	1571233	1571609	Moorella thermoacetica strain DSM 103284 chromosome, complete genome	blastn	4438	658	1	Bacteria	Bacillati	Bacillota	Clostridia	Neomoorellales	Neomoorellaceae	Neomoorella	Neomoorella thermoacetica
22422404	22422404	PRJNA767802_P_NODE_10298_length_222_cov_2.653179_g10225_i0	PRJNA767802	10298	222	2.653179	5.89005738	Neomoorella thermoacetica	1525	Bacteria	Bacteria	398	2.2e-106	NTclustered	gi\|2702398649\|gb\|CP136551.1\|	1525	g10225	i0	99.095	9.96396396396396	221	2	99	0	1	221	1933034	1932814	Moorella thermoacetica strain COM chromosome, complete genome	blastn	2212	398	1	Bacteria	Bacillati	Bacillota	Clostridia	Neomoorellales	Neomoorellaceae	Neomoorella	Neomoorella thermoacetica
22422506	22422506	PRJNA767802_P_NODE_538_length_1199_cov_6.956522_g509_i0	PRJNA767802	538	1199	6.956522	83.40869878	Aeribacillus	1055323	Bacteria	Bacteria	629	4.499999999999998e-216	NR	WP_327874011.1	1868734	g509	i0	79.1	4.84153461217681	387	81	96.8	0	18	1178	224	610	WP_327874011.1 formate dehydrogenase subunit alpha [Aeribacillus composti]	diamond	5805	629	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Aeribacillus	Aeribacillus composti
22422526	22422526	PRJNA767802_P_NODE_9538_length_234_cov_2.135135_g9465_i0	PRJNA767802	9538	234	2.135135	4.9962159	Thermoanaerobacterium thermosaccharolyticum	1517	Bacteria	Bacteria	152	2.01e-32	NTclustered	gi\|2504358668\|gb\|CP116033.1\|	1517	g9465	i0	80.488	2.68376068376068	205	35	86	5	5	206	897141	897343	Thermoanaerobacterium thermosaccharolyticum strain MJ1 chromosome, complete genome	blastn	628	152	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium thermosaccharolyticum
27622042	27622042	PRJNA767802_P_NODE_2504_length_570_cov_3.397313_g2437_i0	PRJNA767802	2504	570	3.397313	19.3646841	Paenibacillus sp. HB172176	2493690	Bacteria	Bacteria	59.3	1.08e-6	NR	WP_240941536.1	2493690	g2437	i0	44.3	0.626315789473684	61	34	32.1	0	382	564	12	72	WP_240941536.1 hypothetical protein [Paenibacillus sp. HB172176]	diamond	357	59.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. HB172176
28158896	28158896	PRJNA767802_P_NODE_3065_length_510_cov_10.312364_g2994_i0	PRJNA767802	3065	510	10.312364	52.5930564	Aerococcus sp. 1KP-2	1872398	Bacteria	Bacteria	291	4.6200000000000004e-91	NR	WP_094518467.1	1981982	g2994	i0	100	0.929411764705882	158	0	92.9	0	18	491	239	396	WP_094518467.1 ATP-binding cassette domain-containing protein [Aerococcus sp. 1KP-2016]	diamond	474	291	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus sp. 1KP-2016
28379658	28379658	PRJNA767802_P_NODE_10546_length_219_cov_1.500000_g10473_i0	PRJNA767802	10546	219	1.5	3.285	Fictibacillus aquaticus	2021314	Bacteria	Bacteria	91.7	1.5e-19	NR	WP_094250820.1	2021314	g10473	i0	59.7	2.94520547945205	72	29	98.6	0	217	2	33	104	WP_094250820.1 flagellar basal-body MS-ring/collar protein FliF [Fictibacillus aquaticus]	diamond	645	91.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Fictibacillaceae	Fictibacillus	Fictibacillus aquaticus
29990064	29990064	PRJNA767802_P_NODE_14111_length_181_cov_2.348485_g14038_i0	PRJNA767802	14111	181	2.348485	4.25075785	Staphylococcus aureus	1280	Bacteria	Bacteria	43.9	0.00133	NR	MCS4580470.1	1280	g14038	i0	91.9	0.613259668508287	37	3	61.3	0	178	68	1	37	MCS4580470.1 hypothetical protein [Staphylococcus aureus]	diamond	111	43.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30653361	30653361	PRJNA767802_P_NODE_15053_length_173_cov_2.467742_g14980_i0	PRJNA767802	15053	173	2.467742	4.26919366	Lucifera butyrica	1351585	Bacteria	Bacteria	79.3	1.31e-16	NR	WP_122626647.1	1351585	g14980	i0	58.9	3.9364161849711	56	23	97.1	0	173	6	80	135	WP_122626647.1 16S rRNA (guanine(966)-N(2))-methyltransferase RsmD [Lucifera butyrica]	diamond	681	79.3	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Lucifera	Lucifera butyrica
31548404	31548404	PRJNA767802_P_NODE_3376_length_481_cov_10.043981_g3304_i0	PRJNA767802	3376	481	10.043981	48.31154861	root	1	Root_unresolved	Root_unresolved	125	1.78e-32	NR	MCK9471944.1	1903720	g3304	i0	59.8	3.54261954261954	97	39	60.5	0	481	191	120	216	MCK9471944.1 hypothetical protein [Bacilli bacterium]	diamond	1704	126	0.992063492063492	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
32202944	32202944	PRJNA767802_P_NODE_13438_length_188_cov_0.928058_g13365_i0	PRJNA767802	13438	188	0.928058	1.74474904	Lacticaseibacillus paracasei	1597	Bacteria	Bacteria	117	1.19e-32	NR	MFK5282332.1	1597	g13365	i0	98.2	0.877659574468085	55	1	87.8	0	22	186	1	55	MFK5282332.1 hypothetical protein [Lacticaseibacillus paracasei]	diamond	165	117	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
32676778	32676778	PRJNA767802_P_NODE_17880_length_163_cov_0.894737_g17807_i0	PRJNA767802	17880	163	0.894737	1.45842131	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	53.9	1.43e-6	NR	MBQ1341607.1	2049044	g17807	i0	60.4	0.883435582822086	48	18	88.3	1	16	159	1	47	MBQ1341607.1 DUF2213 domain-containing protein [Erysipelotrichaceae bacterium]	diamond	144	53.9	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae 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);;