metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA493632" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA493632" 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
26664720	26664720	PRJNA493632_P_NODE_163481_length_373_cov_3.540000_g160056_i0	PRJNA493632	163481	373	3.54	13.2042	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	43.9	0.023	NR	MDI3349715.1	2094	g160056	i0	78.6	0.225201072386059	28	6	22.5	0	221	304	18	45	MDI3349715.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	84	43.9	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
27329656	27329656	PRJNA493632_P_NODE_548803_length_248_cov_1.571429_g545364_i0	PRJNA493632	548803	248	1.571429	3.89714392	Acholeplasmatales bacterium	2053494	Bacteria	Bacteria	43.1	0.0277	NR	MBR6289617.1	2053494	g545364	i0	30.4	1.91129032258065	79	48	91.9	2	241	14	4	78	MBR6289617.1 glycogen/starch/alpha-glucan phosphorylase [Acholeplasmatales bacterium]	diamond	474	43.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales			Acholeplasmatales bacterium
27487499	27487499	PRJNA493632_P_NODE_622943_length_243_cov_1.358824_g619502_i0	PRJNA493632	622943	243	1.358824	3.30194232	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	105	1.25e-24	NR	WP_304949755.1	2754999	g619502	i0	58.7	0.925925925925926	75	31	92.6	0	240	16	65	139	WP_304949755.1 DUF4283 domain-containing protein [Candidatus Phytoplasma australasiaticum]	diamond	225	105	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
27598130	27598130	PRJNA493632_P_NODE_475264_length_257_cov_1.255435_g471825_i0	PRJNA493632	475264	257	1.255435	3.22646795	root	1	Root_unresolved	Root_unresolved	65.9	3.14e-10	NR	MBP1527417.1	2141	g471825	i0	63.3	29.4280155642023	49	18	57.2	0	58	204	380	428	MBP1527417.1 hypothetical protein [Spiroplasma ixodetis]	diamond	7563	66.2	0.995468277945619	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma ixodetis
28024319	28024319	PRJNA493632_P_NODE_570345_length_247_cov_0.885057_g566906_i0	PRJNA493632	570345	247	0.885057	2.18609079	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	84.7	1.85e-18	NR	MDV3194034.1	101513	g566906	i0	48.1	0.935222672064777	77	40	93.5	0	14	244	11	87	MDV3194034.1 ribonuclease H family protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae]	diamond	231	84.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
28244883	28244883	PRJNA493632_P_NODE_154026_length_382_cov_3.032362_g150602_i0	PRJNA493632	154026	382	3.032362	11.58362284	Mycoplasma sp.	2108	Bacteria	Bacteria	110	2.5500000000000003e-27	NR	MBD5423235.1	2108	g150602	i0	48.2	0.879581151832461	112	54	87.2	2	32	364	102	210	MBD5423235.1 uracil-DNA glycosylase [Mycoplasma sp.]	diamond	336	110	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
29066248	29066248	PRJNA493632_P_NODE_426228_length_266_cov_8.632124_g422789_i0	PRJNA493632	426228	266	8.632124	22.96144984	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	177	3.169999999999999e-55	NR	MDI3349715.1	2094	g422789	i0	98.9	0.981203007518797	87	1	98.1	0	6	266	37	123	MDI3349715.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	261	177	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
29350403	29350403	PRJNA493632_P_NODE_640969_length_242_cov_0.911243_g637528_i0	PRJNA493632	640969	242	0.911243	2.20520806	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	148	1.11e-40	NR	NLD26101.1	1898209	g637528	i0	90	0.991735537190083	80	8	99.2	0	3	242	192	271	NLD26101.1 methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [Acholeplasmataceae bacterium]	diamond	240	148	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
29444831	29444831	PRJNA493632_P_NODE_565170_length_247_cov_0.885057_g561731_i0	PRJNA493632	565170	247	0.885057	2.18609079	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	45.1	0.00607	NR	MDV3163074.1	2754999	g561731	i0	45.2	0.753036437246964	62	29	70.4	3	201	28	630	690	MDV3163074.1 cation-translocating P-type ATPase [Candidatus Phytoplasma australasiaticum]	diamond	186	45.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
30629383	30629383	PRJNA493632_P_NODE_332393_length_287_cov_1.060748_g328954_i0	PRJNA493632	332393	287	1.060748	3.04434676	root	1	Root_unresolved	Root_unresolved	68.2	7.32e-11	NR	MBP1527199.1	2141	g328954	i0	53.7	1.14982578397213	54	25	56.4	0	281	120	867	920	MBP1527199.1 hypothetical protein [Spiroplasma ixodetis]	diamond	330	68.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma ixodetis
31372358	31372358	PRJNA493632_P_NODE_379596_length_276_cov_2.881773_g376157_i0	PRJNA493632	379596	276	2.881773	7.95369348	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	70.9	1.89e-12	NR	MFO7969757.1	3018265	g376157	i0	50.7	0.728260869565217	67	33	72.8	0	1	201	160	226	MFO7969757.1 hypothetical protein [Candidatus Izemoplasmatales bacterium]	diamond	201	70.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
31451418	31451418	PRJNA493632_P_NODE_284896_length_302_cov_2.104803_g281460_i0	PRJNA493632	284896	302	2.104803	6.35650506	root	1	Root_unresolved	Root_unresolved	44.3	0.018	NR	MDV3193995.1	101513	g281460	i0	41.1	2.9205298013245	73	23	58.6	2	57	233	130	196	MDV3193995.1 ribonuclease H family protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae]	diamond	882	44.7	0.991051454138702	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
31498922	31498922	PRJNA493632_P_NODE_623956_length_243_cov_0.905882_g620515_i0	PRJNA493632	623956	243	0.905882	2.20129326	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	146	3.82e-42	NR	MDV3183816.1	101513	g620515	i0	86.1	0.975308641975309	79	11	97.5	0	5	241	70	148	MDV3183816.1 reverse transcriptase domain-containing protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae]	diamond	237	146	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
32226529	32226529	PRJNA493632_P_NODE_599398_length_245_cov_0.895349_g595957_i0	PRJNA493632	599398	245	0.895349	2.19360505	Mesoplasma chauliocola	216427	Bacteria	Bacteria	43.1	0.00511	NR	WP_156923121.1	216427	g595957	i0	33.3	0.771428571428571	63	37	77.1	1	235	47	2	59	WP_156923121.1 hypothetical protein [Mesoplasma chauliocola]	diamond	189	43.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma chauliocola

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