metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA682370" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA682370" 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
8317386	8317386	PRJNA682370_S_NODE_17387_length_172_cov_1.270073_g16775_i0	PRJNA682370	17387	172	1.270073	2.18452556	Fungi	4751	Fungi	Fungi	94.4	5.63e-22	NR	XP_069254899.1	911321	g16775	i0	82.5	13.9011627906977	57	10	99.4	0	2	172	84	140	XP_069254899.1 60S ribosomal protein eL6 [Calcarisporiella thermophila]	diamond	2391	94.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
28009953	28009953	PRJNA682370_S_NODE_10445_length_226_cov_1.513089_g9833_i0	PRJNA682370	10445	226	1.513089	3.41958114	Eukaryota	2759	Fungi	Fungi	55.5	8.7e-7	NR	RCH83901.1	4846	g9833	i0	58.5	6.2787610619469	41	17	54.4	0	124	2	227	267	RCH83901.1 hypothetical protein CU098_003291 [Rhizopus stolonifer]	diamond	1419	55.8	0.99462365591397806	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus stolonifer
29682841	29682841	PRJNA682370_S_NODE_17670_length_171_cov_1.007353_g17058_i0	PRJNA682370	17670	171	1.007353	1.72257363	Fungi	4751	Fungi	Fungi	87.8	3.73e-20	NR	KAG9307759.1	50956	g17058	i0	77.4	6.50877192982456	53	12	93	0	160	2	108	160	KAG9307759.1 hypothetical protein G9A89_023324 [Geosiphon pyriformis]	diamond	1113	88.6	0.99097065462754	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Geosiphonaceae	Geosiphon	Geosiphon pyriformis
29892764	29892764	PRJNA682370_S_NODE_21031_length_159_cov_1.016129_g20419_i0	PRJNA682370	21031	159	1.016129	1.61564511	Rhizopus delemar RA 99-88	936053	Fungi	Fungi	44.3	0.00353	NR	XP_067515905.1	246409	g20419	i0	52.5	2.67924528301887	40	17	71.7	1	46	159	148	187	XP_067515905.1 uncharacterized protein RO3G_05214 [Rhizopus delemar RA 99-880]	diamond	426	44.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
31199171	31199171	PRJNA682370_S_NODE_21115_length_158_cov_2.569106_g20503_i0	PRJNA682370	21115	158	2.569106	4.05918748	Glomeromycetes	214506	Fungi	Fungi	83.6	2.2e-18	NR	KAG9283946.1	50956	g20503	i0	73.5	11.2215189873418	49	13	93	0	156	10	100	148	KAG9283946.1 hypothetical protein G9A89_005453 [Geosiphon pyriformis]	diamond	1773	84.3	0.991696322657177	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Geosiphonaceae	Geosiphon	Geosiphon pyriformis
31377851	31377851	PRJNA682370_S_NODE_5536_length_336_cov_1.667774_g4924_i0	PRJNA682370	5536	336	1.667774	5.60372064	Cunninghamella echinulata	76405	Fungi	Fungi	73.6	4.94e-13	NR	KAI9303835.1	76405	g4924	i0	46.1	1.58928571428571	89	48	79.5	0	267	1	15	103	KAI9303835.1 ribosomal protein L30, ferredoxin-like fold domain-containing protein [Cunninghamella echinulata]	diamond	534	73.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Cunninghamella	Cunninghamella echinulata
31863645	31863645	PRJNA682370_S_NODE_16317_length_177_cov_1.774648_g15705_i0	PRJNA682370	16317	177	1.774648	3.14112696	Eukaryota	2759	Fungi	Fungi	90.9	1.66e-19	NR	SAM00168.1	4829	g15705	i0	65.5	19.6610169491525	58	20	98.3	0	176	3	1270	1327	SAM00168.1 hypothetical protein [Absidia glauca]	diamond	3480	90.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca

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