metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA946307" 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
27657502	27657502	PRJNA946307_P_NODE_45124_length_210_cov_5.521739_g44250_i0	PRJNA946307	45124	210	5.521739	11.5956519	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	90.9	2.39e-19	NR	MCK9234936.1	1898209	g44250	i0	57	2.25714285714286	79	18	90	1	3	191	178	256	MCK9234936.1 hypothetical protein [Acholeplasmataceae bacterium]	diamond	474	90.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
28320335	28320335	PRJNA946307_P_NODE_67426_length_199_cov_4.220000_g66552_i0	PRJNA946307	67426	199	4.22	8.3978	Mollicutes bacterium	37628	Bacteria	Bacteria	81.3	4.13e-16	NR	MCI6789462.1	37628	g66552	i0	59.3	2.66834170854271	59	20	82.9	1	180	16	294	352	MCI6789462.1 IS30 family transposase [Mollicutes bacterium]	diamond	531	81.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium
28415153	28415153	PRJNA946307_P_NODE_118106_length_176_cov_1.527559_g117232_i0	PRJNA946307	118106	176	1.5275589999999999	2.68850384	Mycoplasmoidaceae bacterium	2854035	Bacteria	Bacteria	40.8	0.0159	NR	MCQ2956423.1	2854035	g117232	i0	46.5	0.732954545454545	43	23	73.3	0	3	131	30	72	MCQ2956423.1 hypothetical protein [Mycoplasmoidaceae bacterium]	diamond	129	40.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae		Mycoplasmoidaceae bacterium
30056844	30056844	PRJNA946307_P_NODE_134171_length_169_cov_1.616667_g133297_i0	PRJNA946307	134171	169	1.616667	2.73216723	Paracholeplasma morum	264637	Bacteria	Bacteria	78.2	4.44e-15	NR	WP_204434000.1	264637	g133297	i0	67.9	4.70414201183432	53	17	94.1	0	2	160	508	560	WP_204434000.1 HD domain-containing phosphohydrolase [Paracholeplasma morum]	diamond	795	78.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Paracholeplasma	Paracholeplasma morum
32365111	32365111	PRJNA946307_P_NODE_162459_length_162_cov_0.902655_g161585_i0	PRJNA946307	162459	162	0.902655	1.4623011	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	88.6	8.99e-19	NR	MFA5037766.1	3018265	g161585	i0	81.3	0.888888888888889	48	9	88.9	0	162	19	628	675	MFA5037766.1 hypothetical protein [Candidatus Izemoplasmatales bacterium]	diamond	144	88.6	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);;