metadata: contig_metadata: 7 rows where bioproject = "PRJEB75230" and tax

7 rows where bioproject = "PRJEB75230" 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
14166134	14166134	PRJEB75230_P_NODE_73112_length_286_cov_1.084507_g72930_i0	PRJEB75230	73112	286	1.084507	3.10169002	Mycoplasma sp. OR1901	2742195	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1858594482\|gb\|CP054666.1\|	2742195	g72930	i0	100	0.0979020979020979	28	0	10	0	48	75	776187	776214	Mycoplasma sp. OR1901 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp. OR1901
22672748	22672748	PRJEB75230_P_NODE_150038_length_246_cov_0.890173_g149856_i0	PRJEB75230	150038	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	52.8	0.022	NTclustered	gi\|1572559275\|emb\|LS483518.1\|	40477	g149856	i0	100	7.05691056910569	28	0	11	0	77	104	1012266	1012239	Mycoplasma mycoides subsp. capri strain GM12 genome assembly, chromosome: omosome	blastn	1736	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma mycoides
28076441	28076441	PRJEB75230_P_NODE_92985_length_269_cov_1.178571_g92803_i0	PRJEB75230	92985	269	1.178571	3.17035599	Mesomycoplasma ovipneumoniae	29562	Bacteria	Bacteria	40.8	0.0311	NR	WP_337904927.1	29562	g92803	i0	47.7	0.490706319702602	44	23	49.1	0	111	242	16	59	WP_337904927.1 hypothetical protein, partial [Mesomycoplasma ovipneumoniae]	diamond	132	40.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma ovipneumoniae
28132566	28132566	PRJEB75230_P_NODE_95025_length_267_cov_1.587629_g94843_i0	PRJEB75230	95025	267	1.587629	4.23896943	Bacillati	1783272	Bacteria	Bacteria	43.1	0.0331	NR	NLZ85401.1	1898209	g94843	i0	37.5	1.07865168539326	48	26	49.4	1	100	231	198	245	NLZ85401.1 multidrug ABC transporter permease [Acholeplasmataceae bacterium]	diamond	288	43.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
30287401	30287401	PRJEB75230_P_NODE_179932_length_241_cov_0.916667_g179750_i0	PRJEB75230	179932	241	0.916667	2.20916747	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	132	9.18e-38	NR	MDV3185308.1	2754999	g179750	i0	85	0.995850622406639	80	12	99.6	0	1	240	14	93	MDV3185308.1 hypothetical protein [Candidatus Phytoplasma australasiaticum]	diamond	240	132	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
31930658	31930658	PRJEB75230_P_NODE_35797_length_336_cov_1.171103_g35615_i0	PRJEB75230	35797	336	1.171103	3.93490608	Mycoplasma haemofelis str. Langford 1	941640	Bacteria	Bacteria	44.3	0.00995	NR	CBY93226.1	941640	g35615	i0	35.4	0.732142857142857	82	47	71.4	2	251	12	31	108	CBY93226.1 hypothetical protein HF1_12180 [Mycoplasma haemofelis str. Langford 1]	diamond	246	44.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemofelis
32783878	32783878	PRJEB75230_P_NODE_69680_length_289_cov_1.212963_g69498_i0	PRJEB75230	69680	289	1.212963	3.50546307	Haploplasma sp.	2903113	Bacteria	Bacteria	45.4	0.00674	NR	HKL95428.1	2903113	g69498	i0	34.7	0.778546712802768	75	44	77.9	2	60	284	29	98	HKL95428.1 phosphate ABC transporter permease PstA [Haploplasma sp.]	diamond	225	45.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Haploplasma	Haploplasma sp.

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