metadata: contig_metadata: 22 rows where bioproject = "PRJNA768450" and tax

22 rows where bioproject = "PRJNA768450" 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
1206172	1206172	PRJNA768450_S_NODE_20741_length_168_cov_0.983193_g20692_i0	PRJNA768450	20741	168	0.983193	1.65176424	Lactobacillus	1578	Bacteria	Bacteria	270	3.5799999999999998e-68	NTclustered	gi\|2913177562\|gb\|CP180627.1\|	47770	g20692	i0	96.894	377.928571428571	161	5	98	0	6	166	1146118	1145958	Lactobacillus crispatus strain T31e chromosome, complete genome	blastn	63492	270	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
2481549	2481549	PRJNA768450_P_NODE_302_length_603_cov_21.487805_g267_i0	PRJNA768450	302	603	21.487805	129.57146415	Streptococcus	1301	Bacteria	Bacteria	966	0	NTclustered	gi\|2890261556\|gb\|CP177179.1\|	1304	g267	i0	96.167	562.006633499171	600	8	100	2	4	603	67425	66841	Streptococcus salivarius strain MRD-NRLLH chromosome, complete genome	blastn	338890	966	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
3296909	3296909	PRJNA768450_S_NODE_19263_length_172_cov_30.796748_g19214_i0	PRJNA768450	19263	172	30.796748	52.97040656	Staphylococcus aureus	1280	Bacteria	Bacteria	263	6.12e-66	NTclustered	gi\|1909943138\|dbj\|LC576395.1\|	1280	g19214	i0	98.649	85.7325581395349	148	2	86	0	3	150	479	626	Staphylococcus aureus IRQBAS98 gene for 16S rRNA, partial sequence	blastn	14746	263	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
5034591	5034591	PRJNA768450_S_NODE_25264_length_154_cov_3.723810_g25215_i0	PRJNA768450	25264	154	3.72381	5.7346674	Bacteria	2	Bacteria	Bacteria	283	4.12e-72	NTclustered	gi\|166359576\|gb\|EU382220.1\|	1423	g25215	i0	100	99.3506493506493	153	0	99	0	1	153	629	781	Bacillus subtilis strain 15-2 16S ribosomal RNA gene, partial sequence	blastn	15300	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus subtilis
6310160	6310160	PRJNA768450_P_NODE_1125_length_269_cov_8.854167_g1053_i0	PRJNA768450	1125	269	8.854167	23.81770923	Lactobacillus	1578	Bacteria	Bacteria	488	1.5799999999999998e-133	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g1053	i0	100	414.197026022305	264	0	98	0	1	264	89647	89910	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	111419	488	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
7124038	7124038	PRJNA768450_P_NODE_186_length_766_cov_5.280868_g163_i0	PRJNA768450	186	766	5.280868	40.45144888	Hathewaya histolytica	1498	Bacteria	Bacteria	684	0	NTclustered	gi\|3080568\|dbj\|AB013091.1\|	1498	g163	i0	100	819.855091383812	370	0	93	0	1	370	275	644	Clostridium histolyticum rrlC gene for 23S rRNA, partial sequence	blastn	628009	684	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
7584356	7584356	PRJNA768450_S_NODE_4466_length_301_cov_1.873016_g4417_i0	PRJNA768450	4466	301	1.873016	5.63777816	Anoxybacillus	150247	Bacteria	Bacteria	350	8.87e-92	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g4417	i0	95.089	605.083056478405	224	7	74	4	1	222	1975390	1975611	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	182130	350	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
8398857	8398857	PRJNA768450_S_NODE_18747_length_174_cov_2.320000_g18698_i0	PRJNA768450	18747	174	2.32	4.0368	uncultured Eubacterium sp.	165185	Bacteria	Bacteria	281	1.71e-71	NTclustered	gi\|125629137\|emb\|AM422217.1\|	165185	g18698	i0	98.148	85.7183908045977	162	2	93	1	10	170	1196	1357	Uncultured Eubacterium sp. partial 16S rRNA gene, clone 1	blastn	14915	281	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	uncultured Eubacterium sp.
8859270	8859270	PRJNA768450_S_NODE_11167_length_211_cov_2.567901_g11118_i0	PRJNA768450	11167	211	2.567901	5.41827111	Streptococcus	1301	Bacteria	Bacteria	379	7.489999999999999e-101	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g11118	i0	99.519	320.454976303318	208	1	99	0	1	208	422982	422775	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	67616	379	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
10134729	10134729	PRJNA768450_S_NODE_11208_length_211_cov_1.703704_g11159_i0	PRJNA768450	11208	211	1.703704	3.59481544	Streptococcus	1301	Bacteria	Bacteria	255	1.32e-63	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g11159	i0	98.621	234.971563981043	145	0	68	1	40	182	1569860	1570004	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	49579	255	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
11409953	11409953	PRJNA768450_S_NODE_10349_length_218_cov_1.195266_g10300_i0	PRJNA768450	10349	218	1.195266	2.60567988	Bacillus	1386	Bacteria	Bacteria	383	6.02e-102	NTclustered	gi\|2033726263\|gb\|CP072766.1\|	1396	g10300	i0	99.524	1158.07798165138	210	1	96	0	9	218	13073	13282	Bacillus cereus strain BC06 chromosome, complete genome	blastn	252461	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
11410156	11410156	PRJNA768450_S_NODE_5769_length_273_cov_1.727679_g5720_i0	PRJNA768450	5769	273	1.727679	4.71656367	Staphylococcus	1279	Bacteria	Bacteria	503	5.76e-138	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g5720	i0	100	472.864468864469	272	0	99	0	1	272	750395	750666	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	129092	503	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12685780	12685780	PRJNA768450_P_NODE_1910_length_150_cov_8.520661_g1838_i0	PRJNA768450	1910	150	8.520661	12.7809915	Lactococcus	1357	Bacteria	Bacteria	233	4.07e-57	NTclustered	gi\|1487531270\|gb\|CP032627.1\|	2419773	g1838	i0	94.667	530.513333333333	150	8	100	0	1	150	24992	25141	Lactococcus allomyrinae strain 1JSPR-7 chromosome, complete genome	blastn	79577	233	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus allomyrinae
13499616	13499616	PRJNA768450_S_NODE_23971_length_161_cov_2.107143_g23922_i0	PRJNA768450	23971	161	2.107143	3.39250023	uncultured Eubacterium sp.	165185	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|125629137\|emb\|AM422217.1\|	165185	g23922	i0	98.758	62.8509316770186	161	2	100	0	1	161	284	124	Uncultured Eubacterium sp. partial 16S rRNA gene, clone 1	blastn	10119	287	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	uncultured Eubacterium sp.
13960081	13960081	PRJNA768450_P_NODE_1691_length_185_cov_7.532051_g1619_i0	PRJNA768450	1691	185	7.532051	13.93429435	Clostridiaceae	31979	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g1619	i0	100	147.178378378378	185	0	100	0	1	185	9166	8982	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	27228	342	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
13960085	13960085	PRJNA768450_P_NODE_851_length_342_cov_24.424920_g780_i0	PRJNA768450	851	342	24.42492	83.5332264	FCB group	1783270	Bacteria	Bacteria	627	4.22e-175	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g780	i0	99.708	536.897660818713	342	1	100	0	1	342	523053	523394	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	183619	632	0.992088607594937	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
17783704	17783704	PRJNA768450_P_NODE_694_length_391_cov_6.651934_g627_i0	PRJNA768450	694	391	6.651934	26.00906194	Streptococcus	1301	Bacteria	Bacteria	377	5.43e-100	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g627	i0	100	553.49104859335	204	0	97	0	188	391	16678	16881	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	216415	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
21147893	21147893	PRJNA768450_P_NODE_1277_length_241_cov_4.636792_g1205_i0	PRJNA768450	1277	241	4.636792	11.17466872	Hathewaya histolytica	1498	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|3080566\|dbj\|AB013089.1\|	1498	g1205	i0	100	805.917012448133	241	0	100	0	1	241	2314	2554	Clostridium histolyticum rrlA gene for 23S rRNA, partial sequence	blastn	194226	446	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
21608335	21608335	PRJNA768450_S_NODE_14297_length_193_cov_2.368056_g14248_i0	PRJNA768450	14297	193	2.368056	4.57034808	Staphylococcus	1279	Bacteria	Bacteria	357	3.1499999999999996e-94	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g14248	i0	100	465.295336787565	193	0	100	0	1	193	708527	708335	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	89802	357	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
22422606	22422606	PRJNA768450_P_NODE_1058_length_285_cov_2.714844_g986_i0	PRJNA768450	1058	285	2.714844	7.7373054	Hathewaya histolytica	1498	Bacteria	Bacteria	505	1.6799999999999995e-138	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g986	i0	98.601	965.866666666667	286	3	100	1	1	285	11143	10858	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	275272	505	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
22883821	22883821	PRJNA768450_P_NODE_1238_length_247_cov_13.041284_g1166_i0	PRJNA768450	1238	247	13.041284	32.21197148	Hathewaya	1769729	Bacteria	Bacteria	379	9.02e-101	NTclustered	gi\|3080568\|dbj\|AB013091.1\|	1498	g1166	i0	97.309	733.210526315789	223	6	90	0	1	223	2124	1902	Clostridium histolyticum rrlC gene for 23S rRNA, partial sequence	blastn	181103	381	0.994750656167979	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
24972046	24972046	PRJNA768450_S_NODE_12440_length_203_cov_3.194805_g12391_i0	PRJNA768450	12440	203	3.194805	6.48545415	Staphylococcus epidermidis	1282	Bacteria	Bacteria	364	2e-96	NTclustered	gi\|2489625674\|gb\|CP121231.1\|	1282	g12391	i0	99.015	525.133004926108	203	2	100	0	1	203	95270	95068	Staphylococcus epidermidis strain 9 chromosome	blastn	106602	364	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis

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