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

5 rows where analysis = "diamond", bioproject = "PRJNA733995" 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
26608965	26608965	PRJNA733995_P_NODE_13461_length_243_cov_0.905882_g13414_i0	PRJNA733995	13461	243	0.905882	2.20129326	Russula vinacea	517384	Fungi	Fungi	42	0.0089	NR	KAH9980804.1	517384	g13414	i0	44.4	0.555555555555556	45	25	55.6	0	82	216	15	59	KAH9980804.1 hypothetical protein BJV77DRAFT_1046921 [Russula vinacea]	diamond	135	42	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Russula	Russula vinacea
26767560	26767560	PRJNA733995_P_NODE_7341_length_317_cov_1.262295_g7294_i0	PRJNA733995	7341	317	1.262295	4.00147515	Auriscalpium vulgare	40419	Fungi	Fungi	44.3	0.0237	NR	KAI0044408.1	40419	g7294	i0	32.6	0.899053627760252	95	60	86.1	2	27	299	297	391	KAI0044408.1 Metallo-dependent hydrolase [Auriscalpium vulgare]	diamond	285	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Auriscalpiaceae	Auriscalpium	Auriscalpium vulgare
26957282	26957282	PRJNA733995_P_NODE_10482_length_268_cov_1.200000_g10435_i0	PRJNA733995	10482	268	1.2	3.216	Rhodotorula sp. CCFEE 5	1853554	Fungi	Fungi	80.1	3.56e-15	NR	TKA58087.1	1965284	g10435	i0	58	0.772388059701492	69	29	77.2	0	209	3	661	729	TKA58087.1 hypothetical protein B0A53_00489 [Rhodotorula sp. CCFEE 5036]	diamond	207	80.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula sp. CCFEE 5036
27494830	27494830	PRJNA733995_P_NODE_2043_length_627_cov_1.832130_g1996_i0	PRJNA733995	2043	627	1.83213	11.4874551	Mixia osmundae IAM 14324	764103	Fungi	Fungi	91.7	1.49e-17	NR	XP_014569727.1	764103	g1996	i0	31.2	1.04306220095694	218	118	93.3	7	27	611	290	498	XP_014569727.1 glycosyltransferase family 47 protein [Mixia osmundae IAM 14324]	diamond	654	91.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Mixiomycetes	Mixiales	Mixiaceae	Mixia	Mixia osmundae
30905598	30905598	PRJNA733995_P_NODE_3994_length_438_cov_1.476712_g3947_i0	PRJNA733995	3994	438	1.476712	6.46799856	Collybiopsis luxurians FD-317 M1	944289	Fungi	Fungi	50.4	5.83e-4	NR	KIK60310.1	944289	g3947	i0	47.2	0.363013698630137	53	28	36.3	0	160	2	419	471	KIK60310.1 hypothetical protein GYMLUDRAFT_225825 [Collybiopsis luxurians FD-317 M1]	diamond	159	50.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Collybiopsis	Collybiopsis luxurians

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