metadata: contig_metadata: 5 rows where bioproject = "PRJNA745553", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA745553", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"

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
26989234	26989234	PRJNA745553_S_NODE_4162_length_535_cov_2.145022_g3972_i0	PRJNA745553	4162	535	2.145022	11.4758677	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	76.6	5.17e-13	NR	KAI9143162.1	1500003	g3972	i0	40	0.644859813084112	115	63	63.4	5	167	505	72	182	KAI9143162.1 hypothetical protein BKA69DRAFT_1062590, partial [Paraphysoderma sedebokerense]	diamond	345	76.6	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
28000524	28000524	PRJNA745553_S_NODE_1405_length_715_cov_2.641745_g1274_i0	PRJNA745553	1405	715	2.641745	18.88847675	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	227	3.7499999999999996e-68	NR	KAI9144962.1	1500003	g1274	i0	45.9	2.03076923076923	242	119	99.9	3	715	2	38	271	KAI9144962.1 delta5 fatty acid desaturase [Paraphysoderma sedebokerense]	diamond	1452	227	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
29515673	29515673	PRJNA745553_S_NODE_22230_length_262_cov_4.507937_g22035_i0	PRJNA745553	22230	262	4.507937	11.81079494	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	42.7	0.049	NR	KAI9141389.1	1500003	g22035	i0	41.3	0.526717557251908	46	27	52.7	0	89	226	349	394	KAI9141389.1 ER-golgi trafficking TRAPP I complex 85 kDa subunit-domain-containing protein [Paraphysoderma sedebokerense]	diamond	138	42.7	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
30284301	30284301	PRJNA745553_S_NODE_13892_length_330_cov_1.844358_g13697_i0	PRJNA745553	13892	330	1.844358	6.0863814	Fungi	4751	Fungi	Fungi	117	1.55e-28	NR	ABK34893.1	4808	g13697	i0	96.6	2.16363636363636	58	2	52.7	0	12	185	378	435	ABK34893.1 elongation factor alpha-like protein [Blastocladiella emersonii]	diamond	714	118	0.991525423728814	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
31949172	31949172	PRJNA745553_S_NODE_11297_length_364_cov_3.704467_g11102_i0	PRJNA745553	11297	364	3.704467	13.48425988	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	78.2	4.17e-14	NR	KAI9152416.1	1313167	g11102	i0	52.4	0.519230769230769	63	30	51.9	0	64	252	319	381	KAI9152416.1 hypothetical protein H9P43_009207 [Blastocladiella emersonii ATCC 22665]	diamond	189	78.2	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii

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