metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_phylum = "Mucoromycota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2055446	2055446	PRJNA795663_S_NODE_7682_length_216_cov_1.357542_g7577_i0	PRJNA795663	7682	216	1.357542	2.93229072	Rhizopus arrhizus	64495	Fungi	Fungi	77.4	1.71e-16	NR	KAG1137060.1	64495	g7577	i0	62.3	1.70833333333333	61	23	84.7	0	202	20	42	102	KAG1137060.1 hypothetical protein G6F38_011590 [Rhizopus arrhizus]	diamond	369	77.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus arrhizus
27559161	27559161	PRJNA795663_S_NODE_11464_length_183_cov_1.041096_g11359_i0	PRJNA795663	11464	183	1.041096	1.90520568	Sporodiniella umbellata	101117	Fungi	Fungi	98.2	9.05e-25	NR	KAI9280774.1	101117	g11359	i0	96.1	0.836065573770492	51	2	83.6	0	163	11	63	113	KAI9280774.1 hypothetical protein BY458DRAFT_451006 [Sporodiniella umbellata]	diamond	153	98.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Sporodiniella	Sporodiniella umbellata
30527695	30527695	PRJNA795663_S_NODE_6633_length_230_cov_1.585492_g6528_i0	PRJNA795663	6633	230	1.585492	3.6466316	Rhizopus delemar	936053	Fungi	Fungi	71.6	3.47e-14	NR	KAG1442433.1	936053	g6528	i0	87.5	0.939130434782609	72	9	93.9	0	228	13	26	97	KAG1442433.1 hypothetical protein G6F56_011063 [Rhizopus delemar]	diamond	216	71.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
31074098	31074098	PRJNA795663_S_NODE_11715_length_181_cov_1.590278_g11610_i0	PRJNA795663	11715	181	1.590278	2.87840318	Mucorales	4827	Fungi	Fungi	55.1	7.33e-7	NR	XP_069237449.1	4840	g11610	i0	42.9	1.85635359116022	56	31	92.8	1	1	168	563	617	XP_069237449.1 uncharacterized protein VTP01DRAFT_2673 [Rhizomucor pusillus]	diamond	336	55.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
31254439	31254439	PRJNA795663_S_NODE_8875_length_203_cov_1.168675_g8770_i0	PRJNA795663	8875	203	1.168675	2.37241025	Rhizophagus clarus	94130	Fungi	Fungi	89.7	4.86e-19	NR	GBC09217.1	94130	g8770	i0	58.2	0.990147783251232	67	28	99	0	201	1	144	210	GBC09217.1 hypothetical protein RclHR1_00870008 [Rhizophagus clarus]	diamond	201	89.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
31665577	31665577	PRJNA795663_S_NODE_2357_length_368_cov_4.027190_g2252_i0	PRJNA795663	2357	368	4.02719	14.8200592	Rhizopus delemar	936053	Fungi	Fungi	202	5.96e-63	NR	KAG1468767.1	936053	g2252	i0	100	0.75	92	0	75	0	3	278	178	269	KAG1468767.1 hypothetical protein G6F56_003648 [Rhizopus delemar]	diamond	276	202	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar

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