metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA637219" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA637219" 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
24107003	24107003	PRJNA637219_S_NODE_1259_length_387_cov_1.405325_g1214_i0	PRJNA637219	1259	387	1.405325	5.43860775	root	1	Root_unresolved	Root_unresolved	103	3.13e-24	NR	KAH8547581.1	1896174	g1214	i0	46.6	1.82170542635659	116	57	89.9	2	385	38	107	217	KAH8547581.1 4-dihydrotrisporin dehydrogenase [Umbelopsis sp. PMI_123]	diamond	705	103	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis sp. PMI_123
26700990	26700990	PRJNA637219_S_NODE_9001_length_177_cov_1.195312_g8956_i0	PRJNA637219	9001	177	1.195312	2.11570224	Paraglomus occultum	144539	Fungi	Fungi	55.8	3.56e-7	NR	CAG8509588.1	144539	g8956	i0	67.6	0.627118644067797	37	12	62.7	0	51	161	383	419	CAG8509588.1 4440_t:CDS:2 [Paraglomus occultum]	diamond	111	55.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales	Paraglomeraceae	Paraglomus	Paraglomus occultum
27554695	27554695	PRJNA637219_S_NODE_16444_length_161_cov_1.607143_g16399_i0	PRJNA637219	16444	161	1.607143	2.58750023	Entrophospora candida	984092	Fungi	Fungi	41.2	0.0435	NR	CAG8637608.1	984092	g16399	i0	45.5	0.819875776397516	44	24	82	0	159	28	231	274	CAG8637608.1 6850_t:CDS:2, partial [Entrophospora candida]	diamond	132	41.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Entrophosporales	Entrophosporaceae	Entrophospora	Entrophospora candida
28388273	28388273	PRJNA637219_S_NODE_11266_length_167_cov_0.864407_g11221_i0	PRJNA637219	11266	167	0.864407	1.44355969	Fungi	4751	Fungi	Fungi	90.1	2.71e-19	NR	SAL97607.1	4829	g11221	i0	76.4	23.6407185628743	55	13	98.8	0	2	166	1867	1921	SAL97607.1 hypothetical protein [Absidia glauca]	diamond	3948	90.9	0.991199119911991	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca
29954651	29954651	PRJNA637219_S_NODE_9951_length_170_cov_2.074380_g9906_i0	PRJNA637219	9951	170	2.07438	3.526446	Paraglomus occultum	144539	Fungi	Fungi	50.1	3.6e-5	NR	CAG8640750.1	144539	g9906	i0	62.9	1.04117647058824	35	13	61.8	0	2	106	500	534	CAG8640750.1 917_t:CDS:2, partial [Paraglomus occultum]	diamond	177	50.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales	Paraglomeraceae	Paraglomus	Paraglomus occultum
30504273	30504273	PRJNA637219_S_NODE_13333_length_164_cov_1.617391_g13288_i0	PRJNA637219	13333	164	1.617391	2.65252124	Entrophospora	27375	Fungi	Fungi	69.7	7.41e-13	NR	CAG8607459.1	984092	g13288	i0	77.3	14.2682926829268	44	10	80.5	0	157	26	72	115	CAG8607459.1 61_t:CDS:2 [Entrophospora candida]	diamond	2340	70.1	0.994293865905849	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Entrophosporales	Entrophosporaceae	Entrophospora	Entrophospora candida
31945768	31945768	PRJNA637219_S_NODE_3677_length_248_cov_0.904523_g3632_i0	PRJNA637219	3677	248	0.904523	2.24321704	Rhizophagus sp. MUCL 43196	1803374	Fungi	Fungi	63.5	8.74e-10	NR	RGB31720.1	1803374	g3632	i0	47.9	0.883064516129032	73	35	87.1	2	217	2	43	113	RGB31720.1 hypothetical protein C1646_244867 [Rhizophagus diaphanus] [Rhizophagus sp. MUCL 43196]	diamond	219	63.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus sp. MUCL 43196
31945770	31945770	PRJNA637219_S_NODE_7897_length_186_cov_1.116788_g7852_i0	PRJNA637219	7897	186	1.116788	2.07722568	Chlamydoabsidia padenii	90267	Fungi	Fungi	56.6	2.16e-7	NR	KAI8344765.1	90267	g7852	i0	51.7	0.935483870967742	58	23	93.5	2	8	181	63	115	KAI8344765.1 cytochrome P450 [Chlamydoabsidia padenii]	diamond	174	56.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Chlamydoabsidia	Chlamydoabsidia padenii
32148350	32148350	PRJNA637219_S_NODE_13118_length_165_cov_0.879310_g13073_i0	PRJNA637219	13118	165	0.87931	1.4508615	root	1	Root_unresolved	Root_unresolved	70.9	1.53e-12	NR	XP_069248004.1	911321	g13073	i0	73.8	1.74545454545455	42	11	76.4	0	127	2	1012	1053	XP_069248004.1 uncharacterized protein VTP21DRAFT_5436 [Calcarisporiella thermophila]	diamond	288	70.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila

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