metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA753151" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA753151" and tax_phylum = "Mycoplasmatota"

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
729468	729468	PRJNA753151_S_NODE_140721_length_244_cov_3.532338_g138431_i0	PRJNA753151	140721	244	3.532338	8.61890472	Mycoplasma wenyonii	65123	Bacteria	Bacteria	335	1.9499999999999992e-87	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g138431	i0	91.393	31.1065573770492	244	21	100	0	1	244	644917	645160	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	7590	335	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2005601	2005601	PRJNA753151_S_NODE_149582_length_237_cov_3.711340_g147292_i0	PRJNA753151	149582	237	3.71134	8.7958758	Candidatus Mycoplasma haematolamae	141391	Bacteria	Bacteria	172	1.5599999999999999e-38	NTclustered	gi\|397328574\|gb\|CP003731.1\|	1212765	g147292	i0	81.279	0.924050632911392	219	36	91	5	18	233	449206	448990	Candidatus Mycoplasma haemolamae str. Purdue, complete genome	blastn	219	172	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematolamae
4558324	4558324	PRJNA753151_S_NODE_213864_length_197_cov_1.168831_g211574_i0	PRJNA753151	213864	197	1.168831	2.30259707	Mycoplasma wenyonii	65123	Bacteria	Bacteria	292	9.23e-75	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g211574	i0	93.401	1	197	13	100	0	1	197	23923	24119	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	197	292	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9658799	9658799	PRJNA753151_S_NODE_271788_length_170_cov_2.125984_g269498_i0	PRJNA753151	271788	170	2.125984	3.6141728	Mycoplasma wenyonii	65123	Bacteria	Bacteria	270	3.61e-68	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g269498	i0	95.294	3.26470588235294	170	8	100	0	1	170	343673	343504	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	555	270	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10933815	10933815	PRJNA753151_S_NODE_195269_length_207_cov_1.920732_g192979_i0	PRJNA753151	195269	207	1.920732	3.97591524	Mycoplasma wenyonii	65123	Bacteria	Bacteria	333	5.779999999999999e-87	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g192979	i0	95.652	1	207	9	100	0	1	207	140494	140700	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	207	333	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10934741	10934741	PRJNA753151_S_NODE_51589_length_359_cov_2.990506_g49304_i0	PRJNA753151	51589	359	2.990506	10.73591654	Mycoplasma wenyonii	65123	Bacteria	Bacteria	220	8.81e-53	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g49304	i0	82.239	0.721448467966574	259	42	72	3	103	359	342157	341901	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	259	220	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
12209062	12209062	PRJNA753151_S_NODE_158330_length_231_cov_1.675532_g156040_i0	PRJNA753151	158330	231	1.675532	3.87047892	Mycoplasma wenyonii	65123	Bacteria	Bacteria	324	3.96e-84	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g156040	i0	92.275	1.00865800865801	233	11	100	6	1	231	273007	273234	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	233	324	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
14758739	14758739	PRJNA753151_S_NODE_198232_length_205_cov_2.777778_g195942_i0	PRJNA753151	198232	205	2.777778	5.6944449	Mycoplasma wenyonii	65123	Bacteria	Bacteria	230	7.71e-56	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g195942	i0	87.129	0.985365853658537	202	26	99	0	3	204	347904	347703	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	202	230	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
14759013	14759013	PRJNA753151_S_NODE_243632_length_182_cov_1.618705_g241342_i0	PRJNA753151	243632	182	1.618705	2.9460431	Mycoplasma wenyonii	65123	Bacteria	Bacteria	303	3.87e-78	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g241342	i0	96.703	1	182	6	100	0	1	182	358960	358779	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	182	303	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
14759529	14759529	PRJNA753151_S_NODE_330212_length_150_cov_1.682243_g327922_i0	PRJNA753151	330212	150	1.682243	2.5233645	Mycoplasma wenyonii	65123	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g327922	i0	100	1	150	0	100	0	1	150	446161	446012	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	150	278	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
17307940	17307940	PRJNA753151_S_NODE_202374_length_203_cov_1.687500_g200084_i0	PRJNA753151	202374	203	1.6875	3.425625	Mycoplasma wenyonii	65123	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g200084	i0	100	1	203	0	100	0	1	203	372798	372596	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	203	375	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21132252	21132252	PRJNA753151_S_NODE_168417_length_224_cov_1.740331_g166127_i0	PRJNA753151	168417	224	1.740331	3.89834144	Mycoplasma wenyonii	65123	Bacteria	Bacteria	403	4.7699999999999995e-108	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g166127	i0	99.111	1.62053571428571	225	1	100	1	1	224	319586	319362	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	363	403	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21132631	21132631	PRJNA753151_S_NODE_236797_length_185_cov_2.070423_g234507_i0	PRJNA753151	236797	185	2.070423	3.83028255	Mycoplasma wenyonii	65123	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g234507	i0	100	1	185	0	100	0	1	185	644152	644336	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	185	342	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21133191	21133191	PRJNA753151_S_NODE_331537_length_150_cov_1.214953_g329247_i0	PRJNA753151	331537	150	1.214953	1.8224295	Mycoplasma wenyonii	65123	Bacteria	Bacteria	268	1.11e-67	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g329247	i0	99.324	0.986666666666667	148	1	99	0	1	148	646661	646514	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	148	268	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23683143	23683143	PRJNA753151_S_NODE_257979_length_176_cov_1.338346_g255689_i0	PRJNA753151	257979	176	1.338346	2.35548896	Mycoplasma wenyonii	65123	Bacteria	Bacteria	309	7.98e-80	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g255689	i0	98.295	1	176	3	100	0	1	176	537350	537175	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	176	309	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24956895	24956895	PRJNA753151_S_NODE_287360_length_164_cov_2.603306_g285070_i0	PRJNA753151	287360	164	2.603306	4.26942184	Mycoplasma wenyonii	65123	Bacteria	Bacteria	209	7.68e-50	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g285070	i0	90.566	0.969512195121951	159	14	96	1	6	163	145822	145664	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	159	209	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii

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