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

5 rows where analysis = "diamond", bioproject = "PRJNA891846" 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
13621018	13621018	PRJNA891846_P_NODE_39151_length_249_cov_0.875000_g38931_i0	PRJNA891846	39151	249	0.875	2.17875	Rhizoctonia	1322061	Fungi	Fungi	112	9.14e-27	NR	CAE7191834.1	456999	g38931	i0	73.6	8.72289156626506	72	19	86.7	0	217	2	1	72	CAE7191834.1 unnamed protein product [Rhizoctonia solani]	diamond	2172	112	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
28003349	28003349	PRJNA891846_P_NODE_20965_length_334_cov_1.130268_g20746_i0	PRJNA891846	20965	334	1.130268	3.77509512	Roridomyces roridus	1738132	Fungi	Fungi	43.5	0.0211	NR	KAJ7615916.1	1738132	g20746	i0	40.9	0.835329341317365	93	41	76.3	7	326	72	43	129	KAJ7615916.1 hypothetical protein FB45DRAFT_757724 [Roridomyces roridus]	diamond	279	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Roridomyces	Roridomyces roridus
29368660	29368660	PRJNA891846_P_NODE_47529_length_241_cov_0.916667_g47309_i0	PRJNA891846	47529	241	0.916667	2.20916747	Ceraceosorus	401624	Fungi	Fungi	51.2	3.67e-5	NR	CEH13077.1	401625	g47309	i0	71	0.784232365145228	31	9	38.6	0	93	1	169	199	CEH13077.1 hypothetical protein CBOM_01020 [Ceraceosorus bombacis]	diamond	189	51.6	0.992248062015504	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Ceraceosorales	Ceraceosoraceae	Ceraceosorus	Ceraceosorus bombacis
30813838	30813838	PRJNA891846_P_NODE_44214_length_244_cov_0.900585_g43994_i0	PRJNA891846	44214	244	0.900585	2.1974274	Pisolithus microcarpus 441	765257	Fungi	Fungi	91.7	2.35e-19	NR	KIK31000.1	765257	g43994	i0	65.2	1.67213114754098	69	24	84.8	0	238	32	246	314	KIK31000.1 hypothetical protein PISMIDRAFT_85861 [Pisolithus microcarpus 441]	diamond	408	91.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Pisolithaceae	Pisolithus	Pisolithus microcarpus
32363701	32363701	PRJNA891846_P_NODE_14179_length_402_cov_2.838906_g13960_i0	PRJNA891846	14179	402	2.838906	11.41240212	Laetiporus sulphureus 93-53	1314785	Fungi	Fungi	102	8.82e-24	NR	XP_040761607.1	1314785	g13960	i0	46.4	1.58955223880597	112	58	83.6	2	338	3	4	113	XP_040761607.1 uncharacterized protein LAESUDRAFT_728867 [Laetiporus sulphureus 93-53]	diamond	639	102	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Laetiporaceae	Laetiporus	Laetiporus sulphureus

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