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

9 rows where analysis = "diamond", bioproject = "PRJNA1253303" 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
15662406	15662406	PRJNA1253303_P_NODE_8053_length_243_cov_0.917647_g8031_i0	PRJNA1253303	8053	243	0.917647	2.22988221	Eukaryota	2759	Fungi	Fungi	126	6.42e-32	NR	XP_040647596.1	5078	g8031	i0	75.3	49	81	20	100	0	243	1	290	370	XP_040647596.1 HAD-superfamily hydrolase, subfamily IA, variant 3 [Penicillium griseofulvum]	diamond	11907	127	0.992125984251969	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium griseofulvum
19485501	19485501	PRJNA1253303_P_NODE_6476_length_248_cov_0.891429_g6454_i0	PRJNA1253303	6476	248	0.891429	2.21074392	Ascomycota	4890	Fungi	Fungi	126	1.7199999999999995e-31	NR	XP_069257407.1	28565	g6454	i0	72.8	86.4072580645161	81	22	98	0	2	244	535	615	XP_069257407.1 uncharacterized protein VTN31DRAFT_2311 [Thermomyces dupontii]	diamond	21429	127	0.992125984251969	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Thermomyces	Thermomyces dupontii
28544652	28544652	PRJNA1253303_P_NODE_7947_length_244_cov_0.912281_g7925_i0	PRJNA1253303	7947	244	0.912281	2.22596564	Ascomycota	4890	Fungi	Fungi	70.9	4.61e-12	NR	KAF5092323.1	43985	g7925	i0	45.9	5.69262295081967	74	39	89.8	1	230	12	841	914	KAF5092323.1 hypothetical protein D0Z03_002919 [Geotrichum reessii]	diamond	1389	70.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Dipodascaceae	Geotrichum	Geotrichum reessii
29379065	29379065	PRJNA1253303_P_NODE_4289_length_268_cov_1.600000_g4267_i0	PRJNA1253303	4289	268	1.6	4.288	Kockiozyma suomiensis	1337062	Fungi	Fungi	46.6	0.00222	NR	XP_066768786.1	1337062	g4267	i0	42	0.559701492537313	50	29	56	0	118	267	257	306	XP_066768786.1 Metallo-dependent phosphatase-like protein [Kockiozyma suomiensis]	diamond	150	46.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Kockiozyma	Kockiozyma suomiensis
31274460	31274460	PRJNA1253303_P_NODE_4475_length_263_cov_2.173684_g4453_i0	PRJNA1253303	4475	263	2.173684	5.71678892	Kockiozyma suomiensis	1337062	Fungi	Fungi	109	1.03e-25	NR	XP_066767939.1	1337062	g4453	i0	56.3	0.992395437262357	87	38	99.2	0	3	263	193	279	XP_066767939.1 P-loop containing nucleoside triphosphate hydrolase protein [Kockiozyma suomiensis]	diamond	261	109	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Kockiozyma	Kockiozyma suomiensis
31577188	31577188	PRJNA1253303_P_NODE_7916_length_244_cov_0.912281_g7894_i0	PRJNA1253303	7916	244	0.912281	2.22596564	Ascomycota	4890	Fungi	Fungi	107	5.78e-25	NR	XP_037168383.1	112416	g7894	i0	58	4.94262295081967	81	34	99.6	0	2	244	450	530	XP_037168383.1 uncharacterized protein HO173_002959 [Letharia columbiana]	diamond	1206	108	0.990740740740741	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Lecanorales	Parmeliaceae	Letharia	Letharia columbiana
31907077	31907077	PRJNA1253303_P_NODE_6037_length_250_cov_0.881356_g6015_i0	PRJNA1253303	6037	250	0.881356	2.20339	Cladosporium halotolerans	1052096	Fungi	Fungi	172	1.13e-49	NR	XP_069228240.1	1052096	g6015	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
32114994	32114994	PRJNA1253303_P_NODE_5478_length_252_cov_0.871508_g5456_i0	PRJNA1253303	5478	252	0.871508	2.19620016	Ascomycota	4890	Fungi	Fungi	45.1	0.00644	NR	KAK0612334.1	252184	g5456	i0	50	2.22619047619048	48	17	57.1	2	171	28	247	287	KAK0612334.1 putative pre-mRNA splicing factor [Bombardia bombarda]	diamond	561	45.4	0.993392070484582	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Lasiosphaeriaceae	Bombardia	Bombardia bombarda
32729013	32729013	PRJNA1253303_P_NODE_5000_length_253_cov_0.866667_g4978_i0	PRJNA1253303	5000	253	0.866667	2.19266751	Torulaspora globosa	48254	Fungi	Fungi	87.4	9.67e-19	NR	YP_009155514.1	48254	g4978	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

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