metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA867519" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA867519" and tax_phylum = "Zoopagomycota"

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
848120	848120	PRJNA867519_P_NODE_2641_length_625_cov_12.536232_g2491_i0	PRJNA867519	2641	625	12.536232	78.35145	Linderina pennispora	61395	Fungi	Fungi	472	4.02e-128	NTclustered	gi\|2028317716\|ref\|XM_040889713.1\|	61395	g2491	i0	86.543	65.8336	431	54	69	3	20	448	86	514	Linderina pennispora 40S ribosomal protein S23 (DL89DRAFT_282888), partial mRNA	blastn	41146	472	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
848194	848194	PRJNA867519_P_NODE_5201_length_473_cov_1.840000_g5047_i0	PRJNA867519	5201	473	1.84	8.7032	Kickxella alabastrina	61397	Fungi	Fungi	294	6.92e-75	NTclustered	gi\|2324017890\|ref\|XM_051536612.1\|	61397	g5047	i0	86.081	83.8350951374207	273	38	58	0	129	401	991	1263	Kickxella alabastrina ribosomal protein L3-domain-containing protein (BX661DRAFT_184853), mRNA	blastn	39654	294	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
848208	848208	PRJNA867519_P_NODE_641_length_1098_cov_6.483902_g537_i0	PRJNA867519	641	1098	6.483902	71.19324396	Linderina pennispora	61395	Fungi	Fungi	658	0	NTclustered	gi\|2028323302\|ref\|XM_040891225.1\|	61395	g537	i0	82.038	65.6311475409836	785	129	71	12	293	1070	907	128	Linderina pennispora WD40 repeat-like protein (DL89DRAFT_32066), mRNA	blastn	72063	658	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
2123385	2123385	PRJNA867519_P_NODE_1242_length_855_cov_8.615090_g1107_i0	PRJNA867519	1242	855	8.61509	73.6590195	Linderina pennispora	61395	Fungi	Fungi	466	2.5999999999999993e-126	NTclustered	gi\|2028311014\|ref\|XM_040889407.1\|	61395	g1107	i0	81.379	66.5590643274854	580	101	67	7	270	845	577	1	Linderina pennispora ribosomal protein S6e (DL89DRAFT_276961), partial mRNA	blastn	56908	466	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
3398796	3398796	PRJNA867519_P_NODE_16523_length_291_cov_2.811927_g16369_i0	PRJNA867519	16523	291	2.811927	8.18270757	Linderina pennispora	61395	Fungi	Fungi	132	3.37e-26	NTclustered	gi\|2028316108\|ref\|XM_040886815.1\|	61395	g16369	i0	83.448	6.72852233676976	145	20	49	4	12	154	319	461	Linderina pennispora ribosomal 60S subunit protein L29 (DL89DRAFT_265768), partial mRNA	blastn	1958	132	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
7226358	7226358	PRJNA867519_P_NODE_2706_length_619_cov_9.912088_g2556_i0	PRJNA867519	2706	619	9.912088	61.35582472	Linderina pennispora	61395	Fungi	Fungi	466	1.85e-126	NTclustered	gi\|2028320666\|ref\|XM_040889247.1\|	61395	g2556	i0	83.629	71.8400646203554	507	71	81	12	48	548	1	501	Linderina pennispora 60S ribosomal protein L11 (DL89DRAFT_274988), partial mRNA	blastn	44469	466	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
7226381	7226381	PRJNA867519_P_NODE_31466_length_244_cov_0.900585_g31312_i0	PRJNA867519	31466	244	0.900585	2.1974274	Linderina pennispora	61395	Fungi	Fungi	165	2.71e-36	NTclustered	gi\|2028324920\|ref\|XM_040888337.1\|	61395	g31312	i0	80.631	37.5901639344262	222	36	90	5	11	230	476	692	Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA	blastn	9172	165	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
7226412	7226412	PRJNA867519_P_NODE_4466_length_502_cov_12.995338_g4313_i0	PRJNA867519	4466	502	12.995338	65.23659676	Linderina pennispora	61395	Fungi	Fungi	268	4.479999999999999e-67	NTclustered	gi\|2028312080\|ref\|XM_040889418.1\|	61395	g4313	i0	79.733	60.2250996015936	375	72	74	4	76	448	412	40	Linderina pennispora uncharacterized protein (DL89DRAFT_277109), partial mRNA	blastn	30233	268	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
12327275	12327275	PRJNA867519_P_NODE_29490_length_246_cov_1.202312_g29336_i0	PRJNA867519	29490	246	1.202312	2.95768752	Linderina pennispora	61395	Fungi	Fungi	110	1.3e-19	NTclustered	gi\|2028314590\|ref\|XM_040891227.1\|	61395	g29336	i0	79.355	13.4837398373984	155	32	63	0	73	227	201	47	Linderina pennispora ribosomal 60S subunit protein L39 (DL89DRAFT_320715), partial mRNA	blastn	3317	110	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
13601699	13601699	PRJNA867519_P_NODE_1171_length_874_cov_5.415730_g1038_i0	PRJNA867519	1171	874	5.41573	47.3334802	Linderina pennispora	61395	Fungi	Fungi	647	0	NTclustered	gi\|2028314442\|ref\|XM_040889132.1\|	61395	g1038	i0	82.055	88.1453089244851	769	128	87	9	18	781	1	764	Linderina pennispora ribosomal protein S4e (DL89DRAFT_274030), partial mRNA	blastn	77039	647	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
14876077	14876077	PRJNA867519_P_NODE_21312_length_270_cov_1.274112_g21158_i0	PRJNA867519	21312	270	1.274112	3.4401024	Linderina pennispora	61395	Fungi	Fungi	161	3.94e-35	NTclustered	gi\|2028326528\|ref\|XM_040889865.1\|	61395	g21158	i0	80.976	66.2592592592593	205	37	76	2	5	208	967	1170	Linderina pennispora UTP--glucose-1-phosphate uridylyltransferase (DL89DRAFT_286366), partial mRNA	blastn	17890	161	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
17426255	17426255	PRJNA867519_P_NODE_16214_length_294_cov_1.334842_g16060_i0	PRJNA867519	16214	294	1.334842	3.92443548	Linderina pennispora	61395	Fungi	Fungi	346	1.12e-90	NTclustered	gi\|2028320758\|ref\|XM_040890372.1\|	61395	g16060	i0	88.136	91.7006802721088	295	29	99	5	1	292	335	44	Linderina pennispora Mal s 6 allergen (DL89DRAFT_293224), partial mRNA	blastn	26960	346	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
18699433	18699433	PRJNA867519_P_NODE_2135_length_684_cov_11.299509_g1987_i0	PRJNA867519	2135	684	11.299509	77.28864156	Linderina pennispora	61395	Fungi	Fungi	560	9.17e-155	NTclustered	gi\|2028325604\|ref\|XM_040889545.1\|	61395	g1987	i0	85.252	73.5745614035088	556	69	80	8	50	594	15	568	Linderina pennispora 40S ribosomal protein S9 (DL89DRAFT_279070), partial mRNA	blastn	50325	560	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
18699528	18699528	PRJNA867519_P_NODE_34095_length_236_cov_3.073620_g33941_i0	PRJNA867519	34095	236	3.07362	7.2537432	Linderina pennispora	61395	Fungi	Fungi	156	1.57e-33	NTclustered	gi\|2028315762\|ref\|XM_040886762.1\|	61395	g33941	i0	82.162	26.1652542372881	185	29	78	3	2	184	792	974	Linderina pennispora ubiquitin-domain-containing protein (DL89DRAFT_265656), partial mRNA	blastn	6175	156	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
19974715	19974715	PRJNA867519_P_NODE_29656_length_246_cov_0.890173_g29502_i0	PRJNA867519	29656	246	0.890173	2.18982558	Kickxella alabastrina	61397	Fungi	Fungi	122	1.67e-23	NTclustered	gi\|2324019521\|ref\|XM_051537881.1\|	61397	g29502	i0	88.235	7.60162601626016	102	12	41	0	2	103	1132	1233	Kickxella alabastrina acyl-CoA dehydrogenase/oxidase (BX661DRAFT_194448), partial mRNA	blastn	1870	122	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
19974767	19974767	PRJNA867519_P_NODE_5136_length_475_cov_2.656716_g4982_i0	PRJNA867519	5136	475	2.656716	12.619401	Kickxella alabastrina	61397	Fungi	Fungi	246	1.9799999999999998e-60	NTclustered	gi\|2324005298\|ref\|XM_051534802.1\|	61397	g4982	i0	81.013	35.1473684210526	316	55	66	3	106	417	156	470	Kickxella alabastrina ribosomal protein S17-domain-containing protein (BX661DRAFT_178059), mRNA	blastn	16695	246	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
21250196	21250196	PRJNA867519_P_NODE_13897_length_314_cov_1.730290_g13743_i0	PRJNA867519	13897	314	1.73029	5.4331106	Linderina pennispora	61395	Fungi	Fungi	119	2.86e-22	NTclustered	gi\|2028323432\|ref\|XM_040888084.1\|	61395	g13743	i0	76.991	12.9426751592357	226	41	72	3	90	314	1035	820	Linderina pennispora 40S ribosomal protein S5 (DL89DRAFT_268926), mRNA	blastn	4064	119	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
21250215	21250215	PRJNA867519_P_NODE_1617_length_766_cov_6.953824_g1473_i0	PRJNA867519	1617	766	6.953824	53.26629184	Linderina pennispora	61395	Fungi	Fungi	564	7.98e-156	NTclustered	gi\|2028322926\|ref\|XM_040888010.1\|	61395	g1473	i0	85.876	71.5483028720627	531	73	69	2	16	545	392	921	Linderina pennispora 60S ribosomal protein L10-A (DL89DRAFT_268696), partial mRNA	blastn	54806	564	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
22524899	22524899	PRJNA867519_P_NODE_4318_length_509_cov_10.534404_g4165_i0	PRJNA867519	4318	509	10.534404	53.62011636	Linderina pennispora	61395	Fungi	Fungi	294	7.490000000000001e-75	NTclustered	gi\|2028316368\|ref\|XM_040886859.1\|	61395	g4165	i0	79.759	49.7583497053045	415	76	81	8	17	427	410	820	Linderina pennispora 60S ribosomal protein L27a (DL89DRAFT_265861), mRNA	blastn	25327	294	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
23800242	23800242	PRJNA867519_P_NODE_1059_length_909_cov_6.185407_g930_i0	PRJNA867519	1059	909	6.185407	56.22534963	Linderina pennispora	61395	Fungi	Fungi	686	0	NTclustered	gi\|2028312660\|ref\|XM_040889104.1\|	61395	g930	i0	83.696	74.3355335533553	736	110	80	9	145	875	752	22	Linderina pennispora uncharacterized protein (DL89DRAFT_273771), partial mRNA	blastn	67571	686	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
25074197	25074197	PRJNA867519_P_NODE_2360_length_653_cov_19.525862_g2211_i0	PRJNA867519	2360	653	19.525862	127.50387886	Linderina pennispora	61395	Fungi	Fungi	318	5.8e-82	NTclustered	gi\|2028316258\|ref\|XM_040883092.1\|	61395	g2211	i0	83.056	2.41960183767228	360	51	54	9	112	464	201	557	Linderina pennispora putative 40S ribosomal protein RPS20 (DL89DRAFT_110176), mRNA	blastn	1580	318	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora

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