metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA966993" 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
942117	942117	PRJNA966993_P_NODE_42961_length_329_cov_1.726562_g42509_i0	PRJNA966993	42961	329	1.726562	5.68038898	Phycomyces blakesleeanus	4837	Fungi	Fungi	191	6.29e-44	NTclustered	gi\|1069938230\|ref\|XM_018429293.1\|	763407	g42509	i0	82.143	30.2613981762918	224	38	68	2	11	233	3293	3071	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	9956	191	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
942153	942153	PRJNA966993_P_NODE_46641_length_316_cov_2.127572_g46189_i0	PRJNA966993	46641	316	2.127572	6.72312752	Cokeromyces recurvatus	90255	Fungi	Fungi	226	1.65e-54	NTclustered	gi\|2324044167\|ref\|XM_051525007.1\|	90255	g46189	i0	81.588	49.5253164556962	277	47	87	4	5	279	84	358	Cokeromyces recurvatus ras-like protein 1 (BX663DRAFT_491090), mRNA	blastn	15650	226	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
2217638	2217638	PRJNA966993_P_NODE_59642_length_285_cov_1.816038_g59190_i0	PRJNA966993	59642	285	1.816038	5.1757083	Umbelopsis ramanniana	41833	Fungi	Fungi	97.1	1.2e-15	NTclustered	gi\|2323681239\|ref\|XM_051586146.1\|	1314678	g59190	i0	92.537	8.79649122807018	67	5	24	0	49	115	235	169	Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_224025), mRNA	blastn	2507	97.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
3493168	3493168	PRJNA966993_P_NODE_79183_length_255_cov_2.769231_g78731_i0	PRJNA966993	79183	255	2.769231	7.06153905	Rhizophagus irregularis	588596	Fungi	Fungi	73.1	1.78e-8	NTclustered	gi\|2749819622\|ref\|XM_066137500.1\|	588596	g78731	i0	86.364	0.517647058823529	66	9	26	0	177	242	1188	1253	Rhizophagus irregularis uncharacterized protein (OCT59_017460), partial mRNA	blastn	132	73.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
6369750	6369750	PRJNA966993_P_NODE_61665_length_282_cov_1.875598_g61213_i0	PRJNA966993	61665	282	1.875598	5.28918636	Mucorales	4827	Fungi	Fungi	521	1.6499999999999996e-143	NTclustered	gi\|2083274847\|gb\|MZ841800.1\|	29923	g61213	i0	100	99.9858156028369	282	0	100	0	1	282	683	402	Amylomyces rouxii isolate SMD large subunit ribosomal RNA gene, partial sequence	blastn	28196	521	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Amylomyces	Amylomyces rouxii
7320260	7320260	PRJNA966993_P_NODE_46086_length_318_cov_1.885714_g45634_i0	PRJNA966993	46086	318	1.885714	5.99657052	Halteromyces radiatus	101107	Fungi	Fungi	172	2.19e-38	NTclustered	gi\|2323726009\|ref\|XM_051544872.1\|	101107	g45634	i0	77.551	7.08176100628931	294	60	92	5	20	310	73	363	Halteromyces radiatus 40S ribosomal protein S13 (BX664DRAFT_329830), mRNA	blastn	2252	172	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
12421052	12421052	PRJNA966993_P_NODE_19050_length_480_cov_2.088452_g18605_i0	PRJNA966993	19050	480	2.088452	10.0245696	Calcarisporiella thermophila	911321	Fungi	Fungi	305	3.25e-78	NTclustered	gi\|2837851210\|ref\|XM_069391808.1\|	911321	g18605	i0	79.06	96.0770833333333	468	80	96	14	20	478	37	495	Calcarisporiella thermophila uncharacterized protein (VTP21DRAFT_1693), partial mRNA	blastn	46117	305	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
12421516	12421516	PRJNA966993_P_NODE_71170_length_268_cov_2.148718_g70718_i0	PRJNA966993	71170	268	2.148718	5.75856424	Gilbertella persicaria	101096	Fungi	Fungi	58.4	5.27e-4	NTclustered	gi\|2323725371\|ref\|XM_051576959.1\|	101096	g70718	i0	92.5	4.00746268656716	40	3	15	0	130	169	466	427	Gilbertella persicaria uncharacterized protein (B0P05DRAFT_531364), mRNA	blastn	1074	58.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
12744936	12744936	PRJNA966993_P_NODE_83270_length_251_cov_0.865169_g82818_i0	PRJNA966993	83270	251	0.865169	2.17157419	Fungi	4751	Fungi	Fungi	222	1.64e-53	NTclustered	gi\|2323750355\|ref\|XM_051541640.1\|	101107	g82818	i0	83.761	81.0996015936255	234	38	93	0	1	234	657	424	Halteromyces radiatus ATP synthase subunit beta (BX664DRAFT_284604), mRNA	blastn	20356	224	0.991071428571429	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
15293515	15293515	PRJNA966993_P_NODE_24712_length_423_cov_3.377143_g24265_i0	PRJNA966993	24712	423	3.377143	14.28531489	Mucorales	4827	Fungi	Fungi	303	1.02e-77	NTclustered	gi\|2324070387\|ref\|XM_051603187.1\|	29922	g24265	i0	81.383	84.5791962174941	376	66	88	4	50	423	176	549	Mucor mucedo ADP-ribosylation factor (EV154DRAFT_524307), mRNA	blastn	35777	303	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor mucedo
15293603	15293603	PRJNA966993_P_NODE_6052_length_841_cov_4.289062_g5682_i0	PRJNA966993	6052	841	4.289062	36.07101142	Opisthokonta	33154	Fungi	Fungi	422	5.599999999999999e-113	NTclustered	gi\|2749821332\|ref\|XM_025314831.2\|	588596	g5682	i0	84.296	45.9334126040428	433	66	51	2	285	716	647	216	Rhizophagus irregularis uncharacterized protein (OCT59_018453), mRNA	blastn	38630	425	0.992941176470588	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
20068576	20068576	PRJNA966993_P_NODE_100776_length_232_cov_2.691824_g100324_i0	PRJNA966993	100776	232	2.691824	6.24503168	Gamsiella multidivaricata	101098	Fungi	Fungi	54.7	0.006	NTclustered	gi\|2323776307\|ref\|XM_051555072.1\|	101098	g100324	i0	100	0.969827586206897	29	0	13	0	152	180	4585	4557	Gamsiella multidivaricata Fanconi anaemia protein FANCD2 (BC939DRAFT_447284), mRNA	blastn	225	54.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
20068740	20068740	PRJNA966993_P_NODE_32876_length_372_cov_1.478261_g32424_i0	PRJNA966993	32876	372	1.478261	5.49913092	Lichtheimia ornata	688661	Fungi	Fungi	95.3	5.8e-15	NTclustered	gi\|2553548665\|ref\|XM_058480136.1\|	688661	g32424	i0	79.021	17.4784946236559	143	26	38	4	21	161	1	141	Lichtheimia ornata 60S ribosomal protein L29 (O0I10_000020), partial mRNA	blastn	6502	95.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata
21344120	21344120	PRJNA966993_P_NODE_25257_length_419_cov_2.716763_g24810_i0	PRJNA966993	25257	419	2.716763	11.38323697	Halteromyces radiatus	101107	Fungi	Fungi	161	6.419999999999999e-35	NTclustered	gi\|2323714695\|ref\|XM_051541296.1\|	101107	g24810	i0	89.147	7.68496420047733	129	14	31	0	230	358	241	113	Halteromyces radiatus zinc-binding ribosomal protein (BX664DRAFT_275648), mRNA	blastn	3220	161	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
21667981	21667981	PRJNA966993_P_NODE_69897_length_270_cov_1.934010_g69445_i0	PRJNA966993	69897	270	1.93401	5.221827	Opisthokonta	33154	Fungi	Fungi	207	4.99e-49	NTclustered	gi\|2323759064\|ref\|XM_051547197.1\|	101107	g69445	i0	83.871	12.0962962962963	217	35	80	0	50	266	533	317	Halteromyces radiatus ATP synthase subunit alpha (BX664DRAFT_342678), mRNA	blastn	3266	209	0.990430622009569	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
22619006	22619006	PRJNA966993_P_NODE_12158_length_603_cov_1.439623_g11729_i0	PRJNA966993	12158	603	1.439623	8.68092669	Mucor mucedo	29922	Fungi	Fungi	87.9	1.64e-12	NTclustered	gi\|2324056387\|ref\|XM_051601936.1\|	29922	g11729	i0	88.732	0.235489220563847	71	8	12	0	355	425	219	289	Mucor mucedo histone H2A (EV154DRAFT_512598), mRNA	blastn	142	87.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor mucedo
22619015	22619015	PRJNA966993_P_NODE_13938_length_562_cov_2.593047_g13504_i0	PRJNA966993	13938	562	2.593047	14.57292414	Halteromyces radiatus	101107	Fungi	Fungi	56.5	0.004	NTclustered	gi\|2323747804\|ref\|XM_051546396.1\|	101107	g13504	i0	96.97	0.0587188612099644	33	1	6	0	371	403	1321	1289	Halteromyces radiatus uncharacterized protein (BX664DRAFT_338236), mRNA	blastn	33	56.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
25168027	25168027	PRJNA966993_P_NODE_10660_length_642_cov_16.899824_g10234_i0	PRJNA966993	10660	642	16.899824	108.49687008	Gamsiella multidivaricata	101098	Fungi	Fungi	89.8	4.86e-13	NTclustered	gi\|2323800078\|ref\|XM_051557224.1\|	101098	g10234	i0	96.364	1.22118380062305	55	1	8	1	99	152	58	112	Gamsiella multidivaricata ribosomal protein S25 (BC939DRAFT_463398), partial mRNA	blastn	784	89.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
25492134	25492134	PRJNA966993_P_NODE_67780_length_273_cov_2.105000_g67328_i0	PRJNA966993	67780	273	2.105	5.74665	Rhizophagus	295919	Fungi	Fungi	52.8	0.025	NTclustered	gi\|256542349\|gb\|AC237369.1\|	4876	g67328	i0	100	0.216117216117216	28	0	10	0	63	90	30279	30306	Rhizophagus intraradices clone JGIBTPH-69C21, complete sequence	blastn	59	52.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus intraradices

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