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

11 rows where bioproject = "PRJNA396510" 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
1079188	1079188	PRJNA396510_P_NODE_8781_length_202_cov_1.000000_g8712_i0	PRJNA396510	8781	202	1	2.02	Eukaryota	2759	Fungi	Fungi	374	3.3e-99	NTclustered	gi\|8096248\|dbj\|AB021693.1\|	5004	g8712	i0	100	100.009900990099	202	0	100	0	1	202	128	329	Sporidiobolus ruineniae gene for 18S ribosomal RNA, partial sequence	blastn	20202	374	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodosporidiobolus	Rhodosporidiobolus ruineniae
1686759	1686759	PRJNA396510_P_NODE_8902_length_201_cov_0.953947_g8833_i0	PRJNA396510	8902	201	0.953947	1.91743347	Malassezia furfur	55194	Fungi	Fungi	361	2.5599999999999998e-95	NTclustered	gi\|2175024207\|gb\|OM190397.1\|	55194	g8833	i0	99.005	84	201	2	100	0	1	201	625	825	Malassezia furfur strain SB910 small subunit ribosomal RNA gene, partial sequence	blastn	16884	361	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia furfur
8731912	8731912	PRJNA396510_P_NODE_12107_length_174_cov_0.816000_g12038_i0	PRJNA396510	12107	174	0.816	1.41984	Opisthokonta	33154	Fungi	Fungi	322	1.01e-83	NTclustered	gi\|915512607\|gb\|KP825390.1\|	76775	g12038	i0	100	100	174	0	100	0	1	174	278	451	Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence	blastn	17400	322	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
12557851	12557851	PRJNA396510_P_NODE_3470_length_302_cov_1.498024_g3401_i0	PRJNA396510	3470	302	1.498024	4.52403248	Malassezia	55193	Fungi	Fungi	558	1.36e-154	NTclustered	gi\|915512619\|gb\|KP825402.1\|	76775	g3401	i0	100	97.3344370860927	302	0	100	0	1	302	7	308	Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence	blastn	29395	558	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
14440823	14440823	PRJNA396510_P_NODE_16052_length_162_cov_0.902655_g15983_i0	PRJNA396510	16052	162	0.902655	1.4623011	Malassezia globosa	76773	Fungi	Fungi	287	3.39e-73	NTclustered	gi\|164656600\|ref\|XM_001729376.1\|	425265	g15983	i0	98.758	1.45679012345679	161	2	99	0	2	162	1498	1658	Malassezia globosa CBS 7966 uncharacterized protein (MGL_3463), partial mRNA	blastn	236	287	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
19537800	19537800	PRJNA396510_P_NODE_15236_length_163_cov_0.894737_g15167_i0	PRJNA396510	15236	163	0.894737	1.45842131	Malassezia restricta	76775	Fungi	Fungi	291	2.64e-74	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g15167	i0	98.773	28.0858895705521	163	2	100	0	1	163	1840	1678	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	4578	291	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
22088424	22088424	PRJNA396510_P_NODE_15558_length_163_cov_0.894737_g15489_i0	PRJNA396510	15558	163	0.894737	1.45842131	Moniliophthora roreri	221103	Fungi	Fungi	58.4	2.92e-4	NTclustered	gi\|330339441\|ref\|NC_015400.1\|	221103	g15489	i0	97.143	0.214723926380368	35	0	21	1	82	116	33616	33649	Moniliophthora roreri mitochondrion, complete genome	blastn	35	58.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Marasmiaceae	Moniliophthora	Moniliophthora roreri
27012045	27012045	PRJNA396510_P_NODE_16082_length_162_cov_0.902655_g16013_i0	PRJNA396510	16082	162	0.902655	1.4623011	Malassezia furfur	55194	Fungi	Fungi	90.1	2.25e-19	NR	KAI3629254.1	55194	g16013	i0	86.8	0.981481481481482	53	7	98.1	0	161	3	334	386	KAI3629254.1 hypothetical protein CBS9595_000326 [Malassezia furfur]	diamond	159	90.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia furfur
27328369	27328369	PRJNA396510_P_NODE_13883_length_166_cov_0.871795_g13814_i0	PRJNA396510	13883	166	0.871795	1.4471797	Malassezia sp. CBS 17886	3031751	Fungi	Fungi	100	6.03e-23	NR	WFD31456.1	3031751	g13814	i0	83	0.957831325301205	53	9	95.8	0	7	165	1220	1272	WFD31456.1 cell division cycle- protein [Malassezia sp. CBS 17886]	diamond	159	100	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia sp. CBS 17886
28686234	28686234	PRJNA396510_P_NODE_7387_length_218_cov_0.881657_g7318_i0	PRJNA396510	7387	218	0.881657	1.92201226	Marasmiellus scandens	2682957	Fungi	Fungi	42	0.0488	NR	KAK7455862.1	2682957	g7318	i0	32.9	1.0045871559633	73	44	93.6	1	6	209	164	236	KAK7455862.1 hypothetical protein VKT23_010899 [Marasmiellus scandens]	diamond	219	42	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Marasmiellus	Marasmiellus scandens
31307633	31307633	PRJNA396510_P_NODE_16315_length_161_cov_0.910714_g16246_i0	PRJNA396510	16315	161	0.910714	1.46624954	Malassezia sympodialis ATCC 42132	1230383	Fungi	Fungi	54.3	1.01e-6	NR	XP_018739843.1	1230383	g16246	i0	56	1.86335403726708	50	21	93.2	1	154	5	417	465	XP_018739843.1 uncharacterized protein MSY001_1246 [Malassezia sympodialis ATCC 42132]	diamond	300	54.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia sympodialis

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