metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA397733" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA397733" 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
3630686	3630686	PRJNA397733_S_NODE_13963_length_163_cov_17.238806_g13875_i0	PRJNA397733	13963	163	17.238806	28.09925378	Opisthokonta	33154	Fungi	Fungi	302	1.22e-77	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g13875	i0	100	99.7300613496933	163	0	100	0	1	163	838	676	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	16256	302	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
7457825	7457825	PRJNA397733_S_NODE_5606_length_255_cov_7.411504_g5518_i0	PRJNA397733	5606	255	7.411504	18.8993352	Malassezia	55193	Fungi	Fungi	466	6.98e-127	NTclustered	gi\|953821272\|gb\|KT310070.1\|	76773	g5518	i0	99.608	94.9607843137255	255	1	100	0	1	255	682	428	Malassezia globosa isolate 1242 large subunit ribosomal RNA gene, partial sequence	blastn	24215	466	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
8732690	8732690	PRJNA397733_S_NODE_8907_length_201_cov_23.046512_g8819_i0	PRJNA397733	8907	201	23.046512	46.32348912	Basidiomycota	5204	Fungi	Fungi	337	4.309999999999999e-88	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g8819	i0	99.459	107.950248756219	185	1	92	0	17	201	2643	2827	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	21698	337	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
10007991	10007991	PRJNA397733_S_NODE_4448_length_289_cov_18.234615_g4360_i0	PRJNA397733	4448	289	18.234615	52.69803735	Malassezia	55193	Fungi	Fungi	532	7.84e-147	NTclustered	gi\|915512619\|gb\|KP825402.1\|	76775	g4360	i0	100	98.6297577854671	288	0	99	0	1	288	21	308	Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence	blastn	28504	532	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
11890932	11890932	PRJNA397733_S_NODE_1810_length_474_cov_14.696629_g1723_i0	PRJNA397733	1810	474	14.696629	69.66202146	Malassezia restricta	76775	Fungi	Fungi	876	0	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g1723	i0	100	106.537974683544	474	0	100	0	1	474	1466	1939	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	50499	876	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
14441035	14441035	PRJNA397733_S_NODE_3132_length_350_cov_11.389408_g3044_i0	PRJNA397733	3132	350	11.389408	39.862928	Malassezia restricta	76775	Fungi	Fungi	636	7.18e-178	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g3044	i0	99.429	91.48	350	2	100	0	1	350	2976	3325	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	32018	636	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
18931390	18931390	PRJNA397733_S_NODE_10595_length_185_cov_8.692308_g10507_i0	PRJNA397733	10595	185	8.692308	16.0807698	Basidiomycota	5204	Fungi	Fungi	313	6.56e-81	NTclustered	gi\|38906065\|gb\|AY436630.1\|	108892	g10507	i0	97.297	99.8702702702703	185	4	100	1	1	185	911	728	Inonotus baumii strain MPNU 7005 18S ribosomal RNA gene, complete sequence	blastn	18476	313	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Hymenochaetaceae	Sanghuangporus	Sanghuangporus baumii
20206093	20206093	PRJNA397733_S_NODE_13776_length_164_cov_9.555556_g13688_i0	PRJNA397733	13776	164	9.555556	15.67111184	Malassezia	55193	Fungi	Fungi	298	1.59e-76	NTclustered	gi\|56474918\|gb\|AY743630.1\|	76773	g13688	i0	99.39	100	164	1	100	0	1	164	272	435	Malassezia globosa strain CBS 7966 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	16400	298	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
21481599	21481599	PRJNA397733_S_NODE_7137_length_226_cov_13.482234_g7049_i0	PRJNA397733	7137	226	13.482234	30.46984884	Basidiomycota	5204	Fungi	Fungi	375	1.05e-99	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g7049	i0	96.875	104.867256637168	224	7	99	0	1	224	2400	2623	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	23700	375	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta

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