metadata: contig_metadata: 17 rows where bioproject = "PRJNA550047", tax_phylum = "Mycoplasmatota" and tax

17 rows where bioproject = "PRJNA550047", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

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
1788822	1788822	PRJNA550047_P_NODE_176882_length_345_cov_2.849265_g174922_i0	PRJNA550047	176882	345	2.849265	9.82996425	Mycoplasmopsis felifaucium	35768	Bacteria	Bacteria	86.3	2.38e-17	NR	WP_027334686.1	35768	g174922	i0	81.6	8.09565217391304	49	9	42.6	0	148	2	55	103	WP_027334686.1 recombinase RecA [Mycoplasmopsis felifaucium]	diamond	2793	86.3	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis felifaucium
8165681	8165681	PRJNA550047_P_NODE_140167_length_345_cov_5.356618_g138207_i0	PRJNA550047	140167	345	5.356618	18.4803321	Mesomycoplasma moatsii	171287	Bacteria	Bacteria	279	1.38e-70	NTclustered	gi\|2860287645\|gb\|CP174166.1\|	171287	g138207	i0	100	2.76231884057971	151	0	88	0	195	345	179043	178893	Mesomycoplasma moatsii strain MK 405 chromosome, complete genome	blastn	953	279	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma moatsii
8774462	8774462	PRJNA550047_P_NODE_432747_length_253_cov_0.866667_g430775_i0	PRJNA550047	432747	253	0.866667	2.19266751	Ureaplasma	2129	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g430775	i0	99.605	16	253	1	100	0	1	253	85263	85515	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	4048	462	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
14545787	14545787	PRJNA550047_P_NODE_469712_length_240_cov_20.329341_g467739_i0	PRJNA550047	469712	240	20.329341	48.7904184	Haploplasma	2903106	Bacteria	Bacteria	101	1.1699999999999997e-23	NR	HHW79407.1	1898209	g467739	i0	70.5	2.925	78	22	97.5	1	237	4	189	265	HHW79407.1 tryptophan--tRNA ligase [Acholeplasmataceae bacterium]	diamond	702	101	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
18973155	18973155	PRJNA550047_P_NODE_471195_length_240_cov_7.916168_g469222_i0	PRJNA550047	471195	240	7.916168	18.9988032	Ureaplasma	2129	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g469222	i0	100	11	240	0	100	0	1	240	123825	123586	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	2640	444	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
19642266	19642266	PRJNA550047_P_NODE_401876_length_264_cov_8.602094_g399904_i0	PRJNA550047	401876	264	8.602094	22.70952816	Spiroplasma endosymbiont of 'Nebria riversi'	2792084	Bacteria	Bacteria	153	5.62e-41	NR	WP_215826118.1	2792084	g399904	i0	87.5	1	88	11	100	0	1	264	73	160	WP_215826118.1 excinuclease ABC subunit UvrA [Spiroplasma endosymbiont of 'Nebria riversi']	diamond	264	153	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of 'Nebria riversi'
22193542	22193542	PRJNA550047_P_NODE_462878_length_243_cov_3.405882_g460905_i0	PRJNA550047	462878	243	3.405882	8.27629326	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	162	3.26e-44	NR	NLH45207.1	1898209	g460905	i0	98.8	0.987654320987654	80	1	98.8	0	2	241	299	378	NLH45207.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Acholeplasmataceae bacterium]	diamond	240	162	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
22798656	22798656	PRJNA550047_P_NODE_412218_length_260_cov_9.262032_g410246_i0	PRJNA550047	412218	260	9.262032	24.0812832	Ureaplasma	2129	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|620596742\|dbj\|AP014584.1\|	38504	g410246	i0	100	16	260	0	100	0	1	260	114057	113798	Ureaplasma parvum serovar 3 DNA, complete genome, strain: SV3F4	blastn	4160	481	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
26729428	26729428	PRJNA550047_P_NODE_265321_length_300_cov_2.581498_g263352_i0	PRJNA550047	265321	300	2.581498	7.744494	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	51.2	4.36e-5	NR	MDR0985621.1	2685873	g263352	i0	31.7	2.37	82	53	82	1	300	55	122	200	MDR0985621.1 hypothetical protein [Mycoplasmataceae bacterium]	diamond	711	51.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
26776501	26776501	PRJNA550047_P_NODE_488941_length_234_cov_7.316770_g486968_i0	PRJNA550047	488941	234	7.31677	17.1212418	Bacteria	2	Bacteria	Bacteria	82	8.28e-17	NR	WP_023789067.1	2137	g486968	i0	50.6	2.93589743589744	77	38	98.7	0	233	3	24	100	WP_023789067.1 pseudouridine synthase [Spiroplasma apis]	diamond	687	82.8	0.990338164251208	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma apis
27962448	27962448	PRJNA550047_P_NODE_308485_length_296_cov_7.542601_g306516_i0	PRJNA550047	308485	296	7.542601	22.32609896	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	80.9	2.77e-15	NR	MFA5037076.1	3018265	g306516	i0	36.7	0.993243243243243	98	61	99.3	1	294	1	451	547	MFA5037076.1 hypothetical protein [Candidatus Izemoplasmatales bacterium]	diamond	294	80.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
28183173	28183173	PRJNA550047_P_NODE_180286_length_345_cov_2.544118_g178326_i0	PRJNA550047	180286	345	2.544118	8.7772071	Paracholeplasma morum	264637	Bacteria	Bacteria	85.5	1.04e-17	NR	WP_204433177.1	264637	g178326	i0	82	0.434782608695652	50	9	43.5	0	344	195	155	204	WP_204433177.1 deoxyribose-phosphate aldolase [Paracholeplasma morum]	diamond	150	85.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Paracholeplasma	Paracholeplasma morum
28751778	28751778	PRJNA550047_P_NODE_352227_length_284_cov_7.246445_g350256_i0	PRJNA550047	352227	284	7.246445	20.5799038	Spiroplasma endosymbiont of 'Nebria riversi'	2792084	Bacteria	Bacteria	95.5	1.78e-20	NR	WP_215826922.1	2792084	g350256	i0	56.5	0.971830985915493	92	36	94	2	6	272	266	356	WP_215826922.1 ABC transporter permease [Spiroplasma endosymbiont of 'Nebria riversi']	diamond	276	95.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of 'Nebria riversi'
28909455	28909455	PRJNA550047_P_NODE_460268_length_243_cov_23.582353_g458295_i0	PRJNA550047	460268	243	23.582353	57.30511779	Spiroplasma endosymbiont of 'Nebria riversi'	2792084	Bacteria	Bacteria	91.7	2.34e-19	NR	WP_215826118.1	2792084	g458295	i0	59.1	0.814814814814815	66	27	81.5	0	243	46	152	217	WP_215826118.1 excinuclease ABC subunit UvrA [Spiroplasma endosymbiont of 'Nebria riversi']	diamond	198	91.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of 'Nebria riversi'
30646607	30646607	PRJNA550047_P_NODE_522433_length_223_cov_5.893333_g520460_i0	PRJNA550047	522433	223	5.893333	13.14213259	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	75.1	1.16e-15	NR	MDV3184949.1	2754999	g520460	i0	77.3	0.591928251121076	44	10	59.2	0	134	3	12	55	MDV3184949.1 hypothetical protein [Candidatus Phytoplasma australasiaticum]	diamond	132	75.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
31831017	31831017	PRJNA550047_P_NODE_517857_length_224_cov_14.158940_g515884_i0	PRJNA550047	517857	224	14.15894	31.7160256	Spiroplasma	2132	Bacteria	Bacteria	93.2	1.23e-20	NR	WP_342224010.1	3066281	g515884	i0	67.6	1.82142857142857	68	22	91.1	0	11	214	101	168	WP_342224010.1 ABC transporter substrate-binding protein [Spiroplasma endosymbiont of Asaphidion curtum]	diamond	408	93.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Asaphidion curtum
32386094	32386094	PRJNA550047_P_NODE_527119_length_221_cov_10.851351_g525146_i0	PRJNA550047	527119	221	10.851351	23.98148571	Acholeplasmatales bacterium	2053494	Bacteria	Bacteria	71.6	1.83e-12	NR	MCR5706322.1	2053494	g525146	i0	50.7	6.43438914027149	71	35	96.4	0	2	214	73	143	MCR5706322.1 anaerobic ribonucleoside-triphosphate reductase [Acholeplasmatales bacterium]	diamond	1422	71.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales			Acholeplasmatales bacterium

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