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

5 rows where bioproject = "PRJNA799842", 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
27338646	27338646	PRJNA799842_P_NODE_27943_length_553_cov_2.085417_g26386_i0	PRJNA799842	27943	553	2.085417	11.53235601	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	179	2.19e-51	NR	KAI9188728.1	1313167	g26386	i0	54.1	2.84810126582278	172	77	93.3	1	518	3	87	256	KAI9188728.1 hypothetical protein H9P43_000150 [Blastocladiella emersonii ATCC 22665]	diamond	1575	179	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
29674658	29674658	PRJNA799842_P_NODE_143310_length_250_cov_0.870056_g141737_i0	PRJNA799842	143310	250	0.870056	2.17514	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	57.4	2.67e-7	NR	KNE61274.1	578462	g141737	i0	48.2	0.996	83	39	96	2	2	241	1	82	KNE61274.1 hypothetical protein AMAG_07016 [Allomyces macrogynus ATCC 38327]	diamond	249	57.4	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
31033820	31033820	PRJNA799842_P_NODE_52255_length_393_cov_1.203125_g50682_i0	PRJNA799842	52255	393	1.203125	4.72828125	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	134	2.5e-34	NR	KNE60042.1	578462	g50682	i0	48.8	2.90839694656489	127	62	96.9	1	389	9	214	337	KNE60042.1 hypothetical protein AMAG_05479 [Allomyces macrogynus ATCC 38327]	diamond	1143	134	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
31286200	31286200	PRJNA799842_P_NODE_30195_length_529_cov_2.208333_g28634_i0	PRJNA799842	30195	529	2.208333	11.68208157	Allomyces arbusculus	64504	Fungi	Fungi	187	3.0899999999999997e-57	NR	KAJ3374282.1	64504	g28634	i0	56.2	2.90926275992439	169	74	95.8	0	21	527	5	173	KAJ3374282.1 60S ribosomal protein L20 [Allomyces arbusculus]	diamond	1539	187	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
31634157	31634157	PRJNA799842_P_NODE_162996_length_246_cov_0.890173_g161423_i0	PRJNA799842	162996	246	0.890173	2.18982558	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	92.8	9.32e-20	NR	KAI9137790.1	1500003	g161423	i0	57	5.31707317073171	79	29	90.2	1	25	246	352	430	KAI9137790.1 plasma-membrane choline transporter-domain-containing protein, partial [Paraphysoderma sedebokerense]	diamond	1308	92.8	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense

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