metadata: contig_metadata: 10 rows where bioproject = "PRJNA1156092" and tax

10 rows where bioproject = "PRJNA1156092" 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
5405896	5405896	PRJNA1156092_P_NODE_25385_length_248_cov_0.880000_g25255_i0	PRJNA1156092	25385	248	0.88	2.1824	Rhizophagus irregularis	588596	Fungi	Fungi	54.7	0.006	NTclustered	gi\|2749784523\|ref\|XM_066133944.1\|	588596	g25255	i0	100	0.116935483870968	29	0	12	0	128	156	635	607	Rhizophagus irregularis uncharacterized protein (OCT59_024779), partial mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
9230719	9230719	PRJNA1156092_P_NODE_16748_length_286_cov_1.375587_g16618_i0	PRJNA1156092	16748	286	1.375587	3.93417882	Mycotypha africana	64632	Fungi	Fungi	200	8.919999999999998e-47	NTclustered	gi\|2432561609\|ref\|XM_053077210.1\|	64632	g16618	i0	82.479	32.9755244755245	234	35	81	6	55	285	393	163	Mycotypha africana 40S ribosomal protein S16 (BDF20DRAFT_816965), partial mRNA	blastn	9431	200	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mycotyphaceae	Mycotypha	Mycotypha africana
11781356	11781356	PRJNA1156092_P_NODE_17590_length_280_cov_1.468599_g17460_i0	PRJNA1156092	17590	280	1.468599	4.1120772	Mortierellaceae	4854	Fungi	Fungi	171	4.95e-50	NR	KAI8605869.1	979620	g17460	i0	77.4	36.8678571428571	93	21	99.6	0	2	280	152	244	KAI8605869.1 Metallo-dependent phosphatase [Dissophora ornata]	diamond	10323	171	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Dissophora	Dissophora ornata
14331819	14331819	PRJNA1156092_P_NODE_23932_length_249_cov_0.875000_g23802_i0	PRJNA1156092	23932	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	135	7.48e-35	NR	RHZ75948.1	1348612	g23802	i0	76.8	31.9759036144578	82	19	98.8	0	1	246	326	407	RHZ75948.1 hypothetical protein Glove_208g114 [Diversispora epigaea]	diamond	7962	136	0.992647058823529	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora epigaea
26945247	26945247	PRJNA1156092_P_NODE_28242_length_245_cov_0.895349_g28112_i0	PRJNA1156092	28242	245	0.895349	2.19360505	Rhizopus microsporus	58291	Fungi	Fungi	70.1	8.96e-13	NR	ORE12437.1	58291	g28112	i0	44.3	2.86530612244898	79	44	96.7	0	239	3	35	113	ORE12437.1 ribosomal protein S5 domain 2-like protein [Rhizopus microsporus]	diamond	702	70.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
27893034	27893034	PRJNA1156092_P_NODE_18545_length_273_cov_1.540000_g18415_i0	PRJNA1156092	18545	273	1.54	4.2042	Glomus cerebriforme	658196	Fungi	Fungi	50.8	7.45e-5	NR	RIA96026.1	658196	g18415	i0	41.1	2.59340659340659	56	33	61.5	0	4	171	10	65	RIA96026.1 hypothetical protein C1645_435849 [Glomus cerebriforme]	diamond	708	50.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Glomus	Glomus cerebriforme
28544263	28544263	PRJNA1156092_P_NODE_27127_length_246_cov_0.890173_g26997_i0	PRJNA1156092	27127	246	0.890173	2.18982558	Mortierellaceae	4854	Fungi	Fungi	111	2.31e-26	NR	KAF9932112.1	979765	g26997	i0	61	9.97560975609756	82	32	100	0	246	1	612	693	KAF9932112.1 hypothetical protein FBU30_008926 [Linnemannia zychae]	diamond	2454	112	0.991071428571429	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Linnemannia	Linnemannia zychae
29396534	29396534	PRJNA1156092_P_NODE_27409_length_246_cov_0.890173_g27279_i0	PRJNA1156092	27409	246	0.890173	2.18982558	Mortierellaceae	4854	Fungi	Fungi	76.6	4.67e-14	NR	KAF9913233.1	64571	g27279	i0	49.3	4.95121951219512	67	34	81.7	0	1	201	632	698	KAF9913233.1 hypothetical protein BX616_010125 [Lobosporangium transversale]	diamond	1218	76.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
30988289	30988289	PRJNA1156092_P_NODE_1934_length_699_cov_2.797125_g1810_i0	PRJNA1156092	1934	699	2.797125	19.55190375	Apophysomyces ossiformis	679940	Fungi	Fungi	58.5	4.99e-6	NR	KAF7728641.1	679940	g1810	i0	37.5	0.274678111587983	64	40	27.5	0	606	415	3	66	KAF7728641.1 hypothetical protein EC973_005678 [Apophysomyces ossiformis]	diamond	192	58.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Apophysomyces	Apophysomyces ossiformis
31987828	31987828	PRJNA1156092_P_NODE_2318_length_644_cov_1.907180_g2192_i0	PRJNA1156092	2318	644	1.90718	12.2822392	Rhizophagus	295919	Fungi	Fungi	53.9	1.29e-4	NR	PKK68977.1	588596	g2192	i0	37.7	0.722049689440994	77	45	34.9	3	384	608	91	166	PKK68977.1 hypothetical protein RhiirC2_781571 [Rhizophagus irregularis]	diamond	465	54.3	0.992633517495396	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis

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