metadata: contig_metadata: 10 rows where bioproject = "PRJEB2333", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJEB2333", 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
7363852	7363852	PRJEB2333_P_NODE_2606_length_540_cov_11.176938_g1837_i0	PRJEB2333	2606	540	11.176938	60.3554652	Alternaria	5598	Fungi	Fungi	540	9.29e-149	NTclustered	gi\|289449248\|dbj\|AB517938.1\|	5599	g1837	i0	99.661	66.7185185185185	295	1	77	0	1	295	876	582	Alternaria alternata gene for 28S ribosomal RNA, partial sequence	blastn	36028	545	0.990825688073395	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Alternaria	Alternaria alternata
18837961	18837961	PRJEB2333_P_NODE_3775_length_207_cov_1.711765_g2998_i0	PRJEB2333	3775	207	1.711765	3.54335355	Dothideomycetes	147541	Fungi	Fungi	327	2.69e-85	NTclustered	gi\|2749640508\|ref\|XR_010715598.1\|	5022	g2998	i0	99.448	103.328502415459	181	0	87	1	1	181	3248	3427	Leptosphaeria maculans 28S ribosomal RNA (IAQ61_009836), rRNA	blastn	21389	327	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Leptosphaeriaceae	Plenodomus	Plenodomus lingam
22663103	22663103	PRJEB2333_P_NODE_3658_length_224_cov_2.663102_g2881_i0	PRJEB2333	3658	224	2.663102	5.96534848	Eukaryota	2759	Fungi	Fungi	196	8.69e-46	NTclustered	gi\|73990900\|emb\|AM039516.1\|	211099	g2881	i0	85.492	88.3794642857143	193	22	85	4	35	224	911	722	Hanseniaspora clermontiae partial tef1 gene for translation elongation factor 1-alpha, strain CBS 8821	blastn	19797	196	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycodales	Saccharomycodaceae	Hanseniaspora	Hanseniaspora clermontiae
23938496	23938496	PRJEB2333_P_NODE_3199_length_417_cov_2.023684_g2424_i0	PRJEB2333	3199	417	2.023684	8.43876228	Fungi	4751	Fungi	Fungi	233	1.3299999999999998e-56	NTclustered	gi\|6715474\|gb\|AF218791.1\|AF218791	5599	g2424	i0	100	51.4340527577938	126	0	59	0	1	126	1634	1509	Alternaria alternata internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; 28S ribosomal RNA gene, partial sequence; and 18S ribosomal RNA gene, complete sequence	blastn	21448	233	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Alternaria	Alternaria alternata
23938505	23938505	PRJEB2333_P_NODE_3819_length_202_cov_2.351515_g3042_i0	PRJEB2333	3819	202	2.351515	4.7500603	Eukaryota	2759	Fungi	Fungi	372	1.19e-98	NTclustered	gi\|514829572\|gb\|KC771883.1\|	4929	g3042	i0	100	83.5792079207921	201	0	99	0	1	201	132	332	Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence	blastn	16883	372	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Meyerozyma	Meyerozyma guilliermondii
27696950	27696950	PRJEB2333_P_NODE_3084_length_434_cov_1.352645_g2309_i0	PRJEB2333	3084	434	1.352645	5.8704793	Pichia membranifaciens	4926	Fungi	Fungi	77	7.08e-15	NR	GAV28409.1	4926	g2309	i0	64.3	1.88709677419355	56	20	38.7	0	183	16	76	131	GAV28409.1 60S ribosomal protein [Pichia membranifaciens]	diamond	819	77	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Pichia	Pichia membranifaciens
28138887	28138887	PRJEB2333_P_NODE_2585_length_548_cov_1.123288_g1816_i0	PRJEB2333	2585	548	1.123288	6.15561824	Nadsonia fulvescens var. elongata DSM 6958	857566	Fungi	Fungi	110	8.22e-27	NR	ODQ66779.1	857566	g1816	i0	62.7	0.454379562043796	83	30	45.4	1	293	541	77	158	ODQ66779.1 60S ribosomal protein L11-A, partial [Nadsonia fulvescens var. elongata DSM 6958]	diamond	249	110	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales		Nadsonia	Nadsonia fulvescens
28732140	28732140	PRJEB2333_P_NODE_2987_length_447_cov_2.239024_g2213_i0	PRJEB2333	2987	447	2.239024	10.00843728	Pichiomycetes	3239874	Fungi	Fungi	99.4	6.559999999999999e-23	NR	ANZ77480.1	4922	g2213	i0	52.4	5.46308724832215	103	38	69.1	1	5	313	63	154	ANZ77480.1 BA75_04938T0 [Komagataella pastoris]	diamond	2442	100	0.994	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Komagataella	Komagataella pastoris
31075953	31075953	PRJEB2333_P_NODE_4275_length_171_cov_1.455224_g3498_i0	PRJEB2333	4275	171	1.455224	2.48843304	Xylographa carneopallida	1590122	Fungi	Fungi	79	1.89e-16	NR	MCJ1296998.1	1590122	g3498	i0	62.5	1.96491228070175	56	21	98.2	0	3	170	102	157	MCJ1296998.1 Rho GTPase protein rac1 [Xylographa carneopallida]	diamond	336	79	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Baeomycetales	Xylographaceae	Xylographa	Xylographa carneopallida
32492961	32492961	PRJEB2333_P_NODE_4019_length_186_cov_1.570470_g3242_i0	PRJEB2333	4019	186	1.57047	2.9210742	Ascomycota	4890	Fungi	Fungi	85.1	3.69e-19	NR	XP_069259469.1	28565	g3242	i0	64.5	19.4838709677419	62	22	100	0	186	1	49	110	XP_069259469.1 40S ribosomal protein eS12 [Thermomyces dupontii]	diamond	3624	85.5	0.9953216374269	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Thermomyces	Thermomyces dupontii

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