metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1248471" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1248471" 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
26680044	26680044	PRJNA1248471_S_NODE_18621_length_167_cov_0.864407_g18521_i0	PRJNA1248471	18621	167	0.864407	1.44355969	Pucciniales	5258	Fungi	Fungi	52	1.94e-6	NR	CAH7689135.1	170000	g18521	i0	74.2	10.0239520958084	31	8	55.7	0	14	106	112	142	CAH7689135.1 hypothetical protein PPACK8108_LOCUS24208 [Phakopsora pachyrhizi]	diamond	1674	52	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Phakopsoraceae	Phakopsora	Phakopsora pachyrhizi
29378881	29378881	PRJNA1248471_S_NODE_13269_length_188_cov_2.187050_g13169_i0	PRJNA1248471	13269	188	2.18705	4.111654	Crucibulum laeve	68775	Fungi	Fungi	71.6	4.18e-13	NR	TFK40683.1	68775	g13169	i0	70.6	0.813829787234043	51	14	81.4	1	188	36	196	245	TFK40683.1 hypothetical protein BDQ12DRAFT_770473 [Crucibulum laeve]	diamond	153	71.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Nidulariaceae	Crucibulum	Crucibulum laeve
29757620	29757620	PRJNA1248471_S_NODE_8851_length_209_cov_2.781250_g8751_i0	PRJNA1248471	8851	209	2.78125	5.8128125	Malassezia sympodialis ATCC 42132	1230383	Fungi	Fungi	66.6	4.97e-12	NR	XP_018739417.1	1230383	g8751	i0	88.6	0.502392344497608	35	4	50.2	0	208	104	92	126	XP_018739417.1 uncharacterized protein MSY001_0801 [Malassezia sympodialis ATCC 42132]	diamond	105	66.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia sympodialis
29997053	29997053	PRJNA1248471_S_NODE_22651_length_161_cov_0.883929_g22551_i0	PRJNA1248471	22651	161	0.883929	1.42312569	Fungi	4751	Fungi	Fungi	43.1	8.65e-4	NR	EMD30456.1	914234	g22551	i0	59.5	3.7639751552795	37	15	68.9	0	111	1	5	41	EMD30456.1 hypothetical protein CERSUDRAFT_61147, partial [Gelatoporia subvermispora B]	diamond	606	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Gelatoporiaceae	Gelatoporia	Gelatoporia subvermispora
30358452	30358452	PRJNA1248471_S_NODE_13332_length_188_cov_1.100719_g13232_i0	PRJNA1248471	13332	188	1.100719	2.06935172	Ustilago trichophora	86804	Fungi	Fungi	77.4	2.62e-16	NR	SPO22764.1	86804	g13232	i0	82.5	3.82978723404255	40	7	63.8	0	1	120	94	133	SPO22764.1 related to QCR6 - ubiquinol--cytochrome-c reductase 17K protein [Ustilago trichophora]	diamond	720	77.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Ustilago	Ustilago trichophora
31260772	31260772	PRJNA1248471_S_NODE_16935_length_172_cov_1.341463_g16835_i0	PRJNA1248471	16935	172	1.341463	2.30731636	root	1	Root_unresolved	Root_unresolved	41.2	0.0497	NR	THH19875.1	1095465	g16835	i0	40	1.41279069767442	40	24	69.8	0	164	45	781	820	THH19875.1 hypothetical protein EW146_g1395 [Bondarzewia mesenterica]	diamond	243	41.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Bondarzewiaceae	Bondarzewia	Bondarzewia mesenterica

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