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

5 rows where analysis = "diamond", bioproject = "PRJNA1123686" 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
27891372	27891372	PRJNA1123686_S_NODE_6485_length_214_cov_4.491892_g6453_i0	PRJNA1123686	6485	214	4.491892	9.61264888	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	144	3.929999999999999e-40	NR	WP_187150667.1	432608	g6453	i0	97.1	0.981308411214953	70	2	98.1	0	2	211	197	266	WP_187150667.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	210	144	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
28523102	28523102	PRJNA1123686_S_NODE_6007_length_219_cov_4.126316_g5975_i0	PRJNA1123686	6007	219	4.126316	9.03663204	Mycoplasma wenyonii	65123	Bacteria	Bacteria	62.4	1.38e-9	NR	WP_014850079.1	65123	g5975	i0	51.9	1.50684931506849	54	24	74	1	162	1	164	215	WP_014850079.1 hypothetical protein [Mycoplasma wenyonii]	diamond	330	62.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
29186257	29186257	PRJNA1123686_S_NODE_20169_length_154_cov_2.448000_g20137_i0	PRJNA1123686	20169	154	2.448	3.76992	Mycoplasma wenyonii	65123	Bacteria	Bacteria	74.7	5.9e-14	NR	WP_014849727.1	65123	g20137	i0	86.7	1.75324675324675	45	6	87.7	0	136	2	77	121	WP_014849727.1 hypothetical protein [Mycoplasma wenyonii]	diamond	270	74.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32599585	32599585	PRJNA1123686_S_NODE_21480_length_151_cov_2.344262_g21448_i0	PRJNA1123686	21480	151	2.344262	3.53983562	Mycoplasma wenyonii	65123	Bacteria	Bacteria	72.4	2.44e-13	NR	WP_110555174.1	65123	g21448	i0	77.1	0.95364238410596	48	11	95.4	0	1	144	274	321	WP_110555174.1 L-lactate dehydrogenase [Mycoplasma wenyonii]	diamond	144	72.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32630771	32630771	PRJNA1123686_S_NODE_7280_length_207_cov_5.050562_g7248_i0	PRJNA1123686	7280	207	5.050562	10.45466334	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	62.4	1.9e-9	NR	WP_187150208.1	432608	g7248	i0	100	0.434782608695652	30	0	43.5	0	190	101	255	284	WP_187150208.1 50S ribosomal protein L2 [Candidatus Mycoplasma haematobovis]	diamond	90	62.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis

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