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

10 rows where analysis = "diamond", bioproject = "PRJNA1103784" 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
11690798	11690798	PRJNA1103784_P_NODE_2630_length_333_cov_1.480769_g2575_i0	PRJNA1103784	2630	333	1.480769	4.93096077	Fungi	4751	Fungi	Fungi	172	9.39e-53	NR	KAG0164419.1	2184030	g2575	i0	73.6	6.93693693693694	110	29	99.1	0	2	331	10	119	KAG0164419.1 ribosomal 40S subunit protein S13 [Apophysomyces sp. BC1015]	diamond	2310	172	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Apophysomyces	Apophysomyces sp. BC1015
21888890	21888890	PRJNA1103784_P_NODE_1118_length_474_cov_3.256858_g1063_i0	PRJNA1103784	1118	474	3.256858	15.43750692	Opisthokonta	33154	Fungi	Fungi	181	2.219999999999999e-55	NR	XP_069235339.1	4840	g1063	i0	58.8	19.1835443037975	148	61	93.7	0	461	18	20	167	XP_069235339.1 40S ribosomal uS19 domain-containing protein [Rhizomucor pusillus]	diamond	9093	181	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
27216754	27216754	PRJNA1103784_P_NODE_2642_length_332_cov_1.552124_g2587_i0	PRJNA1103784	2642	332	1.552124	5.15305168	Mortierella	4855	Fungi	Fungi	80.9	4.16e-15	NR	KAF9930638.1	64518	g2587	i0	40.2	2.90060240963855	107	57	90.4	1	330	31	407	513	KAF9930638.1 Twinfilin-1 [Mortierella alpina]	diamond	963	81.3	0.995079950799508	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella alpina
27817308	27817308	PRJNA1103784_P_NODE_2824_length_322_cov_1.546185_g2769_i0	PRJNA1103784	2824	322	1.546185	4.9787157	Fungi	4751	Fungi	Fungi	88.2	4.62e-20	NR	XP_069256026.1	911321	g2769	i0	66.1	3.55900621118012	62	21	57.8	0	47	232	1	62	XP_069256026.1 ribosomal protein P2 [Calcarisporiella thermophila]	diamond	1146	88.6	0.99548532731377	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
28227296	28227296	PRJNA1103784_P_NODE_2606_length_334_cov_6.647510_g2551_i0	PRJNA1103784	2606	334	6.64751	22.2026834	Eukaryota	2759	Fungi	Fungi	107	2.1200000000000003e-27	NR	KAF9368268.1	78898	g2551	i0	50.5	4.58083832335329	101	48	88.9	1	34	330	2	102	KAF9368268.1 cofilin, partial [Podila verticillata]	diamond	1530	108	0.990740740740741	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila verticillata
29017257	29017257	PRJNA1103784_P_NODE_6408_length_247_cov_1.649425_g6353_i0	PRJNA1103784	6408	247	1.649425	4.07407975	Mucoromycota	1913637	Fungi	Fungi	106	1.31e-24	NR	KAG9321120.1	64518	g6353	i0	63.4	29.8542510121457	82	30	99.6	0	246	1	883	964	KAG9321120.1 hypothetical protein KVV02_000702 [Mortierella alpina]	diamond	7374	107	0.990654205607477	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella alpina
30257604	30257604	PRJNA1103784_P_NODE_4012_length_282_cov_1.454545_g3957_i0	PRJNA1103784	4012	282	1.454545	4.1018169	Rhizopus delemar	936053	Fungi	Fungi	119	1.57e-30	NR	KAG1469541.1	936053	g3957	i0	64.7	0.904255319148936	85	23	83	1	1	234	222	306	KAG1469541.1 hypothetical protein G6F56_003203 [Rhizopus delemar]	diamond	255	119	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
30352596	30352596	PRJNA1103784_P_NODE_5132_length_260_cov_1.893048_g5077_i0	PRJNA1103784	5132	260	1.893048	4.9219248	Glomus cerebriforme	658196	Fungi	Fungi	77.8	1.93e-14	NR	RIA85156.1	658196	g5077	i0	42.9	2.57307692307692	84	43	92.3	2	4	243	363	445	RIA85156.1 Metallo-dependent phosphatase-like protein [Glomus cerebriforme]	diamond	669	77.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Glomus	Glomus cerebriforme
30541595	30541595	PRJNA1103784_P_NODE_2393_length_346_cov_1.296703_g2338_i0	PRJNA1103784	2393	346	1.296703	4.48659238	Diversispora epigaea	1348612	Fungi	Fungi	78.2	4.52e-14	NR	RHZ85702.1	1348612	g2338	i0	43.5	3.72832369942197	115	57	99.7	2	345	1	171	277	RHZ85702.1 hypothetical protein Glove_62g11 [Diversispora epigaea]	diamond	1290	78.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora epigaea
32280907	32280907	PRJNA1103784_P_NODE_6799_length_245_cov_2.808140_g6744_i0	PRJNA1103784	6799	245	2.80814	6.879943	Funneliformis geosporum	1117311	Fungi	Fungi	112	7.23e-29	NR	CAI2176636.1	1117311	g6744	i0	66.7	1.91020408163265	78	26	95.5	0	245	12	73	150	CAI2176636.1 7433_t:CDS:1 [Funneliformis geosporum]	diamond	468	112	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Funneliformis	Funneliformis geosporum

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