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

10 rows where analysis = "diamond", bioproject = "PRJNA1069776" 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
21861489	21861489	PRJNA1069776_S_NODE_20618_length_232_cov_3.481481_g20304_i0	PRJNA1069776	20618	232	3.481481	8.07703592	Acrodontium crateriforme	150365	Fungi	Fungi	145	8.52e-41	NR	WPH03808.1	150365	g20304	i0	93.5	0.995689655172414	77	5	99.6	0	1	231	230	306	WPH03808.1 Putative ATP phosphoribosyltransferase [Acrodontium crateriforme]	diamond	231	145	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Acrodontium	Acrodontium crateriforme
27067280	27067280	PRJNA1069776_S_NODE_31682_length_192_cov_4.187919_g31368_i0	PRJNA1069776	31682	192	4.187919	8.04080448	Parathielavia appendiculata	2587402	Fungi	Fungi	41.6	0.0492	NR	XP_062641769.1	2587402	g31368	i0	34.5	0.90625	58	38	90.6	0	6	179	419	476	XP_062641769.1 carbohydrate-binding module family 24 protein [Parathielavia appendiculata]	diamond	174	41.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Chaetomiaceae	Parathielavia	Parathielavia appendiculata
27256990	27256990	PRJNA1069776_S_NODE_49463_length_157_cov_1.649123_g49149_i0	PRJNA1069776	49463	157	1.649123	2.58912311	Curvularia clavata	95742	Fungi	Fungi	66.6	4.17e-11	NR	USP79538.1	95742	g49149	i0	92.7	0.78343949044586	41	3	78.3	0	155	33	392	432	USP79538.1 hypothetical protein yc1106_06812 [Curvularia clavata]	diamond	123	66.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Curvularia	Curvularia clavata
28299003	28299003	PRJNA1069776_S_NODE_20186_length_234_cov_4.523560_g19872_i0	PRJNA1069776	20186	234	4.52356	10.5851304	Colletotrichum tofieldiae	708197	Fungi	Fungi	44.3	0.00979	NR	GKT61452.1	708197	g19872	i0	42.9	1.43589743589744	56	32	71.8	0	28	195	542	597	GKT61452.1 hypothetical protein ColTof3_08791 [Colletotrichum tofieldiae]	diamond	336	44.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum tofieldiae
29151950	29151950	PRJNA1069776_S_NODE_28509_length_201_cov_5.348101_g28195_i0	PRJNA1069776	28509	201	5.348101	10.74968301	Bipolaris maydis	5016	Fungi	Fungi	40.8	0.025	NR	KAJ5064503.1	5016	g28195	i0	28.3	0.895522388059702	60	43	89.6	0	195	16	23	82	KAJ5064503.1 hypothetical protein J3E74DRAFT_25795 [Bipolaris maydis]	diamond	180	40.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Bipolaris	Bipolaris maydis
29151952	29151952	PRJNA1069776_S_NODE_52449_length_153_cov_0.872727_g52135_i0	PRJNA1069776	52449	153	0.872727	1.33527231	Xylogone sp. PMI_7	1769369	Fungi	Fungi	41.2	0.0399	NR	KAH8804515.1	2614602	g52135	i0	56.5	0.450980392156863	23	10	45.1	0	79	147	294	316	KAH8804515.1 major facilitator superfamily transporter, partial [Xylogone sp. PMI_703]	diamond	69	41.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes			Xylogone	Xylogone sp. PMI_703
29593221	29593221	PRJNA1069776_S_NODE_19290_length_239_cov_2.204082_g18976_i0	PRJNA1069776	19290	239	2.204082	5.26775598	Aureobasidium sp. EXF-8845	2894279	Fungi	Fungi	42.7	0.0354	NR	KAI4852794.1	2894279	g18976	i0	32.4	0.853556485355649	68	44	82.8	1	204	7	569	636	KAI4852794.1 hypothetical protein E4T44_01252 [Aureobasidium sp. EXF-8845]	diamond	204	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium sp. EXF-8845
29742803	29742803	PRJNA1069776_S_NODE_5790_length_359_cov_12.155063_g5476_i0	PRJNA1069776	5790	359	12.155063	43.63667617	Teratosphaeriaceae	668547	Fungi	Fungi	116	2.45e-28	NR	KAL2356950.1	329879	g5476	i0	68.8	3.82729805013928	77	23	63.5	1	3	230	311	387	KAL2356950.1 glycoside hydrolase superfamily [Cryomyces antarcticus]	diamond	1374	116	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes			Cryomyces	Cryomyces antarcticus
30793955	30793955	PRJNA1069776_S_NODE_35194_length_183_cov_4.742857_g34880_i0	PRJNA1069776	35194	183	4.742857	8.67942831	Talaromyces pinophilus	128442	Fungi	Fungi	78.2	2.67e-16	NR	KAF3399620.1	128442	g34880	i0	61.7	0.983606557377049	60	23	98.4	0	182	3	101	160	KAF3399620.1 hypothetical protein DPV78_007113 [Talaromyces pinophilus]	diamond	180	78.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Talaromyces	Talaromyces pinophilus
30920631	30920631	PRJNA1069776_S_NODE_24934_length_214_cov_1.649123_g24620_i0	PRJNA1069776	24934	214	1.649123	3.52912322	Piccolia ochrophora	2939412	Fungi	Fungi	43.9	0.00951	NR	KAI9803714.1	2939412	g24620	i0	44.1	2.55140186915888	59	32	81.3	1	188	15	119	177	KAI9803714.1 MAG: hypothetical protein M1833_000626 [Piccolia ochrophora]	diamond	546	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes			Piccolia	Piccolia ochrophora

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