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

9 rows where analysis = "blastn", bioproject = "PRJNA690592" 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
671148	671148	PRJNA690592_S_NODE_16661_length_725_cov_7.019939_g15745_i0	PRJNA690592	16661	725	7.019939	50.89455775	Linderina pennispora	61395	Fungi	Fungi	438	4.769999999999999e-118	NTclustered	gi\|2028323432\|ref\|XM_040888084.1\|	61395	g15745	i0	84.828	64.5503448275862	435	66	60	0	122	556	1035	601	Linderina pennispora 40S ribosomal protein S5 (DL89DRAFT_268926), mRNA	blastn	46799	438	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
8832085	8832085	PRJNA690592_S_NODE_98787_length_329_cov_1.621094_g97773_i0	PRJNA690592	98787	329	1.621094	5.33339926	Zoopagomycota	1913638	Fungi	Fungi	167	1.06e-36	NTclustered	gi\|2028313032\|ref\|XM_040890055.1\|	61395	g97773	i0	82.888	37.3313069908815	187	30	57	2	133	318	22	207	Linderina pennispora L41 ribosomal protein (DL89DRAFT_290178), partial mRNA	blastn	12282	167	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
10875876	10875876	PRJNA690592_S_NODE_54269_length_424_cov_1.971510_g53255_i0	PRJNA690592	54269	424	1.97151	8.3592024	Kickxella alabastrina	61397	Fungi	Fungi	220	1.0599999999999999e-52	NTclustered	gi\|2324021279\|ref\|XM_051538459.1\|	61397	g53255	i0	81.55	24.1344339622642	271	46	63	4	1	269	197	465	Kickxella alabastrina putative actin related protein 2/3 complex subunit 4 (BX661DRAFT_200883), partial mRNA	blastn	10233	220	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
12150098	12150098	PRJNA690592_S_NODE_116650_length_308_cov_1.217021_g115636_i0	PRJNA690592	116650	308	1.217021	3.74842468	Linderina pennispora	61395	Fungi	Fungi	196	1.26e-45	NTclustered	gi\|2028325604\|ref\|XM_040889545.1\|	61395	g115636	i0	88.024	32.1623376623377	167	18	54	2	115	280	464	299	Linderina pennispora 40S ribosomal protein S9 (DL89DRAFT_279070), partial mRNA	blastn	9906	196	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
17249867	17249867	PRJNA690592_S_NODE_78574_length_362_cov_1.183391_g77560_i0	PRJNA690592	78574	362	1.183391	4.28387542	Kickxella alabastrina	61397	Fungi	Fungi	89.8	2.62e-13	NTclustered	gi\|2323999892\|ref\|XM_051539258.1\|	61397	g77560	i0	84.946	0.256906077348066	93	9	25	4	238	328	1087	998	Kickxella alabastrina WD40-repeat-containing domain protein (BX661DRAFT_5473), mRNA	blastn	93	89.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
19797798	19797798	PRJNA690592_S_NODE_12676_length_820_cov_8.896921_g11841_i0	PRJNA690592	12676	820	8.896921	72.9547522	Linderina pennispora	61395	Fungi	Fungi	366	2.5899999999999998e-96	NTclustered	gi\|2028325604\|ref\|XM_040889545.1\|	61395	g11841	i0	80.079	45.8780487804878	507	89	61	11	82	583	45	544	Linderina pennispora 40S ribosomal protein S9 (DL89DRAFT_279070), partial mRNA	blastn	37620	366	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
22348896	22348896	PRJNA690592_S_NODE_22118_length_636_cov_9.397869_g21140_i0	PRJNA690592	22118	636	9.397869	59.77044684	Linderina pennispora	61395	Fungi	Fungi	278	9.57e-70	NTclustered	gi\|2028312006\|ref\|XM_040886107.1\|	61395	g21140	i0	80.609	52.7830188679245	361	68	57	2	99	458	511	870	Linderina pennispora 40S ribosomal protein S16 (DL89DRAFT_264115), mRNA	blastn	33570	278	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
23623620	23623620	PRJNA690592_S_NODE_11639_length_851_cov_71.701799_g10838_i0	PRJNA690592	11639	851	71.701799	610.18230949	Linderina pennispora	61395	Fungi	Fungi	316	2.75e-81	NTclustered	gi\|2028325604\|ref\|XM_040889545.1\|	61395	g10838	i0	77.178	39.7955346650999	574	111	67	16	57	623	10	570	Linderina pennispora 40S ribosomal protein S9 (DL89DRAFT_279070), partial mRNA	blastn	33866	316	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
23624137	23624137	PRJNA690592_S_NODE_195919_length_248_cov_0.880000_g194905_i0	PRJNA690592	195919	248	0.88	2.1824	Linderina pennispora	61395	Fungi	Fungi	202	2.0999999999999998e-47	NTclustered	gi\|2028323302\|ref\|XM_040891225.1\|	61395	g194905	i0	81.933	83.4395161290323	238	43	96	0	11	248	927	690	Linderina pennispora WD40 repeat-like protein (DL89DRAFT_32066), mRNA	blastn	20693	202	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);;