metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1218818" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1218818" 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
27420610	27420610	PRJNA1218818_P_NODE_29363_length_231_cov_3.354430_g29296_i0	PRJNA1218818	29363	231	3.35443	7.7487333	Phycomyces nitens	269771	Fungi	Fungi	111	1.46e-29	NR	KAI9010348.1	269771	g29296	i0	76	3.8961038961039	75	18	97.4	0	225	1	1	75	KAI9010348.1 50S ribosomal protein L32 [Phycomyces nitens]	diamond	900	111	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces nitens
27767904	27767904	PRJNA1218818_P_NODE_28264_length_242_cov_0.911243_g28197_i0	PRJNA1218818	28264	242	0.911243	2.20520806	Paraglomus occultum	144539	Fungi	Fungi	125	4.86e-35	NR	CAG8510315.1	144539	g28197	i0	68.8	1.98347107438017	80	25	99.2	0	2	241	17	96	CAG8510315.1 8229_t:CDS:2 [Paraglomus occultum]	diamond	480	125	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales	Paraglomeraceae	Paraglomus	Paraglomus occultum
31007797	31007797	PRJNA1218818_P_NODE_24954_length_249_cov_0.875000_g24887_i0	PRJNA1218818	24954	249	0.875	2.17875	Fungi	4751	Fungi	Fungi	75.5	8.48e-14	NR	CAG8703811.1	94023	g24887	i0	49.4	3.26506024096386	83	36	92.8	1	249	19	174	256	CAG8703811.1 4893_t:CDS:2 [Acaulospora morrowiae]	diamond	813	75.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae	Acaulospora	Acaulospora morrowiae
31039673	31039673	PRJNA1218818_P_NODE_28995_length_241_cov_0.916667_g28928_i0	PRJNA1218818	28995	241	0.916667	2.20916747	Fungi	4751	Fungi	Fungi	64.3	9.27e-10	NR	KAG2205482.1	97098	g28928	i0	37.3	10.0580912863071	83	48	98.3	2	238	2	954	1036	KAG2205482.1 hypothetical protein INT46_007474 [Mucor plumbeus]	diamond	2424	64.7	0.993817619783617	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor plumbeus
32254411	32254411	PRJNA1218818_P_NODE_28718_length_241_cov_1.416667_g28651_i0	PRJNA1218818	28718	241	1.416667	3.41416747	Modicella reniformis	1440133	Fungi	Fungi	71.6	3.65e-13	NR	KAG0004842.1	1440133	g28651	i0	75	0.547717842323652	44	11	54.8	0	136	5	1	44	KAG0004842.1 H(+)-transporting V0 sector ATPase subunit c [Modicella reniformis]	diamond	132	71.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Modicella	Modicella reniformis

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