metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax_phylum = "Zoopagomycota"

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
277639	277639	PRJNA1122875_P_NODE_27321_length_316_cov_1.181070_g27097_i0	PRJNA1122875	27321	316	1.18107	3.7321812	Kickxella alabastrina	61397	Fungi	Fungi	254	7.560000000000001e-63	NTclustered	gi\|2324006968\|ref\|XM_051533524.1\|	61397	g27097	i0	86.522	62.2025316455696	230	31	73	0	86	315	1	230	Kickxella alabastrina histone-fold-containing protein (BX661DRAFT_169484), partial mRNA	blastn	19656	254	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
277768	277768	PRJNA1122875_P_NODE_39301_length_265_cov_1.130208_g39077_i0	PRJNA1122875	39301	265	1.130208	2.9950512	Kickxella alabastrina	61397	Fungi	Fungi	132	3.02e-26	NTclustered	gi\|2324005516\|ref\|XM_051534838.1\|	61397	g39077	i0	79.781	9.19622641509434	183	35	69	2	31	212	340	159	Kickxella alabastrina 50S ribosomal protein L30e-like protein (BX661DRAFT_178169), mRNA	blastn	2437	132	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
6655767	6655767	PRJNA1122875_P_NODE_52886_length_242_cov_0.911243_g52662_i0	PRJNA1122875	52886	242	0.911243	2.20520806	Linderina pennispora	61395	Fungi	Fungi	178	3.45e-40	NTclustered	gi\|2028311994\|ref\|XM_040883102.1\|	61395	g52662	i0	80.973	62.1818181818182	226	41	93	2	1	225	888	1112	Linderina pennispora uncharacterized protein (DL89DRAFT_11075), mRNA	blastn	15048	178	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
6655810	6655810	PRJNA1122875_P_NODE_7246_length_599_cov_2.034221_g7029_i0	PRJNA1122875	7246	599	2.034221	12.18498379	Kickxella alabastrina	61397	Fungi	Fungi	340	1.13e-88	NTclustered	gi\|2324019521\|ref\|XM_051537881.1\|	61397	g7029	i0	84.181	36.6210350584307	354	52	59	4	241	592	1254	903	Kickxella alabastrina acyl-CoA dehydrogenase/oxidase (BX661DRAFT_194448), partial mRNA	blastn	21936	340	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
13031156	13031156	PRJNA1122875_P_NODE_17751_length_396_cov_1.907121_g17527_i0	PRJNA1122875	17751	396	1.907121	7.55219916	Linderina pennispora	61395	Fungi	Fungi	274	7.43e-69	NTclustered	gi\|2028324920\|ref\|XM_040888337.1\|	61395	g17527	i0	80.376	57.3661616161616	372	64	93	8	20	388	346	711	Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA	blastn	22717	274	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
13031376	13031376	PRJNA1122875_P_NODE_37071_length_273_cov_0.830000_g36847_i0	PRJNA1122875	37071	273	0.83	2.2659	Linderina pennispora	61395	Fungi	Fungi	82.4	3.2e-11	NTclustered	gi\|2028317086\|ref\|XM_040885076.1\|	61395	g36847	i0	90.476	1.52380952380952	63	5	23	1	163	224	946	884	Linderina pennispora transaldolase (DL89DRAFT_244893), partial mRNA	blastn	416	82.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
18129363	18129363	PRJNA1122875_P_NODE_30755_length_294_cov_1.891403_g30531_i0	PRJNA1122875	30755	294	1.891403	5.56072482	Kickxella alabastrina	61397	Fungi	Fungi	222	1.96e-53	NTclustered	gi\|2324005222\|ref\|XM_051534789.1\|	61397	g30531	i0	86.634	72.8367346938775	202	25	68	2	42	242	492	292	Kickxella alabastrina 14-3-3 family protein epsilon (BX661DRAFT_178018), mRNA	blastn	21414	222	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
18129442	18129442	PRJNA1122875_P_NODE_36995_length_273_cov_1.235000_g36771_i0	PRJNA1122875	36995	273	1.235	3.37155	Kickxella alabastrina	61397	Fungi	Fungi	60.2	1.5e-4	NTclustered	gi\|2324009512\|ref\|XM_051535378.1\|	61397	g36771	i0	100	0.117216117216117	32	0	12	0	237	268	1573	1542	Kickxella alabastrina WD40-repeat-containing domain protein (BX661DRAFT_180114), mRNA	blastn	32	60.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
20679240	20679240	PRJNA1122875_P_NODE_46337_length_248_cov_0.880000_g46113_i0	PRJNA1122875	46337	248	0.88	2.1824	Linderina pennispora	61395	Fungi	Fungi	147	1e-30	NTclustered	gi\|2028325628\|ref\|XM_040891481.1\|	61395	g46113	i0	80.513	2.16129032258065	195	35	79	3	54	248	1163	972	Linderina pennispora catalase (DL89DRAFT_324752), partial mRNA	blastn	536	147	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora

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