metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax_phylum = "Mucoromycota"

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
22388658	22388658	PRJNA724039_S_NODE_6798_length_260_cov_1.802691_g6591_i0	PRJNA724039	6798	260	1.802691	4.6869966	Opisthokonta	33154	Fungi	Fungi	142	2.14e-40	NR	XP_052977337.1	64656	g6591	i0	72.9	18.7269230769231	85	23	98.1	0	258	4	29	113	XP_052977337.1 60S ribosomal protein L2, partial [Zychaea mexicana]	diamond	4869	143	0.993006993006993	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana
27315617	27315617	PRJNA724039_S_NODE_15303_length_163_cov_1.841270_g15096_i0	PRJNA724039	15303	163	1.84127	3.0012701	Eukaryota	2759	Fungi	Fungi	43.9	0.00505	NR	GBB85145.1	94130	g15096	i0	50	3.1840490797546	38	18	68.1	1	111	1	702	739	GBB85145.1 hypothetical protein RclHR1_01170029 [Rhizophagus clarus]	diamond	519	44.3	0.99097065462754	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
27631393	27631393	PRJNA724039_S_NODE_14724_length_166_cov_2.457364_g14517_i0	PRJNA724039	14724	166	2.457364	4.07922424	Fungi	4751	Fungi	Fungi	60.5	8.6e-10	NR	ORX51325.1	101127	g14517	i0	60.8	2.67469879518072	51	20	92.2	0	5	157	14	64	ORX51325.1 ribosomal protein L28e [Hesseltinella vesiculosa]	diamond	444	60.8	0.995065789473684	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Hesseltinella	Hesseltinella vesiculosa
28473497	28473497	PRJNA724039_S_NODE_17786_length_151_cov_3.052632_g17579_i0	PRJNA724039	17786	151	3.052632	4.60947432	Pilobolus umbonatus	101123	Fungi	Fungi	65.1	1.39e-10	NR	KAI8993165.1	101123	g17579	i0	62.5	0.95364238410596	48	18	95.4	0	145	2	506	553	KAI8993165.1 heat shock protein 90-1 [Pilobolus umbonatus]	diamond	144	65.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Pilobolaceae	Pilobolus	Pilobolus umbonatus
29199799	29199799	PRJNA724039_S_NODE_11109_length_193_cov_5.717949_g10902_i0	PRJNA724039	11109	193	5.717949	11.03564157	Calcarisporiella thermophila	911321	Fungi	Fungi	52.4	8.49e-7	NR	KAL1914197.1	911321	g10902	i0	57.9	0.886010362694301	57	18	80.8	2	187	32	11	66	KAL1914197.1 hypothetical protein VTP21DRAFT_9681 [Calcarisporiella thermophila]	diamond	171	52.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
29199817	29199817	PRJNA724039_S_NODE_8969_length_219_cov_1.423077_g8762_i0	PRJNA724039	8969	219	1.423077	3.11653863	Mortierella sp. GBA43	1896190	Fungi	Fungi	42.4	0.0315	NR	KAG0219050.1	1896190	g8762	i0	48.9	0.643835616438356	47	21	64.4	1	211	71	174	217	KAG0219050.1 40S ribosomal protein S17 [Mortierella sp. GBA43]	diamond	141	42.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella sp. GBA43
30715652	30715652	PRJNA724039_S_NODE_16534_length_157_cov_1.200000_g16327_i0	PRJNA724039	16534	157	1.2	1.884	Calcarisporiella thermophila	911321	Fungi	Fungi	95.1	5.34e-23	NR	XP_069256534.1	911321	g16327	i0	92.3	0.993630573248408	52	4	99.4	0	156	1	79	130	XP_069256534.1 60S ribosomal eL30 domain-containing protein [Calcarisporiella thermophila]	diamond	156	95.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
30747394	30747394	PRJNA724039_S_NODE_15234_length_163_cov_4.277778_g15027_i0	PRJNA724039	15234	163	4.277778	6.97277814	Geosiphon pyriformis	50956	Fungi	Fungi	41.6	0.0327	NR	KAG9298475.1	50956	g15027	i0	69	0.533742331288344	29	9	53.4	0	2	88	252	280	KAG9298475.1 hypothetical protein G9A89_000557, partial [Geosiphon pyriformis]	diamond	87	41.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Geosiphonaceae	Geosiphon	Geosiphon pyriformis
31706056	31706056	PRJNA724039_S_NODE_12677_length_180_cov_2.615385_g12470_i0	PRJNA724039	12677	180	2.615385	4.707693	Mucorales	4827	Fungi	Fungi	71.2	8.75e-13	NR	XP_052932414.1	64632	g12470	i0	53.4	2.9	58	27	96.7	0	178	5	177	234	XP_052932414.1 ribosomal protein L10-domain-containing protein [Mycotypha africana]	diamond	522	71.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mycotyphaceae	Mycotypha	Mycotypha africana

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