metadata: contig_metadata: 11 rows where bioproject = "PRJNA436017", tax_kingdom = "Fungi" and tax

11 rows where bioproject = "PRJNA436017", tax_kingdom = "Fungi" and tax_phylum = "Zoopagomycota"

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
4257554	4257554	PRJNA436017_P_NODE_10344_length_268_cov_1.277056_g10046_i0	PRJNA436017	10344	268	1.277056	3.42251008	Fungi	4751	Fungi	Fungi	156	8.03e-45	NR	KAK9718484.1	34480	g10046	i0	78.7	18.9291044776119	89	19	99.6	0	1	267	162	250	KAK9718484.1 60S ribosomal protein L3 [Basidiobolus ranarum]	diamond	5073	156	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
22107541	22107541	PRJNA436017_P_NODE_3698_length_485_cov_3.575893_g3414_i0	PRJNA436017	3698	485	3.575893	17.34308105	Eukaryota	2759	Fungi	Fungi	212	2.51e-67	NR	KAJ1927577.1	78921	g3414	i0	71.7	23.820618556701	145	40	89.1	1	26	457	22	166	KAJ1927577.1 ribosomal protein S23 [Tieghemiomyces parasiticus]	diamond	11553	213	0.995305164319249	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Tieghemiomyces	Tieghemiomyces parasiticus
24657339	24657339	PRJNA436017_P_NODE_8120_length_310_cov_2.065934_g7823_i0	PRJNA436017	8120	310	2.065934	6.4043954	Zoophagus pectosporus	2082958	Fungi	Fungi	126	1.68e-24	NTclustered	gi\|2130025291\|gb\|OL396565.1\|	2082958	g7823	i0	83.704	36.0838709677419	135	21	43	1	77	210	335	201	Zoophagus pectosporus isolate B39 large subunit ribosomal RNA gene, partial sequence	blastn	11186	126	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Zoopagaceae	Zoophagus	Zoophagus pectosporus
26617449	26617449	PRJNA436017_P_NODE_15981_length_206_cov_2.171598_g15683_i0	PRJNA436017	15981	206	2.171598	4.47349188	Fungi	4751	Fungi	Fungi	60.1	6.88e-10	NR	KAJ1989321.1	215637	g15683	i0	49	1.51456310679612	49	25	71.4	0	201	55	20	68	KAJ1989321.1 40S ribosomal protein S21 [Dimargaris cristalligena]	diamond	312	60.5	0.993388429752066	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
27440199	27440199	PRJNA436017_P_NODE_20563_length_180_cov_2.000000_g20265_i0	PRJNA436017	20563	180	2	3.6	root	1	Root_unresolved	Root_unresolved	73.2	3.02e-13	NR	ORX91306.1	1314790	g20265	i0	56.1	1.91666666666667	57	25	95	0	174	4	121	177	ORX91306.1 ADP-ribosylglycohydrolase [Basidiobolus meristosporus CBS 931.73]	diamond	345	73.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
28149797	28149797	PRJNA436017_P_NODE_19665_length_184_cov_1.857143_g19367_i0	PRJNA436017	19665	184	1.857143	3.41714312	Smittium megazygosporum	133381	Fungi	Fungi	55.8	5.2100000000000003e-08	NR	PVV04822.1	133381	g19367	i0	51.7	1.77717391304348	60	27	97.8	1	183	4	11	68	PVV04822.1 hypothetical protein BB560_000667 [Smittium megazygosporum]	diamond	327	55.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium megazygosporum
28197555	28197555	PRJNA436017_P_NODE_966_length_948_cov_3.336992_g812_i0	PRJNA436017	966	948	3.336992	31.63468416	Eukaryota	2759	Fungi	Fungi	306	1.85e-100	NR	KAJ9073237.1	34485	g812	i0	55.9	35.4177215189873	272	106	86.1	1	918	103	1	258	KAJ9073237.1 40S ribosomal protein S4 [Entomophthora muscae]	diamond	33576	307	0.996742671009772	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
29208235	29208235	PRJNA436017_P_NODE_13329_length_230_cov_1.207254_g13031_i0	PRJNA436017	13329	230	1.207254	2.7766842	Zoopagomycota	1913638	Fungi	Fungi	74.7	1.14e-14	NR	PVU94845.1	133385	g13031	i0	56.3	3.54782608695652	64	28	83.5	0	193	2	41	104	PVU94845.1 hypothetical protein BB561_002225 [Smittium simulii]	diamond	816	74.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium simulii
29475475	29475475	PRJNA436017_P_NODE_12690_length_236_cov_3.271357_g12392_i0	PRJNA436017	12690	236	3.271357	7.72040252	Ramicandelaber brevisporus	304332	Fungi	Fungi	87.4	1.02e-19	NR	KAI8870081.1	304332	g12392	i0	56.5	0.877118644067797	69	30	87.7	0	208	2	4	72	KAI8870081.1 ribosomal protein S19e [Ramicandelaber brevisporus]	diamond	207	87.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
30787401	30787401	PRJNA436017_P_NODE_27074_length_157_cov_1.125000_g26776_i0	PRJNA436017	27074	157	1.125	1.76625	Coemansia	4863	Fungi	Fungi	90.9	1.27e-19	NR	KAJ1724546.1	147472	g26776	i0	75.5	33.687898089172	49	12	93.6	0	11	157	440	488	KAJ1724546.1 hypothetical protein LPJ53_001192 [Coemansia erecta]	diamond	5289	90.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia erecta
30897494	30897494	PRJNA436017_P_NODE_22414_length_173_cov_1.044118_g22116_i0	PRJNA436017	22414	173	1.044118	1.80632414	Massospora cicadina	348617	Fungi	Fungi	41.6	0.0379	NR	KAI0227517.1	348617	g22116	i0	46.5	0.745664739884393	43	18	74.6	2	166	38	62	99	KAI0227517.1 Rho-type gtpase-activating protein [Massospora cicadina]	diamond	129	41.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Massospora	Massospora cicadina

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