metadata: contig_metadata: 10 rows where bioproject = "PRJNA1144090", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA1144090", 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
8686184	8686184	PRJNA1144090_P_NODE_82727_length_277_cov_1.401961_g82192_i0	PRJNA1144090	82727	277	1.401961	3.88343197	Mycoplasmopsis	2767358	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1563797793\|emb\|LR215010.1\|	29555	g82192	i0	100	0.314079422382672	29	0	10	0	35	63	583081	583053	Mycoplasma canis strain NCTC10146 genome assembly, chromosome: 1	blastn	87	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis canis
13786385	13786385	PRJNA1144090_P_NODE_66511_length_310_cov_2.852321_g65976_i0	PRJNA1144090	66511	310	2.852321	8.8421951	Mycoplasmopsis	2767358	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1563797793\|emb\|LR215010.1\|	29555	g65976	i0	100	0.270967741935484	28	0	9	0	13	40	583081	583054	Mycoplasma canis strain NCTC10146 genome assembly, chromosome: 1	blastn	84	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis canis
14316490	14316490	PRJNA1144090_P_NODE_64232_length_316_cov_2.168724_g63697_i0	PRJNA1144090	64232	316	2.168724	6.85316784	Hujiaoplasma nucleasis	2725268	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1880319116\|gb\|CP051151.1\|	2725268	g63697	i0	100	0.0886075949367089	28	0	9	0	167	194	123948	123921	Hujiaoplasma nucleasis strain zrk29 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Hujiaoplasmataceae	Hujiaoplasma	Hujiaoplasma nucleasis
24513061	24513061	PRJNA1144090_P_NODE_28400_length_496_cov_1.990544_g27866_i0	PRJNA1144090	28400	496	1.990544	9.87309824	Haploplasma axanthum	29552	Bacteria	Bacteria	52.8	0.048	NTclustered	gi\|1563809587\|emb\|LR215048.1\|	29552	g27866	i0	100	0.0564516129032258	28	0	6	0	457	484	39730	39703	Acholeplasma axanthum strain NCTC10138 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Haploplasma	Haploplasma axanthum
24513249	24513249	PRJNA1144090_P_NODE_46900_length_373_cov_2.353333_g46365_i0	PRJNA1144090	46900	373	2.353333	8.77793209	Candidatus Phytoplasma fraxini	35780	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2714275034\|gb\|CP146843.1\|	35780	g46365	i0	100	0.0750670241286863	28	0	8	0	25	52	510896	510923	Candidatus Phytoplasma fraxini isolate AshY1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma fraxini
24513311	24513311	PRJNA1144090_P_NODE_51840_length_354_cov_1.782918_g51305_i0	PRJNA1144090	51840	354	1.782918	6.31152972	Metamycoplasma phocicerebrale	142649	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1597691901\|gb\|CP033058.2\|	142649	g51305	i0	88.889	0.127118644067797	45	5	13	0	1	45	20935	20979	Metamycoplasma phocicerebrale strain 1049 chromosome, complete genome	blastn	45	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma phocicerebrale
26912225	26912225	PRJNA1144090_P_NODE_71682_length_298_cov_3.368889_g71147_i0	PRJNA1144090	71682	298	3.368889	10.03928922	Mycoplasmopsis canis	29555	Bacteria	Bacteria	73.9	3.68e-13	NR	WP_004794920.1	29555	g71147	i0	47.5	2.43624161073825	80	42	80.5	0	295	56	26	105	WP_004794920.1 translation elongation factor Ts [Mycoplasmopsis canis]	diamond	726	73.9	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis canis
27975407	27975407	PRJNA1144090_P_NODE_21705_length_580_cov_2.236686_g21180_i0	PRJNA1144090	21705	580	2.236686	12.9727788	Bacteria	2	Bacteria	Bacteria	53.1	1.5e-4	NR	WP_041784289.1	59748	g21180	i0	28.9	5.43620689655172	173	93	84.8	5	61	552	3	154	WP_041784289.1 RluA family pseudouridine synthase [Candidatus Phytoplasma australiense]	diamond	3153	53.5	0.992523364485981	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australiense
28775780	28775780	PRJNA1144090_P_NODE_73027_length_296_cov_1.300448_g72492_i0	PRJNA1144090	73027	296	1.300448	3.84932608	Haloplasmataceae bacterium	2862752	Bacteria	Bacteria	44.3	0.0193	NR	HEY8364506.1	2862752	g72492	i0	30.2	0.871621621621622	86	56	86.1	3	265	11	62	144	HEY8364506.1 tetratricopeptide repeat protein [Haloplasmataceae bacterium]	diamond	258	44.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Haloplasmatales	Haloplasmataceae		Haloplasmataceae bacterium
30133380	30133380	PRJNA1144090_P_NODE_89872_length_265_cov_1.250000_g89337_i0	PRJNA1144090	89872	265	1.25	3.3125	Candidatus Moeniiplasma glomeromycotorum	1822367	Bacteria	Bacteria	80.1	3.5e-15	NR	MCE8162849.1	1822367	g89337	i0	44.8	2.93207547169811	87	47	97.4	1	261	4	385	471	MCE8162849.1 protein kinase [Candidatus Moeniiplasma glomeromycotorum]	diamond	777	80.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Candidatus Moeniiplasma	Candidatus Moeniiplasma glomeromycotorum

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