metadata: contig_metadata: 5 rows where bioproject = "PRJNA772154", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA772154", 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
1206781	1206781	PRJNA772154_P_NODE_20761_length_246_cov_0.901734_g20576_i0	PRJNA772154	20761	246	0.901734	2.21826564	Agaricomycetes	155619	Fungi	Fungi	202	2.08e-47	NTclustered	gi\|530408090\|gb\|JX989002.1\|	456999	g20576	i0	90.446	70.4065040650407	157	9	64	4	90	246	370	220	Rhizoctonia solani strain AG-6_HGI isolate 70Rs 28S ribosomal RNA gene, partial sequence	blastn	17320	204	0.990196078431373	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
8400580	8400580	PRJNA772154_P_NODE_17727_length_253_cov_0.866667_g17542_i0	PRJNA772154	17727	253	0.866667	2.19266751	Vanrija pseudolonga	143232	Fungi	Fungi	244	3.53e-60	NTclustered	gi\|2669757741\|ref\|XM_062773652.1\|	143232	g17542	i0	93.865	0.644268774703557	163	8	64	2	62	223	416	577	Vanrija pseudolonga uncharacterized protein (LOC62_05G007130), partial mRNA	blastn	163	244	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Vanrija	Vanrija pseudolonga
15235311	15235311	PRJNA772154_P_NODE_20092_length_248_cov_0.891429_g19907_i0	PRJNA772154	20092	248	0.891429	2.21074392	Curvibasidium	256806	Fungi	Fungi	459	1.13e-124	NTclustered	gi\|2235263546\|gb\|ON428531.1\|	106008	g19907	i0	100	100	248	0	100	0	1	248	537	290	Curvibasidium cygneicollum isolate UASWS2879 NBB-B02 large subunit ribosomal RNA gene, partial sequence	blastn	24800	459	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes			Curvibasidium	Curvibasidium cygneicollum
23700380	23700380	PRJNA772154_P_NODE_21359_length_245_cov_0.906977_g21174_i0	PRJNA772154	21359	245	0.906977	2.22209365	Terana coerulea	40462	Fungi	Fungi	63.9	1.02e-5	NTclustered	gi\|25987106\|gb\|AF214460.1\|	40462	g21174	i0	100	0.428571428571429	34	0	14	0	1	34	292	259	Pulcherricium caeruleum small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product	blastn	105	63.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Phanerochaetaceae	Terana	Terana coerulea
32139781	32139781	PRJNA772154_P_NODE_9258_length_379_cov_1.235294_g9073_i0	PRJNA772154	9258	379	1.235294	4.68176426	Scleroderma citrinum Foug A	1036808	Fungi	Fungi	48.9	1.31e-4	NR	KIM66722.1	1036808	g9073	i0	51.1	0.372031662269129	47	23	37.2	0	123	263	51	97	KIM66722.1 hypothetical protein SCLCIDRAFT_75972, partial [Scleroderma citrinum Foug A]	diamond	141	48.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Sclerodermataceae	Scleroderma	Scleroderma citrinum

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