metadata: contig_metadata: 59 rows where bioproject = "PRJNA560029" and tax

59 rows where bioproject = "PRJNA560029" 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
543724	543724	PRJNA560029_S_NODE_16741_length_320_cov_1.692308_g16517_i0	PRJNA560029	16741	320	1.692308	5.4153856	Charissa obscurata	204503	Arthropoda	Arthropoda	52.8	0.03	NTclustered	gi\|2919604691\|emb\|OZ238383.1\|	204503	g16517	i0	100	0.0875	28	0	9	0	284	311	10531635	10531662	Charissa obscurata genome assembly, chromosome: 17	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Geometridae	Charissa	Charissa obscurata
544178	544178	PRJNA560029_S_NODE_4501_length_449_cov_4.574468_g4277_i0	PRJNA560029	4501	449	4.574468	20.53936132	root	1	Root_unresolved	Root_unresolved	152	4.55e-42	NR	XP_049838357.1	7010	g4277	i0	61.8	17.3986636971047	123	46	82.2	1	70	438	1	122	XP_049838357.1 aldo-keto reductase family 1 member B1-like isoform X1 [Schistocerca gregaria]	diamond	7812	152	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria
1130457	1130457	PRJNA560029_S_NODE_18921_length_308_cov_2.621277_g18697_i0	PRJNA560029	18921	308	2.621277	8.07353316	Timema	61471	Arthropoda	Arthropoda	52.8	0.029	NTclustered	gi\|1962657315\|emb\|OE179319.1\|	61474	g18697	i0	92.105	0.246753246753247	38	1	12	2	271	308	243246	243281	2_Tcm_b3v08	blastn	76	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
1819693	1819693	PRJNA560029_S_NODE_28102_length_266_cov_3.015544_g27878_i0	PRJNA560029	28102	266	3.015544	8.02134704	Timema poppense	170557	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|1946896637\|emb\|OD014535.1\|	170557	g27878	i0	96.97	0.12406015037594	33	1	12	0	188	220	7375	7407	1_Tps_b3v08	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema poppense
1819905	1819905	PRJNA560029_S_NODE_4682_length_444_cov_7.140162_g4458_i0	PRJNA560029	4682	444	7.140162	31.70231928	Diuraphis noxia	143948	Arthropoda	Arthropoda	56.5	0.003	NTclustered	gi\|985399333\|ref\|XM_015511795.1\|	143948	g4458	i0	100	3.11486486486486	30	0	7	0	143	172	868	839	PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA	blastn	1383	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Diuraphis	Diuraphis noxia
4371071	4371071	PRJNA560029_S_NODE_11344_length_356_cov_1.632509_g11120_i0	PRJNA560029	11344	356	1.632509	5.81173204	Opisthokonta	33154	Arthropoda	Arthropoda	105	5.98e-24	NR	UYV65547.1	51811	g11120	i0	65.8	17.9494382022472	79	27	66.6	0	1	237	324	402	UYV65547.1 RPL23A [Cordylochernes scorpioides]	diamond	6390	105	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Pseudoscorpiones	Chernetidae	Cordylochernes	Cordylochernes scorpioides
4371381	4371381	PRJNA560029_S_NODE_26044_length_275_cov_1.272277_g25820_i0	PRJNA560029	26044	275	1.272277	3.49876175	Artemia franciscana	6661	Arthropoda	Arthropoda	420	6.01e-113	NTclustered	gi\|2743035065\|ref\|XM_065713782.1\|	6661	g25820	i0	94.203	3.09818181818182	276	15	100	1	1	275	397	122	PREDICTED: Artemia franciscana peptidyl-prolyl cis-trans isomerase Fkbp12-like (LOC136033141), mRNA	blastn	852	420	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
4371573	4371573	PRJNA560029_S_NODE_34264_length_244_cov_2.058480_g34040_i0	PRJNA560029	34264	244	2.05848	5.0226912	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|1964742549\|emb\|OC859730.1\|	1979941	g34040	i0	100	0.114754098360656	28	0	11	0	44	71	3732	3705	Medioppia subpectinata	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
4371593	4371593	PRJNA560029_S_NODE_35164_length_242_cov_0.911243_g34940_i0	PRJNA560029	35164	242	0.911243	2.20520806	Chelidurella thaleri	2546182	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2919609962\|emb\|OZ238414.1\|	2546182	g34940	i0	100	0.12396694214876	30	0	12	0	139	168	20415089	20415118	Chelidura thaleri genome assembly, chromosome: 15	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Dermaptera	Forficulidae	Chelidurella	Chelidurella thaleri
4371684	4371684	PRJNA560029_S_NODE_6744_length_404_cov_2.151057_g6520_i0	PRJNA560029	6744	404	2.151057	8.69027028	Timema douglasi	61478	Arthropoda	Arthropoda	54.7	0.011	NTclustered	gi\|1936894007\|emb\|OA565278.1\|	61478	g6520	i0	100	0.0717821782178218	29	0	7	0	250	278	122035	122007	1_Tdi_b3v08	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema douglasi
4371720	4371720	PRJNA560029_S_NODE_9264_length_374_cov_2.129568_g9040_i0	PRJNA560029	9264	374	2.129568	7.96458432	Episema korsakovi	1870626	Arthropoda	Arthropoda	52.8	0.036	NTclustered	gi\|2920003658\|emb\|OZ238877.1\|	1870626	g9040	i0	100	0.0748663101604278	28	0	7	0	345	372	12672505	12672532	Episema korsakovi genome assembly, chromosome: 1	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Episema	Episema korsakovi
4958493	4958493	PRJNA560029_S_NODE_11004_length_358_cov_7.484211_g10780_i0	PRJNA560029	11004	358	7.484211	26.79347538	Arthropoda	6656	Arthropoda	Arthropoda	54.7	0.009	NTclustered	gi\|1026137028\|emb\|LT560377.1\|	85552	g10780	i0	100	0.55586592178771	29	0	8	0	330	358	34	6	Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6	blastn	199	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Scylla	Scylla paramamosain
4958522	4958522	PRJNA560029_S_NODE_2524_length_544_cov_26.702760_g2303_i0	PRJNA560029	2524	544	26.70276	145.2630144	root	1	Root_unresolved	Root_unresolved	58.4	0.001	NTclustered	gi\|2304139023\|ref\|XM_050623139.1\|	85661	g2303	i0	100	2.22426470588235	31	0	6	0	457	487	160	190	PREDICTED: Bombus huntii uncharacterized LOC126868013 (LOC126868013), transcript variant X1, mRNA	blastn	1210	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus huntii
5647745	5647745	PRJNA560029_S_NODE_22505_length_291_cov_1.412844_g22281_i0	PRJNA560029	22505	291	1.412844	4.11137604	Aethina tumida	116153	Arthropoda	Arthropoda	91.6	5.71e-14	NTclustered	gi\|2284703286\|ref\|XM_020014397.2\|	116153	g22281	i0	82.243	0.367697594501718	107	18	37	1	185	291	537	432	PREDICTED: Aethina tumida superoxide dismutase [Cu-Zn] (LOC109598486), mRNA	blastn	107	91.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Nitidulidae	Aethina	Aethina tumida
6233997	6233997	PRJNA560029_S_NODE_16425_length_322_cov_1.088353_g16201_i0	PRJNA560029	16425	322	1.088353	3.50449666	Diptera	7147	Arthropoda	Arthropoda	52.8	0.03	NTclustered	gi\|1829513996\|ref\|XM_033313873.1\|	7226	g16201	i0	100	2.17391304347826	28	0	9	0	293	320	2978	3005	PREDICTED: Drosophila mauritiana innexin shaking-B (LOC117147105), transcript variant X2, mRNA	blastn	700	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila mauritiana
6921645	6921645	PRJNA560029_S_NODE_10906_length_359_cov_4.986014_g10682_i0	PRJNA560029	10906	359	4.986014	17.89979026	Mycalesis perseoides	856294	Arthropoda	Arthropoda	254	8.69e-63	NTclustered	gi\|2567328672\|gb\|OK808162.1\|	856294	g10682	i0	82.095	70.908077994429	296	53	82	0	3	298	305	10	Mycalesis perseoides voucher MCZ:Ent:DL-02-P763 ras protein gene, partial cds	blastn	25456	254	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Mycalesis	Mycalesis perseoides
8196667	8196667	PRJNA560029_S_NODE_15267_length_329_cov_1.914062_g15043_i0	PRJNA560029	15267	329	1.914062	6.29726398	Lysiphlebus testaceipes	77504	Arthropoda	Arthropoda	222	2.23e-53	NTclustered	gi\|62083396\|gb\|AY961521.1\|	77504	g15043	i0	81.955	24.8814589665654	266	45	81	3	65	329	651	388	Lysiphlebus testaceipes ribosomal protein S3 (RpS3) mRNA, partial cds	blastn	8186	222	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Lysiphlebus	Lysiphlebus testaceipes
8197178	8197178	PRJNA560029_S_NODE_6987_length_400_cov_10.596330_g6763_i0	PRJNA560029	6987	400	10.59633	42.38532	Bombyx mori	7091	Arthropoda	Arthropoda	56.5	0.003	NTclustered	gi\|1237088976\|dbj\|LC316987.1\|	7091	g6763	i0	100	0.36	30	0	8	0	371	400	57	28	Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds	blastn	144	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
9472851	9472851	PRJNA560029_S_NODE_6648_length_405_cov_6.581325_g6424_i0	PRJNA560029	6648	405	6.581325	26.65436625	Galathea strigosa	453336	Arthropoda	Arthropoda	71.3	1.07e-7	NTclustered	gi\|1042752279\|gb\|KU613105.1\|	453336	g6424	i0	93.617	1.10617283950617	47	3	12	0	270	316	1234	1188	Galathea strigosa clone A heat shock protein 70 kDa (hsp70) gene, partial cds	blastn	448	71.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Galatheidae	Galathea	Galathea strigosa
10748536	10748536	PRJNA560029_S_NODE_37129_length_226_cov_3.784314_g36905_i0	PRJNA560029	37129	226	3.784314	8.55254964	Drosophila virilis	7244	Arthropoda	Arthropoda	52.8	0.02	NTclustered	gi\|2867921296\|ref\|XM_002052794.4\|	7244	g36905	i0	100	1.61061946902655	28	0	12	0	199	226	465	438	PREDICTED: Drosophila virilis Ribosomal protein LP1 (RpLP1), mRNA	blastn	364	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila virilis
10748584	10748584	PRJNA560029_S_NODE_6449_length_408_cov_3.680597_g6225_i0	PRJNA560029	6449	408	3.680597	15.01683576	Euthrix potatoria	624169	Arthropoda	Arthropoda	52.8	0.039	NTclustered	gi\|2918369991\|emb\|OZ237878.1\|	624169	g6225	i0	100	0.0686274509803922	28	0	7	0	194	221	10616477	10616504	Euthrix potatoria genome assembly, chromosome: 6	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lasiocampidae	Euthrix	Euthrix potatoria
12022961	12022961	PRJNA560029_S_NODE_21370_length_296_cov_2.067265_g21146_i0	PRJNA560029	21370	296	2.067265	6.1191044	Callophrys avis	700180	Arthropoda	Arthropoda	52.8	0.027	NTclustered	gi\|2918385487\|emb\|OZ238082.1\|	700180	g21146	i0	100	0.0945945945945946	28	0	9	0	149	176	30571006	30571033	Callophrys avis genome assembly, chromosome: 15	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Callophrys	Callophrys avis
13297875	13297875	PRJNA560029_S_NODE_17371_length_316_cov_3.378601_g17147_i0	PRJNA560029	17371	316	3.378601	10.67637916	Glossina fuscipes	7396	Arthropoda	Arthropoda	54.7	0.008	NTclustered	gi\|1939361499\|ref\|XM_038045242.1\|	7396	g17147	i0	100	1.37658227848101	29	0	9	0	188	216	8392	8420	PREDICTED: Glossina fuscipes titin (LOC119645211), transcript variant X8, mRNA	blastn	435	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Glossinidae	Glossina	Glossina fuscipes
13298041	13298041	PRJNA560029_S_NODE_25651_length_276_cov_7.147783_g25427_i0	PRJNA560029	25651	276	7.147783	19.72788108	Teleiodes vulgella	1594352	Arthropoda	Arthropoda	54.7	0.007	NTclustered	gi\|2918369937\|emb\|OZ237925.1\|	1594352	g25427	i0	100	0.22463768115942	29	0	11	0	18	46	5276871	5276843	Teleiodes vulgella genome assembly, chromosome: 6	blastn	62	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Gelechiidae	Teleiodes	Teleiodes vulgella
14572650	14572650	PRJNA560029_S_NODE_1432_length_675_cov_16.018272_g1222_i0	PRJNA560029	1432	675	16.018272	108.123336	Zerynthia rumina	132710	Arthropoda	Arthropoda	99	8.52e-16	NTclustered	gi\|2918376694\|emb\|OZ238059.1\|	132710	g1222	i0	92.647	0.608888888888889	68	5	10	0	1	68	24325799	24325732	Zerynthia rumina genome assembly, chromosome: 24	blastn	411	99	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Zerynthia	Zerynthia rumina
14572812	14572812	PRJNA560029_S_NODE_2252_length_568_cov_151.296970_g2031_i0	PRJNA560029	2252	568	151.29697	859.3667896	Timema californicum	61474	Arthropoda	Arthropoda	56.5	0.004	NTclustered	gi\|1965181363\|emb\|OE475415.1\|	61474	g2031	i0	90.909	0.0774647887323944	44	1	7	2	339	379	266	309	2_Tcm_b3v08	blastn	44	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
14573015	14573015	PRJNA560029_S_NODE_31092_length_254_cov_3.563536_g30868_i0	PRJNA560029	31092	254	3.563536	9.05138144	Artemia franciscana	6661	Arthropoda	Arthropoda	385	2e-102	NTclustered	gi\|2743035065\|ref\|XM_065713782.1\|	6661	g30868	i0	94.118	2.90551181102362	255	12	100	2	1	254	520	268	PREDICTED: Artemia franciscana peptidyl-prolyl cis-trans isomerase Fkbp12-like (LOC136033141), mRNA	blastn	738	385	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
15846947	15846947	PRJNA560029_S_NODE_32793_length_248_cov_5.742857_g32569_i0	PRJNA560029	32793	248	5.742857	14.24228536	Vanessa cardui	171605	Arthropoda	Arthropoda	111	3.65e-20	NTclustered	gi\|2207055778\|ref\|XM_047116536.1\|	171605	g32569	i0	94.444	29.3467741935484	72	4	29	0	177	248	1208	1137	PREDICTED: Vanessa cardui actin, muscle (LOC124539235), mRNA	blastn	7278	111	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Vanessa	Vanessa cardui
17121933	17121933	PRJNA560029_S_NODE_5454_length_426_cov_1.651558_g5230_i0	PRJNA560029	5454	426	1.651558	7.03563708	Timema shepardi	629360	Arthropoda	Arthropoda	54.7	0.011	NTclustered	gi\|1937863514\|emb\|OC003847.1\|	629360	g5230	i0	96.97	0.0774647887323944	33	0	8	1	311	343	52561	52592	2_Tsi_b3v08	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema shepardi
18395581	18395581	PRJNA560029_S_NODE_12675_length_346_cov_1.201465_g12451_i0	PRJNA560029	12675	346	1.201465	4.1570689	Trichogramma pretiosum	7493	Arthropoda	Arthropoda	52.8	0.033	NTclustered	gi\|1321338876\|ref\|XM_014365627.2\|	7493	g12451	i0	96.774	0.0895953757225433	31	1	9	0	287	317	1351	1321	PREDICTED: Trichogramma pretiosum transport and Golgi organization protein 1-like (LOC106648608), mRNA	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Trichogrammatidae	Trichogramma	Trichogramma pretiosum
19670227	19670227	PRJNA560029_S_NODE_15876_length_325_cov_2.162698_g15652_i0	PRJNA560029	15876	325	2.162698	7.0287685	Scylla paramamosain	85552	Arthropoda	Arthropoda	52.8	0.031	NTclustered	gi\|1184387702\|emb\|LT835105.1\|	85552	g15652	i0	100	0.0861538461538462	28	0	9	0	1	28	8	35	Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene)	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Scylla	Scylla paramamosain
19670696	19670696	PRJNA560029_S_NODE_4356_length_453_cov_21.671053_g4132_i0	PRJNA560029	4356	453	21.671053	98.16987009	Timema poppense	170557	Arthropoda	Arthropoda	52.8	0.044	NTclustered	gi\|1946153605\|emb\|OD012397.1\|	170557	g4132	i0	100	0.0618101545253863	28	0	6	0	109	136	9148	9121	1_Tps_b3v08	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema poppense
20945826	20945826	PRJNA560029_S_NODE_10237_length_365_cov_2.109589_g10013_i0	PRJNA560029	10237	365	2.109589	7.69999985	Episema korsakovi	1870626	Arthropoda	Arthropoda	52.8	0.035	NTclustered	gi\|2920003667\|emb\|OZ238881.1\|	1870626	g10013	i0	100	0.0767123287671233	28	0	8	0	331	358	16960514	16960487	Episema korsakovi genome assembly, chromosome: 5	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Episema	Episema korsakovi
20946019	20946019	PRJNA560029_S_NODE_19937_length_303_cov_2.082609_g19713_i0	PRJNA560029	19937	303	2.082609	6.31030527	Athalia rosae	37344	Arthropoda	Arthropoda	172	2.08e-38	NTclustered	gi\|2252009780\|ref\|XM_012399187.3\|	37344	g19713	i0	83.077	5.95379537953795	195	28	64	5	90	282	446	255	PREDICTED: Athalia rosae 60S ribosomal protein L36 (LOC105685244), mRNA	blastn	1804	172	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Athaliidae	Athalia	Athalia rosae
22220829	22220829	PRJNA560029_S_NODE_14898_length_331_cov_2.872093_g14674_i0	PRJNA560029	14898	331	2.872093	9.50662783	Timema poppense	170557	Arthropoda	Arthropoda	52.8	0.031	NTclustered	gi\|1946147898\|emb\|OD000035.1\|	170557	g14674	i0	91.892	0.11178247734139	37	3	11	0	289	325	247707	247671	1_Tps_b3v08	blastn	37	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema poppense
22220915	22220915	PRJNA560029_S_NODE_19558_length_305_cov_2.288793_g19334_i0	PRJNA560029	19558	305	2.288793	6.98081865	Prorops nasuta	863751	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2781115027\|ref\|XM_066725477.1\|	863751	g19334	i0	100	1.23934426229508	30	0	10	0	240	269	727	756	PREDICTED: Prorops nasuta zinc finger protein 219-like (LOC136772463), mRNA	blastn	378	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Bethylidae	Prorops	Prorops nasuta
22221108	22221108	PRJNA560029_S_NODE_28078_length_266_cov_3.621762_g27854_i0	PRJNA560029	28078	266	3.621762	9.63388692	Samia ricini	63990	Arthropoda	Arthropoda	54.7	0.007	NTclustered	gi\|2883230451\|dbj\|AP038909.1\|	63990	g27854	i0	94.444	0.135338345864662	36	1	13	1	47	81	30982032	30981997	Samia ricini White GU1 DNA, chromosome 14, complete sequence	blastn	36	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Saturniidae	Samia	Samia ricini
23496398	23496398	PRJNA560029_S_NODE_27619_length_268_cov_2.400000_g27395_i0	PRJNA560029	27619	268	2.4	6.432	Leiobunum subalpinum	3086104	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2920024126\|emb\|OZ239121.1\|	3086104	g27395	i0	100	0.220149253731343	30	0	11	0	85	114	36216185	36216214	Leiobunum subalpinum genome assembly, chromosome: 4	blastn	59	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Opiliones	Sclerosomatidae	Leiobunum	Leiobunum subalpinum
23496442	23496442	PRJNA560029_S_NODE_29879_length_259_cov_3.080645_g29655_i0	PRJNA560029	29879	259	3.080645	7.97887055	Zerynthia rumina	132710	Arthropoda	Arthropoda	54.7	0.007	NTclustered	gi\|2918376681\|emb\|OZ238052.1\|	132710	g29655	i0	96.875	0.123552123552124	32	1	12	0	109	140	14872819	14872788	Zerynthia rumina genome assembly, chromosome: 17	blastn	32	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Zerynthia	Zerynthia rumina
23496645	23496645	PRJNA560029_S_NODE_7079_length_399_cov_5.184049_g6855_i0	PRJNA560029	7079	399	5.184049	20.68435551	Arthropoda	6656	Arthropoda	Arthropoda	176	5.83e-53	NR	KAK7043288.1	373956	g6855	i0	77.9	12.5563909774436	104	23	78.2	0	317	6	1	104	KAK7043288.1 40S ribosomal protein S4, partial [Halocaridina rubra]	diamond	5010	176	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Atyidae	Halocaridina	Halocaridina rubra
24082351	24082351	PRJNA560029_S_NODE_26559_length_272_cov_32.849246_g26335_i0	PRJNA560029	26559	272	32.849246	89.34994912	Arthropoda	6656	Arthropoda	Arthropoda	54.7	0.007	NTclustered	gi\|2500601980\|ref\|XR_008750729.1\|	7200	g26335	i0	96.875	1.09191176470588	32	1	12	0	241	272	3313	3344	PREDICTED: Lutzomyia longipalpis potassium/sodium hyperpolarization-activated cyclic nucleotide-gated channel 3 (LOC129791559), transcript variant X12, misc_RNA	blastn	297	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Lutzomyia	Lutzomyia longipalpis
24770550	24770550	PRJNA560029_S_NODE_7120_length_398_cov_31.381538_g6896_i0	PRJNA560029	7120	398	31.381538	124.89852124	Timema monikensis	170555	Arthropoda	Arthropoda	58.4	8.19e-4	NTclustered	gi\|1946411097\|emb\|OB793204.1\|	170555	g6896	i0	97.059	0.226130653266332	34	1	9	0	311	344	168543	168510	3_Tms_b3v08	blastn	90	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema monikensis
25356744	25356744	PRJNA560029_S_NODE_23920_length_284_cov_3.208531_g23696_i0	PRJNA560029	23920	284	3.208531	9.11222804	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	56.5	0.002	NTclustered	gi\|1891370858\|ref\|XM_035863149.1\|	7446	g23696	i0	96.97	2.84859154929577	33	1	12	0	91	123	310	278	PREDICTED: Vespa mandarinia serine/threonine-protein kinase BRSK2-like (LOC118440305), transcript variant X7, mRNA	blastn	809	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Vespidae	Vespa	Vespa mandarinia
26857826	26857826	PRJNA560029_S_NODE_15901_length_325_cov_1.638889_g15677_i0	PRJNA560029	15901	325	1.638889	5.32638925	Holotrichia oblita	644536	Arthropoda	Arthropoda	50.4	1.76e-4	NR	KAI4461381.1	644536	g15677	i0	56.1	0.378461538461538	41	18	37.8	0	323	201	401	441	KAI4461381.1 ruvb-related reptin and pontin [Holotrichia oblita]	diamond	123	50.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Scarabaeidae	Holotrichia	Holotrichia oblita
26903288	26903288	PRJNA560029_S_NODE_37381_length_221_cov_4.337838_g37157_i0	PRJNA560029	37381	221	4.337838	9.58662198	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47.8	4.67e-4	NR	XP_049849546.1	7010	g37157	i0	58.3	2.91855203619909	36	15	48.9	0	221	114	373	408	XP_049849546.1 uncharacterized protein LOC126319887 [Schistocerca gregaria]	diamond	645	48.1	0.993762993762994	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria
26997888	26997888	PRJNA560029_S_NODE_17922_length_313_cov_3.908333_g17698_i0	PRJNA560029	17922	313	3.908333	12.23308229	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	88.6	1.79e-18	NR	XP_055388650.1	2530218	g17698	i0	46.8	3.57507987220447	94	50	90.1	0	313	32	211	304	XP_055388650.1 60S ribosomal protein L7a-like [Condylostylus longicornis]	diamond	1119	89.4	0.991051454138702	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Dolichopodidae	Condylostylus	Condylostylus longicornis
27977324	27977324	PRJNA560029_S_NODE_2965_length_513_cov_31.890909_g2743_i0	PRJNA560029	2965	513	31.890909	163.60036317	root	1	Root_unresolved	Root_unresolved	53.1	1.39e-4	NR	GBN61280.1	182803	g2743	i0	50.9	2.85380116959064	53	26	31	0	124	282	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
28215746	28215746	PRJNA560029_S_NODE_9206_length_374_cov_5.318937_g8982_i0	PRJNA560029	9206	374	5.318937	19.89282438	Araneus ventricosus	182803	Arthropoda	Arthropoda	49.7	5.4e-4	NR	GBN01749.1	182803	g8982	i0	48.6	1.48395721925134	37	19	29.7	0	113	3	93	129	GBN01749.1 hypothetical protein AVEN_64609-1 [Araneus ventricosus]	diamond	555	49.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Araneus	Araneus ventricosus
28310789	28310789	PRJNA560029_S_NODE_25606_length_277_cov_1.171569_g25382_i0	PRJNA560029	25606	277	1.171569	3.24524613	Pediculus humanus corporis	121224	Arthropoda	Arthropoda	55.8	4.71e-8	NR	XP_002432412.1	121224	g25382	i0	72.7	0.357400722021661	33	9	35.7	0	275	177	20	52	XP_002432412.1 ATP synthase epsilon chain, putative [Pediculus humanus corporis]	diamond	99	55.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Pediculidae	Pediculus	Pediculus humanus
29335099	29335099	PRJNA560029_S_NODE_18509_length_310_cov_3.050633_g18285_i0	PRJNA560029	18509	310	3.050633	9.4569623	Araneidae	6913	Arthropoda	Arthropoda	50.8	1.14e-4	NR	KAF8785944.1	94029	g18285	i0	37.9	1.27741935483871	66	41	63.9	0	95	292	64	129	KAF8785944.1 Sodium-dependent glucose transporter 1 like protein [Argiope bruennichi]	diamond	396	50.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Argiope	Argiope bruennichi
29650373	29650373	PRJNA560029_S_NODE_36010_length_237_cov_3.280488_g35786_i0	PRJNA560029	36010	237	3.280488	7.77475656	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	49.7	1.21e-4	NR	XP_015790989.1	32264	g35786	i0	34.2	3.68354430379747	76	47	94.9	2	2	226	459	532	XP_015790989.1 myotubularin-related protein 2 [Tetranychus urticae]	diamond	873	50.1	0.992015968063872	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
30078842	30078842	PRJNA560029_S_NODE_8252_length_384_cov_26.983923_g8028_i0	PRJNA560029	8252	384	26.983923	103.61826432	Musca domestica	7370	Arthropoda	Arthropoda	54.7	1.25e-5	NR	XP_058975114.1	7370	g8028	i0	37.5	0.875	56	35	43.8	0	19	186	1269	1324	XP_058975114.1 uncharacterized protein LOC131801083 [Musca domestica]	diamond	336	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Muscidae	Musca	Musca domestica
30155901	30155901	PRJNA560029_S_NODE_36632_length_231_cov_3.329114_g36408_i0	PRJNA560029	36632	231	3.329114	7.69025334	root	1	Root_unresolved	Root_unresolved	65.5	2.84e-10	NR	XP_018497077.1	34638	g36408	i0	62	3.16883116883117	50	19	64.9	0	229	80	337	386	XP_018497077.1 aminomethyltransferase, mitochondrial [Galendromus occidentalis]	diamond	732	65.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Mesostigmata	Phytoseiidae	Galendromus	Galendromus occidentalis
30282937	30282937	PRJNA560029_S_NODE_7712_length_391_cov_4.125786_g7488_i0	PRJNA560029	7712	391	4.125786	16.13182326	Insecta	50557	Arthropoda	Arthropoda	207	1.72e-64	NR	XP_023718569.1	105785	g7488	i0	83.6	4.45012787723785	116	19	89	0	2	349	153	268	XP_023718569.1 60S ribosomal protein L7a [Cryptotermes secundus]	diamond	1740	207	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Kalotermitidae	Cryptotermes	Cryptotermes secundus
31184519	31184519	PRJNA560029_S_NODE_29935_length_259_cov_1.967742_g29711_i0	PRJNA560029	29935	259	1.967742	5.09645178	Daphnia barbata	414587	Arthropoda	Arthropoda	54.3	4e-6	NR	SVE74005.1	414587	g29711	i0	44.4	0.938223938223938	81	40	91.5	3	13	249	1700	1777	SVE74005.1 EOG090X00E0 [Daphnia barbata]	diamond	243	54.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia barbata
31342980	31342980	PRJNA560029_S_NODE_10756_length_360_cov_7.226481_g10532_i0	PRJNA560029	10756	360	7.226481	26.0153316	Aromia moschata	1265417	Arthropoda	Arthropoda	94.4	2.48e-20	NR	KAJ8943318.1	1265417	g10532	i0	59.3	4.14166666666667	59	24	49.2	0	5	181	252	310	KAJ8943318.1 hypothetical protein NQ318_004759 [Aromia moschata]	diamond	1491	94.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Cerambycidae	Aromia	Aromia moschata
31564595	31564595	PRJNA560029_S_NODE_11036_length_358_cov_4.361404_g10812_i0	PRJNA560029	11036	358	4.361404	15.61382632	Palaemon carinicauda	392227	Arthropoda	Arthropoda	125	5.97e-31	NR	XP_068233243.1	392227	g10812	i0	56.9	4.53351955307263	109	45	89.7	1	350	30	427	535	XP_068233243.1 phosphopentomutase isoform X2 [Palaemon carinicauda]	diamond	1623	125	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Palaemon	Palaemon carinicauda
31659053	31659053	PRJNA560029_S_NODE_5397_length_427_cov_3.759887_g5173_i0	PRJNA560029	5397	427	3.759887	16.05471749	Daphnia pulex	6669	Arthropoda	Arthropoda	90.9	1.6e-18	NR	EFX63653.1	6669	g5173	i0	39	2.86651053864169	136	71	89.9	3	421	38	38	169	EFX63653.1 hypothetical protein DAPPUDRAFT_268051 [Daphnia pulex]	diamond	1224	90.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
31943751	31943751	PRJNA560029_S_NODE_29357_length_261_cov_3.893617_g29133_i0	PRJNA560029	29357	261	3.893617	10.16234037	Thrips palmi	161013	Arthropoda	Arthropoda	49.3	2.2e-4	NR	XP_034238337.1	161013	g29133	i0	46.7	0.689655172413793	60	28	64.4	1	193	26	391	450	XP_034238337.1 ammonium transporter Rh type A [Thrips palmi]	diamond	180	49.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips palmi

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