metadata: contig_metadata: 10 rows where bioproject = "PRJNA763718" and tax

10 rows where bioproject = "PRJNA763718" 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
10948326	10948326	PRJNA763718_S_NODE_7589_length_160_cov_0.934959_g7381_i0	PRJNA763718	7589	160	0.934959	1.4959344	Mariniplasma anaerobium	2735436	Bacteria	Bacteria	150	4.569999999999999e-32	NTclustered	gi\|1964073164\|dbj\|AP024412.1\|	2735436	g7381	i0	84.516	84.85625	155	20	96	4	5	157	1311171	1311323	Mariniplasma anaerobium DNA, complete genome	blastn	13577	150	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Mariniplasma	Mariniplasma anaerobium
12223896	12223896	PRJNA763718_S_NODE_6650_length_170_cov_1.090226_g6442_i0	PRJNA763718	6650	170	1.090226	1.8533842	Malacoplasma muris	2119	Bacteria	Bacteria	237	3.6600000000000005e-58	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g6442	i0	91.813	54.0411764705882	171	12	100	2	1	170	703	872	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	9187	237	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
19871000	19871000	PRJNA763718_S_NODE_6036_length_178_cov_1.106383_g5828_i0	PRJNA763718	6036	178	1.106383	1.96936174	Malacoplasma microti	38746	Bacteria	Bacteria	283	4.909999999999999e-72	NTclustered	gi\|299851939\|gb\|HM135466.1\|	38746	g5828	i0	95.506	27.0337078651685	178	7	100	1	1	178	1437	1613	Mycoplasma microti strain IL371 23S ribosomal RNA gene, partial sequence	blastn	4812	283	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma microti
27053265	27053265	PRJNA763718_S_NODE_7862_length_157_cov_1.916667_g7654_i0	PRJNA763718	7862	157	1.916667	3.00916719	Mycoplasma sp.	2108	Bacteria	Bacteria	82	1.83e-18	NR	MBD5445970.1	2108	g7654	i0	82.7	0.993630573248408	52	9	99.4	0	156	1	33	84	MBD5445970.1 50S ribosomal protein L18 [Mycoplasma sp.]	diamond	156	82	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
27685331	27685331	PRJNA763718_S_NODE_7064_length_165_cov_1.492188_g6856_i0	PRJNA763718	7064	165	1.492188	2.4621102	Malacoplasma iowae	2116	Bacteria	Bacteria	84	1.83e-17	NR	WP_004024699.1	2116	g6856	i0	75.9	0.981818181818182	54	13	98.2	0	163	2	43	96	WP_004024699.1 50S ribosomal protein L22 [Malacoplasma iowae]	diamond	162	84	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
29494368	29494368	PRJNA763718_S_NODE_6810_length_168_cov_1.396947_g6602_i0	PRJNA763718	6810	168	1.396947	2.34687096	Mollicutes	31969	Bacteria	Bacteria	65.5	6.26e-11	NR	MBD5445965.1	2108	g6602	i0	68.3	2.96428571428571	41	13	73.2	0	1	123	176	216	MBD5445965.1 type I methionyl aminopeptidase [Mycoplasma sp.]	diamond	498	65.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
31001148	31001148	PRJNA763718_S_NODE_5694_length_183_cov_1.849315_g5486_i0	PRJNA763718	5694	183	1.849315	3.38424645	Candidatus Ureaplasma intestinipullorum	2838770	Bacteria	Bacteria	53.1	3.15e-7	NR	MBU3830742.1	2838770	g5486	i0	46	2.42622950819672	50	27	82	0	150	1	36	85	MBU3830742.1 DUF2188 domain-containing protein [Candidatus Ureaplasma intestinipullorum]	diamond	444	53.1	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Candidatus Ureaplasma intestinipullorum
31127052	31127052	PRJNA763718_S_NODE_6795_length_168_cov_1.763359_g6587_i0	PRJNA763718	6795	168	1.763359	2.96244312	Malacoplasma sp.	2791014	Bacteria	Bacteria	69.7	2.69e-13	NR	MDE6645948.1	2791014	g6587	i0	61.1	1.94642857142857	54	21	96.4	0	162	1	20	73	MDE6645948.1 50S ribosomal protein L10 [Malacoplasma sp.]	diamond	327	69.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma sp.
31317123	31317123	PRJNA763718_S_NODE_2115_length_319_cov_5.815603_g1907_i0	PRJNA763718	2115	319	5.815603	18.55177357	Spiroplasma culicicola	216935	Bacteria	Bacteria	149	7.45e-42	NR	WP_025362677.1	216935	g1907	i0	67.9	2.99059561128527	106	34	99.7	0	318	1	42	147	WP_025362677.1 L-lactate dehydrogenase [Spiroplasma culicicola]	diamond	954	149	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma culicicola
31959324	31959324	PRJNA763718_S_NODE_5357_length_189_cov_2.263158_g5149_i0	PRJNA763718	5357	189	2.263158	4.27736862	Mollicutes	31969	Bacteria	Bacteria	70.1	3.72e-12	NR	MFA7422770.1	1898209	g5149	i0	78.6	3.33333333333333	42	9	66.7	0	2	127	356	397	MFA7422770.1 phosphoglycerate kinase [Acholeplasmataceae bacterium]	diamond	630	70.5	0.994326241134752	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae 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);;