metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA675042" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA675042" 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
6272226	6272226	PRJNA675042_P_NODE_5565_length_606_cov_9.227017_g5132_i0	PRJNA675042	5565	606	9.227017	55.91572302	Cladosporium halotolerans	1052096	Fungi	Fungi	213	7.8e-60	NR	XP_069226237.1	1052096	g5132	i0	96.4	0.544554455445545	110	4	54.5	0	332	3	245	354	XP_069226237.1 uncharacterized protein WHR41_07999 [Cladosporium halotolerans]	diamond	330	213	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
13400946	13400946	PRJNA675042_P_NODE_35851_length_354_cov_1.501779_g35401_i0	PRJNA675042	35851	354	1.501779	5.31629766	Cladosporium halotolerans	1052096	Fungi	Fungi	148	2.46e-39	NR	XP_069228774.1	1052096	g35401	i0	90.1	0.771186440677966	91	8	77.1	1	5	277	453	542	XP_069228774.1 uncharacterized protein WHR41_06021 [Cladosporium halotolerans]	diamond	273	148	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
27619043	27619043	PRJNA675042_P_NODE_138584_length_247_cov_0.885057_g138134_i0	PRJNA675042	138584	247	0.885057	2.18609079	Saitoella complicata NRRL Y-178	5606	Fungi	Fungi	53.1	7.83e-6	NR	GAO51261.1	698492	g138134	i0	30.9	3.86234817813765	81	56	98.4	0	3	245	61	141	GAO51261.1 hypothetical protein G7K_5367-t1 [Saitoella complicata NRRL Y-17804]	diamond	954	53.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota				Saitoella	Saitoella complicata
27902965	27902965	PRJNA675042_P_NODE_87965_length_271_cov_1.555556_g87515_i0	PRJNA675042	87965	271	1.555556	4.21555676	Hyaloscypha bicolor E	1095630	Fungi	Fungi	47.8	3.99e-4	NR	XP_024727052.1	1095630	g87515	i0	33.3	0.896678966789668	81	33	75.3	3	21	224	23	95	XP_024727052.1 uncharacterized protein K444DRAFT_637562 [Hyaloscypha bicolor E]	diamond	243	47.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Hyaloscyphaceae	Hyaloscypha	Hyaloscypha bicolor
28913265	28913265	PRJNA675042_P_NODE_68308_length_295_cov_2.081081_g67858_i0	PRJNA675042	68308	295	2.081081	6.13918895	Lithohypha guttulata	1690604	Fungi	Fungi	85.9	7.95e-18	NR	XP_064752093.1	1690604	g67858	i0	46.9	2.91864406779661	96	50	97.6	1	4	291	155	249	XP_064752093.1 uncharacterized protein LTR64_006688 [Lithohypha guttulata]	diamond	861	85.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Lithohypha	Lithohypha guttulata
29639441	29639441	PRJNA675042_P_NODE_88350_length_271_cov_1.141414_g87900_i0	PRJNA675042	88350	271	1.141414	3.09323194	uncultured Trichoderma	265189	Fungi	Fungi	89.7	3.63e-21	NR	AIA84157.1	265189	g87900	i0	59.5	0.874538745387454	79	32	87.5	0	269	33	14	92	AIA84157.1 CAZy families GH18 protein [uncultured Trichoderma]	diamond	237	89.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae		uncultured Trichoderma
29924042	29924042	PRJNA675042_P_NODE_57391_length_312_cov_1.062762_g56941_i0	PRJNA675042	57391	312	1.062762	3.31581744	Lipomyces japonicus	56871	Fungi	Fungi	44.3	0.0198	NR	XP_066780918.1	56871	g56941	i0	43.6	0.528846153846154	55	30	51.9	1	209	48	63	117	XP_066780918.1 SGNH hydrolase-type esterase domain-containing protein [Lipomyces japonicus]	diamond	165	44.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Lipomyces	Lipomyces japonicus
30713698	30713698	PRJNA675042_P_NODE_13734_length_455_cov_3.916230_g13284_i0	PRJNA675042	13734	455	3.91623	17.8188465	Cladophialophora chaetospira	386627	Fungi	Fungi	208	5.220000000000001e-59	NR	KAJ9608079.1	386627	g13284	i0	91.9	0.817582417582418	124	10	81.8	0	82	453	175	298	KAJ9608079.1 plasma membrane localization protein [Cladophialophora chaetospira]	diamond	372	208	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Cladophialophora	Cladophialophora chaetospira
31705595	31705595	PRJNA675042_P_NODE_5437_length_611_cov_1.295539_g5006_i0	PRJNA675042	5437	611	1.295539	7.91574329	Talaromyces	5094	Fungi	Fungi	148	2.68e-41	NR	KAI7970711.1	128442	g5006	i0	75.3	2.50409165302782	85	21	41.7	0	2	256	96	180	KAI7970711.1 hypothetical protein EIK77_007891 [Talaromyces pinophilus]	diamond	1530	149	0.993288590604027	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Talaromyces	Talaromyces pinophilus
32642256	32642256	PRJNA675042_P_NODE_178500_length_241_cov_0.916667_g178050_i0	PRJNA675042	178500	241	0.916667	2.20916747	Ogataea polymorpha	460523	Fungi	Fungi	58.9	4.14e-8	NR	KAH3659872.1	460523	g178050	i0	53.7	1.34439834024896	54	25	67.2	0	191	30	138	191	KAH3659872.1 hypothetical protein OGATHE_005917 [Ogataea polymorpha]	diamond	324	58.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Ogataea	Ogataea polymorpha

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