metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA971593" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA971593" 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
7644251	7644251	PRJNA971593_P_NODE_15066_length_309_cov_1.305085_g14917_i0	PRJNA971593	15066	309	1.305085	4.03271265	Mortierellaceae	4854	Fungi	Fungi	196	1.26e-45	NTclustered	gi\|1227143098\|ref\|XM_022027954.1\|	64571	g14917	i0	82.301	24.8252427184466	226	40	73	0	14	239	366	141	Lobosporangium transversale zinc-binding ribosomal protein (BCR41DRAFT_388020), partial mRNA	blastn	7671	196	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
12745491	12745491	PRJNA971593_P_NODE_23430_length_249_cov_1.312500_g23281_i0	PRJNA971593	23430	249	1.3125	3.268125	Opisthokonta	33154	Fungi	Fungi	193	1.27e-44	NTclustered	gi\|2323721132\|ref\|XM_051575490.1\|	101096	g23281	i0	80.645	86.0843373493976	248	48	99	0	2	249	1773	1526	Gilbertella persicaria 70 kDa heat shock protein 3 (B0P05DRAFT_504449), mRNA	blastn	21435	193	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
14972145	14972145	PRJNA971593_P_NODE_17192_length_287_cov_1.948598_g17043_i0	PRJNA971593	17192	287	1.948598	5.59247626	Rhizophagus irregularis	588596	Fungi	Fungi	56.5	0.002	NTclustered	gi\|2749803153\|ref\|XM_066132065.1\|	588596	g17043	i0	92.308	0.13588850174216	39	3	14	0	218	256	1108	1070	Rhizophagus irregularis uncharacterized protein (OCT59_007746), partial mRNA	blastn	39	56.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
20070810	20070810	PRJNA971593_P_NODE_13716_length_325_cov_1.269841_g13567_i0	PRJNA971593	13716	325	1.269841	4.12698325	Umbelopsis ramanniana	41833	Fungi	Fungi	237	7.860000000000001e-58	NTclustered	gi\|2323693911\|ref\|XM_051591000.1\|	1314678	g13567	i0	84.337	67.7876923076923	249	31	75	4	77	321	577	333	Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_253187), mRNA	blastn	22031	237	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
20070910	20070910	PRJNA971593_P_NODE_21316_length_255_cov_1.269231_g21167_i0	PRJNA971593	21316	255	1.269231	3.23653905	Rhizomucor pusillus	4840	Fungi	Fungi	211	3.61e-50	NTclustered	gi\|2837710818\|ref\|XM_069382993.1\|	4840	g21167	i0	81.641	44.0235294117647	256	45	100	2	1	255	280	534	Rhizomucor pusillus 40S ribosomal protein uS7 (VTP01DRAFT_4323), partial mRNA	blastn	11226	211	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
20392614	20392614	PRJNA971593_P_NODE_8576_length_414_cov_1.847507_g8427_i0	PRJNA971593	8576	414	1.847507	7.64867898	Eukaryota	2759	Fungi	Fungi	603	8.759999999999999e-168	NTclustered	gi\|41353938\|gb\|AY522919.1\|	262042	g8427	i0	92.857	90.1473429951691	420	22	99	5	1	412	20	439	Glomus sp. Tf 2-16 26S ribosomal RNA gene, partial sequence	blastn	37321	608	0.991776315789474	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Glomus	Glomus sp. Tf 2-16
21346378	21346378	PRJNA971593_P_NODE_24737_length_247_cov_1.712644_g24588_i0	PRJNA971593	24737	247	1.712644	4.23023068	Calcarisporiella thermophila	911321	Fungi	Fungi	237	5.74e-58	NTclustered	gi\|2837822230\|ref\|XM_069396782.1\|	911321	g24588	i0	84.082	8.82995951417004	245	39	99	0	1	245	6059	6303	Calcarisporiella thermophila uncharacterized protein (VTP21DRAFT_618), partial mRNA	blastn	2181	237	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
22943949	22943949	PRJNA971593_P_NODE_178_length_2092_cov_3.042595_g132_i0	PRJNA971593	178	2092	3.042595	63.6510874	Mucorales	4827	Fungi	Fungi	1223	0	NTclustered	gi\|2432142676\|ref\|XM_053120491.1\|	64656	g132	i0	80.516	75.0239005736138	1627	290	77	21	56	1670	17	1628	Zychaea mexicana 70 kDa heat shock protein 3 (BDB00DRAFT_784808), partial mRNA	blastn	156950	1223	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana
24217944	24217944	PRJNA971593_P_NODE_4539_length_568_cov_1.414141_g4393_i0	PRJNA971593	4539	568	1.414141	8.03232088	Mucorales	4827	Fungi	Fungi	287	1.41e-72	NTclustered	gi\|2323703744\|ref\|XM_051570545.1\|	64574	g4393	i0	77.778	72.9383802816901	504	86	86	24	1	491	251	741	Radiomyces spectabilis 60S ribosomal protein L2 (BYT42DRAFT_591511), partial mRNA	blastn	41429	289	0.993079584775087	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Radiomycetaceae	Radiomyces	Radiomyces spectabilis

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