metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA602115" 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
27946086	27946086	PRJNA602115_P_NODE_10405_length_205_cov_0.888889_g10380_i0	PRJNA602115	10405	205	0.888889	1.82222245	Sordariomycetes	147550	Fungi	Fungi	79	3.7e-15	NR	TDZ28190.1	5466	g10380	i0	65.7	18.8341463414634	67	23	98	0	1	201	319	385	TDZ28190.1 60S ribosomal protein L18-B [Colletotrichum trifolii]	diamond	3861	79.3	0.996216897856242	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum trifolii
28406476	28406476	PRJNA602115_P_NODE_11566_length_202_cov_0.872340_g11541_i0	PRJNA602115	11566	202	0.87234	1.7621268	Penicilliopsis zonata CBS 5	41063	Fungi	Fungi	56.6	2.79e-7	NR	XP_022582779.1	1073090	g11541	i0	53.7	1.70792079207921	54	24	78.7	1	2	160	477	530	XP_022582779.1 hypothetical protein ASPZODRAFT_92710 [Penicilliopsis zonata CBS 506.65]	diamond	345	56.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicilliopsis	Penicilliopsis zonata
30093028	30093028	PRJNA602115_P_NODE_10632_length_204_cov_0.895105_g10607_i0	PRJNA602115	10632	204	0.895105	1.8260142	Helotiales	5178	Fungi	Fungi	97.1	2.85e-24	NR	KAK6598951.1	40559	g10607	i0	84.7	5.11764705882353	59	9	86.8	0	203	27	48	106	KAK6598951.1 60s ribosomal protein l26 [Botrytis cinerea]	diamond	1044	97.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Sclerotiniaceae	Botrytis	Botrytis cinerea
30504036	30504036	PRJNA602115_P_NODE_4393_length_297_cov_1.355932_g4368_i0	PRJNA602115	4393	297	1.355932	4.02711804	Ophiostomataceae	5152	Fungi	Fungi	94.7	1.83e-22	NR	XP_014173999.1	655863	g4368	i0	58.3	4.33333333333333	84	35	84.8	0	2	253	50	133	XP_014173999.1 ribosomal protein l26 [Grosmannia clavigera kw1407]	diamond	1287	95.5	0.991623036649215	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Ophiostomatales	Ophiostomataceae	Leptographium	Leptographium clavigerum
32401330	32401330	PRJNA602115_P_NODE_9639_length_207_cov_0.876712_g9614_i0	PRJNA602115	9639	207	0.876712	1.81479384	Fungi	4751	Fungi	Fungi	99.4	1.22e-22	NR	XP_040677356.1	1081103	g9614	i0	69.2	12.231884057971	65	20	94.2	0	1	195	31	95	XP_040677356.1 DEAD-like helicase [Metarhizium album ARSEF 1941]	diamond	2532	99.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Clavicipitaceae	Metarhizium	Metarhizium album
32829629	32829629	PRJNA602115_P_NODE_11000_length_203_cov_0.901408_g10975_i0	PRJNA602115	11000	203	0.901408	1.82985824	Erysiphe pulchra	225359	Fungi	Fungi	145	2.34e-39	NR	POS83175.1	225359	g10975	i0	97	1.98029556650246	67	2	99	0	1	201	82	148	POS83175.1 hypothetical protein EPUL_005876 [Erysiphe pulchra]	diamond	402	145	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Erysiphe	Erysiphe pulchra

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