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

10 rows where analysis = "diamond", bioproject = "PRJNA827593" 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
26896472	26896472	PRJNA827593_P_NODE_10741_length_673_cov_1.650000_g10450_i0	PRJNA827593	10741	673	1.65	11.1045	Diversispora eburnea	1213867	Fungi	Fungi	86.3	2.23e-15	NR	CAG8463697.1	1213867	g10450	i0	34	1.54234769687964	156	99	69.5	1	651	184	1035	1186	CAG8463697.1 9996_t:CDS:2 [Diversispora eburnea]	diamond	1038	86.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora eburnea
27316199	27316199	PRJNA827593_P_NODE_67123_length_242_cov_1.366864_g66824_i0	PRJNA827593	67123	242	1.366864	3.30781088	Mucoromycota	1913637	Fungi	Fungi	51.6	2.82e-5	NR	KAG9289781.1	50956	g66824	i0	44.8	5.76446280991736	67	29	83.1	2	213	13	1443	1501	KAG9289781.1 hypothetical protein G9A89_015361 [Geosiphon pyriformis]	diamond	1395	51.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Geosiphonaceae	Geosiphon	Geosiphon pyriformis
28452892	28452892	PRJNA827593_P_NODE_64306_length_246_cov_1.369942_g64007_i0	PRJNA827593	64306	246	1.369942	3.37005732	Fungi	4751	Fungi	Fungi	62.8	3.26e-9	NR	XP_052940026.1	64632	g64007	i0	41.9	12.8048780487805	74	42	90.2	1	23	244	378	450	XP_052940026.1 plasma-membrane choline transporter-domain-containing protein [Mycotypha africana]	diamond	3150	62.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mycotyphaceae	Mycotypha	Mycotypha africana
28539087	28539087	PRJNA827593_P_NODE_62347_length_249_cov_1.465909_g62048_i0	PRJNA827593	62347	249	1.465909	3.65011341	Choanephora cucurbitarum	101091	Fungi	Fungi	86.7	8.42e-18	NR	OBZ81055.1	101091	g62048	i0	100	0.493975903614458	41	0	49.4	0	109	231	339	379	OBZ81055.1 Protein FAM63A [Choanephora cucurbitarum]	diamond	123	86.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Choanephora	Choanephora cucurbitarum
29107297	29107297	PRJNA827593_P_NODE_59788_length_254_cov_2.193370_g59489_i0	PRJNA827593	59788	254	2.19337	5.5711598	Umbelopsis sp. PMI_123	1896174	Fungi	Fungi	68.2	3.68e-11	NR	KAH8552182.1	1896174	g59489	i0	48.6	2.36220472440945	70	34	80.3	1	241	38	263	332	KAH8552182.1 alcohol dehydrogenase zinc-containing protein [Umbelopsis sp. PMI_123]	diamond	600	68.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis sp. PMI_123
29612035	29612035	PRJNA827593_P_NODE_46590_length_295_cov_1.040541_g46291_i0	PRJNA827593	46590	295	1.040541	3.06959595	Gigaspora rosea	44941	Fungi	Fungi	88.2	7.27e-18	NR	RIB28540.1	44941	g46291	i0	54.8	0.945762711864407	93	36	88.5	1	261	1	437	529	RIB28540.1 P-loop containing nucleoside triphosphate hydrolase protein, partial [Gigaspora rosea]	diamond	279	88.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora rosea
30781168	30781168	PRJNA827593_P_NODE_24934_length_420_cov_2.146974_g24635_i0	PRJNA827593	24934	420	2.146974	9.0172908	Endogone sp. FLAS-F59	2012134	Fungi	Fungi	68.2	3.66e-10	NR	RUS17912.1	2340872	g24635	i0	35.5	1.54285714285714	107	44	75.7	2	324	7	524	606	RUS17912.1 hypothetical protein BC937DRAFT_89357 [Endogone sp. FLAS-F59071]	diamond	648	68.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales	Endogonaceae	Endogone	Endogone sp. FLAS-F59071
31611798	31611798	PRJNA827593_P_NODE_13996_length_581_cov_2.265748_g13701_i0	PRJNA827593	13996	581	2.265748	13.16399588	Mucoromycota	1913637	Fungi	Fungi	118	4.43e-28	NR	KAI1317593.1	1343614	g13701	i0	62.1	1.97246127366609	95	32	49.1	1	577	293	276	366	KAI1317593.1 Ethanolamine kinase 1 [Mortierella claussenii]	diamond	1146	118	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella claussenii
32181326	32181326	PRJNA827593_P_NODE_20578_length_468_cov_2.131646_g20280_i0	PRJNA827593	20578	468	2.131646	9.97610328	Eukaryota	2759	Fungi	Fungi	92.8	1.2e-19	NR	AKT93706.1	29924	g20280	i0	50	10.0448717948718	86	43	55.1	0	88	345	162	247	AKT93706.1 cytochrome c oxidase subunit 2 [Mucor lusitanicus]	diamond	4701	92.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor lusitanicus
32394135	32394135	PRJNA827593_P_NODE_38479_length_328_cov_1.380392_g38180_i0	PRJNA827593	38479	328	1.380392	4.52768576	Acaulospora morrowiae	94023	Fungi	Fungi	72.4	1.62e-12	NR	CAG8765948.1	94023	g38180	i0	40.5	1.39939024390244	84	50	76.8	0	1	252	127	210	CAG8765948.1 16271_t:CDS:2, partial [Acaulospora morrowiae]	diamond	459	72.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae	Acaulospora	Acaulospora morrowiae

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