metadata: contig_metadata: 17 rows where bioproject = "PRJNA929952", tax_kingdom = "Bacillati" and tax

17 rows where bioproject = "PRJNA929952", tax_kingdom = "Bacillati" 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
1254794	1254794	PRJNA929952_P_NODE_8541_length_408_cov_2.693931_g7281_i0	PRJNA929952	8541	408	2.693931	10.99123848	Exiguobacterium	33986	Bacteria	Bacteria	309	2.11e-79	NTclustered	gi\|2851161950\|gb\|CP085018.1\|	169177	g7281	i0	90.598	225.014705882353	234	21	57	1	1	233	13911	13678	Exiguobacterium undae strain SLM-182 chromosome, complete genome	blastn	91806	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium undae
3806830	3806830	PRJNA929952_P_NODE_20783_length_197_cov_780.755952_g19489_i0	PRJNA929952	20783	197	780.755952	1538.08922544	Staphylococcus	1279	Bacteria	Bacteria	285	1.55e-72	NTclustered	gi\|1403776180\|emb\|LS483311.1\|	1280	g19489	i0	92.893	531.238578680203	197	13	100	1	1	197	564594	564789	Staphylococcus aureus strain NCTC6136 genome assembly, chromosome: 1	blastn	104654	287	0.993031358885017	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8907601	8907601	PRJNA929952_P_NODE_20607_length_200_cov_3.345029_g19313_i0	PRJNA929952	20607	200	3.345029	6.690058	root	1	Root_unresolved	Root_unresolved	370	4.22e-98	NTclustered	gi\|2675654968\|gb\|PP338727.1\|	1579	g19313	i0	100	115	200	0	100	0	1	200	794	595	Lactobacillus acidophilus strain RG-07 16S ribosomal RNA gene, partial sequence	blastn	23000	370	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus acidophilus
12388305	12388305	PRJNA929952_P_NODE_15710_length_258_cov_3.000000_g14416_i0	PRJNA929952	15710	258	3	7.74	Clostridium culturomicium	1499683	Bacteria	Bacteria	104	6.39e-18	NTclustered	gi\|2831321202\|gb\|CP171113.1\|	1499683	g14416	i0	90	132.06976744186	80	8	31	0	179	258	11431	11352	Clostridium culturomicium strain WGS1527 chromosome, complete genome	blastn	34074	104	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium culturomicium
12734238	12734238	PRJNA929952_P_NODE_7050_length_460_cov_4.638051_g5857_i0	PRJNA929952	7050	460	4.638051	21.3350346	Lactobacillus	1578	Bacteria	Bacteria	795	0	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g5857	i0	97.826	422.039130434783	460	10	100	0	1	460	90717	90258	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	194138	795	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
14008786	14008786	PRJNA929952_P_NODE_15631_length_259_cov_3.182609_g14337_i0	PRJNA929952	15631	259	3.182609	8.24295731	Lactobacillus	1578	Bacteria	Bacteria	473	4.25e-129	NTclustered	gi\|2913177562\|gb\|CP180627.1\|	47770	g14337	i0	99.614	384.752895752896	259	1	100	0	1	259	1145899	1146157	Lactobacillus crispatus strain T31e chromosome, complete genome	blastn	99651	473	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
15282743	15282743	PRJNA929952_P_NODE_7052_length_460_cov_4.176334_g5859_i0	PRJNA929952	7052	460	4.176334	19.2111364	Lactobacillus	1578	Bacteria	Bacteria	850	0	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g5859	i0	100	422.039130434783	460	0	100	0	1	460	90258	90717	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	194138	850	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
17487403	17487403	PRJNA929952_P_NODE_10174_length_361_cov_10.924699_g8891_i0	PRJNA929952	10174	361	10.924699	39.43816339	Ruminiclostridium cellulolyticum	1521	Bacteria	Bacteria	84.2	1.21e-11	NTclustered	gi\|219997787\|gb\|CP001348.1\|	394503	g8891	i0	86.842	35.5346260387812	76	9	21	1	167	241	4054877	4054952	Ruminiclostridium cellulolyticum H10 chromosome, complete genome	blastn	12828	84.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminiclostridium	Ruminiclostridium cellulolyticum
20035803	20035803	PRJNA929952_P_NODE_8616_length_405_cov_11.707447_g7356_i0	PRJNA929952	8616	405	11.707447	47.41516035	Ruminiclostridium cellulolyticum	1521	Bacteria	Bacteria	84.2	1.38e-11	NTclustered	gi\|219997787\|gb\|CP001348.1\|	394503	g7356	i0	87.5	0.444444444444444	72	9	18	0	214	285	4054881	4054952	Ruminiclostridium cellulolyticum H10 chromosome, complete genome	blastn	180	84.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminiclostridium	Ruminiclostridium cellulolyticum
20381146	20381146	PRJNA929952_P_NODE_21436_length_188_cov_5.157233_g20142_i0	PRJNA929952	21436	188	5.157233	9.69559804	Bacillati	1783272	Bacteria	Bacteria	237	4.14e-58	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g20142	i0	100	513.63829787234	128	0	99	0	60	187	748549	748422	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	96564	237	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
21311257	21311257	PRJNA929952_P_NODE_3157_length_697_cov_3.962575_g2366_i0	PRJNA929952	3157	697	3.962575	27.61914775	Streptococcus australis	113107	Bacteria	Bacteria	553	1.5699999999999996e-152	NTclustered	gi\|1686100210\|gb\|MK330558.1\|	113107	g2366	i0	92.347	326.004304160689	392	25	56	4	1	391	2882	3269	Streptococcus australis strain 2086_09 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	227225	553	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus australis
22932629	22932629	PRJNA929952_P_NODE_20078_length_209_cov_3.266667_g18784_i0	PRJNA929952	20078	209	3.266667	6.82733403	Streptococcus	1301	Bacteria	Bacteria	261	2.8e-65	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g18784	i0	100	351.421052631579	141	0	100	0	69	209	1571258	1571398	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	73447	261	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
22932635	22932635	PRJNA929952_P_NODE_21798_length_183_cov_3.714286_g20504_i0	PRJNA929952	21798	183	3.714286	6.79714338	root	1	Root_unresolved	Root_unresolved	339	1.07e-88	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g20504	i0	100	103	183	0	100	0	1	183	1572698	1572880	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	18849	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
24206408	24206408	PRJNA929952_P_NODE_7439_length_445_cov_6.072115_g6222_i0	PRJNA929952	7439	445	6.072115	27.02091175	Staphylococcus	1279	Bacteria	Bacteria	787	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g6222	i0	98.652	504.065168539326	445	5	100	1	1	445	2278389	2277946	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	224309	787	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
26961480	26961480	PRJNA929952_P_NODE_2882_length_723_cov_3.785303_g2147_i0	PRJNA929952	2882	723	3.785303	27.36774069	Massilimicrobiota sp. An142	1965564	Bacteria	Bacteria	44.3	0.0168	NR	OUQ08064.1	1965564	g2147	i0	47.8	0.190871369294606	46	24	19.1	0	355	492	6	51	OUQ08064.1 hypothetical protein B5E87_14690 [Massilimicrobiota sp. An142]	diamond	138	44.3	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Massilimicrobiota	Massilimicrobiota sp. An142
27277918	27277918	PRJNA929952_P_NODE_21063_length_193_cov_8.341463_g19769_i0	PRJNA929952	21063	193	8.341463	16.09902359	Clostridiales bacterium	1898207	Bacteria	Bacteria	42.7	0.0196	NR	NLE68665.1	1898207	g19769	i0	51.4	0.575129533678757	37	15	57.5	1	130	20	97	130	NLE68665.1 hypothetical protein [Clostridiales bacterium]	diamond	111	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
31953037	31953037	PRJNA929952_P_NODE_2897_length_721_cov_3.923410_g2147_i1	PRJNA929952	2897	721	3.92341	28.2877861	Massilimicrobiota sp. An142	1965564	Bacteria	Bacteria	44.3	0.0167	NR	OUQ08064.1	1965564	g2147	i1	47.8	0.191400832177531	46	24	19.1	0	369	232	6	51	OUQ08064.1 hypothetical protein B5E87_14690 [Massilimicrobiota sp. An142]	diamond	138	44.3	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Massilimicrobiota	Massilimicrobiota sp. An142

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