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

10 rows where analysis = "diamond", bioproject = "PRJNA591127" 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
27725349	27725349	PRJNA591127_P_NODE_13524_length_200_cov_1.564417_g13355_i0	PRJNA591127	13524	200	1.564417	3.128834	Fungi	4751	Fungi	Fungi	45.1	0.00167	NR	CAG8677645.1	984092	g13355	i0	65.8	2.745	38	13	57	0	195	82	16	53	CAG8677645.1 9746_t:CDS:2, partial [Entrophospora candida]	diamond	549	45.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Entrophosporales	Entrophosporaceae	Entrophospora	Entrophospora candida
27788229	27788229	PRJNA591127_P_NODE_14604_length_197_cov_4.037500_g14435_i0	PRJNA591127	14604	197	4.0375	7.953875	Mucorales	4827	Fungi	Fungi	48.9	1.19e-4	NR	KAG1082787.1	64495	g14435	i0	84	6.47208121827411	25	4	38.1	0	1	75	195	219	KAG1082787.1 hypothetical protein G6F42_022448 [Rhizopus arrhizus]	diamond	1275	48.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus arrhizus
28500955	28500955	PRJNA591127_P_NODE_30467_length_151_cov_2.833333_g30298_i0	PRJNA591127	30467	151	2.833333	4.27833283	Bifiguratus adelaidae	1938954	Fungi	Fungi	44.7	0.00226	NR	OZJ04384.1	1938954	g30298	i0	66.7	0.536423841059603	27	9	53.6	0	150	70	615	641	OZJ04384.1 hypothetical protein BZG36_02405 [Bifiguratus adelaidae]	diamond	81	44.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales		Bifiguratus	Bifiguratus adelaidae
28627398	28627398	PRJNA591127_P_NODE_17107_length_197_cov_2.593750_g16938_i0	PRJNA591127	17107	197	2.59375	5.1096875	Thamnidium elegans	101142	Fungi	Fungi	49.7	7.13e-5	NR	KAG2237338.1	101142	g16938	i0	75	1.82741116751269	24	6	36.5	0	124	195	322	345	KAG2237338.1 hypothetical protein INT48_009071 [Thamnidium elegans]	diamond	360	49.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Thamnidium	Thamnidium elegans
30174424	30174424	PRJNA591127_P_NODE_20652_length_196_cov_3.100629_g20483_i0	PRJNA591127	20652	196	3.100629	6.07723284	Racocetra persica	160502	Fungi	Fungi	46.6	6.92e-4	NR	CAG8812724.1	160502	g20483	i0	38.5	1.98979591836735	65	30	99.5	1	195	1	147	201	CAG8812724.1 18002_t:CDS:2, partial [Racocetra persica]	diamond	390	46.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Racocetra	Racocetra persica
30648158	30648158	PRJNA591127_P_NODE_15773_length_197_cov_3.106250_g15604_i0	PRJNA591127	15773	197	3.10625	6.1193125	Mucor plumbeus	97098	Fungi	Fungi	78.2	2.23e-15	NR	KAG2197500.1	97098	g15604	i0	66.1	1.91878172588832	62	21	94.4	0	11	196	46	107	KAG2197500.1 hypothetical protein INT46_003429 [Mucor plumbeus]	diamond	378	78.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor plumbeus
31325441	31325441	PRJNA591127_P_NODE_7975_length_261_cov_1.375000_g7807_i0	PRJNA591127	7975	261	1.375	3.58875	Mucor	4830	Fungi	Fungi	68.2	6.24e-12	NR	GAN02220.1	91626	g7807	i0	46.4	5.57471264367816	84	44	96.6	1	261	10	83	165	GAN02220.1 40S ribosomal protein S25 [Mucor ambiguus]	diamond	1455	68.6	0.994169096209913	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor ambiguus
31547090	31547090	PRJNA591127_P_NODE_24516_length_171_cov_2.880597_g24347_i0	PRJNA591127	24516	171	2.880597	4.92582087	Eukaryota	2759	Fungi	Fungi	57.8	6.79e-8	NR	KAF9374415.1	78898	g24347	i0	47.8	33.6842105263158	69	22	96.5	2	167	3	296	364	KAF9374415.1 37S ribosomal protein S9, mitochondrial [Podila verticillata]	diamond	5760	58.2	0.993127147766323	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila verticillata
31958053	31958053	PRJNA591127_P_NODE_13717_length_198_cov_3.341615_g13548_i0	PRJNA591127	13717	198	3.341615	6.6163977	Eukaryota	2759	Fungi	Fungi	107	2.51e-25	NR	CAG8519310.1	4874	g13548	i0	81.3	21.3939393939394	64	12	97	0	2	193	393	456	CAG8519310.1 6912_t:CDS:2 [Gigaspora margarita]	diamond	4236	107	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
32622266	32622266	PRJNA591127_P_NODE_13700_length_198_cov_4.012422_g13531_i0	PRJNA591127	13700	198	4.012422	7.94459556	Fungi	4751	Fungi	Fungi	109	1.55e-27	NR	KAG2175289.1	44442	g13531	i0	73.8	6.89393939393939	65	17	98.5	0	2	196	60	124	KAG2175289.1 hypothetical protein INT44_007777 [Umbelopsis vinacea]	diamond	1365	110	0.990909090909091	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis vinacea

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