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

6 rows where analysis = "diamond", bioproject = "PRJNA922890" 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
26803025	26803025	PRJNA922890_P_NODE_52761_length_269_cov_1.155000_g52351_i0	PRJNA922890	52761	269	1.155	3.10695	Cyphobasidiales sp. Tagirdzhanova-	2801448	Fungi	Fungi	48.1	5.85e-4	NR	CAD6578736.1	2778381	g52351	i0	40.9	0.736059479553903	66	26	73.6	2	50	247	195	247	CAD6578736.1 MAG: hypothetical protein CYPHOPRED_000664 [Cyphobasidiales sp. Tagirdzhanova-0007]	diamond	198	48.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cyphobasidiales			Cyphobasidiales sp. Tagirdzhanova-0007
27404076	27404076	PRJNA922890_P_NODE_68403_length_236_cov_0.874251_g67993_i0	PRJNA922890	68403	236	0.874251	2.06323236	Ustilago sp. UG-2	1849495	Fungi	Fungi	126	8.41e-32	NR	SOV04426.1	2043610	g67993	i0	79.2	0.978813559322034	77	16	97.9	0	236	6	3	79	SOV04426.1 probable sugar transporter [Ustilago sp. UG-2017a]	diamond	231	126	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Ustilago	Ustilago sp. UG-2017a
28484743	28484743	PRJNA922890_P_NODE_69326_length_235_cov_0.879518_g68916_i0	PRJNA922890	69326	235	0.879518	2.0668673	Moesziomyces	63261	Fungi	Fungi	49.7	1.22e-4	NR	XP_014656186.1	84753	g68916	i0	52	1.90212765957447	75	32	93.2	3	220	2	133	205	XP_014656186.1 intermembrane space import and assembly protein 40 [Moesziomyces antarcticus]	diamond	447	49.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Moesziomyces	Moesziomyces antarcticus
29747385	29747385	PRJNA922890_P_NODE_60670_length_250_cov_1.685083_g60260_i0	PRJNA922890	60670	250	1.685083	4.2127075	Fungi	4751	Fungi	Fungi	63.2	2.6e-9	NR	GAW05771.1	5353	g60260	i0	51.4	3.36	72	35	86.4	0	222	7	445	516	GAW05771.1 cytoplasmic protein [Lentinula edodes]	diamond	840	63.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Lentinula	Lentinula edodes
30000490	30000490	PRJNA922890_P_NODE_60231_length_251_cov_1.989011_g59821_i0	PRJNA922890	60231	251	1.989011	4.99241761	Fungi	4751	Fungi	Fungi	80.5	3.84e-17	NR	ORY41752.1	106004	g59821	i0	49.4	6.74103585657371	81	40	96.8	1	8	250	10	89	ORY41752.1 ribosomal protein L23/L15e core domain-containing protein [Leucosporidium creatinivorum]	diamond	1692	81.3	0.990159901599016	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Leucosporidiales	Leucosporidiaceae	Leucosporidium	Leucosporidium creatinivorum
31636454	31636454	PRJNA922890_P_NODE_75356_length_232_cov_0.895706_g74946_i0	PRJNA922890	75356	232	0.895706	2.07803792	Mixia osmundae IAM 14324	764103	Fungi	Fungi	63.2	2.06e-9	NR	XP_014567198.1	764103	g74946	i0	39.5	1.04741379310345	81	44	99.6	3	1	231	545	624	XP_014567198.1 uncharacterized protein L969DRAFT_18205 [Mixia osmundae IAM 14324]	diamond	243	63.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Mixiomycetes	Mixiales	Mixiaceae	Mixia	Mixia osmundae

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