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

5 rows where bioproject = "PRJNA812715", 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
28231406	28231406	PRJNA812715_P_NODE_99986_length_253_cov_1.711111_g98185_i0	PRJNA812715	99986	253	1.711111	4.32911083	root	1	Root_unresolved	Root_unresolved	51.6	2.64e-5	NR	KAI9143024.1	1500003	g98185	i0	43.9	12.1304347826087	57	28	67.6	1	3	173	187	239	KAI9143024.1 mitochondrial complex Ii bound with N--2-Trifluoromethyl-benzamide [Paraphysoderma sedebokerense]	diamond	3069	52	0.992307692307692	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
28759573	28759573	PRJNA812715_P_NODE_121287_length_241_cov_0.916667_g119486_i0	PRJNA812715	121287	241	0.916667	2.20916747	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	111	5.660000000000001e-27	NR	KNE64108.1	578462	g119486	i0	57.9	6.77178423236515	76	32	94.6	0	229	2	218	293	KNE64108.1 hypothetical protein AMAG_09170 [Allomyces macrogynus ATCC 38327]	diamond	1632	111	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
29075609	29075609	PRJNA812715_P_NODE_87388_length_273_cov_0.975000_g85587_i0	PRJNA812715	87388	273	0.975	2.66175	Blastocladiella britannica	64508	Fungi	Fungi	102	1.5e-23	NR	KAI9220673.1	64508	g85587	i0	56.2	0.978021978021978	89	39	97.8	0	1	267	135	223	KAI9220673.1 acyltransferase-domain-containing protein [Blastocladiella britannica]	diamond	267	102	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
31010879	31010879	PRJNA812715_P_NODE_84354_length_277_cov_2.264706_g82554_i0	PRJNA812715	84354	277	2.264706	6.27323562	Fungi	4751	Fungi	Fungi	95.5	9.47e-21	NR	AAA20074.1	4808	g82554	i0	55.8	12.8339350180505	86	38	93.1	0	20	277	91	176	AAA20074.1 cAMP-dependent protein kinase [Blastocladiella emersonii]	diamond	3555	95.5	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
32907118	32907118	PRJNA812715_P_NODE_67940_length_312_cov_0.966527_g66140_i0	PRJNA812715	67940	312	0.966527	3.01556424	Eukaryota	2759	Fungi	Fungi	100	6.28e-24	NR	ORZ34610.1	765915	g66140	i0	57.1	10.4326923076923	98	40	93.3	2	294	4	5	101	ORZ34610.1 ribosomal protein S7e [Catenaria anguillulae PL171]	diamond	3255	101	0.99009900990099	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae

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