metadata: contig_metadata: 6 rows where bioproject = "PRJNA560029", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA560029", tax_clade = "Opisthokonta" 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
27995036	27995036	PRJNA560029_S_NODE_20925_length_298_cov_2.751111_g20701_i0	PRJNA560029	20925	298	2.751111	8.19831078	Massospora cicadina	348617	Fungi	Fungi	96.3	3.88e-22	NR	KAI0241819.1	348617	g20701	i0	52.6	0.785234899328859	78	35	76.5	1	297	70	116	193	KAI0241819.1 hypothetical protein L0F63_004562 [Massospora cicadina]	diamond	234	96.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Massospora	Massospora cicadina
29303462	29303462	PRJNA560029_S_NODE_5969_length_416_cov_5.137026_g5745_i0	PRJNA560029	5969	416	5.137026	21.37002816	Fungi	4751	Fungi	Fungi	52.4	2.6e-5	NR	KAI8871100.1	304332	g5745	i0	47.8	1.60817307692308	67	26	42.5	2	4	180	79	144	KAI8871100.1 hypothetical protein GQ42DRAFT_162243 [Ramicandelaber brevisporus]	diamond	669	52.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
29541959	29541959	PRJNA560029_S_NODE_15030_length_330_cov_3.852140_g14806_i0	PRJNA560029	15030	330	3.85214	12.712062	Coemansia reversa NRRL 1564	763665	Fungi	Fungi	70.9	1.3e-11	NR	PIA19164.1	763665	g14806	i0	41.2	1.85454545454545	102	53	86.4	3	286	2	330	431	PIA19164.1 phosphoglycerate mutase-like protein [Coemansia reversa NRRL 1564]	diamond	612	70.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia reversa
29745268	29745268	PRJNA560029_S_NODE_26430_length_273_cov_2.575000_g26206_i0	PRJNA560029	26430	273	2.575	7.02975	Coemansia	4863	Fungi	Fungi	101	5.189999999999999e-23	NR	KAJ1647605.1	1052880	g26206	i0	62.9	3.0989010989011	70	26	76.9	0	273	64	358	427	KAJ1647605.1 ornithine aminotransferase [Coemansia asiatica]	diamond	846	102	0.990196078431373	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia asiatica
30363756	30363756	PRJNA560029_S_NODE_26752_length_272_cov_1.160804_g26528_i0	PRJNA560029	26752	272	1.160804	3.15738688	Mycoemilia scoparia	417184	Fungi	Fungi	73.6	7.73e-14	NR	KAJ1919059.1	417184	g26528	i0	66	0.584558823529412	53	18	58.5	0	271	113	109	161	KAJ1919059.1 60S ribosomal protein L18 [Mycoemilia scoparia]	diamond	159	73.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Mycoemilia	Mycoemilia scoparia
31578412	31578412	PRJNA560029_S_NODE_15976_length_324_cov_4.517928_g15752_i0	PRJNA560029	15976	324	4.517928	14.63808672	Fungi	4751	Fungi	Fungi	67.4	6e-11	NR	ORY03108.1	1314790	g15752	i0	47.1	7.63888888888889	70	36	64.8	1	1	210	148	216	ORY03108.1 PRTase-like protein [Basidiobolus meristosporus CBS 931.73]	diamond	2475	67.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus

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