metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA771359" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA771359" 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
29588777	29588777	PRJNA771359_S_NODE_5150_length_151_cov_2.035088_g5067_i0	PRJNA771359	5150	151	2.035088	3.07298288	Basidiomycota	5204	Fungi	Fungi	75.5	1.58e-15	NR	TFK74787.1	181527	g5067	i0	69.4	18.4569536423841	49	15	97.4	0	149	3	25	73	TFK74787.1 ribosomal protein S19e [Pluteus cervinus]	diamond	2787	75.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pluteaceae	Pluteus	Pluteus cervinus
29588778	29588778	PRJNA771359_S_NODE_890_length_343_cov_2.624183_g807_i0	PRJNA771359	890	343	2.624183	9.00094769	Moesziomyces	63261	Fungi	Fungi	91.7	8.49e-19	NR	XP_014658689.1	84753	g807	i0	50.5	2.91253644314869	111	50	92.7	1	5	322	694	804	XP_014658689.1 60S ribosomal protein L24 [Moesziomyces antarcticus]	diamond	999	91.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Moesziomyces	Moesziomyces antarcticus
29610820	29610820	PRJNA771359_S_NODE_2610_length_207_cov_2.035294_g2527_i0	PRJNA771359	2610	207	2.035294	4.21305858	Naganishia cerealis	610337	Fungi	Fungi	62.8	2.35e-10	NR	KAJ9112376.1	610337	g2527	i0	44.4	0.91304347826087	63	35	91.3	0	200	12	11	73	KAJ9112376.1 hypothetical protein QFC19_000797 [Naganishia cerealis]	diamond	189	62.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia cerealis
30347732	30347732	PRJNA771359_S_NODE_3292_length_185_cov_1.554054_g3209_i0	PRJNA771359	3292	185	1.554054	2.8749999	root	1	Root_unresolved	Root_unresolved	66.6	1.32e-11	NR	GAA5865959.1	86832	g3209	i0	55.8	7.73513513513513	52	23	84.3	0	185	30	121	172	GAA5865959.1 hypothetical protein JCM3774_005538 [Rhodotorula dairenensis]	diamond	1431	67	0.994029850746269	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula dairenensis
31579983	31579983	PRJNA771359_S_NODE_4656_length_158_cov_0.958678_g4573_i0	PRJNA771359	4656	158	0.958678	1.51471124	Eukaryota	2759	Fungi	Fungi	87.4	2.1e-18	NR	POW05985.1	27350	g4573	i0	75	12.8354430379747	52	13	98.7	0	158	3	264	315	POW05985.1 hypothetical protein PSHT_10567 [Puccinia striiformis]	diamond	2028	88.2	0.99092970521542	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia striiformis

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