metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1253303" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1253303" 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
26870539	26870539	PRJNA1253303_P_NODE_5461_length_252_cov_0.871508_g5439_i0	PRJNA1253303	5461	252	0.871508	2.19620016	Actinomortierella	2779867	Fungi	Fungi	123	2.84e-33	NR	KAG0234004.1	90253	g5439	i0	71.1	14.8214285714286	83	24	98.8	0	251	3	66	148	KAG0234004.1 hypothetical protein BGW42_006985 [Actinomortierella wolfii]	diamond	3735	123	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Actinomortierella	Actinomortierella wolfii
27818420	27818420	PRJNA1253303_P_NODE_6764_length_247_cov_0.896552_g6742_i0	PRJNA1253303	6764	247	0.896552	2.21448344	Rhizopus	4842	Fungi	Fungi	50.8	5.25e-5	NR	XP_067514098.1	246409	g6742	i0	34.3	4.06882591093117	67	44	81.4	0	201	1	215	281	XP_067514098.1 uncharacterized protein RO3G_03406 [Rhizopus delemar RA 99-880]	diamond	1005	50.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
27863398	27863398	PRJNA1253303_P_NODE_1825_length_381_cov_0.970779_g1803_i0	PRJNA1253303	1825	381	0.970779	3.69866799	Lichtheimia corymbifera JMRC:FSU:9682	1263082	Fungi	Fungi	164	8.87e-47	NR	CDH58389.1	1263082	g1803	i0	62.3	1.82677165354331	122	42	96.1	2	380	15	117	234	CDH58389.1 beta--glucan-binding [Lichtheimia corymbifera JMRC:FSU:9682]	diamond	696	164	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia corymbifera
28684597	28684597	PRJNA1253303_P_NODE_2487_length_334_cov_0.896552_g2465_i0	PRJNA1253303	2487	334	0.896552	2.99448368	Fennellomyces sp. T-	1329386	Fungi	Fungi	48.9	6.2e-4	NR	KAI8137181.1	1329386	g2465	i0	58.5	0.368263473053892	41	16	36.8	1	7	129	217	256	KAI8137181.1 NRDE protein-domain-containing protein [Fennellomyces sp. T-0311]	diamond	123	48.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Fennellomyces	Fennellomyces sp. T-0311
29775680	29775680	PRJNA1253303_P_NODE_5071_length_253_cov_0.866667_g5049_i0	PRJNA1253303	5071	253	0.866667	2.19266751	Rhizopus	4842	Fungi	Fungi	55.5	8.96e-7	NR	ORE02502.1	86635	g5049	i0	67.5	0.948616600790514	40	13	47.4	0	252	133	132	171	ORE02502.1 cyclin-domain-containing protein [Rhizopus microsporus var. microsporus]	diamond	240	55.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
30484625	30484625	PRJNA1253303_P_NODE_1693_length_392_cov_0.978056_g1671_i0	PRJNA1253303	1693	392	0.978056	3.83397952	Rhizomucor pusillus	4840	Fungi	Fungi	129	6.829999999999998e-35	NR	XP_069242305.1	4840	g1671	i0	51.2	2.81632653061224	123	59	94.1	1	23	391	1	122	XP_069242305.1 uncharacterized protein VTP01DRAFT_7840 [Rhizomucor pusillus]	diamond	1104	129	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
30484629	30484629	PRJNA1253303_P_NODE_7333_length_246_cov_0.901734_g7311_i0	PRJNA1253303	7333	246	0.901734	2.21826564	Phycomyces blakesleeanus	4837	Fungi	Fungi	52	2.08e-5	NR	KAL0093496.1	4837	g7311	i0	38.4	4.35365853658537	73	42	85.4	2	36	245	389	461	KAL0093496.1 hypothetical protein F4703DRAFT_1730878, partial [Phycomyces blakesleeanus]	diamond	1071	52	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
30881524	30881524	PRJNA1253303_P_NODE_8194_length_243_cov_0.917647_g8172_i0	PRJNA1253303	8194	243	0.917647	2.22988221	Mucorales	4827	Fungi	Fungi	48.9	2.45e-4	NR	GAA5812367.1	439312	g8172	i0	39.1	3.22222222222222	87	45	100	3	243	1	58	142	GAA5812367.1 hypothetical protein MFLAVUS_005819 [Mucor flavus]	diamond	783	49.3	0.991886409736308	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor flavus
31590980	31590980	PRJNA1253303_P_NODE_6116_length_249_cov_1.130682_g6094_i0	PRJNA1253303	6116	249	1.130682	2.81539818	Rhizophagus clarus	94130	Fungi	Fungi	74.7	2.18e-13	NR	GBB85365.1	94130	g6094	i0	42.7	1.97590361445783	82	47	98.8	0	3	248	508	589	GBB85365.1 hypothetical protein RclHR1_11910001 [Rhizophagus clarus]	diamond	492	74.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
32540152	32540152	PRJNA1253303_P_NODE_3679_length_287_cov_0.957944_g3657_i0	PRJNA1253303	3679	287	0.957944	2.74929928	Gongronella butleri	101105	Fungi	Fungi	44.3	0.0159	NR	KAI8072677.1	101105	g3657	i0	31.2	0.804878048780488	77	46	73.2	2	3	212	2	78	KAI8072677.1 3-oxo-5-alpha-steroid 4-dehydrogenase-domain-containing protein [Gongronella butleri]	diamond	231	44.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Gongronella	Gongronella butleri

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