metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1159911" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1159911" 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
18159835	18159835	PRJNA1159911_P_NODE_60855_length_308_cov_1.310638_g60313_i0	PRJNA1159911	60855	308	1.310638	4.03676504	Opisthokonta	33154	Fungi	Fungi	146	4.55e-41	NR	KAL0085350.1	4837	g60313	i0	71.3	18.75	101	29	98.4	0	4	306	26	126	KAL0085350.1 40S ribosomal protein S6-B [Phycomyces blakesleeanus]	diamond	5775	147	0.993197278911565	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
27091364	27091364	PRJNA1159911_P_NODE_97442_length_243_cov_1.811765_g96900_i0	PRJNA1159911	97442	243	1.811765	4.40258895	Opisthokonta	33154	Fungi	Fungi	124	6.31e-35	NR	RCI02638.1	4846	g96900	i0	70.7	58.3333333333333	75	22	92.6	0	2	226	38	112	RCI02638.1 ribosomal protein S15 [Rhizopus stolonifer]	diamond	14175	125	0.992	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus stolonifer
27628604	27628604	PRJNA1159911_P_NODE_99984_length_242_cov_0.911243_g99442_i0	PRJNA1159911	99984	242	0.911243	2.20520806	Mucoromycota	1913637	Fungi	Fungi	67.8	5.25e-11	NR	ORZ03995.1	13706	g99442	i0	41.4	1.8099173553719	70	41	86.8	0	225	16	99	168	ORZ03995.1 polynucleotide kinase 3 phosphatase-domain-containing protein [Syncephalastrum racemosum]	diamond	438	67.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
30925279	30925279	PRJNA1159911_P_NODE_102574_length_235_cov_2.814815_g102032_i0	PRJNA1159911	102574	235	2.814815	6.61481525	Haplosporangium sp. Z 767	1897647	Fungi	Fungi	82.8	8.18e-17	NR	KAF9187984.1	1897647	g102032	i0	60.3	0.868085106382979	68	26	85.5	1	232	32	164	231	KAF9187984.1 Inorganic pyrophosphatase [Haplosporangium sp. Z 767]	diamond	204	82.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Haplosporangium	Haplosporangium sp. Z 767
31639872	31639872	PRJNA1159911_P_NODE_55376_length_326_cov_1.399209_g54834_i0	PRJNA1159911	55376	326	1.399209	4.56142134	Fungi	4751	Fungi	Fungi	73.6	1.33e-12	NR	KAF9585876.1	979761	g54834	i0	75.6	4.15030674846626	45	11	41.4	0	326	192	272	316	KAF9585876.1 cross-pathway control WD-repeat protein cpc2 [Lunasporangiospora selenospora]	diamond	1353	73.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lunasporangiospora	Lunasporangiospora selenospora
31936796	31936796	PRJNA1159911_P_NODE_83677_length_256_cov_1.683060_g83135_i0	PRJNA1159911	83677	256	1.68306	4.3086336	Rhizomucor pusillus	4840	Fungi	Fungi	89	5.34e-19	NR	XP_069237285.1	4840	g83135	i0	59	2.21484375	78	31	91.4	1	22	255	19	95	XP_069237285.1 uncharacterized protein VTP01DRAFT_2509 [Rhizomucor pusillus]	diamond	567	89	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
32348498	32348498	PRJNA1159911_P_NODE_75419_length_272_cov_1.015075_g74877_i0	PRJNA1159911	75419	272	1.015075	2.761004	Lobosporangium transversale	64571	Fungi	Fungi	43.9	0.0201	NR	XP_021877401.1	64571	g74877	i0	47.2	1.16911764705882	53	27	58.5	1	85	243	238	289	XP_021877401.1 hypothetical protein BCR41DRAFT_171525 [Lobosporangium transversale]	diamond	318	43.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
32348503	32348503	PRJNA1159911_P_NODE_79399_length_264_cov_1.209424_g78857_i0	PRJNA1159911	79399	264	1.209424	3.19287936	Paraglomus occultum	144539	Fungi	Fungi	53.5	7.35e-6	NR	CAG8554860.1	144539	g78857	i0	36.4	0.875	77	42	79.5	2	47	256	379	455	CAG8554860.1 4184_t:CDS:2 [Paraglomus occultum]	diamond	231	53.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales	Paraglomeraceae	Paraglomus	Paraglomus occultum

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