metadata: contig_metadata: 6 rows where bioproject = "PRJNA1129273" and tax

6 rows where bioproject = "PRJNA1129273" 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
2833974	2833974	PRJNA1129273_P_NODE_9843_length_245_cov_1.325581_g9563_i0	PRJNA1129273	9843	245	1.325581	3.24767345	Fungi	4751	Fungi	Fungi	118	4.09e-30	NR	KAJ9060058.1	34485	g9563	i0	71.8	9.61224489795918	71	20	86.9	0	243	31	240	310	KAJ9060058.1 cross-pathway control WD-repeat protein cpc2 [Entomophthora muscae]	diamond	2355	119	0.991596638655462	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
13785007	13785007	PRJNA1129273_P_NODE_4371_length_343_cov_3.100000_g4091_i0	PRJNA1129273	4371	343	3.1	10.633	Basidiobolus	4859	Fungi	Fungi	171	8.009999999999999e-52	NR	KAK9700674.1	34480	g4091	i0	74.3	13.6443148688047	113	29	98.8	0	1	339	9	121	KAK9700674.1 ribosomal 40S subunit protein S1B [Basidiobolus ranarum]	diamond	4680	172	0.994186046511628	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
30007312	30007312	PRJNA1129273_P_NODE_5391_length_304_cov_11.519481_g5111_i0	PRJNA1129273	5391	304	11.519481	35.01922224	Furculomyces boomerangus	61424	Fungi	Fungi	73.6	8.19e-14	NR	PVU86898.1	61424	g5111	i0	37.4	1.95394736842105	99	61	96.7	1	295	2	4	102	PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus]	diamond	594	73.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
30386678	30386678	PRJNA1129273_P_NODE_3953_length_363_cov_2.500000_g3673_i0	PRJNA1129273	3953	363	2.5	9.075	Basidiobolus ranarum	34480	Fungi	Fungi	159	1.29e-46	NR	KAK9767561.1	34480	g3673	i0	79	9.92561983471074	100	20	82.6	1	302	3	1	99	KAK9767561.1 ribosomal 40S subunit protein S1B [Basidiobolus ranarum]	diamond	3603	159	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
30627915	30627915	PRJNA1129273_P_NODE_5053_length_316_cov_1.888889_g4773_i0	PRJNA1129273	5053	316	1.888889	5.96888924	Fungi	4751	Fungi	Fungi	101	1.8e-25	NR	KAK9768031.1	34480	g4773	i0	59.6	19.3196202531646	89	35	84.5	1	39	305	1	88	KAK9768031.1 40S ribosomal protein S25 [Basidiobolus ranarum]	diamond	6105	102	0.990196078431373	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
31587475	31587475	PRJNA1129273_P_NODE_3436_length_395_cov_4.372671_g3156_i0	PRJNA1129273	3436	395	4.372671	17.27205045	Ramicandelaber brevisporus	304332	Fungi	Fungi	103	1.96e-25	NR	KAI8872700.1	304332	g3156	i0	43.6	3.37215189873418	117	58	88.9	1	29	379	13	121	KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus]	diamond	1332	103	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus

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