metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1240804" 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
23299457	23299457	PRJNA1240804_P_NODE_118899_length_167_cov_0.881356_g118533_i0	PRJNA1240804	118899	167	0.881356	1.47186452	Fungi	4751	Fungi	Fungi	62.8	1.13e-9	NR	XP_018288356.1	763407	g118533	i0	64.7	3.34131736526946	51	16	88	1	11	157	218	268	XP_018288356.1 hypothetical protein PHYBLDRAFT_177979 [Phycomyces blakesleeanus NRRL 1555(-)]	diamond	558	63.2	0.993670886075949	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
26630372	26630372	PRJNA1240804_P_NODE_44521_length_228_cov_1.726257_g44155_i0	PRJNA1240804	44521	228	1.726257	3.93586596	Calcarisporiella thermophila	911321	Fungi	Fungi	56.2	5.16e-7	NR	XP_069256330.1	911321	g44155	i0	59.1	0.578947368421053	44	18	57.9	0	8	139	376	419	XP_069256330.1 uncharacterized protein VTP21DRAFT_4722 [Calcarisporiella thermophila]	diamond	132	56.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
27249687	27249687	PRJNA1240804_P_NODE_115023_length_168_cov_0.873950_g114657_i0	PRJNA1240804	115023	168	0.87395	1.468236	Mucorales	4827	Fungi	Fungi	65.5	1.25e-10	NR	ORY97359.1	13706	g114657	i0	83.3	3.80357142857143	36	6	64.3	0	60	167	193	228	ORY97359.1 hypothetical protein BCR43DRAFT_438612 [Syncephalastrum racemosum]	diamond	639	65.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
27281429	27281429	PRJNA1240804_P_NODE_37883_length_243_cov_0.989691_g37517_i0	PRJNA1240804	37883	243	0.989691	2.40494913	Fungi	4751	Fungi	Fungi	49.7	1.33e-4	NR	CAG8653703.1	27376	g37517	i0	43.2	8.18518518518519	74	38	91.4	1	18	239	821	890	CAG8653703.1 2196_t:CDS:2, partial [Acaulospora colombiana]	diamond	1989	50.1	0.992015968063872	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae	Acaulospora	Acaulospora colombiana
27344742	27344742	PRJNA1240804_P_NODE_126863_length_166_cov_0.888889_g126497_i0	PRJNA1240804	126863	166	0.888889	1.47555574	Rhizopus	4842	Fungi	Fungi	63.9	4.25e-10	NR	KAG1171395.1	58291	g126497	i0	60	2.71084337349398	50	20	90.4	0	152	3	565	614	KAG1171395.1 hypothetical protein G6F71_006995 [Rhizopus microsporus]	diamond	450	63.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
28955103	28955103	PRJNA1240804_P_NODE_76188_length_189_cov_1.371429_g75822_i0	PRJNA1240804	76188	189	1.371429	2.59200081	Fungi	4751	Fungi	Fungi	47.4	4.18e-4	NR	KAI9267914.1	60185	g75822	i0	51.9	3.33333333333333	52	21	76.2	1	45	188	7	58	KAI9267914.1 hypothetical protein BDA99DRAFT_504345 [Phascolomyces articulosus]	diamond	630	47.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Phascolomyces	Phascolomyces articulosus
29757509	29757509	PRJNA1240804_P_NODE_6751_length_477_cov_14.105140_g6391_i0	PRJNA1240804	6751	477	14.10514	67.2815178	Diversispora epigaea	1348612	Fungi	Fungi	51.2	4.34e-5	NR	RHZ86459.1	1348612	g6391	i0	31.7	0.874213836477987	139	49	87.4	3	21	437	7	99	RHZ86459.1 hypothetical protein Glove_50g81 [Diversispora epigaea]	diamond	417	51.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora epigaea
30976477	30976477	PRJNA1240804_P_NODE_140634_length_163_cov_1.710526_g140268_i0	PRJNA1240804	140634	163	1.710526	2.78815738	Fungi	4751	Fungi	Fungi	45.1	0.00195	NR	CAG8631081.1	144539	g140268	i0	56.8	1.21472392638037	37	14	68.1	1	159	49	148	182	CAG8631081.1 8882_t:CDS:1, partial [Paraglomus occultum]	diamond	198	45.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales	Paraglomeraceae	Paraglomus	Paraglomus occultum
31482437	31482437	PRJNA1240804_P_NODE_146936_length_162_cov_1.362832_g146570_i0	PRJNA1240804	146936	162	1.362832	2.20778784	root	1	Root_unresolved	Root_unresolved	94	5.0499999999999987e-23	NR	KAG0161761.1	2184030	g146570	i0	95.9	3.62962962962963	49	2	90.7	0	2	148	7	55	KAG0161761.1 hypothetical protein DFQ30_005774, partial [Apophysomyces sp. BC1015]	diamond	588	94.4	0.995762711864407	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Apophysomyces	Apophysomyces sp. BC1015
32019895	32019895	PRJNA1240804_P_NODE_128238_length_166_cov_0.888889_g127872_i0	PRJNA1240804	128238	166	0.888889	1.47555574	Fungi	4751	Fungi	Fungi	54.3	7.39e-7	NR	KAF9289019.1	64518	g127872	i0	54	7.06626506024096	50	21	86.7	1	16	159	84	133	KAF9289019.1 hypothetical protein BGZ68_010174 [Mortierella alpina]	diamond	1173	54.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella alpina
32304945	32304945	PRJNA1240804_P_NODE_110939_length_169_cov_0.866667_g110573_i0	PRJNA1240804	110939	169	0.866667	1.46466723	Mucorales	4827	Fungi	Fungi	42	0.0264	NR	SAM07304.1	4829	g110573	i0	41.8	2.75147928994083	55	24	97.6	2	165	1	12	58	SAM07304.1 hypothetical protein [Absidia glauca]	diamond	465	42.4	0.990566037735849	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca

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