metadata: contig_metadata: 10 rows where bioproject = "PRJNA613025", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA613025", 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
1148853	1148853	PRJNA613025_S_NODE_21201_length_211_cov_0.944444_g21047_i0	PRJNA613025	21201	211	0.944444	1.99277684	root	1	Root_unresolved	Root_unresolved	116	6.54e-29	NR	KAI9296646.1	1314799	g21047	i0	80.3	2.85781990521327	66	13	93.8	0	202	5	273	338	KAI9296646.1 actin binding protein [Neoconidiobolus thromboides FSU 785]	diamond	603	116	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
13345880	13345880	PRJNA613025_S_NODE_22671_length_201_cov_2.401316_g22517_i0	PRJNA613025	22671	201	2.401316	4.82664516	Piptocephalis corymbifera	78917	Fungi	Fungi	56.5	0.001	NTclustered	gi\|311235601\|ref\|NG_027616.1\|	78917	g22517	i0	86.538	0.691542288557214	52	6	25	1	151	201	3234	3183	Piptocephalis corymbifera NRRL 2385 28S rRNA gene, partial sequence; from reference material	blastn	139	56.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Piptocephalis	Piptocephalis corymbifera
20275188	20275188	PRJNA613025_S_NODE_16476_length_257_cov_1.221154_g16322_i0	PRJNA613025	16476	257	1.221154	3.13836578	Eukaryota	2759	Fungi	Fungi	130	2.2699999999999997e-35	NR	KAK9709119.1	34480	g16322	i0	77.4	24.5953307392996	84	19	98.1	0	4	255	149	232	KAK9709119.1 60S ribosomal protein L19B [Basidiobolus ranarum]	diamond	6321	131	0.99236641221374	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
28438439	28438439	PRJNA613025_S_NODE_30206_length_167_cov_0.864407_g30052_i0	PRJNA613025	30206	167	0.864407	1.44355969	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	64.3	1.64e-11	NR	ORX95554.1	1314790	g30052	i0	80	5.17365269461078	35	7	62.9	0	165	61	77	111	ORX95554.1 60S ribosomal protein L34-B [Basidiobolus meristosporus CBS 931.73]	diamond	864	64.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
29448402	29448402	PRJNA613025_S_NODE_32530_length_163_cov_0.894737_g32376_i0	PRJNA613025	32530	163	0.894737	1.45842131	Zancudomyces culisetae	1213189	Fungi	Fungi	85.1	1.67e-19	NR	OMH83614.1	1213189	g32376	i0	79.6	2.98159509202454	54	11	99.4	0	1	162	57	110	OMH83614.1 60S ribosomal protein L26-1 [Zancudomyces culisetae]	diamond	486	85.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Zancudomyces	Zancudomyces culisetae
30378046	30378046	PRJNA613025_S_NODE_30392_length_167_cov_0.864407_g30238_i0	PRJNA613025	30392	167	0.864407	1.44355969	Coemansia	4863	Fungi	Fungi	105	1.4500000000000002e-27	NR	KAJ1811887.1	2849854	g30238	i0	81.8	2.96407185628743	55	10	98.8	0	165	1	60	114	KAJ1811887.1 cross-pathway control WD-repeat protein cpc2, partial [Coemansia sp. RSA 2598]	diamond	495	105	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 2598
30598690	30598690	PRJNA613025_S_NODE_30193_length_167_cov_0.864407_g30039_i0	PRJNA613025	30193	167	0.864407	1.44355969	Harpellales	61421	Fungi	Fungi	69.3	9.47e-13	NR	PVU99658.1	61424	g30039	i0	74.5	1.97604790419162	55	14	98.8	0	167	3	137	191	PVU99658.1 hypothetical protein BB559_000507 [Furculomyces boomerangus]	diamond	330	69.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
32084790	32084790	PRJNA613025_S_NODE_31578_length_165_cov_0.870690_g31424_i0	PRJNA613025	31578	165	0.87069	1.4366385	Fungi	4751	Fungi	Fungi	56.2	6.1e-8	NR	XP_040747950.1	61395	g31424	i0	64.9	6.18181818181818	37	13	67.3	0	150	40	122	158	XP_040747950.1 initiation factor 5a [Linderina pennispora]	diamond	1020	56.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
32546645	32546645	PRJNA613025_S_NODE_33979_length_161_cov_0.901786_g33825_i0	PRJNA613025	33979	161	0.901786	1.45187546	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	68.9	3.21e-13	NR	KXN73393.1	796925	g33825	i0	62.3	0.987577639751553	53	19	98.8	1	3	161	25	76	KXN73393.1 profilin-2 [Conidiobolus coronatus NRRL 28638]	diamond	159	68.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
32622398	32622398	PRJNA613025_S_NODE_29180_length_170_cov_1.264463_g29026_i0	PRJNA613025	29180	170	1.264463	2.1495871	Fungi	4751	Fungi	Fungi	45.4	0.00155	NR	OLY81704.1	133383	g29026	i0	50	4.30588235294118	44	22	77.6	0	169	38	427	470	OLY81704.1 Adenylyl cyclase-associated protein 1 [Smittium mucronatum]	diamond	732	45.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum

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