metadata: contig_metadata: 53 rows where analysis = "blastn", bioproject = "PRJNA951388" and tax

53 rows where analysis = "blastn", bioproject = "PRJNA951388" 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
934761	934761	PRJNA951388_S_NODE_12501_length_220_cov_10.945578_g12374_i0	PRJNA951388	12501	220	10.945578	24.0802716	Bombus monticola	103936	Arthropoda	Arthropoda	54.7	0.005	NTclustered	gi\|2919524519\|emb\|OZ238329.1\|	103936	g12374	i0	100	0.131818181818182	29	0	13	0	1	29	2951200	2951172	Bombus monticola genome assembly, chromosome: 7	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus monticola
934774	934774	PRJNA951388_S_NODE_4741_length_384_cov_1.784566_g4614_i0	PRJNA951388	4741	384	1.784566	6.85273344	Anthonomus grandis	7044	Arthropoda	Arthropoda	52.8	0.037	NTclustered	gi\|2293514322\|ref\|XR_007663146.1\|	2921223	g4614	i0	100	0.0729166666666667	28	0	7	0	25	52	308	281	PREDICTED: Anthonomus grandis grandis uncharacterized LOC126744397 (LOC126744397), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Anthonomus	Anthonomus grandis
934778	934778	PRJNA951388_S_NODE_5241_length_367_cov_3.391156_g5114_i0	PRJNA951388	5241	367	3.391156	12.44554252	Penaeus monodon	6687	Arthropoda	Arthropoda	54.7	0.01	NTclustered	gi\|1832334880\|gb\|MK599468.1\|	6687	g5114	i0	100	0.307901907356948	29	0	8	0	339	367	115	87	Penaeus monodon C-type lectin mRNA, complete cds	blastn	113	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus monodon
934789	934789	PRJNA951388_S_NODE_881_length_683_cov_77.921311_g767_i0	PRJNA951388	881	683	77.921311	532.20255413	Microplitis mediator	375433	Arthropoda	Arthropoda	431	7.49e-116	NTclustered	gi\|2520952473\|ref\|XM_057476662.1\|	375433	g767	i0	80.236	87.2547584187408	592	101	86	13	1	584	688	1271	PREDICTED: Microplitis mediator actin-5C (LOC130672231), transcript variant X1, mRNA	blastn	59595	431	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Microplitis	Microplitis mediator
2210034	2210034	PRJNA951388_S_NODE_5582_length_358_cov_4.561404_g5455_i0	PRJNA951388	5582	358	4.561404	16.32982632	Timema californicum	61474	Arthropoda	Arthropoda	52.8	0.034	NTclustered	gi\|1962683356\|emb\|OE185345.1\|	61474	g5455	i0	100	0.0782122905027933	28	0	8	0	258	285	6388	6361	2_Tcm_b3v08	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
2210036	2210036	PRJNA951388_S_NODE_5722_length_354_cov_2.608541_g5595_i0	PRJNA951388	5722	354	2.608541	9.23423514	Orchesella villosa	48706	Arthropoda	Arthropoda	303	8.37e-78	NTclustered	gi\|171473571\|ref\|NC_010534.1\|	48706	g5595	i0	82.451	57.7542372881356	359	51	99	11	1	353	12610	12962	Orchesella villosa mitochondrion, complete genome	blastn	20445	303	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Entomobryomorpha	Orchesellidae	Orchesella	Orchesella villosa
2538423	2538423	PRJNA951388_S_NODE_5142_length_370_cov_3.589226_g5015_i0	PRJNA951388	5142	370	3.589226	13.2801362	root	1	Root_unresolved	Root_unresolved	52.8	0.035	NTclustered	gi\|1184387702\|emb\|LT835105.1\|	85552	g5015	i0	100	0.227027027027027	28	0	8	0	1	28	6	33	Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene)	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Scylla	Scylla paramamosain
3485408	3485408	PRJNA951388_S_NODE_123_length_1349_cov_91.926332_g80_i0	PRJNA951388	123	1349	91.926332	1240.08621868	Anastrepha ludens	28586	Arthropoda	Arthropoda	597	1.4099999999999995e-165	NTclustered	gi\|2453197034\|ref\|XM_054093020.1\|	28586	g80	i0	79.951	60.0244625648629	823	155	61	10	524	1341	1322	505	PREDICTED: Anastrepha ludens actin, cytoplasmic A3a (LOC128857310), transcript variant X3, mRNA	blastn	80973	597	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Anastrepha	Anastrepha ludens
3485410	3485410	PRJNA951388_S_NODE_12903_length_209_cov_4.036765_g12776_i0	PRJNA951388	12903	209	4.036765	8.4368388499999991	Diabrotica virgifera	50389	Arthropoda	Arthropoda	60.2	1.1e-4	NTclustered	gi\|2305201476\|ref\|XM_028295620.2\|	50390	g12776	i0	100	0.30622009569378	32	0	15	0	158	189	7048	7017	PREDICTED: Diabrotica virgifera virgifera uncharacterized LOC114344785 (LOC114344785), transcript variant X1, mRNA	blastn	64	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Diabrotica	Diabrotica virgifera
3485421	3485421	PRJNA951388_S_NODE_3483_length_428_cov_4.532394_g3356_i0	PRJNA951388	3483	428	4.532394	19.39864632	Bombyx mori	7091	Arthropoda	Arthropoda	54.7	0.011	NTclustered	gi\|1237088976\|dbj\|LC316987.1\|	7091	g3356	i0	100	0.198598130841121	29	0	7	0	1	29	28	56	Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds	blastn	85	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
3485425	3485425	PRJNA951388_S_NODE_4743_length_383_cov_49.296774_g4616_i0	PRJNA951388	4743	383	49.296774	188.80664442	Chelidurella thaleri	2546182	Arthropoda	Arthropoda	54.7	0.01	NTclustered	gi\|2919573549\|emb\|OZ238423.1\|	2546182	g4616	i0	100	0.879895561357702	29	0	8	0	179	207	8269359	8269387	Chelidura thaleri genome assembly, chromosome: 24	blastn	337	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Dermaptera	Forficulidae	Chelidurella	Chelidurella thaleri
4763104	4763104	PRJNA951388_S_NODE_3044_length_449_cov_8.085106_g2917_i0	PRJNA951388	3044	449	8.085106	36.30212594	Scylla paramamosain	85552	Arthropoda	Arthropoda	54.7	0.012	NTclustered	gi\|1184387702\|emb\|LT835105.1\|	85552	g2917	i0	100	0.126948775055679	29	0	6	0	1	29	6	34	Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene)	blastn	57	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Scylla	Scylla paramamosain
4763121	4763121	PRJNA951388_S_NODE_7104_length_319_cov_2.373984_g6977_i0	PRJNA951388	7104	319	2.373984	7.57300896	Zerynthia rumina	132710	Arthropoda	Arthropoda	52.8	0.03	NTclustered	gi\|2918382484\|emb\|OZ238062.1\|	132710	g6977	i0	100	0.0877742946708464	28	0	9	0	265	292	21406394	21406421	Zerynthia rumina genome assembly, chromosome: 27	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Zerynthia	Zerynthia rumina
6037876	6037876	PRJNA951388_S_NODE_11145_length_245_cov_1.343023_g11018_i0	PRJNA951388	11145	245	1.343023	3.29040635	Scylla paramamosain	85552	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|1184387702\|emb\|LT835105.1\|	85552	g11018	i0	100	0.236734693877551	30	0	12	0	1	30	6	35	Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene)	blastn	58	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Scylla	Scylla paramamosain
6366801	6366801	PRJNA951388_S_NODE_12705_length_214_cov_4.588652_g12578_i0	PRJNA951388	12705	214	4.588652	9.81971528	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.2	1.13e-4	NTclustered	gi\|2637391907\|ref\|XM_003435721.2\|	7165	g12578	i0	89.796	18.6261682242991	49	2	23	3	165	213	595	550	PREDICTED: Anopheles gambiae probable E3 ubiquitin-protein ligase IRF2BPL (LOC11175981), mRNA	blastn	3986	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Anopheles	Anopheles gambiae
7312744	7312744	PRJNA951388_S_NODE_13286_length_198_cov_16.336000_g13159_i0	PRJNA951388	13286	198	16.336	32.34528	Chelidurella thaleri	2546182	Arthropoda	Arthropoda	52.8	0.017	NTclustered	gi\|2919607919\|emb\|OZ238406.1\|	2546182	g13159	i0	100	0.141414141414141	28	0	14	0	171	198	16957416	16957443	Chelidura thaleri genome assembly, chromosome: 7	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Dermaptera	Forficulidae	Chelidurella	Chelidurella thaleri
7312746	7312746	PRJNA951388_S_NODE_1946_length_518_cov_3.024719_g1823_i0	PRJNA951388	1946	518	3.024719	15.66804442	Timema genevievae	629358	Arthropoda	Arthropoda	56.5	0.004	NTclustered	gi\|1963373000\|emb\|OE846047.1\|	629358	g1823	i0	100	0.0579150579150579	30	0	6	0	64	93	20158	20187	5_Tge_b3v08	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema genevievae
7312762	7312762	PRJNA951388_S_NODE_706_length_735_cov_8.388218_g595_i0	PRJNA951388	706	735	8.388218	61.6534023	Aedes albopictus	7160	Arthropoda	Arthropoda	488	4.7299999999999985e-133	NTclustered	gi\|2669921693\|ref\|XM_062859457.1\|	7160	g595	i0	80.389	212.914285714286	668	109	89	21	67	723	3568	2912	PREDICTED: Aedes albopictus polyubiquitin-C (LOC115269552), transcript variant X4, mRNA	blastn	156492	488	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Aedes	Aedes albopictus
7640723	7640723	PRJNA951388_S_NODE_2546_length_475_cov_17.601990_g2419_i0	PRJNA951388	2546	475	17.60199	83.6094525	Timema	61471	Arthropoda	Arthropoda	54.7	0.013	NTclustered	gi\|1947819426\|emb\|OD566331.1\|	61472	g2419	i0	96.875	0.204210526315789	32	1	7	0	51	82	28900	28931	4_Tbi_b3v08	blastn	97	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema bartmani
8587718	8587718	PRJNA951388_S_NODE_11447_length_241_cov_1.375000_g11320_i0	PRJNA951388	11447	241	1.375	3.31375	Hetaerina americana	62018	Arthropoda	Arthropoda	182	2.65e-41	NTclustered	gi\|2918246893\|ref\|XM_071588585.1\|	62018	g11320	i0	80.498	11.7966804979253	241	43	99	4	1	239	1929	1691	PREDICTED: Hetaerina americana myosin heavy chain 10 (zip), transcript variant X1, mRNA	blastn	2843	182	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Odonata	Calopterygidae	Hetaerina	Hetaerina americana
8587732	8587732	PRJNA951388_S_NODE_5807_length_351_cov_4.838129_g5680_i0	PRJNA951388	5807	351	4.838129	16.98183279	Apis cerana	7461	Arthropoda	Arthropoda	58.4	7.13e-4	NTclustered	gi\|2644524054\|ref\|XM_028664386.2\|	7461	g5680	i0	97.059	6.58974358974359	34	1	10	0	66	99	5275	5242	PREDICTED: Apis cerana brain tumor protein-like (LOC107992923), transcript variant X3, mRNA	blastn	2313	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Apis	Apis cerana
8587737	8587737	PRJNA951388_S_NODE_7747_length_304_cov_6.038961_g7620_i0	PRJNA951388	7747	304	6.038961	18.35844144	Coccinella septempunctata	41139	Arthropoda	Arthropoda	126	1.65e-24	NTclustered	gi\|2125251188\|ref\|XM_044892703.1\|	41139	g7620	i0	87.273	1.60526315789474	110	14	36	0	127	236	238	347	PREDICTED: Coccinella septempunctata protein transport protein Sec61 subunit gamma (LOC123309542), mRNA	blastn	488	126	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Coccinella	Coccinella septempunctata
8915512	8915512	PRJNA951388_S_NODE_3487_length_427_cov_44.745763_g3360_i0	PRJNA951388	3487	427	44.745763	191.06440801	Arthropoda	6656	Arthropoda	Arthropoda	54.7	0.011	NTclustered	gi\|1026137028\|emb\|LT560377.1\|	85552	g3360	i0	100	0.540983606557377	29	0	7	0	1	29	6	34	Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6	blastn	231	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Scylla	Scylla paramamosain
8915515	8915515	PRJNA951388_S_NODE_467_length_837_cov_81.592932_g366_i0	PRJNA951388	467	837	81.592932	682.93284084	Timema	61471	Arthropoda	Arthropoda	54.7	0.023	NTclustered	gi\|1947819235\|emb\|OD566261.1\|	61472	g366	i0	100	0.0692951015531661	29	0	3	0	416	444	111505	111477	4_Tbi_b3v08	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema bartmani
9862737	9862737	PRJNA951388_S_NODE_10228_length_258_cov_1.248649_g10101_i0	PRJNA951388	10228	258	1.248649	3.22151442	Apis cerana	7461	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2644533885\|ref\|XM_017058322.3\|	7461	g10101	i0	97.059	0.131782945736434	34	0	13	1	215	248	50	82	PREDICTED: Apis cerana uncharacterized LOC107998823 (LOC107998823), transcript variant X2, mRNA	blastn	34	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Apis	Apis cerana
9862767	9862767	PRJNA951388_S_NODE_6528_length_333_cov_2.069231_g6401_i0	PRJNA951388	6528	333	2.069231	6.89053923	Helicoverpa assulta	52344	Arthropoda	Arthropoda	52.8	0.031	NTclustered	gi\|2636206755\|emb\|OY979781.1\|	52344	g6401	i0	100	0.168168168168168	28	0	8	0	79	106	8315242	8315215	Helicoverpa assulta genome assembly, chromosome: 7	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Helicoverpa	Helicoverpa assulta
11138401	11138401	PRJNA951388_S_NODE_4889_length_378_cov_9.796721_g4762_i0	PRJNA951388	4889	378	9.796721	37.03160538	Hylaeus anthracinus	313031	Arthropoda	Arthropoda	54.7	0.01	NTclustered	gi\|2456229340\|ref\|XR_008459613.1\|	313031	g4762	i0	100	0.0767195767195767	29	0	8	0	225	253	1672	1700	PREDICTED: Hylaeus anthracinus uncharacterized LOC128885479 (LOC128885479), ncRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Colletidae	Hylaeus	Hylaeus anthracinus
11138412	11138412	PRJNA951388_S_NODE_8349_length_293_cov_1.709091_g8222_i0	PRJNA951388	8349	293	1.709091	5.00763663	Penaeus monodon	6687	Arthropoda	Arthropoda	54.7	0.008	NTclustered	gi\|1832334880\|gb\|MK599468.1\|	6687	g8222	i0	100	0.385665529010239	29	0	10	0	1	29	87	115	Penaeus monodon C-type lectin mRNA, complete cds	blastn	113	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus monodon
12413852	12413852	PRJNA951388_S_NODE_6070_length_344_cov_3.269373_g5943_i0	PRJNA951388	6070	344	3.269373	11.24664312	Chelidurella thaleri	2546182	Arthropoda	Arthropoda	52.8	0.033	NTclustered	gi\|2919610158\|emb\|OZ238415.1\|	2546182	g5943	i0	100	0.0813953488372093	28	0	8	0	49	76	8689678	8689705	Chelidura thaleri genome assembly, chromosome: 16	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Dermaptera	Forficulidae	Chelidurella	Chelidurella thaleri
13688411	13688411	PRJNA951388_S_NODE_6351_length_337_cov_4.473485_g6224_i0	PRJNA951388	6351	337	4.473485	15.07564445	Satyrium ilicis	876074	Arthropoda	Arthropoda	52.8	0.032	NTclustered	gi\|2918386102\|emb\|OZ238122.1\|	876074	g6224	i0	100	0.0830860534124629	28	0	8	0	273	300	41566560	41566587	Satyrium ilicis genome assembly, chromosome: 13	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Satyrium	Satyrium ilicis
13688415	13688415	PRJNA951388_S_NODE_8211_length_295_cov_1.909910_g8084_i0	PRJNA951388	8211	295	1.90991	5.6342345	Timema poppense	170557	Arthropoda	Arthropoda	52.8	0.027	NTclustered	gi\|1946160769\|emb\|OD005169.1\|	170557	g8084	i0	100	0.0949152542372881	28	0	9	0	27	54	2712	2739	1_Tps_b3v08	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema poppense
13688417	13688417	PRJNA951388_S_NODE_8951_length_280_cov_2.231884_g8824_i0	PRJNA951388	8951	280	2.231884	6.2492752	Timema californicum	61474	Arthropoda	Arthropoda	54.7	0.007	NTclustered	gi\|1964743424\|emb\|OE190532.1\|	61474	g8824	i0	100	0.103571428571429	29	0	10	0	191	219	4613	4585	2_Tcm_b3v08	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
14962612	14962612	PRJNA951388_S_NODE_8192_length_295_cov_3.180180_g8065_i0	PRJNA951388	8192	295	3.18018	9.381531	Charissa obscurata	204503	Arthropoda	Arthropoda	52.8	0.027	NTclustered	gi\|2919559730\|emb\|OZ238369.1\|	204503	g8065	i0	96.774	0.105084745762712	31	1	11	0	60	90	13587260	13587230	Charissa obscurata genome assembly, chromosome: 3	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Geometridae	Charissa	Charissa obscurata
16237585	16237585	PRJNA951388_S_NODE_9993_length_261_cov_7.276596_g9866_i0	PRJNA951388	9993	261	7.276596	18.99191556	Rhynchophorus ferrugineus	354439	Arthropoda	Arthropoda	52.8	0.024	NTclustered	gi\|1044897043\|gb\|KT223635.1\|	354439	g9866	i0	100	0.10727969348659	28	0	11	0	234	261	59	32	Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Rhynchophorus	Rhynchophorus ferrugineus
17512876	17512876	PRJNA951388_S_NODE_11354_length_242_cov_2.189349_g11227_i0	PRJNA951388	11354	242	2.189349	5.29822458	Tydeidae sp.	2945581	Arthropoda	Arthropoda	267	7.15e-67	NTclustered	gi\|2240866609\|gb\|ON555724.1\|	2945581	g11227	i0	98.039	3.5702479338843	153	3	63	0	88	240	656	808	Tydeidae sp. isolate FP100 small subunit ribosomal RNA gene, partial sequence	blastn	864	267	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tydeidae		Tydeidae sp.
17512881	17512881	PRJNA951388_S_NODE_2294_length_490_cov_2.676259_g2168_i0	PRJNA951388	2294	490	2.676259	13.1136691	Timema poppense	170557	Arthropoda	Arthropoda	54.7	0.013	NTclustered	gi\|1946150776\|emb\|OD003210.1\|	170557	g2168	i0	100	0.0591836734693878	29	0	6	0	254	282	63479	63451	1_Tps_b3v08	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema poppense
17512886	17512886	PRJNA951388_S_NODE_4054_length_405_cov_17.704819_g3927_i0	PRJNA951388	4054	405	17.704819	71.70451695	Agapeta hamana	1100904	Arthropoda	Arthropoda	54.7	0.011	NTclustered	gi\|2918369971\|emb\|OZ237863.1\|	1100904	g3927	i0	94.286	0.0864197530864197	35	2	9	0	110	144	16934804	16934838	Agapeta hamana genome assembly, chromosome: 4	blastn	35	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Agapeta	Agapeta hamana
17512892	17512892	PRJNA951388_S_NODE_5714_length_354_cov_3.953737_g5587_i0	PRJNA951388	5714	354	3.953737	13.99622898	Megachile rotundata	143995	Arthropoda	Arthropoda	357	6.34e-94	NTclustered	gi\|805798334\|ref\|XM_012288428.1\|	143995	g5587	i0	86.136	0.957627118644068	339	37	95	5	1	337	914	1244	PREDICTED: Megachile rotundata piggyBac transposable element-derived protein 4-like (LOC100881135), mRNA	blastn	339	357	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Megachilidae	Megachile	Megachile rotundata
18786483	18786483	PRJNA951388_S_NODE_1815_length_528_cov_25.619780_g1692_i0	PRJNA951388	1815	528	25.61978	135.2724384	Scylla paramamosain	85552	Arthropoda	Arthropoda	54.7	0.014	NTclustered	gi\|1184387702\|emb\|LT835105.1\|	85552	g1692	i0	100	0.0549242424242424	29	0	5	0	1	29	6	34	Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene)	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Scylla	Scylla paramamosain
18786500	18786500	PRJNA951388_S_NODE_6915_length_323_cov_5.624000_g6788_i0	PRJNA951388	6915	323	5.624	18.16552	Timema californicum	61474	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|1965181363\|emb\|OE475415.1\|	61474	g6788	i0	90.909	0.136222910216718	44	1	13	2	5	45	309	266	2_Tcm_b3v08	blastn	44	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
19114098	19114098	PRJNA951388_S_NODE_10815_length_249_cov_5.687500_g10688_i0	PRJNA951388	10815	249	5.6875	14.161875	Timema	61471	Arthropoda	Arthropoda	52.8	0.023	NTclustered	gi\|1946912840\|emb\|OC317663.1\|	61476	g10688	i0	100	0.224899598393574	28	0	11	0	89	116	8416	8443	3_Tce_b3v08	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema cristinae
20061402	20061402	PRJNA951388_S_NODE_2316_length_488_cov_12.366265_g2190_i0	PRJNA951388	2316	488	12.366265	60.3473732	Rhynchophorus ferrugineus	354439	Arthropoda	Arthropoda	54.7	0.013	NTclustered	gi\|1044897043\|gb\|KT223635.1\|	354439	g2190	i0	100	0.0594262295081967	29	0	6	0	460	488	60	32	Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Rhynchophorus	Rhynchophorus ferrugineus
20061406	20061406	PRJNA951388_S_NODE_2716_length_465_cov_24.193878_g2589_i0	PRJNA951388	2716	465	24.193878	112.5015327	Samia ricini	63990	Arthropoda	Arthropoda	67.6	1.61e-6	NTclustered	gi\|2883230270\|dbj\|AP038904.1\|	63990	g2589	i0	93.333	0.0967741935483871	45	3	10	0	175	219	4073384	4073340	Samia ricini White GU1 DNA, chromosome 09, complete sequence	blastn	45	67.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Saturniidae	Samia	Samia ricini
21665042	21665042	PRJNA951388_S_NODE_12597_length_217_cov_6.243056_g12470_i0	PRJNA951388	12597	217	6.243056	13.54743152	Bombus	28641	Arthropoda	Arthropoda	52.8	0.019	NTclustered	gi\|2832700248\|ref\|XR_011174825.1\|	103934	g12470	i0	100	0.258064516129032	28	0	13	0	112	139	1433	1460	PREDICTED: Bombus flavifrons uncharacterized lncRNA (LOC138186175), ncRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus flavifrons
21665051	21665051	PRJNA951388_S_NODE_8077_length_297_cov_13.214286_g7950_i0	PRJNA951388	8077	297	13.214286	39.24642942	Arthropoda	6656	Arthropoda	Arthropoda	54.7	0.008	NTclustered	gi\|1026137028\|emb\|LT560377.1\|	85552	g7950	i0	100	0.67003367003367	29	0	10	0	269	297	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
23887068	23887068	PRJNA951388_S_NODE_13279_length_199_cov_4.238095_g13152_i0	PRJNA951388	13279	199	4.238095	8.43380905	Lorryia sp.	2945573	Arthropoda	Arthropoda	305	1.2e-78	NTclustered	gi\|2240866603\|gb\|ON555718.1\|	2945573	g13152	i0	94.118	65.2361809045226	204	6	100	4	1	199	1645	1443	Lorryia sp. isolate FP301 large subunit ribosomal RNA gene, partial sequence	blastn	12982	305	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tydeidae	Lorryia	Lorryia sp.
23887070	23887070	PRJNA951388_S_NODE_1499_length_562_cov_102.777096_g1378_i0	PRJNA951388	1499	562	102.777096	577.60727952	Aphidius gifuensis	684658	Arthropoda	Arthropoda	243	3.06e-59	NTclustered	gi\|2106740718\|ref\|XM_044152953.1\|	684658	g1378	i0	77.531	48.432384341637	405	89	72	2	34	437	171	574	PREDICTED: Aphidius gifuensis histone H3.3A (LOC122852866), mRNA	blastn	27219	243	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Aphidius	Aphidius gifuensis
23887081	23887081	PRJNA951388_S_NODE_4179_length_401_cov_10.591463_g4052_i0	PRJNA951388	4179	401	10.591463	42.47176663	Bombus vancouverensis	2705177	Arthropoda	Arthropoda	237	9.890000000000001e-58	NTclustered	gi\|1830291871\|ref\|XM_033346665.1\|	2705178	g4052	i0	81.208	79.573566084788	298	52	74	4	106	401	2215	1920	PREDICTED: Bombus vancouverensis nearcticus polyubiquitin-A (LOC117163925), transcript variant X3, mRNA	blastn	31909	237	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus vancouverensis
23887103	23887103	PRJNA951388_S_NODE_9199_length_275_cov_7.782178_g9072_i0	PRJNA951388	9199	275	7.782178	21.4009895	Longitarsus dorsalis	346795	Arthropoda	Arthropoda	52.8	0.025	NTclustered	gi\|2918386058\|emb\|OZ238101.1\|	346795	g9072	i0	96.774	0.112727272727273	31	1	11	0	239	269	17808193	17808223	Longitarsus dorsalis genome assembly, chromosome: 8	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Longitarsus	Longitarsus dorsalis
24214372	24214372	PRJNA951388_S_NODE_2679_length_467_cov_8.840102_g2552_i0	PRJNA951388	2679	467	8.840102	41.28327634	Metazoa	33208	Arthropoda	Arthropoda	58.4	0.001	NTclustered	gi\|1723829356\|ref\|XM_030390083.1\|	7232	g2552	i0	94.737	7.72162740899358	38	0	8	1	255	290	1495	1458	PREDICTED: Drosophila navojoa homeobox protein vnd (LOC115565098), mRNA	blastn	3606	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila navojoa
24214376	24214376	PRJNA951388_S_NODE_6739_length_327_cov_4.846457_g6612_i0	PRJNA951388	6739	327	4.846457	15.84791439	root	1	Root_unresolved	Root_unresolved	52.8	0.031	NTclustered	gi\|1184387702\|emb\|LT835105.1\|	85552	g6612	i0	100	0.171253822629969	28	0	9	0	1	28	6	33	Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene)	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Scylla	Scylla paramamosain
25160876	25160876	PRJNA951388_S_NODE_2460_length_481_cov_2.649510_g2333_i0	PRJNA951388	2460	481	2.64951	12.7441431	Darwinula stevensoni	69355	Arthropoda	Arthropoda	58.4	0.001	NTclustered	gi\|1936546861\|emb\|LR902229.1\|	69355	g2333	i0	92.5	0.0831600831600832	40	3	8	0	79	118	29089	29128	Darwinula stevensoni	blastn	40	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
25160889	25160889	PRJNA951388_S_NODE_6780_length_326_cov_3.920949_g6653_i0	PRJNA951388	6780	326	3.920949	12.78229374	Leptopilina boulardi	63433	Arthropoda	Arthropoda	183	1.04e-41	NTclustered	gi\|2322511844\|ref\|XM_051308159.1\|	63433	g6653	i0	83.938	3.58282208588957	193	30	59	1	9	201	716	525	PREDICTED: Leptopilina boulardi 26S proteasome regulatory subunit 8 (LOC127283358), mRNA	blastn	1168	183	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Figitidae	Leptopilina	Leptopilina boulardi

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