metadata: contig_metadata: 5 rows where bioproject = "PRJNA312615" and tax

5 rows where bioproject = "PRJNA312615" 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
5482241	5482241	PRJNA312615_P_NODE_6645_length_473_cov_4.528302_g6496_i0	PRJNA312615	6645	473	4.528302	21.41886846	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	195	6.82e-59	NR	KAI9140511.1	1500003	g6496	i0	75.6	2.28329809725159	119	29	75.5	0	471	115	197	315	KAI9140511.1 WD40-repeat-containing domain protein [Paraphysoderma sedebokerense]	diamond	1080	195	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
30313524	30313524	PRJNA312615_P_NODE_12992_length_342_cov_13.078498_g12842_i0	PRJNA312615	12992	342	13.078498	44.72846316	Fungi	4751	Fungi	Fungi	121	5.35e-33	NR	KAI9221418.1	64508	g12842	i0	59.8	5.10526315789474	97	39	85.1	0	24	314	14	110	KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica]	diamond	1746	122	0.991803278688525	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
30832518	30832518	PRJNA312615_P_NODE_22714_length_256_cov_0.975845_g22563_i0	PRJNA312615	22714	256	0.975845	2.4981632	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	56.2	8.06e-7	NR	KNE65811.1	578462	g22563	i0	36.6	0.9609375	82	51	96.1	1	256	11	325	405	KNE65811.1 hypothetical protein AMAG_09783 [Allomyces macrogynus ATCC 38327]	diamond	246	56.2	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
32020098	32020098	PRJNA312615_P_NODE_54858_length_164_cov_1.330435_g54707_i0	PRJNA312615	54858	164	1.330435	2.1819134	Eukaryota	2759	Fungi	Fungi	70.5	2.02e-12	NR	KAI9216227.1	64508	g54707	i0	62.5	13.9024390243902	48	18	87.8	0	164	21	383	430	KAI9216227.1 GTP-binding protein YchF [Blastocladiella britannica]	diamond	2280	70.9	0.994358251057828	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
32477282	32477282	PRJNA312615_P_NODE_41499_length_190_cov_1.390071_g41348_i0	PRJNA312615	41499	190	1.390071	2.6411349	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	45.8	0.00147	NR	KAI9184341.1	1313167	g41348	i0	43.4	0.836842105263158	53	30	83.7	0	164	6	607	659	KAI9184341.1 fatty-acyl coenzyme A oxidase [Blastocladiella emersonii ATCC 22665]	diamond	159	45.8	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);;