metadata: contig_metadata: 51 rows where bioproject = "PRJNA1073005" and tax

51 rows where bioproject = "PRJNA1073005" 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
186989	186989	PRJNA1073005_P_NODE_6141_length_364_cov_1.453608_g6022_i0	PRJNA1073005	6141	364	1.453608	5.29113312	Satyrium ilicis	876074	Arthropoda	Arthropoda	58.4	7.42e-4	NTclustered	gi\|2918386101\|emb\|OZ238115.1\|	876074	g6022	i0	90.698	0.118131868131868	43	4	12	0	124	166	56559195	56559237	Satyrium ilicis genome assembly, chromosome: 6	blastn	43	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Satyrium	Satyrium ilicis
1461547	1461547	PRJNA1073005_P_NODE_3482_length_560_cov_1.379877_g3363_i0	PRJNA1073005	3482	560	1.379877	7.7273112	Episema korsakovi	1870626	Arthropoda	Arthropoda	54.7	0.015	NTclustered	gi\|2920003685\|emb\|OZ238899.1\|	1870626	g3363	i0	100	0.0517857142857143	29	0	5	0	195	223	13326297	13326325	Episema korsakovi genome assembly, chromosome: 23	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Episema	Episema korsakovi
2737534	2737534	PRJNA1073005_P_NODE_6523_length_345_cov_1.437500_g6404_i0	PRJNA1073005	6523	345	1.4375	4.959375	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	638	1.97e-178	NTclustered	gi\|2306731610\|ref\|XM_035587968.2\|	7108	g6404	i0	100	93.3217391304348	345	0	100	0	1	345	437	93	PREDICTED: Spodoptera frugiperda 14-3-3 protein zeta (LOC118271767), transcript variant X1, mRNA	blastn	32196	638	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
2737544	2737544	PRJNA1073005_P_NODE_8623_length_261_cov_1.228723_g8504_i0	PRJNA1073005	8623	261	1.228723	3.20696703	Wasmannia auropunctata	64793	Arthropoda	Arthropoda	52.8	0.024	NTclustered	gi\|780644672\|ref\|XM_011690559.1\|	64793	g8504	i0	100	0.10727969348659	28	0	11	0	1	28	1060	1033	PREDICTED: Wasmannia auropunctata fatty acid synthase-like (LOC105450626), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Wasmannia	Wasmannia auropunctata
5289764	5289764	PRJNA1073005_P_NODE_7005_length_323_cov_1.576000_g6886_i0	PRJNA1073005	7005	323	1.576	5.09048	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	592	1.4499999999999999e-164	NTclustered	gi\|2306739890\|ref\|XM_035584576.2\|	7108	g6886	i0	99.69	1.99071207430341	323	1	100	0	1	323	481	159	PREDICTED: Spodoptera frugiperda cuticle protein CP14.6 (LOC118269457), mRNA	blastn	643	592	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
7839589	7839589	PRJNA1073005_P_NODE_10327_length_241_cov_0.916667_g10208_i0	PRJNA1073005	10327	241	0.916667	2.20916747	Eriocheir sinensis	95602	Arthropoda	Arthropoda	440	3.959999999999999e-119	NTclustered	gi\|2311970906\|ref\|XM_050882932.1\|	95602	g10208	i0	99.585	13.0539419087137	241	1	100	0	1	241	703	943	PREDICTED: Eriocheir sinensis UDP-glucosyltransferase 2-like (LOC127009658), mRNA	blastn	3146	440	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis
7839590	7839590	PRJNA1073005_P_NODE_10367_length_241_cov_0.916667_g10248_i0	PRJNA1073005	10367	241	0.916667	2.20916747	Papilio polytes	76194	Arthropoda	Arthropoda	231	2.6e-56	NTclustered	gi\|914099541\|ref\|NM_001311525.1\|	76194	g10248	i0	84.298	93.1327800829876	242	33	99	5	1	240	328	566	Papilio polytes ribosomal protein L10 (RpL10), mRNA	blastn	22445	231	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
7839602	7839602	PRJNA1073005_P_NODE_6867_length_330_cov_1.128405_g6748_i0	PRJNA1073005	6867	330	1.128405	3.7237365	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	586	6.889999999999998e-163	NTclustered	gi\|2306742210\|ref\|XM_035603380.2\|	7108	g6748	i0	98.784	2.02121212121212	329	4	99	0	2	330	431	103	PREDICTED: Spodoptera frugiperda larval cuticle protein LCP-30-like (LOC118282342), mRNA	blastn	667	586	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
9114591	9114591	PRJNA1073005_P_NODE_7448_length_304_cov_1.333333_g7329_i0	PRJNA1073005	7448	304	1.333333	4.05333232	Drosophila ficusphila	30025	Arthropoda	Arthropoda	320	7.03e-83	NTclustered	gi\|1036938023\|ref\|XM_017194943.1\|	30025	g7329	i0	85.762	98.5131578947368	302	43	99	0	1	302	1502	1803	PREDICTED: Drosophila ficusphila eukaryotic translation elongation factor 2 (LOC108094381), mRNA	blastn	29948	320	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila ficusphila
9114599	9114599	PRJNA1073005_P_NODE_9108_length_250_cov_0.870056_g8989_i0	PRJNA1073005	9108	250	0.870056	2.17514	Lucilia sericata	13632	Arthropoda	Arthropoda	265	2.67e-66	NTclustered	gi\|1937277070\|ref\|XM_037958633.1\|	13632	g8989	i0	85.887	99.092	248	35	99	0	3	250	1342	1095	PREDICTED: Lucilia sericata actin-5C (LOC119605489), transcript variant X1, mRNA	blastn	24773	265	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Calliphoridae	Lucilia	Lucilia sericata
9114600	9114600	PRJNA1073005_P_NODE_9128_length_250_cov_0.870056_g9009_i0	PRJNA1073005	9128	250	0.870056	2.17514	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	451	1.91e-122	NTclustered	gi\|2306718735\|ref\|XM_035589757.2\|	7108	g9009	i0	99.595	1.92	247	1	99	0	1	247	5711	5465	PREDICTED: Spodoptera frugiperda collagen alpha-1(IV) chain (LOC118273020), mRNA	blastn	480	451	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
10390286	10390286	PRJNA1073005_P_NODE_9369_length_248_cov_0.880000_g9250_i0	PRJNA1073005	9369	248	0.88	2.1824	Eriocheir sinensis	95602	Arthropoda	Arthropoda	448	2.4499999999999996e-121	NTclustered	gi\|2311939130\|ref\|XM_050873463.1\|	95602	g9250	i0	99.194	4	248	2	100	0	1	248	2105	1858	PREDICTED: Eriocheir sinensis mucin-17-like (LOC127005020), transcript variant X4, mRNA	blastn	992	448	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis
10390287	10390287	PRJNA1073005_P_NODE_9429_length_248_cov_0.880000_g9310_i0	PRJNA1073005	9429	248	0.88	2.1824	Euroglyphus maynei	6958	Arthropoda	Arthropoda	127	1.31e-35	NR	OTF82201.1	6958	g9310	i0	70.7	10.8991935483871	82	24	99.2	0	2	247	19	100	OTF82201.1 40S ribosomal protein S18-like protein [Euroglyphus maynei]	diamond	2703	127	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Euroglyphus	Euroglyphus maynei
10390289	10390289	PRJNA1073005_P_NODE_9769_length_245_cov_0.895349_g9650_i0	PRJNA1073005	9769	245	0.895349	2.19360505	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	292	1.2e-74	NTclustered	gi\|2306760450\|ref\|XM_050706691.1\|	7108	g9650	i0	96.591	19.0857142857143	176	6	100	0	70	245	1991	2166	PREDICTED: Spodoptera frugiperda FK506-binding protein 5 (LOC118268177), transcript variant X7, mRNA	blastn	4676	292	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
11665622	11665622	PRJNA1073005_P_NODE_10090_length_243_cov_0.905882_g9971_i0	PRJNA1073005	10090	243	0.905882	2.20129326	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	438	1.4399999999999996e-118	NTclustered	gi\|2306742227\|ref\|XM_035572853.2\|	7108	g9971	i0	99.177	3.59670781893004	243	2	100	0	1	243	387	145	PREDICTED: Spodoptera frugiperda larval cuticle protein 1 (LOC118261853), mRNA	blastn	874	438	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
11665639	11665639	PRJNA1073005_P_NODE_7710_length_293_cov_1.290909_g7591_i0	PRJNA1073005	7710	293	1.290909	3.78236337	Psychoda cinerea	7202	Arthropoda	Arthropoda	462	1.06e-125	NTclustered	gi\|2190489\|emb\|X93404.1\|	7202	g7591	i0	94.737	99.0238907849829	304	5	100	9	1	293	14	317	P.cinerea 28S rRNA gene, expansion segment D7	blastn	29014	462	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Psychoda	Psychoda cinerea
11665650	11665650	PRJNA1073005_P_NODE_9330_length_248_cov_1.502857_g9211_i0	PRJNA1073005	9330	248	1.502857	3.72708536	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	409	1.16e-109	NTclustered	gi\|2306763855\|ref\|XM_035591579.2\|	7108	g9211	i0	96.371	3.32258064516129	248	9	100	0	1	248	1508	1261	PREDICTED: Spodoptera frugiperda serine/threonine-protein kinase RIO2 (LOC118274160), mRNA	blastn	824	409	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
11665653	11665653	PRJNA1073005_P_NODE_9610_length_246_cov_1.323699_g9491_i0	PRJNA1073005	9610	246	1.323699	3.25629954	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|2919550840\|emb\|OZ238361.1\|	1002887	g9491	i0	100	0.113821138211382	28	0	11	0	118	145	14100628	14100601	Glaucopsyche melanops genome assembly, chromosome: 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops
13769321	13769321	PRJNA1073005_P_NODE_7331_length_309_cov_1.754237_g7212_i0	PRJNA1073005	7331	309	1.754237	5.42059233	Lepidoptera	7088	Arthropoda	Arthropoda	571	1.7899999999999995e-158	NTclustered	gi\|2306717695\|ref\|XR_004783997.2\|	7108	g7212	i0	100	347.860841423948	309	0	100	0	1	309	3545	3853	PREDICTED: Spodoptera frugiperda large subunit ribosomal RNA (LOC118279431), rRNA	blastn	107489	571	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
14215671	14215671	PRJNA1073005_P_NODE_8472_length_267_cov_1.164948_g8353_i0	PRJNA1073005	8472	267	1.164948	3.11041116	Sitodiplosis mosellana	263140	Arthropoda	Arthropoda	207	4.93e-49	NTclustered	gi\|2492501057\|ref\|XM_055465043.1\|	263140	g8353	i0	81.395	3.90262172284644	258	44	96	3	7	262	134	389	PREDICTED: Sitodiplosis mosellana 40S ribosomal protein S23 (LOC129577635), mRNA	blastn	1042	207	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Cecidomyiidae	Sitodiplosis	Sitodiplosis mosellana
14215677	14215677	PRJNA1073005_P_NODE_9132_length_250_cov_0.870056_g9013_i0	PRJNA1073005	9132	250	0.870056	2.17514	Procambarus clarkii	6728	Arthropoda	Arthropoda	401	1.9499999999999994e-107	NTclustered	gi\|1477345672\|gb\|MH538273.1\|	6728	g9013	i0	95.6	3.14	250	11	100	0	1	250	122	371	Procambarus clarkii 14-3-3 epsilon-like protein variant 1 mRNA, partial cds	blastn	785	401	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
14215680	14215680	PRJNA1073005_P_NODE_9432_length_248_cov_0.880000_g9313_i0	PRJNA1073005	9432	248	0.88	2.1824	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	145	3.6e-30	NTclustered	gi\|619325822\|emb\|FO681379.1\|	7108	g9313	i0	93.75	59.9395161290323	96	6	39	0	28	123	98405	98500	Spodoptera frugiperda sequence from BAC clone 21I19	blastn	14865	145	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
14215685	14215685	PRJNA1073005_P_NODE_9952_length_244_cov_0.900585_g9833_i0	PRJNA1073005	9952	244	0.900585	2.1974274	Drosophila arizonae	7263	Arthropoda	Arthropoda	130	9.88e-26	NTclustered	gi\|1060208674\|ref\|XM_018002600.1\|	7263	g9833	i0	80.11	43.2254098360656	181	30	73	5	1	178	2406	2583	PREDICTED: Drosophila arizonae elongation factor 2 (LOC108610473), mRNA	blastn	10547	130	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila arizonae
15489615	15489615	PRJNA1073005_P_NODE_7113_length_318_cov_1.151020_g6994_i0	PRJNA1073005	7113	318	1.15102	3.6602436	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	281	3.49e-71	NTclustered	gi\|2306775059\|ref\|XM_050694849.1\|	7108	g6994	i0	99.355	74.8553459119497	155	1	66	0	1	155	115	269	PREDICTED: Spodoptera frugiperda sporozoite surface protein 2 (LOC118265676), transcript variant X2, mRNA	blastn	23804	281	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
15489626	15489626	PRJNA1073005_P_NODE_9453_length_248_cov_0.880000_g9334_i0	PRJNA1073005	9453	248	0.88	2.1824	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	145	3.6e-30	NTclustered	gi\|2306732723\|ref\|XM_035601035.2\|	7108	g9334	i0	96.591	0.524193548387097	88	2	35	1	160	246	5122	5209	PREDICTED: Spodoptera frugiperda vinculin (LOC118280713), mRNA	blastn	130	145	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
15489627	15489627	PRJNA1073005_P_NODE_9633_length_246_cov_0.890173_g9514_i0	PRJNA1073005	9633	246	0.890173	2.18982558	Limulus polyphemus	6850	Arthropoda	Arthropoda	89.8	1.69e-13	NTclustered	gi\|1238848985\|ref\|XM_022386821.1\|	6850	g9514	i0	86.747	4.03658536585366	83	7	33	4	15	95	1755	1835	PREDICTED: Limulus polyphemus plasma membrane calcium-transporting ATPase 2-like (LOC106460173), mRNA	blastn	993	89.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Merostomata	Xiphosura	Limulidae	Limulus	Limulus polyphemus
16763904	16763904	PRJNA1073005_P_NODE_9154_length_250_cov_0.870056_g9035_i0	PRJNA1073005	9154	250	0.870056	2.17514	Agapeta hamana	1100904	Arthropoda	Arthropoda	54.7	0.006	NTclustered	gi\|2918370034\|emb\|OZ237962.1\|	1100904	g9035	i0	100	0.232	29	0	12	0	22	50	20233927	20233955	Agapeta hamana genome assembly, chromosome: 2	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Agapeta	Agapeta hamana
20588048	20588048	PRJNA1073005_P_NODE_8477_length_267_cov_0.974227_g8358_i0	PRJNA1073005	8477	267	0.974227	2.60118609	Tetranychus cinnabarinus	93129	Arthropoda	Arthropoda	209	1.37e-49	NTclustered	gi\|635174378\|gb\|KJ534396.1\|	93129	g8358	i0	83.043	48.4419475655431	230	39	86	0	24	253	517	746	Tetranychus cinnabarinus clone TcATP-synt_b_1 putative F0F1-type ATP synthase beta subunit mRNA, complete cds	blastn	12934	209	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus cinnabarinus
21418080	21418080	PRJNA1073005_P_NODE_9877_length_244_cov_1.777778_g9758_i0	PRJNA1073005	9877	244	1.777778	4.33777832	Eriocheir	95601	Arthropoda	Arthropoda	449	6.68e-122	NTclustered	gi\|2311877481\|ref\|XR_007745368.1\|	95602	g9758	i0	100	99.3073770491803	243	0	99	0	1	243	396	638	PREDICTED: Eriocheir sinensis large subunit ribosomal RNA (LOC126991277), rRNA	blastn	24231	449	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis
21863835	21863835	PRJNA1073005_P_NODE_6518_length_345_cov_2.264706_g6399_i0	PRJNA1073005	6518	345	2.264706	7.8132357	Metazoa	33208	Arthropoda	Arthropoda	199	3.7699999999999995e-57	NR	XP_059082377.1	6832	g6399	i0	79.1	39.8260869565217	115	23	100	1	345	1	628	741	XP_059082377.1 translation elongation factor 2-like [Tigriopus californicus]	diamond	13740	200	0.995	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
22692918	22692918	PRJNA1073005_P_NODE_7098_length_318_cov_1.710204_g6979_i0	PRJNA1073005	7098	318	1.710204	5.43844872	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	588	1.84e-163	NTclustered	gi\|669034645\|gb\|KJ729022.1\|	32264	g6979	i0	100	64.5471698113208	318	0	100	0	1	318	2932	2615	Tetranychus urticae mitochondrion, complete genome	blastn	20526	588	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
23139310	23139310	PRJNA1073005_P_NODE_9459_length_248_cov_0.880000_g9340_i0	PRJNA1073005	9459	248	0.88	2.1824	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	444	3.17e-120	NTclustered	gi\|2306777069\|ref\|XM_035593888.2\|	7108	g9340	i0	98.805	4.05645161290323	251	0	100	1	1	248	123	373	PREDICTED: Spodoptera frugiperda uncharacterized LOC118275808 (LOC118275808), transcript variant X3, mRNA	blastn	1006	444	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
23968372	23968372	PRJNA1073005_P_NODE_6939_length_326_cov_2.418972_g6820_i0	PRJNA1073005	6939	326	2.418972	7.88584872	Decapoda	6683	Arthropoda	Arthropoda	597	3.139999999999999e-166	NTclustered	gi\|29123218\|gb\|AY216710.1\|	40176	g6820	i0	99.693	99.9907975460123	326	1	100	0	1	326	11	336	Hemigrapsus sanguineus small subunit ribosomal RNA gene, complete sequence	blastn	32597	603	0.990049751243781	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Hemigrapsus	Hemigrapsus sanguineus
24412881	24412881	PRJNA1073005_P_NODE_6420_length_350_cov_4.555957_g6301_i0	PRJNA1073005	6420	350	4.555957	15.9458495	Eriocheir sinensis	95602	Arthropoda	Arthropoda	647	0	NTclustered	gi\|165909369\|gb\|EU373478.1\|	95602	g6301	i0	100	96.5085714285714	350	0	100	0	1	350	1453	1104	Eriocheir sinensis strain CJ1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	33778	647	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis
24412892	24412892	PRJNA1073005_P_NODE_8400_length_269_cov_1.484694_g8281_i0	PRJNA1073005	8400	269	1.484694	3.99382686	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	497	2.63e-136	NTclustered	gi\|2666121852\|gb\|PP230608.1\|	7108	g8281	i0	100	99.0334572490706	269	0	100	0	1	269	5057	4789	Spodoptera frugiperda isolate HR64 mitochondrion, complete genome	blastn	26640	497	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
25242270	25242270	PRJNA1073005_P_NODE_7340_length_309_cov_1.305085_g7221_i0	PRJNA1073005	7340	309	1.305085	4.03271265	Diptera	7147	Arthropoda	Arthropoda	235	2.67e-57	NTclustered	gi\|2202985638\|ref\|XM_023449373.2\|	7375	g7221	i0	84.979	108.750809061489	233	33	75	2	76	307	381	150	PREDICTED: Lucilia cuprina ubiquitin-60S ribosomal protein L40 (LOC111686969), mRNA	blastn	33604	235	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Calliphoridae	Lucilia	Lucilia cuprina
27532850	27532850	PRJNA1073005_P_NODE_9943_length_244_cov_0.900585_g9824_i0	PRJNA1073005	9943	244	0.900585	2.1974274	Metazoa	33208	Arthropoda	Arthropoda	115	1.34e-27	NR	KAJ6647572.1	35572	g9824	i0	70	40.5245901639344	80	17	98.4	1	1	240	489	561	KAJ6647572.1 RNA helicase aquarius, partial [Pseudolycoriella hygida]	diamond	9888	115	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Pseudolycoriella	Pseudolycoriella hygida
27564196	27564196	PRJNA1073005_P_NODE_144_length_2259_cov_6.845837_g129_i0	PRJNA1073005	144	2259	6.845837	154.64745783	Insecta	50557	Arthropoda	Arthropoda	103	1e-18	NR	KAG6464791.1	7130	g129	i0	27.9	3.0066401062417	305	188	37.5	10	925	1770	2	297	KAG6464791.1 hypothetical protein O3G_MSEX014731 [Manduca sexta]	diamond	6792	104	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Sphingidae	Manduca	Manduca sexta
27722728	27722728	PRJNA1073005_P_NODE_5204_length_415_cov_1.514620_g5085_i0	PRJNA1073005	5204	415	1.51462	6.285673	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	192	7.3e-59	NR	CAH0775837.1	7038	g5085	i0	69.6	47.8048192771084	135	39	96.1	1	17	415	14	148	CAH0775837.1 unnamed protein product [Bemisia tabaci]	diamond	19839	192	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
28015105	28015105	PRJNA1073005_P_NODE_9165_length_250_cov_0.870056_g9046_i0	PRJNA1073005	9165	250	0.870056	2.17514	Eurytemora carolleeae	1294199	Arthropoda	Arthropoda	46.6	0.0018	NR	XP_023344555.1	1294199	g9046	i0	35.3	0.612	51	33	61.2	0	30	182	447	497	XP_023344555.1 uncharacterized protein LOC111713829 [Eurytemora carolleeae]	diamond	153	46.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Calanoida	Temoridae	Eurytemora	Eurytemora carolleeae
29237980	29237980	PRJNA1073005_P_NODE_9929_length_244_cov_0.900585_g9810_i0	PRJNA1073005	9929	244	0.900585	2.1974274	Metazoa	33208	Arthropoda	Arthropoda	49.3	1.2e-4	NR	XP_030751531.1	7048	g9810	i0	38.8	4.10655737704918	67	40	82.4	1	41	241	81	146	XP_030751531.1 regulator of G-protein signaling 7-like [Sitophilus oryzae]	diamond	1002	49.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Sitophilus	Sitophilus oryzae
29972585	29972585	PRJNA1073005_P_NODE_6811_length_332_cov_1.189189_g6692_i0	PRJNA1073005	6811	332	1.189189	3.94810748	Allacma fusca	39272	Arthropoda	Arthropoda	111	8.03e-28	NR	CAG7723843.1	39272	g6692	i0	51.4	0.984939759036145	109	52	98.5	1	327	1	9	116	CAG7723843.1 unnamed protein product [Allacma fusca]	diamond	327	111	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Symphypleona	Sminthuridae	Allacma	Allacma fusca
30352305	30352305	PRJNA1073005_P_NODE_6492_length_347_cov_1.164234_g6373_i0	PRJNA1073005	6492	347	1.164234	4.03989198	Idotea baltica	82763	Arthropoda	Arthropoda	107	1.2e-26	NR	MCL4113740.1	82763	g6373	i0	55.8	0.821325648414986	95	41	81.3	1	283	2	7	101	MCL4113740.1 hypothetical protein [Idotea baltica]	diamond	285	107	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
30352306	30352306	PRJNA1073005_P_NODE_9292_length_249_cov_0.875000_g9173_i0	PRJNA1073005	9292	249	0.875	2.17875	Daphnia pulex	6669	Arthropoda	Arthropoda	53.5	1.11e-6	NR	EFX90100.1	6669	g9173	i0	35.4	1.95180722891566	79	44	86.7	2	240	25	35	113	EFX90100.1 hypothetical protein DAPPUDRAFT_40094 [Daphnia pulex]	diamond	486	53.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
30730875	30730875	PRJNA1073005_P_NODE_9874_length_244_cov_1.801170_g9755_i0	PRJNA1073005	9874	244	1.80117	4.3948548	Procambarus clarkii	6728	Arthropoda	Arthropoda	89.4	2.07e-19	NR	AXR98485.1	6728	g9755	i0	61.3	1.52459016393443	62	24	76.2	0	59	244	114	175	AXR98485.1 papain family cysteine protease, partial [Procambarus clarkii]	diamond	372	90.1	0.992230854605993	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
30785589	30785589	PRJNA1073005_P_NODE_10174_length_242_cov_1.124260_g10055_i0	PRJNA1073005	10174	242	1.12426	2.7207092	Opisthokonta	33154	Arthropoda	Arthropoda	80.5	4.94e-17	NR	XP_021952128.1	158441	g10055	i0	64.4	16.8223140495868	59	21	73.1	0	178	2	49	107	XP_021952128.1 40S ribosomal protein S12 [Folsomia candida]	diamond	4071	80.9	0.995055624227441	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Entomobryomorpha	Isotomidae	Folsomia	Folsomia candida
31164451	31164451	PRJNA1073005_P_NODE_9035_length_251_cov_0.865169_g8916_i0	PRJNA1073005	9035	251	0.865169	2.17157419	Insecta	50557	Arthropoda	Arthropoda	53.5	6.28e-6	NR	XP_063229579.1	93214	g8916	i0	43.2	3.77689243027888	74	35	87.3	3	8	226	338	405	XP_063229579.1 uncharacterized protein LOC134534858 isoform X2 [Bacillus rossius redtenbacheri]	diamond	948	53.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Bacillidae	Bacillus	Bacillus rossius
31521225	31521225	PRJNA1073005_P_NODE_8276_length_273_cov_1.540000_g8157_i0	PRJNA1073005	8276	273	1.54	4.2042	Oppia nitens	1686743	Arthropoda	Arthropoda	48.5	4.91e-4	NR	XP_054165495.1	1686743	g8157	i0	32.2	0.956043956043956	87	58	94.5	1	7	264	308	394	XP_054165495.1 peroxisomal N(1)-acetyl-spermine/spermidine oxidase-like isoform X2 [Oppia nitens]	diamond	261	48.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppia	Oppia nitens
31837230	31837230	PRJNA1073005_P_NODE_4197_length_487_cov_2.183575_g4078_i0	PRJNA1073005	4197	487	2.183575	10.63401025	Limulus polyphemus	6850	Arthropoda	Arthropoda	84.3	1.33e-15	NR	XP_013792674.1	6850	g4078	i0	40	1.61396303901437	125	65	73.9	4	126	485	16	135	XP_013792674.1 sequestosome-1-like [Limulus polyphemus]	diamond	786	84.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Merostomata	Xiphosura	Limulidae	Limulus	Limulus polyphemus
32018755	32018755	PRJNA1073005_P_NODE_8718_length_258_cov_1.291892_g8599_i0	PRJNA1073005	8718	258	1.291892	3.33308136	Vespula	7451	Arthropoda	Arthropoda	100	2e-22	NR	XP_050869787.1	7454	g8599	i0	54.8	11.7093023255814	84	38	97.7	0	256	5	439	522	XP_050869787.1 phenylalanine--tRNA ligase beta subunit [Vespula vulgaris]	diamond	3021	100	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Vespidae	Vespula	Vespula vulgaris
32690928	32690928	PRJNA1073005_P_NODE_6380_length_352_cov_1.666667_g6261_i0	PRJNA1073005	6380	352	1.666667	5.86666784	Schistocerca gregaria	7010	Arthropoda	Arthropoda	109	6.75e-26	NR	XP_049850989.1	7010	g6261	i0	52.6	0.988636363636364	116	54	98.9	1	3	350	12	126	XP_049850989.1 uncharacterized protein LOC126324525 [Schistocerca gregaria]	diamond	348	109	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria

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