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

30 rows where bioproject = "PRJEB12982" 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
985677	985677	PRJEB12982_P_NODE_10941_length_213_cov_1.256098_g10778_i0	PRJEB12982	10941	213	1.256098	2.67548874	Lactobacillus	1578	Bacteria	Bacteria	394	2.7e-105	NTclustered	gi\|2913931147\|gb\|CP181267.1\|	1584	g10778	i0	100	400.244131455399	213	0	100	0	1	213	572564	572352	MAG: Lactobacillus delbrueckii isolate UW_FK_LACTO1_1 chromosome	blastn	85252	394	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus delbrueckii
985708	985708	PRJEB12982_P_NODE_5621_length_314_cov_1.071698_g5458_i0	PRJEB12982	5621	314	1.071698	3.36513172	Companilactobacillus	2767879	Bacteria	Bacteria	481	3.16e-131	NTclustered	gi\|1678291493\|gb\|CP040736.1\|	938155	g5458	i0	94.322	542.834394904459	317	13	100	4	1	314	33918	34232	Companilactobacillus futsaii strain Y97 chromosome, complete genome	blastn	170450	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus futsaii
2260990	2260990	PRJEB12982_P_NODE_7962_length_255_cov_4.242718_g7799_i0	PRJEB12982	7962	255	4.242718	10.8189309	Staphylococcus	1279	Bacteria	Bacteria	472	1.5e-128	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g7799	i0	100	474.462745098039	255	0	100	0	1	255	750695	750441	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	120988	472	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4813526	4813526	PRJEB12982_P_NODE_15224_length_177_cov_1.593750_g15061_i0	PRJEB12982	15224	177	1.59375	2.8209375	Lysinibacillus	400634	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|1333950533\|gb\|CP026007.1\|	2072025	g15061	i0	100	20.9661016949153	177	0	100	0	1	177	510049	509873	Lysinibacillus sp. YS11 chromosome, complete genome	blastn	3711	327	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. YS11
4813530	4813530	PRJEB12982_P_NODE_16924_length_167_cov_0.864407_g16761_i0	PRJEB12982	16924	167	0.864407	1.44355969	Streptococcus	1301	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1948576487\|gb\|CP065994.1\|	102684	g16761	i0	100	108.652694610778	167	0	100	0	1	167	41589	41423	Streptococcus infantarius strain FDAARGOS_1019 chromosome, complete genome	blastn	18145	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantarius
5123458	5123458	PRJEB12982_P_NODE_8405_length_247_cov_1.388889_g8242_i0	PRJEB12982	8405	247	1.388889	3.43055583	Finegoldia magna	1260	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2831269597\|gb\|CP170999.1\|	1260	g8242	i0	99.595	35.1052631578947	247	1	100	0	1	247	871224	871470	Finegoldia magna strain WGS1513 chromosome, complete genome	blastn	8671	451	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
7363394	7363394	PRJEB12982_P_NODE_9466_length_230_cov_3.000000_g9303_i0	PRJEB12982	9466	230	3	6.9	Staphylococcus	1279	Bacteria	Bacteria	398	2.2899999999999997e-106	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g9303	i0	97.826	532.778260869565	230	5	100	0	1	230	2168054	2168283	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	122539	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
7673226	7673226	PRJEB12982_P_NODE_3327_length_422_cov_3.930295_g3166_i0	PRJEB12982	3327	422	3.930295	16.5858449	Staphylococcus aureus	1280	Bacteria	Bacteria	564	4.219999999999999e-156	NTclustered	gi\|1747262679\|gb\|CP043912.1\|	1280	g3166	i0	90.78	538.281990521327	423	33	100	6	1	420	2162853	2163272	Staphylococcus aureus strain GHA12 chromosome	blastn	227155	564	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
7673247	7673247	PRJEB12982_P_NODE_5747_length_310_cov_1.145594_g5584_i0	PRJEB12982	5747	310	1.145594	3.5513414	Terrilactibacillus sp. S3-3	2969846	Bacteria	Bacteria	484	2.4099999999999996e-132	NTclustered	gi\|2533273496\|gb\|CP129291.1\|	2969846	g5584	i0	94.855	890.364516129032	311	14	100	2	1	310	1548478	1548169	Terrilactibacillus sp. S3-3 chromosome, complete genome	blastn	276013	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Terrilactibacillus	Terrilactibacillus sp. S3-3
9913861	9913861	PRJEB12982_P_NODE_3328_length_422_cov_3.509383_g3166_i1	PRJEB12982	3328	422	3.509383	14.80959626	Staphylococcus	1279	Bacteria	Bacteria	628	1.48e-175	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g3166	i1	93.677	548.431279620853	427	16	99	11	1	421	700318	699897	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	231438	628	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
9913872	9913872	PRJEB12982_P_NODE_8788_length_241_cov_1.666667_g8625_i0	PRJEB12982	8788	241	1.666667	4.01666747	Streptococcus	1301	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2417856148\|gb\|CP114883.1\|	29389	g8625	i0	99.17	458.406639004149	241	2	100	0	1	241	19768	19528	Streptococcus alactolyticus strain LGM chromosome, complete genome	blastn	110476	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus alactolyticus
11189025	11189025	PRJEB12982_P_NODE_19969_length_163_cov_0.894737_g19806_i0	PRJEB12982	19969	163	0.894737	1.45842131	Staphylococcus	1279	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g19806	i0	100	80.9938650306748	163	0	100	0	1	163	774279	774441	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	13202	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
12774638	12774638	PRJEB12982_P_NODE_7331_length_268_cov_0.986301_g7168_i0	PRJEB12982	7331	268	0.986301	2.64328668	Gemella sanguinis	84135	Bacteria	Bacteria	481	2.64e-131	NTclustered	gi\|1780450472\|gb\|CP046313.1\|	84135	g7168	i0	99.248	310.070895522388	266	2	99	0	2	267	518920	519185	Gemella sanguinis strain FDAARGOS_742 chromosome, complete genome	blastn	83099	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella sanguinis
13739115	13739115	PRJEB12982_P_NODE_18591_length_165_cov_0.879310_g18428_i0	PRJEB12982	18591	165	0.87931	1.4508615	Lactobacillaceae	33958	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1433432408\|gb\|MH665770.1\|	1612	g18428	i0	100	114.70303030303	165	0	100	0	1	165	167	3	Companilactobacillus farciminis strain HBUAS51151 16S ribosomal RNA gene, partial sequence	blastn	18926	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus farciminis
13739142	13739142	PRJEB12982_P_NODE_9171_length_235_cov_1.096774_g9008_i0	PRJEB12982	9171	235	1.096774	2.5774189	Lactococcus	1357	Bacteria	Bacteria	418	1.8e-112	NTclustered	gi\|2451278082\|gb\|CP118627.1\|	1363	g9008	i0	98.723	509	235	3	100	0	1	235	1509907	1509673	Lactococcus garvieae strain Pa-2 chromosome, complete genome	blastn	119615	418	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus garvieae
15323132	15323132	PRJEB12982_P_NODE_19013_length_164_cov_0.886957_g18850_i0	PRJEB12982	19013	164	0.886957	1.45460948	Mordavella massiliensis	1871024	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|2729058686\|emb\|OZ006986.1\|	1871024	g18850	i0	98.78	466.140243902439	164	2	100	0	1	164	42959	42796	MAG: Mordavella massiliensis isolate 6737_HOM_CTRL_s20.ctg000294l_hifiasm_large MAG genome assembly, chromosome: 1	blastn	76447	292	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Mordavella	Mordavella massiliensis
17563526	17563526	PRJEB12982_P_NODE_14154_length_185_cov_1.125000_g13991_i0	PRJEB12982	14154	185	1.125	2.08125	Turicibacter	191303	Bacteria	Bacteria	226	8.789999999999998e-55	NTclustered	gi\|1840485543\|gb\|CP053187.1\|	154288	g13991	i0	91.463	590.967567567568	164	14	89	0	1	164	681634	681471	Turicibacter sanguinis strain MOL361 chromosome, complete genome	blastn	109329	226	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Turicibacteraceae	Turicibacter	Turicibacter sanguinis
17563537	17563537	PRJEB12982_P_NODE_19354_length_163_cov_3.578947_g19191_i0	PRJEB12982	19354	163	3.578947	5.83368361	Streptococcus	1301	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g19191	i0	100	578.006134969325	163	0	100	0	1	163	18759	18921	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	94215	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
19146349	19146349	PRJEB12982_P_NODE_11156_length_211_cov_1.092593_g10993_i0	PRJEB12982	11156	211	1.092593	2.30537123	Mordavella massiliensis	1871024	Bacteria	Bacteria	385	1.61e-102	NTclustered	gi\|2729058686\|emb\|OZ006986.1\|	1871024	g10993	i0	99.526	454.990521327014	211	1	100	0	1	211	167723	167933	MAG: Mordavella massiliensis isolate 6737_HOM_CTRL_s20.ctg000294l_hifiasm_large MAG genome assembly, chromosome: 1	blastn	96003	385	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Mordavella	Mordavella massiliensis
19146485	19146485	PRJEB12982_P_NODE_20316_length_162_cov_0.902655_g20153_i0	PRJEB12982	20316	162	0.902655	1.4623011	uncultured Massilimicrobiota sp.	1924113	Bacteria	Bacteria	119	1.31e-22	NTclustered	gi\|1899225271\|gb\|MT967743.1\|	1924113	g20153	i0	80.488	3.09876543209877	164	25	100	7	1	162	1934	1776	Uncultured Massilimicrobiota sp. clone asv_242_2205 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	502	119	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Massilimicrobiota	uncultured Massilimicrobiota sp.
20112255	20112255	PRJEB12982_P_NODE_16436_length_169_cov_1.275000_g16273_i0	PRJEB12982	16436	169	1.275	2.15475	Bacilli	91061	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|1114444147\|gb\|KX057511.1\|	1428	g16273	i0	99.408	106	169	1	100	0	1	169	533	365	Bacillus thuringiensis strain a33 16S ribosomal RNA gene, partial sequence	blastn	17914	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
22662626	22662626	PRJEB12982_P_NODE_18738_length_164_cov_1.452174_g18575_i0	PRJEB12982	18738	164	1.452174	2.38156536	Bacillota	1239	Bacteria	Bacteria	215	1.65e-51	NTclustered	gi\|470489958\|ref\|NR_076959.1\|	36854	g18575	i0	90.854	382.829268292683	164	10	98	4	5	164	2346	2508	Desulfitobacterium dehalogenans strain JW/IU-DC1 23S ribosomal RNA gene, complete sequence	blastn	62784	215	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Desulfitobacterium	Desulfitobacterium dehalogenans
22972938	22972938	PRJEB12982_P_NODE_19399_length_163_cov_1.385965_g19236_i0	PRJEB12982	19399	163	1.385965	2.25912295	Dolosigranulum pigrum	29394	Bacteria	Bacteria	235	1.26e-57	NTclustered	gi\|2020692764\|gb\|CP040408.1\|	29394	g19236	i0	93.21	387.521472392638	162	8	99	3	3	163	1384798	1384957	Dolosigranulum pigrum strain KPL3911 chromosome, complete genome	blastn	63166	235	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
24246862	24246862	PRJEB12982_P_NODE_7180_length_271_cov_1.103604_g7017_i0	PRJEB12982	7180	271	1.103604	2.99076684	Terrilactibacillus sp. S3-3	2969846	Bacteria	Bacteria	399	7.699999999999999e-107	NTclustered	gi\|2533273496\|gb\|CP129291.1\|	2969846	g7017	i0	94.595	799.077490774908	259	13	96	1	1	259	48424	48681	Terrilactibacillus sp. S3-3 chromosome, complete genome	blastn	216550	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Terrilactibacillus	Terrilactibacillus sp. S3-3
27570109	27570109	PRJEB12982_P_NODE_19584_length_163_cov_0.894737_g19421_i0	PRJEB12982	19584	163	0.894737	1.45842131	Sporosarcina sp. FSL K6-3457	2978204	Bacteria	Bacteria	53.5	1.84e-6	NR	WP_340738690.1	2978204	g19421	i0	50	1.71165644171779	50	24	92	1	14	163	124	172	WP_340738690.1 serine/threonine-protein kinase [Sporosarcina sp. FSL K6-3457]	diamond	279	53.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina sp. FSL K6-3457
28485843	28485843	PRJEB12982_P_NODE_3287_length_425_cov_1.627660_g3126_i0	PRJEB12982	3287	425	1.62766	6.917555	Anaeromicropila populeti	37658	Bacteria	Bacteria	61.6	4.64e-9	NR	WP_092562468.1	37658	g3126	i0	57.1	1.76470588235294	56	23	38.8	1	202	38	3	58	WP_092562468.1 DnaJ domain-containing protein [Anaeromicropila populeti]	diamond	750	61.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaeromicropila	Anaeromicropila populeti
28927838	28927838	PRJEB12982_P_NODE_11268_length_210_cov_1.099379_g11105_i0	PRJEB12982	11268	210	1.099379	2.3086959	Clostridia bacterium	2044939	Bacteria	Bacteria	44.3	0.00675	NR	MBR1686885.1	2044939	g11105	i0	44.9	0.7	49	26	68.6	1	60	203	88	136	MBR1686885.1 MATE family efflux transporter [Clostridia bacterium]	diamond	147	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29022946	29022946	PRJEB12982_P_NODE_18728_length_164_cov_1.695652_g18565_i0	PRJEB12982	18728	164	1.695652	2.78086928	uncultured Anaerococcus sp.	293428	Bacteria	Bacteria	93.2	4.91e-23	NR	WP_297790668.1	293428	g18565	i0	98	0.914634146341463	50	1	91.5	0	152	3	1	50	WP_297790668.1 hypothetical protein [uncultured Anaerococcus sp.]	diamond	150	93.2	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	uncultured Anaerococcus sp.
29559210	29559210	PRJEB12982_P_NODE_10610_length_217_cov_0.910714_g10447_i0	PRJEB12982	10610	217	0.910714	1.97624938	Bacillota bacterium	1879010	Bacteria	Bacteria	63.5	8.2e-10	NR	MBR4149758.1	1879010	g10447	i0	56.1	0.788018433179724	57	25	78.8	0	1	171	207	263	MBR4149758.1 SMP-30/gluconolactonase/LRE family protein [Bacillota bacterium]	diamond	171	63.5	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
29837058	29837058	PRJEB12982_P_NODE_10211_length_221_cov_1.186047_g10048_i0	PRJEB12982	10211	221	1.186047	2.62116387	Lactobacillus	1578	Bacteria	Bacteria	90.9	3.07e-19	NR	WP_003652924.1	1596	g10048	i0	59.7	10.6289592760181	67	27	91	0	221	21	71	137	WP_003652924.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Lactobacillus gasseri]	diamond	2349	91.3	0.995618838992333	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus gasseri

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