metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA393181" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA393181" 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
10614284	10614284	PRJNA393181_S_NODE_2829_length_625_cov_2.544218_g2747_i0	PRJNA393181	2829	625	2.544218	15.9013625	Leptodontidium sp. MPI-SDFR-AT-	1920929	Fungi	Fungi	174	1.75e-49	NR	KAH6700579.1	2826080	g2747	i0	67.8	2.3088	121	38	57.6	1	362	3	2	122	KAH6700579.1 hypothetical protein BKA61DRAFT_620796 [Leptodontidium sp. MPI-SDFR-AT-0119]	diamond	1443	174	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Leptodontidiaceae	Leptodontidium	Leptodontidium sp. MPI-SDFR-AT-0119
14439528	14439528	PRJNA393181_S_NODE_36852_length_179_cov_1.338028_g36746_i0	PRJNA393181	36852	179	1.338028	2.39507012	Agaricomycetes	155619	Fungi	Fungi	95.5	8.429999999999999e-23	NR	TEB38703.1	71717	g36746	i0	79.3	252.45251396648	58	12	97.2	0	1	174	12	69	TEB38703.1 ras-domain-containing protein [Coprinellus micaceus]	diamond	45189	95.9	0.995828988529718	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Psathyrellaceae	Coprinellus	Coprinellus micaceus
27265041	27265041	PRJNA393181_S_NODE_41563_length_165_cov_1.203125_g41457_i0	PRJNA393181	41563	165	1.203125	1.98515625	Penicillium decumbens	69771	Fungi	Fungi	47.4	8.85e-5	NR	OQD78233.1	69771	g41457	i0	44.2	2.87272727272727	52	27	92.7	2	10	162	29	79	OQD78233.1 hypothetical protein PENDEC_c001G06406 [Penicillium decumbens]	diamond	474	47.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium decumbens
28418763	28418763	PRJNA393181_S_NODE_44306_length_158_cov_1.487603_g44200_i0	PRJNA393181	44306	158	1.487603	2.35041274	root	1	Root_unresolved	Root_unresolved	42.4	0.0138	NR	TQV90680.1	43265	g44200	i0	42.2	2.56329113924051	45	26	85.4	0	18	152	62	106	TQV90680.1 macro domain-containing protein [Cordyceps javanica]	diamond	405	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Cordyceps	Cordyceps javanica
29854232	29854232	PRJNA393181_S_NODE_32131_length_196_cov_1.421384_g32025_i0	PRJNA393181	32131	196	1.421384	2.78591264	Cladophialophora bantiana CBS 173.52	1442370	Fungi	Fungi	109	4.94e-27	NR	XP_016613449.1	1442370	g32025	i0	75.4	4.94387755102041	65	16	99.5	0	195	1	251	315	XP_016613449.1 uncharacterized protein Z519_12566 [Cladophialophora bantiana CBS 173.52]	diamond	969	109	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Cladophialophora	Cladophialophora bantiana
30296937	30296937	PRJNA393181_S_NODE_20692_length_258_cov_2.294118_g20586_i0	PRJNA393181	20692	258	2.294118	5.91882444	Cunninghamella echinulata	76405	Fungi	Fungi	49.7	1.05e-4	NR	KAI9300859.1	76405	g20586	i0	34.5	0.976744186046512	84	53	96.5	2	257	9	74	156	KAI9300859.1 OSCP/delta subunit of ATPase [Cunninghamella echinulata]	diamond	252	49.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Cunninghamella	Cunninghamella echinulata
30865127	30865127	PRJNA393181_S_NODE_40494_length_168_cov_1.190840_g40388_i0	PRJNA393181	40494	168	1.19084	2.0006112	Malassezia restricta	76775	Fungi	Fungi	90.9	2.51e-21	NR	XP_027485772.1	76775	g40388	i0	78.2	0.982142857142857	55	12	98.2	0	166	2	96	150	XP_027485772.1 peptidyl-tRNA hydrolase, PTH2 family [Malassezia restricta]	diamond	165	90.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
31086384	31086384	PRJNA393181_S_NODE_43375_length_160_cov_1.894309_g43269_i0	PRJNA393181	43375	160	1.894309	3.0308944	Testicularia cyperi	1882483	Fungi	Fungi	83.6	2.93e-17	NR	PWZ01463.1	1882483	g43269	i0	77.4	7.95	53	12	99.4	0	2	160	297	349	PWZ01463.1 NAD-dependent glycerol-3-phosphate dehydrogenase [Testicularia cyperi]	diamond	1272	83.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Anthracoideaceae	Testicularia	Testicularia cyperi
31402707	31402707	PRJNA393181_S_NODE_47456_length_151_cov_1.350877_g47350_i0	PRJNA393181	47456	151	1.350877	2.03982427	Westerdykella ornata	318751	Fungi	Fungi	40.4	0.0292	NR	XP_033653906.1	318751	g47350	i0	50	0.834437086092715	42	20	81.5	1	133	11	71	112	XP_033653906.1 uncharacterized protein EI97DRAFT_37200 [Westerdykella ornata]	diamond	126	40.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Sporormiaceae	Westerdykella	Westerdykella ornata
32383209	32383209	PRJNA393181_S_NODE_24819_length_231_cov_1.726804_g24713_i0	PRJNA393181	24819	231	1.726804	3.98891724	Madurella fahalii	1157608	Fungi	Fungi	42.4	0.0449	NR	XP_070919493.1	1157608	g24713	i0	38.6	0.74025974025974	57	31	74	1	52	222	291	343	XP_070919493.1 uncharacterized protein MFIFM68171_07972 [Madurella fahalii]	diamond	171	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales		Madurella	Madurella fahalii
32446742	32446742	PRJNA393181_S_NODE_24059_length_235_cov_3.010101_g23953_i0	PRJNA393181	24059	235	3.010101	7.07373735	Acarospora aff. strigata	2871812	Fungi	Fungi	43.1	0.0236	NR	MCJ1366958.1	2871812	g23953	i0	36.4	0.702127659574468	55	33	67.7	1	72	230	326	380	MCJ1366958.1 hypothetical protein [Acarospora aff. strigata]	diamond	165	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Acarosporales	Acarosporaceae	Acarospora	Acarospora aff. strigata

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