metadata: contig_metadata: 13 rows where bioproject = "PRJNA450632" and tax

13 rows where bioproject = "PRJNA450632" 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
439153	439153	PRJNA450632_P_NODE_10441_length_261_cov_1.389381_g10262_i0	PRJNA450632	10441	261	1.389381	3.62628441	Malassezia globosa	76773	Fungi	Fungi	483	7.12e-132	NTclustered	gi\|1805972860\|gb\|CP046440.1\|	76773	g10262	i0	100	95.6973180076628	261	0	100	0	1	261	1926	2186	Malassezia globosa strain CBS7966 mitochondrion, complete genome	blastn	24977	483	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
4266572	4266572	PRJNA450632_P_NODE_6644_length_358_cov_2.374613_g6465_i0	PRJNA450632	6644	358	2.374613	8.50111454	Leucosporidium scottii	5278	Fungi	Fungi	529	1.2799999999999996e-145	NTclustered	gi\|1358186634\|gb\|MH047191.1\|	5278	g6465	i0	93.296	105.039106145251	358	24	100	0	1	358	4105	3748	Leucosporidium scottii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	37604	529	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Leucosporidiales	Leucosporidiaceae	Leucosporidium	Leucosporidium scottii
4920681	4920681	PRJNA450632_P_NODE_10864_length_254_cov_1.995434_g10685_i0	PRJNA450632	10864	254	1.995434	5.06840236	Dioszegia	165440	Fungi	Fungi	424	4.2399999999999996e-114	NTclustered	gi\|284468567\|gb\|GU328514.1\|	175244	g10685	i0	96.85	95.5787401574803	254	7	99	1	1	253	724	471	Uncultured Basidiomycota clone man22_litter_B09 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	24277	424	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota					uncultured Basidiomycota
6195577	6195577	PRJNA450632_P_NODE_19045_length_174_cov_1.827338_g18866_i0	PRJNA450632	19045	174	1.827338	3.17956812	Malassezia	55193	Fungi	Fungi	322	1.01e-83	NTclustered	gi\|1321659621\|gb\|KY911094.1\|	76775	g18866	i0	100	46.3563218390805	174	0	100	0	1	174	33651	33478	Malassezia restricta mitochondrion, complete genome	blastn	8066	322	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
8092531	8092531	PRJNA450632_P_NODE_20047_length_168_cov_1.894737_g19868_i0	PRJNA450632	20047	168	1.894737	3.18315816	Malassezia pachydermatis	77020	Fungi	Fungi	99	1.79e-16	NTclustered	gi\|1063862975\|ref\|XM_018135079.1\|	77020	g19868	i0	85.87	6.75595238095238	92	13	55	0	62	153	76	167	Malassezia pachydermatis 40s ribosomal protein s27 (Malapachy_0563), partial mRNA	blastn	1135	99	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia pachydermatis
8092740	8092740	PRJNA450632_P_NODE_7547_length_326_cov_4.395189_g7368_i0	PRJNA450632	7547	326	4.395189	14.32831614	Malassezia restricta	76775	Fungi	Fungi	558	1.48e-154	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g7368	i0	97.554	83.3036809815951	327	7	100	1	1	326	2978	3304	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	27157	558	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
12571429	12571429	PRJNA450632_P_NODE_19370_length_172_cov_1.532847_g19191_i0	PRJNA450632	19370	172	1.532847	2.63649684	Pleurotus	5320	Fungi	Fungi	270	3.66e-68	NTclustered	gi\|148358037\|gb\|DQ071722.2\|	5322	g19191	i0	94.857	103.604651162791	175	6	100	2	1	172	1460	1634	Pleurotus ostreatus voucher TUB 011571 28S large subunit ribosomal RNA gene, partial sequence	blastn	17820	270	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus ostreatus
13846072	13846072	PRJNA450632_P_NODE_19331_length_172_cov_1.861314_g19152_i0	PRJNA450632	19331	172	1.861314	3.20146008	Physalacriaceae	862241	Fungi	Fungi	303	3.61e-78	NTclustered	gi\|84873668\|gb\|DQ338540.1\|	47425	g19152	i0	98.276	103.093023255814	174	1	100	2	1	172	1461	1288	Armillaria borealis strain CMW 3172 large subunit ribosomal RNA gene, partial sequence	blastn	17732	303	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Armillaria	Armillaria borealis
17670166	17670166	PRJNA450632_P_NODE_17334_length_185_cov_4.380000_g17155_i0	PRJNA450632	17334	185	4.38	8.103	Fungi	4751	Fungi	Fungi	326	8.430000000000001e-85	NTclustered	gi\|827515687\|gb\|KP346957.1\|	5003	g17155	i0	98.378	100.005405405405	185	3	100	0	1	185	148	332	Sporidiobolus pararoseus strain CBS 13692 26S ribosomal RNA gene, partial sequence	blastn	18501	326	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces pararoseus
20218728	20218728	PRJNA450632_P_NODE_11596_length_243_cov_2.038462_g11417_i0	PRJNA450632	11596	243	2.038462	4.95346266	Basidiomycota	5204	Fungi	Fungi	394	3.16e-105	NTclustered	gi\|357593611\|gb\|JN938622.1\|	5003	g11417	i0	95.902	100.411522633745	244	8	100	2	1	243	1005	763	Sporidiobolus pararoseus strain MCA 3662 18S ribosomal RNA (SSU) gene, partial sequence	blastn	24400	394	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces pararoseus
24665799	24665799	PRJNA450632_P_NODE_7200_length_338_cov_1.297030_g7021_i0	PRJNA450632	7200	338	1.29703	4.3839614	Rhodotorula graminis	29898	Fungi	Fungi	346	1.31e-90	NTclustered	gi\|1069924879\|ref\|XM_018414273.1\|	578459	g7021	i0	85.207	10.2810650887574	338	48	99	2	2	338	450	114	Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_43715), partial mRNA	blastn	3475	346	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula graminis
25318761	25318761	PRJNA450632_P_NODE_22660_length_155_cov_2.666667_g22481_i0	PRJNA450632	22660	155	2.666667	4.13333385	Basidiomycota	5204	Fungi	Fungi	281	1.49e-71	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g22481	i0	99.355	137.41935483871	155	1	100	0	1	155	1469	1315	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	21300	281	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
26949430	26949430	PRJNA450632_P_NODE_12102_length_236_cov_1.781095_g11923_i0	PRJNA450632	12102	236	1.781095	4.2033842	Puccinia triticina	208348	Fungi	Fungi	62.8	6.88e-10	NR	XP_053016611.1	208348	g11923	i0	41.9	0.940677966101695	74	43	94.1	0	234	13	81	154	XP_053016611.1 uncharacterized protein PtA15_1A394 [Puccinia triticina]	diamond	222	62.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia triticina

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