metadata: contig_metadata: 7 rows where bioproject = "PRJNA1255065", tax_kingdom = "Bacillati" and tax

7 rows where bioproject = "PRJNA1255065", tax_kingdom = "Bacillati" 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
13806627	13806627	PRJNA1255065_P_NODE_151751_length_162_cov_0.920354_g149523_i0	PRJNA1255065	151751	162	0.920354	1.49097348	root	1	Root_unresolved	Root_unresolved	52.8	0.013	NTclustered	gi\|2639800476\|gb\|CP141041.1\|	171284	g149523	i0	100	0.401234567901235	28	0	17	0	16	43	688385	688358	Mycoplasmopsis cynos strain 94662 chromosome	blastn	65	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis cynos
16937116	16937116	PRJNA1255065_P_NODE_114134_length_168_cov_0.873950_g111906_i0	PRJNA1255065	114134	168	0.87395	1.468236	Spiroplasma culicicola	216935	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|583840421\|gb\|CP006681.1\|	1276246	g111906	i0	100	0.166666666666667	28	0	17	0	117	144	480339	480312	Spiroplasma culicicola AES-1, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma culicicola
16937743	16937743	PRJNA1255065_P_NODE_62334_length_239_cov_1.894737_g60106_i0	PRJNA1255065	62334	239	1.894737	4.52842143	Spiroplasma endosymbiont of Aspidapion aeneum	3066276	Bacteria	Bacteria	132	2.68e-26	NTclustered	gi\|2719904881\|emb\|OZ034994.1\|	3066276	g60106	i0	86.667	157.790794979079	120	14	50	2	120	238	943829	943947	Spiroplasma endosymbiont of Aspidapion aeneum isolate 54746 genome assembly, chromosome: 1	blastn	37712	132	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Aspidapion aeneum
27516194	27516194	PRJNA1255065_P_NODE_7263_length_1063_cov_49.628205_g5990_i1	PRJNA1255065	7263	1063	49.628205	527.54781915	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	115	3.72e-27	NR	MBW0597145.1	171279	g5990	i1	68	0.640639698965193	97	31	27.4	0	550	840	62	158	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	681	115	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
29189764	29189764	PRJNA1255065_P_NODE_121729_length_167_cov_0.813559_g119501_i0	PRJNA1255065	121729	167	0.813559	1.35864353	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	45.8	2e-4	NR	MDI3350086.1	2094	g119501	i0	76	0.449101796407186	25	6	44.9	0	164	90	71	95	MDI3350086.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	75	45.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
30737180	30737180	PRJNA1255065_P_NODE_122654_length_166_cov_1.247863_g120426_i0	PRJNA1255065	122654	166	1.247863	2.07145258	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	45.4	0.00122	NR	MDI3350303.1	2094	g120426	i0	85.7	0.379518072289157	21	3	38	0	88	26	4	24	MDI3350303.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	63	45.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
31685541	31685541	PRJNA1255065_P_NODE_128117_length_165_cov_1.793103_g125889_i0	PRJNA1255065	128117	165	1.793103	2.95861995	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	40.4	0.0246	NR	MDI3350086.1	2094	g125889	i0	72.7	0.4	22	6	40	0	3	68	74	95	MDI3350086.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	66	40.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini

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