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

9 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
1998190	1998190	PRJNA743294_P_NODE_53922_length_244_cov_2.795322_g53466_i0	PRJNA743294	53922	244	2.795322	6.82058568	Kickxella alabastrina	61397	Fungi	Fungi	204	5.74e-48	NTclustered	gi\|2324005516\|ref\|XM_051534838.1\|	61397	g53466	i0	86.813	48.3073770491803	182	24	75	0	19	200	340	159	Kickxella alabastrina 50S ribosomal protein L30e-like protein (BX661DRAFT_178169), mRNA	blastn	11787	204	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
5825772	5825772	PRJNA743294_P_NODE_53085_length_245_cov_1.994186_g52629_i0	PRJNA743294	53085	245	1.994186	4.8857557	Kickxella alabastrina	61397	Fungi	Fungi	250	7.31e-62	NTclustered	gi\|2323998632\|ref\|XM_051533988.1\|	61397	g52629	i0	85.306	60.3183673469388	245	32	99	4	1	243	795	1037	Kickxella alabastrina serine/threonine-protein phosphatase 2A catalytic subunit beta isoform (BX661DRAFT_175085), mRNA	blastn	14778	250	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
7100750	7100750	PRJNA743294_P_NODE_33906_length_288_cov_2.167442_g33450_i0	PRJNA743294	33906	288	2.167442	6.24223296	Linderina pennispora	61395	Fungi	Fungi	287	6.710000000000001e-73	NTclustered	gi\|2028323356\|ref\|XM_040888071.1\|	61395	g33450	i0	84.859	46.7777777777778	284	43	99	0	3	286	2199	2482	Linderina pennispora P-loop containing nucleoside triphosphate hydrolase protein (DL89DRAFT_268891), mRNA	blastn	13472	287	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
7576262	7576262	PRJNA743294_P_NODE_29546_length_306_cov_1.304721_g29090_i0	PRJNA743294	29546	306	1.304721	3.99244626	Fungi	4751	Fungi	Fungi	180	1.25e-40	NTclustered	gi\|2028317564\|ref\|XM_040887074.1\|	61395	g29090	i0	79.545	8.49346405228758	264	45	84	8	1	258	849	1109	Linderina pennispora component of the holoenzyme form of RNA polymerase transcription factor (DL89DRAFT_266410), mRNA	blastn	2599	180	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
10926038	10926038	PRJNA743294_P_NODE_40629_length_267_cov_1.463918_g40173_i0	PRJNA743294	40629	267	1.463918	3.90866106	Linderina pennispora	61395	Fungi	Fungi	100	8.6e-17	NTclustered	gi\|2028314444\|ref\|XM_040890117.1\|	61395	g40173	i0	83.636	0.928838951310861	110	15	41	3	60	169	2199	2093	Linderina pennispora uncharacterized protein (DL89DRAFT_290733), partial mRNA	blastn	248	100	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
13475706	13475706	PRJNA743294_P_NODE_10411_length_490_cov_25.223022_g9955_i0	PRJNA743294	10411	490	25.223022	123.5928078	Kickxella alabastrina	61397	Fungi	Fungi	302	4.3e-77	NTclustered	gi\|2324012667\|ref\|XM_051535724.1\|	61397	g9955	i0	83.692	34.3510204081633	325	47	66	6	30	351	489	168	Kickxella alabastrina putative 40S ribosomal protein S15-like protein (BX661DRAFT_181480), mRNA	blastn	16832	302	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
14751110	14751110	PRJNA743294_P_NODE_55232_length_243_cov_1.129412_g54776_i0	PRJNA743294	55232	243	1.129412	2.74447116	Linderina pennispora	61395	Fungi	Fungi	195	3.4399999999999997e-45	NTclustered	gi\|2028324920\|ref\|XM_040888337.1\|	61395	g54776	i0	81.07	9.81481481481481	243	46	100	0	1	243	159	401	Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA	blastn	2385	195	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
18573755	18573755	PRJNA743294_P_NODE_33015_length_291_cov_2.256881_g32559_i0	PRJNA743294	33015	291	2.256881	6.56752371	Conidiobolus taihushanensis	2721185	Fungi	Fungi	174	5.51e-39	NTclustered	gi\|2127863558\|ref\|NC_058641.1\|	2721185	g32559	i0	80	40.46735395189	240	44	82	4	14	251	21013	21250	Conidiobolus taihushanensis mitochondrion, complete genome	blastn	11776	174	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus taihushanensis
23674988	23674988	PRJNA743294_P_NODE_25019_length_329_cov_1.875000_g24563_i0	PRJNA743294	25019	329	1.875	6.16875	Capillidium jiangsuense	2902872	Fungi	Fungi	250	1.02e-61	NTclustered	gi\|2329506787\|gb\|OL801339.1\|	2902872	g24563	i0	82.857	5.99088145896657	280	46	85	2	45	323	373	95	Capillidium jiangsuense strain CGMCC 3.16168 translation elongation factor 1-alpha (EF-1a) gene, partial cds	blastn	1971	250	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Capillidium	Capillidium jiangsuense

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