metadata: contig_metadata: 11 rows where bioproject = "PRJEB27957" and tax

11 rows where bioproject = "PRJEB27957" and tax_phylum = "Basidiomycota"

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
2573337	2573337	PRJEB27957_P_NODE_56763_length_221_cov_0.726744_g56653_i0	PRJEB27957	56763	221	0.726744	1.60610424	Hygrocybe coccinea	378274	Fungi	Fungi	303	4.9e-78	NTclustered	gi\|2586993227\|emb\|OY742001.1\|	378274	g56653	i0	91.781	99.0678733031674	219	17	99	1	1	219	34840	35057	Hygrocybe coccinea genome assembly, organelle: mitochondrion	blastn	21894	303	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Hygrophoraceae	Hygrocybe	Hygrocybe coccinea
3849617	3849617	PRJEB27957_P_NODE_98084_length_173_cov_1.677419_g97974_i0	PRJEB27957	98084	173	1.677419	2.90193487	Lactarius trivialis	217427	Fungi	Fungi	54.7	0.004	NTclustered	gi\|2091527986\|ref\|NC_057510.1\|	217427	g97974	i0	96.875	0.184971098265896	32	1	18	0	9	40	27959	27990	Lactarius trivialis mitochondrion, complete genome	blastn	32	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Lactarius	Lactarius trivialis
13740312	13740312	PRJEB27957_P_NODE_92471_length_179_cov_1.200000_g92361_i0	PRJEB27957	92471	179	1.2	2.148	Malassezia	55193	Fungi	Fungi	331	1.74e-86	NTclustered	gi\|1321659599\|gb\|KY911093.1\|	76775	g92361	i0	100	44.804469273743	179	0	100	0	1	179	32074	31896	Malassezia restricta mitochondrion, complete genome	blastn	8020	331	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
15014697	15014697	PRJEB27957_P_NODE_106012_length_168_cov_1.193277_g105902_i0	PRJEB27957	106012	168	1.193277	2.00470536	Hymenochaetaceae	40424	Fungi	Fungi	52.8	0.014	NTclustered	gi\|2459374072\|ref\|NC_072248.1\|	40471	g105902	i0	100	0.333333333333333	28	0	17	0	29	56	49420	49393	Fuscoporia gilva mitochondrion, complete genome	blastn	56	52.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Hymenochaetaceae	Fuscoporia	Fuscoporia gilva
16600190	16600190	PRJEB27957_P_NODE_111474_length_166_cov_1.333333_g111364_i0	PRJEB27957	111474	166	1.333333	2.21333278	Tricholoma myomyces	54549	Fungi	Fungi	58.4	2.99e-4	NTclustered	gi\|359744923\|gb\|JN389325.1\|	54549	g111364	i0	100	0.373493975903614	31	0	19	0	120	150	411	381	Tricholoma myomyces voucher MICH68589 25S ribosomal RNA gene, partial sequence; ribosomal intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	62	58.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Tricholomataceae	Tricholoma	Tricholoma myomyces
20424123	20424123	PRJEB27957_P_NODE_64017_length_210_cov_1.937888_g63907_i0	PRJEB27957	64017	210	1.937888	4.0695648	Flammulina velutipes	38945	Fungi	Fungi	52.8	0.018	NTclustered	gi\|511347638\|ref\|NC_021373.1\|	38945	g63907	i0	100	0.666666666666667	28	0	13	0	14	41	14632	14605	Flammulina velutipes strain 4019-20 mitochondrion, complete genome	blastn	140	52.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Flammulina	Flammulina velutipes
26875273	26875273	PRJEB27957_P_NODE_38701_length_256_cov_1.405797_g38591_i0	PRJEB27957	38701	256	1.405797	3.59884032	Boletus coccyginus	1758874	Fungi	Fungi	42.7	0.0386	NR	KAI9570093.1	1758874	g38591	i0	39	0.69140625	59	31	63.3	1	36	197	92	150	KAI9570093.1 hypothetical protein HD554DRAFT_2170720 [Boletus coccyginus]	diamond	177	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Boletaceae	Boletus	Boletus coccyginus
27033122	27033122	PRJEB27957_P_NODE_94682_length_176_cov_3.220472_g94572_i0	PRJEB27957	94682	176	3.220472	5.66803072	Crucibulum laeve	68775	Fungi	Fungi	46.2	8.25e-4	NR	TFK38387.1	68775	g94572	i0	40	0.852272727272727	50	30	85.2	0	167	18	48	97	TFK38387.1 hypothetical protein BDQ12DRAFT_630844, partial [Crucibulum laeve]	diamond	150	46.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Nidulariaceae	Crucibulum	Crucibulum laeve
27349498	27349498	PRJEB27957_P_NODE_45163_length_241_cov_1.333333_g45053_i0	PRJEB27957	45163	241	1.333333	3.21333253	Leucocoprinus birnbaumii	56174	Fungi	Fungi	42.4	0.0496	NR	KAJ3564268.1	56174	g45053	i0	48.8	0.535269709543568	43	21	52.3	1	128	3	217	259	KAJ3564268.1 hypothetical protein NP233_g8409 [Leucocoprinus birnbaumii]	diamond	129	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Agaricaceae	Leucocoprinus	Leucocoprinus birnbaumii
27381040	27381040	PRJEB27957_P_NODE_48943_length_233_cov_2.826087_g48833_i0	PRJEB27957	48943	233	2.826087	6.58478271	Leucoagaricus sp. SymC.cos	1714833	Fungi	Fungi	45.1	0.00487	NR	KXN92644.1	1714833	g48833	i0	44.7	0.489270386266094	38	21	48.9	0	12	125	312	349	KXN92644.1 O-methylsterigmatocystin oxidoreductase [Leucoagaricus sp. SymC.cos]	diamond	114	45.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Agaricaceae	Leucoagaricus	Leucoagaricus sp. SymC.cos
28927971	28927971	PRJEB27957_P_NODE_43348_length_245_cov_1.219388_g43238_i0	PRJEB27957	43348	245	1.219388	2.9875006	Chiua virens	1914213	Fungi	Fungi	42.4	0.0435	NR	KAG9316513.1	1914213	g43238	i0	34.7	0.6	49	31	58.8	1	229	86	140	188	KAG9316513.1 hypothetical protein JVU11DRAFT_2562 [Chiua virens]	diamond	147	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Boletaceae	Chiua	Chiua virens

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