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

10 rows where analysis = "diamond", bioproject = "PRJEB55122" 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
121208	121208	PRJEB55122_P_NODE_36641_length_169_cov_0.866667_g36244_i0	PRJEB55122	36641	169	0.866667	1.46466723	Anthostomella pinea	933095	Fungi	Fungi	102	1.45e-24	NR	CAJ2508098.1	933095	g36244	i0	78.6	2.96449704142012	56	12	99.4	0	168	1	201	256	CAJ2508098.1 Uu.00g092840.m01.CDS01 [Anthostomella pinea]	diamond	501	102	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Xylariaceae	Anthostomella	Anthostomella pinea
26716619	26716619	PRJEB55122_P_NODE_30781_length_189_cov_1.157143_g30384_i0	PRJEB55122	30781	189	1.157143	2.18700027	Lophiotrema nucula	690887	Fungi	Fungi	90.1	8.23e-20	NR	KAF2107932.1	690887	g30384	i0	58.3	0.952380952380952	60	25	95.2	0	3	182	141	200	KAF2107932.1 fatty acid hydroxylase superfamily-domain-containing protein [Lophiotrema nucula]	diamond	180	90.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Lophiotremataceae	Lophiotrema	Lophiotrema nucula
27311519	27311519	PRJEB55122_P_NODE_38143_length_167_cov_1.762712_g37746_i0	PRJEB55122	38143	167	1.762712	2.94372904	Sordariomycetes	147550	Fungi	Fungi	69.7	5.72e-13	NR	KAL1880002.1	223376	g37746	i0	67.3	7.90419161676647	55	17	98.8	1	166	2	57	110	KAL1880002.1 hypothetical protein VTK73DRAFT_6392 [Phialemonium thermophilum]	diamond	1320	69.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Cephalothecales	Cephalothecaceae	Phialemonium	Phialemonium thermophilum
28044287	28044287	PRJEB55122_P_NODE_37525_length_168_cov_0.873950_g37128_i0	PRJEB55122	37525	168	0.87395	1.468236	Cladosporium halotolerans	1052096	Fungi	Fungi	75.5	3.94e-14	NR	XP_069231173.1	1052096	g37128	i0	65.4	0.928571428571429	52	16	92.9	1	10	165	541	590	XP_069231173.1 uncharacterized protein WHR41_03163 [Cladosporium halotolerans]	diamond	156	75.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
28700726	28700726	PRJEB55122_P_NODE_40727_length_165_cov_0.896552_g40330_i0	PRJEB55122	40727	165	0.896552	1.4793108	Saccotheciaceae	1570301	Fungi	Fungi	98.6	1e-24	NR	TIA32914.1	5580	g40330	i0	87	9.81818181818182	54	7	98.2	0	165	4	58	111	TIA32914.1 hypothetical protein D6C79_09091 [Aureobasidium pullulans]	diamond	1620	98.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium pullulans
28763700	28763700	PRJEB55122_P_NODE_32007_length_184_cov_1.540741_g31610_i0	PRJEB55122	32007	184	1.540741	2.83496344	Sporocadaceae	1812776	Fungi	Fungi	94.4	1.09e-20	NR	KAK6066447.1	138065	g31610	i0	85	2.83695652173913	60	9	97.8	0	3	182	243	302	KAK6066447.1 hypothetical protein SCUP234_12107 [Seiridium cupressi]	diamond	522	94.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Amphisphaeriales	Sporocadaceae	Seiridium	Seiridium cupressi
30033677	30033677	PRJEB55122_P_NODE_40311_length_165_cov_0.896552_g39914_i0	PRJEB55122	40311	165	0.896552	1.4793108	Alternaria alternata	5599	Fungi	Fungi	43.9	0.00521	NR	XP_018390487.1	5599	g39914	i0	65.9	1.8	44	14	78.2	1	37	165	313	356	XP_018390487.1 hypothetical protein CC77DRAFT_1004729 [Alternaria alternata]	diamond	297	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Alternaria	Alternaria alternata
30191438	30191438	PRJEB55122_P_NODE_13632_length_325_cov_1.315217_g13235_i0	PRJEB55122	13632	325	1.315217	4.27445525	Alternaria alternata	5599	Fungi	Fungi	43.5	0.0346	NR	KAH8637649.1	5599	g13235	i0	34.5	0.507692307692308	55	36	50.8	0	296	132	96	150	KAH8637649.1 hypothetical protein IG631_09484 [Alternaria alternata]	diamond	165	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Alternaria	Alternaria alternata
30223076	30223076	PRJEB55122_P_NODE_43292_length_162_cov_0.920354_g42895_i0	PRJEB55122	43292	162	0.920354	1.49097348	Sarocladium strictum	5046	Fungi	Fungi	80.1	8.16e-16	NR	KAK0391648.1	5046	g42895	i0	86	0.796296296296296	43	6	79.6	0	32	160	269	311	KAK0391648.1 hypothetical protein NLU13_1147 [Sarocladium strictum]	diamond	129	80.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
31676943	31676943	PRJEB55122_P_NODE_42497_length_163_cov_0.912281_g42100_i0	PRJEB55122	42497	163	0.912281	1.48701803	Pseudogymnoascus sp.	1891168	Fungi	Fungi	78.2	2.55e-15	NR	OBT90321.1	1622148	g42100	i0	72.2	7.93251533742331	54	15	99.4	0	162	1	186	239	OBT90321.1 hypothetical protein VE02_03360 [Pseudogymnoascus sp. 03VT05]	diamond	1293	78.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Thelebolales	Thelebolaceae	Pseudogymnoascus	Pseudogymnoascus sp. 03VT05

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