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

11 rows where bioproject = "PRJNA752572" and tax_phylum = "Blastocladiomycota"

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
3753079	3753079	PRJNA752572_P_NODE_57983_length_359_cov_2.089506_g57476_i0	PRJNA752572	57983	359	2.089506	7.50132654	Opisthokonta	33154	Fungi	Fungi	141	5.21e-37	NR	ORZ40735.1	765915	g57476	i0	59.8	11.6239554317549	117	47	97.8	0	2	352	90	206	ORZ40735.1 SHMT-domain-containing protein [Catenaria anguillulae PL171]	diamond	4173	142	0.992957746478873	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
8381940	8381940	PRJNA752572_P_NODE_64887_length_338_cov_3.056106_g64380_i0	PRJNA752572	64887	338	3.056106	10.32963828	Catenaria anguillulae PL171	765915	Fungi	Fungi	134	3.19e-34	NR	ORZ31340.1	765915	g64380	i0	56.8	1.97041420118343	111	47	98.5	1	338	6	108	217	ORZ31340.1 aminopeptidase I zinc metalloprotease-domain-containing protein [Catenaria anguillulae PL171]	diamond	666	134	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
13482436	13482436	PRJNA752572_P_NODE_184351_length_196_cov_2.422360_g183844_i0	PRJNA752572	184351	196	2.42236	4.7478256	Blastocladiomycota	451459	Fungi	Fungi	123	9.95e-31	NR	KAJ3362316.1	64504	g183844	i0	84.6	19.8979591836735	65	10	99.5	0	1	195	1136	1200	KAJ3362316.1 DEAH-box ATP-dependent RNA helicase prp22 [Allomyces arbusculus]	diamond	3900	123	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
13482471	13482471	PRJNA752572_P_NODE_261711_length_166_cov_0.916031_g261204_i0	PRJNA752572	261711	166	0.916031	1.52061146	Allomyces	28581	Fungi	Fungi	90.1	2.71e-19	NR	KAJ3372819.1	64504	g261204	i0	78.2	13.9156626506024	55	12	99.4	0	1	165	964	1018	KAJ3372819.1 hypothetical protein GGF31_001356 [Allomyces arbusculus]	diamond	2310	90.1	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
22405983	22405983	PRJNA752572_P_NODE_209258_length_184_cov_1.073826_g208751_i0	PRJNA752572	209258	184	1.073826	1.97583984	Allomyces arbusculus	64504	Fungi	Fungi	67.4	4.92e-12	NR	KAJ3374282.1	64504	g208751	i0	60	0.978260869565217	60	24	97.8	0	3	182	114	173	KAJ3374282.1 60S ribosomal protein L20 [Allomyces arbusculus]	diamond	180	67.4	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
26989346	26989346	PRJNA752572_P_NODE_56382_length_364_cov_2.449848_g55875_i0	PRJNA752572	56382	364	2.449848	8.91744672	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	162	2.78e-47	NR	KAI9137242.1	1500003	g55875	i0	59.8	5.02747252747253	122	48	99.7	1	363	1	21	142	KAI9137242.1 phosphomannomutase [Paraphysoderma sedebokerense]	diamond	1830	162	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
27305876	27305876	PRJNA752572_P_NODE_227063_length_176_cov_1.078014_g226556_i0	PRJNA752572	227063	176	1.078014	1.89730464	Coelomomyces lativittatus	945690	Fungi	Fungi	94.4	2.32e-21	NR	KAJ1499672.1	945690	g226556	i0	77.6	4.94318181818182	58	13	98.9	0	3	176	51	108	KAJ1499672.1 hypothetical protein HMI55_004272 [Coelomomyces lativittatus]	diamond	870	94.4	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Coelomomycetaceae	Coelomomyces	Coelomomyces lativittatus
31485032	31485032	PRJNA752572_P_NODE_109236_length_258_cov_1.735426_g108729_i0	PRJNA752572	109236	258	1.735426	4.47739908	Blastocladiaceae	4806	Fungi	Fungi	108	2.05e-28	NR	KAI9222680.1	64508	g108729	i0	68.2	3.94186046511628	85	27	98.8	0	255	1	25	109	KAI9222680.1 translation protein SH3-like domain-containing protein, partial [Blastocladiella britannica]	diamond	1017	108	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
31886087	31886087	PRJNA752572_P_NODE_225417_length_176_cov_2.269504_g224910_i0	PRJNA752572	225417	176	2.269504	3.99432704	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	68.6	9.2e-12	NR	KNE65318.1	578462	g224910	i0	55.4	3.81818181818182	56	25	95.5	0	173	6	131	186	KNE65318.1 CMGC/CDK protein kinase [Allomyces macrogynus ATCC 38327]	diamond	672	68.6	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
32012735	32012735	PRJNA752572_P_NODE_252578_length_168_cov_1.195489_g252071_i0	PRJNA752572	252578	168	1.195489	2.00842152	Catenaria anguillulae PL171	765915	Fungi	Fungi	43.5	0.00725	NR	ORZ33905.1	765915	g252071	i0	40.9	0.785714285714286	44	26	78.6	0	33	164	672	715	ORZ33905.1 clustered mitochondria-domain-containing protein [Catenaria anguillulae PL171]	diamond	132	43.5	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
32212535	32212535	PRJNA752572_P_NODE_53198_length_374_cov_21.533923_g52692_i0	PRJNA752572	53198	374	21.533923	80.53687202	Fungi	4751	Fungi	Fungi	121	8.130000000000001e-33	NR	KAI9221418.1	64508	g52692	i0	59.8	4.66844919786096	97	39	77.8	0	26	316	14	110	KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica]	diamond	1746	122	0.991803278688525	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica

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