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

11 rows where bioproject = "PRJNA929940" 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
10183461	10183461	PRJNA929940_S_NODE_20568_length_226_cov_5.216931_g20333_i0	PRJNA929940	20568	226	5.216931	11.79026406	Eurotiomycetes	147545	Fungi	Fungi	418	1.7199999999999998e-112	NTclustered	gi\|4098984\|gb\|U81264.1\|APU81264	41959	g20333	i0	100	100	226	0	100	0	1	226	361	136	Aspergillus penicillioides 28S ribosomal RNA gene, partial sequence	blastn	22600	418	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus penicillioides
15282711	15282711	PRJNA929940_S_NODE_14612_length_258_cov_5.742081_g14377_i0	PRJNA929940	14612	258	5.742081	14.81456898	Eukaryota	2759	Fungi	Fungi	202	2.1999999999999997e-47	NTclustered	gi\|2797496751\|ref\|XM_067691726.1\|	273372	g14377	i0	82.819	89.5736434108527	227	37	88	2	1	226	20	245	Candida metapsilosis translation elongation factor EF-1 alpha (I9W82_002828), partial mRNA	blastn	23110	202	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida metapsilosis
22586106	22586106	PRJNA929940_S_NODE_34338_length_186_cov_1.295302_g34103_i0	PRJNA929940	34338	186	1.295302	2.40926172	Limtongia smithiae	1125753	Fungi	Fungi	52.8	0.016	NTclustered	gi\|2781505902\|ref\|XM_066903428.1\|	1125753	g34103	i0	100	0.150537634408602	28	0	15	0	100	127	698	725	Limtongia smithiae uncharacterized protein (V1518DRAFT_413920), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Limtongia	Limtongia smithiae
22586119	22586119	PRJNA929940_S_NODE_9918_length_299_cov_1.614504_g9683_i0	PRJNA929940	9918	299	1.614504	4.82736696	Trichoderma atroviride	63577	Fungi	Fungi	86.1	2.74e-12	NTclustered	gi\|2749703766\|ref\|XM_014090103.2\|	63577	g9683	i0	88	1.47491638795987	75	6	25	1	26	100	2198	2269	Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA	blastn	441	86.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Trichoderma	Trichoderma atroviride
22932612	22932612	PRJNA929940_S_NODE_53438_length_156_cov_2.243697_g53203_i0	PRJNA929940	53438	156	2.243697	3.50016732	root	1	Root_unresolved	Root_unresolved	289	9e-74	NTclustered	gi\|2588676\|dbj\|AB008407.1\|	5064	g53203	i0	100	100	156	0	100	0	1	156	1583	1428	Aspergillus restrictus gene for 18S rRNA, partial sequence	blastn	15600	289	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus restrictus
27846118	27846118	PRJNA929940_S_NODE_29124_length_198_cov_1.677019_g28889_i0	PRJNA929940	29124	198	1.677019	3.32049762	Caeruleum heppii	2939410	Fungi	Fungi	42.4	0.0294	NR	KAI9676422.1	2939410	g28889	i0	35.6	0.681818181818182	45	26	68.2	1	49	183	339	380	KAI9676422.1 MAG: hypothetical protein M1817_000579 [Caeruleum heppii]	diamond	135	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Acarosporales	Acarosporaceae	Caeruleum	Caeruleum heppii
30467607	30467607	PRJNA929940_S_NODE_3393_length_437_cov_3.947500_g3160_i0	PRJNA929940	3393	437	3.9475	17.250575	Aspergillus nomiae NRRL 13137	1509407	Fungi	Fungi	45.1	0.0425	NR	XP_015410206.1	1509407	g3160	i0	36.7	0.411899313501144	60	36	39.8	1	64	237	43	102	XP_015410206.1 uncharacterized protein ANOM_001644 [Aspergillus nomiae NRRL 13137]	diamond	180	45.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus nomiae
30568831	30568831	PRJNA929940_S_NODE_11153_length_286_cov_2.983936_g10918_i0	PRJNA929940	11153	286	2.983936	8.53405696	Eukaryota	2759	Fungi	Fungi	57	6.01e-7	NR	KAI6709330.1	946123	g10918	i0	73	1.59440559440559	37	9	38.8	1	176	286	215	250	KAI6709330.1 mannose-1-phosphate guanyltransferase [Diplocarpon mali]	diamond	456	57	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Drepanopezizaceae	Diplocarpon	Diplocarpon mali
30593554	30593554	PRJNA929940_S_NODE_34553_length_185_cov_2.560811_g34318_i0	PRJNA929940	34553	185	2.560811	4.73750035	Trichothecium roseum	47278	Fungi	Fungi	43.9	0.00684	NR	KAI9902123.1	47278	g34318	i0	33.3	1.11891891891892	69	29	84.3	2	171	16	380	448	KAI9902123.1 hypothetical protein N3K66_003940 [Trichothecium roseum]	diamond	207	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales		Trichothecium	Trichothecium roseum
31225451	31225451	PRJNA929940_S_NODE_8095_length_322_cov_1.750877_g7860_i0	PRJNA929940	8095	322	1.750877	5.63782394	Colletotrichum higginsianum IMI 349	80884	Fungi	Fungi	42.7	0.0412	NR	XP_018152744.1	759273	g7860	i0	38.9	0.503105590062112	54	30	47.5	2	75	227	51	104	XP_018152744.1 hypothetical protein CH63R_13353 [Colletotrichum higginsianum IMI 349063]	diamond	162	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum higginsianum
31700060	31700060	PRJNA929940_S_NODE_12277_length_276_cov_2.451883_g12042_i0	PRJNA929940	12277	276	2.451883	6.76719708	Penicillium expansum	27334	Fungi	Fungi	43.1	0.0399	NR	XP_016593829.1	27334	g12042	i0	40.7	1.28260869565217	59	30	58.7	2	274	113	320	378	XP_016593829.1 Major facilitator superfamily domain, general substrate transporter [Penicillium expansum]	diamond	354	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium expansum

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