metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1068513" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1068513" and tax_clade = "Discoba"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
181870	181870	PRJNA1068513_S_NODE_11721_length_257_cov_1.271739_g11675_i0	PRJNA1068513	11721	257	1.271739	3.26836923	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	383	7.299999999999998e-102	NTclustered	gi\|290975096\|ref\|XM_002670234.1\|	5762	g11675	i0	93.725	8.29182879377432	255	16	99	0	3	257	289	543	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_81906), mRNA	blastn	2131	383	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
181874	181874	PRJNA1068513_S_NODE_12161_length_252_cov_1.016760_g12115_i0	PRJNA1068513	12161	252	1.01676	2.5622352	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	424	4.2e-114	NTclustered	gi\|290983374\|ref\|XM_002674358.1\|	5762	g12115	i0	98.34	3.61111111111111	241	4	96	0	1	241	604	844	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82706), mRNA	blastn	910	424	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
181878	181878	PRJNA1068513_S_NODE_12301_length_251_cov_0.876404_g12255_i0	PRJNA1068513	12301	251	0.876404	2.19977404	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	252	2.09e-62	NTclustered	gi\|290985340\|ref\|XM_002675338.1\|	5762	g12255	i0	93.491	5.21115537848606	169	11	67	0	73	241	358	526	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82670), mRNA	blastn	1308	252	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
2732469	2732469	PRJNA1068513_S_NODE_8483_length_311_cov_0.983193_g8437_i0	PRJNA1068513	8483	311	0.983193	3.05773023	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	435	2.47e-117	NTclustered	gi\|290987322\|ref\|XM_002676326.1\|	5762	g8437	i0	96.578	0.845659163987138	263	8	85	1	49	311	379	118	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_36914), mRNA	blastn	263	435	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
2732471	2732471	PRJNA1068513_S_NODE_8583_length_309_cov_0.991525_g8537_i0	PRJNA1068513	8583	309	0.991525	3.06381225	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	472	1.87e-128	NTclustered	gi\|290987797\|ref\|XM_002676563.1\|	5762	g8537	i0	95.608	3.50485436893204	296	10	95	3	11	305	662	369	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_83175), mRNA	blastn	1083	472	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
6559723	6559723	PRJNA1068513_S_NODE_13006_length_245_cov_1.191860_g12960_i0	PRJNA1068513	13006	245	1.19186	2.920057	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	121	5.98e-23	NTclustered	gi\|290981079\|ref\|XM_002673213.1\|	5762	g12960	i0	91.954	1.04897959183673	87	6	36	1	159	245	11	96	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82738), mRNA	blastn	257	121	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
6559818	6559818	PRJNA1068513_S_NODE_8386_length_313_cov_1.666667_g8340_i0	PRJNA1068513	8386	313	1.666667	5.21666771	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	479	1.1299999999999996e-130	NTclustered	gi\|290995181\|ref\|XM_002680150.1\|	5762	g8340	i0	96.864	11.7731629392971	287	8	91	1	28	313	846	560	Naegleria gruberi 60S ribosomal protein L2 (NAEGRDRAFT_35785), mRNA	blastn	3685	479	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
7834469	7834469	PRJNA1068513_S_NODE_9867_length_285_cov_2.471698_g9821_i0	PRJNA1068513	9867	285	2.471698	7.0443393	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	425	1.35e-114	NTclustered	gi\|290985904\|ref\|XM_002675619.1\|	5762	g9821	i0	96.154	0.912280701754386	260	10	91	0	1	260	192	451	Naegleria gruberi ribosomal protein S13 (NAEGRDRAFT_82651), mRNA	blastn	260	425	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
9109365	9109365	PRJNA1068513_S_NODE_12408_length_250_cov_0.949153_g12362_i0	PRJNA1068513	12408	250	0.949153	2.3728825	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	289	1.59e-73	NTclustered	gi\|290975667\|ref\|XM_002670518.1\|	5762	g12362	i0	91.204	2.452	216	13	84	4	41	250	446	231	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_59665), mRNA	blastn	613	289	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
9109459	9109459	PRJNA1068513_S_NODE_8128_length_318_cov_1.783673_g8082_i0	PRJNA1068513	8128	318	1.783673	5.67208014	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	490	5.33e-134	NTclustered	gi\|290990436\|ref\|XM_002677797.1\|	5762	g8082	i0	95.161	46.7327044025157	310	15	97	0	2	311	303	612	Naegleria gruberi ribosomal protein S7 (NAEGRDRAFT_39045), mRNA	blastn	14861	490	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
12935569	12935569	PRJNA1068513_S_NODE_12511_length_249_cov_1.272727_g12465_i0	PRJNA1068513	12511	249	1.272727	3.16909023	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	390	4.2e-104	NTclustered	gi\|290995331\|ref\|XM_002680203.1\|	5762	g12465	i0	95.142	0.991967871485944	247	12	99	0	1	247	404	158	Naegleria gruberi 60S ribosomal protein L21 (NAEGRDRAFT_78822), mRNA	blastn	247	390	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
12935577	12935577	PRJNA1068513_S_NODE_13291_length_242_cov_2.094675_g13245_i0	PRJNA1068513	13291	242	2.094675	5.0691135	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	220	5.65e-53	NTclustered	gi\|290973118\|ref\|XM_002669251.1\|	5762	g13245	i0	87.065	0.830578512396694	201	18	81	7	1	197	285	481	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82208), mRNA	blastn	201	220	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
15041320	15041320	PRJNA1068513_S_NODE_8612_length_308_cov_2.289362_g8566_i0	PRJNA1068513	8612	308	2.289362	7.05123496	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	71.3	7.94e-8	NTclustered	gi\|2593249679\|emb\|OY748418.1\|	5660	g8566	i0	88.136	1.29545454545455	59	7	19	0	104	162	818968	818910	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 24	blastn	399	71.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
15484528	15484528	PRJNA1068513_S_NODE_12513_length_249_cov_1.261364_g12467_i0	PRJNA1068513	12513	249	1.261364	3.14079636	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	283	7.339999999999999e-72	NTclustered	gi\|290986860\|ref\|XM_002676096.1\|	5762	g12467	i0	98.148	0.763052208835341	162	3	65	0	1	162	217	378	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_34422), partial mRNA	blastn	190	283	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
15484648	15484648	PRJNA1068513_S_NODE_9293_length_296_cov_1.049327_g9247_i0	PRJNA1068513	9293	296	1.049327	3.10600792	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	435	2.34e-117	NTclustered	gi\|290997451\|ref\|XM_002681249.1\|	5762	g9247	i0	93.22	1.9527027027027	295	20	99	0	2	296	526	232	Naegleria gruberi S-phase kinase-associated protein (NAEGRDRAFT_82963), mRNA	blastn	578	435	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
16758745	16758745	PRJNA1068513_S_NODE_13254_length_243_cov_0.917647_g13208_i0	PRJNA1068513	13254	243	0.917647	2.22988221	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	399	6.789999999999999e-107	NTclustered	gi\|290988743\|ref\|XM_002677007.1\|	5762	g13208	i0	96.296	1	243	9	100	0	1	243	468	226	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_36778), mRNA	blastn	243	399	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
18033541	18033541	PRJNA1068513_S_NODE_11175_length_265_cov_1.265625_g11129_i0	PRJNA1068513	11175	265	1.265625	3.35390625	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	348	2.76e-91	NTclustered	gi\|290981067\|ref\|XM_002673207.1\|	5762	g11129	i0	93.939	1.08301886792453	231	13	87	1	1	230	172	402	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_80999), mRNA	blastn	287	348	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
18865144	18865144	PRJNA1068513_S_NODE_11715_length_257_cov_1.429348_g11669_i0	PRJNA1068513	11715	257	1.429348	3.67342436	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	139	1.74e-28	NTclustered	gi\|290979566\|ref\|XM_002672459.1\|	5762	g11669	i0	91.176	12.5214007782101	102	9	40	0	97	198	1326	1225	Naegleria gruberi beta-tubulin (NAEGRDRAFT_55423), mRNA	blastn	3218	139	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
20582968	20582968	PRJNA1068513_S_NODE_12197_length_252_cov_0.871508_g12151_i0	PRJNA1068513	12197	252	0.871508	2.19620016	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	331	2.62e-86	NTclustered	gi\|290989763\|ref\|XM_002677461.1\|	5762	g12151	i0	95.631	1.07539682539683	206	9	82	0	45	250	499	294	Naegleria gruberi 40S ribosomal protein S10 (NAEGRDRAFT_39066), mRNA	blastn	271	331	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
24407698	24407698	PRJNA1068513_S_NODE_12280_length_251_cov_1.308989_g12234_i0	PRJNA1068513	12280	251	1.308989	3.28556239	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	370	5.53e-98	NTclustered	gi\|290987781\|ref\|XM_002676555.1\|	5762	g12234	i0	93.227	3.00796812749004	251	17	100	0	1	251	59	309	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_58185), mRNA	blastn	755	370	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi

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