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

12 rows where analysis = "diamond", bioproject = "PRJNA1044115" and tax_kingdom = "Fungi"

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
171290	171290	PRJNA1044115_P_NODE_20001_length_326_cov_1.545455_g19817_i0	PRJNA1044115	20001	326	1.545455	5.0381833	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	90.9	5.95e-21	NR	KAH9251936.1	1357716	g19817	i0	82.1	0.515337423312883	56	10	51.5	0	324	157	20	75	KAH9251936.1 hypothetical protein BASA81_010140 [Batrachochytrium salamandrivorans]	diamond	168	90.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
14200226	14200226	PRJNA1044115_P_NODE_38332_length_247_cov_0.896552_g38148_i0	PRJNA1044115	38332	247	0.896552	2.21448344	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	154	5.88e-42	NR	KAH9251926.1	1357716	g38148	i0	92.7	0.995951417004049	82	6	99.6	0	246	1	458	539	KAH9251926.1 hypothetical protein BASA81_010130 [Batrachochytrium salamandrivorans]	diamond	246	154	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
27090469	27090469	PRJNA1044115_P_NODE_32482_length_258_cov_2.183784_g32298_i0	PRJNA1044115	32482	258	2.183784	5.63416272	Candida	5475	Fungi	Fungi	78.6	3.33e-17	NR	KHC45672.1	1094986	g32298	i0	66.7	1.19767441860465	66	13	76.7	2	19	216	1	57	KHC45672.1 hypothetical protein MEW_05321, partial [Candida albicans P60002]	diamond	309	78.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida albicans
27509363	27509363	PRJNA1044115_P_NODE_35643_length_251_cov_0.876404_g35459_i0	PRJNA1044115	35643	251	0.876404	2.19977404	Poronia punctata	101475	Fungi	Fungi	43.1	0.0293	NR	KAI1813744.1	101475	g35459	i0	36	0.597609561752988	50	32	59.8	0	225	76	161	210	KAI1813744.1 DUF1766-domain-containing protein [Poronia punctata]	diamond	150	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Xylariaceae	Poronia	Poronia punctata
28930063	28930063	PRJNA1044115_P_NODE_31208_length_263_cov_2.157895_g31024_i0	PRJNA1044115	31208	263	2.157895	5.67526385	Coemansia sp. S3946	2761407	Fungi	Fungi	47.8	5.9e-5	NR	KAJ2026080.1	2761407	g31024	i0	52.6	1.32319391634981	38	14	38.8	1	1	102	2	39	KAJ2026080.1 hypothetical protein H4S03_008706, partial [Coemansia sp. S3946]	diamond	348	47.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. S3946
29277170	29277170	PRJNA1044115_P_NODE_21789_length_311_cov_18.718487_g21605_i0	PRJNA1044115	21789	311	18.718487	58.21449457	Zygosaccharomyces bailii ISA13	4954	Fungi	Fungi	61.6	1.06e-9	NR	CDH16361.1	1355161	g21605	i0	51.4	2.02572347266881	70	24	67.5	1	310	101	7	66	CDH16361.1 probable protein TAR1 [Zygosaccharomyces bailii ISA1307]	diamond	630	61.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Zygosaccharomyces	Zygosaccharomyces bailii
29909009	29909009	PRJNA1044115_P_NODE_32551_length_258_cov_1.686486_g32367_i0	PRJNA1044115	32551	258	1.686486	4.35113388	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	69.3	1.92e-11	NR	KAH9260109.1	1357716	g32367	i0	55.7	0.709302325581395	61	27	70.9	0	24	206	168	228	KAH9260109.1 hypothetical protein BASA81_001881 [Batrachochytrium salamandrivorans]	diamond	183	69.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
30888340	30888340	PRJNA1044115_P_NODE_37714_length_248_cov_0.891429_g37530_i0	PRJNA1044115	37714	248	0.891429	2.21074392	Quaeritorhiza haematococci	2654861	Fungi	Fungi	75.5	1.17e-13	NR	KAJ3091114.1	2654861	g37530	i0	54.1	2.74596774193548	74	29	89.5	2	16	237	657	725	KAJ3091114.1 Ca(2+)-dependent cysteine protease [Quaeritorhiza haematococci]	diamond	681	75.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes		Quaeritorhizaceae	Quaeritorhiza	Quaeritorhiza haematococci
31014680	31014680	PRJNA1044115_P_NODE_30075_length_268_cov_1.420513_g29891_i0	PRJNA1044115	30075	268	1.420513	3.80697484	Funneliformis mosseae	27381	Fungi	Fungi	124	7.97e-31	NR	CAG8454506.1	27381	g29891	i0	64.8	10.6007462686567	88	31	98.5	0	266	3	43	130	CAG8454506.1 15875_t:CDS:2 [Funneliformis mosseae]	diamond	2841	124	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Funneliformis	Funneliformis mosseae
31584017	31584017	PRJNA1044115_P_NODE_37836_length_247_cov_2.367816_g37652_i0	PRJNA1044115	37836	247	2.367816	5.84850552	Candida albicans SC5314	237561	Fungi	Fungi	167	1.55e-51	NR	KHC78117.1	237561	g37652	i0	100	0.935222672064777	77	0	93.5	0	17	247	1	77	KHC78117.1 hypothetical protein W5Q_03473 [Candida albicans SC5314]	diamond	231	167	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida albicans
32343368	32343368	PRJNA1044115_P_NODE_40279_length_244_cov_0.912281_g40095_i0	PRJNA1044115	40279	244	0.912281	2.22596564	Watsoniomyces obsoletus	2796175	Fungi	Fungi	42.7	0.0365	NR	KAI9887890.1	2796175	g40095	i0	42	0.614754098360656	50	26	61.5	1	3	152	82	128	KAI9887890.1 MAG: hypothetical protein M1823_000278 [Watsoniomyces obsoletus]	diamond	150	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lichinomycetes	Lichinales	Porocyphaceae	Watsoniomyces	Watsoniomyces obsoletus
32501546	32501546	PRJNA1044115_P_NODE_41979_length_242_cov_0.923077_g41795_i0	PRJNA1044115	41979	242	0.923077	2.23384634	Calocera cornea HHB12733	1353952	Fungi	Fungi	42.4	0.0477	NR	KZT60001.1	1353952	g41795	i0	35.7	0.694214876033058	56	32	64.5	2	180	25	260	315	KZT60001.1 hypothetical protein CALCODRAFT_507165 [Calocera cornea HHB12733]	diamond	168	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Dacrymycetes	Dacrymycetales	Dacrymycetaceae	Calocera	Calocera cornea

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