metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB2333" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB2333" 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

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