metadata: contig_metadata: 64 rows where bioproject = "PRJNA1227535", tax_clade = "Opisthokonta" and tax

64 rows where bioproject = "PRJNA1227535", tax_clade = "Opisthokonta" and tax_phylum = "Arthropoda"

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
335143	335143	PRJNA1227535_P_NODE_12101_length_285_cov_1.471698_g11978_i0	PRJNA1227535	12101	285	1.471698	4.1943393	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	516	7.77e-142	NTclustered	gi\|239792999\|dbj\|AK342945.1\|	7029	g11978	i0	99.301	43.4175438596491	286	1	100	1	1	285	985	1270	Acyrthosiphon pisum mRNA, clone: 689M17, full-insert cDNA sequence based on the ESTs (5'-EST:FF337481, 3'-EST:FF339286)	blastn	12374	516	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
335250	335250	PRJNA1227535_P_NODE_19901_length_259_cov_1.392473_g19777_i0	PRJNA1227535	19901	259	1.392473	3.60650507	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	224	4.72e-54	NTclustered	gi\|146149421\|gb\|AC202214.3\|	7029	g19777	i0	87.192	11.8030888030888	203	19	78	5	1	202	99429	99625	Acyrthosiphon pisum BAC VMRC38-20-A9 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence	blastn	3057	224	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
335462	335462	PRJNA1227535_P_NODE_31941_length_235_cov_2.827160_g31817_i0	PRJNA1227535	31941	235	2.82716	6.643826	Drosophila serrata	7274	Arthropoda	Arthropoda	363	8.569999999999998e-96	NTclustered	gi\|2062575639\|gb\|MK659841.1\|	7274	g31817	i0	95.982	99.4808510638298	224	7	95	2	12	235	7641	7420	Drosophila serrata voucher DSERR20180902 mitochondrion, complete genome	blastn	23378	363	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila serrata
335557	335557	PRJNA1227535_P_NODE_8681_length_302_cov_2.921397_g8558_i0	PRJNA1227535	8681	302	2.921397	8.82261894	Pararge aegeria	116150	Arthropoda	Arthropoda	99	3.56e-16	NTclustered	gi\|635377229\|gb\|KJ547676.1\|	348720	g8558	i0	89.873	7.1125827814569504	79	5	25	3	163	238	9429	9351	Pararge aegeria aegeria mitochondrion, complete genome	blastn	2148	99	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Pararge	Pararge aegeria
1610101	1610101	PRJNA1227535_P_NODE_31662_length_237_cov_3.103659_g31538_i0	PRJNA1227535	31662	237	3.103659	7.35567183	Leiobunum subalpinum	3086104	Arthropoda	Arthropoda	52.8	0.021	NTclustered	gi\|2920020174\|emb\|OZ239119.1\|	3086104	g31538	i0	100	0.118143459915612	28	0	12	0	141	168	30056675	30056702	Leiobunum subalpinum genome assembly, chromosome: 2	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Opiliones	Sclerosomatidae	Leiobunum	Leiobunum subalpinum
2886277	2886277	PRJNA1227535_P_NODE_26643_length_247_cov_0.896552_g26519_i0	PRJNA1227535	26643	247	0.896552	2.21448344	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	272	1.5699999999999999e-68	NTclustered	gi\|161485019\|gb\|AC202217.9\|	7029	g26519	i0	95.833	0.870445344129555	168	7	68	0	1	168	145105	144938	Acyrthosiphon pisum BAC VMRC38-20-A6 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence	blastn	215	272	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
2886313	2886313	PRJNA1227535_P_NODE_28843_length_244_cov_1.578947_g28719_i0	PRJNA1227535	28843	244	1.578947	3.85263068	Oppiella nova	334625	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|1964830538\|emb\|OC917260.1\|	334625	g28719	i0	100	0.229508196721311	28	0	11	0	97	124	6566	6593	Oppiella nova	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
2886318	2886318	PRJNA1227535_P_NODE_29083_length_244_cov_0.912281_g28959_i0	PRJNA1227535	29083	244	0.912281	2.22596564	Galleria mellonella	7137	Arthropoda	Arthropoda	156	1.63e-33	NTclustered	gi\|1476366213\|gb\|MG846920.1\|	7137	g28959	i0	86.62	46.577868852459	142	17	58	2	2	142	506	646	Galleria mellonella heat shock protein 90 (HSP90) mRNA, complete cds	blastn	11365	156	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pyralidae	Galleria	Galleria mellonella
4162181	4162181	PRJNA1227535_P_NODE_14484_length_277_cov_1.303922_g14361_i0	PRJNA1227535	14484	277	1.303922	3.61186394	Psychoda alternata	114594	Arthropoda	Arthropoda	340	4.86e-89	NTclustered	gi\|2424876078\|ref\|NC_069157.1\|	114594	g14361	i0	88.849	90.6967509025271	278	29	100	2	1	277	8158	8434	Psychoda alternata mitochondrion, complete genome	blastn	25123	340	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Psychoda	Psychoda alternata
4162491	4162491	PRJNA1227535_P_NODE_33544_length_219_cov_3.136986_g33420_i0	PRJNA1227535	33544	219	3.136986	6.86999934	Penaeus vannamei	6689	Arthropoda	Arthropoda	377	2.81e-100	NTclustered	gi\|34604313\|gb\|AY382981.1\|	6689	g33420	i0	97.717	110.004566210046	219	5	100	0	1	219	363	145	Litopenaeus vannamei microsatellite TUMXLV8.125 sequence	blastn	24091	377	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
4162523	4162523	PRJNA1227535_P_NODE_5384_length_320_cov_3.429150_g5261_i0	PRJNA1227535	5384	320	3.42915	10.97328	Chironomidae sp. Cy2020 sp1	2766959	Arthropoda	Arthropoda	536	6.799999999999998e-148	NTclustered	gi\|1896444337\|gb\|MT921238.1\|	2766959	g5261	i0	96.875	92.671875	320	10	100	0	1	320	4	323	Chironomidae sp. Cy2020 sp1 voucher Chironomidae_Cy2020_sp1 large subunit ribosomal RNA gene, partial sequence	blastn	29655	536	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae		Chironomidae sp. Cy2020 sp1
5438447	5438447	PRJNA1227535_P_NODE_16825_length_269_cov_1.484694_g16702_i0	PRJNA1227535	16825	269	1.484694	3.99382686	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	424	4.53e-114	NTclustered	gi\|146149420\|gb\|AC202218.2\|	7029	g16702	i0	95.149	52.6059479553903	268	13	99	0	1	268	95641	95908	Acyrthosiphon pisum BAC VMRC38-20-A2 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence	blastn	14151	424	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
5438589	5438589	PRJNA1227535_P_NODE_25645_length_248_cov_0.891429_g25521_i0	PRJNA1227535	25645	248	0.891429	2.21074392	Myzus persicae	13164	Arthropoda	Arthropoda	141	4.65e-29	NTclustered	gi\|1229890175\|ref\|XM_022309784.1\|	13164	g25521	i0	94.505	1.43548387096774	91	5	37	0	2	92	3331	3421	PREDICTED: Myzus persicae E3 ubiquitin-protein ligase RNF8-like (LOC111030346), mRNA	blastn	356	141	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Myzus	Myzus persicae
6713077	6713077	PRJNA1227535_P_NODE_24926_length_249_cov_0.886364_g24802_i0	PRJNA1227535	24926	249	0.886364	2.20704636	Periplaneta americana	6978	Arthropoda	Arthropoda	106	1.71e-18	NTclustered	gi\|2852194406\|ref\|XM_069822268.1\|	6978	g24802	i0	88.636	35.0682730923695	88	8	35	2	10	95	5004	4917	PREDICTED: Periplaneta americana uncharacterized protein (LOC138696824), transcript variant X5, mRNA	blastn	8732	106	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blattidae	Periplaneta	Periplaneta americana
6713214	6713214	PRJNA1227535_P_NODE_3706_length_370_cov_6.656566_g3583_i0	PRJNA1227535	3706	370	6.656566	24.6292942	Paratanytarsus grimmii	288873	Arthropoda	Arthropoda	595	1.2999999999999996e-165	NTclustered	gi\|1771910279\|dbj\|LC476946.1\|	288873	g3583	i0	100	97.9162162162162	322	0	87	0	1	322	334	655	Paratanytarsus grimmii HAEK1516 gene for 28S ribosomal RNA, partial sequence	blastn	36229	595	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Paratanytarsus	Paratanytarsus grimmii
7424845	7424845	PRJNA1227535_P_NODE_2486_length_433_cov_5.266667_g2364_i0	PRJNA1227535	2486	433	5.266667	22.80466811	Chironomidae	7149	Arthropoda	Arthropoda	496	1.61e-135	NTclustered	gi\|2874226698\|ref\|XR_011544952.1\|	113505	g2364	i0	87.359	101.157043879908	443	43	100	12	1	433	3432	3871	PREDICTED: Chironomus tepperi large subunit ribosomal RNA (LOC139096258), rRNA	blastn	43801	497	0.997987927565392	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
7988570	7988570	PRJNA1227535_P_NODE_12807_length_283_cov_0.966667_g12684_i0	PRJNA1227535	12807	283	0.966667	2.73566761	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	217	8.75e-52	NTclustered	gi\|1685556971\|ref\|XM_016800247.2\|	7029	g12684	i0	94.928	0.830388692579505	138	7	49	0	146	283	1066	929	PREDICTED: Acyrthosiphon pisum uncharacterized LOC107882207 (LOC107882207), transcript variant X1, mRNA	blastn	235	217	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
7988979	7988979	PRJNA1227535_P_NODE_8987_length_298_cov_3.706667_g8864_i0	PRJNA1227535	8987	298	3.706667	11.04586766	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	52.8	0.028	NTclustered	gi\|2919538070\|emb\|OZ238348.1\|	1002887	g8864	i0	100	0.0939597315436242	28	0	9	0	256	283	19041256	19041283	Glaucopsyche melanops genome assembly, chromosome: 7	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops
8700004	8700004	PRJNA1227535_P_NODE_26747_length_247_cov_0.896552_g26623_i0	PRJNA1227535	26747	247	0.896552	2.21448344	root	1	Root_unresolved	Root_unresolved	451	1.88e-122	NTclustered	gi\|1964807406\|emb\|OC914833.1\|	334625	g26623	i0	99.595	44.5748987854251	247	1	100	0	1	247	68016	68262	Oppiella nova	blastn	11010	451	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
9263395	9263395	PRJNA1227535_P_NODE_25368_length_248_cov_2.348571_g25244_i0	PRJNA1227535	25368	248	2.348571	5.82445608	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	436	5.3e-118	NTclustered	gi\|84662989\|gb\|AC167667.4\|	7176	g25244	i0	98.387	25.1895161290323	248	4	100	0	1	248	48279	48032	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940123D9, complete sequence	blastn	6247	436	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
9263448	9263448	PRJNA1227535_P_NODE_28268_length_245_cov_0.906977_g28144_i0	PRJNA1227535	28268	245	0.906977	2.22209365	Leptidea sinapis	189913	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|2311237571\|ref\|XM_050819974.1\|	189913	g28144	i0	96.875	0.261224489795918	32	0	13	1	65	95	896	927	PREDICTED: Leptidea sinapis ras-related protein Rab-14 (LOC126972868), transcript variant X1, mRNA	blastn	64	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pieridae	Leptidea	Leptidea sinapis
9263575	9263575	PRJNA1227535_P_NODE_6148_length_312_cov_3.707113_g6025_i0	PRJNA1227535	6148	312	3.707113	11.56619256	Penaeus vannamei	6689	Arthropoda	Arthropoda	279	1.23e-70	NTclustered	gi\|2864096146\|ref\|XM_070138924.1\|	6689	g6025	i0	100	0.967948717948718	151	0	97	0	162	312	3617	3467	PREDICTED: Penaeus vannamei uncharacterized protein (LOC113801172), mRNA	blastn	302	279	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
10539172	10539172	PRJNA1227535_P_NODE_22289_length_252_cov_4.463687_g22165_i0	PRJNA1227535	22289	252	4.463687	11.24849124	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	460	3.2e-125	NTclustered	gi\|149944779\|gb\|AC202226.4\|	7029	g22165	i0	99.603	1.1468253968254	252	1	100	0	1	252	103953	104204	Acyrthosiphon pisum BAC VMRC38-10-A4 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence	blastn	289	460	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
11813873	11813873	PRJNA1227535_P_NODE_19750_length_259_cov_2.096774_g19626_i0	PRJNA1227535	19750	259	2.096774	5.43064466	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	320	5.86e-83	NTclustered	gi\|91176468\|gb\|AC167662.6\|	7176	g19626	i0	89.919	30.969111969112	248	25	96	0	7	254	9855	9608	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940141D9, complete sequence	blastn	8021	320	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
11813983	11813983	PRJNA1227535_P_NODE_26590_length_247_cov_0.896552_g26466_i0	PRJNA1227535	26590	247	0.896552	2.21448344	Penaeus vannamei	6689	Arthropoda	Arthropoda	206	1.6199999999999998e-48	NTclustered	gi\|2864093136\|ref\|XM_070137632.1\|	6689	g26466	i0	99.123	7.38461538461539	114	1	46	0	1	114	10387	10500	PREDICTED: Penaeus vannamei mucin-17 (LOC113814278), transcript variant X1, mRNA	blastn	1824	206	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
14364188	14364188	PRJNA1227535_P_NODE_13892_length_279_cov_1.383495_g13769_i0	PRJNA1227535	13892	279	1.383495	3.85995105	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	292	1.39e-74	NTclustered	gi\|2621209094\|ref\|XM_061002979.1\|	44670	g13769	i0	95.628	3.06093189964158	183	6	65	2	57	238	547	728	PREDICTED: Metopolophium dirhodum uncharacterized LOC132936282 (LOC132936282), mRNA	blastn	854	292	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum
14364386	14364386	PRJNA1227535_P_NODE_28052_length_245_cov_1.482558_g27928_i0	PRJNA1227535	28052	245	1.482558	3.6322671	Dermatophagoides farinae	6954	Arthropoda	Arthropoda	453	5.1900000000000006e-123	NTclustered	gi\|2205474498\|ref\|XM_047057627.1\|	6954	g27928	i0	100	2	245	0	100	0	1	245	2005	2249	PREDICTED: Dermatophagoides farinae myb-like protein P (LOC124494457), transcript variant X1, mRNA	blastn	490	453	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides farinae
15074463	15074463	PRJNA1227535_P_NODE_11572_length_287_cov_1.373832_g11449_i0	PRJNA1227535	11572	287	1.373832	3.94289784	root	1	Root_unresolved	Root_unresolved	525	1.2999999999999995e-144	NTclustered	gi\|1964807194\|emb\|OC914826.1\|	334625	g11449	i0	99.652	9.97212543554007	287	1	100	0	1	287	48009	47723	Oppiella nova	blastn	2862	525	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
15074719	15074719	PRJNA1227535_P_NODE_9532_length_294_cov_2.932127_g9409_i0	PRJNA1227535	9532	294	2.932127	8.62045338	root	1	Root_unresolved	Root_unresolved	207	5.5e-49	NTclustered	gi\|84662989\|gb\|AC167667.4\|	7176	g9409	i0	90.968	9.06462585034014	155	12	52	2	1	154	6909	6756	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940123D9, complete sequence	blastn	2665	207	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
16349492	16349492	PRJNA1227535_P_NODE_27153_length_246_cov_1.624277_g27029_i0	PRJNA1227535	27153	246	1.624277	3.99572142	Insecta	50557	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|1946423413\|emb\|OD005853.1\|	170557	g27029	i0	100	0.341463414634146	28	0	11	0	88	115	13292	13265	1_Tps_b3v08	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema poppense
18186779	18186779	PRJNA1227535_P_NODE_18835_length_262_cov_2.137566_g18711_i0	PRJNA1227535	18835	262	2.137566	5.60042292	Oppiella nova	334625	Arthropoda	Arthropoda	479	9.249999999999999e-131	NTclustered	gi\|1964807194\|emb\|OC914826.1\|	334625	g18711	i0	99.618	6.98473282442748	262	1	100	0	1	262	99013	99274	Oppiella nova	blastn	1830	479	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
18186834	18186834	PRJNA1227535_P_NODE_22535_length_252_cov_1.625698_g22411_i0	PRJNA1227535	22535	252	1.625698	4.09675896	Aphidius gifuensis	684658	Arthropoda	Arthropoda	128	3.69e-25	NTclustered	gi\|2106720669\|ref\|XM_044154381.1\|	684658	g22411	i0	100	1.03968253968254	69	0	55	0	1	69	364	432	PREDICTED: Aphidius gifuensis protein will die slowly (LOC122853968), transcript variant X1, mRNA	blastn	262	128	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Aphidius	Aphidius gifuensis
19461390	19461390	PRJNA1227535_P_NODE_28096_length_245_cov_1.325581_g27972_i0	PRJNA1227535	28096	245	1.325581	3.24767345	Aphidius gifuensis	684658	Arthropoda	Arthropoda	54.7	0.006	NTclustered	gi\|2106754342\|ref\|XM_044160281.1\|	684658	g27972	i0	96.97	0.404081632653061	33	0	13	1	147	178	4351	4383	PREDICTED: Aphidius gifuensis serine-rich adhesin for platelets-like (LOC122857845), transcript variant X3, mRNA	blastn	99	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Aphidius	Aphidius gifuensis
19461471	19461471	PRJNA1227535_P_NODE_32916_length_228_cov_3.600000_g32792_i0	PRJNA1227535	32916	228	3.6	8.208	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	183	6.909999999999998e-42	NTclustered	gi\|402766743\|ref\|NM_001162260.2\|	7029	g32792	i0	100	0.868421052631579	99	0	43	0	1	99	99	1	Acyrthosiphon pisum prefoldin subunit 5-like (LOC100166994), mRNA	blastn	198	183	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
20173324	20173324	PRJNA1227535_P_NODE_2976_length_405_cov_1.240964_g2853_i0	PRJNA1227535	2976	405	1.240964	5.0259042	root	1	Root_unresolved	Root_unresolved	710	0	NTclustered	gi\|1962583066\|emb\|OC915537.1\|	334625	g2853	i0	98.272	8.48888888888889	405	7	100	0	1	405	18810	19214	Oppiella nova	blastn	3438	710	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
20736593	20736593	PRJNA1227535_P_NODE_12077_length_285_cov_1.679245_g11954_i0	PRJNA1227535	12077	285	1.679245	4.78584825	Homidia socia	301514	Arthropoda	Arthropoda	514	2.79e-141	NTclustered	gi\|712872289\|gb\|KJ873422.1\|	301514	g11954	i0	99.298	100.238596491228	285	1	100	1	1	285	620	337	Homidia socia isolate CQ pop-variant BYY_socia 28S ribosomal RNA gene, partial sequence	blastn	28568	514	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Entomobryomorpha	Entomobryidae	Homidia	Homidia socia
20736817	20736817	PRJNA1227535_P_NODE_26917_length_246_cov_2.959538_g26793_i0	PRJNA1227535	26917	246	2.959538	7.28046348	Coleoptera	7041	Arthropoda	Arthropoda	82.8	3.05e-16	NR	XP_044766292.1	41139	g26793	i0	54.1	3.64634146341463	74	33	90.2	1	245	24	938	1010	XP_044766292.1 uncharacterized protein LOC123322410 [Coccinella septempunctata]	diamond	897	82.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Coccinella	Coccinella septempunctata
22011982	22011982	PRJNA1227535_P_NODE_21258_length_254_cov_2.685083_g21134_i0	PRJNA1227535	21258	254	2.685083	6.82011082	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	75	4.92e-9	NTclustered	gi\|2621253424\|ref\|XR_009665037.1\|	44670	g21134	i0	92.308	0.409448818897638	52	4	20	0	62	113	515	566	PREDICTED: Metopolophium dirhodum uncharacterized LOC132948697 (LOC132948697), transcript variant X1, ncRNA	blastn	104	75	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum
22012167	22012167	PRJNA1227535_P_NODE_31418_length_239_cov_2.536145_g31294_i0	PRJNA1227535	31418	239	2.536145	6.06138655	Frankliniella occidentalis	133901	Arthropoda	Arthropoda	124	4.49e-24	NTclustered	gi\|2347665545\|ref\|XM_026433082.2\|	133901	g31294	i0	94.937	0.640167364016736	79	4	33	0	146	224	149	71	PREDICTED: Frankliniella occidentalis 60S acidic ribosomal protein P2 (LOC113213871), mRNA	blastn	153	124	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Frankliniella	Frankliniella occidentalis
23287404	23287404	PRJNA1227535_P_NODE_12359_length_284_cov_1.876777_g12236_i0	PRJNA1227535	12359	284	1.876777	5.33004668	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	202	2.459999999999999e-47	NTclustered	gi\|82830649\|gb\|AC168019.4\|	7176	g12236	i0	80.069	1.22183098591549	291	43	97	7	1	276	12353	12643	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940127D9, complete sequence	blastn	347	202	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
23287532	23287532	PRJNA1227535_P_NODE_21119_length_255_cov_1.670330_g20995_i0	PRJNA1227535	21119	255	1.67033	4.2593415	Oppiella nova	334625	Arthropoda	Arthropoda	466	6.98e-127	NTclustered	gi\|1964807194\|emb\|OC914826.1\|	334625	g20995	i0	99.608	24.6941176470588	255	1	100	0	1	255	290903	290649	Oppiella nova	blastn	6297	466	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
23287561	23287561	PRJNA1227535_P_NODE_22939_length_252_cov_0.871508_g22815_i0	PRJNA1227535	22939	252	0.871508	2.19620016	Oppiella nova	334625	Arthropoda	Arthropoda	455	1.49e-123	NTclustered	gi\|1964807436\|emb\|OC914834.1\|	334625	g22815	i0	99.598	10.468253968254	249	1	99	0	1	249	66508	66756	Oppiella nova	blastn	2638	455	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
23999122	23999122	PRJNA1227535_P_NODE_33579_length_217_cov_4.694444_g33455_i0	PRJNA1227535	33579	217	4.694444	10.18694348	root	1	Root_unresolved	Root_unresolved	377	2.78e-100	NTclustered	gi\|91176468\|gb\|AC167662.6\|	7176	g33455	i0	98.148	25.2258064516129	216	4	99	0	1	216	65694	65909	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940141D9, complete sequence	blastn	5474	377	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
24561319	24561319	PRJNA1227535_P_NODE_13540_length_280_cov_1.507246_g13417_i0	PRJNA1227535	13540	280	1.507246	4.2202888	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	435	2.19e-117	NTclustered	gi\|146198881\|gb\|AC202216.3\|	7029	g13417	i0	94.681	5.225	282	12	100	2	1	280	63337	63057	Acyrthosiphon pisum BAC VMRC38-20-A5 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence	blastn	1463	435	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
24561713	24561713	PRJNA1227535_P_NODE_7360_length_312_cov_2.803347_g7237_i0	PRJNA1227535	7360	312	2.803347	8.74644264	Nilaparvata lugens	108931	Arthropoda	Arthropoda	87.9	8e-13	NTclustered	gi\|1983919132\|ref\|XM_022339501.2\|	108931	g7237	i0	93.333	0.512820512820513	60	3	19	1	218	276	4192	4133	PREDICTED: Nilaparvata lugens zinc finger protein 391 (LOC111052745), mRNA	blastn	160	87.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Delphacidae	Nilaparvata	Nilaparvata lugens
25273155	25273155	PRJNA1227535_P_NODE_28380_length_245_cov_0.906977_g28256_i0	PRJNA1227535	28380	245	0.906977	2.22209365	root	1	Root_unresolved	Root_unresolved	448	2.41e-121	NTclustered	gi\|1964807365\|emb\|OC914831.1\|	334625	g28256	i0	99.592	19.1755102040816	245	1	100	0	1	245	71658	71902	Oppiella nova	blastn	4698	448	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
26788057	26788057	PRJNA1227535_P_NODE_30081_length_243_cov_0.917647_g29957_i0	PRJNA1227535	30081	243	0.917647	2.22988221	Contarinia nasturtii	265458	Arthropoda	Arthropoda	48.9	2.53e-4	NR	XP_031623911.1	265458	g29957	i0	66.7	1.40740740740741	27	9	33.3	0	93	13	324	350	XP_031623911.1 zinc finger CCHC domain-containing protein 7-like [Contarinia nasturtii]	diamond	342	48.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Cecidomyiidae	Contarinia	Contarinia nasturtii
27452208	27452208	PRJNA1227535_P_NODE_33563_length_218_cov_4.482759_g33439_i0	PRJNA1227535	33563	218	4.482759	9.77241462	Linepithema humile	83485	Arthropoda	Arthropoda	130	1.31e-36	NR	XP_067210080.1	83485	g33439	i0	77.5	1.95412844036697	71	16	97.7	0	5	217	69	139	XP_067210080.1 histone-lysine N-methyltransferase SETMAR-like [Linepithema humile]	diamond	426	130	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Linepithema	Linepithema humile
27483551	27483551	PRJNA1227535_P_NODE_7843_length_312_cov_2.548117_g7720_i0	PRJNA1227535	7843	312	2.548117	7.95012504	Panonychus citri	50023	Arthropoda	Arthropoda	73.6	1.22e-12	NR	XP_053200629.1	50023	g7720	i0	54.8	0.807692307692308	84	35	78.8	2	3	248	495	577	XP_053200629.1 nucleolar protein 14-like [Panonychus citri]	diamond	252	73.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Panonychus	Panonychus citri
27767942	27767942	PRJNA1227535_P_NODE_29204_length_244_cov_0.912281_g29080_i0	PRJNA1227535	29204	244	0.912281	2.22596564	Parasacculina yatsui	2836420	Arthropoda	Arthropoda	89.4	2.59e-20	NR	UEK51488.1	2836420	g29080	i0	62.9	0.860655737704918	70	26	86.1	0	35	244	1	70	UEK51488.1 HOX-like protein 2, partial [Parasacculina yatsui]	diamond	210	89.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Thecostraca		Polyascidae	Parasacculina	Parasacculina yatsui
27944391	27944391	PRJNA1227535_P_NODE_10165_length_292_cov_1.237443_g10042_i0	PRJNA1227535	10165	292	1.237443	3.61333356	Chironomus	7150	Arthropoda	Arthropoda	91.3	5.41e-19	NR	XP_070502689.1	113505	g10042	i0	75.9	1.10958904109589	54	13	55.5	0	292	131	460	513	XP_070502689.1 ubiquitin carboxyl-terminal hydrolase MINDY-3 homolog [Chironomus tepperi]	diamond	324	91.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
29207450	29207450	PRJNA1227535_P_NODE_11289_length_288_cov_1.372093_g11166_i0	PRJNA1227535	11289	288	1.372093	3.95162784	Arthropoda	6656	Arthropoda	Arthropoda	83.2	3.8e-16	NR	XP_044747737.1	41139	g11166	i0	68.2	8.10416666666667	66	18	67.7	2	195	1	6	69	XP_044747737.1 probable methylmalonate-semialdehyde dehydrogenase [acylating], mitochondrial [Coccinella septempunctata]	diamond	2334	83.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Coccinella	Coccinella septempunctata
29440842	29440842	PRJNA1227535_P_NODE_11390_length_287_cov_2.967290_g11267_i0	PRJNA1227535	11390	287	2.96729	8.5161223	Schistocerca nitens	7011	Arthropoda	Arthropoda	64.7	1.14e-9	NR	XP_049808976.1	7011	g11267	i0	45.7	0.731707317073171	70	36	72.1	2	81	287	345	413	XP_049808976.1 stromelysin-1-like [Schistocerca nitens]	diamond	210	64.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca nitens
29883400	29883400	PRJNA1227535_P_NODE_22831_length_252_cov_0.871508_g22707_i0	PRJNA1227535	22831	252	0.871508	2.19620016	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	105	4.74e-24	NR	KAH9407772.1	59818	g22707	i0	100	0.619047619047619	52	0	61.9	0	63	218	14	65	KAH9407772.1 hypothetical protein TYRP_012595 [Tyrophagus putrescentiae]	diamond	156	105	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
30167387	30167387	PRJNA1227535_P_NODE_21032_length_255_cov_2.104396_g20908_i0	PRJNA1227535	21032	255	2.104396	5.3662098	Clunio marinus	568069	Arthropoda	Arthropoda	45.1	0.00658	NR	CRL04832.1	568069	g20908	i0	95.7	0.270588235294118	23	1	27.1	0	34	102	157	179	CRL04832.1 CLUMA_CG017885, isoform A [Clunio marinus]	diamond	69	45.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Clunio	Clunio marinus
30344836	30344836	PRJNA1227535_P_NODE_6452_length_312_cov_3.355649_g6329_i0	PRJNA1227535	6452	312	3.355649	10.46962488	Syrphidae	34680	Arthropoda	Arthropoda	72	4.35e-12	NR	XP_055837555.1	286459	g6329	i0	62	3.83653846153846	50	19	48.1	0	312	163	51	100	XP_055837555.1 dynein regulatory complex subunit 2 [Episyrphus balteatus]	diamond	1197	72	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Syrphidae	Episyrphus	Episyrphus balteatus
30357624	30357624	PRJNA1227535_P_NODE_24152_length_250_cov_0.881356_g24028_i0	PRJNA1227535	24152	250	0.881356	2.20339	Odynerus spinipes	1348599	Arthropoda	Arthropoda	46.2	0.00207	NR	KAK2575428.1	1348599	g24028	i0	40.7	0.972	81	32	86.4	3	1	216	88	161	KAK2575428.1 hypothetical protein KPH14_008337 [Odynerus spinipes]	diamond	243	46.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Vespidae	Odynerus	Odynerus spinipes
30389124	30389124	PRJNA1227535_P_NODE_13393_length_280_cov_3.396135_g13270_i0	PRJNA1227535	13393	280	3.396135	9.509178	Dinothrombium tinctorium	1965070	Arthropoda	Arthropoda	48.9	3.52e-4	NR	RWS16504.1	1965070	g13270	i0	58.3	0.385714285714286	36	15	38.6	0	279	172	233	268	RWS16504.1 outer dense fiber protein 3-like protein [Dinothrombium tinctorium]	diamond	108	48.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombidiidae	Dinothrombium	Dinothrombium tinctorium
30389126	30389126	PRJNA1227535_P_NODE_6293_length_312_cov_3.502092_g6170_i0	PRJNA1227535	6293	312	3.502092	10.92652704	Lucilia cuprina	7375	Arthropoda	Arthropoda	49.7	1.55e-5	NR	KAI8117165.1	7375	g6170	i0	100	0.519230769230769	23	0	22.1	0	211	279	34	56	KAI8117165.1 Mitochondrial folate transporter/carrier [Lucilia cuprina]	diamond	162	49.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Calliphoridae	Lucilia	Lucilia cuprina
30641315	30641315	PRJNA1227535_P_NODE_22893_length_252_cov_0.871508_g22769_i0	PRJNA1227535	22893	252	0.871508	2.19620016	Araneus ventricosus	182803	Arthropoda	Arthropoda	61.6	1.26e-9	NR	GBN98214.1	182803	g22769	i0	43.8	0.952380952380952	80	37	95.2	2	240	1	25	96	GBN98214.1 hypothetical protein AVEN_149174-1 [Araneus ventricosus]	diamond	240	61.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Araneus	Araneus ventricosus
30831013	30831013	PRJNA1227535_P_NODE_12994_length_282_cov_1.449761_g12871_i0	PRJNA1227535	12994	282	1.449761	4.08832602	Psylliodes chrysocephala	3402493	Arthropoda	Arthropoda	69.7	1.96e-11	NR	CAH1114773.1	2598218	g12871	i0	34.1	0.968085106382979	91	60	96.8	0	9	281	263	353	CAH1114773.1 unnamed protein product [Psylliodes chrysocephala]	diamond	273	69.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Psylliodes	Psylliodes chrysocephala
31355580	31355580	PRJNA1227535_P_NODE_1756_length_496_cov_2.380615_g1634_i0	PRJNA1227535	1756	496	2.380615	11.8078504	root	1	Root_unresolved	Root_unresolved	53.1	1.2e-4	NR	GBN61280.1	182803	g1634	i0	50.9	2.95161290322581	53	26	32.1	0	385	227	1136	1188	GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus]	diamond	1464	53.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Araneus	Araneus ventricosus
32095861	32095861	PRJNA1227535_P_NODE_27438_length_246_cov_0.901734_g27314_i0	PRJNA1227535	27438	246	0.901734	2.21826564	Polypedilum vanderplanki	319348	Arthropoda	Arthropoda	134	3.2399999999999993e-34	NR	KAG5677167.1	319348	g27314	i0	79	0.98780487804878	81	17	98.8	0	3	245	785	865	KAG5677167.1 hypothetical protein PVAND_006948 [Polypedilum vanderplanki]	diamond	243	134	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Polypedilum	Polypedilum vanderplanki
32872483	32872483	PRJNA1227535_P_NODE_6060_length_312_cov_3.874477_g5937_i0	PRJNA1227535	6060	312	3.874477	12.08836824	Arthropoda	6656	Arthropoda	Arthropoda	99.4	1.09e-21	NR	XP_046917860.1	6954	g5937	i0	82	42.7884615384615	50	9	48.1	0	1	150	319	368	XP_046917860.1 DNA-binding protein P3A2-like isoform X2 [Dermatophagoides farinae]	diamond	13350	99.8	0.995991983967936	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides farinae

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