metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1098727" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1098727" and tax_phylum = "Basidiomycota"

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
26909495	26909495	PRJNA1098727_P_NODE_12942_length_169_cov_0.866667_g12701_i0	PRJNA1098727	12942	169	0.866667	1.46466723	Puccinia sorghi	27349	Fungi	Fungi	116	5.45e-29	NR	KNZ62209.1	27349	g12701	i0	92.9	1.98816568047337	56	4	99.4	0	2	169	270	325	KNZ62209.1 glutamine synthetase [Puccinia sorghi]	diamond	336	116	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia sorghi
27604911	27604911	PRJNA1098727_P_NODE_13944_length_166_cov_0.888889_g13703_i0	PRJNA1098727	13944	166	0.888889	1.47555574	Puccinia coronata f. sp. avenae	200324	Fungi	Fungi	112	1.2e-27	NR	PLW48889.1	200324	g13703	i0	96.4	0.993975903614458	55	2	99.4	0	1	165	325	379	PLW48889.1 hypothetical protein PCASD_02824 [Puccinia coronata f. sp. avenae]	diamond	165	112	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia coronata
27880243	27880243	PRJNA1098727_P_NODE_10685_length_185_cov_1.750000_g10444_i0	PRJNA1098727	10685	185	1.75	3.2375	Vanrija	1851468	Fungi	Fungi	75.5	4.71e-14	NR	XP_062625329.1	143232	g10444	i0	60.8	2.72432432432432	51	20	82.7	0	28	180	251	301	XP_062625329.1 uncharacterized protein LOC62_02G002828 [Vanrija pseudolonga]	diamond	504	75.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Vanrija	Vanrija pseudolonga
28109790	28109790	PRJNA1098727_P_NODE_13585_length_167_cov_0.881356_g13344_i0	PRJNA1098727	13585	167	0.881356	1.47186452	Naganishia liquefaciens	104408	Fungi	Fungi	97.4	1.2e-23	NR	GHJ88444.1	104408	g13344	i0	88.9	0.970059880239521	54	6	97	0	3	164	43	96	GHJ88444.1 hypothetical protein NliqN6_4846 [Naganishia liquefaciens]	diamond	162	97.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia liquefaciens
28552119	28552119	PRJNA1098727_P_NODE_5827_length_262_cov_0.971831_g5586_i0	PRJNA1098727	5827	262	0.971831	2.54619722	Puccinia coronata f. sp. avenae	200324	Fungi	Fungi	57.4	3.28e-7	NR	PLW20004.1	200324	g5586	i0	40.9	2.01526717557252	88	41	88.2	4	259	29	290	377	PLW20004.1 hypothetical protein PCANC_10205 [Puccinia coronata f. sp. avenae]	diamond	528	57.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia coronata
29688322	29688322	PRJNA1098727_P_NODE_15250_length_163_cov_0.912281_g15009_i0	PRJNA1098727	15250	163	0.912281	1.48701803	Guyanagaster necrorhizus MCA 395	856835	Fungi	Fungi	46.6	5.42e-4	NR	XP_043034996.1	1450536	g15009	i0	78.3	3.34969325153374	23	5	42.3	0	40	108	87	109	XP_043034996.1 alpha/beta-hydrolase [Guyanagaster necrorhizus MCA 3950]	diamond	546	46.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Guyanagaster	Guyanagaster necrorhizus
30478498	30478498	PRJNA1098727_P_NODE_15913_length_162_cov_0.920354_g15672_i0	PRJNA1098727	15913	162	0.920354	1.49097348	Coprinopsis sp. MPI-PUGE-AT-	1859955	Fungi	Fungi	101	5.39e-24	NR	KAH6912635.1	2826081	g15672	i0	98.1	0.981481481481482	53	1	98.1	0	160	2	185	237	KAH6912635.1 2-nitropropane dioxygenase [Coprinopsis sp. MPI-PUGE-AT-0042]	diamond	159	101	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Psathyrellaceae	Coprinopsis	Coprinopsis sp. MPI-PUGE-AT-0042
31481395	31481395	PRJNA1098727_P_NODE_13276_length_168_cov_0.873950_g13035_i0	PRJNA1098727	13276	168	0.87395	1.468236	Agaricales	5338	Fungi	Fungi	91.7	5.77e-20	NR	KAF9462957.1	64659	g13035	i0	83.6	2.94642857142857	55	9	98.2	0	3	167	363	417	KAF9462957.1 SAC3/GANP/Nin1/mts3/eIF-3 p25 family-domain-containing protein [Collybia nuda]	diamond	495	91.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Clitocybaceae	Collybia	Collybia nuda
31774312	31774312	PRJNA1098727_P_NODE_2237_length_460_cov_1.661800_g2001_i0	PRJNA1098727	2237	460	1.6618	7.64428	Mycena galopus ATCC 62	41248	Fungi	Fungi	47.4	0.00333	NR	KAF8146155.1	1314675	g2001	i0	35.5	0.606521739130435	93	54	57.4	3	64	327	13	104	KAF8146155.1 hypothetical protein K438DRAFT_1870451 [Mycena galopus ATCC 62051]	diamond	279	47.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena galopus
32154115	32154115	PRJNA1098727_P_NODE_13978_length_166_cov_0.888889_g13737_i0	PRJNA1098727	13978	166	0.888889	1.47555574	Naganishia liquefaciens	104408	Fungi	Fungi	79	1.96e-16	NR	GHJ90383.1	104408	g13737	i0	100	0.668674698795181	37	0	66.9	0	2	112	159	195	GHJ90383.1 hypothetical protein NliqN6_6785 [Naganishia liquefaciens]	diamond	111	79	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia liquefaciens
32439109	32439109	PRJNA1098727_P_NODE_15519_length_162_cov_1.831858_g15278_i0	PRJNA1098727	15519	162	1.831858	2.96760996	Phaffia rhodozyma	264483	Fungi	Fungi	46.2	7.28e-4	NR	CDZ96529.1	264483	g15278	i0	47.9	0.888888888888889	48	25	88.9	0	145	2	356	403	CDZ96529.1 hexokinase [Phaffia rhodozyma]	diamond	144	46.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
32597025	32597025	PRJNA1098727_P_NODE_13080_length_168_cov_1.159664_g12839_i0	PRJNA1098727	13080	168	1.159664	1.94823552	Puccinia triticina	208348	Fungi	Fungi	51.2	3.9e-6	NR	XP_053027383.1	208348	g12839	i0	54.9	1.82142857142857	51	20	91.1	1	163	11	96	143	XP_053027383.1 uncharacterized protein PtA15_15A220 [Puccinia triticina]	diamond	306	51.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia triticina

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