metadata: contig_metadata: 12 rows where bioproject = "PRJNA719595" and tax

12 rows where bioproject = "PRJNA719595" 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
1985540	1985540	PRJNA719595_P_NODE_8702_length_245_cov_0.906977_g8667_i0	PRJNA719595	8702	245	0.906977	2.22209365	Yarrowia lipolytica	4952	Fungi	Fungi	372	1.49e-98	NTclustered	gi\|2801357908\|ref\|XM_503717.3\|	4952	g8667	i0	100	0.820408163265306	201	0	82	0	45	245	2640	2440	Yarrowia lipolytica uncharacterized protein (YALI1_E11136g), partial mRNA	blastn	201	372	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales		Yarrowia	Yarrowia lipolytica
5813034	5813034	PRJNA719595_P_NODE_6505_length_253_cov_0.866667_g6470_i0	PRJNA719595	6505	253	0.866667	2.19266751	Cercospora kikuchii	84275	Fungi	Fungi	424	4.22e-114	NTclustered	gi\|2124596981\|ref\|XM_044795495.1\|	84275	g6470	i0	96.838	2	253	8	100	0	1	253	794	542	Cercospora kikuchii uncharacterized protein (CKM354_000040800), partial mRNA	blastn	506	424	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Cercospora	Cercospora kikuchii
8362785	8362785	PRJNA719595_P_NODE_7567_length_249_cov_0.886364_g7532_i0	PRJNA719595	7567	249	0.886364	2.20704636	Cladosporium cladosporioides	29917	Fungi	Fungi	436	5.32e-118	NTclustered	gi\|301015197\|gb\|GQ906475.1\|	29917	g7532	i0	98.387	88.3333333333333	248	4	99	0	2	249	248	495	Cladosporium cladosporioides transaldolase mRNA, complete cds	blastn	21995	436	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium cladosporioides
10913506	10913506	PRJNA719595_P_NODE_8629_length_245_cov_0.906977_g8594_i0	PRJNA719595	8629	245	0.906977	2.22209365	Purpureocillium takamizusanense	2060973	Fungi	Fungi	143	1.28e-29	NTclustered	gi\|2234652211\|ref\|XM_047983266.1\|	2060973	g8594	i0	82.635	12.6408163265306	167	23	67	5	6	169	1154	1317	Purpureocillium takamizusanense Glutamine synthetase (GLN1), mRNA	blastn	3097	143	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Purpureocillium	Purpureocillium takamizusanense
11397010	11397010	PRJNA719595_P_NODE_6429_length_253_cov_0.866667_g6394_i0	PRJNA719595	6429	253	0.866667	2.19266751	Cladosporium	5498	Fungi	Fungi	414	2.54e-111	NTclustered	gi\|1905450536\|gb\|MN657180.1\|	1707700	g6394	i0	96.774	92.6679841897233	248	8	98	0	6	253	5430	5183	Cladosporium sp. strain YFCC8620 mitochondrion, complete genome	blastn	23445	418	0.990430622009569	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium sp.
21112077	21112077	PRJNA719595_P_NODE_8137_length_247_cov_0.896552_g8102_i0	PRJNA719595	8137	247	0.896552	2.21448344	Candida albicans	5476	Fungi	Fungi	52.8	0.022	NTclustered	gi\|1111954566\|ref\|XM_717482.2\|	237561	g8102	i0	100	0.11336032388664	28	0	11	0	31	58	1192	1219	Candida albicans SC5314 cleavage polyadenylation factor subunit (CAALFM_C202150CA), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida albicans
26650759	26650759	PRJNA719595_P_NODE_8861_length_244_cov_0.912281_g8826_i0	PRJNA719595	8861	244	0.912281	2.22596564	Ascomycota	4890	Fungi	Fungi	107	5.84e-25	NR	XP_020069790.1	983966	g8826	i0	65.4	4.97950819672131	81	27	98.4	1	242	3	234	314	XP_020069790.1 uncharacterized protein CYBJADRAFT_128708 [Cyberlindnera jadinii NRRL Y-1542]	diamond	1215	107	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Phaffomycetales	Phaffomycetaceae	Cyberlindnera	Cyberlindnera jadinii
28031265	28031265	PRJNA719595_P_NODE_8445_length_246_cov_0.901734_g8410_i0	PRJNA719595	8445	246	0.901734	2.21826564	Sugiyamaella lignohabitans	796027	Fungi	Fungi	51.6	1.75e-5	NR	XP_018738447.1	796027	g8410	i0	35.4	0.963414634146341	79	49	95.1	2	244	11	122	199	XP_018738447.1 Aim41p [Sugiyamaella lignohabitans]	diamond	237	51.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Trichomonascaceae	Sugiyamaella	Sugiyamaella lignohabitans
28252105	28252105	PRJNA719595_P_NODE_6486_length_253_cov_0.866667_g6451_i0	PRJNA719595	6486	253	0.866667	2.19266751	Torulaspora globosa	48254	Fungi	Fungi	87.4	9.67e-19	NR	YP_009155514.1	48254	g6451	i0	63.1	0.770750988142292	65	24	77.1	0	56	250	1	65	YP_009155514.1 cytochrome c oxidase subunit 2 [Torulaspora globosa]	diamond	195	87.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Torulaspora	Torulaspora globosa
28473325	28473325	PRJNA719595_P_NODE_7566_length_249_cov_0.886364_g7531_i0	PRJNA719595	7566	249	0.886364	2.20704636	Sphaerosporella brunnea	1250544	Fungi	Fungi	64.3	1.04e-9	NR	KAA8912777.1	1250544	g7531	i0	44.8	2.4578313253012	58	32	69.9	0	13	186	75	132	KAA8912777.1 fungal transcriptional regulatory protein [Sphaerosporella brunnea]	diamond	612	64.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pezizomycetes	Pezizales	Pyronemataceae	Sphaerosporella	Sphaerosporella brunnea
29389008	29389008	PRJNA719595_P_NODE_7369_length_250_cov_0.881356_g7334_i0	PRJNA719595	7369	250	0.881356	2.20339	Cladosporium halotolerans	1052096	Fungi	Fungi	172	1.13e-49	NR	XP_069228240.1	1052096	g7334	i0	94	0.996	83	5	99.6	0	250	2	352	434	XP_069228240.1 uncharacterized protein WHR41_06539 [Cladosporium halotolerans]	diamond	249	172	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
29809679	29809679	PRJNA719595_P_NODE_7651_length_249_cov_0.886364_g7616_i0	PRJNA719595	7651	249	0.886364	2.20704636	root	1	Root_unresolved	Root_unresolved	47.4	6.88e-4	NR	XP_024665956.1	45607	g7616	i0	38.2	1.98795180722892	68	36	80.7	2	207	7	120	182	XP_024665956.1 JmjC domain-containing protein 7 [Wickerhamiella sorbophila]	diamond	495	47.8	0.99163179916318	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Trichomonascaceae	Wickerhamiella	Wickerhamiella sorbophila

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