metadata: contig_metadata: 13 rows where bioproject = "PRJEB14175" and tax

13 rows where bioproject = "PRJEB14175" 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
25648174	25648174	PRJEB14175_P_NODE_90186_length_381_cov_2.656250_g87920_i0	PRJEB14175	90186	381	2.65625	10.1203125	Mycoplasmopsis bovis	28903	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1951506244\|gb\|CP058504.1\|	28903	g87920	i0	100	0.078740157480315	30	0	8	0	28	57	259167	259138	Mycoplasmopsis bovis strain Mb157 chromosome	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
25744665	25744665	PRJEB14175_P_NODE_174850_length_249_cov_54.425532_g172583_i0	PRJEB14175	174850	249	54.425532	135.51957468	Bacteria	2	Bacteria	Bacteria	193	1.27e-44	NTclustered	gi\|2606720429\|gb\|CP136989.1\|	3081162	g172583	i0	84.236	144.248995983936	203	26	82	6	9	208	308281	308480	Mollicutes bacterium LVI A0006 chromosome, complete genome	blastn	35918	193	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium LVI A0006
25775980	25775980	PRJEB14175_P_NODE_161123_length_264_cov_1.236453_g158856_i0	PRJEB14175	161123	264	1.236453	3.26423592	Mycoplasma haemofelis Ohio2	859194	Bacteria	Bacteria	62.1	4.01e-5	NTclustered	gi\|334192594\|gb\|CP002808.1\|	859194	g158856	i0	97.222	0.511363636363636	36	1	14	0	220	255	403842	403877	Mycoplasma haemofelis Ohio2, complete genome	blastn	135	62.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemofelis
25782328	25782328	PRJEB14175_P_NODE_54859_length_502_cov_14.210884_g52613_i0	PRJEB14175	54859	502	14.210884	71.33863768	Metamycoplasma canadense	29554	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|675242197\|dbj\|AP014631.1\|	29554	g52613	i0	96.774	0.117529880478088	31	1	6	0	14	44	445652	445622	Mycoplasma canadense DNA, complete genome, strain: HAZ360_1	blastn	59	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma canadense
25912993	25912993	PRJEB14175_P_NODE_180212_length_244_cov_13.284153_g177945_i0	PRJEB14175	180212	244	13.284153	32.41333332	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	350	6.969999999999998e-92	NTclustered	gi\|2040452726\|gb\|CP074573.1\|	2231116	g177945	i0	95.067	1108.61885245902	223	9	91	1	1	223	2238317	2238537	Tenericutes bacterium strain zrk4 chromosome, complete genome	blastn	270503	350	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
26017667	26017667	PRJEB14175_P_NODE_226076_length_209_cov_4.547297_g223808_i0	PRJEB14175	226076	209	4.547297	9.50385073	Bacillati	1783272	Bacteria	Bacteria	113	9.39e-28	NR	MCI5938610.1	1898209	g223808	i0	85.5	2.97129186602871	69	10	99	0	207	1	38	106	MCI5938610.1 phosphoglycerate kinase [Acholeplasmataceae bacterium]	diamond	621	114	0.991228070175439	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
26324309	26324309	PRJEB14175_P_NODE_261407_length_200_cov_6.302158_g259139_i0	PRJEB14175	261407	200	6.302158	12.604316	Ureaplasma cati	42093	Bacteria	Bacteria	300	5.62e-77	NTclustered	gi\|306410979\|gb\|HM197715.1\|	42093	g259139	i0	95.288	58.905	191	6	95	3	1	189	2506	2317	Ureaplasma cati strain ATCC 49228 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	11781	300	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma cati
26324364	26324364	PRJEB14175_P_NODE_262903_length_198_cov_9.795620_g260635_i0	PRJEB14175	262903	198	9.79562	19.3953276	Ureaplasma diversum	42094	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|764071633\|gb\|CP009770.1\|	42094	g260635	i0	100	0.141414141414141	28	0	14	0	91	118	689679	689706	Ureaplasma diversum strain ATCC 49782 genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma diversum
26424508	26424508	PRJEB14175_P_NODE_166903_length_257_cov_34.933673_g164636_i0	PRJEB14175	166903	257	34.933673	89.77953961	Acholeplasma	2147	Bacteria	Bacteria	67.6	8.35e-7	NTclustered	gi\|294768449\|gb\|GU905034.1\|	264634	g164636	i0	89.091	33.8132295719844	55	4	21	2	13	65	1787	1841	Acholeplasma equifetale strain ATCC 29724 23S ribosomal RNA gene, partial sequence; 23S-5S ribosomal RNA intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	8690	67.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma equifetale
26424886	26424886	PRJEB14175_P_NODE_184703_length_240_cov_30.067039_g182436_i0	PRJEB14175	184703	240	30.067039	72.1608936	Mycoplasmopsis	2767358	Bacteria	Bacteria	396	8.659999999999997e-106	NTclustered	gi\|2639791867\|gb\|CP141038.1\|	171284	g182436	i0	99.541	90.9	218	0	90	1	24	240	881383	881600	Mycoplasmopsis cynos strain 64228 chromosome, complete genome	blastn	21816	396	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis cynos
33011842	33011842	PRJEB14175_P_NODE_219900_length_213_cov_60.921053_g217632_i0	PRJEB14175	219900	213	60.921053	129.76184289	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	60.5	1.38e-8	NR	MDD4070430.1	3018265	g217632	i0	50.8	0.830985915492958	59	24	83.1	1	189	13	202	255	MDD4070430.1 hypothetical protein [Candidatus Izemoplasmatales bacterium]	diamond	177	60.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
33025172	33025172	PRJEB14175_P_NODE_226100_length_209_cov_4.216216_g223832_i0	PRJEB14175	226100	209	4.216216	8.81189144	Bacillati	1783272	Bacteria	Bacteria	43.5	0.0115	NR	MCI6108229.1	2231116	g223832	i0	47.5	1.14832535885167	40	21	57.4	0	142	23	3	42	MCI6108229.1 hypothetical protein [Mycoplasmatota bacterium]	diamond	240	43.9	0.990888382687927	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
33147362	33147362	PRJEB14175_P_NODE_119464_length_320_cov_12.745174_g117198_i0	PRJEB14175	119464	320	12.745174	40.7845568	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	44.3	0.0263	NR	MDT8336945.1	3018265	g117198	i0	35.8	0.628125	67	42	61.9	1	96	293	745	811	MDT8336945.1 valine--tRNA ligase [Candidatus Izemoplasmatales bacterium]	diamond	201	44.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales 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);;