metadata: contig_metadata: 30 rows where bioproject = "PRJNA737474" and tax

30 rows where bioproject = "PRJNA737474" 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
25576662	25576662	PRJNA737474f_S_NODE_115537_length_283_cov_0.857143_g114859_i0	PRJNA737474	115537	283	0.857143	2.42571469	Malacoplasma iowae	2116	Bacteria	Bacteria	60.2	1.56e-4	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g114859	i0	100	0.113074204946996	32	0	11	0	33	64	96960	96929	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	32	60.2	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
25581533	25581533	PRJNA737474f_S_NODE_83713_length_302_cov_539.781659_g83035_i0	PRJNA737474	83713	302	539.781659	1630.14061018	Malacoplasma iowae	2116	Bacteria	Bacteria	75	6e-9	NTclustered	gi\|2624195583\|gb\|CP129199.1\|	2116	g83035	i0	95.745	144.476821192053	47	1	15	1	36	81	161	115	Malacoplasma iowae strain M817 chromosome, complete genome	blastn	43632	75	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
25630542	25630542	PRJNA737474g_S_NODE_22809_length_620_cov_3.914077_g21573_i0	PRJNA737474	22809	620	3.914077	24.2672774	Spiroplasma	2132	Bacteria	Bacteria	56.5	0.005	NTclustered	gi\|835318765\|gb\|CP011855.1\|	2144	g21573	i0	96.97	0.159677419354839	33	1	5	0	469	501	1075932	1075900	Spiroplasma atrichopogonis strain GNAT3597, complete genome	blastn	99	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma mirum
25859441	25859441	PRJNA737474g_S_NODE_384331_length_245_cov_0.994186_g383037_i0	PRJNA737474	384331	245	0.994186	2.4357557	Malacoplasma iowae	2116	Bacteria	Bacteria	60.2	1.32e-4	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g383037	i0	97.143	0.142857142857143	35	1	14	0	61	95	96963	96929	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	35	60.2	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
25860097	25860097	PRJNA737474g_S_NODE_441163_length_241_cov_0.648810_g439869_i0	PRJNA737474	441163	241	0.64881	1.5636321	Malacoplasma iowae	2116	Bacteria	Bacteria	67.6	7.75e-7	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g439869	i0	100	0.14937759336099601	36	0	15	0	17	52	96964	96929	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	36	67.6	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
25985877	25985877	PRJNA737474f_S_NODE_157796_length_264_cov_1.026178_g157118_i0	PRJNA737474	157796	264	1.026178	2.70910992	Malacoplasma iowae	2116	Bacteria	Bacteria	65.8	3.1e-6	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g157118	i0	100	0.238636363636364	35	0	13	0	215	249	96929	96963	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	63	65.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
25987192	25987192	PRJNA737474f_S_NODE_243100_length_246_cov_0.849711_g242422_i0	PRJNA737474	243100	246	0.849711	2.09028906	Malacoplasma iowae	2116	Bacteria	Bacteria	65.8	2.85e-6	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g242422	i0	100	0.142276422764228	35	0	14	0	29	63	96963	96929	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	35	65.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
25993828	25993828	PRJNA737474g_S_NODE_265084_length_260_cov_3.245989_g263790_i0	PRJNA737474	265084	260	3.245989	8.4395714	Mycoplasmopsis synoviae	2109	Bacteria	Bacteria	170	4.91e-53	NR	WP_367896666.1	2109	g263790	i0	100	0.992307692307692	86	0	99.2	0	259	2	2	87	WP_367896666.1 aldehyde dehydrogenase family protein, partial [Mycoplasmopsis synoviae]	diamond	258	170	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis synoviae
25997235	25997235	PRJNA737474g_S_NODE_565796_length_213_cov_2.442857_g564502_i0	PRJNA737474	565796	213	2.442857	5.20328541	Malacoplasma iowae	2116	Bacteria	Bacteria	69.4	1.86e-7	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g564502	i0	100	0.173708920187793	37	0	17	0	152	188	96928	96964	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	37	69.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
25997462	25997462	PRJNA737474g_S_NODE_609068_length_199_cov_2.761905_g607774_i0	PRJNA737474	609068	199	2.761905	5.49619095	Malacoplasma iowae	2116	Bacteria	Bacteria	65.8	2.22e-6	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g607774	i0	100	0.175879396984925	35	0	18	0	151	185	96929	96963	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	35	65.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
26131590	26131590	PRJNA737474g_S_NODE_371189_length_246_cov_1.121387_g369895_i0	PRJNA737474	371189	246	1.121387	2.75861202	Malacoplasma iowae	2116	Bacteria	Bacteria	65.8	2.85e-6	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g369895	i0	100	1.29268292682927	35	0	14	0	26	60	96963	96929	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	318	65.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
26253871	26253871	PRJNA737474d_S_NODE_27438_length_291_cov_2.041284_g26844_i0	PRJNA737474	27438	291	2.041284	5.94013644	Mycoplasmopsis maculosa	114885	Bacteria	Bacteria	69.4	2.68e-7	NTclustered	gi\|1563804680\|emb\|LR215037.1\|	114885	g26844	i0	77.391	0.786941580756014	115	26	40	0	12	126	310452	310566	Mycoplasma maculosum strain NCTC10168 genome assembly, chromosome: 1	blastn	229	69.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis maculosa
26257384	26257384	PRJNA737474f_S_NODE_119526_length_280_cov_5051.685990_g118848_i0	PRJNA737474	119526	280	5051.68599	14144.720772	Malacoplasma iowae	2116	Bacteria	Bacteria	75	5.51e-9	NTclustered	gi\|2624195583\|gb\|CP129199.1\|	2116	g118848	i0	100	139.139285714286	40	0	14	0	203	242	120	159	Malacoplasma iowae strain M817 chromosome, complete genome	blastn	38959	75	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
26260578	26260578	PRJNA737474f_S_NODE_367990_length_209_cov_63.941176_g367312_i0	PRJNA737474	367990	209	63.941176	133.63705784	Malacoplasma iowae	2116	Bacteria	Bacteria	65.8	2.35e-6	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g367312	i0	100	3.02392344497608	35	0	17	0	16	50	96963	96929	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	632	65.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
26265344	26265344	PRJNA737474g_S_NODE_228126_length_269_cov_18.709184_g226832_i0	PRJNA737474	228126	269	18.709184	50.32770496	Malacoplasma iowae	2116	Bacteria	Bacteria	58.4	5.3e-4	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g226832	i0	100	0.115241635687732	31	0	12	0	1	31	96958	96928	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	31	58.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
26267788	26267788	PRJNA737474g_S_NODE_383534_length_245_cov_1.110465_g382240_i0	PRJNA737474	383534	245	1.110465	2.72063925	Malacoplasma iowae	2116	Bacteria	Bacteria	67.6	7.9e-7	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g382240	i0	100	2.97959183673469	36	0	15	0	16	51	96964	96929	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	730	67.6	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
26401954	26401954	PRJNA737474g_S_NODE_268439_length_260_cov_0.780749_g267145_i0	PRJNA737474	268439	260	0.780749	2.0299474	Malacoplasma iowae	2116	Bacteria	Bacteria	69.4	2.35e-7	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g267145	i0	95.455	0.276923076923077	44	1	17	1	199	242	96925	96967	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	72	69.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
26446160	26446160	PRJNA737474f_S_NODE_8959_length_683_cov_9.467213_g8346_i0	PRJNA737474	8959	683	9.467213	64.66106479	Spiroplasma	2132	Bacteria	Bacteria	56.5	0.005	NTclustered	gi\|835318765\|gb\|CP011855.1\|	2144	g8346	i0	96.97	0.144948755490483	33	1	5	0	175	207	1075900	1075932	Spiroplasma atrichopogonis strain GNAT3597, complete genome	blastn	99	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma mirum
26446775	26446775	PRJNA737474g_S_NODE_17559_length_743_cov_3.256716_g16394_i0	PRJNA737474	17559	743	3.256716	24.19739988	Acholeplasmataceae	2146	Bacteria	Bacteria	95.3	1.22e-14	NTclustered	gi\|383505802\|gb\|JQ390343.1\|	2150	g16394	i0	78.431	28.0915208613728	153	27	20	5	591	741	391	243	Acholeplasma modicum strain PG49 23S ribosomal RNA gene, partial sequence	blastn	20872	95.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Haploplasma	Haploplasma modicum
26520510	26520510	PRJNA737474b_S_NODE_15560_length_406_cov_4.357357_g14521_i0	PRJNA737474	15560	406	4.357357	17.69086942	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g14521	i0	100	0.0714285714285714	29	0	7	0	197	225	915961	915933	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
26537367	26537367	PRJNA737474g_S_NODE_227384_length_270_cov_0.598985_g226090_i0	PRJNA737474	227384	270	0.598985	1.6172595	Malacoplasma iowae	2116	Bacteria	Bacteria	65.8	3.18e-6	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g226090	i0	100	0.233333333333333	35	0	13	0	230	264	96929	96963	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	63	65.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
26539541	26539541	PRJNA737474g_S_NODE_363656_length_247_cov_0.885057_g362362_i0	PRJNA737474	363656	247	0.885057	2.18609079	Malacoplasma iowae	2116	Bacteria	Bacteria	62.1	3.71e-5	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g362362	i0	97.222	0.145748987854251	36	1	15	0	151	186	96929	96964	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	36	62.1	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
26541264	26541264	PRJNA737474g_S_NODE_530040_length_222_cov_41.986577_g528746_i0	PRJNA737474	530040	222	41.986577	93.210200939999993	Malacoplasma iowae	2116	Bacteria	Bacteria	67.6	7.03e-7	NTclustered	gi\|2624197841\|gb\|CP129198.1\|	2116	g528746	i0	100	0.292792792792793	36	0	16	0	162	197	96929	96964	Malacoplasma iowae strain M818 chromosome, complete genome	blastn	65	67.6	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
32937049	32937049	PRJNA737474f_S_NODE_66257_length_318_cov_3.253061_g65579_i0	PRJNA737474	66257	318	3.253061	10.34473398	Mycoplasmopsis synoviae	2109	Bacteria	Bacteria	119	1.45e-32	NR	WP_367896663.1	2109	g65579	i0	100	0.594339622641509	63	0	59.4	0	77	265	1	63	WP_367896663.1 hypothetical protein, partial [Mycoplasmopsis synoviae]	diamond	189	119	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis synoviae
32954253	32954253	PRJNA737474f_S_NODE_45410_length_349_cov_4.619565_g44732_i0	PRJNA737474	45410	349	4.619565	16.12228185	Spiroplasma endosymbiont of Danaus chrysippus	2691041	Bacteria	Bacteria	80.9	2.88e-17	NR	WP_174480293.1	2691041	g44732	i0	58.7	0.541547277936963	63	26	54.2	0	343	155	20	82	WP_174480293.1 HMG-box domain-containing protein [Spiroplasma endosymbiont of Danaus chrysippus]	diamond	189	80.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Danaus chrysippus
32988795	32988795	PRJNA737474g_S_NODE_188947_length_281_cov_1.822115_g187653_i0	PRJNA737474	188947	281	1.822115	5.12014315	Mycoplasmopsis synoviae	2109	Bacteria	Bacteria	166	3.23e-51	NR	WP_367896663.1	2109	g187653	i0	95.5	0.939501779359431	88	4	94	0	280	17	9	96	WP_367896663.1 hypothetical protein, partial [Mycoplasmopsis synoviae]	diamond	264	166	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis synoviae
33055539	33055539	PRJNA737474d_S_NODE_22701_length_320_cov_1.923077_g22107_i0	PRJNA737474	22701	320	1.923077	6.1538464	Mesoplasma photuris	217731	Bacteria	Bacteria	68.2	1.09e-10	NR	WP_031542743.1	217731	g22107	i0	43.9	0.76875	82	31	76.9	1	54	299	673	739	WP_031542743.1 ATP-dependent DNA helicase [Mesoplasma photuris]	diamond	246	68.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma photuris
33057473	33057473	PRJNA737474g_S_NODE_46333_length_424_cov_1.752137_g45041_i0	PRJNA737474	46333	424	1.752137	7.42906088	Mycoplasmopsis synoviae	2109	Bacteria	Bacteria	161	2.82e-48	NR	WP_367896650.1	2109	g45041	i0	100	1.71933962264151	81	0	57.3	0	2	244	12	92	WP_367896650.1 alcohol dehydrogenase catalytic domain-containing protein, partial [Mycoplasmopsis synoviae]	diamond	729	161	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis synoviae
33142180	33142180	PRJNA737474g_S_NODE_177775_length_285_cov_2.561321_g176481_i0	PRJNA737474	177775	285	2.561321	7.29976485	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	69.3	2.08e-12	NR	RKX67325.1	2231116	g176481	i0	38.1	0.884210526315789	84	52	88.4	0	280	29	43	126	RKX67325.1 MAG: hypothetical protein DRP42_00575 [Mycoplasmatota bacterium]	diamond	252	69.3	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
33175655	33175655	PRJNA737474f_S_NODE_163952_length_262_cov_0.804233_g163274_i0	PRJNA737474	163952	262	0.804233	2.10709046	Spiroplasma	2132	Bacteria	Bacteria	54.3	3.94e-6	NR	WP_040093872.1	2132	g163274	i0	45.9	4.21374045801527	61	28	68.7	2	261	82	413	469	WP_040093872.1 MULTISPECIES: glycerol kinase GlpK [Spiroplasma]	diamond	1104	54.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma

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