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

11 rows where analysis = "diamond", bioproject = "PRJNA938397" 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
3464467	3464467	PRJNA938397_S_NODE_42723_length_168_cov_2.595420_g42482_i0	PRJNA938397	42723	168	2.59542	4.3603056	Sungouiella intermedia	45354	Fungi	Fungi	102	1.8e-23	NR	SGZ47193.1	45354	g42482	i0	89.3	12.9642857142857	56	6	100	0	1	168	156	211	SGZ47193.1 CIC11C00000005829 [Sungouiella intermedia]	diamond	2178	102	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Sungouiella	Sungouiella intermedia
27443162	27443162	PRJNA938397_S_NODE_24483_length_223_cov_6.446237_g24242_i0	PRJNA938397	24483	223	6.446237	14.37510851	Opisthokonta	33154	Fungi	Fungi	42.7	0.0284	NR	KAK4232089.1	252190	g24242	i0	45.9	2.51569506726457	37	19	48.4	1	220	113	37	73	KAK4232089.1 XPC-binding domain-containing protein [Podospora fimiseda]	diamond	561	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Podosporaceae	Podospora	Podospora fimiseda
27530527	27530527	PRJNA938397_S_NODE_15683_length_277_cov_3.850000_g15442_i0	PRJNA938397	15683	277	3.85	10.6645	Thyridium curvatum	1093900	Fungi	Fungi	53.1	1.2e-5	NR	XP_030990509.1	1093900	g15442	i0	47.2	0.574007220216607	53	28	57.4	0	262	104	401	453	XP_030990509.1 uncharacterized protein E0L32_009738 [Thyridium curvatum]	diamond	159	53.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Thyridiales	Thyridiaceae	Thyridium	Thyridium curvatum
27688832	27688832	PRJNA938397_S_NODE_45964_length_162_cov_1.224000_g45723_i0	PRJNA938397	45964	162	1.224	1.98288	Thozetella sp. PMI_491	1506992	Fungi	Fungi	56.6	1.6e-7	NR	KAH8878909.1	1506992	g45723	i0	65.1	1.72222222222222	43	15	79.6	0	1	129	123	165	KAH8878909.1 pre-mRNA-splicing factor SLU7 [Thozetella sp. PMI_491]	diamond	279	56.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Chaetosphaeriales	Chaetosphaeriaceae	Thozetella	Thozetella sp. PMI_491
28414769	28414769	PRJNA938397_S_NODE_42046_length_169_cov_5.212121_g41805_i0	PRJNA938397	42046	169	5.212121	8.80848449	Aspergillus aculeatus ATCC 16872	690307	Fungi	Fungi	56.2	2.25e-7	NR	XP_020056901.1	690307	g41805	i0	53.5	0.763313609467456	43	20	76.3	0	5	133	282	324	XP_020056901.1 uncharacterized protein ASPACDRAFT_28590 [Aspergillus aculeatus ATCC 16872]	diamond	129	56.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus aculeatus
28541151	28541151	PRJNA938397_S_NODE_29587_length_202_cov_108.939394_g29346_i0	PRJNA938397	29587	202	108.939394	220.05757588	Claviceps pusilla	123648	Fungi	Fungi	42	0.00995	NR	KAG6005011.1	123648	g29346	i0	74.2	0.920792079207921	31	8	46	0	15	107	66	96	KAG6005011.1 hypothetical protein E4U43_000638 [Claviceps pusilla]	diamond	186	42	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Clavicipitaceae	Claviceps	Claviceps pusilla
28611125	28611125	PRJNA938397_S_NODE_37487_length_180_cov_1.013986_g37246_i0	PRJNA938397	37487	180	1.013986	1.8251748	Ascomycota	4890	Fungi	Fungi	51.2	1.66e-5	NR	KAF4305781.1	55169	g37246	i0	52.5	1.33333333333333	40	19	66.7	0	4	123	255	294	KAF4305781.1 putative integral membrane protein [Botryosphaeria dothidea]	diamond	240	51.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Botryosphaeriales	Botryosphaeriaceae	Botryosphaeria	Botryosphaeria dothidea
29708751	29708751	PRJNA938397_S_NODE_27850_length_209_cov_4.843023_g27609_i0	PRJNA938397	27850	209	4.843023	10.12191807	Aspergillus versicolor CBS 583.65	1036611	Fungi	Fungi	42.4	0.0183	NR	XP_040662471.1	1036611	g27609	i0	40.5	1.17703349282297	42	25	60.3	0	187	62	41	82	XP_040662471.1 uncharacterized protein ASPVEDRAFT_36118 [Aspergillus versicolor CBS 583.65]	diamond	246	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus versicolor
30309857	30309857	PRJNA938397_S_NODE_18572_length_256_cov_2.488584_g18331_i0	PRJNA938397	18572	256	2.488584	6.37077504	Paecilomyces variotii	264951	Fungi	Fungi	92.4	3.02e-20	NR	KAJ9222105.1	264951	g18331	i0	59.5	2.6484375	74	30	86.7	0	224	3	6	79	KAJ9222105.1 hypothetical protein DTO169C6_5556 [Paecilomyces variotii]	diamond	678	92.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Thermoascaceae	Paecilomyces	Paecilomyces variotii
30341496	30341496	PRJNA938397_S_NODE_7172_length_378_cov_22.495601_g6933_i0	PRJNA938397	7172	378	22.495601	85.03337178	Rhexocercosporidium sp. MPI-PUGE-AT-	1756112	Fungi	Fungi	65.1	2.36e-9	NR	KAH7305356.1	2042821	g6933	i0	54.3	0.873015873015873	46	21	36.5	0	106	243	70	115	KAH7305356.1 hypothetical protein BKA65DRAFT_520766 [Rhexocercosporidium sp. MPI-PUGE-AT-0058]	diamond	330	65.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales		Rhexocercosporidium	Rhexocercosporidium sp. MPI-PUGE-AT-0058
32561631	32561631	PRJNA938397_S_NODE_39079_length_176_cov_2.251799_g38838_i0	PRJNA938397	39079	176	2.251799	3.96316624	Dothideomycetes	147541	Fungi	Fungi	73.9	3.24e-14	NR	KAF2834819.1	1346257	g38838	i0	56.1	3.85227272727273	57	25	97.2	0	171	1	142	198	KAF2834819.1 RPB5 subunit of DNA-directed RNA polymerase [Patellaria atrata CBS 101060]	diamond	678	73.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Patellariales	Patellariaceae	Patellaria	Patellaria atrata

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