metadata: contig_metadata: 8 rows where bioproject = "PRJNA287283" and tax

8 rows where bioproject = "PRJNA287283" 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
1646951	1646951	PRJNA287283_P_NODE_7562_length_197_cov_1.111111_g7338_i0	PRJNA287283	7562	197	1.111111	2.18888867	Neogloea sp. TUB 020325	1349589	Fungi	Fungi	243	9.43e-60	NTclustered	gi\|514995910\|gb\|KF061297.1\|	1349589	g7338	i0	88.832	126.502538071066	197	22	100	0	1	197	1458	1654	Helicogloea sp. TUB 020325 28S large subunit ribosomal RNA gene, partial sequence	blastn	24921	243	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Atractiellomycetes	Atractiellales	Helicogloeaceae	Neogloea	Neogloea sp. TUB 020325
3609728	3609728	PRJNA287283_P_NODE_5083_length_266_cov_2.769953_g4859_i0	PRJNA287283	5083	266	2.769953	7.36807498	Basidiomycota	5204	Fungi	Fungi	488	1.5599999999999996e-133	NTclustered	gi\|12744208\|gb\|AF314235.1\|AF314235	4972	g4859	i0	99.624	99.7368421052632	266	1	100	0	1	266	352	87	Cryptococcus hungaricus strain CBS 6569 18S ribosomal RNA gene, partial sequence	blastn	26530	492	0.991869918699187	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Bulleribasidiaceae	Dioszegia	Dioszegia hungarica
4199308	4199308	PRJNA287283_P_NODE_10564_length_175_cov_0.885246_g10340_i0	PRJNA287283	10564	175	0.885246	1.5491805	Malassezia restricta	76775	Fungi	Fungi	313	6.13e-81	NTclustered	gi\|1546636555\|ref\|XM_027629920.1\|	76775	g10340	i0	98.857	1	175	2	100	0	1	175	236	62	Malassezia restricta vacuole protein (MRET_3293), partial mRNA	blastn	175	313	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
13126017	13126017	PRJNA287283_P_NODE_10791_length_155_cov_13.117647_g10567_i0	PRJNA287283	10791	155	13.117647	20.33235285	Cystofilobasidium capitatum	5412	Fungi	Fungi	209	7.15e-50	NTclustered	gi\|501438057\|gb\|FJ644524.2\|	5412	g10567	i0	94.776	64.5677419354839	134	7	86	0	22	155	2021	1888	Cystofilobasidium capitatum voucher 01/04 28S ribosomal RNA gene, partial sequence	blastn	10008	209	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Cystofilobasidiaceae	Cystofilobasidium	Cystofilobasidium capitatum
18910621	18910621	PRJNA287283_P_NODE_8015_length_188_cov_4.140741_g7791_i0	PRJNA287283	8015	188	4.140741	7.78459308	Basidiomycota	5204	Fungi	Fungi	287	4.06e-73	NTclustered	gi\|77379307\|gb\|DQ208412.1\|	5315	g7791	i0	94.18	104.75	189	10	100	1	1	188	2419	2607	Ganoderma lucidum strain C-1 large subunit ribosomal RNA gene, partial sequence	blastn	19693	287	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Ganoderma	Ganoderma lucidum
20773686	20773686	PRJNA287283_P_NODE_8137_length_186_cov_5.263158_g7913_i0	PRJNA287283	8137	186	5.263158	9.78947388	uncultured Cystofilobasidium	997644	Fungi	Fungi	313	6.61e-81	NTclustered	gi\|1005259966\|emb\|HG936842.1\|	997644	g7913	i0	97.283	98.9247311827957	184	5	99	0	1	184	180	363	Uncultured Cystofilobasidium genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, clone 10D10C26 (MOTU83)	blastn	18400	313	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Cystofilobasidiaceae		uncultured Cystofilobasidium
29428354	29428354	PRJNA287283_P_NODE_8589_length_183_cov_0.861538_g8365_i0	PRJNA287283	8589	183	0.861538	1.57661454	Wallemia	148959	Fungi	Fungi	41.6	0.045	NR	TIA77982.1	245174	g8365	i0	41.4	1.90163934426229	58	33	95.1	1	183	10	328	384	TIA77982.1 hypothetical protein E3P98_04025 [Wallemia ichthyophaga]	diamond	348	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Wallemiomycetes	Wallemiales	Wallemiaceae	Wallemia	Wallemia ichthyophaga
29775788	29775788	PRJNA287283_P_NODE_6091_length_234_cov_0.977901_g5867_i0	PRJNA287283	6091	234	0.977901	2.28828834	Agaricomycetes	155619	Fungi	Fungi	114	1.6e-27	NR	KAH9850839.1	5632	g5867	i0	74	2.96153846153846	77	18	98.7	1	2	232	275	349	KAH9850839.1 glycosyl hydrolase family 7-domain-containing protein [Lenzites betulinus]	diamond	693	115	0.991304347826087	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Lenzites	Lenzites betulinus

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