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

8 rows where analysis = "diamond", bioproject = "PRJNA1101946" 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
211284	211284	PRJNA1101946_S_NODE_5481_length_303_cov_4.830709_g5382_i0	PRJNA1101946	5481	303	4.830709	14.63704827	Rhodotorula diobovata	5288	Fungi	Fungi	99	2.31e-24	NR	TNY20462.1	5288	g5382	i0	77.1	0.693069306930693	70	14	67.3	2	290	87	44	113	TNY20462.1 hypothetical protein DMC30DRAFT_251588 [Rhodotorula diobovata]	diamond	210	99	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula diobovata
26972660	26972660	PRJNA1101946_S_NODE_12242_length_228_cov_1.932961_g12143_i0	PRJNA1101946	12242	228	1.932961	4.40715108	Hericium alpestre	135208	Fungi	Fungi	110	1.24e-26	NR	TFY82181.1	135208	g12143	i0	78.3	4.38157894736842	69	15	90.8	0	9	215	317	385	TFY82181.1 hypothetical protein EWM64_g1832 [Hericium alpestre]	diamond	999	110	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Hericiaceae	Hericium	Hericium alpestre
27248634	27248634	PRJNA1101946_S_NODE_8483_length_263_cov_3.336449_g8384_i0	PRJNA1101946	8483	263	3.336449	8.77486087	Pleurotus	5320	Fungi	Fungi	107	6.3399999999999995e-25	NR	KAG9224806.1	5321	g8384	i0	75	6.87832699619772	60	15	68.4	0	6	185	988	1047	KAG9224806.1 hypothetical protein CCMSSC00406_0002043 [Pleurotus cornucopiae]	diamond	1809	107	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus cornucopiae
28038233	28038233	PRJNA1101946_S_NODE_18565_length_187_cov_2.847826_g18466_i0	PRJNA1101946	18565	187	2.847826	5.32543462	Agaricomycetes	155619	Fungi	Fungi	56.2	2.96e-7	NR	KAF4574962.1	28995	g18466	i0	83.3	2.32620320855615	30	5	48.1	0	33	122	503	532	KAF4574962.1 Phenylalanyl-tRNA synthetase, beta subunit, cytoplasmic [Pleurotus pulmonarius]	diamond	435	56.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus pulmonarius
30825899	30825899	PRJNA1101946_S_NODE_8814_length_259_cov_45.876190_g8715_i0	PRJNA1101946	8814	259	45.87619	118.8193321	Rhizoctonia solani	456999	Fungi	Fungi	43.5	0.0241	NR	KAJ1311228.1	456999	g8715	i0	38.8	0.776061776061776	67	38	74.1	2	209	18	415	481	KAJ1311228.1 hypothetical protein OPQ81_009728 [Rhizoctonia solani]	diamond	201	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
30952511	30952511	PRJNA1101946_S_NODE_20454_length_178_cov_2.333333_g20355_i0	PRJNA1101946	20454	178	2.333333	4.15333274	Phaffia rhodozyma	264483	Fungi	Fungi	84.3	1.37e-17	NR	CDZ96598.1	264483	g20355	i0	72.5	0.859550561797753	51	14	86	0	26	178	252	302	CDZ96598.1 Reductases with broad range of substrate specificities [Phaffia rhodozyma]	diamond	153	84.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
31932523	31932523	PRJNA1101946_S_NODE_26957_length_154_cov_7.647619_g26858_i0	PRJNA1101946	26957	154	7.647619	11.77733326	Phaffia rhodozyma	264483	Fungi	Fungi	41.6	0.0291	NR	CDZ96523.1	264483	g26858	i0	45.5	0.642857142857143	33	18	64.3	0	105	7	400	432	CDZ96523.1 Uncharacterized conserved protein, contains BSD domain [Phaffia rhodozyma]	diamond	99	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
32691236	32691236	PRJNA1101946_S_NODE_7420_length_276_cov_3.202643_g7321_i0	PRJNA1101946	7420	276	3.202643	8.83929468	Athelia psychrophila	1759441	Fungi	Fungi	68.9	3.4e-11	NR	KZP34738.1	1759441	g7321	i0	67.3	0.532608695652174	49	16	53.3	0	2	148	1192	1240	KZP34738.1 hypothetical protein FIBSPDRAFT_772561 [Athelia psychrophila]	diamond	147	68.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Atheliales	Atheliaceae	Athelia	Athelia psychrophila

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