metadata: contig_metadata: 6 rows where bioproject = "PRJNA454503", tax_kingdom = "Fungi" and tax

6 rows where bioproject = "PRJNA454503", 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
14471040	14471040	PRJNA454503_P_NODE_36752_length_231_cov_1.117647_g36423_i0	PRJNA454503	36752	231	1.117647	2.58176457	Opisthokonta	33154	Fungi	Fungi	124	9.04e-34	NR	KAK9687576.1	34480	g36423	i0	72	8.03896103896104	75	21	97.4	0	6	230	1	75	KAK9687576.1 alpha-tubulin [Basidiobolus ranarum]	diamond	1857	125	0.992	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
27440274	27440274	PRJNA454503_P_NODE_72223_length_206_cov_0.896552_g71894_i0	PRJNA454503	72223	206	0.896552	1.84689712	Fungi	4751	Fungi	Fungi	92.8	4.84e-22	NR	KAJ1911275.1	78921	g71894	i0	61.9	8.25728155339806	63	24	91.7	0	192	4	1	63	KAJ1911275.1 60S ribosomal protein L24 [Tieghemiomyces parasiticus]	diamond	1701	93.2	0.995708154506438	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Tieghemiomyces	Tieghemiomyces parasiticus
30076024	30076024	PRJNA454503_P_NODE_14472_length_302_cov_3.236515_g14143_i0	PRJNA454503	14472	302	3.236515	9.7742753	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	76.6	7e-14	NR	KXN66155.1	796925	g14143	i0	44.4	0.983443708609272	99	49	98.3	2	302	6	78	170	KXN66155.1 hypothetical protein CONCODRAFT_12075 [Conidiobolus coronatus NRRL 28638]	diamond	297	76.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
30424081	30424081	PRJNA454503_P_NODE_8773_length_377_cov_2.262658_g8444_i0	PRJNA454503	8773	377	2.262658	8.53022066	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	95.1	3.12e-20	NR	KXN66155.1	796925	g8444	i0	44.2	0.89920424403183	113	58	89.9	2	371	33	43	150	KXN66155.1 hypothetical protein CONCODRAFT_12075 [Conidiobolus coronatus NRRL 28638]	diamond	339	95.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
30929257	30929257	PRJNA454503_P_NODE_9034_length_372_cov_1.254019_g8705_i0	PRJNA454503	9034	372	1.254019	4.66495068	Ramicandelaber brevisporus	304332	Fungi	Fungi	154	3.58e-45	NR	KAI8870081.1	304332	g8705	i0	61	2.88709677419355	118	46	95.2	0	356	3	2	119	KAI8870081.1 ribosomal protein S19e [Ramicandelaber brevisporus]	diamond	1074	154	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
31197754	31197754	PRJNA454503_P_NODE_74775_length_205_cov_0.902778_g74446_i0	PRJNA454503	74775	205	0.902778	1.8506949	Fungi	4751	Fungi	Fungi	85.5	1.75e-18	NR	RKP07262.1	78915	g74446	i0	64.2	7.88780487804878	67	24	98	0	204	4	54	120	RKP07262.1 Snf7-domain-containing protein [Thamnocephalis sphaerospora]	diamond	1617	85.9	0.9953434225844	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora

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