metadata: contig_metadata: 56 rows where analysis = "blastn", bioproject = "PRJNA929924" and tax

56 rows where analysis = "blastn", bioproject = "PRJNA929924" 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
908990	908990	PRJNA929924_P_NODE_4541_length_738_cov_4.142235_g4404_i0	PRJNA929924	4541	738	4.142235	30.5696943	Megacopta sp. SY-2015	1603591	Arthropoda	Arthropoda	230	3.1799999999999992e-55	NTclustered	gi\|755530982\|gb\|KJ535889.1\|	1603591	g4404	i0	78.873	42.0528455284553	355	53	48	19	69	419	2233	2569	Megacopta sp. SY-2015 28S ribosomal RNA gene, partial sequence	blastn	31035	230	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Plataspidae	Megacopta	Megacopta sp. SY-2015
909067	909067	PRJNA929924_P_NODE_9061_length_276_cov_4.938326_g8898_i0	PRJNA929924	9061	276	4.938326	13.62977976	Drosophila melanogaster	7227	Arthropoda	Arthropoda	508	1.2499999999999999e-139	NTclustered	gi\|1834199029\|ref\|NR_037753.2\|	7227	g8898	i0	100	20.1304347826087	275	0	99	0	2	276	287	13	Drosophila melanogaster signal recognition particle 7SL RNA CR42652 (7SLRNA:CR42652), SRP_RNA	blastn	5556	508	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
1254177	1254177	PRJNA929924_P_NODE_16581_length_166_cov_0.880342_g16418_i0	PRJNA929924	16581	166	0.880342	1.46136772	Metazoa	33208	Arthropoda	Arthropoda	202	1.2999999999999998e-47	NTclustered	gi\|1465231276\|gb\|MG910468.1\|	6728	g16418	i0	89.375	16.5301204819277	160	17	96	0	1	160	953	1112	Procambarus clarkii heat shock protein 84 kDa (Hsp90) mRNA, partial cds	blastn	2744	204	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
3459928	3459928	PRJNA929924_P_NODE_8643_length_296_cov_1.943320_g8480_i0	PRJNA929924	8643	296	1.94332	5.7522272	Riptortus clavatus	41704	Arthropoda	Arthropoda	542	1.34e-149	NTclustered	gi\|2462820\|gb\|U97277.1\|RCU97277	41704	g8480	i0	99.662	1	296	1	100	0	1	296	3430	3135	Riptortus clavatus vitellogenin mRNA, complete cds	blastn	296	542	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
3459937	3459937	PRJNA929924_P_NODE_9643_length_256_cov_1.323671_g9480_i0	PRJNA929924	9643	256	1.323671	3.38859776	Riptortus clavatus	41704	Arthropoda	Arthropoda	468	1.95e-127	NTclustered	gi\|2462820\|gb\|U97277.1\|RCU97277	41704	g9480	i0	99.609	1	256	1	100	0	1	256	5196	5451	Riptortus clavatus vitellogenin mRNA, complete cds	blastn	256	468	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
3806466	3806466	PRJNA929924_P_NODE_9523_length_260_cov_1.232227_g9360_i0	PRJNA929924	9523	260	1.232227	3.2037902	Diptera	7147	Arthropoda	Arthropoda	54.7	0.007	NTclustered	gi\|1189053999\|ref\|XM_020944159.1\|	7274	g9360	i0	100	2.43076923076923	29	0	11	0	123	151	957	929	PREDICTED: Drosophila serrata protein CBFA2T3 (LOC110177432), mRNA	blastn	632	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila serrata
4737212	4737212	PRJNA929924_P_NODE_11564_length_211_cov_1.604938_g11401_i0	PRJNA929924	11564	211	1.604938	3.38641918	Riptortus clavatus	41704	Arthropoda	Arthropoda	374	3.4799999999999995e-99	NTclustered	gi\|2462820\|gb\|U97277.1\|RCU97277	41704	g11401	i0	98.578	1	211	3	100	0	1	211	1507	1297	Riptortus clavatus vitellogenin mRNA, complete cds	blastn	211	374	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
4737413	4737413	PRJNA929924_P_NODE_8664_length_295_cov_2.837398_g8501_i0	PRJNA929924	8664	295	2.837398	8.3703241	Daphnia pulex	6669	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2192734159\|ref\|XM_046600325.1\|	6669	g8501	i0	94.595	0.501694915254237	37	0	12	2	161	195	8462	8498	PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA	blastn	148	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
4737415	4737415	PRJNA929924_P_NODE_9144_length_273_cov_4.611607_g8981_i0	PRJNA929924	9144	273	4.611607	12.58968711	Tribolium castaneum	7070	Arthropoda	Arthropoda	239	1.79e-58	NTclustered	gi\|2733082151\|emb\|OX466069.1\|	7070	g8981	i0	84.211	122.282051282051	247	37	90	2	1	246	6239905	6240150	Tribolium castaneum genome assembly, chromosome: LG9	blastn	33383	239	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum
5082466	5082466	PRJNA929924_P_NODE_12744_length_192_cov_1.279720_g12581_i0	PRJNA929924	12744	192	1.27972	2.4570624	root	1	Root_unresolved	Root_unresolved	355	1.13e-93	NTclustered	gi\|15412422\|gb\|AC010558.4\|	7227	g12581	i0	100	16.875	192	0	100	0	1	192	93526	93717	Drosophila melanogaster 3L BAC RPCI98-1K9 (Roswell Park Cancer Institute Drosophila BAC Library) complete sequence	blastn	3240	355	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
6012153	6012153	PRJNA929924_P_NODE_16105_length_167_cov_0.881356_g15942_i0	PRJNA929924	16105	167	0.881356	1.47186452	Aleurodicus dugesii	30099	Arthropoda	Arthropoda	148	1.7399999999999999e-31	NTclustered	gi\|694047\|gb\|U20412.1\|ADU20412	30099	g15942	i0	94.737	49.1976047904192	95	5	57	0	73	167	406	312	Aleurodicus dugesii 18S small subunit ribosomal RNA, partial sequence	blastn	8216	148	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Aleurodicus	Aleurodicus dugesii
6012284	6012284	PRJNA929924_P_NODE_6865_length_416_cov_1.351499_g6702_i0	PRJNA929924	6865	416	1.351499	5.62223584	Sipha flava	143950	Arthropoda	Arthropoda	281	4.69e-71	NTclustered	gi\|1418892531\|ref\|XM_025551621.1\|	143950	g6702	i0	79.048	72.2860576923077	420	80	100	7	1	416	1278	863	PREDICTED: Sipha flava heat shock 70 kDa protein cognate 4-like (LOC112681358), mRNA	blastn	30071	281	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Sipha	Sipha flava
6012313	6012313	PRJNA929924_P_NODE_8905_length_283_cov_1.991453_g8742_i0	PRJNA929924	8905	283	1.991453	5.63581199	Trialeurodes vaporariorum	88556	Arthropoda	Arthropoda	518	2.14e-142	NTclustered	gi\|52220968\|ref\|NC_006280.1\|	88556	g8742	i0	99.647	74.1201413427562	283	1	100	0	1	283	11294	11012	Trialeurodes vaporariorum mitochondrion, complete genome	blastn	20976	518	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Trialeurodes	Trialeurodes vaporariorum
6012317	6012317	PRJNA929924_P_NODE_9245_length_269_cov_2.550000_g9082_i0	PRJNA929924	9245	269	2.55	6.8595	Ceutorhynchus obstrictus	307131	Arthropoda	Arthropoda	174	5.04e-39	NTclustered	gi\|2918376580\|emb\|OZ238010.1\|	307131	g9082	i0	79.31	69.7323420074349	261	44	96	10	13	269	67565780	67566034	Ceutorhynchus obstrictus genome assembly, chromosome: 1	blastn	18758	174	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Ceutorhynchus	Ceutorhynchus obstrictus
7286983	7286983	PRJNA929924_P_NODE_15466_length_168_cov_0.873950_g15303_i0	PRJNA929924	15466	168	0.87395	1.468236	Drosophila melanogaster	7227	Arthropoda	Arthropoda	311	2.11e-80	NTclustered	gi\|442628079\|ref\|NM_001273580.1\|	7227	g15303	i0	100	19.2261904761905	168	0	100	0	1	168	255	88	Drosophila melanogaster cytochrome c distal, transcript variant B (Cyt-c-d), mRNA	blastn	3230	311	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
8561807	8561807	PRJNA929924_P_NODE_17007_length_165_cov_0.827586_g16844_i0	PRJNA929924	17007	165	0.827586	1.3655169	Aphidius gifuensis	684658	Arthropoda	Arthropoda	128	2.23e-25	NTclustered	gi\|2106732601\|ref\|XM_044148575.1\|	684658	g16844	i0	89.216	41.969696969697	102	11	62	0	1	102	235	134	PREDICTED: Aphidius gifuensis tubulin alpha-1 chain (LOC122849763), mRNA	blastn	6925	128	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Aphidius	Aphidius gifuensis
9836827	9836827	PRJNA929924_P_NODE_12008_length_203_cov_2.272727_g11845_i0	PRJNA929924	12008	203	2.272727	4.61363581	Papilio polytes	76194	Arthropoda	Arthropoda	226	9.849999999999997e-55	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g11845	i0	98.425	0.625615763546798	127	2	63	0	77	203	1	127	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	127	226	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
9837041	9837041	PRJNA929924_P_NODE_9328_length_267_cov_1.233945_g9165_i0	PRJNA929924	9328	267	1.233945	3.29463315	Riptortus clavatus	41704	Arthropoda	Arthropoda	494	3.38e-135	NTclustered	gi\|1513060\|dbj\|D87272.1\|	41704	g9165	i0	100	1	267	0	100	0	1	267	1562	1828	Riptortus clavatus mRNA for cyanoprotein alpha subunit precursor, complete cds	blastn	267	494	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
11112465	11112465	PRJNA929924_P_NODE_10229_length_239_cov_1.515789_g10066_i0	PRJNA929924	10229	239	1.515789	3.62273571	Trialeurodes vaporariorum	88556	Arthropoda	Arthropoda	442	1.0899999999999994e-119	NTclustered	gi\|2037173692\|gb\|MZ191254.1\|	88556	g10066	i0	100	100	239	0	100	0	1	239	283	521	Trialeurodes vaporariorum isolate Me-Mw-WF6B cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	23900	442	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Trialeurodes	Trialeurodes vaporariorum
11112475	11112475	PRJNA929924_P_NODE_11009_length_222_cov_1.693642_g10846_i0	PRJNA929924	11009	222	1.693642	3.75988524	Riptortus clavatus	41704	Arthropoda	Arthropoda	399	6.099999999999999e-107	NTclustered	gi\|2462820\|gb\|U97277.1\|RCU97277	41704	g10846	i0	99.099	1	222	2	100	0	1	222	5429	5650	Riptortus clavatus vitellogenin mRNA, complete cds	blastn	222	399	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
11112477	11112477	PRJNA929924_P_NODE_11109_length_220_cov_1.274854_g10946_i0	PRJNA929924	11109	220	1.274854	2.8046788	Riptortus clavatus	41704	Arthropoda	Arthropoda	407	3.61e-109	NTclustered	gi\|1513060\|dbj\|D87272.1\|	41704	g10946	i0	100	1	220	0	100	0	1	220	1396	1177	Riptortus clavatus mRNA for cyanoprotein alpha subunit precursor, complete cds	blastn	220	407	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
11112482	11112482	PRJNA929924_P_NODE_11589_length_211_cov_1.141975_g11426_i0	PRJNA929924	11589	211	1.141975	2.40956725	Tetranychus urticae	32264	Arthropoda	Arthropoda	209	1.04e-49	NTclustered	gi\|1390642066\|ref\|XM_015925537.2\|	32264	g11426	i0	84.762	113.417061611374	210	30	99	2	2	210	685	893	PREDICTED: Tetranychus urticae polyubiquitin-B (LOC107359088), mRNA	blastn	23931	209	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
11112503	11112503	PRJNA929924_P_NODE_13249_length_187_cov_1.130435_g13086_i0	PRJNA929924	13249	187	1.130435	2.11391345	Aleyrodidae sp. JRC-2012	1225581	Arthropoda	Arthropoda	183	5.439999999999999e-42	NTclustered	gi\|406822837\|gb\|JN797303.1\|	1225581	g13086	i0	93.548	1.1283422459893	124	6	66	2	20	142	194	316	Aleyrodidae sp. JRC-2012 28S ribosomal RNA gene, partial sequence	blastn	211	183	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae		Aleyrodidae sp. JRC-2012
11112529	11112529	PRJNA929924_P_NODE_15689_length_167_cov_2.203390_g15526_i0	PRJNA929924	15689	167	2.20339	3.6796613	Hamanumida daedalus	681794	Arthropoda	Arthropoda	104	3.81e-18	NTclustered	gi\|2568655181\|gb\|OL054665.1\|	681794	g15526	i0	83.051	0.706586826347305	118	16	69	4	1	116	136	21	Hamanumida daedalus voucher MGCL:LEP-35432 polyadenylate-binding protein gene, partial cds	blastn	118	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Hamanumida	Hamanumida daedalus
11112550	11112550	PRJNA929924_P_NODE_17329_length_164_cov_0.904348_g17166_i0	PRJNA929924	17329	164	0.904348	1.48313072	Riptortus pedestris	329032	Arthropoda	Arthropoda	303	3.42e-78	NTclustered	gi\|501300659\|dbj\|AK418507.1\|	329032	g17166	i0	100	2	164	0	100	0	1	164	172	9	Riptortus pedestris mRNA, putative 3'UTR of hypothetical protein, sequence id: Rped-1302, expressed in midgut	blastn	328	303	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus pedestris
12388019	12388019	PRJNA929924_P_NODE_12910_length_190_cov_1.304965_g12747_i0	PRJNA929924	12910	190	1.304965	2.4794335	Bemisia tabaci	7038	Arthropoda	Arthropoda	329	6.730000000000001e-86	NTclustered	gi\|1101364690\|ref\|XM_019057968.1\|	7038	g12747	i0	97.895	84.6315789473684	190	4	100	0	1	190	88	277	PREDICTED: Bemisia tabaci uncharacterized LOC109041581 (LOC109041581), mRNA	blastn	16080	329	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
12388021	12388021	PRJNA929924_P_NODE_13450_length_184_cov_2.822222_g13287_i0	PRJNA929924	13450	184	2.822222	5.19288848	Darwinula stevensoni	69355	Arthropoda	Arthropoda	126	9.12e-25	NTclustered	gi\|1936515315\|emb\|LR939176.1\|	69355	g13287	i0	89.109	0.548913043478261	101	11	55	0	1	101	198	298	Darwinula stevensoni	blastn	101	126	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
12388217	12388217	PRJNA929924_P_NODE_9750_length_252_cov_2.985222_g9587_i0	PRJNA929924	9750	252	2.985222	7.52275944	Bemisia tabaci	7038	Arthropoda	Arthropoda	279	9.63e-71	NTclustered	gi\|1101363427\|ref\|XM_019051875.1\|	7038	g9587	i0	93.617	23.3095238095238	188	11	74	1	46	232	856	1043	PREDICTED: Bemisia tabaci tubulin alpha chain-like (LOC109037277), mRNA	blastn	5874	279	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
13662491	13662491	PRJNA929924_P_NODE_11891_length_205_cov_1.666667_g11728_i0	PRJNA929924	11891	205	1.666667	3.41666735	Procambarus clarkii	6728	Arthropoda	Arthropoda	248	2.13e-61	NTclustered	gi\|854959472\|gb\|KM624016.1\|	6728	g11728	i0	89	79.2878048780488	200	22	98	0	2	201	836	637	Procambarus clarkii elongation factor 1-alpha mRNA, partial cds	blastn	16254	248	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
13662498	13662498	PRJNA929924_P_NODE_12551_length_195_cov_1.294521_g12388_i0	PRJNA929924	12551	195	1.294521	2.52431595	Apis florea	7463	Arthropoda	Arthropoda	152	1.61e-32	NTclustered	gi\|1787255432\|ref\|XM_031916224.1\|	7463	g12388	i0	81.152	41.9076923076923	191	34	97	2	1	190	130	319	PREDICTED: Apis florea GTP-binding nuclear protein Ran (LOC100869865), mRNA	blastn	8172	152	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Apis	Apis florea
13662505	13662505	PRJNA929924_P_NODE_13191_length_187_cov_1.507246_g13028_i0	PRJNA929924	13191	187	1.507246	2.81855002	Thrips palmi	161013	Arthropoda	Arthropoda	115	2.01e-21	NTclustered	gi\|1841832294\|ref\|XM_034389981.1\|	161013	g13028	i0	87.129	29.903743315508	101	13	54	0	77	177	153	253	PREDICTED: Thrips palmi translation elongation factor 2 (LOC117647964), mRNA	blastn	5592	115	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips palmi
13662530	13662530	PRJNA929924_P_NODE_15231_length_169_cov_0.866667_g15068_i0	PRJNA929924	15231	169	0.866667	1.46466723	Drosophila melanogaster	7227	Arthropoda	Arthropoda	307	2.73e-79	NTclustered	gi\|16874826\|gb\|AC099307.1\|	7227	g15068	i0	99.408	2	169	1	100	0	1	169	90331	90499	Drosophila melanogaster, chromosome 2R, region 57C-57D, BAC clone BACR13H23, complete sequence	blastn	338	307	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
13662532	13662532	PRJNA929924_P_NODE_15411_length_168_cov_0.873950_g15248_i0	PRJNA929924	15411	168	0.87395	1.468236	Riptortus clavatus	41704	Arthropoda	Arthropoda	305	9.81e-79	NTclustered	gi\|2462820\|gb\|U97277.1\|RCU97277	41704	g15248	i0	99.405	1	168	1	100	0	1	168	4092	3925	Riptortus clavatus vitellogenin mRNA, complete cds	blastn	168	305	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
14936788	14936788	PRJNA929924_P_NODE_10612_length_231_cov_1.142857_g10449_i0	PRJNA929924	10612	231	1.142857	2.63999967	Riptortus clavatus	41704	Arthropoda	Arthropoda	427	2.9399999999999998e-115	NTclustered	gi\|2462820\|gb\|U97277.1\|RCU97277	41704	g10449	i0	100	1	231	0	100	0	1	231	4629	4859	Riptortus clavatus vitellogenin mRNA, complete cds	blastn	231	427	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
14936817	14936817	PRJNA929924_P_NODE_14292_length_176_cov_1.330709_g14129_i0	PRJNA929924	14292	176	1.330709	2.34204784	Artemia franciscana	6661	Arthropoda	Arthropoda	209	8.33e-50	NTclustered	gi\|2743035274\|ref\|XR_010618878.1\|	6661	g14129	i0	89.941	70.2272727272727	169	8	95	3	1	168	104	264	PREDICTED: Artemia franciscana uncharacterized LOC136033186 (LOC136033186), ncRNA	blastn	12360	209	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
14936857	14936857	PRJNA929924_P_NODE_18292_length_162_cov_0.920354_g18129_i0	PRJNA929924	18292	162	0.920354	1.49097348	Lucilia sericata	13632	Arthropoda	Arthropoda	148	1.6699999999999999e-31	NTclustered	gi\|1937259663\|ref\|XM_037950428.1\|	13632	g18129	i0	84.667	3.52469135802469	150	21	92	2	8	156	277	129	PREDICTED: Lucilia sericata DNA-directed RNA polymerases I, II, and III subunit RPABC5 (LOC119600280), mRNA	blastn	571	148	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Calliphoridae	Lucilia	Lucilia sericata
16211804	16211804	PRJNA929924_P_NODE_10073_length_243_cov_1.376289_g9910_i0	PRJNA929924	10073	243	1.376289	3.34438227	Trialeurodes vaporariorum	88556	Arthropoda	Arthropoda	444	3.09e-120	NTclustered	gi\|2227868615\|gb\|ON311140.1\|	88556	g9910	i0	99.588	14.5637860082305	243	1	100	0	1	243	586	344	Trialeurodes vaporariorum isolate WF109 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	3539	444	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Trialeurodes	Trialeurodes vaporariorum
17831680	17831680	PRJNA929924_P_NODE_10754_length_228_cov_0.988827_g10591_i0	PRJNA929924	10754	228	0.988827	2.25452556	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	224	4.0699999999999996e-54	NTclustered	gi\|1928074112\|ref\|XM_037184666.1\|	38358	g10591	i0	84.753	146.039473684211	223	34	98	0	1	223	505	283	PREDICTED: Bradysia coprophila polyubiquitin-C (LOC119077460), transcript variant X6, mRNA	blastn	33297	224	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia coprophila
18760525	18760525	PRJNA929924_P_NODE_17735_length_163_cov_0.912281_g17572_i0	PRJNA929924	17735	163	0.912281	1.48701803	Bemisia tabaci	7038	Arthropoda	Arthropoda	233	4.52e-57	NTclustered	gi\|1101360397\|ref\|XM_019050961.1\|	7038	g17572	i0	93.59	0.957055214723926	156	10	96	0	8	163	1218	1063	PREDICTED: Bemisia tabaci tRNA (uracil-5-)-methyltransferase homolog A-like (LOC109036619), mRNA	blastn	156	233	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
18760642	18760642	PRJNA929924_P_NODE_8035_length_329_cov_1.967857_g7872_i0	PRJNA929924	8035	329	1.967857	6.47424953	Procambarus clarkii	6728	Arthropoda	Arthropoda	422	2.05e-113	NTclustered	gi\|854959472\|gb\|KM624016.1\|	6728	g7872	i0	90.123	94.112462006079	324	32	98	0	6	329	1121	798	Procambarus clarkii elongation factor 1-alpha mRNA, partial cds	blastn	30963	422	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
19105563	19105563	PRJNA929924_P_NODE_10515_length_232_cov_5.409836_g10352_i0	PRJNA929924	10515	232	5.409836	12.55081952	Riptortus	41703	Arthropoda	Arthropoda	429	8.2e-116	NTclustered	gi\|501289711\|dbj\|AB725684.1\|	329032	g10352	i0	100	99.3405172413793	232	0	100	0	1	232	6964	6733	Riptortus pedestris genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA	blastn	23047	429	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus pedestris
19105640	19105640	PRJNA929924_P_NODE_18175_length_162_cov_0.920354_g18012_i0	PRJNA929924	18175	162	0.920354	1.49097348	root	1	Root_unresolved	Root_unresolved	300	4.36e-77	NTclustered	gi\|21428553\|gb\|AY118568.1\|	7227	g18012	i0	100	19.6604938271605	162	0	100	0	1	162	499	338	Drosophila melanogaster LD40776 full insert cDNA	blastn	3185	300	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
20035459	20035459	PRJNA929924_P_NODE_11136_length_219_cov_1.782353_g10973_i0	PRJNA929924	11136	219	1.782353	3.90335307	Bemisia tabaci	7038	Arthropoda	Arthropoda	87.9	5.31e-13	NTclustered	gi\|1101364690\|ref\|XM_019057968.1\|	7038	g10973	i0	100	0.214611872146119	47	0	21	0	1	47	47	1	PREDICTED: Bemisia tabaci uncharacterized LOC109041581 (LOC109041581), mRNA	blastn	47	87.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
21310960	21310960	PRJNA929924_P_NODE_11877_length_205_cov_3.108974_g11714_i0	PRJNA929924	11877	205	3.108974	6.3733967	Bemisia tabaci	7038	Arthropoda	Arthropoda	63.9	8.27e-6	NTclustered	gi\|1694459157\|gb\|MH757924.1\|	7038	g11714	i0	90.385	0.253658536585366	52	0	25	3	10	61	110	156	Bemisia tabaci isolate 137 28S ribosomal RNA gene, partial sequence	blastn	52	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
21311123	21311123	PRJNA929924_P_NODE_7737_length_350_cov_1.196013_g7574_i0	PRJNA929924	7737	350	1.196013	4.1860455	Riptortus clavatus	41704	Arthropoda	Arthropoda	630	3.3399999999999984e-176	NTclustered	gi\|2462820\|gb\|U97277.1\|RCU97277	41704	g7574	i0	99.145	1.00285714285714	351	1	100	2	1	350	3088	2739	Riptortus clavatus vitellogenin mRNA, complete cds	blastn	351	630	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
21656394	21656394	PRJNA929924_P_NODE_11097_length_220_cov_2.233918_g10934_i0	PRJNA929924	11097	220	2.233918	4.9146196	Drosophila	7215	Arthropoda	Arthropoda	407	3.61e-109	NTclustered	gi\|45332696\|ref\|NC_005779.1\|	7226	g10934	i0	100	100.031818181818	220	0	100	0	1	220	13216	13435	Drosophila mauritiana mitochondrion, complete genome	blastn	22007	407	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila mauritiana
22585860	22585860	PRJNA929924_P_NODE_13198_length_187_cov_1.500000_g13035_i0	PRJNA929924	13198	187	1.5	2.805	Papilio polytes	76194	Arthropoda	Arthropoda	318	1.43e-82	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g13035	i0	97.34	1.00534759358289	188	4	100	1	1	187	517	330	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	188	318	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
22585989	22585989	PRJNA929924_P_NODE_5498_length_580_cov_1.273070_g5341_i0	PRJNA929924	5498	580	1.27307	7.383806	Procambarus clarkii	6728	Arthropoda	Arthropoda	645	2.069999999999999e-180	NTclustered	gi\|1465231276\|gb\|MG910468.1\|	6728	g5341	i0	86.747	16.9120689655172	581	75	100	2	1	580	1897	1318	Procambarus clarkii heat shock protein 84 kDa (Hsp90) mRNA, partial cds	blastn	9809	645	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
22586040	22586040	PRJNA929924_P_NODE_8938_length_282_cov_1.665236_g8775_i0	PRJNA929924	8938	282	1.665236	4.69596552	Riptortus clavatus	41704	Arthropoda	Arthropoda	521	1.6499999999999996e-143	NTclustered	gi\|2462820\|gb\|U97277.1\|RCU97277	41704	g8775	i0	100	1	282	0	100	0	1	282	652	371	Riptortus clavatus vitellogenin mRNA, complete cds	blastn	282	521	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus
22931959	22931959	PRJNA929924_P_NODE_12518_length_195_cov_1.869863_g12355_i0	PRJNA929924	12518	195	1.869863	3.64623285	Artemia	6660	Arthropoda	Arthropoda	351	1.48e-92	NTclustered	gi\|2743080997\|ref\|XR_010618360.1\|	6661	g12355	i0	100	2.41538461538462	190	0	97	0	6	195	3469	3658	PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA	blastn	471	351	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
22932234	22932234	PRJNA929924_P_NODE_9338_length_266_cov_3.880184_g9175_i0	PRJNA929924	9338	266	3.880184	10.32128944	Drosophila	7215	Arthropoda	Arthropoda	492	1.2099999999999999e-134	NTclustered	gi\|1829471572\|ref\|XR_004460481.1\|	7226	g9175	i0	100	100	266	0	100	0	1	266	2131	1866	PREDICTED: Drosophila mauritiana large subunit ribosomal RNA (LOC117149730), rRNA	blastn	26600	492	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila mauritiana
23861198	23861198	PRJNA929924_P_NODE_13519_length_184_cov_1.207407_g13356_i0	PRJNA929924	13519	184	1.207407	2.22162888	Drosophila melanogaster	7227	Arthropoda	Arthropoda	340	2.99e-89	NTclustered	gi\|14578108\|gb\|AC092227.1\|AC092227	7227	g13356	i0	100	2	184	0	100	0	1	184	95378	95561	Drosophila melanogaster, chromosome 2L, region 35X-35X, BAC clone BACR20P10, complete sequence	blastn	368	340	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
24205781	24205781	PRJNA929924_P_NODE_17179_length_164_cov_0.904348_g17016_i0	PRJNA929924	17179	164	0.904348	1.48313072	root	1	Root_unresolved	Root_unresolved	303	3.42e-78	NTclustered	gi\|442624231\|ref\|NM_206171.4\|	7227	g17016	i0	100	38.9390243902439	164	0	100	0	1	164	1125	962	Drosophila melanogaster par-1, transcript variant H (par-1), mRNA	blastn	6386	303	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
25135013	25135013	PRJNA929924_P_NODE_11200_length_218_cov_1.751479_g11037_i0	PRJNA929924	11200	218	1.751479	3.81822422	Sitodiplosis mosellana	263140	Arthropoda	Arthropoda	119	1.87e-22	NTclustered	gi\|2492461588\|ref\|XM_055447219.1\|	263140	g11037	i0	81.633	0.674311926605505	147	24	67	3	72	216	602	457	PREDICTED: Sitodiplosis mosellana thioredoxin-like protein 4A (LOC129568890), mRNA	blastn	147	119	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Cecidomyiidae	Sitodiplosis	Sitodiplosis mosellana
25135161	25135161	PRJNA929924_P_NODE_5440_length_586_cov_4.018622_g5284_i0	PRJNA929924	5440	586	4.018622	23.54912492	Pealius kelloggii	30101	Arthropoda	Arthropoda	643	7.509999999999999e-180	NTclustered	gi\|532982\|gb\|U06479.1\|PKU06479	30101	g5284	i0	87.14	1.29351535836177	591	47	99	27	6	586	725	1296	Pealius kelloggii 18S ribosomal RNA gene, complete sequence	blastn	758	643	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Pealius	Pealius kelloggii
25135219	25135219	PRJNA929924_P_NODE_9860_length_249_cov_1.560000_g9697_i0	PRJNA929924	9860	249	1.56	3.8844	Riptortus clavatus	41704	Arthropoda	Arthropoda	460	3.16e-125	NTclustered	gi\|2462820\|gb\|U97277.1\|RCU97277	41704	g9697	i0	100	1	249	0	100	0	1	249	331	83	Riptortus clavatus vitellogenin mRNA, complete cds	blastn	249	460	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus clavatus

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