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

10 rows where analysis = "diamond", bioproject = "PRJNA993416" 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
9903993	9903993	PRJNA993416_P_NODE_13668_length_248_cov_0.880000_g13563_i0	PRJNA993416	13668	248	0.88	2.1824	Aspergillus ruber CBS 13568	396024	Fungi	Fungi	146	1.8e-39	NR	XP_040640207.1	1388766	g13563	i0	89.2	2.68548387096774	74	8	89.5	0	223	2	21	94	XP_040640207.1 nonsense-mediated mRNA decay protein 3 [Aspergillus ruber CBS 135680]	diamond	666	146	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus ruber
26715413	26715413	PRJNA993416_P_NODE_15721_length_242_cov_0.911243_g15616_i0	PRJNA993416	15721	242	0.911243	2.20520806	Trichoderma	5543	Fungi	Fungi	45.1	0.00552	NR	XP_018656489.1	398673	g15616	i0	35.4	2.93801652892562	79	46	97.9	1	242	6	123	196	XP_018656489.1 hypothetical protein TGAM01_v210907 [Trichoderma gamsii]	diamond	711	45.4	0.993392070484582	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Trichoderma	Trichoderma gamsii
27658530	27658530	PRJNA993416_P_NODE_13664_length_248_cov_0.880000_g13559_i0	PRJNA993416	13664	248	0.88	2.1824	Lentithecium fluviatile CBS 122367	1168545	Fungi	Fungi	43.9	0.0141	NR	KAF2677001.1	1168545	g13559	i0	41.3	0.556451612903226	46	27	55.6	0	148	11	190	235	KAF2677001.1 hypothetical protein K458DRAFT_166946 [Lentithecium fluviatile CBS 122367]	diamond	138	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Lentitheciaceae	Lentithecium	Lentithecium fluviatile
27784851	27784851	PRJNA993416_P_NODE_7704_length_297_cov_1.750000_g7599_i0	PRJNA993416	7704	297	1.75	5.1975	Cercophora scortea	314031	Fungi	Fungi	46.2	0.00125	NR	KAK3335352.1	314031	g7599	i0	40.4	0.474747474747475	47	28	47.5	0	40	180	81	127	KAK3335352.1 hypothetical protein B0T19DRAFT_5808 [Cercophora scortea]	diamond	141	46.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Lasiosphaeriaceae	Cercophora	Cercophora scortea
30437496	30437496	PRJNA993416_P_NODE_15253_length_243_cov_1.705882_g15148_i0	PRJNA993416	15253	243	1.705882	4.14529326	Cordyceps sp. RAO-2	1755423	Fungi	Fungi	67	1.03e-10	NR	PHH89725.1	2004951	g15148	i0	50.7	2.01234567901235	69	21	85.2	2	35	241	610	665	PHH89725.1 hypothetical protein CDD83_5422 [Cordyceps sp. RAO-2017]	diamond	489	67	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Cordyceps	Cordyceps sp. RAO-2017
30784771	30784771	PRJNA993416_P_NODE_8994_length_283_cov_1.219048_g8889_i0	PRJNA993416	8994	283	1.219048	3.44990584	Cladosporium halotolerans	1052096	Fungi	Fungi	157	3.3299999999999995e-42	NR	XP_069229364.1	1052096	g8889	i0	81.3	0.964664310954064	91	17	96.5	0	10	282	260	350	XP_069229364.1 uncharacterized protein WHR41_05489 [Cladosporium halotolerans]	diamond	273	157	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
31416929	31416929	PRJNA993416_P_NODE_9676_length_277_cov_1.357843_g9571_i0	PRJNA993416	9676	277	1.357843	3.76122511	Sungouiella intermedia	45354	Fungi	Fungi	44.3	0.0167	NR	SGZ55957.1	45354	g9571	i0	27.8	0.974729241877256	90	46	84.5	2	235	2	866	948	SGZ55957.1 CIC11C00000001096 [Sungouiella intermedia]	diamond	270	44.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Sungouiella	Sungouiella intermedia
32334644	32334644	PRJNA993416_P_NODE_15139_length_244_cov_0.900585_g15034_i0	PRJNA993416	15139	244	0.900585	2.1974274	Epichloe bromicola	79588	Fungi	Fungi	57.8	1.05e-7	NR	GAB0147160.1	79588	g15034	i0	47.6	1.52459016393443	63	33	77.5	0	221	33	72	134	GAB0147160.1 hypothetical protein EsHS_00007537 [Epichloe bromicola]	diamond	372	57.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Clavicipitaceae	Epichloe	Epichloe bromicola
32461017	32461017	PRJNA993416_P_NODE_2599_length_532_cov_2.952070_g2495_i0	PRJNA993416	2599	532	2.95207	15.7050124	Fusarium euwallaceae	1147111	Fungi	Fungi	272	2.69e-85	NR	RTE68074.1	1147111	g2495	i0	93.9	0.834586466165414	148	9	83.5	0	446	3	245	392	RTE68074.1 hypothetical protein BHE90_017548, partial [Fusarium euwallaceae]	diamond	444	272	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium euwallaceae
32587530	32587530	PRJNA993416_P_NODE_11779_length_257_cov_1.342391_g11674_i0	PRJNA993416	11779	257	1.342391	3.44994487	Saitoella complicata NRRL Y-178	5606	Fungi	Fungi	72	2.2e-12	NR	XP_019021730.1	698492	g11674	i0	53.8	1.52918287937743	65	29	74.7	1	196	5	455	519	XP_019021730.1 uncharacterized protein SAICODRAFT_9885 [Saitoella complicata NRRL Y-17804]	diamond	393	72	1	Eukaryota	Opisthokonta	Fungi	Ascomycota				Saitoella	Saitoella complicata

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