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

11 rows where analysis = "diamond", bioproject = "PRJNA890871" 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
864557	864557	PRJNA890871_P_NODE_43781_length_276_cov_1.231527_g43646_i0	PRJNA890871	43781	276	1.231527	3.39901452	Mucor plumbeus	97098	Fungi	Fungi	147	1.34e-38	NR	KAG2193467.1	97098	g43646	i0	77.2	5	92	21	100	0	276	1	123	214	KAG2193467.1 hypothetical protein INT46_007735, partial [Mucor plumbeus]	diamond	1380	147	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor plumbeus
27505947	27505947	PRJNA890871_P_NODE_41243_length_280_cov_1.425121_g41108_i0	PRJNA890871	41243	280	1.425121	3.9903388	Mucorales	4827	Fungi	Fungi	150	8.14e-43	NR	CEP08802.1	35722	g41108	i0	78	11.7	91	20	97.5	0	273	1	130	220	CEP08802.1 hypothetical protein [Parasitella parasitica]	diamond	3276	151	0.993377483443709	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Parasitella	Parasitella parasitica
28097786	28097786	PRJNA890871_P_NODE_65645_length_250_cov_0.870056_g65510_i0	PRJNA890871	65645	250	0.870056	2.17514	Mucor plumbeus	97098	Fungi	Fungi	145	8.71e-40	NR	KAG2203086.1	97098	g65510	i0	89	0.984	82	9	98.4	0	248	3	136	217	KAG2203086.1 hypothetical protein INT46_005043 [Mucor plumbeus]	diamond	246	145	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor plumbeus
30087072	30087072	PRJNA890871_P_NODE_78052_length_244_cov_1.736842_g77917_i0	PRJNA890871	78052	244	1.736842	4.23789448	Mucor plumbeus	97098	Fungi	Fungi	160	1.2999999999999996e-43	NR	KAG2192522.1	97098	g77917	i0	98.8	0.983606557377049	80	1	98.4	0	242	3	408	487	KAG2192522.1 hypothetical protein INT46_004632 [Mucor plumbeus]	diamond	240	160	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor plumbeus
30126352	30126352	PRJNA890871_P_NODE_84052_length_242_cov_0.911243_g83917_i0	PRJNA890871	84052	242	0.911243	2.20520806	Mucor	4830	Fungi	Fungi	149	3.2999999999999987e-41	NR	KAF1803436.1	29924	g83917	i0	88.8	1.98347107438017	80	9	99.2	0	241	2	47	126	KAF1803436.1 auxin efflux carrier [Mucor lusitanicus]	diamond	480	150	0.993333333333333	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor lusitanicus
30245284	30245284	PRJNA890871_P_NODE_2612_length_988_cov_6.893989_g2491_i0	PRJNA890871	2612	988	6.893989	68.11261132	Gigaspora margarita	4874	Fungi	Fungi	47.8	0.049	NR	KAF0406850.1	4874	g2491	i0	28.7	0.497975708502024	164	100	48.3	6	587	111	228	379	KAF0406850.1 hypothetical protein F8M41_008815 [Gigaspora margarita]	diamond	492	47.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
30371934	30371934	PRJNA890871_P_NODE_82172_length_242_cov_3.224852_g82037_i0	PRJNA890871	82172	242	3.224852	7.80414184	Parasitella parasitica	35722	Fungi	Fungi	136	4.87e-35	NR	CEP08728.1	35722	g82037	i0	80	1.98347107438017	80	16	99.2	0	241	2	25	104	CEP08728.1 hypothetical protein [Parasitella parasitica]	diamond	480	136	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Parasitella	Parasitella parasitica
30750733	30750733	PRJNA890871_P_NODE_53914_length_261_cov_2.138298_g53779_i0	PRJNA890871	53914	261	2.138298	5.58095778	Rhizophagus irregularis DAOM 197198w	1432141	Fungi	Fungi	56.6	6.99e-8	NR	EXX78851.1	1432141	g53779	i0	68.8	0.367816091954023	32	10	36.8	0	2	97	91	122	EXX78851.1 hypothetical protein RirG_011270 [Rhizophagus irregularis DAOM 197198w]	diamond	96	56.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
31066807	31066807	PRJNA890871_P_NODE_2115_length_1169_cov_4.135036_g1999_i0	PRJNA890871	2115	1169	4.135036	48.33857084	Rhizophagus irregularis	588596	Fungi	Fungi	75.9	2.84e-11	NR	PKY22945.1	588596	g1999	i0	42.9	0.269461077844311	105	57	26.2	1	405	100	100	204	PKY22945.1 HCP-like protein [Rhizophagus irregularis]	diamond	315	75.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
31295648	31295648	PRJNA890871_P_NODE_87435_length_239_cov_2.765060_g87300_i0	PRJNA890871	87435	239	2.76506	6.6084934	Fungi	4751	Fungi	Fungi	56.6	4.36e-7	NR	KAI8074382.1	101105	g87300	i0	88.5	1.63179916317992	26	3	32.6	0	8	85	347	372	KAI8074382.1 PQQ repeat-containing enzyme [Gongronella butleri]	diamond	390	57	0.992982456140351	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Gongronella	Gongronella butleri
31888723	31888723	PRJNA890871_P_NODE_58057_length_256_cov_1.683060_g57922_i0	PRJNA890871	58057	256	1.68306	4.3086336	Mucor plumbeus	97098	Fungi	Fungi	112	1.08e-27	NR	KAG2193113.1	97098	g57922	i0	96.9	0.75	64	2	75	0	214	23	1	64	KAG2193113.1 hypothetical protein INT46_009799 [Mucor plumbeus]	diamond	192	112	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);;