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

10 rows where analysis = "diamond", bioproject = "PRJNA1196384" 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
322687	322687	PRJNA1196384_S_NODE_3761_length_204_cov_1.395210_g3697_i0	PRJNA1196384	3761	204	1.39521	2.8462284	root	1	Root_unresolved	Root_unresolved	125	2.1e-32	NR	CAE6491370.1	456999	g3697	i0	82.1	21.6764705882353	67	12	98.5	0	203	3	292	358	CAE6491370.1 unnamed protein product [Rhizoctonia solani]	diamond	4422	125	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
19448725	19448725	PRJNA1196384_S_NODE_3956_length_199_cov_2.166667_g3892_i0	PRJNA1196384	3956	199	2.166667	4.31166733	Sphaerobolus stellatus SS14	990650	Fungi	Fungi	63.2	2.21e-10	NR	KIJ47029.1	990650	g3892	i0	52.2	0.693467336683417	46	22	69.3	0	4	141	114	159	KIJ47029.1 hypothetical protein M422DRAFT_28999 [Sphaerobolus stellatus SS14]	diamond	138	63.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Geastrales	Sphaerobolaceae	Sphaerobolus	Sphaerobolus stellatus
26742884	26742884	PRJNA1196384_S_NODE_5541_length_175_cov_1.086957_g5477_i0	PRJNA1196384	5541	175	1.086957	1.90217475	root	1	Root_unresolved	Root_unresolved	62.8	2.83e-10	NR	PPQ94467.1	93625	g5477	i0	50.9	1.97142857142857	57	28	97.7	0	4	174	42	98	PPQ94467.1 hypothetical protein CVT25_001148 [Psilocybe cyanescens]	diamond	345	63.2	0.993670886075949	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Psilocybe	Psilocybe cyanescens
26933272	26933272	PRJNA1196384_S_NODE_4782_length_185_cov_1.317568_g4718_i0	PRJNA1196384	4782	185	1.317568	2.4375008	Opisthokonta	33154	Fungi	Fungi	67.4	3.42e-11	NR	KLO14811.1	27342	g4718	i0	67.4	2.23783783783784	46	15	74.6	0	23	160	497	542	KLO14811.1 isocitrate lyase [Schizopora paradoxa]	diamond	414	67.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Schizoporaceae	Schizopora	Schizopora paradoxa
27325351	27325351	PRJNA1196384_S_NODE_2843_length_230_cov_3.398964_g2779_i0	PRJNA1196384	2843	230	3.398964	7.8176172	Tricholoma furcatifolium	2724999	Fungi	Fungi	51.6	2.29e-5	NR	KAG6830629.1	2724999	g2779	i0	44.3	0.795652173913043	61	30	74.3	2	223	53	29	89	KAG6830629.1 hypothetical protein H0H92_015721 [Tricholoma furcatifolium]	diamond	183	51.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Tricholomataceae	Tricholoma	Tricholoma furcatifolium
27546411	27546411	PRJNA1196384_S_NODE_3144_length_219_cov_2.719780_g3080_i0	PRJNA1196384	3144	219	2.71978	5.9563182	Clathrus columnatus	1419009	Fungi	Fungi	42.4	0.0357	NR	GJJ07375.1	1419009	g3080	i0	51.1	0.616438356164384	45	20	61.6	1	3	137	281	323	GJJ07375.1 hypothetical protein Clacol_001577 [Clathrus columnatus]	diamond	135	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Phallales	Clathraceae	Clathrus	Clathrus columnatus
28051564	28051564	PRJNA1196384_S_NODE_7685_length_155_cov_1.644068_g7621_i0	PRJNA1196384	7685	155	1.644068	2.5483054	Acaromyces ingoldii	215250	Fungi	Fungi	53.5	9.59e-7	NR	XP_025379156.1	215250	g7621	i0	60	1.76129032258065	45	18	87.1	0	154	20	159	203	XP_025379156.1 putative RPL15A 60S large subunit ribosomal protein L15.e [Acaromyces ingoldii]	diamond	273	53.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Exobasidiales	Cryptobasidiaceae	Acaromyces	Acaromyces ingoldii
28702132	28702132	PRJNA1196384_S_NODE_7407_length_157_cov_1.341667_g7343_i0	PRJNA1196384	7407	157	1.341667	2.10641719	Eukaryota	2759	Fungi	Fungi	105	9.24e-25	NR	KAF7303334.1	1325293	g7343	i0	92.3	43.7006369426752	52	4	99.4	0	156	1	8	59	KAF7303334.1 hypothetical protein MKEN_01297700 [Mycena kentingensis (nom. inval.)]	diamond	6861	106	0.990566037735849	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena kentingensis (nom. inval.)
31621021	31621021	PRJNA1196384_S_NODE_8216_length_152_cov_0.991304_g8152_i0	PRJNA1196384	8216	152	0.991304	1.50678208	Melampsora americana	2182807	Fungi	Fungi	42	0.0204	NR	KAH9823142.1	2182807	g8152	i0	50	0.75	38	19	75	0	135	22	19	56	KAH9823142.1 PHD-zinc-finger like domain-containing protein [Melampsora americana]	diamond	114	42	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Melampsoraceae	Melampsora	Melampsora americana
32557828	32557828	PRJNA1196384_S_NODE_1359_length_332_cov_4.772881_g1295_i0	PRJNA1196384	1359	332	4.772881	15.84596492	Fungi	4751	Fungi	Fungi	130	6.07e-37	NR	KAI3625218.1	55194	g1295	i0	63.2	5.97289156626506	95	35	85.8	0	331	47	10	104	KAI3625218.1 hypothetical protein CBS9595_000579 [Malassezia furfur]	diamond	1983	130	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia furfur

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