metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJEB75017" and tax

12 rows where analysis = "blastn", bioproject = "PRJEB75017" 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
1410005	1410005	PRJEB75017_P_NODE_9362_length_296_cov_1.748879_g9233_i0	PRJEB75017	9362	296	1.748879	5.17668184	Lichtheimia ornata	688661	Fungi	Fungi	171	7.2699999999999995e-38	NTclustered	gi\|2553572607\|ref\|XM_058485260.1\|	688661	g9233	i0	82.412	8.31418918918919	199	31	67	3	80	276	1	197	Lichtheimia ornata cell division control protein 42 (O0I10_005213), partial mRNA	blastn	2461	171	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata
3961504	3961504	PRJEB75017_P_NODE_3744_length_452_cov_1.825858_g3615_i0	PRJEB75017	3744	452	1.825858	8.25287816	Cokeromyces recurvatus	90255	Fungi	Fungi	339	3e-88	NTclustered	gi\|2324081571\|ref\|XM_051528701.1\|	90255	g3615	i0	81.598	92.358407079646	413	72	91	4	1	411	893	1303	Cokeromyces recurvatus ATP synthase subunit beta (BX663DRAFT_517252), mRNA	blastn	41746	339	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
9923591	9923591	PRJEB75017_P_NODE_15208_length_250_cov_0.881356_g15079_i0	PRJEB75017	15208	250	0.881356	2.20339	Mucorales	4827	Fungi	Fungi	198	2.75e-46	NTclustered	gi\|2323732780\|ref\|XM_051582483.1\|	101096	g15079	i0	81.102	97.992	254	43	100	5	1	250	257	5	Gilbertella persicaria histone H3 (B0P05DRAFT_586039), partial mRNA	blastn	24498	198	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
10338402	10338402	PRJEB75017_P_NODE_17509_length_244_cov_0.912281_g17380_i0	PRJEB75017	17509	244	0.912281	2.22596564	Gilbertella persicaria	101096	Fungi	Fungi	169	2.09e-37	NTclustered	gi\|2323723727\|ref\|XM_051576835.1\|	101096	g17380	i0	85.714	9.23360655737705	161	21	66	2	43	202	531	372	Gilbertella persicaria V-type proton ATPase proteolipid subunit (B0P05DRAFT_530185), mRNA	blastn	2253	169	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
14163720	14163720	PRJEB75017_P_NODE_12752_length_262_cov_1.238095_g12623_i0	PRJEB75017	12752	262	1.238095	3.2438089	Lobosporangium transversale	64571	Fungi	Fungi	187	6.279999999999998e-43	NTclustered	gi\|1227133910\|ref\|XM_022023341.1\|	64571	g12623	i0	81.172	34.5648854961832	239	39	90	6	1	236	305	540	Lobosporangium transversale Serine/threonine-protein phosphatase ppe1 (BCR41DRAFT_348683), mRNA	blastn	9056	187	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
14163835	14163835	PRJEB75017_P_NODE_9912_length_290_cov_1.161290_g9783_i0	PRJEB75017	9912	290	1.16129	3.367741	Umbelopsis ramanniana	41833	Fungi	Fungi	54.7	0.007	NTclustered	gi\|2323696651\|ref\|XM_051591815.1\|	1314678	g9783	i0	100	0.1	29	0	10	0	34	62	1428	1400	Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_258283), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
15437909	15437909	PRJEB75017_P_NODE_8973_length_301_cov_15.057018_g8844_i0	PRJEB75017	8973	301	15.057018	45.32162418	Halteromyces radiatus	101107	Fungi	Fungi	298	3.26e-76	NTclustered	gi\|2323719496\|ref\|XM_051549776.1\|	101107	g8844	i0	84.768	418.916943521595	302	40	99	6	3	301	958	660	Halteromyces radiatus uncharacterized protein (BX664DRAFT_88022), mRNA	blastn	126094	298	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
16298234	16298234	PRJEB75017_P_NODE_73_length_2195_cov_3.470311_g53_i0	PRJEB75017	73	2195	3.470311	76.17332645	Mucorales	4827	Fungi	Fungi	1242	0	NTclustered	gi\|2323721132\|ref\|XM_051575490.1\|	101096	g53	i0	80.541	66.6205011389522	1665	283	75	34	533	2181	1834	195	Gilbertella persicaria 70 kDa heat shock protein 3 (B0P05DRAFT_504449), mRNA	blastn	146232	1253	0.99122106943336	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
20122092	20122092	PRJEB75017_P_NODE_6536_length_347_cov_1.069343_g6407_i0	PRJEB75017	6536	347	1.069343	3.71062021	Fungi	4751	Fungi	Fungi	158	6.77e-34	NTclustered	gi\|82398547\|gb\|DQ273811.1\|	4872	g6407	i0	84.906	68.4063400576369	159	20	46	4	173	331	1658	1504	Endogone pisiformis isolate AFTOL-ID 539 28S ribosomal RNA gene, partial sequence	blastn	23737	158	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales	Endogonaceae	Endogone	Endogone pisiformis
23087113	23087113	PRJEB75017_P_NODE_12859_length_261_cov_1.250000_g12730_i0	PRJEB75017	12859	261	1.25	3.2625	Mucor velutinosus	708070	Fungi	Fungi	58.4	5.12e-4	NTclustered	gi\|2724894529\|ref\|XM_064827581.1\|	708070	g12730	i0	97.059	0.498084291187739	34	1	13	0	1	34	2744	2777	Mucor velutinosus uncharacterized protein (ATC70_008330), partial mRNA	blastn	130	58.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor velutinosus
23087178	23087178	PRJEB75017_P_NODE_3159_length_492_cov_6.169451_g3030_i0	PRJEB75017	3159	492	6.169451	30.35369892	Rhizopus delemar	936053	Fungi	Fungi	267	1.5799999999999998e-66	NTclustered	gi\|2797444561\|ref\|XM_067660141.1\|	246409	g3030	i0	79.442	77.6747967479675	394	67	79	11	90	476	387	1	Rhizopus delemar RA 99-880 ubiquitin-60S ribosomal protein L40 (RO3G_05551), partial mRNA	blastn	38216	267	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
25221727	25221727	PRJEB75017_P_NODE_4740_length_403_cov_2.603030_g4611_i0	PRJEB75017	4740	403	2.60303	10.4902109	Mucoromycota	1913637	Fungi	Fungi	259	2.12e-64	NTclustered	gi\|2324053211\|ref\|XM_051597037.1\|	29922	g4611	i0	79.722	88.9454094292804	360	71	89	2	1	359	529	171	Mucor mucedo GTP-binding nuclear protein GSP1/Ran (EV154DRAFT_443869), mRNA	blastn	35845	259	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor mucedo

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