metadata: contig_metadata: 9 rows where bioproject = "PRJNA407886", tax_kingdom = "Fungi" and tax

9 rows where bioproject = "PRJNA407886", 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
11896706	11896706	PRJNA407886_P_NODE_63530_length_265_cov_1.604167_g61836_i0	PRJNA407886	63530	265	1.604167	4.25104255	Eukaryota	2759	Fungi	Fungi	105	4.25e-24	NR	KAJ3368409.1	64504	g61836	i0	70.4	2.37735849056604	71	21	80.4	0	7	219	588	658	KAJ3368409.1 Non-essential glycogen phosphorylase [Allomyces arbusculus]	diamond	630	106	0.990566037735849	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
13171832	13171832	PRJNA407886_P_NODE_76631_length_245_cov_0.895349_g74937_i0	PRJNA407886	76631	245	0.895349	2.19360505	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	124	7.7399999999999995e-31	NR	KNE61652.1	578462	g74937	i0	90.8	0.795918367346939	65	6	79.6	0	196	2	767	831	KNE61652.1 methionine synthase [Allomyces macrogynus ATCC 38327]	diamond	195	124	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
22093635	22093635	PRJNA407886_P_NODE_31338_length_405_cov_3.132530_g29644_i0	PRJNA407886	31338	405	3.13253	12.6867465	Fungi	4751	Fungi	Fungi	121	8.63e-33	NR	KAI9221418.1	64508	g29644	i0	59.8	9.23703703703704	97	39	71.9	0	354	64	14	110	KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica]	diamond	3741	122	0.991803278688525	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
26917329	26917329	PRJNA407886_P_NODE_59322_length_276_cov_1.512315_g57628_i0	PRJNA407886	59322	276	1.512315	4.1739894	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	50.8	2.96e-5	NR	KAI9145461.1	1500003	g57628	i0	36.9	0.91304347826087	84	53	91.3	0	25	276	12	95	KAI9145461.1 epsilon subunit of F1F0-ATP synthase N-terminal domain-containing protein [Paraphysoderma sedebokerense]	diamond	252	50.8	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
29601447	29601447	PRJNA407886_P_NODE_65890_length_259_cov_2.354839_g64196_i0	PRJNA407886	65890	259	2.354839	6.09903301	Blastocladiella britannica	64508	Fungi	Fungi	83.6	1.46e-18	NR	KAI9221418.1	64508	g64196	i0	59.1	8.23552123552123	66	27	76.4	0	10	207	45	110	KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica]	diamond	2133	83.6	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
30897190	30897190	PRJNA407886_P_NODE_79834_length_242_cov_1.804734_g78140_i0	PRJNA407886	79834	242	1.804734	4.36745628	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	50.1	9.48e-5	NR	KNE67283.1	578462	g78140	i0	43.5	2.40495867768595	62	33	74.4	1	2	181	69	130	KNE67283.1 hypothetical protein AMAG_12347 [Allomyces macrogynus ATCC 38327]	diamond	582	50.4	0.994047619047619	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
31798752	31798752	PRJNA407886_P_NODE_57957_length_280_cov_1.352657_g56263_i0	PRJNA407886	57957	280	1.352657	3.7874396	Eukaryota	2759	Fungi	Fungi	94	5.8e-20	NR	ABH04243.1	4808	g56263	i0	56.3	7.56428571428571	87	38	93.2	0	1	261	154	240	ABH04243.1 heat shock protein 90 kDa [Blastocladiella emersonii]	diamond	2118	94.4	0.995762711864407	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
32667581	32667581	PRJNA407886_P_NODE_33020_length_392_cov_0.965517_g31326_i0	PRJNA407886	33020	392	0.965517	3.78482664	Allomyces javanicus	64505	Fungi	Fungi	127	1.02e-32	NR	KAJ3355496.1	64505	g31326	i0	55	2.8469387755102	120	42	91.8	1	368	9	17	124	KAJ3355496.1 hypothetical protein GGF32_002000 [Allomyces javanicus]	diamond	1116	127	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces javanicus
32825172	32825172	PRJNA407886_P_NODE_70140_length_251_cov_0.865169_g68446_i0	PRJNA407886	70140	251	0.865169	2.17157419	Blastocladiella britannica	64508	Fungi	Fungi	102	2.0399999999999998e-23	NR	KAI9222150.1	64508	g68446	i0	52.4	1.99601593625498	84	39	99.2	1	2	250	114	197	KAI9222150.1 AAA domain-containing protein [Blastocladiella britannica]	diamond	501	102	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica

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