metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA558770" 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
7506662	7506662	PRJNA558770_P_NODE_124066_length_234_cov_8.733668_g122061_i0	PRJNA558770	124066	234	8.733668	20.43678312	Mucor	4830	Fungi	Fungi	86.3	6.74e-18	NR	GAN02719.1	91626	g122061	i0	61.5	2	78	23	100	1	1	234	75	145	GAN02719.1 glyceraldehyde-3-phosphate dehydrogenase [Mucor ambiguus]	diamond	468	86.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor ambiguus
26871833	26871833	PRJNA558770_P_NODE_256481_length_234_cov_2.170854_g254476_i0	PRJNA558770	256481	234	2.170854	5.07979836	Mucoraceae	34489	Fungi	Fungi	76.3	5.13e-14	NR	KAL0139421.1	29924	g254476	i0	53.2	4.93589743589744	77	14	98.7	1	2	232	792	846	KAL0139421.1 hypothetical protein V8B55DRAFT_1565542 [Mucor lusitanicus]	diamond	1155	76.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor lusitanicus
27110346	27110346	PRJNA558770_P_NODE_48002_length_309_cov_4.857664_g46000_i0	PRJNA558770	48002	309	4.857664	15.01018176	Rhizopus delemar	936053	Fungi	Fungi	50.1	2.25e-4	NR	KAG1472402.1	936053	g46000	i0	77.8	0.825242718446602	27	6	26.2	0	85	5	1326	1352	KAG1472402.1 hypothetical protein G6F56_001560 [Rhizopus delemar]	diamond	255	50.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
27331968	27331968	PRJNA558770_P_NODE_272243_length_234_cov_1.864322_g270238_i0	PRJNA558770	272243	234	1.864322	4.36251348	Syncephalastrum racemosum	13706	Fungi	Fungi	65.9	3.03e-11	NR	ORZ01004.1	13706	g270238	i0	51.3	1	78	28	87.2	1	31	234	1	78	ORZ01004.1 HSP20-like chaperone [Syncephalastrum racemosum]	diamond	234	65.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
27346036	27346036	PRJNA558770_P_NODE_284323_length_234_cov_1.668342_g282318_i0	PRJNA558770	284323	234	1.668342	3.90392028	Mucorales	4827	Fungi	Fungi	57.8	8.47e-8	NR	SAM08510.1	4829	g282318	i0	100	16	24	0	30.8	0	161	232	88	111	SAM08510.1 hypothetical protein [Absidia glauca]	diamond	3744	57.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca
28152932	28152932	PRJNA558770_P_NODE_151085_length_234_cov_6.341709_g149080_i0	PRJNA558770	151085	234	6.341709	14.83959906	Rhizophagus irregularis DAOM 197198w	1432141	Fungi	Fungi	43.1	0.00878	NR	EXX73766.1	1432141	g149080	i0	51.4	0.448717948717949	35	17	44.9	0	125	229	10	44	EXX73766.1 Skt5p [Rhizophagus irregularis DAOM 197198w]	diamond	105	43.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
28405393	28405393	PRJNA558770_P_NODE_273846_length_234_cov_1.834171_g271841_i0	PRJNA558770	273846	234	1.834171	4.29196014	Syncephalastrum racemosum	13706	Fungi	Fungi	49.7	1.06e-4	NR	ORZ02779.1	13706	g271841	i0	100	0.307692307692308	24	0	30.8	0	2	73	64	87	ORZ02779.1 hypothetical protein BCR43DRAFT_482145 [Syncephalastrum racemosum]	diamond	72	49.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
28784083	28784083	PRJNA558770_P_NODE_294267_length_234_cov_1.427136_g292262_i0	PRJNA558770	294267	234	1.427136	3.33949824	Apophysomyces sp. BC1	2184030	Fungi	Fungi	52.8	4.75e-7	NR	KAG0161832.1	2184030	g292262	i0	100	0.320512820512821	25	0	32.1	0	75	1	11	35	KAG0161832.1 hypothetical protein DFQ30_005345, partial [Apophysomyces sp. BC1015]	diamond	75	52.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Apophysomyces	Apophysomyces sp. BC1015
31152728	31152728	PRJNA558770_P_NODE_160655_length_234_cov_5.718593_g158650_i0	PRJNA558770	160655	234	5.718593	13.38150762	Absidia repens	90262	Fungi	Fungi	74.7	1.82e-13	NR	ORZ09197.1	90262	g158650	i0	58.7	0.961538461538462	75	20	96.2	1	7	231	428	491	ORZ09197.1 hypothetical protein BCR42DRAFT_381864 [Absidia repens]	diamond	225	74.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia repens
31374627	31374627	PRJNA558770_P_NODE_192116_length_234_cov_4.100503_g190111_i0	PRJNA558770	192116	234	4.100503	9.59517702	Mucor plumbeus	97098	Fungi	Fungi	48.5	5.75e-5	NR	KAG2206784.1	97098	g190111	i0	100	0.294871794871795	23	0	29.5	0	230	162	8	30	KAG2206784.1 hypothetical protein INT46_008652 [Mucor plumbeus]	diamond	69	48.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor plumbeus
31785488	31785488	PRJNA558770_P_NODE_241097_length_234_cov_2.512563_g239092_i0	PRJNA558770	241097	234	2.512563	5.87939742	Blakeslea trispora	4850	Fungi	Fungi	52.8	7.25e-6	NR	KAI8387389.1	4850	g239092	i0	44.3	1.12820512820513	88	38	98.7	1	232	2	124	211	KAI8387389.1 PIN domain-like protein [Blakeslea trispora]	diamond	264	52.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Blakeslea	Blakeslea trispora
32228830	32228830	PRJNA558770_P_NODE_288298_length_234_cov_1.603015_g286293_i0	PRJNA558770	288298	234	1.603015	3.7510551	Mucor plumbeus	97098	Fungi	Fungi	55.8	7.63e-7	NR	KAG2213340.1	97098	g286293	i0	100	0.307692307692308	24	0	30.8	0	3	74	269	292	KAG2213340.1 hypothetical protein INT46_007199 [Mucor plumbeus]	diamond	72	55.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor plumbeus

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