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

9 rows where analysis = "blastn", bioproject = "PRJNA1218816" 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
333530	333530	PRJNA1218816_P_NODE_61721_length_242_cov_0.911243_g61288_i0	PRJNA1218816	61721	242	0.911243	2.20520806	Gilbertella persicaria	101096	Fungi	Fungi	178	3.45e-40	NTclustered	gi\|2323767922\|ref\|XM_051573586.1\|	101096	g61288	i0	80.083	7.95867768595041	241	46	99	2	3	242	921	682	Gilbertella persicaria guanine nucleotide-binding protein subunit beta-2-like 1 (B0P05DRAFT_343640), mRNA	blastn	1926	178	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
1608265	1608265	PRJNA1218816_P_NODE_60922_length_243_cov_0.905882_g60489_i0	PRJNA1218816	60922	243	0.905882	2.20129326	uncultured Acaulospora	254030	Fungi	Fungi	311	3.27e-80	NTclustered	gi\|583967819\|gb\|KF849526.1\|	254030	g60489	i0	90.417	91.7448559670782	240	18	98	4	2	238	1090	853	Uncultured Acaulospora clone AM46 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	22294	311	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae		uncultured Acaulospora
3596754	3596754	PRJNA1218816_P_NODE_23883_length_432_cov_4.484680_g23450_i0	PRJNA1218816	23883	432	4.48468	19.3738176	Mucorales	4827	Fungi	Fungi	305	2.9e-78	NTclustered	gi\|2324070387\|ref\|XM_051603187.1\|	29922	g23450	i0	81.501	69.75	373	67	86	2	61	432	680	309	Mucor mucedo ADP-ribosylation factor (EV154DRAFT_524307), mRNA	blastn	30132	305	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor mucedo
3596793	3596793	PRJNA1218816_P_NODE_54323_length_250_cov_10.892655_g53890_i0	PRJNA1218816	54323	250	10.892655	27.2316375	Fungi	4751	Fungi	Fungi	457	4.1099999999999985e-124	NTclustered	gi\|658131632\|emb\|HF968958.1\|	4874	g53890	i0	99.6	147.856	250	1	100	0	1	250	2239	1990	Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26	blastn	36964	457	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
6711360	6711360	PRJNA1218816_P_NODE_63006_length_241_cov_0.916667_g62573_i0	PRJNA1218816	63006	241	0.916667	2.20916747	Cokeromyces recurvatus	90255	Fungi	Fungi	171	5.74e-38	NTclustered	gi\|2324087667\|ref\|XM_051530092.1\|	90255	g62573	i0	81.081	14.448132780083	222	35	91	7	21	239	193	410	Cokeromyces recurvatus putative ribosomal protein L10 (BX663DRAFT_527823), partial mRNA	blastn	3482	171	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
7424166	7424166	PRJNA1218816_P_NODE_43486_length_289_cov_3.597222_g43053_i0	PRJNA1218816	43486	289	3.597222	10.39597158	Glomeraceae	36751	Fungi	Fungi	252	2.46e-62	NTclustered	gi\|121488322\|emb\|AJ854574.1\|	4876	g43053	i0	93.976	57.439446366782	166	10	57	0	124	289	872	1037	Glomus intraradices 28S rRNA gene, strain MUCL 43194, clone 1	blastn	16600	252	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus intraradices
18184843	18184843	PRJNA1218816_P_NODE_29535_length_372_cov_1.401338_g29102_i0	PRJNA1218816	29535	372	1.401338	5.21297736	Rhizopus delemar	936053	Fungi	Fungi	196	1.54e-45	NTclustered	gi\|2797411137\|ref\|XM_067656165.1\|	246409	g29102	i0	78.205	18.5510752688172	312	64	83	4	47	356	35	344	Rhizopus delemar RA 99-880 50S ribosomal protein L22 (RO3G_01574), partial mRNA	blastn	6901	196	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
18185142	18185142	PRJNA1218816_P_NODE_62315_length_241_cov_2.011905_g61882_i0	PRJNA1218816	62315	241	2.011905	4.84869105	Rhizopus microsporus	58291	Fungi	Fungi	132	2.7100000000000004e-26	NTclustered	gi\|1331188077\|ref\|XM_023606091.1\|	1340429	g61882	i0	79.679	0.775933609958506	187	34	77	4	7	191	223	39	Rhizopus microsporus ATCC 52813 putative 60S ribosomal protein L30 (RHIMIDRAFT_196053), partial mRNA	blastn	187	132	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
19459337	19459337	PRJNA1218816_P_NODE_35296_length_331_cov_0.887597_g34863_i0	PRJNA1218816	35296	331	0.887597	2.93794607	Rhizopus delemar	936053	Fungi	Fungi	207	6.29e-49	NTclustered	gi\|2797473748\|ref\|XM_067666040.1\|	246409	g34863	i0	78.313	9.1238670694864	332	65	99	6	1	330	637	311	Rhizopus delemar RA 99-880 60S ribosomal protein uL2 (RO3G_11456), partial mRNA	blastn	3020	207	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar

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