metadata: contig_metadata: 13 rows where bioproject = "PRJNA393181", tax_clade = "Opisthokonta" and tax

13 rows where bioproject = "PRJNA393181", tax_clade = "Opisthokonta" 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
6181512	6181512	PRJNA393181_S_NODE_29805_length_206_cov_1.544379_g29699_i0	PRJNA393181	29805	206	1.544379	3.18142074	Cladosporium	5498	Fungi	Fungi	381	2.0199999999999994e-101	NTclustered	gi\|1401690641\|gb\|MH474001.1\|	29917	g29699	i0	100	100	206	0	100	0	1	206	224	19	Cladosporium cladosporioides isolate CK1359 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	20600	381	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium cladosporioides
7456466	7456466	PRJNA393181_S_NODE_31586_length_198_cov_1.826087_g31480_i0	PRJNA393181	31586	198	1.826087	3.61565226	Dothideomycetes	147541	Fungi	Fungi	361	2.51e-95	NTclustered	gi\|283827932\|gb\|FJ493209.2\|	630509	g31480	i0	99.495	99.7626262626263	198	1	100	0	1	198	2134	1937	Phaeophleospora eugeniicola strain CPC 2558 28S large subunit ribosomal RNA gene, partial sequence	blastn	19753	361	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Phaeophleospora	Phaeophleospora eugeniicola
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
10614698	10614698	PRJNA393181_S_NODE_44329_length_158_cov_1.289256_g44223_i0	PRJNA393181	44329	158	1.289256	2.03702448	Cladosporium anthropophilum	1970646	Fungi	Fungi	254	3.3400000000000003e-63	NTclustered	gi\|2216737164\|ref\|NC_061970.1\|	1970646	g44223	i0	95.57	87.6329113924051	158	7	100	0	1	158	4738	4581	Cladosporium anthropophilum voucher KACC 49782 mitochondrion, complete genome	blastn	13846	254	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium anthropophilum
13831865	13831865	PRJNA393181_S_NODE_22051_length_249_cov_1.292453_g21945_i0	PRJNA393181	22051	249	1.292453	3.21820797	Fusarium	5506	Fungi	Fungi	182	2.75e-41	NTclustered	gi\|1070343524\|ref\|XM_018389999.1\|	426428	g21945	i0	80.952	61.1044176706827	231	42	92	2	1	230	678	449	Fusarium oxysporum f. sp. lycopersici 4287 60S ribosomal protein L7 (FOXG_10571), mRNA	blastn	15215	182	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
23363124	23363124	PRJNA393181_S_NODE_7839_length_426_cov_2.753213_g7733_i0	PRJNA393181	7839	426	2.753213	11.72868738	Diutina rugosa	5481	Fungi	Fungi	52.8	0.041	NTclustered	gi\|1838467306\|ref\|XM_034154283.1\|	5481	g7733	i0	92.105	3.03286384976526	38	2	9	1	186	223	120	156	Diutina rugosa uncharacterized protein (DIURU_000171), partial mRNA	blastn	1292	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Diutina	Diutina rugosa
24637255	24637255	PRJNA393181_S_NODE_45340_length_155_cov_2.940678_g45234_i0	PRJNA393181	45340	155	2.940678	4.5580509	Diaporthe batatas	748121	Fungi	Fungi	82.4	1.63e-11	NTclustered	gi\|2124364152\|ref\|XM_044788593.1\|	748121	g45234	i0	96	8.84516129032258	50	2	32	0	106	155	626	675	Diaporthe batatas uncharacterized protein (KVR01_004153), mRNA	blastn	1371	82.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Diaporthales	Diaporthaceae	Diaporthe	Diaporthe batatas
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);;