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

59 rows where bioproject = "PRJNA554794" 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
2398758	2398758	PRJNA554794_P_NODE_12282_length_280_cov_0.909091_g8353_i0	PRJNA554794	12282	280	0.909091	2.5454548	Opisthokonta	33154	Arthropoda	Arthropoda	149	4.3e-44	NR	OTF82201.1	6958	g8353	i0	75.3	65.7535714285714	93	23	99.6	0	1	279	3	95	OTF82201.1 40S ribosomal protein S18-like protein [Euroglyphus maynei]	diamond	18411	149	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Euroglyphus	Euroglyphus maynei
2399000	2399000	PRJNA554794_P_NODE_24522_length_161_cov_1.053571_g20593_i0	PRJNA554794	24522	161	1.053571	1.69624931	Lucilia	7374	Arthropoda	Arthropoda	104	3.64e-18	NTclustered	gi\|2203009945\|ref\|XM_023439305.2\|	7375	g20593	i0	81.343	4.3416149068323	134	19	81	5	30	160	413	283	PREDICTED: Lucilia cuprina 40S ribosomal protein S3 (LOC111678069), mRNA	blastn	699	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Calliphoridae	Lucilia	Lucilia cuprina
3674892	3674892	PRJNA554794_P_NODE_24163_length_162_cov_0.902655_g20234_i0	PRJNA554794	24163	162	0.902655	1.4623011	Eriocheir sinensis	95602	Arthropoda	Arthropoda	97.4	6.67e-22	NR	XP_050706876.1	95602	g20234	i0	71.7	10.5925925925926	53	15	98.1	0	2	160	361	413	XP_050706876.1 maltase-glucoamylase-like isoform X2 [Eriocheir sinensis]	diamond	1716	97.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis
4348019	4348019	PRJNA554794_P_NODE_19964_length_202_cov_1.320261_g16035_i0	PRJNA554794	19964	202	1.320261	2.66692722	Artemia franciscana	6661	Arthropoda	Arthropoda	296	7.36e-76	NTclustered	gi\|2743025003\|ref\|XR_010621486.1\|	6661	g16035	i0	93.069	21.1980198019802	202	14	100	0	1	202	489	690	PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA	blastn	4282	296	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
5624774	5624774	PRJNA554794_P_NODE_21765_length_176_cov_1.629921_g17836_i0	PRJNA554794	21765	176	1.629921	2.86866096	Tigriopus californicus	6832	Arthropoda	Arthropoda	69.4	1.47e-7	NTclustered	gi\|2571333329\|ref\|XM_059228596.1\|	6832	g17836	i0	90.385	1.47727272727273	52	5	30	0	115	166	1009	958	PREDICTED: Tigriopus californicus uncharacterized LOC131881664 (LOC131881664), transcript variant X2, mRNA	blastn	260	69.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
6898795	6898795	PRJNA554794_P_NODE_14626_length_217_cov_1.089286_g10697_i0	PRJNA554794	14626	217	1.089286	2.36375062	Schistocerca gregaria	7010	Arthropoda	Arthropoda	116	1.9099999999999997e-30	NR	XP_049850721.1	7010	g10697	i0	72.2	7.963133640553	72	20	99.5	0	2	217	101	172	XP_049850721.1 uncharacterized protein LOC126323765 [Schistocerca gregaria]	diamond	1728	116	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria
6898827	6898827	PRJNA554794_P_NODE_21066_length_185_cov_1.139706_g17137_i0	PRJNA554794	21066	185	1.139706	2.1084561	Orussus abietinus	222816	Arthropoda	Arthropoda	193	8.919999999999999e-45	NTclustered	gi\|1317995991\|ref\|XM_012424317.2\|	222816	g17137	i0	85.714	92.6162162162162	182	26	98	0	4	185	479	298	PREDICTED: Orussus abietinus dynein light chain 2, cytoplasmic (LOC105699386), mRNA	blastn	17134	193	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Orussidae	Orussus	Orussus abietinus
7501649	7501649	PRJNA554794_P_NODE_20506_length_193_cov_1.138889_g16577_i0	PRJNA554794	20506	193	1.138889	2.19805577	Amphipoda	6821	Arthropoda	Arthropoda	110	1.62e-28	NR	KAA0197699.1	294128	g16577	i0	77.8	2.93782383419689	63	14	97.9	0	190	2	36	98	KAA0197699.1 hypothetical protein HAZT_HAZT010610, partial [Hyalella azteca]	diamond	567	110	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Amphipoda	Hyalellidae	Hyalella	Hyalella azteca
8173649	8173649	PRJNA554794_P_NODE_14687_length_216_cov_0.802395_g10758_i0	PRJNA554794	14687	216	0.802395	1.7331732	Metazoa	33208	Arthropoda	Arthropoda	102	6.93e-25	NR	TRY62750.1	6832	g10758	i0	73	2.625	63	17	87.5	0	216	28	156	218	TRY62750.1 hypothetical protein TCAL_04938, partial [Tigriopus californicus]	diamond	567	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
8173695	8173695	PRJNA554794_P_NODE_22847_length_166_cov_0.871795_g18918_i0	PRJNA554794	22847	166	0.871795	1.4471797	Pieris napi	78633	Arthropoda	Arthropoda	63.9	6.42e-6	NTclustered	gi\|2220890286\|ref\|XM_047666315.1\|	78633	g18918	i0	95.122	4.95783132530121	41	0	24	1	15	53	1381	1421	PREDICTED: Pieris napi putative per-hexamer repeat protein 5 (LOC125061103), transcript variant X3, mRNA	blastn	823	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pieridae	Pieris	Pieris napi
8173721	8173721	PRJNA554794_P_NODE_9567_length_429_cov_1.163158_g5733_i0	PRJNA554794	9567	429	1.163158	4.98994782	Reduviidae	27479	Arthropoda	Arthropoda	162	3.2399999999999998e-46	NR	KAK9498923.1	488301	g5733	i0	62.8	2.51748251748252	121	44	83.9	1	68	427	114	234	KAK9498923.1 hypothetical protein O3M35_003464 [Rhynocoris fuscipes]	diamond	1080	162	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Reduviidae	Rhynocoris	Rhynocoris fuscipes
9449281	9449281	PRJNA554794_P_NODE_14268_length_224_cov_1.428571_g10339_i0	PRJNA554794	14268	224	1.428571	3.19999904	Idotea baltica	82763	Arthropoda	Arthropoda	138	6.67e-40	NR	MCL4119274.1	82763	g10339	i0	91.9	1.98214285714286	74	6	99.1	0	222	1	28	101	MCL4119274.1 hypothetical protein [Idotea baltica]	diamond	444	138	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
9449357	9449357	PRJNA554794_P_NODE_9748_length_416_cov_1.032698_g5892_i0	PRJNA554794	9748	416	1.032698	4.29602368	Tetranychus urticae	32264	Arthropoda	Arthropoda	63.9	1.85e-5	NTclustered	gi\|1390648244\|ref\|XM_015930162.2\|	32264	g5892	i0	89.796	1.13701923076923	49	5	12	0	48	96	451	499	PREDICTED: Tetranychus urticae cathepsin L1 (LOC107363003), mRNA	blastn	473	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
11999833	11999833	PRJNA554794_P_NODE_15470_length_210_cov_1.322981_g11541_i0	PRJNA554794	15470	210	1.322981	2.7782601	Drosophila obscura	7282	Arthropoda	Arthropoda	148	2.2799999999999997e-31	NTclustered	gi\|2038062354\|ref\|XM_022363539.2\|	7282	g11541	i0	90.909	46.1571428571429	110	10	52	0	77	186	2519	2410	PREDICTED: Drosophila obscura eukaryotic translation elongation factor 2 (LOC111071977), mRNA	blastn	9693	148	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila obscura
14549947	14549947	PRJNA554794_P_NODE_19912_length_203_cov_1.305195_g15983_i0	PRJNA554794	19912	203	1.305195	2.64954585	Opisthokonta	33154	Arthropoda	Arthropoda	118	6.19e-29	NR	XP_059094847.1	6832	g15983	i0	80.6	50.3645320197044	67	13	99	0	201	1	1349	1415	XP_059094847.1 LOW QUALITY PROTEIN: bifunctional glutamate/proline--tRNA ligase-like [Tigriopus californicus]	diamond	10224	118	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
17098473	17098473	PRJNA554794_P_NODE_12394_length_277_cov_1.070175_g8465_i0	PRJNA554794	12394	277	1.070175	2.96438475	Hermetia illucens	343691	Arthropoda	Arthropoda	172	1.87e-38	NTclustered	gi\|1941237557\|ref\|XM_038058799.1\|	343691	g8465	i0	81.951	4.17328519855596	205	35	74	2	1	204	398	195	PREDICTED: Hermetia illucens 40S ribosomal protein S23 (LOC119653793), mRNA	blastn	1156	172	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Stratiomyidae	Hermetia	Hermetia illucens
17098532	17098532	PRJNA554794_P_NODE_24534_length_161_cov_0.919643_g20605_i0	PRJNA554794	24534	161	0.919643	1.48062523	Macrosteles quadrilineatus	74068	Arthropoda	Arthropoda	100	4.71e-17	NTclustered	gi\|2463282423\|ref\|XM_054432459.1\|	74068	g20605	i0	93.939	36.7701863354037	66	4	41	0	27	92	1603	1538	PREDICTED: Macrosteles quadrilineatus heat shock 70 kDa protein cognate 4 (LOC129004070), transcript variant X3, mRNA	blastn	5920	100	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Macrosteles	Macrosteles quadrilineatus
18372691	18372691	PRJNA554794_P_NODE_23795_length_163_cov_0.894737_g19866_i0	PRJNA554794	23795	163	0.894737	1.45842131	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	285	1.23e-72	NTclustered	gi\|78097483\|gb\|AC167561.3\|	7176	g19866	i0	98.16	42.3496932515337	163	3	100	0	1	163	53321	53159	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940117D9, complete sequence	blastn	6903	285	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
19647297	19647297	PRJNA554794_P_NODE_22996_length_166_cov_0.863248_g19067_i0	PRJNA554794	22996	166	0.863248	1.43299168	Artemia franciscana	6661	Arthropoda	Arthropoda	193	7.85e-45	NTclustered	gi\|2743025299\|ref\|XM_065727981.1\|	6661	g19067	i0	89.61	0.927710843373494	154	13	92	2	1	152	3729	3881	PREDICTED: Artemia franciscana piwi-like protein 1 (LOC136043066), transcript variant X1, mRNA	blastn	154	193	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
20923058	20923058	PRJNA554794_P_NODE_14177_length_226_cov_1.706215_g10248_i0	PRJNA554794	14177	226	1.706215	3.8560459	Daphnia pulex	6669	Arthropoda	Arthropoda	142	1.39e-39	NR	EFX60189.1	6669	g10248	i0	100	0.982300884955752	74	0	98.2	0	224	3	132	205	EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex]	diamond	222	142	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
20923059	20923059	PRJNA554794_P_NODE_14397_length_221_cov_2.406977_g10468_i0	PRJNA554794	14397	221	2.406977	5.31941917	Helicoverpa assulta	52344	Arthropoda	Arthropoda	52.8	0.02	NTclustered	gi\|2636206755\|emb\|OY979781.1\|	52344	g10468	i0	100	0.126696832579186	28	0	13	0	129	156	8315215	8315242	Helicoverpa assulta genome assembly, chromosome: 7	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Helicoverpa	Helicoverpa assulta
20923093	20923093	PRJNA554794_P_NODE_20817_length_188_cov_2.446043_g16888_i0	PRJNA554794	20817	188	2.446043	4.59856084	Dyschiriodes sp. 63_EN	1055885	Arthropoda	Arthropoda	93.5	9.49e-15	NTclustered	gi\|340807426\|gb\|JF778824.1\|	1055885	g16888	i0	85.87	33.3244680851064	92	7	47	5	15	103	929	841	Dyschiriodes sp. 63_EN large subunit ribosomal RNA gene, partial sequence	blastn	6265	93.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Carabidae	Dyschiriodes	Dyschiriodes sp. 63_EN
20923095	20923095	PRJNA554794_P_NODE_21357_length_181_cov_1.606061_g17428_i0	PRJNA554794	21357	181	1.606061	2.90697041	Calybites phasianipennella	796989	Arthropoda	Arthropoda	141	3.19e-29	NTclustered	gi\|1049595438\|dbj\|LC127980.1\|	796989	g17428	i0	81.143	60.1823204419889	175	33	97	0	1	175	324	498	Calybites phasianipennella gene for elongation factor-1 alpha, partial cds, isolate: RN26	blastn	10893	141	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Gracillariidae	Calybites	Calybites phasianipennella
21525595	21525595	PRJNA554794_P_NODE_22517_length_167_cov_5.940678_g18588_i0	PRJNA554794	22517	167	5.940678	9.92093226	root	1	Root_unresolved	Root_unresolved	60.2	8.37e-5	NTclustered	gi\|2864127362\|ref\|XM_070117547.1\|	6689	g18588	i0	100	1.91017964071856	32	0	19	0	110	141	11	42	PREDICTED: Penaeus vannamei HECT, UBA and WWE domain containing E3 ubiquitin protein ligase 1 (HUWE1), transcript variant X6, mRNA	blastn	319	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
21525609	21525609	PRJNA554794_P_NODE_23437_length_164_cov_0.973913_g19508_i0	PRJNA554794	23437	164	0.973913	1.59721732	Anastrepha	28585	Arthropoda	Arthropoda	73.1	1.05e-8	NTclustered	gi\|2453225557\|ref\|XM_054106513.1\|	28586	g19508	i0	88.333	1.6280487804878	60	7	37	0	12	71	444	503	PREDICTED: Anastrepha ludens 40S ribosomal protein S16 (LOC128866044), mRNA	blastn	267	73.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Anastrepha	Anastrepha ludens
22197803	22197803	PRJNA554794_P_NODE_20898_length_187_cov_1.260870_g16969_i0	PRJNA554794	20898	187	1.26087	2.3578269	Bombyx mori	7091	Arthropoda	Arthropoda	60.2	9.57e-5	NTclustered	gi\|2919985619\|emb\|OZ208592.1\|	7091	g16969	i0	97.143	0.18716577540107	35	1	19	0	34	68	8289332	8289298	Bombyx mori genome assembly, chromosome: 14	blastn	35	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
23473368	23473368	PRJNA554794_P_NODE_20079_length_200_cov_1.033113_g16150_i0	PRJNA554794	20079	200	1.033113	2.066226	Arthropoda	6656	Arthropoda	Arthropoda	99	1.3999999999999999e-24	NR	KAI2807530.1	40697	g16150	i0	70.5	5.595	61	18	91.5	0	198	16	36	96	KAI2807530.1 ribosomal 40S subunit protein S10A [Blomia tropicalis]	diamond	1119	99.4	0.995975855130785	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Echimyopodidae	Blomia	Blomia tropicalis
23473379	23473379	PRJNA554794_P_NODE_22039_length_173_cov_1.225806_g18110_i0	PRJNA554794	22039	173	1.225806	2.12064438	Leguminivora glycinivorella	1035111	Arthropoda	Arthropoda	128	2.35e-25	NTclustered	gi\|2237301641\|ref\|XM_048145146.1\|	1035111	g18110	i0	85.484	4.15028901734104	124	16	71	2	47	169	392	514	PREDICTED: Leguminivora glycinivorella 60S ribosomal protein L7 (LOC125237910), mRNA	blastn	718	128	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Leguminivora	Leguminivora glycinivorella
24747112	24747112	PRJNA554794_P_NODE_12320_length_279_cov_1.030435_g8391_i0	PRJNA554794	12320	279	1.030435	2.87491365	Ornithodoros turicata	34597	Arthropoda	Arthropoda	183	8.73e-42	NTclustered	gi\|2720960512\|ref\|XM_064625776.1\|	34597	g8391	i0	84.127	23.6200716845878	189	30	68	0	39	227	146	334	PREDICTED: Ornithodoros turicata V-type proton ATPase 16 kDa proteolipid subunit c-like (LOC135394791), mRNA	blastn	6590	183	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Argasidae	Ornithodoros	Ornithodoros turicata
24747147	24747147	PRJNA554794_P_NODE_20200_length_198_cov_1.187919_g16271_i0	PRJNA554794	20200	198	1.187919	2.35207962	Apidae	7458	Arthropoda	Arthropoda	122	4.1e-32	NR	XP_012174989.1	30195	g16271	i0	84.8	60	66	10	100	0	198	1	149	214	XP_012174989.1 40S ribosomal protein S2 isoform X1 [Bombus terrestris]	diamond	11880	122	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus terrestris
26761634	26761634	PRJNA554794_P_NODE_23661_length_164_cov_0.869565_g19732_i0	PRJNA554794	23661	164	0.869565	1.4260866	Carabus blaptoides fortunei	49296	Arthropoda	Arthropoda	64.7	2.26e-10	NR	GLV44186.1	49296	g19732	i0	61.7	4.40853658536585	47	18	86	0	2	142	352	398	GLV44186.1 poly(A) binding protein [Carabus blaptoides fortunei]	diamond	723	64.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Carabidae	Carabus	Carabus blaptoides
26934586	26934586	PRJNA554794_P_NODE_24302_length_162_cov_0.893805_g20373_i0	PRJNA554794	24302	162	0.893805	1.4479641	Arthropoda	6656	Arthropoda	Arthropoda	60.8	4.87e-9	NR	XP_044570346.1	7217	g20373	i0	56.4	47.8703703703704	55	23	100	1	1	162	74	128	XP_044570346.1 RNA-binding protein Musashi homolog Rbp6 isoform X3 [Drosophila ananassae]	diamond	7755	61.2	0.993464052287582	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila ananassae
27078247	27078247	PRJNA554794_P_NODE_23482_length_164_cov_0.886957_g19553_i0	PRJNA554794	23482	164	0.886957	1.45460948	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	54.3	1.06e-6	NR	CAD7620960.1	1979941	g19553	i0	41.4	4.97560975609756	58	29	97	2	5	163	1022	1079	CAD7620960.1 unnamed protein product [Medioppia subpectinata]	diamond	816	54.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
27710505	27710505	PRJNA554794_P_NODE_14684_length_216_cov_1.107784_g10755_i0	PRJNA554794	14684	216	1.107784	2.39281344	Schistocerca gregaria	7010	Arthropoda	Arthropoda	93.6	2.77e-21	NR	XP_049849682.1	7010	g10755	i0	66.2	0.902777777777778	65	22	90.3	0	11	205	106	170	XP_049849682.1 coronin-A-like [Schistocerca gregaria]	diamond	195	93.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria
28183423	28183423	PRJNA554794_P_NODE_10486_length_365_cov_1.484177_g6586_i0	PRJNA554794	10486	365	1.484177	5.41724605	Daphnia pulex	6669	Arthropoda	Arthropoda	144	1.6e-40	NR	EFX61295.1	6669	g6586	i0	80	0.780821917808219	95	12	72.3	1	365	102	1	95	EFX61295.1 hypothetical protein DAPPUDRAFT_274173, partial [Daphnia pulex]	diamond	285	144	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
28467991	28467991	PRJNA554794_P_NODE_22126_length_172_cov_1.463415_g18197_i0	PRJNA554794	22126	172	1.463415	2.5170738	Molorchus minor	1323400	Arthropoda	Arthropoda	47	4.47e-4	NR	KAJ8984234.1	1323400	g18197	i0	38.6	0.994186046511628	57	34	99.4	1	172	2	174	229	KAJ8984234.1 hypothetical protein NQ317_007466 [Molorchus minor]	diamond	171	47	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Cerambycidae	Molorchus	Molorchus minor
28545795	28545795	PRJNA554794_P_NODE_24607_length_161_cov_0.910714_g20678_i0	PRJNA554794	24607	161	0.910714	1.46624954	Opisthokonta	33154	Arthropoda	Arthropoda	87.4	1.06e-20	NR	NP_001292408.1	51655	g20678	i0	88.9	7.52795031055901	45	5	83.9	0	3	137	64	108	NP_001292408.1 cytochrome c [Plutella xylostella]	diamond	1212	87.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Plutellidae	Plutella	Plutella xylostella
28625871	28625871	PRJNA554794_P_NODE_23267_length_165_cov_0.870690_g19338_i0	PRJNA554794	23267	165	0.87069	1.4366385	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	50.4	1.77e-5	NR	KAH9406993.1	59818	g19338	i0	96.3	0.490909090909091	27	1	49.1	0	84	164	13	39	KAH9406993.1 Receptor expression-enhancing protein 5 [Tyrophagus putrescentiae]	diamond	81	50.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
28689073	28689073	PRJNA554794_P_NODE_13747_length_237_cov_1.473404_g9818_i0	PRJNA554794	13747	237	1.473404	3.49196748	Coptotermes formosanus	36987	Arthropoda	Arthropoda	60.8	4.1e-9	NR	AEW67355.1	36987	g9818	i0	59.5	0.531645569620253	42	17	53.2	0	226	101	86	127	AEW67355.1 carbohydrate binding module, partial [Coptotermes formosanus]	diamond	126	60.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Rhinotermitidae	Coptotermes	Coptotermes formosanus
28829615	28829615	PRJNA554794_P_NODE_11828_length_297_cov_0.818548_g7899_i0	PRJNA554794	11828	297	0.818548	2.43108756	Opisthokonta	33154	Arthropoda	Arthropoda	81.3	8.32e-17	NR	XP_049849606.1	7010	g7899	i0	47	1.98989898989899	100	44	91.9	1	25	297	1	100	XP_049849606.1 uncharacterized protein LOC126319936 [Schistocerca gregaria]	diamond	591	81.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria
28829616	28829616	PRJNA554794_P_NODE_12968_length_259_cov_0.971429_g9039_i0	PRJNA554794	12968	259	0.971429	2.51600111	Lepidoptera	7088	Arthropoda	Arthropoda	63.5	1.79e-9	NR	CAG4972968.1	42296	g9039	i0	42.9	2.46718146718147	70	39	81.1	1	238	29	41	109	CAG4972968.1 unnamed protein product [Colias eurytheme]	diamond	639	63.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pieridae	Colias	Colias eurytheme
29019460	29019460	PRJNA554794_P_NODE_13828_length_235_cov_0.994624_g9899_i0	PRJNA554794	13828	235	0.994624	2.3373664	Metazoa	33208	Arthropoda	Arthropoda	105	3.27e-26	NR	VVC25385.1	506608	g9899	i0	71.8	19.3404255319149	71	20	90.6	0	222	10	118	188	VVC25385.1 Hypothetical protein CINCED_3A007389 [Cinara cedri]	diamond	4545	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Cinara	Cinara cedri
29208783	29208783	PRJNA554794_P_NODE_22469_length_168_cov_1.277311_g18540_i0	PRJNA554794	22469	168	1.277311	2.14588248	root	1	Root_unresolved	Root_unresolved	101	1.4600000000000002e-26	NR	EEC04179.1	6945	g18540	i0	80.4	14.9642857142857	56	11	100	0	168	1	3	58	EEC04179.1 ribosomal protein L37A, putative, partial [Ixodes scapularis]	diamond	2514	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Ixodes	Ixodes scapularis
29303295	29303295	PRJNA554794_P_NODE_11189_length_327_cov_1.161871_g7263_i0	PRJNA554794	11189	327	1.161871	3.79931817	Arthropoda	6656	Arthropoda	Arthropoda	116	5.829999999999999e-31	NR	QYL00110.1	77651	g7263	i0	53.6	4.10091743119266	112	45	99.1	3	327	4	4	112	QYL00110.1 GPX, partial [Simocephalus vetulus]	diamond	1341	116	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Simocephalus	Simocephalus vetulus
29698805	29698805	PRJNA554794_P_NODE_10030_length_397_cov_0.862069_g6156_i0	PRJNA554794	10030	397	0.862069	3.42241393	Schistocerca gregaria	7010	Arthropoda	Arthropoda	124	2.24e-33	NR	XP_049851025.1	7010	g6156	i0	55.6	1.57934508816121	108	47	80.9	1	4	324	33	140	XP_049851025.1 uncharacterized protein LOC126324550 [Schistocerca gregaria]	diamond	627	124	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria
29920439	29920439	PRJNA554794_P_NODE_13091_length_255_cov_1.247573_g9162_i0	PRJNA554794	13091	255	1.247573	3.18131115	Acanthoscelides obtectus	200917	Arthropoda	Arthropoda	69.3	1.14e-11	NR	CAH1971731.1	200917	g9162	i0	53.1	1.89411764705882	81	32	95.3	2	3	245	166	240	CAH1971731.1 unnamed protein product [Acanthoscelides obtectus]	diamond	483	69.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Acanthoscelides	Acanthoscelides obtectus
29935019	29935019	PRJNA554794_P_NODE_19851_length_204_cov_1.393548_g15922_i0	PRJNA554794	19851	204	1.393548	2.84283792	Arthropoda	6656	Arthropoda	Arthropoda	102	1.5299999999999999e-24	NR	XP_026480605.1	7515	g15922	i0	75	22	68	16	98.5	1	203	3	45	112	XP_026480605.1 40S ribosomal protein S3a [Ctenocephalides felis]	diamond	4488	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Siphonaptera	Pulicidae	Ctenocephalides	Ctenocephalides felis
30629779	30629779	PRJNA554794_P_NODE_19913_length_203_cov_1.214286_g15984_i0	PRJNA554794	19913	203	1.214286	2.46500058	Metazoa	33208	Arthropoda	Arthropoda	104	4.86e-27	NR	XP_037278529.1	6941	g15984	i0	75.8	81.9753694581281	66	16	97.5	0	2	199	36	101	XP_037278529.1 40S ribosomal protein S25-like [Rhipicephalus microplus]	diamond	16641	105	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
30678378	30678378	PRJNA554794_P_NODE_23093_length_165_cov_0.974138_g19164_i0	PRJNA554794	23093	165	0.974138	1.6073277	Brenthis ino	405034	Arthropoda	Arthropoda	65.1	1.38e-10	NR	CAH0726215.1	405034	g19164	i0	68.3	2.21818181818182	41	13	74.5	0	163	41	285	325	CAH0726215.1 unnamed protein product, partial [Brenthis ino]	diamond	366	65.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Brenthis	Brenthis ino
30693066	30693066	PRJNA554794_P_NODE_23693_length_164_cov_0.860870_g19764_i0	PRJNA554794	23693	164	0.86087	1.4118268	Insecta	50557	Arthropoda	Arthropoda	92.4	9.890000000000002e-21	NR	XP_969526.2	7070	g19764	i0	74.1	9.87804878048781	54	14	98.8	0	1	162	12	65	XP_969526.2 aldo-keto reductase family 1 member B1 [Tribolium castaneum]	diamond	1620	93.2	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum
30836513	30836513	PRJNA554794_P_NODE_21534_length_179_cov_0.861538_g17605_i0	PRJNA554794	21534	179	0.861538	1.54215302	Daphnia pulex	6669	Arthropoda	Arthropoda	115	1.91e-29	NR	EFX60189.1	6669	g17605	i0	100	0.988826815642458	59	0	98.9	0	177	1	238	296	EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex]	diamond	177	115	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
31072374	31072374	PRJNA554794_P_NODE_19915_length_203_cov_0.980519_g15986_i0	PRJNA554794	19915	203	0.980519	1.99045357	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	63.9	7.2e-10	NR	XP_022214517.2	7282	g15986	i0	44.4	1.77339901477833	54	30	79.8	0	167	6	329	382	XP_022214517.2 lysosomal aspartic protease [Drosophila obscura]	diamond	360	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila obscura
31247277	31247277	PRJNA554794_P_NODE_21375_length_181_cov_0.916667_g17446_i0	PRJNA554794	21375	181	0.916667	1.65916727	Caerostris darwini	1538125	Arthropoda	Arthropoda	62.4	4.5e-10	NR	GIY73251.1	1538125	g17446	i0	59.2	0.812154696132597	49	20	81.2	0	27	173	48	96	GIY73251.1 microsomal glutathione S-transferase 3 [Caerostris darwini]	diamond	147	62.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Caerostris	Caerostris darwini
31310486	31310486	PRJNA554794_P_NODE_13375_length_247_cov_1.202020_g9446_i0	PRJNA554794	13375	247	1.20202	2.9689894	Procambarus clarkii	6728	Arthropoda	Arthropoda	106	6.42e-26	NR	AXR98485.1	6728	g9446	i0	63	0.983805668016194	81	29	98.4	1	245	3	102	181	AXR98485.1 papain family cysteine protease, partial [Procambarus clarkii]	diamond	243	106	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
31373964	31373964	PRJNA554794_P_NODE_12396_length_277_cov_1.017544_g8467_i0	PRJNA554794	12396	277	1.017544	2.81859688	Copidosoma floridanum	29053	Arthropoda	Arthropoda	60.1	3.52e-8	NR	XP_014205260.1	29053	g8467	i0	71.4	2.26353790613718	42	12	45.5	0	152	277	170	211	XP_014205260.1 60S ribosomal protein L23a [Copidosoma floridanum]	diamond	627	60.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Encyrtidae	Copidosoma	Copidosoma floridanum
32228135	32228135	PRJNA554794_P_NODE_22118_length_172_cov_1.764228_g18189_i0	PRJNA554794	22118	172	1.764228	3.03447216	Pseudodiaptomus poplesia	213370	Arthropoda	Arthropoda	59.7	1.42e-9	NR	ALS04824.1	213370	g18189	i0	61.8	2.87790697674419	55	21	95.9	0	170	6	68	122	ALS04824.1 60S ribosomal protein L35 [Pseudodiaptomus poplesia]	diamond	495	59.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Calanoida	Pseudodiaptomidae	Pseudodiaptomus	Pseudodiaptomus poplesia
32513065	32513065	PRJNA554794_P_NODE_24559_length_161_cov_0.910714_g20630_i0	PRJNA554794	24559	161	0.910714	1.46624954	Homarus americanus	6706	Arthropoda	Arthropoda	50.1	3.12e-5	NR	XP_042234569.1	6706	g20630	i0	59.5	1.54658385093168	42	16	78.3	1	154	29	88	128	XP_042234569.1 zinc finger protein-like 1 homolog [Homarus americanus]	diamond	249	50.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Nephropidae	Homarus	Homarus americanus
32638623	32638623	PRJNA554794_P_NODE_12240_length_281_cov_1.426724_g8311_i0	PRJNA554794	12240	281	1.426724	4.00909444	Notodromas monacha	399045	Arthropoda	Arthropoda	43.9	0.0201	NR	CAD7277191.1	399045	g8311	i0	35.1	0.608540925266904	57	33	60.9	1	212	42	131	183	CAD7277191.1 unnamed protein product [Notodromas monacha]	diamond	171	43.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cyprididae	Notodromas	Notodromas monacha
32716432	32716432	PRJNA554794_P_NODE_22380_length_169_cov_0.941667_g18451_i0	PRJNA554794	22380	169	0.941667	1.59141723	root	1	Root_unresolved	Root_unresolved	80.9	4.64e-18	NR	MCL4116028.1	82763	g18451	i0	73.1	3.79881656804734	52	14	92.3	0	156	1	1	52	MCL4116028.1 hypothetical protein [Idotea baltica]	diamond	642	80.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica

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