metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA193544" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA193544" and tax_kingdom = "Fungi"

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
26662126	26662126	PRJNA193544_S_NODE_1141_length_239_cov_5.390476_g1126_i0	PRJNA193544	1141	239	5.390476	12.88323764	Tremella mesenterica DSM 1558	578456	Fungi	Fungi	50.4	2.5e-5	NR	EIW67481.1	578456	g1126	i0	63.9	0.451882845188285	36	13	45.2	0	122	229	125	160	EIW67481.1 hypothetical protein TREMEDRAFT_33574 [Tremella mesenterica DSM 1558]	diamond	108	50.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Tremellaceae	Tremella	Tremella mesenterica
28400391	28400391	PRJNA193544_S_NODE_2126_length_186_cov_570.751592_g2111_i0	PRJNA193544	2126	186	570.751592	1061.59796112	Rozella allomycis CSF55	988480	Fungi	Fungi	48.1	1.14e-5	NR	RKP19416.1	988480	g2111	i0	66.7	0.532258064516129	33	11	53.2	0	68	166	8	40	RKP19416.1 hypothetical protein ROZALSC1DRAFT_14013, partial [Rozella allomycis CSF55]	diamond	99	48.1	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota				Rozella	Rozella allomycis
30295524	30295524	PRJNA193544_S_NODE_3272_length_154_cov_16.336000_g3257_i0	PRJNA193544	3272	154	16.336	25.15744	Thermothelomyces fergusii	2588716	Fungi	Fungi	52	2.11e-6	NR	KAL2161104.1	2588716	g3257	i0	50.9	5.31818181818182	53	24	99.4	1	153	1	48	100	KAL2161104.1 hypothetical protein VTH06DRAFT_8817 [Thermothelomyces fergusii]	diamond	819	52	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Chaetomiaceae	Thermothelomyces	Thermothelomyces fergusii
30927220	30927220	PRJNA193544_S_NODE_1134_length_240_cov_5.393365_g1119_i0	PRJNA193544	1134	240	5.393365	12.944076	Sarocladium implicatum	1610689	Fungi	Fungi	58.5	3.88e-9	NR	KAH8175438.1	1610689	g1119	i0	49.4	1.0125	81	34	97.5	3	7	240	5	81	KAH8175438.1 hypothetical protein LIA77_03856 [Sarocladium implicatum]	diamond	243	58.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium implicatum
31085016	31085016	PRJNA193544_S_NODE_995_length_251_cov_19.842342_g980_i0	PRJNA193544	995	251	19.842342	49.80427842	Linnemannia gamsii	64522	Fungi	Fungi	42	0.0336	NR	KAG0283656.1	64522	g980	i0	31.8	0.788844621513944	66	40	78.9	2	1	198	66	126	KAG0283656.1 hypothetical protein BGZ97_008457, partial [Linnemannia gamsii]	diamond	198	42	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Linnemannia	Linnemannia gamsii
31432739	31432739	PRJNA193544_S_NODE_1056_length_246_cov_13.760369_g1041_i0	PRJNA193544	1056	246	13.760369	33.85050774	Calcarisporiella thermophila	911321	Fungi	Fungi	54.7	2.07e-7	NR	KAL1914197.1	911321	g1041	i0	53.4	0.707317073170732	58	26	70.7	1	243	70	9	65	KAL1914197.1 hypothetical protein VTP21DRAFT_9681 [Calcarisporiella thermophila]	diamond	174	54.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
32065390	32065390	PRJNA193544_S_NODE_1798_length_200_cov_3.508772_g1783_i0	PRJNA193544	1798	200	3.508772	7.017544	Rhizomucor pusillus	4840	Fungi	Fungi	44.7	0.00276	NR	KAL1932413.1	4840	g1783	i0	54.8	0.63	42	19	63	0	47	172	103	144	KAL1932413.1 hypothetical protein VTP01DRAFT_9469 [Rhizomucor pusillus]	diamond	126	44.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
32571901	32571901	PRJNA193544_S_NODE_239_length_380_cov_10.467236_g224_i0	PRJNA193544	239	380	10.467236	39.7754968	Claviceps pusilla	123648	Fungi	Fungi	62.4	1.02e-9	NR	KAG5993183.1	123648	g224	i0	43.3	0.710526315789474	90	49	71.1	1	111	380	12	99	KAG5993183.1 hypothetical protein E4U43_003579, partial [Claviceps pusilla]	diamond	270	62.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Clavicipitaceae	Claviceps	Claviceps pusilla
32778195	32778195	PRJNA193544_S_NODE_660_length_293_cov_8.943182_g645_i0	PRJNA193544	660	293	8.943182	26.20352326	Penicillium	5073	Fungi	Fungi	55.8	2.79e-7	NR	KAJ5598932.1	94218	g645	i0	49.3	1.45392491467577	71	36	72.7	0	38	250	32	102	KAJ5598932.1 hypothetical protein N7510_011882, partial [Penicillium lagena]	diamond	426	55.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium lagena

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