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

10 rows where analysis = "diamond", bioproject = "PRJEB8827" 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
25802054	25802054	PRJEB8827f_S_NODE_2611_length_266_cov_2.077922_g2591_i0	PRJEB8827	2611	266	2.077922	5.52727252	Cyberlindnera fabianii	36022	Fungi	Fungi	60.5	4.31e-9	NR	CDR47425.1	36022	g2591	i0	64.6	0.541353383458647	48	14	50.8	1	264	130	90	137	CDR47425.1 CYFA0S32e00188g1_1 [Cyberlindnera fabianii]	diamond	144	60.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Phaffomycetales	Phaffomycetaceae	Cyberlindnera	Cyberlindnera fabianii
26482962	26482962	PRJEB8827h_S_NODE_2952_length_215_cov_1.938889_g2933_i0	PRJEB8827	2952	215	1.938889	4.16861135	root	1	Root_unresolved	Root_unresolved	58.5	6.4e-9	NR	NP_594857.1	4896	g2933	i0	81.3	8.03720930232558	32	6	44.7	0	195	100	84	115	NP_594857.1 60S ribosomal protein eL30 [Schizosaccharomyces pombe]	diamond	1728	58.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Schizosaccharomycetes	Schizosaccharomycetales	Schizosaccharomycetaceae	Schizosaccharomyces	Schizosaccharomyces pombe
32913941	32913941	PRJEB8827e_S_NODE_34049_length_164_cov_4.054264_g34021_i0	PRJEB8827	34049	164	4.054264	6.64899296	Kockiozyma suomiensis	1337062	Fungi	Fungi	43.9	0.00269	NR	XP_066765151.1	1337062	g34021	i0	39.6	0.969512195121951	53	32	97	0	159	1	35	87	XP_066765151.1 ubiquitin-related domain-containing protein [Kockiozyma suomiensis]	diamond	159	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Kockiozyma	Kockiozyma suomiensis
32914158	32914158	PRJEB8827h_S_NODE_2457_length_222_cov_4.320856_g2438_i0	PRJEB8827	2457	222	4.320856	9.59230032	Myotisia sp. PD_48	2135911	Fungi	Fungi	54.7	7.35e-7	NR	KAK2739774.1	2135911	g2438	i0	50	1.39189189189189	52	26	70.3	0	3	158	127	178	KAK2739774.1 40S ribosomal protein S9 [Myotisia sp. PD_48]	diamond	309	54.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Onygenales		Myotisia	Myotisia sp. PD_48
32923282	32923282	PRJEB8827h_S_NODE_10201_length_191_cov_1.993590_g10182_i0	PRJEB8827	10201	191	1.99359	3.8077569000000002	Sordariomycetes	147550	Fungi	Fungi	55.1	4.01e-7	NR	XP_035322026.1	1094350	g10182	i0	59.1	5.40314136125654	44	18	69.1	0	3	134	157	200	XP_035322026.1 large subunit ribosomal protein L6e [Geosmithia morbida]	diamond	1032	55.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Bionectriaceae	Geosmithia	Geosmithia morbida
32923286	32923286	PRJEB8827h_S_NODE_5337_length_201_cov_2.789157_g5318_i0	PRJEB8827	5337	201	2.789157	5.60620557	Fungi	4751	Fungi	Fungi	45.1	5.21e-4	NR	TID13282.1	52247	g5318	i0	41.9	5.14925373134328	43	25	64.2	0	199	71	36	78	TID13282.1 hypothetical protein CANINC_004968 [Pichia inconspicua]	diamond	1035	45.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Pichia	Pichia inconspicua
33033718	33033718	PRJEB8827f_S_NODE_20028_length_165_cov_6.361538_g20008_i0	PRJEB8827	20028	165	6.361538	10.4965377	Hypomontagnella monticulosa	2487000	Fungi	Fungi	41.2	0.0449	NR	KAI0376501.1	2487000	g20008	i0	48.8	0.745454545454545	41	20	74.5	1	20	142	228	267	KAI0376501.1 hypothetical protein F5Y04DRAFT_285808 [Hypomontagnella monticulosa]	diamond	123	41.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Hypoxylaceae	Hypomontagnella	Hypomontagnella monticulosa
33119021	33119021	PRJEB8827g_S_NODE_1471_length_255_cov_3481.763636_g1450_i0	PRJEB8827	1471	255	3481.763636	8878.4972718	Byssothecium circinans	147558	Fungi	Fungi	44.3	0.00117	NR	KAF1948084.1	147558	g1450	i0	62.9	0.835294117647059	35	13	41.2	0	104	208	9	43	KAF1948084.1 hypothetical protein CC80DRAFT_57283 [Byssothecium circinans]	diamond	213	44.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Massarinaceae	Byssothecium	Byssothecium circinans
33128202	33128202	PRJEB8827d_S_NODE_911_length_227_cov_2.421875_g907_i0	PRJEB8827	911	227	2.421875	5.49765625	Ascomycota	4890	Fungi	Fungi	45.8	2.13e-4	NR	KAF1948084.1	147558	g907	i0	59.5	2.12775330396476	37	15	48.9	0	152	42	9	45	KAF1948084.1 hypothetical protein CC80DRAFT_57283 [Byssothecium circinans]	diamond	483	46.2	0.991341991341991	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Massarinaceae	Byssothecium	Byssothecium circinans
33135997	33135997	PRJEB8827e_S_NODE_6623_length_205_cov_3.258824_g6595_i0	PRJEB8827	6623	205	3.258824	6.6805892	Exophiala mesophila	212818	Fungi	Fungi	43.1	0.00237	NR	RVX67386.1	212818	g6595	i0	47.5	0.892682926829268	61	29	89.3	1	190	8	13	70	RVX67386.1 hypothetical protein B0A52_09167 [Exophiala mesophila]	diamond	183	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Exophiala	Exophiala mesophila

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