metadata: contig_metadata: 10 rows where bioproject = "PRJNA1264536" and tax

10 rows where bioproject = "PRJNA1264536" 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
8017270	8017270	PRJNA1264536_P_NODE_3647_length_288_cov_1.083721_g3573_i0	PRJNA1264536	3647	288	1.083721	3.12111648	Daldinia caldariorum	326644	Fungi	Fungi	52.8	0.027	NTclustered	gi\|2234654077\|ref\|XM_047932825.1\|	326644	g3573	i0	96.875	0.111111111111111	32	0	11	1	153	184	842	812	Daldinia caldariorum uncharacterized protein (F4812DRAFT_413826), mRNA	blastn	32	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Hypoxylaceae	Daldinia	Daldinia caldariorum
10567955	10567955	PRJNA1264536_P_NODE_1689_length_441_cov_1.573370_g1615_i0	PRJNA1264536	1689	441	1.57337	6.9385617	Debaryomyces fabryi	58627	Fungi	Fungi	302	3.83e-77	NTclustered	gi\|998531938\|ref\|XM_015610877.1\|	58627	g1615	i0	81.217	30.5374149659864	378	67	85	2	49	424	37	412	Debaryomyces fabryi 40S ribosomal protein S14-A (AC631_02047), partial mRNA	blastn	13467	302	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Debaryomyces	Debaryomyces fabryi
15666799	15666799	PRJNA1264536_P_NODE_4233_length_257_cov_1.271739_g4159_i0	PRJNA1264536	4233	257	1.271739	3.26836923	Plenodomus biglobosus	220672	Fungi	Fungi	52.8	0.023	NTclustered	gi\|702066537\|emb\|FO905617.1\|	225338	g4159	i0	100	0.108949416342412	28	0	11	0	179	206	69748	69775	Leptosphaeria biglobosa brassicae b35_scaffold00047 complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Leptosphaeriaceae	Plenodomus	Plenodomus biglobosus
15666804	15666804	PRJNA1264536_P_NODE_4633_length_250_cov_1.322034_g4559_i0	PRJNA1264536	4633	250	1.322034	3.305085	Helenozyma melibiosica	5491	Fungi	Fungi	305	1.57e-78	NTclustered	gi\|32127488\|emb\|AJ508531.1\|	5491	g4559	i0	90.213	93.008	235	21	94	2	1	234	73	306	Candida melibiosica partial act1 gene for actin, strain CBS 6087T	blastn	23252	305	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Helenozyma	Helenozyma melibiosica
23316084	23316084	PRJNA1264536_P_NODE_4879_length_248_cov_0.891429_g4805_i0	PRJNA1264536	4879	248	0.891429	2.21074392	Monosporozyma unispora	27294	Fungi	Fungi	179	1.87e-53	NR	KAG0658246.1	27294	g4805	i0	100	0.991935483870968	82	0	99.2	0	246	1	102	183	KAG0658246.1 SUN protein uth1 [Monosporozyma unispora]	diamond	246	179	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Monosporozyma	Monosporozyma unispora
26820905	26820905	PRJNA1264536_P_NODE_2401_length_364_cov_1.072165_g2327_i0	PRJNA1264536	2401	364	1.072165	3.9026806	Candida viswanathii	5486	Fungi	Fungi	107	3.49e-24	NR	RCK59601.1	5486	g2327	i0	54.2	4.07967032967033	96	43	78.3	1	80	364	62	157	RCK59601.1 ATP-dependent RNA helicase DBP2 [Candida viswanathii]	diamond	1485	107	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida viswanathii
27073863	27073863	PRJNA1264536_P_NODE_3862_length_276_cov_1.492611_g3788_i0	PRJNA1264536	3862	276	1.492611	4.11960636	Protomyces lactucae-debilis	2754530	Fungi	Fungi	79.3	4.69e-15	NR	XP_040722964.1	2754530	g3788	i0	51.4	4.1304347826087	72	35	78.3	0	1	216	234	305	XP_040722964.1 cytoplasmic tRNA 2-thiolation protein 1 [Protomyces lactucae-debilis]	diamond	1140	79.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Taphrinomycetes	Taphrinales	Protomycetaceae	Protomyces	Protomyces lactucae-debilis
29095097	29095097	PRJNA1264536_P_NODE_5528_length_242_cov_0.923077_g5454_i0	PRJNA1264536	5528	242	0.923077	2.23384634	Hyaloscypha bicolor E	1095630	Fungi	Fungi	74.3	2.79e-13	NR	XP_024729651.1	1095630	g5454	i0	56.2	0.90495867768595	73	15	90.5	1	22	240	377	432	XP_024729651.1 uncharacterized protein K444DRAFT_619455 [Hyaloscypha bicolor E]	diamond	219	74.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Hyaloscyphaceae	Hyaloscypha	Hyaloscypha bicolor
31685621	31685621	PRJNA1264536_P_NODE_4517_length_251_cov_1.724719_g4443_i0	PRJNA1264536	4517	251	1.724719	4.32904469	Ambrosiozyma monospora	43982	Fungi	Fungi	54.3	1.54e-7	NR	GMG40450.1	43982	g4443	i0	54	0.597609561752988	50	22	58.6	1	251	105	13	62	GMG40450.1 unnamed protein product [Ambrosiozyma monospora]	diamond	150	54.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Ambrosiozyma	Ambrosiozyma monospora
31893361	31893361	PRJNA1264536_P_NODE_3937_length_273_cov_0.955000_g3863_i0	PRJNA1264536	3937	273	0.955	2.60715	Fungi	4751	Fungi	Fungi	44.3	0.00858	NR	XP_008599172.1	655819	g3863	i0	41	3.65934065934066	39	23	42.9	0	241	125	132	170	XP_008599172.1 LysM domain-containing protein [Beauveria bassiana ARSEF 2860]	diamond	999	44.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Beauveria	Beauveria bassiana

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