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

7 rows where analysis = "diamond", bioproject = "PRJEB28062" 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
6402437	6402437	PRJEB28062_P_NODE_21006_length_818_cov_6.240268_g18910_i0	PRJEB28062	21006	818	6.240268	51.04539224	Rhizopus	4842	Fungi	Fungi	144	1.98e-39	NR	RCH92830.1	4846	g18910	i0	65.2	6.2200488997555	135	45	48.8	2	814	416	1	135	RCH92830.1 40S ribosomal protein S6, partial [Rhizopus stolonifer]	diamond	5088	144	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus stolonifer
17877342	17877342	PRJEB28062_P_NODE_88975_length_348_cov_4.076364_g86613_i0	PRJEB28062	88975	348	4.076364	14.18574672	Fungi	4751	Fungi	Fungi	164	2.99e-44	NR	XP_069241793.1	4840	g86613	i0	73.8	38.6034482758621	107	28	92.2	0	18	338	745	851	XP_069241793.1 DNA-directed RNA polymerase II subunit RPB1 [Rhizomucor pusillus]	diamond	13434	165	0.993939393939394	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
20425155	20425155	PRJEB28062_P_NODE_28277_length_696_cov_38.680578_g26014_i0	PRJEB28062	28277	696	38.680578	269.21682288	Fungi	4751	Fungi	Fungi	254	2.87e-79	NR	KAG9301506.1	50956	g26014	i0	73.1	38.2284482758621	186	46	80.2	3	49	606	1	182	KAG9301506.1 hypothetical protein G9A89_008358 [Geosiphon pyriformis]	diamond	26607	256	0.9921875	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Geosiphonaceae	Geosiphon	Geosiphon pyriformis
30089813	30089813	PRJEB28062_P_NODE_131232_length_239_cov_26.427711_g128868_i0	PRJEB28062	131232	239	26.427711	63.16222929	Fungi	4751	Fungi	Fungi	73.9	3.64e-13	NR	CAG8483113.1	144539	g128868	i0	62.7	1.94560669456067	51	19	64	0	27	179	1012	1062	CAG8483113.1 10690_t:CDS:10 [Paraglomus occultum]	diamond	465	73.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales	Paraglomeraceae	Paraglomus	Paraglomus occultum
30595312	30595312	PRJEB28062_P_NODE_45873_length_530_cov_84.954048_g43532_i0	PRJEB28062	45873	530	84.954048	450.2564544	Opisthokonta	33154	Fungi	Fungi	47.4	0.0126	NR	KAG2182317.1	91625	g43532	i0	34.8	1.00754716981132	69	29	30	1	35	193	113	181	KAG2182317.1 hypothetical protein INT43_007247 [Umbelopsis isabellina]	diamond	534	47.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis isabellina
31385704	31385704	PRJEB28062_P_NODE_123096_length_253_cov_4.650000_g120732_i0	PRJEB28062	123096	253	4.65	11.7645	Mucorales	4827	Fungi	Fungi	54.3	3.64e-6	NR	KAI9263108.1	60185	g120732	i0	43.1	13.3162055335968	58	28	68.8	1	190	17	684	736	KAI9263108.1 hypothetical protein BDA99DRAFT_463429 [Phascolomyces articulosus]	diamond	3369	54.7	0.992687385740402	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Phascolomyces	Phascolomyces articulosus
32625423	32625423	PRJEB28062_P_NODE_111560_length_282_cov_2.622010_g109197_i0	PRJEB28062	111560	282	2.62201	7.3940682	Mucor lusitanicus	29924	Fungi	Fungi	73.2	7.9e-13	NR	AKT93713.1	29924	g109197	i0	51.3	1.96808510638298	76	28	71.3	1	234	34	247	322	AKT93713.1 NADH dehydrogenase subunit 1 [Mucor lusitanicus]	diamond	555	73.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor lusitanicus

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