metadata: contig_metadata: 11 rows where bioproject = "PRJNA611476" and tax

11 rows where bioproject = "PRJNA611476" 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
10794468	10794468	PRJNA611476_P_NODE_97169_length_246_cov_0.890173_g96378_i0	PRJNA611476	97169	246	0.890173	2.18982558	Spiroplasma endosymbiont of Drosophila atripex	614643	Bacteria	Bacteria	182	2.72e-41	NTclustered	gi\|2444111447\|gb\|CP117528.1\|	614643	g96378	i0	94.118	10.369918699187	119	7	48	0	1	119	900480	900362	MAG: Spiroplasma endosymbiont of Drosophila atripex isolate sAtri chromosome, complete genome	blastn	2551	182	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Drosophila atripex
17167276	17167276	PRJNA611476_P_NODE_38734_length_341_cov_1.160448_g37943_i0	PRJNA611476	38734	341	1.160448	3.95712768	[Mycoplasma] gypis	92404	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2702675406\|gb\|CP148066.1\|	92404	g37943	i0	100	0.0821114369501466	28	0	8	0	66	93	194695	194722	[Mycoplasma] gypis strain B1/T1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	[Mycoplasma] gypis
18440837	18440837	PRJNA611476_P_NODE_101275_length_245_cov_0.895349_g100484_i0	PRJNA611476	101275	245	0.895349	2.19360505	Mesomycoplasma ovipneumoniae	29562	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2290351421\|gb\|CP079199.1\|	29562	g100484	i0	100	0.114285714285714	28	0	11	0	116	143	646763	646736	Mesomycoplasma ovipneumoniae strain 274 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma ovipneumoniae
19716737	19716737	PRJNA611476_P_NODE_96076_length_247_cov_0.885057_g95285_i0	PRJNA611476	96076	247	0.885057	2.18609079	uncultured Mycoplasmataceae bacterium	300027	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1824112148\|gb\|MN991199.1\|	300027	g95285	i0	99.595	2.31578947368421	247	1	100	0	1	247	81944	81698	Uncultured Mycoplasmataceae bacterium isolate LL85 clone UCI_10-1	blastn	572	451	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		uncultured Mycoplasmataceae bacterium
25374587	25374587	PRJNA611476_P_NODE_79560_length_251_cov_0.865169_g78769_i0	PRJNA611476	79560	251	0.865169	2.17157419	Mesomycoplasma	2923352	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g78769	i0	100	16.9880478087649	251	0	100	0	1	251	958	1208	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4264	464	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
26700158	26700158	PRJNA611476_P_NODE_39841_length_337_cov_1.571970_g39050_i0	PRJNA611476	39841	337	1.57197	5.2975389	Aster yellows phytoplasma	35779	Bacteria	Bacteria	53.1	8.52e-7	NR	AAO61994.1	35779	g39050	i0	51.9	0.961424332344214	52	25	46.3	0	165	10	1	52	AAO61994.1 conserved hypothetical protein, partial [Aster yellows phytoplasma]	diamond	324	53.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Aster yellows phytoplasma
29859043	29859043	PRJNA611476_P_NODE_98111_length_246_cov_0.890173_g97320_i0	PRJNA611476	98111	246	0.890173	2.18982558	Haploplasma axanthum	29552	Bacteria	Bacteria	72.8	9.98e-13	NR	WP_129747553.1	29552	g97320	i0	43.2	0.98780487804878	81	46	98.8	0	3	245	51	131	WP_129747553.1 lectin-like domain-containing protein [Haploplasma axanthum]	diamond	243	72.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Haploplasma	Haploplasma axanthum
31122444	31122444	PRJNA611476_P_NODE_116075_length_241_cov_0.916667_g115284_i0	PRJNA611476	116075	241	0.916667	2.20916747	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	90.9	4.07e-19	NR	MDY0294809.1	1898209	g115284	i0	60.5	0.946058091286307	76	30	94.6	0	233	6	958	1033	MDY0294809.1 DNRLRE domain-containing protein [Acholeplasmataceae bacterium]	diamond	228	90.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
31913464	31913464	PRJNA611476_P_NODE_105757_length_244_cov_0.900585_g104966_i0	PRJNA611476	105757	244	0.900585	2.1974274	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	99	4e-23	NR	HHX00860.1	1898209	g104966	i0	100	0.590163934426229	48	0	59	0	244	101	216	263	HHX00860.1 hypothetical protein [Acholeplasmataceae bacterium]	diamond	144	99	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
32829857	32829857	PRJNA611476_P_NODE_116380_length_241_cov_0.916667_g115589_i0	PRJNA611476	116380	241	0.916667	2.20916747	Haploplasma sp.	2903113	Bacteria	Bacteria	150	1.1399999999999997e-42	NR	HKL95362.1	2903113	g115589	i0	97.5	0.995850622406639	80	2	99.6	0	2	241	202	281	HKL95362.1 DNA-binding protein WhiA [Haploplasma sp.]	diamond	240	150	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Haploplasma	Haploplasma sp.
32842748	32842748	PRJNA611476_P_NODE_60560_length_284_cov_1.199052_g59769_i0	PRJNA611476	60560	284	1.199052	3.40530768	Bacillati	1783272	Bacteria	Bacteria	43.1	0.00821	NR	OPZ33206.1	1852921	g59769	i0	50	1.51056338028169	52	24	53.9	2	193	41	30	80	OPZ33206.1 MAG: Double zinc ribbon [Tenericutes bacterium ADurb.BinA124]	diamond	429	43.1	1	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium ADurb.BinA124

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