metadata: contig_metadata: 4 rows where bioproject = "PRJEB2368", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJEB2368", 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
22891	22891	PRJEB2368_P_NODE_14781_length_160_cov_2.894309_g14462_i0	PRJEB2368	14781	160	2.894309	4.6308944	Candida parapsilosis	5480	Fungi	Fungi	296	5.55e-76	NTclustered	gi\|371925444\|gb\|JQ062882.1\|	5480	g14462	i0	100	51.1125	160	0	100	0	1	160	22416	22575	Candida parapsilosis strain CBS 1954 mitochondrion, partial genome	blastn	8178	296	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida parapsilosis
6089477	6089477	PRJEB2368_P_NODE_9745_length_287_cov_1.364000_g9427_i0	PRJEB2368	9745	287	1.364	3.91468	Ramalina	56479	Fungi	Fungi	52.8	0.027	NTclustered	gi\|1069417254\|gb\|KU496963.1\|	86786	g9427	i0	100	0.195121951219512	28	0	10	0	20	47	463	490	Ramalina americana voucher TL022-D04 12S ribosomal RNA gene, partial sequence; mitochondrial	blastn	56	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Lecanorales	Ramalinaceae	Ramalina	Ramalina americana
29590685	29590685	PRJEB2368_P_NODE_1210_length_790_cov_3.034529_g993_i0	PRJEB2368	1210	790	3.034529	23.9727791	Diploschistes diacapsis	150877	Fungi	Fungi	64.7	7.95e-8	NR	KAI4142025.1	150877	g993	i0	31.6	1.51518987341772	136	85	51.3	3	782	378	98	226	KAI4142025.1 MAG: hypothetical protein LQ340_007455 [Diploschistes diacapsis]	diamond	1197	64.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Ostropales	Graphidaceae	Diploschistes	Diploschistes diacapsis
31455316	31455316	PRJEB2368_P_NODE_14296_length_166_cov_1.713178_g13977_i0	PRJEB2368	14296	166	1.713178	2.84387548	Pyronema omphalodes CBS 1	337075	Fungi	Fungi	92.8	2.33e-20	NR	CCX05784.1	1076935	g13977	i0	71.2	4.69879518072289	52	15	94	0	1	156	242	293	CCX05784.1 Similar to Exoglucanase 1; acc. no. P13860 [Pyronema omphalodes CBS 100304]	diamond	780	92.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pezizomycetes	Pezizales	Pyronemataceae	Pyronema	Pyronema omphalodes

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