metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1247234" 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
24577890	24577890	PRJNA1247234_P_NODE_27980_length_242_cov_0.923077_g27824_i0	PRJNA1247234	27980	242	0.923077	2.23384634	Dothideomycetes	147541	Fungi	Fungi	160	1.1199999999999996e-43	NR	KAK5703114.1	574655	g27824	i0	96.2	68.603305785124	79	3	97.9	0	241	5	118	196	KAK5703114.1 carnitine O-acetyltransferase yat1 [Elasticomyces elasticus]	diamond	16602	161	0.993788819875776	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Elasticomyces	Elasticomyces elasticus
27294848	27294848	PRJNA1247234_P_NODE_23563_length_248_cov_0.891429_g23407_i0	PRJNA1247234	23563	248	0.891429	2.21074392	Lecanicillium sp. MT-2	1756136	Fungi	Fungi	80.9	4.04e-16	NR	KAK3190438.1	1964301	g23407	i0	90.5	0.979838709677419	42	4	50.8	0	247	122	234	275	KAK3190438.1 hypothetical protein K4F52_003459 [Lecanicillium sp. MT-2017a]	diamond	243	80.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Lecanicillium	Lecanicillium sp. MT-2017a
27737282	27737282	PRJNA1247234_P_NODE_26524_length_244_cov_0.912281_g26368_i0	PRJNA1247234	26524	244	0.912281	2.22596564	Dissoconium aciculare CBS 342.82	1314786	Fungi	Fungi	77.4	2.22e-16	NR	XP_033463042.1	1314786	g26368	i0	64.7	0.627049180327869	51	18	62.7	0	243	91	47	97	XP_033463042.1 hydrophobin 3 [Dissoconium aciculare CBS 342.82]	diamond	153	77.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Dissoconiaceae	Dissoconium	Dissoconium aciculare
28305280	28305280	PRJNA1247234_P_NODE_23646_length_248_cov_0.891429_g23490_i0	PRJNA1247234	23646	248	0.891429	2.21074392	Talaromyces atroroseus	1441469	Fungi	Fungi	101	4.4699999999999996e-23	NR	XP_020119060.1	1441469	g23490	i0	88.5	0.629032258064516	52	6	62.9	0	157	2	7	58	XP_020119060.1 Chorismate synthase [Talaromyces atroroseus]	diamond	156	101	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Talaromyces	Talaromyces atroroseus
29568181	29568181	PRJNA1247234_P_NODE_26510_length_244_cov_0.912281_g26354_i0	PRJNA1247234	26510	244	0.912281	2.22596564	Cladosporium halotolerans	1052096	Fungi	Fungi	55.8	3.85e-7	NR	XP_069230340.1	1052096	g26354	i0	57.8	1.13114754098361	45	15	55.3	1	136	2	22	62	XP_069230340.1 uncharacterized protein WHR41_04393 [Cladosporium halotolerans]	diamond	276	55.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
30610560	30610560	PRJNA1247234_P_NODE_26533_length_244_cov_0.912281_g26377_i0	PRJNA1247234	26533	244	0.912281	2.22596564	[Candida] anglica	148631	Fungi	Fungi	112	8.260000000000001e-27	NR	CAK7894753.1	148631	g26377	i0	62.8	0.959016393442623	78	29	95.9	0	242	9	389	466	CAK7894753.1 hypothetical protein CAAN1_02S04478 [[Candida] anglica]	diamond	234	112	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Kurtzmaniella	[Candida] anglica

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