metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA1233317" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA1233317" 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
335646	335646	PRJNA1233317_S_NODE_2661_length_371_cov_3.868590_g2625_i0	PRJNA1233317	2661	371	3.86859	14.3524689	Mycoplasma wenyonii	65123	Bacteria	Bacteria	224	7.059999999999998e-54	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2625	i0	77.838	0.997304582210243	370	76	99	5	1	369	161705	162069	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	370	224	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
335681	335681	PRJNA1233317_S_NODE_6281_length_297_cov_5.399160_g6245_i0	PRJNA1233317	6281	297	5.39916	16.0355052	Mycoplasma wenyonii	65123	Bacteria	Bacteria	324	5.3e-84	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g6245	i0	86.78	0.993265993265993	295	34	99	4	1	294	296861	297151	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	295	324	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4162718	4162718	PRJNA1233317_S_NODE_8144_length_270_cov_3.469194_g8108_i0	PRJNA1233317	8144	270	3.469194	9.3668238	Mycoplasma wenyonii	65123	Bacteria	Bacteria	444	3.49e-120	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g8108	i0	96.296	1	270	10	100	0	1	270	365566	365297	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	270	444	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
7989022	7989022	PRJNA1233317_S_NODE_11307_length_231_cov_2.872093_g11271_i0	PRJNA1233317	11307	231	2.872093	6.63453483	Mycoplasma wenyonii	65123	Bacteria	Bacteria	422	1.37e-113	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g11271	i0	99.567	1	231	1	100	0	1	231	6790	6560	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	231	422	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
7989036	7989036	PRJNA1233317_S_NODE_14067_length_205_cov_2.506849_g14031_i0	PRJNA1233317	14067	205	2.506849	5.13904045	Mycoplasma wenyonii	65123	Bacteria	Bacteria	315	2.0699999999999998e-81	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g14031	i0	95	1.62926829268293	200	10	98	0	4	203	562023	561824	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	334	315	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
7989075	7989075	PRJNA1233317_S_NODE_4127_length_335_cov_2.358696_g4091_i0	PRJNA1233317	4127	335	2.358696	7.9016316	Mycoplasma wenyonii	65123	Bacteria	Bacteria	592	1.5099999999999996e-164	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4091	i0	98.507	1	335	5	100	0	1	335	137713	137379	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	335	592	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10539522	10539522	PRJNA1233317_S_NODE_4569_length_327_cov_2.869403_g4533_i0	PRJNA1233317	4569	327	2.869403	9.38294781	Mycoplasma ovis	171632	Bacteria	Bacteria	139	2.29e-28	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g4533	i0	79.048	0.642201834862385	210	39	63	5	1	207	77443	77650	Mycoplasma ovis str. Michigan, complete genome	blastn	210	139	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
10539524	10539524	PRJNA1233317_S_NODE_4749_length_323_cov_5.424242_g4713_i0	PRJNA1233317	4749	323	5.424242	17.52030166	Mycoplasma wenyonii	65123	Bacteria	Bacteria	460	4.25e-125	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4713	i0	92.523	1.97523219814241	321	24	99	0	3	323	196070	196390	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	638	460	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11814227	11814227	PRJNA1233317_S_NODE_12870_length_216_cov_1.910828_g12834_i0	PRJNA1233317	12870	216	1.910828	4.12738848	Mycoplasma wenyonii	65123	Bacteria	Bacteria	344	2.81e-90	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g12834	i0	95.37	1	216	10	100	0	1	216	508542	508327	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	216	344	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11814310	11814310	PRJNA1233317_S_NODE_7950_length_273_cov_1.710280_g7914_i0	PRJNA1233317	7950	273	1.71028	4.6690644	Mycoplasma wenyonii	65123	Bacteria	Bacteria	481	2.699999999999999e-131	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7914	i0	98.529	0.996336996336996	272	4	99	0	2	273	391794	392065	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	272	481	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
14364581	14364581	PRJNA1233317_S_NODE_12752_length_217_cov_2.316456_g12716_i0	PRJNA1233317	12752	217	2.316456	5.02670952	Mycoplasma wenyonii	65123	Bacteria	Bacteria	274	3.76e-69	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g12716	i0	92.228	15.0691244239631	193	15	89	0	25	217	645139	644947	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	3270	274	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
14364630	14364630	PRJNA1233317_S_NODE_3832_length_341_cov_2.507092_g3796_i0	PRJNA1233317	3832	341	2.507092	8.54918372	Mycoplasma ovis	171632	Bacteria	Bacteria	346	1.32e-90	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g3796	i0	90.037	14.2609970674487	271	22	79	5	2	270	433538	433271	Mycoplasma ovis str. Michigan, complete genome	blastn	4863	346	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
15638558	15638558	PRJNA1233317_S_NODE_16553_length_187_cov_3.773438_g16517_i0	PRJNA1233317	16553	187	3.773438	7.05632906	Mycoplasma wenyonii	65123	Bacteria	Bacteria	215	1.93e-51	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g16517	i0	87.368	1.01604278074866	190	21	100	3	1	187	141318	141507	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	190	215	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
15638561	15638561	PRJNA1233317_S_NODE_17333_length_181_cov_2.500000_g17297_i0	PRJNA1233317	17333	181	2.5	4.525	Mycoplasma wenyonii	65123	Bacteria	Bacteria	318	1.37e-82	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g17297	i0	98.343	1	181	3	100	0	1	181	344309	344129	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	181	318	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
15638590	15638590	PRJNA1233317_S_NODE_3913_length_339_cov_4.046429_g3877_i0	PRJNA1233317	3913	339	4.046429	13.71739431	Mycoplasma wenyonii	65123	Bacteria	Bacteria	610	4.21e-170	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3877	i0	99.115	1	339	3	100	0	1	339	579462	579124	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	339	610	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16912723	16912723	PRJNA1233317_S_NODE_2574_length_374_cov_1.822222_g2538_i0	PRJNA1233317	2574	374	1.822222	6.81511028	Mycoplasma wenyonii	65123	Bacteria	Bacteria	340	6.78e-89	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2538	i0	93.103	1.36096256684492	232	16	97	0	1	232	27444	27213	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	509	340	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16912770	16912770	PRJNA1233317_S_NODE_8094_length_271_cov_1.537736_g8058_i0	PRJNA1233317	8094	271	1.537736	4.16726456	Mycoplasma wenyonii	65123	Bacteria	Bacteria	405	1.66e-108	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g8058	i0	96.341	1.32472324723247	246	9	91	0	26	271	420478	420233	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	359	405	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19461648	19461648	PRJNA1233317_S_NODE_3516_length_348_cov_4.266436_g3480_i0	PRJNA1233317	3516	348	4.266436	14.84719728	Mycoplasma wenyonii	65123	Bacteria	Bacteria	399	1.0199999999999998e-106	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3480	i0	87.356	1	348	44	100	0	1	348	1080	733	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	348	399	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19461706	19461706	PRJNA1233317_S_NODE_9496_length_252_cov_3.533679_g9460_i0	PRJNA1233317	9496	252	3.533679	8.90487108	Mycoplasma wenyonii	65123	Bacteria	Bacteria	364	2.58e-96	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g9460	i0	93.522	1.33333333333333	247	13	98	3	1	247	18798	18555	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	336	364	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23287869	23287869	PRJNA1233317_S_NODE_13699_length_208_cov_4.046980_g13663_i0	PRJNA1233317	13699	208	4.04698	8.4177184	Mycoplasma wenyonii	65123	Bacteria	Bacteria	196	7.95e-46	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g13663	i0	97.391	0.552884615384615	115	3	55	0	1	115	438545	438431	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	115	196	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23287894	23287894	PRJNA1233317_S_NODE_2399_length_378_cov_9.018809_g2363_i0	PRJNA1233317	2399	378	9.018809	34.09109802	Mycoplasma wenyonii	65123	Bacteria	Bacteria	429	1.42e-115	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2363	i0	90.303	0.873015873015873	330	28	87	4	1	327	583657	583329	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	330	429	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23287918	23287918	PRJNA1233317_S_NODE_4159_length_334_cov_5.090909_g4123_i0	PRJNA1233317	4159	334	5.090909	17.00363606	Mycoplasma wenyonii	65123	Bacteria	Bacteria	556	5.469999999999999e-154	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4123	i0	96.707	1	334	11	100	0	1	334	177149	176816	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	334	556	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24561795	24561795	PRJNA1233317_S_NODE_12500_length_219_cov_3.431250_g12464_i0	PRJNA1233317	12500	219	3.43125	7.5144375	Mycoplasma wenyonii	65123	Bacteria	Bacteria	364	2.19e-96	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g12464	i0	99.5	0.91324200913242	200	1	91	0	20	219	500305	500504	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	200	364	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24561825	24561825	PRJNA1233317_S_NODE_2460_length_377_cov_3.062893_g2424_i0	PRJNA1233317	2460	377	3.062893	11.54710661	Mycoplasma wenyonii	65123	Bacteria	Bacteria	387	8.67e-103	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2424	i0	85.146	1	377	56	100	0	1	377	501232	501608	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	377	387	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24561851	24561851	PRJNA1233317_S_NODE_5000_length_319_cov_1.973077_g4964_i0	PRJNA1233317	5000	319	1.973077	6.29411563	Mycoplasma wenyonii	65123	Bacteria	Bacteria	484	2.4899999999999996e-132	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4964	i0	94.044	1	319	19	100	0	1	319	635704	636022	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	319	484	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24561855	24561855	PRJNA1233317_S_NODE_5260_length_314_cov_3.286275_g5224_i0	PRJNA1233317	5260	314	3.286275	10.3189035	Mycoplasma wenyonii	65123	Bacteria	Bacteria	580	3.0299999999999992e-161	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5224	i0	100	1.19745222929936	314	0	100	0	1	314	121623	121936	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	376	580	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);;