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

14 rows where analysis = "diamond", bioproject = "PRJDB14274" 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
26588923	26588923	PRJDB14274_S_NODE_6701_length_244_cov_1.683060_g6623_i0	PRJDB14274	6701	244	1.68306	4.1066664	Pyrenochaeta sp. DS3sAY3a	765867	Fungi	Fungi	42.7	0.0383	NR	OAL43103.1	765867	g6623	i0	47.8	0.565573770491803	46	24	56.6	0	162	25	188	233	OAL43103.1 hypothetical protein IQ07DRAFT_637261 [Pyrenochaeta sp. DS3sAY3a]	diamond	138	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Cucurbitariaceae	Pyrenochaeta	Pyrenochaeta sp. DS3sAY3a
26588924	26588924	PRJDB14274_S_NODE_6961_length_240_cov_1.418994_g6883_i0	PRJDB14274	6961	240	1.418994	3.4055856	Friedmanniomyces endolithicus	329885	Fungi	Fungi	80.5	6.07e-16	NR	KAK0296463.1	329885	g6883	i0	56.8	1.85	74	31	91.3	1	219	1	35	108	KAK0296463.1 Thymidylate kinase [Friedmanniomyces endolithicus]	diamond	444	80.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Friedmanniomyces	Friedmanniomyces endolithicus
27063997	27063997	PRJDB14274_S_NODE_8082_length_223_cov_2.006173_g8004_i0	PRJDB14274	8082	223	2.006173	4.47376579	Penicillium manginii	203109	Fungi	Fungi	46.2	0.00169	NR	XP_056959759.1	203109	g8004	i0	39.3	0.820627802690583	61	32	82.1	1	20	202	37	92	XP_056959759.1 Chromatin modification-related protein eaf3 [Penicillium manginii]	diamond	183	46.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium manginii
28321378	28321378	PRJDB14274_S_NODE_4346_length_296_cov_1.859574_g4268_i0	PRJDB14274	4346	296	1.859574	5.50433904	Fungi	4751	Fungi	Fungi	102	7.559999999999999e-23	NR	ONH67940.1	36022	g4268	i0	45.7	10.4594594594595	94	50	95.3	1	9	290	143	235	ONH67940.1 hypothetical protein BON22_2002 [Cyberlindnera fabianii]	diamond	3096	103	0.990291262135922	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Phaffomycetales	Phaffomycetaceae	Cyberlindnera	Cyberlindnera fabianii
29110911	29110911	PRJDB14274_S_NODE_5688_length_263_cov_1.287129_g5610_i0	PRJDB14274	5688	263	1.287129	3.38514927	Ascomycota	4890	Fungi	Fungi	46.6	0.00215	NR	KAI1909061.1	1387563	g5610	i0	30.4	2.34980988593156	79	54	90.1	1	262	26	96	173	KAI1909061.1 eukaryotic translation initiation factor 2-alpha kinase [Ophidiomyces ophidiicola]	diamond	618	46.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Onygenales	Onygenaceae	Ophidiomyces	Ophidiomyces ophidiicola
29174109	29174109	PRJDB14274_S_NODE_10129_length_203_cov_0.915493_g10051_i0	PRJDB14274	10129	203	0.915493	1.85845079	Ascomycota	4890	Fungi	Fungi	53.9	2.55e-6	NR	KAJ9228877.1	264951	g10051	i0	41.7	1.77339901477833	60	35	88.7	0	188	9	955	1014	KAJ9228877.1 hypothetical protein DTO166G5_8277 [Paecilomyces variotii]	diamond	360	53.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Thermoascaceae	Paecilomyces	Paecilomyces variotii
29906235	29906235	PRJDB14274_S_NODE_8571_length_217_cov_1.102564_g8493_i0	PRJDB14274	8571	217	1.102564	2.39256388	Clonostachys rosea f. rosea IK726	1349383	Fungi	Fungi	41.2	0.0475	NR	CAG9942619.1	1349383	g8493	i0	38.5	0.71889400921659	52	32	71.9	0	169	14	86	137	CAG9942619.1 unnamed protein product [Clonostachys rosea f. rosea IK726]	diamond	156	41.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Bionectriaceae	Clonostachys	Clonostachys rosea
30026665	30026665	PRJDB14274_S_NODE_1511_length_496_cov_2.147126_g1434_i0	PRJDB14274	1511	496	2.147126	10.64974496	Ascomycota	4890	Fungi	Fungi	47.8	8.32e-4	NR	KAJ6259137.1	74499	g1434	i0	43.5	1.29435483870968	85	43	49.6	2	127	372	2	84	KAJ6259137.1 putative 26S proteasome complex subunit sem-1 [Drechslerella dactyloides]	diamond	642	48.1	0.993762993762994	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Drechslerella	Drechslerella dactyloides
30658448	30658448	PRJDB14274_S_NODE_9853_length_205_cov_0.902778_g9775_i0	PRJDB14274	9853	205	0.902778	1.8506949	Eurotiales	5042	Fungi	Fungi	57	2.16e-7	NR	KAF3398920.1	128442	g9775	i0	49.2	1.84390243902439	65	31	95.1	1	5	199	1025	1087	KAF3398920.1 Ankyrin-3 [Talaromyces pinophilus]	diamond	378	57	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Talaromyces	Talaromyces pinophilus
30822291	30822291	PRJDB14274_S_NODE_3074_length_349_cov_0.871528_g2996_i0	PRJDB14274	3074	349	0.871528	3.04163272	Hanseniaspora osmophila	56408	Fungi	Fungi	79	1.69e-14	NR	OEJ83813.1	56408	g2996	i0	54.5	0.472779369627507	55	25	47.3	0	40	204	293	347	OEJ83813.1 Inhibitor of growth protein 5 [Hanseniaspora osmophila]	diamond	165	79	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycodales	Saccharomycodaceae	Hanseniaspora	Hanseniaspora osmophila
30948871	30948871	PRJDB14274_S_NODE_6894_length_241_cov_1.433333_g6816_i0	PRJDB14274	6894	241	1.433333	3.45433253	Babjeviella inositovora NRRL Y-12698	984486	Fungi	Fungi	43.9	0.0142	NR	XP_018982890.1	984486	g6816	i0	44.2	1.46887966804979	52	29	64.7	0	220	65	107	158	XP_018982890.1 uncharacterized protein BABINDRAFT_163300 [Babjeviella inositovora NRRL Y-12698]	diamond	354	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales		Babjeviella	Babjeviella inositovora
32303082	32303082	PRJDB14274_S_NODE_9599_length_207_cov_0.890411_g9521_i0	PRJDB14274	9599	207	0.890411	1.84315077	Opisthokonta	33154	Fungi	Fungi	50.4	4.56e-5	NR	XP_066691355.1	335849	g9521	i0	36.2	1.85507246376812	69	32	82.6	1	7	177	213	281	XP_066691355.1 uncharacterized protein PG985_000707 [Apiospora marii]	diamond	384	50.8	0.992125984251969	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Amphisphaeriales	Apiosporaceae	Apiospora	Apiospora marii
32366249	32366249	PRJDB14274_S_NODE_10279_length_202_cov_0.921986_g10201_i0	PRJDB14274	10279	202	0.921986	1.86241172	Eukaryota	2759	Fungi	Fungi	97.8	4.99e-22	NR	XP_003645618.1	931890	g10201	i0	67.7	16.4405940594059	65	21	96.5	0	198	4	53	117	XP_003645618.1 2-(3-amino-3-carboxypropyl)histidine synthase Ecym_3310 [Eremothecium cymbalariae DBVPG#7215]	diamond	3321	98.2	0.995926680244399	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Eremothecium	Eremothecium cymbalariae
32372101	32372101	PRJDB14274_S_NODE_7659_length_229_cov_1.488095_g7581_i0	PRJDB14274	7659	229	1.488095	3.40773755	Hortaea werneckii	91943	Fungi	Fungi	41.6	0.0197	NR	KAI7590442.1	91943	g7581	i0	44.3	0.799126637554585	61	28	76	3	224	51	11	68	KAI7590442.1 hypothetical protein KC346_g16567, partial [Hortaea werneckii]	diamond	183	41.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Hortaea	Hortaea werneckii

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