metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA309466" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA309466" 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
12541471	12541471	PRJNA309466_P_NODE_12990_length_181_cov_1.446970_g12933_i0	PRJNA309466	12990	181	1.44697	2.6190157	Dothideomycetes	147541	Fungi	Fungi	128	7.17e-33	NR	XP_069232264.1	1052096	g12933	i0	93.2	6.89502762430939	59	4	97.8	0	4	180	248	306	XP_069232264.1 uncharacterized protein WHR41_01992 [Cladosporium halotolerans]	diamond	1248	129	0.992248062015504	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
13130652	13130652	PRJNA309466_P_NODE_3811_length_300_cov_2.047809_g3755_i0	PRJNA309466	3811	300	2.047809	6.143427	Pleosporales	92860	Fungi	Fungi	115	2.25e-27	NR	KAF2996844.1	90978	g3755	i0	85.1	1.99	67	10	67	0	9	209	531	597	KAF2996844.1 hypothetical protein E8E13_003664 [Curvularia kusanoi]	diamond	597	115	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Curvularia	Curvularia kusanoi
14405773	14405773	PRJNA309466_P_NODE_16512_length_166_cov_1.384615_g16455_i0	PRJNA309466	16512	166	1.384615	2.2984609	Cladosporium halotolerans	1052096	Fungi	Fungi	85.9	5.92e-19	NR	XP_069229575.1	1052096	g16455	i0	93	8.54819277108434	43	3	77.7	0	164	36	173	215	XP_069229575.1 uncharacterized protein WHR41_05168 [Cladosporium halotolerans]	diamond	1419	85.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
26631104	26631104	PRJNA309466_P_NODE_16861_length_165_cov_1.543103_g16804_i0	PRJNA309466	16861	165	1.543103	2.54611995	Sarocladium strictum	5046	Fungi	Fungi	107	8.630000000000001e-26	NR	KAK0383663.1	5046	g16804	i0	96.4	1	55	2	100	0	165	1	1	55	KAK0383663.1 hypothetical protein NLU13_9574 [Sarocladium strictum]	diamond	165	107	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
27042638	27042638	PRJNA309466_P_NODE_15002_length_171_cov_1.696721_g14945_i0	PRJNA309466	15002	171	1.696721	2.90139291	Cladosporium halotolerans	1052096	Fungi	Fungi	89.7	1.4e-19	NR	XP_069233122.1	1052096	g14945	i0	85.1	0.824561403508772	47	7	82.5	0	167	27	292	338	XP_069233122.1 uncharacterized protein WHR41_01392 [Cladosporium halotolerans]	diamond	141	89.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
27091872	27091872	PRJNA309466_P_NODE_11182_length_191_cov_4.612676_g11125_i0	PRJNA309466	11182	191	4.6126760000000004	8.81021116	Helotiales	5178	Fungi	Fungi	93.2	3.15e-20	NR	KAF8866358.1	886606	g11125	i0	96.1	12.9581151832461	51	2	80.1	0	39	191	367	417	KAF8866358.1 hypothetical protein BDZ45DRAFT_668155 [Acephala macrosclerotiorum]	diamond	2475	94	0.991489361702128	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Mollisiaceae	Acephala	Acephala macrosclerotiorum
28355046	28355046	PRJNA309466_P_NODE_12706_length_182_cov_4.646617_g12649_i0	PRJNA309466	12706	182	4.646617	8.45684294	Hypocreales	5125	Fungi	Fungi	42.7	0.0122	NR	KAF4512273.1	72228	g12649	i0	91.3	5.71978021978022	23	2	37.9	0	181	113	159	181	KAF4512273.1 hypothetical protein G6O67_001438 [Ophiocordyceps sinensis]	diamond	1041	43.1	0.990719257540603	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Ophiocordyceps	Ophiocordyceps sinensis
28527206	28527206	PRJNA309466_P_NODE_18367_length_161_cov_3.375000_g18310_i0	PRJNA309466	18367	161	3.375	5.43375	Cladosporium halotolerans	1052096	Fungi	Fungi	70.5	1.26e-12	NR	XP_069228683.1	1052096	g18310	i0	81.8	0.819875776397516	44	8	82	0	160	29	261	304	XP_069228683.1 uncharacterized protein WHR41_06045 [Cladosporium halotolerans]	diamond	132	70.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
29459892	29459892	PRJNA309466_P_NODE_5130_length_255_cov_2.907767_g5073_i0	PRJNA309466	5130	255	2.907767	7.41480585	Eukaryota	2759	Fungi	Fungi	56.2	7.46e-7	NR	XP_501992.1	4952	g5073	i0	57.8	4.30588235294118	45	19	52.9	0	29	163	51	95	XP_501992.1 uncharacterized protein YALI1_C26051g [Yarrowia lipolytica]	diamond	1098	56.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales		Yarrowia	Yarrowia lipolytica
30945025	30945025	PRJNA309466_P_NODE_7374_length_221_cov_1337722.941860_g7317_i0	PRJNA309466	7374	221	1337722.94186	2956367.7015106	Eukaryota	2759	Fungi	Fungi	42.7	0.025	NR	QGI66133.1	5127	g7317	i0	94.7	25.737556561086	19	1	25.8	0	44	100	121	139	QGI66133.1 hypothetical protein CEK27_010104 [Fusarium fujikuroi]	diamond	5688	43.1	0.990719257540603	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium fujikuroi
31260919	31260919	PRJNA309466_P_NODE_17295_length_164_cov_0.904348_g17238_i0	PRJNA309466	17295	164	0.904348	1.48313072	Lecanoromycetes	147547	Fungi	Fungi	70.5	2.1e-12	NR	MCJ1232844.1	160984	g17238	i0	69.2	5.67073170731707	52	15	95.1	1	162	7	1133	1183	MCJ1232844.1 UDP-glucose:glycoprotein glucosyltransferase 2 [Varicellaria rhodocarpa]	diamond	930	70.9	0.994358251057828	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Pertusariales	Pertusariaceae	Varicellaria	Varicellaria rhodocarpa
31622818	31622818	PRJNA309466_P_NODE_7056_length_225_cov_2.272727_g6999_i0	PRJNA309466	7056	225	2.272727	5.11363575	Podosphaera aphanis	79252	Fungi	Fungi	52.4	7.58e-6	NR	KAI0999017.1	79252	g6999	i0	61.5	1.04	39	15	52	0	4	120	172	210	KAI0999017.1 hypothetical protein K3495_g9181 [Podosphaera aphanis]	diamond	234	52.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Podosphaera	Podosphaera aphanis
31717774	31717774	PRJNA309466_P_NODE_6857_length_227_cov_3.039326_g6800_i0	PRJNA309466	6857	227	3.039326	6.89927002	Coniella lustricola	2025994	Fungi	Fungi	58.9	8.69e-9	NR	PSR78156.1	2025994	g6800	i0	65.1	0.568281938325991	43	15	56.8	0	36	164	85	127	PSR78156.1 hypothetical protein BD289DRAFT_377009 [Coniella lustricola]	diamond	129	58.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Diaporthales	Schizoparmaceae	Coniella	Coniella lustricola
32319215	32319215	PRJNA309466_P_NODE_9059_length_206_cov_4.439490_g9002_i0	PRJNA309466	9059	206	4.43949	9.1453494	Cladosporium halotolerans	1052096	Fungi	Fungi	111	1.18e-26	NR	XP_069234332.1	1052096	g9002	i0	89.6	0.975728155339806	67	7	97.6	0	206	6	238	304	XP_069234332.1 uncharacterized protein WHR41_00084 [Cladosporium halotolerans]	diamond	201	111	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans

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