metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1012699" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1012699" 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
11636634	11636634	PRJNA1012699_P_NODE_3990_length_242_cov_0.923077_g3958_i0	PRJNA1012699	3990	242	0.923077	2.23384634	Ascomycota	4890	Fungi	Fungi	144	3.56e-38	NR	XP_066782754.1	56871	g3958	i0	81.3	54.5330578512397	80	15	99.2	0	241	2	258	337	XP_066782754.1 uncharacterized protein V1514DRAFT_332727 [Lipomyces japonicus]	diamond	13197	144	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Lipomyces	Lipomyces japonicus
15460697	15460697	PRJNA1012699_P_NODE_633_length_442_cov_2.084011_g601_i0	PRJNA1012699	633	442	2.084011	9.21132862	Fungi	4751	Fungi	Fungi	216	1.94e-65	NR	GAO52013.1	698492	g601	i0	72.3	19.8461538461538	141	39	95.7	0	11	433	66	206	GAO52013.1 hypothetical protein G7K_6101-t1 [Saitoella complicata NRRL Y-17804]	diamond	8772	216	1	Eukaryota	Opisthokonta	Fungi	Ascomycota				Saitoella	Saitoella complicata
26591388	26591388	PRJNA1012699_P_NODE_2881_length_251_cov_0.876404_g2849_i0	PRJNA1012699	2881	251	0.876404	2.19977404	Orbilia brochopaga	3140254	Fungi	Fungi	43.9	0.0166	NR	KAF3902113.1	3140254	g2849	i0	38.6	1.05179282868526	88	37	99.2	3	251	3	1611	1686	KAF3902113.1 hypothetical protein ABW21_db0203475 [Orbilia brochopaga]	diamond	264	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Orbilia	Orbilia brochopaga
26805497	26805497	PRJNA1012699_P_NODE_3981_length_242_cov_0.923077_g3949_i0	PRJNA1012699	3981	242	0.923077	2.23384634	Orbiliaceae	47021	Fungi	Fungi	75.1	1.45e-13	NR	KAF3926957.1	47266	g3949	i0	47.3	9.97933884297521	74	37	89.3	2	216	1	274	347	KAF3926957.1 hypothetical protein ABW20_dc0107831 [Dactylellina cionopaga]	diamond	2415	75.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Dactylellina	Dactylellina cionopaga
27817006	27817006	PRJNA1012699_P_NODE_3124_length_249_cov_0.886364_g3092_i0	PRJNA1012699	3124	249	0.886364	2.20704636	Ascomycota	4890	Fungi	Fungi	116	3.85e-28	NR	MCJ1239493.1	160984	g3092	i0	76.4	1.73493975903614	72	17	86.7	0	32	247	541	612	MCJ1239493.1 hypothetical protein [Varicellaria rhodocarpa]	diamond	432	117	0.991452991452991	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Pertusariales	Pertusariaceae	Varicellaria	Varicellaria rhodocarpa
30880140	30880140	PRJNA1012699_P_NODE_614_length_445_cov_3.295699_g582_i0	PRJNA1012699	614	445	3.295699	14.66586055	Ascomycota	4890	Fungi	Fungi	228	6.75e-66	NR	TIA60130.1	5580	g582	i0	79.6	108.788764044944	142	29	95.7	0	427	2	12	153	TIA60130.1 HECT-domain-containing protein [Aureobasidium pullulans]	diamond	48411	229	0.995633187772926	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium pullulans
31101188	31101188	PRJNA1012699_P_NODE_2195_length_271_cov_1.560606_g2163_i0	PRJNA1012699	2195	271	1.560606	4.22924226	Eukaryota	2759	Fungi	Fungi	87.4	5.93e-20	NR	RKP29244.1	27322	g2163	i0	61.1	4.79335793357934	72	28	79.7	0	55	270	4	75	RKP29244.1 ribosomal protein L34e [Metschnikowia bicuspidata]	diamond	1299	88.2	0.99092970521542	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Metschnikowia	Metschnikowia bicuspidata
31986776	31986776	PRJNA1012699_P_NODE_1738_length_293_cov_1.413636_g1706_i0	PRJNA1012699	1738	293	1.413636	4.14195348	Fungi	4751	Fungi	Fungi	122	1.18e-32	NR	KAK5797584.1	5077	g1706	i0	80.6	8.43686006825939	72	14	73.7	0	218	3	76	147	KAK5797584.1 hypothetical protein VI817_003875 [Penicillium citrinum]	diamond	2472	123	0.991869918699187	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium citrinum
32121450	32121450	PRJNA1012699_P_NODE_4098_length_233_cov_2.912500_g4066_i0	PRJNA1012699	4098	233	2.9125	6.786125	Schizosaccharomyces pombe	4896	Fungi	Fungi	90.5	8.4e-21	NR	NP_594328.1	4896	g4066	i0	59.7	5.88412017167382	77	30	99.1	1	2	232	76	151	NP_594328.1 translationally-controlled tumor protein [Schizosaccharomyces pombe]	diamond	1371	90.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Schizosaccharomycetes	Schizosaccharomycetales	Schizosaccharomycetaceae	Schizosaccharomyces	Schizosaccharomyces pombe

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