metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA781453" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA781453" 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
27527497	27527497	PRJNA781453_P_NODE_24883_length_291_cov_1.788991_g24768_i0	PRJNA781453	24883	291	1.788991	5.20596381	Penicillium fimorum	1882269	Fungi	Fungi	43.5	0.0314	NR	KAJ5504772.1	1882269	g24768	i0	32	0.515463917525773	50	30	51.5	1	2	151	102	147	KAJ5504772.1 hypothetical protein N7463_007646 [Penicillium fimorum]	diamond	150	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium fimorum
27938114	27938114	PRJNA781453_P_NODE_32305_length_251_cov_0.865169_g32190_i0	PRJNA781453	32305	251	0.865169	2.17157419	Aspergillus calidoustus	454130	Fungi	Fungi	109	1.2e-25	NR	CEL10766.1	454130	g32190	i0	71.1	4.41035856573705	83	19	93.2	2	234	1	18	100	CEL10766.1 Putative Aldehyde dehydrogenase [Aspergillus calidoustus]	diamond	1107	109	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus calidoustus
28222002	28222002	PRJNA781453_P_NODE_17046_length_354_cov_1.370107_g16931_i0	PRJNA781453	17046	354	1.370107	4.85017878	Delitschia confertaspora ATCC 742	1504671	Fungi	Fungi	218	1.82e-67	NR	KAF2196293.1	1513339	g16931	i0	86.3	3.96610169491525	117	16	99.2	0	352	2	270	386	KAF2196293.1 PLP-dependent transferase [Delitschia confertaspora ATCC 74209]	diamond	1404	218	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Delitschiaceae	Delitschia	Delitschia confertaspora
28853463	28853463	PRJNA781453_P_NODE_37928_length_244_cov_0.900585_g37813_i0	PRJNA781453	37928	244	0.900585	2.1974274	Lophium mytilinum	390894	Fungi	Fungi	45.4	0.00435	NR	KAF2493283.1	390894	g37813	i0	31.3	0.983606557377049	80	47	98.4	1	4	243	319	390	KAF2493283.1 hypothetical protein BU16DRAFT_619624 [Lophium mytilinum]	diamond	240	45.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mytilinidiales	Mytilinidiaceae	Lophium	Lophium mytilinum
29927395	29927395	PRJNA781453_P_NODE_29891_length_262_cov_1.222222_g29776_i0	PRJNA781453	29891	262	1.222222	3.20222164	Daldinia caldariorum	326644	Fungi	Fungi	43.1	0.0336	NR	XP_047787429.1	326644	g29776	i0	47.9	0.549618320610687	48	25	55	0	217	74	95	142	XP_047787429.1 uncharacterized protein F4812DRAFT_132643 [Daldinia caldariorum]	diamond	144	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Hypoxylaceae	Daldinia	Daldinia caldariorum
31760321	31760321	PRJNA781453_P_NODE_4757_length_685_cov_3.281046_g4652_i0	PRJNA781453	4757	685	3.281046	22.4751651	Penicillium soppii	69789	Fungi	Fungi	322	5.439999999999999e-107	NR	XP_057099546.1	69789	g4652	i0	74.9	1.01167883211679	231	51	99.9	4	685	2	45	271	XP_057099546.1 uncharacterized protein N7529_004724 [Penicillium soppii]	diamond	693	322	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium soppii
31855174	31855174	PRJNA781453_P_NODE_35717_length_247_cov_0.885057_g35602_i0	PRJNA781453	35717	247	0.885057	2.18609079	Stachybotrys chartarum IBT 4	74722	Fungi	Fungi	154	2.4e-42	NR	KFA53101.1	1280524	g35602	i0	93.9	0.995951417004049	82	5	99.6	0	2	247	436	517	KFA53101.1 hypothetical protein S40293_05343 [Stachybotrys chartarum IBT 40293]	diamond	246	154	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Stachybotryaceae	Stachybotrys	Stachybotrys chartarum
32551617	32551617	PRJNA781453_P_NODE_38099_length_244_cov_0.900585_g37984_i0	PRJNA781453	38099	244	0.900585	2.1974274	[Candida] railenensis	45579	Fungi	Fungi	170	1.37e-51	NR	CAH2352551.1	45579	g37984	i0	96.2	0.971311475409836	79	3	97.1	0	243	7	98	176	CAH2352551.1 uncharacterized RING finger protein [[Candida] railenensis]	diamond	237	170	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Kurtzmaniella	[Candida] railenensis

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