metadata: contig_metadata: 10 rows where bioproject = "PRJNA909412" and tax

10 rows where bioproject = "PRJNA909412" 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
8543630	8543630	PRJNA909412_P_NODE_5347_length_225_cov_2.908602_g5206_i0	PRJNA909412	5347	225	2.908602	6.5443545	Fungi	4751	Fungi	Fungi	111	1.46e-29	NR	RKP11106.1	78915	g5206	i0	74.3	7.90666666666667	74	19	98.7	0	4	225	55	128	RKP11106.1 60S ribosomal protein L32 [Thamnocephalis sphaerospora]	diamond	1779	112	0.991071428571429	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
12369740	12369740	PRJNA909412_P_NODE_11930_length_165_cov_2.095238_g11789_i0	PRJNA909412	11930	165	2.095238	3.4571427	Fungi	4751	Fungi	Fungi	115	3.859999999999999e-31	NR	XP_040745615.1	61395	g11789	i0	90.7	143.345454545455	54	5	98.2	0	164	3	37	90	XP_040745615.1 ubiquitin-conjugating enzyme [Linderina pennispora]	diamond	23652	116	0.991379310344828	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
16193490	16193490	PRJNA909412_P_NODE_5193_length_229_cov_2.068421_g5052_i0	PRJNA909412	5193	229	2.068421	4.73668409	Opisthokonta	33154	Fungi	Fungi	99.8	7.15e-25	NR	KAJ1674193.1	68401	g5052	i0	68.8	26.2401746724891	77	22	98.3	1	226	2	32	108	KAJ1674193.1 ribosomal protein S15, partial [Spiromyces aspiralis]	diamond	6009	99.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
17468982	17468982	PRJNA909412_P_NODE_3674_length_274_cov_2.255319_g3533_i0	PRJNA909412	3674	274	2.255319	6.17957406	Fungi	4751	Fungi	Fungi	134	6.28e-38	NR	ORY02099.1	1314790	g3533	i0	91.2	78.7773722627737	68	6	74.5	0	2	205	80	147	ORY02099.1 ubiquitin-conjugating enzyme [Basidiobolus meristosporus CBS 931.73]	diamond	21585	134	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
26992552	26992552	PRJNA909412_P_NODE_11242_length_171_cov_1.250000_g11101_i0	PRJNA909412	11242	171	1.25	2.1375	Coemansia guatemalensis	2761395	Fungi	Fungi	48.1	9.56e-5	NR	KAJ2795190.1	2761395	g11101	i0	54.9	1.6140350877193	51	20	84.2	1	149	6	5	55	KAJ2795190.1 ADP/ATP carrier protein, partial [Coemansia guatemalensis]	diamond	276	48.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia guatemalensis
27031785	27031785	PRJNA909412_P_NODE_12182_length_163_cov_1.798387_g12041_i0	PRJNA909412	12182	163	1.798387	2.93137081	Eukaryota	2759	Fungi	Fungi	98.6	3.62e-23	NR	KAI9477504.1	4864	g12041	i0	86	17.2638036809816	50	7	92	0	13	162	53	102	KAI9477504.1 thymidylate synthase/dCMP hydroxymethylase domain-containing protein [Coemansia mojavensis]	diamond	2814	98.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia mojavensis
27593323	27593323	PRJNA909412_P_NODE_11984_length_165_cov_1.000000_g11843_i0	PRJNA909412	11984	165	1	1.65	Basidiobolus ranarum	34480	Fungi	Fungi	42	0.0245	NR	KAK9703249.1	34480	g11843	i0	35.2	0.981818181818182	54	35	98.2	0	165	4	140	193	KAK9703249.1 hypothetical protein K7432_010836 [Basidiobolus ranarum]	diamond	162	42	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
29652538	29652538	PRJNA909412_P_NODE_3510_length_280_cov_2.560166_g3369_i0	PRJNA909412	3510	280	2.560166	7.1684648	Eukaryota	2759	Fungi	Fungi	69.7	7e-13	NR	KAI8872700.1	304332	g3369	i0	50.7	8.475	67	25	71.8	1	279	79	28	86	KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus]	diamond	2373	69.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
31731046	31731046	PRJNA909412_P_NODE_9437_length_174_cov_3.725926_g9296_i0	PRJNA909412	9437	174	3.725926	6.48311124	Coemansia javaensis	2761396	Fungi	Fungi	61.2	4.32e-9	NR	KAJ2780387.1	2761396	g9296	i0	47.5	1.05172413793103	61	24	91.4	1	173	15	272	332	KAJ2780387.1 FKBP12-associated protein [Coemansia javaensis]	diamond	183	61.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia javaensis
32364118	32364118	PRJNA909412_P_NODE_2379_length_345_cov_2.620915_g2239_i0	PRJNA909412	2379	345	2.620915	9.04215675	Basidiobolus ranarum	34480	Fungi	Fungi	50.4	2.34e-4	NR	KAK9720193.1	34480	g2239	i0	29.8	0.817391304347826	94	66	81.7	0	338	57	663	756	KAK9720193.1 adenyl-nucleotide exchange factor sse1 [Basidiobolus ranarum]	diamond	282	50.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum

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