metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA506002" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA506002" 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
10039062	10039062	PRJNA506002_S_NODE_50548_length_260_cov_2.021390_g50302_i0	PRJNA506002	50548	260	2.02139	5.255614	Mycoplasma wenyonii	65123	Bacteria	Bacteria	162	2.7399999999999997e-48	NR	WP_112664966.1	65123	g50302	i0	97.6	0.957692307692308	83	2	95.8	0	10	258	53	135	WP_112664966.1 restriction endonuclease PLD domain-containing protein [Mycoplasma wenyonii]	diamond	249	162	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
26855809	26855809	PRJNA506002_S_NODE_15801_length_367_cov_2.163265_g15555_i0	PRJNA506002	15801	367	2.163265	7.93918255	Mycoplasma wenyonii	65123	Bacteria	Bacteria	224	4.2e-65	NR	WP_112665124.1	65123	g15555	i0	99.2	0.97275204359673	119	1	97.3	0	359	3	582	700	WP_112665124.1 DUF3713 domain-containing protein [Mycoplasma wenyonii]	diamond	357	224	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27203282	27203282	PRJNA506002_S_NODE_26202_length_320_cov_1.477733_g25956_i0	PRJNA506002	26202	320	1.477733	4.7287456	Mycoplasma wenyonii	65123	Bacteria	Bacteria	189	1.14e-56	NR	WP_146737514.1	65123	g25956	i0	97.1	0.984375	105	3	98.4	0	5	319	5	109	WP_146737514.1 hypothetical protein [Mycoplasma wenyonii]	diamond	315	189	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27266781	27266781	PRJNA506002_S_NODE_66443_length_239_cov_2.084337_g66197_i0	PRJNA506002	66443	239	2.084337	4.98156543	Candidatus Mycoplasma haematolamae	141391	Bacteria	Bacteria	105	1.09e-24	NR	WP_014858110.1	141391	g66197	i0	67.1	0.95397489539749	76	25	95.4	0	1	228	5	80	WP_014858110.1 signal recognition particle receptor subunit alpha [Candidatus Mycoplasma haematolamae]	diamond	228	105	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematolamae
27393323	27393323	PRJNA506002_S_NODE_15083_length_371_cov_2.533557_g14837_i0	PRJNA506002	15083	371	2.533557	9.39949647	Mycoplasma wenyonii	65123	Bacteria	Bacteria	65.5	5.56e-10	NR	WP_014850079.1	65123	g14837	i0	52.6	0.962264150943396	57	25	46.1	1	181	11	164	218	WP_014850079.1 hypothetical protein [Mycoplasma wenyonii]	diamond	357	65.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
28308896	28308896	PRJNA506002_S_NODE_16306_length_364_cov_1.852234_g16060_i0	PRJNA506002	16306	364	1.852234	6.74213176	Mycoplasma wenyonii	65123	Bacteria	Bacteria	128	9.75e-35	NR	WP_112665419.1	65123	g16060	i0	81.7	0.675824175824176	82	15	67.6	0	248	3	1	82	WP_112665419.1 hypothetical protein [Mycoplasma wenyonii]	diamond	246	128	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
28971949	28971949	PRJNA506002_S_NODE_41248_length_279_cov_2.427184_g41002_i0	PRJNA506002	41248	279	2.427184	6.77184336	Mycoplasma wenyonii	65123	Bacteria	Bacteria	48.9	2.83e-4	NR	WP_014849561.1	65123	g41002	i0	41	0.89247311827957	83	46	87.1	3	37	279	105	186	WP_014849561.1 hypothetical protein [Mycoplasma wenyonii]	diamond	249	48.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
30361907	30361907	PRJNA506002_S_NODE_13972_length_378_cov_2.727869_g13726_i0	PRJNA506002	13972	378	2.727869	10.31134482	Mycoplasma wenyonii	65123	Bacteria	Bacteria	209	1.93e-66	NR	WP_112665531.1	65123	g13726	i0	99	0.825396825396825	104	1	82.5	0	67	378	1	104	WP_112665531.1 hypothetical protein [Mycoplasma wenyonii]	diamond	312	209	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
31372863	31372863	PRJNA506002_S_NODE_42696_length_276_cov_1.763547_g42450_i0	PRJNA506002	42696	276	1.763547	4.86738972	Mycoplasma wenyonii	65123	Bacteria	Bacteria	152	1.85e-41	NR	WP_112665597.1	65123	g42450	i0	100	0.826086956521739	76	0	82.6	0	237	10	146	221	WP_112665597.1 iron-containing alcohol dehydrogenase [Mycoplasma wenyonii]	diamond	228	152	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32036989	32036989	PRJNA506002_S_NODE_55878_length_251_cov_1.421348_g55632_i0	PRJNA506002	55878	251	1.421348	3.56758348	Mycoplasma wenyonii	65123	Bacteria	Bacteria	58.5	6.07e-9	NR	WP_112665663.1	65123	g55632	i0	84.8	0.394422310756972	33	4	38.2	1	250	155	50	82	WP_112665663.1 hypothetical protein [Mycoplasma wenyonii]	diamond	99	58.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii

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