metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1072736" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1072736" and tax_kingdom = "Bacillati"

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
186974	186974	PRJNA1072736_S_NODE_7761_length_150_cov_0.878505_g7756_i0	PRJNA1072736	7761	150	0.878505	1.3177575	Mycoplasma wenyonii	65123	Bacteria	Bacteria	189	8.92e-44	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7756	i0	89.333	1	150	16	100	0	1	150	423319	423170	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	150	189	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
1461535	1461535	PRJNA1072736_S_NODE_2202_length_235_cov_1.317708_g2197_i0	PRJNA1072736	2202	235	1.317708	3.0966138	Mycoplasma wenyonii	65123	Bacteria	Bacteria	292	1.14e-74	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2197	i0	89.655	0.987234042553191	232	21	97	3	1	229	141303	141534	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	232	292	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2737516	2737516	PRJNA1072736_S_NODE_1443_length_270_cov_2.140969_g1438_i0	PRJNA1072736	1443	270	2.140969	5.7806163	Mycoplasma wenyonii	65123	Bacteria	Bacteria	494	3.4199999999999996e-135	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1438	i0	99.63	34.262962962963	270	1	100	0	1	270	605006	604737	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	9251	494	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2737519	2737519	PRJNA1072736_S_NODE_4063_length_189_cov_1.883562_g4058_i0	PRJNA1072736	4063	189	1.883562	3.55993218	Mycoplasma wenyonii	65123	Bacteria	Bacteria	333	5.169999999999999e-87	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4058	i0	98.413	1	189	3	100	0	1	189	577516	577328	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	189	333	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4013404	4013404	PRJNA1072736_S_NODE_1024_length_303_cov_2.192308_g1019_i0	PRJNA1072736	1024	303	2.192308	6.64269324	Mycoplasma wenyonii	65123	Bacteria	Bacteria	527	3.8499999999999985e-145	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1019	i0	98.333	2.03630363036304	300	5	99	0	4	303	549161	548862	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	617	527	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4013409	4013409	PRJNA1072736_S_NODE_964_length_309_cov_1.334586_g959_i0	PRJNA1072736	964	309	1.334586	4.12387074	Mycoplasma wenyonii	65123	Bacteria	Bacteria	547	3.0199999999999986e-151	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g959	i0	98.701	0.996763754045307	308	4	99	0	1	308	86481	86174	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	308	547	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5289738	5289738	PRJNA1072736_S_NODE_1585_length_262_cov_2.429224_g1580_i0	PRJNA1072736	1585	262	2.429224	6.36456688	Mycoplasma wenyonii	65123	Bacteria	Bacteria	429	9.449999999999999e-116	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1580	i0	96.212	1.00763358778626	264	6	100	3	1	262	441576	441315	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	264	429	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5289739	5289739	PRJNA1072736_S_NODE_2465_length_226_cov_1.284153_g2460_i0	PRJNA1072736	2465	226	1.284153	2.90218578	Mycoplasma wenyonii	65123	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2460	i0	100	2.88053097345133	226	0	100	0	1	226	381015	380790	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	651	418	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
6118965	6118965	PRJNA1072736_S_NODE_4705_length_179_cov_2.477941_g4700_i0	PRJNA1072736	4705	179	2.477941	4.43551439	Clostridium	1485	Bacteria	Bacteria	324	2.91e-84	NTclustered	gi\|1321427195\|gb\|CP013847.1\|	1491	g4700	i0	100	772.329608938547	175	0	98	0	5	179	11883	12057	Clostridium botulinum strain Af650, complete sequence.	blastn	138247	326	0.993865030674847	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
6118966	6118966	PRJNA1072736_S_NODE_545_length_371_cov_1.746951_g540_i0	PRJNA1072736	545	371	1.746951	6.48118821	Corynebacterium	1716	Bacteria	Bacteria	669	0	NTclustered	gi\|2879441308\|gb\|CP176023.1\|	3050208	g540	i0	99.191	371.525606469003	371	3	100	0	1	371	1213904	1213534	Corynebacterium sp. MSK130 chromosome, complete genome	blastn	137836	669	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. MSK130
6564929	6564929	PRJNA1072736_S_NODE_3566_length_197_cov_2.857143_g3561_i0	PRJNA1072736	3566	197	2.857143	5.62857171	Cutibacterium granulosum	33011	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|1231673337\|emb\|LT906441.1\|	33011	g3561	i0	100	237.197969543147	197	0	100	0	1	197	1036083	1036279	Cutibacterium granulosum strain NCTC11865 genome assembly, chromosome: 1	blastn	46728	364	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
8669014	8669014	PRJNA1072736_S_NODE_6347_length_161_cov_1.194915_g6342_i0	PRJNA1072736	6347	161	1.194915	1.92381315	Bacillales	1385	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g6342	i0	100	547.341614906832	161	0	100	0	1	161	1244553	1244713	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	88122	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
14215640	14215640	PRJNA1072736_S_NODE_2712_length_218_cov_6.120000_g2707_i0	PRJNA1072736	2712	218	6.12	13.3416	Caloranaerobacter azorensis	116090	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1810187734\|gb\|CP048617.1\|	116090	g2707	i0	100	0.13302752293578	29	0	13	0	133	161	1707613	1707585	Caloranaerobacter azorensis strain T3-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Thermohalobacteraceae	Caloranaerobacter	Caloranaerobacter azorensis
15043474	15043474	PRJNA1072736_S_NODE_3092_length_208_cov_1.987879_g3087_i0	PRJNA1072736	3092	208	1.987879	4.13478832	Corynebacterium	1716	Bacteria	Bacteria	368	1.59e-97	NTclustered	gi\|2550471320\|gb\|CP100376.1\|	38284	g3087	i0	98.558	371	208	3	100	0	1	208	2342952	2342745	Corynebacterium accolens strain CA7 chromosome	blastn	77168	368	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
16763878	16763878	PRJNA1072736_S_NODE_3014_length_210_cov_1.970060_g3009_i0	PRJNA1072736	3014	210	1.97006	4.137126	Mycoplasma wenyonii	65123	Bacteria	Bacteria	355	1.25e-93	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3009	i0	97.143	1	210	6	100	0	1	210	304110	303901	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	210	355	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
18867402	18867402	PRJNA1072736_S_NODE_3575_length_197_cov_2.298701_g3570_i0	PRJNA1072736	3575	197	2.298701	4.52844097	Staphylococcus	1279	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g3570	i0	100	100	197	0	100	0	1	197	1064189	1063993	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	19700	364	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
19312639	19312639	PRJNA1072736_S_NODE_3596_length_197_cov_1.272727_g3591_i0	PRJNA1072736	3596	197	1.272727	2.50727219	Mycoplasma wenyonii	65123	Bacteria	Bacteria	320	4.24e-83	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3591	i0	95.96	1.00507614213198	198	7	100	1	1	197	144696	144499	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	198	320	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21863821	21863821	PRJNA1072736_S_NODE_4378_length_184_cov_1.375887_g4373_i0	PRJNA1072736	4378	184	1.375887	2.53163208	Mycoplasma wenyonii	65123	Bacteria	Bacteria	337	3.869999999999999e-88	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4373	i0	100	0.989130434782609	182	0	99	0	1	182	498163	498344	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	182	337	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21863824	21863824	PRJNA1072736_S_NODE_5058_length_175_cov_1.424242_g5053_i0	PRJNA1072736	5058	175	1.424242	2.4924235	Mycoplasma wenyonii	65123	Bacteria	Bacteria	287	3.71e-73	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5053	i0	96.552	0.994285714285714	174	4	99	2	3	175	413486	413314	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	174	287	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23139283	23139283	PRJNA1072736_S_NODE_2599_length_222_cov_1.402235_g2594_i0	PRJNA1072736	2599	222	1.402235	3.1129617	Mycoplasma ovis	171632	Bacteria	Bacteria	178	3.11e-40	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g2594	i0	81.25	1.00900900900901	224	38	100	4	1	222	436868	436647	Mycoplasma ovis str. Michigan, complete genome	blastn	224	178	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis

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