metadata: contig_metadata: 35 rows where bioproject = "PRJNA753151" and tax

35 rows where bioproject = "PRJNA753151" 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
1201828	1201828	PRJNA753151_S_NODE_151681_length_236_cov_1.398964_g149391_i0	PRJNA753151	151681	236	1.398964	3.30155504	Lactobacillus	1578	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g149391	i0	100	393.949152542373	236	0	100	0	1	236	89369	89604	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	92972	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
1201884	1201884	PRJNA753151_S_NODE_269201_length_171_cov_2.109375_g266911_i0	PRJNA753151	269201	171	2.109375	3.60703125	Staphylococcus	1279	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2150735284\|gb\|CP086659.1\|	29388	g266911	i0	100	42	171	0	100	0	1	171	733816	733986	Staphylococcus capitis strain XZ03 chromosome, complete genome	blastn	7182	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
2477242	2477242	PRJNA753151_S_NODE_160682_length_229_cov_2.844086_g158392_i0	PRJNA753151	160682	229	2.844086	6.51295694	Staphylococcus	1279	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g158392	i0	100	100	229	0	100	0	1	229	2239106	2239334	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	22900	424	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2477303	2477303	PRJNA753151_S_NODE_291882_length_163_cov_1.125000_g289592_i0	PRJNA753151	291882	163	1.125	1.83375	root	1	Root_unresolved	Root_unresolved	296	5.68e-76	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g289592	i0	99.387	100	163	1	100	0	1	163	1720506	1720668	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	16300	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
3753568	3753568	PRJNA753151_S_NODE_207943_length_200_cov_1.433121_g205653_i0	PRJNA753151	207943	200	1.433121	2.866242	Streptococcus	1301	Bacteria	Bacteria	370	4.22e-98	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g205653	i0	100	340.31	200	0	100	0	1	200	424075	424274	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	68062	370	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3753580	3753580	PRJNA753151_S_NODE_228023_length_189_cov_2.849315_g225733_i0	PRJNA753151	228023	189	2.849315	5.38520535	Staphylococcus	1279	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g225733	i0	100	102.206349206349	189	0	100	0	1	189	761243	761431	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	19317	350	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
3753609	3753609	PRJNA753151_S_NODE_278683_length_167_cov_35.411290_g276393_i0	PRJNA753151	278683	167	35.41129	59.1368543	root	1	Root_unresolved	Root_unresolved	309	7.53e-80	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g276393	i0	100	99.6826347305389	167	0	100	0	1	167	2463838	2463672	Staphylococcus aureus strain WH9628 chromosome	blastn	16647	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
5030206	5030206	PRJNA753151_S_NODE_295984_length_161_cov_2.288136_g293694_i0	PRJNA753151	295984	161	2.288136	3.68389896	Staphylococcus	1279	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g293694	i0	100	98.2919254658385	161	0	100	0	1	161	2284651	2284491	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	15825	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
6305880	6305880	PRJNA753151_S_NODE_146705_length_239_cov_7.918367_g144415_i0	PRJNA753151	146705	239	7.918367	18.92489713	Staphylococcus	1279	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|2688295587\|gb\|CP145595.1\|	29388	g144415	i0	100	475.476987447699	239	0	100	0	1	239	2299167	2299405	Staphylococcus capitis strain kcgeb_sa chromosome, complete genome	blastn	113639	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
7579824	7579824	PRJNA753151_S_NODE_176226_length_219_cov_1.272727_g173936_i0	PRJNA753151	176226	219	1.272727	2.78727213	Staphylococcus	1279	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g173936	i0	100	100	219	0	100	0	1	219	2247562	2247344	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	21900	405	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
8854869	8854869	PRJNA753151_S_NODE_200887_length_204_cov_1.397516_g198597_i0	PRJNA753151	200887	204	1.397516	2.85093264	Bacteria	2	Bacteria	Bacteria	366	5.599999999999998e-97	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g198597	i0	99.02	124.210784313725	204	2	100	0	1	204	442	645	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	25339	366	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8854908	8854908	PRJNA753151_S_NODE_268767_length_171_cov_2.765625_g266477_i0	PRJNA753151	268767	171	2.765625	4.72921875	Staphylococcus	1279	Bacteria	Bacteria	311	2.14e-80	NTclustered	gi\|691218329\|gb\|CP009046.1\|	1282	g266477	i0	99.415	478	171	1	100	0	1	171	638303	638473	Staphylococcus epidermidis strain SEI, complete genome	blastn	81738	311	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12681536	12681536	PRJNA753151_S_NODE_211790_length_198_cov_1.451613_g209500_i0	PRJNA753151	211790	198	1.451613	2.87419374	Staphylococcus	1279	Bacteria	Bacteria	322	1.18e-83	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g209500	i0	100	87.8787878787879	174	0	88	0	25	198	498068	497895	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	17400	322	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13483463	13483463	PRJNA753151_S_NODE_166311_length_225_cov_3.461538_g164021_i0	PRJNA753151	166311	225	3.461538	7.7884605	Anaerococcus prevotii	33034	Bacteria	Bacteria	411	2.869999999999999e-110	NTclustered	gi\|256797400\|gb\|CP001708.1\|	525919	g164021	i0	99.556	248.431111111111	225	1	100	0	1	225	239640	239416	Anaerococcus prevotii DSM 20548, complete genome	blastn	55897	411	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
14758259	14758259	PRJNA753151_S_NODE_109192_length_273_cov_1.721739_g106902_i0	PRJNA753151	109192	273	1.721739	4.70034747	Staphylococcus pasteuri	45972	Bacteria	Bacteria	505	1.6e-138	NTclustered	gi\|1250045397\|gb\|CP017463.1\|	45972	g106902	i0	100	99.5970695970696	273	0	100	0	1	273	2309319	2309591	Staphylococcus pasteuri strain JS7 chromosome, complete genome	blastn	27190	505	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri
16504769	16504769	PRJNA753151_S_NODE_134693_length_249_cov_3.033981_g132403_i0	PRJNA753151	134693	249	3.033981	7.55461269	Staphylococcus	1279	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g132403	i0	100	99.2008032128514	249	0	100	0	1	249	1788448	1788200	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	24701	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
16504889	16504889	PRJNA753151_S_NODE_90533_length_294_cov_3.406375_g88243_i0	PRJNA753151	90533	294	3.406375	10.0147425	Staphylococcus	1279	Bacteria	Bacteria	544	3.69e-150	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g88243	i0	100	100	294	0	100	0	1	294	701066	700773	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	29400	544	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
23683358	23683358	PRJNA753151_S_NODE_294699_length_162_cov_1.134454_g292409_i0	PRJNA753151	294699	162	1.134454	1.83781548	Staphylococcus epidermidis	1282	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2522199385\|gb\|CP127869.1\|	1282	g292409	i0	100	100	162	0	100	0	1	162	1629770	1629931	Staphylococcus epidermidis strain NG02 chromosome, complete genome	blastn	16200	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
24153545	24153545	PRJNA753151_S_NODE_253419_length_178_cov_1.000000_g251129_i0	PRJNA753151	253419	178	1	1.78	Staphylococcus	1279	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|2150735284\|gb\|CP086659.1\|	29388	g251129	i0	100	42.4101123595506	178	0	100	0	1	178	1474146	1474323	Staphylococcus capitis strain XZ03 chromosome, complete genome	blastn	7549	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
24956273	24956273	PRJNA753151_S_NODE_17960_length_524_cov_13.604990_g15920_i0	PRJNA753151	17960	524	13.60499	71.2901476	Natroniella sp. ANB-PHB2	3384444	Bacteria	Bacteria	54.7	0.014	NTclustered	gi\|2869714905\|gb\|CP175562.1\|	3384444	g15920	i0	100	0.0553435114503817	29	0	6	0	255	283	1966718	1966746	Natroniella sp. ANB-PHB2 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halobacteroidaceae	Natroniella	Natroniella sp. ANB-PHB2
26799671	26799671	PRJNA753151_S_NODE_159961_length_230_cov_0.935829_g157671_i0	PRJNA753151	159961	230	0.935829	2.1524067	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	140	3.65e-37	NR	MBQ8039213.1	1898203	g157671	i0	80.3	0.991304347826087	76	15	99.1	0	228	1	289	364	MBQ8039213.1 IS66 family transposase [Lachnospiraceae bacterium]	diamond	228	140	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
27274183	27274183	PRJNA753151_S_NODE_288963_length_164_cov_1.115702_g286673_i0	PRJNA753151	288963	164	1.115702	1.82975128	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	102	9.28e-26	NR	MBQ5918651.1	1898203	g286673	i0	96.3	0.98780487804878	54	2	98.8	0	1	162	88	141	MBQ5918651.1 5-(carboxyamino)imidazole ribonucleotide mutase [Lachnospiraceae bacterium]	diamond	162	102	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
27968872	27968872	PRJNA753151_S_NODE_102745_length_279_cov_10.864407_g100455_i0	PRJNA753151	102745	279	10.864407	30.31169553	Enterococcus mundtii	53346	Bacteria	Bacteria	44.7	0.011	NR	WP_108173663.1	53346	g100455	i0	34	1.04301075268817	97	52	91.4	4	256	2	178	274	WP_108173663.1 glycosyltransferase family 2 protein, partial [Enterococcus mundtii]	diamond	291	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus mundtii
28063541	28063541	PRJNA753151_S_NODE_288725_length_164_cov_1.487603_g286435_i0	PRJNA753151	288725	164	1.487603	2.43966892	Veillonella sp.	1926307	Bacteria	Bacteria	40.8	0.0341	NR	MDU7823949.1	1926307	g286435	i0	46.7	0.823170731707317	45	24	82.3	0	161	27	44	88	MDU7823949.1 phenylalanine--tRNA ligase subunit beta [Veillonella sp.]	diamond	135	40.8	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella sp.
29231970	29231970	PRJNA753151_S_NODE_152929_length_235_cov_1.713542_g150639_i0	PRJNA753151	152929	235	1.713542	4.0268237	Tissierella praeacuta	43131	Bacteria	Bacteria	42.7	0.034	NR	WP_353095936.1	43131	g150639	i0	40.4	0.663829787234043	52	31	66.4	0	165	10	201	252	WP_353095936.1 M56 family metallopeptidase [Tissierella praeacuta]	diamond	156	42.7	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Tissierella	Tissierella praeacuta
29263231	29263231	PRJNA753151_S_NODE_179389_length_217_cov_1.034483_g177099_i0	PRJNA753151	179389	217	1.034483	2.24482811	Listeria monocytogenes	1639	Bacteria	Bacteria	42	0.00646	NR	MCH2749318.1	1639	g177099	i0	47.1	0.705069124423963	51	26	69.1	1	66	215	2	52	MCH2749318.1 hypothetical protein [Listeria monocytogenes]	diamond	153	42	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
29389866	29389866	PRJNA753151_S_NODE_273809_length_169_cov_3.507937_g271519_i0	PRJNA753151	273809	169	3.507937	5.92841353	Staphylococcus aureus	1280	Bacteria	Bacteria	44.3	0.00389	NR	QHG80493.1	1280	g271519	i0	53.5	1.52662721893491	43	18	72.8	1	37	159	195	237	QHG80493.1 hypothetical protein D7B62_12635 [Staphylococcus aureus]	diamond	258	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
29683410	29683410	PRJNA753151_S_NODE_73570_length_317_cov_8.693431_g71280_i0	PRJNA753151	73570	317	8.693431	27.55817627	Lachnospiraceae	186803	Bacteria	Bacteria	47.8	0.00133	NR	WP_242827130.1	1280669	g71280	i0	36.5	1.81703470031546	96	51	89.9	4	315	31	169	255	WP_242827130.1 Rep protein [Dorea sp. AGR2135]	diamond	576	47.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Dorea	Dorea sp. AGR2135
29895055	29895055	PRJNA753151_S_NODE_181451_length_215_cov_3.372093_g179161_i0	PRJNA753151	181451	215	3.372093	7.24999995	[Clostridium] innocuum	1522	Bacteria	Bacteria	43.1	0.0182	NR	WP_233106945.1	1522	g179161	i0	39.7	0.809302325581395	58	29	80.9	2	198	25	59	110	WP_233106945.1 isoaspartyl peptidase/L-asparaginase [[Clostridium] innocuum]	diamond	174	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum
30242571	30242571	PRJNA753151_S_NODE_300612_length_160_cov_0.786325_g298322_i0	PRJNA753151	300612	160	0.786325	1.25812	Streptococcus suis	1307	Bacteria	Bacteria	42.4	0.00226	NR	WP_319443996.1	1307	g298322	i0	73.9	0.84375	23	6	43.1	0	159	91	24	46	WP_319443996.1 hypothetical protein, partial [Streptococcus suis]	diamond	135	42.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
30464068	30464068	PRJNA753151_S_NODE_177853_length_218_cov_1.005714_g175563_i0	PRJNA753151	177853	218	1.005714	2.19245652	[Clostridium] innocuum	1522	Bacteria	Bacteria	42	0.0484	NR	WP_233106945.1	1522	g175563	i0	39	0.564220183486238	41	25	56.4	0	90	212	69	109	WP_233106945.1 isoaspartyl peptidase/L-asparaginase [[Clostridium] innocuum]	diamond	123	42	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum
30811182	30811182	PRJNA753151_S_NODE_128014_length_255_cov_1.910377_g125724_i0	PRJNA753151	128014	255	1.910377	4.87146135	Atopostipes sp.	1872652	Bacteria	Bacteria	167	2.23e-49	NR	HZK46646.1	1872652	g125724	i0	96.4	0.988235294117647	84	3	98.8	0	254	3	199	282	HZK46646.1 peptide chain release factor N(5)-glutamine methyltransferase [Atopostipes sp.]	diamond	252	167	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Atopostipes	Atopostipes sp.
31959262	31959262	PRJNA753151_S_NODE_221297_length_193_cov_1.486667_g219007_i0	PRJNA753151	221297	193	1.486667	2.86926731	Peptoniphilus	162289	Bacteria	Bacteria	128	1.6699999999999998e-32	NR	WP_273497505.1	1175452	g219007	i0	100	3.97927461139896	64	0	99.5	0	2	193	306	369	WP_273497505.1 S-layer homology domain-containing protein [Peptoniphilus rhinitidis]	diamond	768	128	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus rhinitidis
32266137	32266137	PRJNA753151_S_NODE_64838_length_332_cov_2.647059_g62548_i0	PRJNA753151	64838	332	2.647059	8.78823588	Staphylococcus aureus	1280	Bacteria	Bacteria	50.8	1.42e-4	NR	QHG80002.1	1280	g62548	i0	56	0.451807228915663	50	19	43.4	2	161	18	297	345	QHG80002.1 hypothetical protein D7B62_12520 [Staphylococcus aureus]	diamond	150	50.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32370852	32370852	PRJNA753151_S_NODE_7679_length_721_cov_1.805310_g6353_i0	PRJNA753151	7679	721	1.80531	13.0162851	root	1	Root_unresolved	Root_unresolved	311	2.13e-93	NR	WP_306789577.1	1280	g6353	i0	69	44.750346740638	239	74	99.4	0	3	719	850	1088	WP_306789577.1 type II CRISPR RNA-guided endonuclease Cas9 [Staphylococcus aureus]	diamond	32265	312	0.996794871794872	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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