metadata: contig_metadata: 6 rows where bioproject = "PRJNA1253303", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA1253303", tax_clade = "Opisthokonta" 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
359431	359431	PRJNA1253303_P_NODE_8201_length_243_cov_0.917647_g8179_i0	PRJNA1253303	8201	243	0.917647	2.22988221	Cyathus striatus	68777	Fungi	Fungi	144	1.71e-42	NR	KAF9008724.1	68777	g8179	i0	85.7	1.91358024691358	77	11	95.1	0	239	9	39	115	KAF9008724.1 ribosomal protein S27-domain-containing protein [Cyathus striatus]	diamond	465	144	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Nidulariaceae	Cyathus	Cyathus striatus
5462836	5462836	PRJNA1253303_P_NODE_7345_length_246_cov_0.901734_g7323_i0	PRJNA1253303	7345	246	0.901734	2.21826564	Cryptococcus amylolentus	104669	Fungi	Fungi	178	3.5099999999999993e-40	NTclustered	gi\|1101782768\|ref\|XM_019134367.1\|	1295533	g7323	i0	84.043	24.1585365853659	188	26	76	3	1	186	1518	1703	Cryptococcus amylolentus CBS 6039 ATP-dependent RNA helicase ded1 (L202_01067), mRNA	blastn	5943	178	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus amylolentus
9980618	9980618	PRJNA1253303_P_NODE_7268_length_246_cov_0.901734_g7246_i0	PRJNA1253303	7268	246	0.901734	2.21826564	Agaricomycetes	155619	Fungi	Fungi	161	8.99e-44	NR	KAH8120070.1	127956	g7246	i0	94.9	19.9878048780488	78	4	95.1	0	246	13	953	1030	KAH8120070.1 P-loop containing nucleoside triphosphate hydrolase protein [Phellopilus nigrolimitatus]	diamond	4917	162	0.993827160493827	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Hymenochaetaceae	Phellopilus	Phellopilus nigrolimitatus
14388565	14388565	PRJNA1253303_P_NODE_4752_length_256_cov_1.644809_g4730_i0	PRJNA1253303	4752	256	1.644809	4.21071104	Eukaryota	2759	Fungi	Fungi	141	8.609999999999999e-37	NR	XP_052948313.1	4972	g4730	i0	78.6	190.91015625	84	18	98.4	0	253	2	35	118	XP_052948313.1 uncharacterized protein MKK02DRAFT_36225 [Dioszegia hungarica]	diamond	48873	142	0.992957746478873	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Bulleribasidiaceae	Dioszegia	Dioszegia hungarica
21454432	21454432	PRJNA1253303_P_NODE_8517_length_242_cov_0.923077_g8495_i0	PRJNA1253303	8517	242	0.923077	2.23384634	Violaceomyces palustris	1673888	Fungi	Fungi	144	7.34e-40	NR	PWN50398.1	1673888	g8495	i0	87.5	2.97520661157025	80	10	99.2	0	3	242	149	228	PWN50398.1 GroES-like protein [Violaceomyces palustris]	diamond	720	144	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Violaceomycetales	Violaceomycetaceae	Violaceomyces	Violaceomyces palustris
30471019	30471019	PRJNA1253303_P_NODE_8453_length_242_cov_0.923077_g8431_i0	PRJNA1253303	8453	242	0.923077	2.23384634	Polyporales	5303	Fungi	Fungi	80.1	2.64e-16	NR	XP_047892774.1	139415	g8431	i0	51.3	3.96694214876033	80	38	99.2	1	240	1	101	179	XP_047892774.1 40S ribosomal protein S8 [Fomitopsis serialis]	diamond	960	80.9	0.990111248454882	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Fomitopsidaceae	Fomitopsis	Fomitopsis serialis

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