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

5 rows where bioproject = "PRJNA1005695", 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
28424251	28424251	PRJNA1005695_P_NODE_35806_length_250_cov_2.644068_g34954_i0	PRJNA1005695	35806	250	2.644068	6.61017	Catenaria anguillulae PL171	765915	Fungi	Fungi	68.6	2.87e-11	NR	ORZ30597.1	765915	g34954	i0	54.4	0.684	57	26	68.4	0	2	172	25	81	ORZ30597.1 P-loop containing nucleoside triphosphate hydrolase protein [Catenaria anguillulae PL171]	diamond	171	68.6	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
30223962	30223962	PRJNA1005695_P_NODE_20292_length_335_cov_1.541985_g19440_i0	PRJNA1005695	20292	335	1.541985	5.16564975	Catenaria anguillulae PL171	765915	Fungi	Fungi	194	5.22e-58	NR	ORZ31481.1	765915	g19440	i0	88.3	2.98208955223881	111	13	99.4	0	3	335	131	241	ORZ31481.1 26S protease regulatory subunit 7 [Catenaria anguillulae PL171]	diamond	999	194	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
30634637	30634637	PRJNA1005695_P_NODE_39053_length_244_cov_0.912281_g38201_i0	PRJNA1005695	39053	244	0.912281	2.22596564	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	48.9	2.5e-4	NR	KAI9179031.1	1313167	g38201	i0	35	0.737704918032787	60	39	73.8	0	244	65	137	196	KAI9179031.1 rRNA-processing protein las1 [Blastocladiella emersonii ATCC 22665]	diamond	180	48.9	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
32081708	32081708	PRJNA1005695_P_NODE_8678_length_530_cov_12.286652_g7831_i0	PRJNA1005695	8678	530	12.286652	65.1192556	Fungi	4751	Fungi	Fungi	139	8.93e-39	NR	KAI9217172.1	64508	g7831	i0	47.8	8.54150943396226	136	71	77	0	67	474	3	138	KAI9217172.1 hypothetical protein BC828DRAFT_391853 [Blastocladiella britannica]	diamond	4527	139	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
32721309	32721309	PRJNA1005695_P_NODE_34140_length_254_cov_2.906077_g33288_i0	PRJNA1005695	34140	254	2.906077	7.38143558	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	59.7	2.03e-8	NR	KAI9183408.1	1313167	g33288	i0	57.1	3.67322834645669	56	19	66.1	1	252	85	140	190	KAI9183408.1 Protein component of the small (40S) ribosomal subunit [Blastocladiella emersonii ATCC 22665]	diamond	933	59.7	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);;