metadata: contig_metadata: 5 rows where bioproject = "PRJNA977246", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA977246", 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
2226371	2226371	PRJNA977246_S_NODE_19562_length_314_cov_182.266667_g18570_i0	PRJNA977246	19562	314	182.266667	572.31733438	Entomophthora muscae	34485	Fungi	Fungi	514	3.1199999999999997e-141	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g18570	i0	96.178	41.343949044586	314	12	100	0	1	314	1692	2005	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	12982	514	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
3501817	3501817	PRJNA977246_S_NODE_26683_length_249_cov_3.145455_g25691_i0	PRJNA977246	26683	249	3.145455	7.83218295	Zoopagomycota	1913638	Fungi	Fungi	115	2.25e-29	NR	PVV04649.1	133381	g25691	i0	67.5	3.86746987951807	83	27	100	0	1	249	132	214	PVV04649.1 hypothetical protein BB560_000844 [Smittium megazygosporum]	diamond	963	115	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium megazygosporum
3501997	3501997	PRJNA977246_S_NODE_32803_length_211_cov_15.582418_g31811_i0	PRJNA977246	32803	211	15.582418	32.87890198	Entomophthora muscae	34485	Fungi	Fungi	172	1.36e-38	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g31811	i0	81.517	34.5071090047393	211	37	100	2	1	211	1992	2200	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	7281	172	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
21353176	21353176	PRJNA977246_S_NODE_23297_length_277_cov_3.516129_g22305_i0	PRJNA977246	23297	277	3.516129	9.73967733	Entomophthora muscae	34485	Fungi	Fungi	424	4.69e-114	NTclustered	gi\|240104215\|gb\|DQ481225.2\|	34485	g22305	i0	94.224	70.4584837545126	277	16	100	0	1	277	318	42	Entomophthora muscae isolate ARSEF 6815 28S ribosomal RNA gene, partial sequence	blastn	19517	424	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
21353532	21353532	PRJNA977246_S_NODE_37557_length_190_cov_318.006211_g36565_i0	PRJNA977246	37557	190	318.006211	604.2118009	Entomophthora muscae	34485	Fungi	Fungi	196	7.13e-46	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g36565	i0	85.567	45.9947368421053	194	21	100	6	1	190	2005	1815	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	8739	196	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae

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