metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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
7416937	7416937	PRJNA1160211_S_NODE_78586_length_501_cov_19.848131_g77370_i0	PRJNA1160211	78586	501	19.848131	99.43913631	Backusella circina FSU 941	1314798	Fungi	Fungi	168	1.83e-50	NR	KAI8882719.1	1314798	g77370	i0	74.8	1.31736526946108	111	28	66.5	0	478	146	16	126	KAI8882719.1 endoribonuclease L-PSP [Backusella circina FSU 941]	diamond	660	168	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Backusellaceae	Backusella	Backusella circina
18162006	18162006	PRJNA1160211_S_NODE_30915_length_647_cov_31.954704_g29818_i0	PRJNA1160211	30915	647	31.954704	206.74693488	Mucoromycota	1913637	Fungi	Fungi	230	2.7199999999999992e-68	NR	KAG2187787.1	44442	g29818	i0	59.7	5.1097372488408	216	72	95.1	6	14	628	407	618	KAG2187787.1 hypothetical protein INT44_005477 [Umbelopsis vinacea]	diamond	3306	230	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis vinacea
27861577	27861577	PRJNA1160211_S_NODE_282145_length_241_cov_2.732143_g280912_i0	PRJNA1160211	282145	241	2.732143	6.58446463	Phascolomyces articulosus	60185	Fungi	Fungi	54.3	2.84e-6	NR	KAI9243903.1	60185	g280912	i0	46.9	1.58091286307054	64	31	77.2	3	45	230	8	70	KAI9243903.1 kinase-like domain-containing protein [Phascolomyces articulosus]	diamond	381	54.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Phascolomyces	Phascolomyces articulosus
28796438	28796438	PRJNA1160211_S_NODE_81407_length_495_cov_6.779621_g80190_i0	PRJNA1160211	81407	495	6.779621	33.55912395	Fungi	4751	Fungi	Fungi	55.5	1.44e-5	NR	KAF0525725.1	4874	g80190	i0	46	1.28484848484848	63	30	38.2	1	425	237	160	218	KAF0525725.1 HCP-like protein [Gigaspora margarita]	diamond	636	55.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
29882668	29882668	PRJNA1160211_S_NODE_194211_length_317_cov_5.143443_g192978_i0	PRJNA1160211	194211	317	5.143443	16.30471431	Umbelopsis sp. PMI_123	1896174	Fungi	Fungi	98.6	4.8e-22	NR	KAH8553423.1	1896174	g192978	i0	63.8	0.757097791798107	80	29	75.7	0	78	317	4	83	KAH8553423.1 hypothetical protein BGW37DRAFT_260472 [Umbelopsis sp. PMI_123]	diamond	240	98.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis sp. PMI_123
30451398	30451398	PRJNA1160211_S_NODE_162233_length_357_cov_20.859155_g161000_i0	PRJNA1160211	162233	357	20.859155	74.46718335	Linnemannia elongata	310910	Fungi	Fungi	42.7	0.0247	NR	KAK5809265.1	310910	g161000	i0	47.5	0.80672268907563	61	24	44.5	2	67	225	29	89	KAK5809265.1 hypothetical protein F5H01DRAFT_369134 [Linnemannia elongata]	diamond	288	42.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Linnemannia	Linnemannia elongata
30976110	30976110	PRJNA1160211_S_NODE_176434_length_339_cov_2.451128_g175201_i0	PRJNA1160211	176434	339	2.451128	8.30932392	Mucoromycota	1913637	Fungi	Fungi	119	6.71e-29	NR	XP_021886141.1	64571	g175201	i0	59.8	11.5309734513274	92	37	81.4	0	25	300	365	456	XP_021886141.1 hypothetical protein BCR41DRAFT_376431 [Lobosporangium transversale]	diamond	3909	119	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
31039461	31039461	PRJNA1160211_S_NODE_265055_length_250_cov_2.610169_g263822_i0	PRJNA1160211	265055	250	2.610169	6.5254225	Entrophospora	27375	Fungi	Fungi	48.1	4.14e-4	NR	CAG8566807.1	984092	g263822	i0	59.5	3.552	37	15	44.4	0	163	53	52	88	CAG8566807.1 13539_t:CDS:2, partial [Entrophospora candida]	diamond	888	48.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Entrophosporales	Entrophosporaceae	Entrophospora	Entrophospora candida
31525867	31525867	PRJNA1160211_S_NODE_156816_length_365_cov_3.671233_g155583_i0	PRJNA1160211	156816	365	3.671233	13.40000045	Mycotypha africana	64632	Fungi	Fungi	82	1.8e-15	NR	XP_052933002.1	64632	g155583	i0	40.2	0.920547945205479	112	56	92.1	1	1	336	293	393	XP_052933002.1 regulator of chromosome condensation 1/beta-lactamase-inhibitor protein II [Mycotypha africana]	diamond	336	82	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mycotyphaceae	Mycotypha	Mycotypha africana
31968503	31968503	PRJNA1160211_S_NODE_185838_length_327_cov_3.968504_g184605_i0	PRJNA1160211	185838	327	3.968504	12.97700808	Jimgerdemannia flammicorona	994334	Fungi	Fungi	82.8	3.3e-17	NR	RUS28804.1	994334	g184605	i0	72.5	0.935779816513762	51	14	46.8	0	175	327	99	149	RUS28804.1 phosphatidylinositol N-acetylglucosaminyltransferase subunit Y-domain-containing protein [Jimgerdemannia flammicorona]	diamond	306	82.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales	Endogonaceae	Jimgerdemannia	Jimgerdemannia flammicorona
32095164	32095164	PRJNA1160211_S_NODE_56938_length_556_cov_3.368530_g55760_i0	PRJNA1160211	56938	556	3.36853	18.7290268	Syncephalastrum racemosum	13706	Fungi	Fungi	48.1	0.00481	NR	ORY93249.1	13706	g55760	i0	52.3	0.474820143884892	65	20	30.2	2	6	173	73	135	ORY93249.1 hypothetical protein BCR43DRAFT_496577 [Syncephalastrum racemosum]	diamond	264	48.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
32209468	32209468	PRJNA1160211_S_NODE_24038_length_684_cov_5.332242_g22992_i0	PRJNA1160211	24038	684	5.332242	36.47253528	Cunninghamellaceae	4851	Fungi	Fungi	85.5	2.61e-16	NR	KAI8075209.1	101105	g22992	i0	56.3	1.55701754385965	71	31	31.1	0	24	236	147	217	KAI8075209.1 GPR1/FUN34/yaaH family-domain-containing protein [Gongronella butleri]	diamond	1065	85.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Gongronella	Gongronella butleri
32253687	32253687	PRJNA1160211_S_NODE_65198_length_533_cov_51.108696_g63999_i0	PRJNA1160211	65198	533	51.108696	272.40934968	Rhizomucor pusillus	4840	Fungi	Fungi	72.8	9.8e-12	NR	XP_069244083.1	4840	g63999	i0	54.7	0.360225140712946	64	28	35.5	1	407	219	48	111	XP_069244083.1 uncharacterized protein VTP01DRAFT_4669 [Rhizomucor pusillus]	diamond	192	72.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
32336197	32336197	PRJNA1160211_S_NODE_223039_length_286_cov_3.863850_g221806_i0	PRJNA1160211	223039	286	3.86385	11.050611	Eukaryota	2759	Fungi	Fungi	48.5	5.21e-4	NR	KAI9305436.1	76405	g221806	i0	46.7	3.7972027972028	45	24	47.2	0	167	33	1	45	KAI9305436.1 GRASP55/65 PDZ-like domain-containing protein [Cunninghamella echinulata]	diamond	1086	48.9	0.991820040899796	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Cunninghamella	Cunninghamella echinulata

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