metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA640143" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA640143" 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
27554732	27554732	PRJNA640143_S_NODE_8804_length_287_cov_2.812000_g8594_i0	PRJNA640143	8804	287	2.812	8.07044	Sporodiniella umbellata	101117	Fungi	Fungi	169	1e-48	NR	KAI9268716.1	101117	g8594	i0	93.6	0.982578397212544	94	5	97.2	1	281	3	265	358	KAI9268716.1 hypothetical protein BY458DRAFT_511323 [Sporodiniella umbellata]	diamond	282	169	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Sporodiniella	Sporodiniella umbellata
28344275	28344275	PRJNA640143_S_NODE_246_length_1141_cov_9.676630_g212_i0	PRJNA640143	246	1141	9.67663	110.4103483	Rhizophagus clarus	94130	Fungi	Fungi	178	1.13e-48	NR	GES82402.1	94130	g212	i0	32.8	0.904469763365469	344	219	88.6	5	1069	59	4	342	GES82402.1 IS630 family transposase [Rhizophagus clarus]	diamond	1032	178	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
29228609	29228609	PRJNA640143_S_NODE_6349_length_331_cov_2.323129_g6139_i0	PRJNA640143	6349	331	2.3231290000000002	7.68955699	Rhizopus microsporus	58291	Fungi	Fungi	67	1.11e-10	NR	CEG70231.1	58291	g6139	i0	32.7	1.83081570996979	101	68	91.5	0	306	4	109	209	CEG70231.1 hypothetical protein RMATCC62417_06167 [Rhizopus microsporus]	diamond	606	67	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
29923170	29923170	PRJNA640143_S_NODE_9051_length_283_cov_217.544715_g8841_i0	PRJNA640143	9051	283	217.544715	615.65154345	Hesseltinella vesiculosa	101127	Fungi	Fungi	42.7	0.046	NR	ORX44065.1	101127	g8841	i0	44	0.530035335689046	50	28	53	0	199	50	13	62	ORX44065.1 hypothetical protein DM01DRAFT_1312606 [Hesseltinella vesiculosa]	diamond	150	42.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Hesseltinella	Hesseltinella vesiculosa
30143842	30143842	PRJNA640143_S_NODE_2952_length_461_cov_2.655660_g2764_i0	PRJNA640143	2952	461	2.65566	12.2425926	Rhizopus delemar	936053	Fungi	Fungi	251	8.28e-78	NR	KAG1449406.1	936053	g2764	i0	96	0.813449023861171	125	5	81.3	0	57	431	266	390	KAG1449406.1 hypothetical protein G6F56_008651 [Rhizopus delemar]	diamond	375	251	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
31958374	31958374	PRJNA640143_S_NODE_977_length_706_cov_3.046338_g886_i0	PRJNA640143	977	706	3.046338	21.50714628	Mucoromycota	1913637	Fungi	Fungi	101	7.53e-22	NR	KAG2201525.1	64648	g886	i0	29.2	1.52974504249292	216	144	90.9	4	60	701	5	213	KAG2201525.1 hypothetical protein INT47_007402 [Mucor saturninus]	diamond	1080	102	0.990196078431373	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor saturninus
32072535	32072535	PRJNA640143_S_NODE_18038_length_206_cov_3.000000_g17828_i0	PRJNA640143	18038	206	3	6.18	Sporodiniella umbellata	101117	Fungi	Fungi	79.3	2.55e-15	NR	KAI9268716.1	101117	g17828	i0	94.3	1.99514563106796	35	2	51	0	133	29	372	406	KAI9268716.1 hypothetical protein BY458DRAFT_511323 [Sporodiniella umbellata]	diamond	411	79.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Sporodiniella	Sporodiniella umbellata

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