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

5 rows where analysis = "diamond", bioproject = "PRJNA613025" 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
28406792	28406792	PRJNA613025_S_NODE_31106_length_165_cov_1.741379_g30952_i0	PRJNA613025	31106	165	1.741379	2.87327535	Puccinia striiformis f. sp. tritici	168172	Fungi	Fungi	81.3	5.9e-18	NR	XP_047802996.1	168172	g30952	i0	73.6	6.76363636363636	53	14	96.4	0	160	2	35	87	XP_047802996.1 hypothetical protein Pst134EA_019078 [Puccinia striiformis f. sp. tritici]	diamond	1116	81.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia striiformis
29303771	29303771	PRJNA613025_S_NODE_12289_length_332_cov_1.982332_g12135_i0	PRJNA613025	12289	332	1.982332	6.58134224	Eukaryota	2759	Fungi	Fungi	115	1.89e-30	NR	KAI0053645.1	40419	g12135	i0	66.7	8.93674698795181	99	33	89.5	0	1	297	25	123	KAI0053645.1 ribosomal protein L35 [Auriscalpium vulgare]	diamond	2967	115	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Auriscalpiaceae	Auriscalpium	Auriscalpium vulgare
29713886	29713886	PRJNA613025_S_NODE_33170_length_162_cov_0.902655_g33016_i0	PRJNA613025	33170	162	0.902655	1.4623011	Fungi	4751	Fungi	Fungi	97.1	3.8600000000000003e-22	NR	XP_046034071.1	5210	g33016	i0	84.9	223.759259259259	53	8	98.1	0	161	3	78	130	XP_046034071.1 ribosomal protein L3-domain-containing protein [Filobasidium floriforme]	diamond	36249	97.8	0.992842535787321	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Filobasidium	Filobasidium floriforme
29890905	29890905	PRJNA613025_S_NODE_26491_length_181_cov_1.515152_g26337_i0	PRJNA613025	26491	181	1.515152	2.74242512	Amanita brunnescens Koide BX	87326	Fungi	Fungi	46.2	9.85e-4	NR	KAF8716017.1	1457509	g26337	i0	43.9	3.74585635359116	57	28	94.5	2	174	4	340	392	KAF8716017.1 hypothetical protein AX14_012500 [Amanita brunnescens Koide BX004]	diamond	678	46.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Amanitaceae	Amanita	Amanita brunnescens
31135633	31135633	PRJNA613025_S_NODE_34215_length_158_cov_2.339450_g34061_i0	PRJNA613025	34215	158	2.33945	3.696331	Agaricomycetes	155619	Fungi	Fungi	50.8	1.29e-5	NR	KAH9951639.1	202700	g34061	i0	63.8	6.18987341772152	47	15	85.4	2	22	156	54	100	KAH9951639.1 60S ribosomal protein L6 [Amylocystis lapponica]	diamond	978	50.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Postiaceae	Amylocystis	Amylocystis lapponica

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