metadata: contig_metadata: 19 rows where bioproject = "PRJNA900999", tax_kingdom = "Bacillati" and tax

19 rows where bioproject = "PRJNA900999", tax_kingdom = "Bacillati" 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
3428838	3428838	PRJNA900999_S_NODE_2703_length_247_cov_3.931193_g2647_i0	PRJNA900999	2703	247	3.931193	9.71004671	Mycoplasma wenyonii	65123	Bacteria	Bacteria	424	4.1099999999999996e-114	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2647	i0	97.571	1.98785425101215	247	6	100	0	1	247	397855	397609	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	491	424	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
3428857	3428857	PRJNA900999_S_NODE_4443_length_205_cov_2.352273_g4387_i0	PRJNA900999	4443	205	2.352273	4.82215965	Mycoplasma wenyonii	65123	Bacteria	Bacteria	337	4.41e-88	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4387	i0	97.938	0.946341463414634	194	4	95	0	12	205	157663	157856	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	194	337	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4706742	4706742	PRJNA900999_S_NODE_6004_length_183_cov_2.207792_g5948_i0	PRJNA900999	6004	183	2.207792	4.04025936	Mycoplasma wenyonii	65123	Bacteria	Bacteria	278	2.36e-70	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5948	i0	94.915	0.967213114754098	177	9	97	0	7	183	342301	342125	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	177	278	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5981399	5981399	PRJNA900999_S_NODE_5825_length_185_cov_3.198718_g5769_i0	PRJNA900999	5825	185	3.198718	5.9176283	Mycoplasma wenyonii	65123	Bacteria	Bacteria	289	1.11e-73	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5769	i0	97.076	2.25945945945946	171	5	94	0	15	185	620299	620469	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	418	289	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5981421	5981421	PRJNA900999_S_NODE_8345_length_160_cov_2.267176_g8289_i0	PRJNA900999	8345	160	2.267176	3.6274816	Mycoplasma wenyonii	65123	Bacteria	Bacteria	279	5.59e-71	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g8289	i0	98.125	1	160	3	100	0	1	160	30082	30241	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	160	279	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5981422	5981422	PRJNA900999_S_NODE_8485_length_159_cov_2.000000_g8429_i0	PRJNA900999	8485	159	2	3.18	Mycoplasma wenyonii	65123	Bacteria	Bacteria	250	4.3499999999999996e-62	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g8429	i0	94.969	2	159	8	100	0	1	159	209226	209068	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	318	250	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
7256202	7256202	PRJNA900999_S_NODE_4726_length_200_cov_3.479532_g4670_i0	PRJNA900999	4726	200	3.479532	6.959064	Mycoplasma wenyonii	65123	Bacteria	Bacteria	255	1.23e-63	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4670	i0	97.973	0.74	148	2	74	1	5	151	315205	315352	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	148	255	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11081682	11081682	PRJNA900999_S_NODE_3789_length_218_cov_4.248677_g3733_i0	PRJNA900999	3789	218	4.248677	9.26211586	Mycoplasma wenyonii	65123	Bacteria	Bacteria	379	7.779999999999999e-101	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3733	i0	98.157	0.995412844036697	217	4	99	0	1	217	214298	214082	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	217	379	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11081725	11081725	PRJNA900999_S_NODE_9309_length_153_cov_3.306452_g9253_i0	PRJNA900999	9309	153	3.306452	5.05887156	Mycoplasma wenyonii	65123	Bacteria	Bacteria	233	4.17e-57	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g9253	i0	94.118	1	153	9	100	0	1	153	537403	537251	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	153	233	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
12357003	12357003	PRJNA900999_S_NODE_1390_length_307_cov_4.856115_g1334_i0	PRJNA900999	1390	307	4.856115	14.90827305	Mycoplasma wenyonii	65123	Bacteria	Bacteria	551	2.319999999999999e-152	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1334	i0	99.023	1	307	3	100	0	1	307	516222	515916	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	307	551	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
13631790	13631790	PRJNA900999_S_NODE_1431_length_304_cov_4.360000_g1375_i0	PRJNA900999	1431	304	4.36	13.2544	Mycoplasma wenyonii	65123	Bacteria	Bacteria	409	1.46e-109	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1375	i0	92.883	2.82894736842105	281	20	98	0	4	284	626465	626745	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	860	409	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
14906070	14906070	PRJNA900999_S_NODE_6312_length_179_cov_3.626667_g6256_i0	PRJNA900999	6312	179	3.626667	6.49173393	Mycoplasma wenyonii	65123	Bacteria	Bacteria	189	1.1099999999999999e-43	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g6256	i0	87.879	0.921787709497207	165	15	91	5	18	179	346791	346953	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	165	189	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16180814	16180814	PRJNA900999_S_NODE_4073_length_212_cov_4.530055_g4017_i0	PRJNA900999	4073	212	4.530055	9.6037166	Mycoplasma wenyonii	65123	Bacteria	Bacteria	363	7.579999999999997e-96	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4017	i0	98.077	0.981132075471698	208	4	98	0	5	212	392115	391908	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	208	363	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
18729518	18729518	PRJNA900999_S_NODE_5335_length_191_cov_2.685185_g5279_i0	PRJNA900999	5335	191	2.685185	5.12870335	Mycoplasma wenyonii	65123	Bacteria	Bacteria	307	3.18e-79	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5279	i0	95.789	0.994764397905759	190	8	99	0	2	191	483005	482816	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	190	307	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20004741	20004741	PRJNA900999_S_NODE_8896_length_156_cov_2.047244_g8840_i0	PRJNA900999	8896	156	2.047244	3.19370064	Mycoplasma wenyonii	65123	Bacteria	Bacteria	200	4.3399999999999996e-47	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g8840	i0	89.809	1.00641025641026	157	14	100	2	1	156	520645	520490	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	157	200	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
22554972	22554972	PRJNA900999_S_NODE_9698_length_151_cov_2.598361_g9642_i0	PRJNA900999	9698	151	2.598361	3.92352511	Mycoplasma wenyonii	65123	Bacteria	Bacteria	274	2.42e-69	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g9642	i0	99.338	1	151	1	100	0	1	151	410639	410789	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	151	274	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23830246	23830246	PRJNA900999_S_NODE_7739_length_165_cov_1.764706_g7683_i0	PRJNA900999	7739	165	1.764706	2.9117649	Mycoplasma wenyonii	65123	Bacteria	Bacteria	195	2.17e-45	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7683	i0	88.272	0.981818181818182	162	19	98	0	2	163	26160	25999	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	162	195	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27340443	27340443	PRJNA900999_S_NODE_9843_length_150_cov_3.801653_g9787_i0	PRJNA900999	9843	150	3.801653	5.7024795	Mycoplasma wenyonii	65123	Bacteria	Bacteria	71.6	6.57e-13	NR	WP_112665563.1	65123	g9787	i0	69.4	0.98	49	15	98	0	148	2	163	211	WP_112665563.1 type I restriction-modification system subunit M [Mycoplasma wenyonii]	diamond	147	71.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
29834669	29834669	PRJNA900999_S_NODE_1391_length_307_cov_4.579137_g1335_i0	PRJNA900999	1391	307	4.579137	14.05795059	Mycoplasma wenyonii	65123	Bacteria	Bacteria	189	3.119999999999999e-55	NR	WP_112665603.1	65123	g1335	i0	99	0.938110749185668	96	1	93.8	0	306	19	104	199	WP_112665603.1 arginine--tRNA ligase [Mycoplasma wenyonii]	diamond	288	189	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);;