metadata: contig_metadata: 8 rows where bioproject = "PRJNA807685", tax_kingdom = "Fungi" and tax

8 rows where bioproject = "PRJNA807685", tax_kingdom = "Fungi" 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
19933235	19933235	PRJNA807685_P_NODE_34996_length_211_cov_1.603448_g33923_i0	PRJNA807685	34996	211	1.603448	3.38327528	Zychaea mexicana	64656	Fungi	Fungi	56.5	0.001	NTclustered	gi\|2432194474\|ref\|XM_053125651.1\|	64656	g33923	i0	96.97	0.156398104265403	33	1	16	0	102	134	670	638	Zychaea mexicana uncharacterized protein (BDB00DRAFT_853817), mRNA	blastn	33	56.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana
27758336	27758336	PRJNA807685_P_NODE_31744_length_225_cov_1.936170_g30671_i0	PRJNA807685	31744	225	1.93617	4.3563825	Eukaryota	2759	Fungi	Fungi	72.4	1.01e-12	NR	CAG8809826.1	4874	g30671	i0	56.5	34.48	62	27	82.7	0	27	212	475	536	CAG8809826.1 31114_t:CDS:2, partial [Gigaspora margarita]	diamond	7758	72.8	0.994505494505495	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
28001898	28001898	PRJNA807685_P_NODE_38145_length_200_cov_1.190184_g37072_i0	PRJNA807685	38145	200	1.190184	2.380368	Ambispora gerdemannii	144530	Fungi	Fungi	45.1	0.00218	NR	CAG8441140.1	144530	g37072	i0	48.6	0.555	37	19	55.5	0	24	134	86	122	CAG8441140.1 1583_t:CDS:2 [Ambispora gerdemannii]	diamond	111	45.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Ambisporaceae	Ambispora	Ambispora gerdemannii
29905242	29905242	PRJNA807685_P_NODE_55971_length_163_cov_2.325397_g54898_i0	PRJNA807685	55971	163	2.325397	3.79039711	Mucoromycota	1913637	Fungi	Fungi	41.6	0.03	NR	KAI7869435.1	101115	g54898	i0	42.3	1.85889570552147	52	28	92	1	157	8	116	167	KAI7869435.1 hypothetical protein BDF14DRAFT_302405 [Spinellus fusiger]	diamond	303	41.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Spinellus	Spinellus fusiger
30685960	30685960	PRJNA807685_P_NODE_56853_length_162_cov_1.800000_g55780_i0	PRJNA807685	56853	162	1.8	2.916	Calcarisporiella thermophila	911321	Fungi	Fungi	64.3	3.09e-10	NR	XP_069250474.1	911321	g55780	i0	57.1	2.31481481481481	42	18	77.8	0	126	1	185	226	XP_069250474.1 uncharacterized protein VTP21DRAFT_2586 [Calcarisporiella thermophila]	diamond	375	64.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
31421875	31421875	PRJNA807685_P_NODE_8136_length_628_cov_6.150592_g7156_i0	PRJNA807685	8136	628	6.150592	38.62571776	Opisthokonta	33154	Fungi	Fungi	199	9.079999999999999e-55	NR	GES98494.1	94130	g7156	i0	46.2	24.0143312101911	210	111	99.8	2	2	628	1697	1905	GES98494.1 retroviral-like aspartic protease 1 [Rhizophagus clarus]	diamond	15081	201	0.990049751243781	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
32362347	32362347	PRJNA807685_P_NODE_42759_length_187_cov_2.280000_g41686_i0	PRJNA807685	42759	187	2.28	4.2636	Ambispora gerdemannii	144530	Fungi	Fungi	47.8	2.92e-4	NR	CAG8458434.1	144530	g41686	i0	41.7	6.54545454545455	60	35	96.3	0	186	7	1	60	CAG8458434.1 11227_t:CDS:1, partial [Ambispora gerdemannii]	diamond	1224	47.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Ambisporaceae	Ambispora	Ambispora gerdemannii
32812628	32812628	PRJNA807685_P_NODE_32840_length_220_cov_1.661202_g31767_i0	PRJNA807685	32840	220	1.661202	3.6546444	Opisthokonta	33154	Fungi	Fungi	91.7	1.34e-19	NR	KAG1191506.1	58291	g31767	i0	57.5	70.6636363636364	73	31	99.5	0	2	220	152	224	KAG1191506.1 hypothetical protein G6F70_009302 [Rhizopus microsporus]	diamond	15546	91.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus

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