metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA797475" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA797475" 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
4609784	4609784	PRJNA797475_P_NODE_2624_length_602_cov_1.508507_g2526_i0	PRJNA797475	2624	602	1.508507	9.08121214	Phycomyces blakesleeanus	4837	Fungi	Fungi	331	6.8400000000000007e-86	NTclustered	gi\|1069936519\|ref\|XM_018440025.1\|	763407	g2526	i0	80.41	62.5199335548173	439	83	73	2	1	439	136	571	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	37637	331	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
5884942	5884942	PRJNA797475_P_NODE_23145_length_249_cov_0.875000_g23046_i0	PRJNA797475	23145	249	0.875	2.17875	Rhizopus microsporus	58291	Fungi	Fungi	132	2.81e-26	NTclustered	gi\|1331190836\|ref\|XM_023615507.1\|	1340429	g23046	i0	78.607	0.807228915662651	201	42	80	1	47	246	60	260	Rhizopus microsporus ATCC 52813 14-3-3 protein (RHIMIDRAFT_64213), mRNA	blastn	201	132	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
7159695	7159695	PRJNA797475_P_NODE_14586_length_286_cov_1.145540_g14487_i0	PRJNA797475	14586	286	1.14554	3.2762444	Mortierella sp. MS-6	281844	Fungi	Fungi	76.8	1.57e-9	NTclustered	gi\|82398296\|gb\|DQ273786.1\|	281844	g14487	i0	100	13.3391608391608	41	0	14	0	1	41	2798	2758	Mortierella sp. MS-6 isolate AFTOL-ID 42 28S ribosomal RNA gene, partial sequence	blastn	3815	76.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella sp. MS-6
8434464	8434464	PRJNA797475_P_NODE_16207_length_277_cov_1.509804_g16108_i0	PRJNA797475	16207	277	1.509804	4.18215708	Zychaea mexicana	64656	Fungi	Fungi	180	1.1199999999999999e-40	NTclustered	gi\|2432184741\|ref\|XM_053129968.1\|	64656	g16108	i0	80.417	79.4440433212996	240	44	86	1	3	239	240	1	Zychaea mexicana histone H3 (BDB00DRAFT_979855), partial mRNA	blastn	22006	180	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana
9709580	9709580	PRJNA797475_P_NODE_16688_length_275_cov_1.143564_g16589_i0	PRJNA797475	16688	275	1.143564	3.144801	Gamsiella multidivaricata	101098	Fungi	Fungi	171	6.69e-38	NTclustered	gi\|2323775344\|ref\|XM_051554880.1\|	101098	g16589	i0	84.091	22.5054545454545	176	28	64	0	4	179	273	448	Gamsiella multidivaricata ribosomal protein s23 (BC939DRAFT_445976), mRNA	blastn	6189	171	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
13970876	13970876	PRJNA797475_P_NODE_13791_length_290_cov_1.391705_g13692_i0	PRJNA797475	13791	290	1.391705	4.0359445	root	1	Root_unresolved	Root_unresolved	313	1.12e-80	NTclustered	gi\|530339809\|gb\|KC666029.1\|	4874	g13692	i0	86.102	101.389655172414	295	35	100	6	1	290	273	566	Gigaspora margarita isolate WDG47 18S ribosomal RNA gene, partial sequence	blastn	29403	313	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
16083816	16083816	PRJNA797475_P_NODE_11273_length_315_cov_2.144628_g11174_i0	PRJNA797475	11273	315	2.144628	6.7555782	Halteromyces radiatus	101107	Fungi	Fungi	191	5.99e-44	NTclustered	gi\|2323707249\|ref\|XM_051541878.1\|	101107	g11174	i0	79.487	19.7015873015873	273	53	87	3	37	309	130	399	Halteromyces radiatus 40S ribosomal protein S2 (BX664DRAFT_290292), mRNA	blastn	6206	191	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
16519883	16519883	PRJNA797475_P_NODE_31153_length_203_cov_5.853846_g31054_i0	PRJNA797475	31153	203	5.853846	11.88330738	Fungi	4751	Fungi	Fungi	375	9.24e-100	NTclustered	gi\|658131632\|emb\|HF968958.1\|	4874	g31054	i0	100	145.216748768473	203	0	100	0	1	203	1995	2197	Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26	blastn	29479	375	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
17359965	17359965	PRJNA797475_P_NODE_7054_length_383_cov_1.819355_g6955_i0	PRJNA797475	7054	383	1.819355	6.96812965	Gamsiella multidivaricata	101098	Fungi	Fungi	180	1.61e-40	NTclustered	gi\|2323775902\|ref\|XM_051549929.1\|	101098	g6955	i0	85.549	40.7075718015666	173	23	45	2	190	361	377	206	Gamsiella multidivaricata putative 60S ribosomal protein L27A (BC939DRAFT_112647), mRNA	blastn	15591	180	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
22894541	22894541	PRJNA797475_P_NODE_17698_length_269_cov_4.724490_g17599_i0	PRJNA797475	17698	269	4.72449	12.7088781	Fungi	4751	Fungi	Fungi	69.4	2.45e-7	NTclustered	gi\|2323709746\|ref\|XM_051543720.1\|	101107	g17599	i0	93.478	0.546468401486989	46	3	17	0	2	47	194	149	Halteromyces radiatus histone H2B (BX664DRAFT_323875), mRNA	blastn	147	69.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
25007693	25007693	PRJNA797475_P_NODE_12040_length_307_cov_1.923077_g11941_i0	PRJNA797475	12040	307	1.923077	5.90384639	Rhizomucor pusillus	4840	Fungi	Fungi	195	4.5e-45	NTclustered	gi\|2837731086\|ref\|XM_069388369.1\|	4840	g11941	i0	80.233	55.1302931596091	258	51	84	0	10	267	267	10	Rhizomucor pusillus 60S ribosomal protein eL43 (VTP01DRAFT_9167), partial mRNA	blastn	16925	195	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus

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