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

7 rows where analysis = "diamond", bioproject = "PRJNA393181" and tax_phylum = "Ascomycota"

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