metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB7799" 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
32912669	32912669	PRJEB7799a_S_NODE_17601_length_156_cov_2.289256_g17566_i0	PRJEB7799	17601	156	2.289256	3.57123936	Lactarius akahatsu	416441	Fungi	Fungi	45.8	7.77e-4	NR	KAH8993511.1	416441	g17566	i0	42.6	0.903846153846154	47	25	90.4	1	12	152	179	223	KAH8993511.1 hypothetical protein EDB92DRAFT_2113825 [Lactarius akahatsu]	diamond	141	45.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Lactarius	Lactarius akahatsu
32940387	32940387	PRJEB7799h_S_NODE_9921_length_152_cov_2.598291_g9918_i0	PRJEB7799	9921	152	2.598291	3.94940232	Tulasnella	5240	Fungi	Fungi	46.6	1.14e-4	NR	KAG8921424.1	2600226	g9918	i0	71	1.22368421052632	31	9	61.2	0	148	56	82	112	KAG8921424.1 60S ribosomal protein L28 [Tulasnella sp. 418]	diamond	186	46.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 418
33101669	33101669	PRJEB7799p_S_NODE_7454_length_207_cov_2.232558_g7431_i0	PRJEB7799	7454	207	2.232558	4.62139506	Malassezia equina	1381935	Fungi	Fungi	43.5	0.00131	NR	WFD24263.1	1381935	g7431	i0	51.1	0.652173913043478	45	22	65.2	0	189	55	16	60	WFD24263.1 60S ribosomal protein L38 [Malassezia equina]	diamond	135	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia equina
33110937	33110937	PRJEB7799c_S_NODE_21806_length_160_cov_1.280000_g21783_i0	PRJEB7799	21806	160	1.28	2.048	Fungi	4751	Fungi	Fungi	111	8.68e-27	NR	KAG9220927.1	5321	g21783	i0	90.4	9.75	52	5	97.5	0	158	3	323	374	KAG9220927.1 hypothetical protein CCMSSC00406_0002473 [Pleurotus cornucopiae]	diamond	1560	112	0.991071428571429	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus cornucopiae
33111046	33111046	PRJEB7799p_S_NODE_5606_length_226_cov_1.481675_g5583_i0	PRJEB7799	5606	226	1.481675	3.3485855	Microbotryum	34416	Fungi	Fungi	55.8	1.26e-7	NR	SCZ97658.1	289078	g5583	i0	63.3	1.93805309734513	49	17	65	1	226	80	87	134	SCZ97658.1 BZ3500_MvSof-1268-A1-R1_Chr4-3g07343 [Microbotryum saponariae]	diamond	438	55.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Microbotryales	Microbotryaceae	Microbotryum	Microbotryum saponariae
33118100	33118100	PRJEB7799k_S_NODE_6015_length_180_cov_1.924138_g6009_i0	PRJEB7799	6015	180	1.924138	3.4634484	Tulasnella sp. UAMH 9824	2601502	Fungi	Fungi	91.7	7.31e-20	NR	KAG9050358.1	2601502	g6009	i0	69.5	4.91666666666667	59	18	98.3	0	179	3	364	422	KAG9050358.1 translation elongation factor EF-1 alpha [Tulasnella sp. UAMH 9824]	diamond	885	91.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. UAMH 9824
33145259	33145259	PRJEB7799n_S_NODE_2255_length_286_cov_5.701195_g2218_i0	PRJEB7799	2255	286	5.701195	16.3054177	Tulasnella	5240	Fungi	Fungi	70.5	5.12e-13	NR	KAG8920536.1	2600225	g2218	i0	55.4	1.55244755244755	74	29	73.4	1	5	214	62	135	KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417]	diamond	444	70.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 417
33169764	33169764	PRJEB7799p_S_NODE_14640_length_178_cov_1.958042_g14617_i0	PRJEB7799	14640	178	1.958042	3.48531476	Gymnopus androsaceus JB14	1447944	Fungi	Fungi	41.6	0.011	NR	KAE9386828.1	1447944	g14617	i0	50	0.808988764044944	48	23	80.9	1	145	2	27	73	KAE9386828.1 hypothetical protein BT96DRAFT_507124 [Gymnopus androsaceus JB14]	diamond	144	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Gymnopus	Gymnopus androsaceus

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