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

5 rows where analysis = "diamond", bioproject = "PRJEB15333" 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
26621569	26621569	PRJEB15333_P_NODE_10741_length_207_cov_1.702532_g10657_i0	PRJEB15333	10741	207	1.702532	3.52424124	Wolfiporia cocos MD-1	81056	Fungi	Fungi	42	0.00689	NR	PCH33491.1	742152	g10657	i0	39	0.594202898550725	41	25	59.4	0	60	182	16	56	PCH33491.1 hypothetical protein WOLCODRAFT_22050 [Wolfiporia cocos MD-104 SS10]	diamond	123	42	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Phaeolaceae	Wolfiporia	Wolfiporia cocos
28075356	28075356	PRJEB15333_P_NODE_17865_length_167_cov_1.101695_g17781_i0	PRJEB15333	17865	167	1.101695	1.83983065	Stereum hirsutum FP-91666 SS1	721885	Fungi	Fungi	41.6	0.0343	NR	XP_007309574.1	721885	g17781	i0	45.2	0.754491017964072	42	18	66.5	1	57	167	111	152	XP_007309574.1 uncharacterized protein STEHIDRAFT_66796 [Stereum hirsutum FP-91666 SS1]	diamond	126	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
28448121	28448121	PRJEB15333_P_NODE_20826_length_162_cov_0.699115_g20742_i0	PRJEB15333	20826	162	0.699115	1.1325663	Agaricomycetes	155619	Fungi	Fungi	47.8	1.41e-4	NR	KAH9083508.1	55514	g20742	i0	48.1	13.2962962962963	52	27	96.3	0	6	161	110	161	KAH9083508.1 hypothetical protein EDB83DRAFT_22607 [Lactarius deliciosus]	diamond	2154	48.1	0.993762993762994	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Lactarius	Lactarius deliciosus
28612256	28612256	PRJEB15333_P_NODE_5927_length_270_cov_1.067873_g5843_i0	PRJEB15333	5927	270	1.067873	2.8832571	Mycena sp. CBHHK59/15	1940295	Fungi	Fungi	43.1	0.033	NR	KAJ6610829.1	1940295	g5843	i0	40	0.555555555555556	50	27	55.6	2	63	212	164	210	KAJ6610829.1 hypothetical protein B0H10DRAFT_1953533 [Mycena sp. CBHHK59/15]	diamond	150	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena sp. CBHHK59/15
30633274	30633274	PRJEB15333_P_NODE_20813_length_162_cov_0.876106_g20729_i0	PRJEB15333	20813	162	0.876106	1.41929172	Phanerochaete carnosa HHB-1	231932	Fungi	Fungi	39.3	0.0419	NR	XP_007391454.1	650164	g20729	i0	59.3	0.5	27	11	50	0	159	79	5	31	XP_007391454.1 uncharacterized protein PHACADRAFT_86317, partial [Phanerochaete carnosa HHB-10118-sp]	diamond	81	39.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Phanerochaetaceae	Phanerochaete	Phanerochaete carnosa

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