metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA685060" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA685060" and tax_phylum = "Ascomycota"

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
27461576	27461576	PRJNA685060_P_NODE_2963_length_575_cov_2.428287_g2873_i0	PRJNA685060	2963	575	2.428287	13.96265025	Tuber magnatum	42249	Fungi	Fungi	46.6	0.0157	NR	PWW75267.1	42249	g2873	i0	46	0.474782608695652	50	21	23	1	333	464	147	196	PWW75267.1 hypothetical protein C7212DRAFT_280944 [Tuber magnatum]	diamond	273	46.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pezizomycetes	Pezizales	Tuberaceae	Tuber	Tuber magnatum
27682799	27682799	PRJNA685060_P_NODE_6244_length_382_cov_2.220065_g6154_i0	PRJNA685060	6244	382	2.220065	8.4806483	Schizosaccharomyces pombe	4896	Fungi	Fungi	82	2.38e-17	NR	NP_593558.1	4896	g6154	i0	69	1.33507853403141	58	18	45.5	0	207	380	5	62	NP_593558.1 60S ribosomal protein eL30 [Schizosaccharomyces pombe]	diamond	510	82	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Schizosaccharomycetes	Schizosaccharomycetales	Schizosaccharomycetaceae	Schizosaccharomyces	Schizosaccharomyces pombe
27745825	27745825	PRJNA685060_P_NODE_4304_length_468_cov_1.043038_g4214_i0	PRJNA685060	4304	468	1.043038	4.88141784	Physcia stellaris	116821	Fungi	Fungi	53.5	6.87e-5	NR	KAG7009130.1	116821	g4214	i0	38.3	0.384615384615385	60	37	38.5	0	310	131	1062	1121	KAG7009130.1 hypothetical protein G7Y79_00003g009980 [Physcia stellaris]	diamond	180	53.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Caliciales	Physciaceae	Physcia	Physcia stellaris
28692984	28692984	PRJNA685060_P_NODE_11687_length_273_cov_1.540000_g11597_i0	PRJNA685060	11687	273	1.54	4.2042	Brettanomyces nanus	13502	Fungi	Fungi	88.6	3.46e-18	NR	XP_038778999.1	13502	g11597	i0	56.5	7.34065934065934	69	30	75.8	0	233	27	50	118	XP_038778999.1 histone deacetylase [Brettanomyces nanus]	diamond	2004	88.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Brettanomyces	Brettanomyces nanus
29702774	29702774	PRJNA685060_P_NODE_10450_length_291_cov_1.577982_g10360_i0	PRJNA685060	10450	291	1.577982	4.59192762	Viridothelium virens	1048519	Fungi	Fungi	47.4	0.00145	NR	KAF2233318.1	1048519	g10360	i0	39.7	1.16494845360825	58	33	59.8	2	174	1	9	64	KAF2233318.1 casein kinase 1, delta [Viridothelium virens]	diamond	339	47.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Trypetheliales	Trypetheliaceae	Viridothelium	Viridothelium virens
29702785	29702785	PRJNA685060_P_NODE_3630_length_514_cov_3.111111_g3540_i0	PRJNA685060	3630	514	3.111111	15.99111054	Candidozyma haemuli var. vulneris	1231523	Fungi	Fungi	48.1	3.52e-4	NR	KAF3991661.1	1231523	g3540	i0	47.5	0.752918287937743	59	30	34.4	1	218	394	9	66	KAF3991661.1 hypothetical protein FT663_02638 [Candidozyma haemuli var. vulneris]	diamond	387	48.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Candidozyma	Candidozyma haemuli
29861064	29861064	PRJNA685060_P_NODE_9831_length_302_cov_1.008734_g9741_i0	PRJNA685060	9831	302	1.008734	3.04637668	Ogataea philodendri	1378263	Fungi	Fungi	58.2	2.88e-7	NR	XP_046064272.1	1378263	g9741	i0	33.7	0.884105960264901	89	47	81.5	2	302	57	197	280	XP_046064272.1 uncharacterized protein OGAPHI_000615 [Ogataea philodendri]	diamond	267	58.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Ogataea	Ogataea philodendri
29967500	29967500	PRJNA685060_P_NODE_14071_length_249_cov_1.750000_g13981_i0	PRJNA685060	14071	249	1.75	4.3575	Ascomycota	4890	Fungi	Fungi	85.5	3.53e-17	NR	XP_017989649.1	45286	g13981	i0	54.9	3.91566265060241	82	33	94	2	12	245	310	391	XP_017989649.1 histone acetyltransferase [Eremothecium sinecaudum]	diamond	975	85.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Eremothecium	Eremothecium sinecaudum
30019196	30019196	PRJNA685060_P_NODE_15051_length_247_cov_0.885057_g14961_i0	PRJNA685060	15051	247	0.885057	2.18609079	Pseudocercospora fuligena	685502	Fungi	Fungi	62.8	3.23e-9	NR	KAF7190355.1	685502	g14961	i0	39.8	1.76113360323887	83	47	97.2	1	245	6	214	296	KAF7190355.1 Ankyrin-1 [Pseudocercospora fuligena]	diamond	435	62.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Pseudocercospora	Pseudocercospora fuligena
30366976	30366976	PRJNA685060_P_NODE_11992_length_269_cov_1.260204_g11902_i0	PRJNA685060	11992	269	1.260204	3.38994876	Candida jiufengensis	497108	Fungi	Fungi	117	2.65e-28	NR	XP_051621114.1	497108	g11902	i0	64	0.992565055762082	89	32	99.3	0	2	268	178	266	XP_051621114.1 CCT6 [Candida jiufengensis]	diamond	267	117	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida jiufengensis
30473072	30473072	PRJNA685060_P_NODE_16653_length_243_cov_0.905882_g16563_i0	PRJNA685060	16653	243	0.905882	2.20129326	Onygenales	33183	Fungi	Fungi	142	2.52e-37	NR	KMU73930.1	454286	g16563	i0	86.4	6	81	11	100	0	243	1	254	334	KMU73930.1 DNA-directed RNA polymerase 3 subunit RPC2 [Coccidioides immitis RMSCC 3703]	diamond	1458	143	0.993006993006993	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Onygenales	Onygenaceae	Coccidioides	Coccidioides immitis
30935379	30935379	PRJNA685060_P_NODE_10354_length_293_cov_1.304545_g10264_i0	PRJNA685060	10354	293	1.304545	3.82231685	Tortispora caseinolytica NRRL Y-17796	767744	Fungi	Fungi	47	0.0018	NR	ODV88374.1	767744	g10264	i0	36.7	0.921501706484642	90	50	89.1	2	292	32	160	245	ODV88374.1 hypothetical protein CANCADRAFT_32992 [Tortispora caseinolytica NRRL Y-17796]	diamond	270	47	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Trigonopsidomycetes	Trigonopsidales	Trigonopsidaceae	Tortispora	Tortispora caseinolytica
31041995	31041995	PRJNA685060_P_NODE_12975_length_255_cov_2.115385_g12885_i0	PRJNA685060	12975	255	2.115385	5.39423175	Fungi	4751	Fungi	Fungi	144	1.2e-37	NR	QSL66761.1	38082	g12885	i0	77.6	59.8941176470588	85	19	100	0	255	1	970	1054	QSL66761.1 hypothetical protein MERGE_001147 [Pneumocystis wakefieldiae]	diamond	15273	145	0.993103448275862	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pneumocystomycetes	Pneumocystales	Pneumocystaceae	Pneumocystis	Pneumocystis wakefieldiae
32548588	32548588	PRJNA685060_P_NODE_14639_length_248_cov_0.880000_g14549_i0	PRJNA685060	14639	248	0.88	2.1824	Flavoplaca oasis	1301336	Fungi	Fungi	43.1	0.03	NR	KAI4274636.1	1301336	g14549	i0	37	0.653225806451613	54	27	65.3	1	86	247	1485	1531	KAI4274636.1 MAG: hypothetical protein LQ337_003798 [Flavoplaca oasis]	diamond	162	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Teloschistales	Teloschistaceae	Flavoplaca	Flavoplaca oasis

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