metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax_phylum = "Ascomycota"

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
7358271	7358271	PRJNA999747_S_NODE_2606_length_192_cov_2.111801_g2574_i0	PRJNA999747	2606	192	2.111801	4.05465792	Eukaryota	2759	Fungi	Fungi	112	7.35e-27	NR	AAD09565.1	4754	g2574	i0	79.7	130	64	13	100	0	192	1	204	267	AAD09565.1 heat shock protein 70, partial [Pneumocystis carinii]	diamond	24960	112	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pneumocystomycetes	Pneumocystales	Pneumocystaceae	Pneumocystis	Pneumocystis carinii
26747075	26747075	PRJNA999747_S_NODE_681_length_336_cov_3.163934_g649_i0	PRJNA999747	681	336	3.163934	10.63081824	Exophiala	5583	Fungi	Fungi	53.5	1.51e-5	NR	KAJ4516297.1	5970	g649	i0	40.7	2.23214285714286	81	38	71.4	2	332	93	232	303	KAJ4516297.1 hypothetical protein HRR73_004759 [Exophiala dermatitidis]	diamond	750	53.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Exophiala	Exophiala dermatitidis
27158484	27158484	PRJNA999747_S_NODE_2802_length_186_cov_2.354839_g2770_i0	PRJNA999747	2802	186	2.354839	4.38000054	Fungi	4751	Fungi	Fungi	87.4	1.35e-19	NR	XP_066787155.1	44089	g2770	i0	66.1	21.6129032258065	59	20	95.2	0	180	4	123	181	XP_066787155.1 thioredoxin-like protein [Dipodascopsis tothii]	diamond	4020	87.8	0.995444191343964	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Dipodascopsis	Dipodascopsis tothii
27816459	27816459	PRJNA999747_S_NODE_2444_length_197_cov_2.789157_g2412_i0	PRJNA999747	2444	197	2.789157	5.49463929	Lojkania enalia	147567	Fungi	Fungi	42.4	0.0266	NR	KAF2257479.1	147567	g2412	i0	47.3	0.83756345177665	55	28	83.8	1	20	184	167	220	KAF2257479.1 hypothetical protein CC78DRAFT_563415 [Lojkania enalia]	diamond	165	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales		Lojkania	Lojkania enalia
27910735	27910735	PRJNA999747_S_NODE_1165_length_277_cov_2.707317_g1133_i0	PRJNA999747	1165	277	2.707317	7.49926809	Aspergillus pseudoviridinutans	1517512	Fungi	Fungi	56.6	4.64e-7	NR	XP_043157348.1	1517512	g1133	i0	46.7	2.42599277978339	60	31	65	1	62	241	67	125	XP_043157348.1 uncharacterized protein Asppvi_005492 [Aspergillus pseudoviridinutans]	diamond	672	56.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus pseudoviridinutans
28068806	28068806	PRJNA999747_S_NODE_2885_length_183_cov_6.802632_g2853_i0	PRJNA999747	2885	183	6.802632	12.44881656	Scheffersomyces stipitis CBS 6	4924	Fungi	Fungi	49.7	1.84e-5	NR	XP_001387993.2	322104	g2853	i0	45.5	1.81967213114754	55	27	85.2	1	158	3	5	59	XP_001387993.2 predicted protein [Scheffersomyces stipitis CBS 6054]	diamond	333	49.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Scheffersomyces	Scheffersomyces stipitis
30247930	30247930	PRJNA999747_S_NODE_3412_length_170_cov_2.035971_g3380_i0	PRJNA999747	3412	170	2.035971	3.4611507	Candida verbasci	1227364	Fungi	Fungi	42.4	0.018	NR	CAI5758658.1	1227364	g3380	i0	51	0.9	51	21	90	2	4	156	199	245	CAI5758658.1 unnamed protein product [Candida verbasci]	diamond	153	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida verbasci
30247931	30247931	PRJNA999747_S_NODE_952_length_299_cov_3.410448_g920_i0	PRJNA999747	952	299	3.410448	10.19723952	Penicillium malachiteum	1324776	Fungi	Fungi	43.5	0.0196	NR	KAJ5710222.1	1324776	g920	i0	65.5	0.290969899665552	29	10	29.1	0	48	134	97	125	KAJ5710222.1 hypothetical protein N7493_009389 [Penicillium malachiteum]	diamond	87	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium malachiteum
30759155	30759155	PRJNA999747_S_NODE_2134_length_209_cov_1.932584_g2102_i0	PRJNA999747	2134	209	1.932584	4.03910056	Opisthokonta	33154	Fungi	Fungi	52	9.01e-6	NR	TQB67787.1	5098	g2102	i0	45.1	7.09090909090909	71	24	80.4	3	1	168	43	113	TQB67787.1 Elongation factor [Monascus purpureus]	diamond	1482	52.4	0.99236641221374	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Monascus	Monascus purpureus
31416965	31416965	PRJNA999747_S_NODE_1756_length_228_cov_2.157360_g1724_i0	PRJNA999747	1756	228	2.15736	4.9187808	Ambrosiozyma monospora	43982	Fungi	Fungi	91.7	8.16e-22	NR	GMG40253.1	43982	g1724	i0	61.4	2.73684210526316	70	27	92.1	0	7	216	31	100	GMG40253.1 unnamed protein product [Ambrosiozyma monospora]	diamond	624	91.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Ambrosiozyma	Ambrosiozyma monospora

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