metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1072736" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1072736" and tax_kingdom = "Fungi"

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
2291159	2291159	PRJNA1072736_S_NODE_3082_length_208_cov_2.987879_g3077_i0	PRJNA1072736	3082	208	2.987879	6.21478832	root	1	Root_unresolved	Root_unresolved	372	1.23e-98	NTclustered	gi\|1389182097\|gb\|CP029160.1\|	4932	g3077	i0	99.038	100	208	0	100	1	1	208	5234430	5234635	Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence	blastn	20800	374	0.994652406417112	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
9114567	9114567	PRJNA1072736_S_NODE_3208_length_205_cov_3.518519_g3203_i0	PRJNA1072736	3208	205	3.518519	7.21296395	Beauveria bassiana	176275	Fungi	Fungi	379	7.229999999999999e-101	NTclustered	gi\|1304112037\|gb\|MG654726.1\|	176275	g3203	i0	100	103.278048780488	205	0	100	0	1	205	1666	1462	Beauveria bassiana isolate VSP11 large subunit ribosomal RNA gene, partial sequence	blastn	21172	379	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Beauveria	Beauveria bassiana
9943973	9943973	PRJNA1072736_S_NODE_7708_length_150_cov_1.504673_g7703_i0	PRJNA1072736	7708	150	1.504673	2.2570095	Malassezia	55193	Fungi	Fungi	278	1.85e-70	NTclustered	gi\|1321659621\|gb\|KY911094.1\|	76775	g7703	i0	100	62.0733333333333	150	0	100	0	1	150	32760	32611	Malassezia restricta mitochondrion, complete genome	blastn	9311	278	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
11665619	11665619	PRJNA1072736_S_NODE_4830_length_178_cov_0.985185_g4825_i0	PRJNA1072736	4830	178	0.985185	1.7536293	Cladosporium halotolerans	1052096	Fungi	Fungi	209	8.44e-50	NTclustered	gi\|2837770936\|ref\|XM_069377483.1\|	1052096	g4825	i0	94.776	6.10674157303371	134	7	75	0	45	178	328	195	Cladosporium halotolerans 40S ribosomal protein eS25 (WHR41_08879), mRNA	blastn	1087	209	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
15489595	15489595	PRJNA1072736_S_NODE_5313_length_171_cov_30.093750_g5308_i0	PRJNA1072736	5313	171	30.09375	51.4603125	Mucor mucedo	29922	Fungi	Fungi	58.4	3.08e-4	NTclustered	gi\|2324075884\|ref\|XM_051603668.1\|	29922	g5308	i0	94.737	0.222222222222222	38	0	22	1	90	127	218	253	Mucor mucedo uncharacterized protein (EV154DRAFT_529412), mRNA	blastn	38	58.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor mucedo
15489597	15489597	PRJNA1072736_S_NODE_7513_length_151_cov_2.175926_g7508_i0	PRJNA1072736	7513	151	2.175926	3.28564826	Rhodotorula toruloides	5286	Fungi	Fungi	150	4.2499999999999996e-32	NTclustered	gi\|1022847039\|ref\|XM_016421566.1\|	1130832	g7508	i0	89.744	1.50331125827815	117	12	77	0	35	151	372	256	Rhodotorula toruloides NP11 40S ribosomal protein s20 (RHTO_07911), partial mRNA	blastn	227	150	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula toruloides
17593595	17593595	PRJNA1072736_S_NODE_4634_length_180_cov_2.058394_g4629_i0	PRJNA1072736	4634	180	2.058394	3.7051092	Candelariaceae	452226	Fungi	Fungi	230	6.5699999999999985e-56	NTclustered	gi\|2460928388\|gb\|OQ646163.1\|	411581	g4629	i0	97.744	72.0722222222222	133	3	74	0	48	180	448	316	Candelariella reflexa voucher Herb. Malicek14206 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	12973	230	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Candelariomycetes	Candelariales	Candelariaceae	Candelariella	Candelariella reflexa
21863822	21863822	PRJNA1072736_S_NODE_4458_length_183_cov_1.007143_g4453_i0	PRJNA1072736	4458	183	1.007143	1.84307169	Trichoderma atroviride	63577	Fungi	Fungi	86.1	1.54e-12	NTclustered	gi\|2749703766\|ref\|XM_014090103.2\|	63577	g4453	i0	88	2.40983606557377	75	6	41	1	33	107	2269	2198	Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA	blastn	441	86.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Trichoderma	Trichoderma atroviride
24412863	24412863	PRJNA1072736_S_NODE_1340_length_277_cov_1.982906_g1335_i0	PRJNA1072736	1340	277	1.982906	5.49264962	Beauveria bassiana	176275	Fungi	Fungi	267	8.36e-67	NTclustered	gi\|667653266\|ref\|XM_008600243.1\|	655819	g1335	i0	90.547	0.725631768953069	201	19	73	0	77	277	153	353	Beauveria bassiana ARSEF 2860 uncharacterized protein (BBA_05146), partial mRNA	blastn	201	267	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);;