metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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
337981	337981	PRJNA1237347_P_NODE_179841_length_465_cov_1.836735_g173270_i0	PRJNA1237347	179841	465	1.836735	8.54081775	Candidatus Mycoplasma mahonii	3004105	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2554183568\|gb\|CP114583.1\|	3004105	g173270	i0	100	0.0623655913978495	29	0	6	0	349	377	637605	637633	Candidatus Mycoplasma mahonii isolate OP267 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma mahonii
5443521	5443521	PRJNA1237347_P_NODE_280025_length_348_cov_8.727273_g273452_i0	PRJNA1237347	280025	348	8.727273	30.37091004	Malacoplasma muris	2119	Bacteria	Bacteria	516	9.72e-142	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g273452	i0	93.391	144.965517241379	348	23	100	0	1	348	2052	1705	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	50448	516	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
6721988	6721988	PRJNA1237347_P_NODE_491106_length_249_cov_0.875000_g484533_i0	PRJNA1237347	491106	249	0.875	2.17875	Spiroplasma endosymbiont of Seladonia tumulorum	3066321	Bacteria	Bacteria	303	5.63e-78	NTclustered	gi\|2706543124\|emb\|OZ026545.1\|	3066321	g484533	i0	93.204	115.951807228916	206	14	84	0	25	230	218349	218554	Spiroplasma endosymbiont of Seladonia tumulorum isolate 54790 genome assembly, chromosome: 1	blastn	28872	303	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Seladonia tumulorum
14374268	14374268	PRJNA1237347_P_NODE_551452_length_241_cov_1.375000_g544879_i0	PRJNA1237347	551452	241	1.375	3.31375	Mycoplasmatota bacterium WC30	3075149	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2877983046\|gb\|CP134495.1\|	3075149	g544879	i0	100	0.12448132780083	30	0	12	0	141	170	1493418	1493389	Mycoplasmatota bacterium WC30 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium WC30
16916167	16916167	PRJNA1237347_P_NODE_22814_length_1648_cov_3.582222_g19976_i0	PRJNA1237347	22814	1648	3.582222	59.03501856	Mycoplasmopsis edwardii	53558	Bacteria	Bacteria	237	4.36e-57	NTclustered	gi\|2425261263\|gb\|CP114370.1\|	53558	g19976	i0	73.241	5.55885922330097	725	165	95	26	534	1245	351572	350864	Mycoplasmopsis edwardii strain felid995 chromosome, complete genome	blastn	9161	237	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis edwardii
20742865	20742865	PRJNA1237347_P_NODE_343517_length_307_cov_1.226496_g336944_i0	PRJNA1237347	343517	307	1.226496	3.76534272	uncultured Mycoplasma sp.	167967	Bacteria	Bacteria	556	4.98e-154	NTclustered	gi\|2859863227\|gb\|PQ631164.1\|	167967	g336944	i0	99.349	1083.82736156352	307	2	100	0	1	307	628	322	Uncultured Mycoplasma sp. clone 79 23S ribosomal RNA gene, partial sequence	blastn	332735	556	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	uncultured Mycoplasma sp.
21449568	21449568	PRJNA1237347_P_NODE_211937_length_417_cov_1.938953_g205365_i0	PRJNA1237347	211937	417	1.938953	8.08543401	Candidatus Phytoplasma	33926	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|2470326911\|gb\|CP120448.1\|	85620	g205365	i0	100	0.335731414868106	28	0	7	0	114	141	654724	654697	MAG: Candidatus Phytoplasma asteris isolate QS2022 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma asteris
22022698	22022698	PRJNA1237347_P_NODE_70358_length_853_cov_3.705128_g64550_i0	PRJNA1237347	70358	853	3.705128	31.60474184	Candidatus Mycoplasma mahonii	3004105	Bacteria	Bacteria	60.2	5.13e-4	NTclustered	gi\|2554183568\|gb\|CP114583.1\|	3004105	g64550	i0	100	0.143024618991794	32	0	4	0	699	730	637605	637636	Candidatus Mycoplasma mahonii isolate OP267 chromosome, complete genome	blastn	122	60.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma mahonii
23293845	23293845	PRJNA1237347_P_NODE_34559_length_1315_cov_17.995169_g30703_i0	PRJNA1237347	34559	1315	17.995169	236.63647235	Candidatus Phytoplasma solani	69896	Bacteria	Bacteria	54.7	0.037	NTclustered	gi\|2741905208\|gb\|CP155828.1\|	69896	g30703	i0	92.308	0.0593155893536122	39	1	3	2	465	501	152953	152991	Candidatus Phytoplasma solani strain GOE chromosome, complete genome	blastn	78	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma solani
23296987	23296987	PRJNA1237347_P_NODE_512019_length_246_cov_0.890173_g505446_i0	PRJNA1237347	512019	246	0.890173	2.18982558	Mycoplasmopsis edwardii	53558	Bacteria	Bacteria	147	9.909999999999998e-31	NTclustered	gi\|2425261263\|gb\|CP114370.1\|	53558	g505446	i0	78.543	2.34959349593496	247	36	99	14	8	246	350419	350656	Mycoplasmopsis edwardii strain felid995 chromosome, complete genome	blastn	578	147	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis edwardii

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