metadata: contig_metadata: 52 rows where analysis = "blastn", bioproject = "PRJNA782551" and tax

52 rows where analysis = "blastn", bioproject = "PRJNA782551" 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
2039556	2039556	PRJNA782551_P_NODE_13882_length_264_cov_1.209424_g13760_i0	PRJNA782551	13882	264	1.209424	3.19287936	Aphidius gifuensis	684658	Arthropoda	Arthropoda	195	3.79e-45	NTclustered	gi\|2106740718\|ref\|XM_044152953.1\|	684658	g13760	i0	80	83.3257575757576	265	51	100	2	1	264	567	304	PREDICTED: Aphidius gifuensis histone H3.3A (LOC122852866), mRNA	blastn	21998	195	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Aphidius	Aphidius gifuensis
2039675	2039675	PRJNA782551_P_NODE_22322_length_244_cov_0.900585_g22200_i0	PRJNA782551	22322	244	0.900585	2.1974274	Drosophila melanogaster	7227	Arthropoda	Arthropoda	451	1.86e-122	NTclustered	gi\|15150418\|gb\|AY050234.1\|	7227	g22200	i0	100	31.7090163934426	244	0	100	0	1	244	2209	1966	Drosophila melanogaster SD02026 full length cDNA	blastn	7737	451	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
2039691	2039691	PRJNA782551_P_NODE_23882_length_242_cov_0.911243_g23760_i0	PRJNA782551	23882	242	0.911243	2.20520806	Drosophila melanogaster	7227	Arthropoda	Arthropoda	425	1.11e-114	NTclustered	gi\|665394427\|ref\|NM_142503.5\|	7227	g23760	i0	98.347	14.1322314049587	242	4	100	0	1	242	21	262	Drosophila melanogaster N-sulfoglucosamine sulfohydrolase (Sgsh), mRNA	blastn	3420	425	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
2488018	2488018	PRJNA782551_P_NODE_3882_length_479_cov_7.312808_g3760_i0	PRJNA782551	3882	479	7.312808	35.02835032	Noctuidae	7100	Arthropoda	Arthropoda	885	0	NTclustered	gi\|2306717695\|ref\|XR_004783997.2\|	7108	g3760	i0	100	453.549060542798	479	0	100	0	1	479	3324	2846	PREDICTED: Spodoptera frugiperda large subunit ribosomal RNA (LOC118279431), rRNA	blastn	217250	885	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
3314965	3314965	PRJNA782551_P_NODE_19383_length_247_cov_0.885057_g19261_i0	PRJNA782551	19383	247	0.885057	2.18609079	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	407	4.14e-109	NTclustered	gi\|1535915943\|ref\|XM_027344263.1\|	6956	g19261	i0	100	1.78137651821862	220	0	89	0	1	220	1988	1769	PREDICTED: Dermatophagoides pteronyssinus plasma membrane calcium-transporting ATPase 2-like (LOC113794167), mRNA	blastn	440	407	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
4591984	4591984	PRJNA782551_P_NODE_2024_length_686_cov_1.696574_g1908_i0	PRJNA782551	2024	686	1.696574	11.63849764	Drosophila melanogaster	7227	Arthropoda	Arthropoda	1173	0	NTclustered	gi\|113204896\|gb\|BT028801.1\|	7227	g1908	i0	98.083	96.6195335276968	678	5	99	7	1	677	534	1204	Drosophila melanogaster LP21747 full insert cDNA	blastn	66281	1173	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
5867090	5867090	PRJNA782551_P_NODE_14905_length_256_cov_1.683060_g14783_i0	PRJNA782551	14905	256	1.68306	4.3086336	Culex pipiens	7175	Arthropoda	Arthropoda	403	5.58e-108	NTclustered	gi\|2415558147\|ref\|XM_052711389.1\|	42434	g14783	i0	94.961	24.44140625	258	11	100	2	1	256	10651	10908	PREDICTED: Culex pipiens pallens uncharacterized LOC120431258 (LOC120431258), transcript variant X6, mRNA	blastn	6257	403	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
5867292	5867292	PRJNA782551_P_NODE_8305_length_325_cov_2.047619_g8183_i0	PRJNA782551	8305	325	2.047619	6.65476175	Ferrisia virgata	223228	Arthropoda	Arthropoda	599	8.699999999999997e-167	NTclustered	gi\|1394298201\|dbj\|LC278437.1\|	223228	g8183	i0	100	99.8153846153846	324	0	99	0	1	324	361	684	Ferrisia virgata gene for 28S ribosomal RNA, partial sequence	blastn	32440	599	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Pseudococcidae	Ferrisia	Ferrisia virgata
6316472	6316472	PRJNA782551_P_NODE_17785_length_249_cov_0.875000_g17663_i0	PRJNA782551	17785	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	455	1.47e-123	NTclustered	gi\|13027509\|gb\|AC007709.4\|AC007709	7227	g17663	i0	99.598	27.0120481927711	249	1	100	0	1	249	84893	84645	Drosophila melanogaster, chromosome 3R, region 86E-86E, BAC clone BACR13P08, complete sequence	blastn	6726	455	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
6316629	6316629	PRJNA782551_P_NODE_9825_length_300_cov_1.356828_g9703_i0	PRJNA782551	9825	300	1.356828	4.070484	root	1	Root_unresolved	Root_unresolved	549	8.119999999999997e-152	NTclustered	gi\|1049300354\|gb\|KX531311.1\|	7227	g9703	i0	99.667	65.51	300	1	100	0	1	300	387	88	Drosophila melanogaster GEO07455p1 mRNA, partial cds	blastn	19653	549	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
7142312	7142312	PRJNA782551_P_NODE_7426_length_343_cov_1.459259_g7304_i0	PRJNA782551	7426	343	1.459259	5.00525837	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	634	2.5299999999999996e-177	NTclustered	gi\|1535914814\|ref\|XR_003474832.1\|	6956	g7304	i0	100	100.288629737609	343	0	100	0	1	343	2733	3075	PREDICTED: Dermatophagoides pteronyssinus large subunit ribosomal RNA (LOC113793595), rRNA	blastn	34399	634	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
7590522	7590522	PRJNA782551_P_NODE_14066_length_262_cov_2.365079_g13944_i0	PRJNA782551	14066	262	2.365079	6.19650698	root	1	Root_unresolved	Root_unresolved	479	9.249999999999999e-131	NTclustered	gi\|442628508\|ref\|NM_136169.4\|	7227	g13944	i0	99.618	84.5801526717557	262	1	100	0	1	262	436	175	Drosophila melanogaster cytochrome c oxidase subunit 4, transcript variant A (COX4), mRNA	blastn	22160	479	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
8416872	8416872	PRJNA782551_P_NODE_7487_length_342_cov_1.007435_g7365_i0	PRJNA782551	7487	342	1.007435	3.4454277	Aedes aegypti	7159	Arthropoda	Arthropoda	571	2.0099999999999995e-158	NTclustered	gi\|1218222286\|ref\|XM_011495050.2\|	7159	g7365	i0	96.784	64.6023391812866	342	11	100	0	1	342	779	438	PREDICTED: Aedes aegypti glutathione S-transferase 1 (LOC5568355), transcript variant X2, mRNA	blastn	22094	571	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Aedes	Aedes aegypti
8865646	8865646	PRJNA782551_P_NODE_24287_length_241_cov_1.642857_g24165_i0	PRJNA782551	24287	241	1.642857	3.95928537	root	1	Root_unresolved	Root_unresolved	440	3.959999999999999e-119	NTclustered	gi\|15291438\|gb\|AY051564.1\|	7227	g24165	i0	99.585	11.0207468879668	241	1	100	0	1	241	1027	1267	Drosophila melanogaster GH21174 full length cDNA	blastn	2656	440	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
8865762	8865762	PRJNA782551_P_NODE_8387_length_323_cov_17.984000_g8265_i0	PRJNA782551	8387	323	17.984	58.08832	Lepidoptera	7088	Arthropoda	Arthropoda	595	1.1199999999999995e-165	NTclustered	gi\|2306717695\|ref\|XR_004783997.2\|	7108	g8265	i0	100	353.984520123839	322	0	99	0	2	323	2253	1932	PREDICTED: Spodoptera frugiperda large subunit ribosomal RNA (LOC118279431), rRNA	blastn	114337	595	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
9692027	9692027	PRJNA782551_P_NODE_14568_length_259_cov_1.241935_g14446_i0	PRJNA782551	14568	259	1.241935	3.21661165	Pediculus humanus	121225	Arthropoda	Arthropoda	193	1.33e-44	NTclustered	gi\|242023573\|ref\|XM_002432162.1\|	121224	g14446	i0	86.364	41	176	24	68	0	3	178	1334	1509	Pediculus humanus corporis ATP synthase subunit beta, putative (Phum_PHUM576810), partial mRNA	blastn	10619	193	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Pediculidae	Pediculus	Pediculus humanus
9692036	9692036	PRJNA782551_P_NODE_1548_length_780_cov_1.960396_g1435_i0	PRJNA782551	1548	780	1.960396	15.2910888	Phenacoccus solenopsis	483260	Arthropoda	Arthropoda	992	0	NTclustered	gi\|741985831\|gb\|KJ461274.1\|	483260	g1435	i0	89.599	69.8205128205128	798	59	100	20	1	780	2964	2173	Phenacoccus solenopsis 28S ribosomal RNA gene, partial sequence	blastn	54460	992	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Pseudococcidae	Phenacoccus	Phenacoccus solenopsis
9692090	9692090	PRJNA782551_P_NODE_19588_length_247_cov_0.885057_g19466_i0	PRJNA782551	19588	247	0.885057	2.18609079	Drosophila melanogaster	7227	Arthropoda	Arthropoda	457	4.05e-124	NTclustered	gi\|939620288\|ref\|NM_001316502.1\|	7227	g19466	i0	100	39.4817813765182	247	0	100	0	1	247	449	695	Drosophila melanogaster translationally controlled tumor protein, transcript variant B (Tctp), mRNA	blastn	9752	457	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
10141051	10141051	PRJNA782551_P_NODE_20908_length_245_cov_0.895349_g20786_i0	PRJNA782551	20908	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	453	5.1900000000000006e-123	NTclustered	gi\|665399366\|ref\|NM_001259265.2\|	7227	g20786	i0	100	32.9469387755102	245	0	100	0	1	245	811	567	Drosophila melanogaster lysine demethylase 4A, transcript variant B (Kdm4A), mRNA	blastn	8072	453	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
10967808	10967808	PRJNA782551_P_NODE_19429_length_247_cov_0.885057_g19307_i0	PRJNA782551	19429	247	0.885057	2.18609079	Monomorium pharaonis	307658	Arthropoda	Arthropoda	326	1.19e-84	NTclustered	gi\|1911063914\|ref\|XR_004962229.1\|	307658	g19307	i0	90.514	2.07287449392713	253	14	99	5	4	247	11533	11282	PREDICTED: Monomorium pharaonis uncharacterized LOC118644417 (LOC118644417), ncRNA	blastn	512	326	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Monomorium	Monomorium pharaonis
11416394	11416394	PRJNA782551_P_NODE_19689_length_247_cov_0.885057_g19567_i0	PRJNA782551	19689	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	457	4.05e-124	NTclustered	gi\|665395397\|ref\|NM_001300663.1\|	7227	g19567	i0	100	45.0404858299595	247	0	100	0	1	247	971	725	Drosophila melanogaster non-claret disjunctional (ncd), transcript variant B, mRNA	blastn	11125	457	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
11416478	11416478	PRJNA782551_P_NODE_5369_length_402_cov_12.191489_g5247_i0	PRJNA782551	5369	402	12.191489	49.00978578	Lepidoptera	7088	Arthropoda	Arthropoda	743	0	NTclustered	gi\|2306717695\|ref\|XR_004783997.2\|	7108	g5247	i0	100	347.781094527363	402	0	100	0	1	402	3872	3471	PREDICTED: Spodoptera frugiperda large subunit ribosomal RNA (LOC118279431), rRNA	blastn	139808	743	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
12243380	12243380	PRJNA782551_P_NODE_6290_length_371_cov_4.825503_g6168_i0	PRJNA782551	6290	371	4.825503	17.90261613	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	634	2.75e-177	NTclustered	gi\|2306717695\|ref\|XR_004783997.2\|	7108	g6168	i0	100	346.404312668464	343	0	100	0	1	343	2637	2295	PREDICTED: Spodoptera frugiperda large subunit ribosomal RNA (LOC118279431), rRNA	blastn	128516	634	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
12692121	12692121	PRJNA782551_P_NODE_13450_length_267_cov_1.587629_g13328_i0	PRJNA782551	13450	267	1.587629	4.23896943	Timema	61471	Arthropoda	Arthropoda	60.2	1.46e-4	NTclustered	gi\|1947851601\|emb\|OD568924.1\|	61472	g13328	i0	100	0.692883895131086	32	0	12	0	34	65	27870	27901	4_Tbi_b3v08	blastn	185	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema bartmani
13517562	13517562	PRJNA782551_P_NODE_4711_length_431_cov_1.290503_g4589_i0	PRJNA782551	4711	431	1.290503	5.56206793	Sternochetus mangiferae	925794	Arthropoda	Arthropoda	797	0	NTclustered	gi\|2328386701\|ref\|NC_068213.1\|	925794	g4589	i0	100	97.8399071925754	431	0	100	0	1	431	5117	5547	Sternochetus mangiferae mitochondrion, complete genome	blastn	42169	797	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Sternochetus	Sternochetus mangiferae
13966548	13966548	PRJNA782551_P_NODE_8531_length_321_cov_1.241935_g8409_i0	PRJNA782551	8531	321	1.241935	3.98661135	root	1	Root_unresolved	Root_unresolved	547	3.149999999999999e-151	NTclustered	gi\|442631401\|ref\|NM_079287.2\|	7227	g8409	i0	99.338	72.7165109034268	302	2	94	0	1	302	756	455	Drosophila melanogaster ATP synthase, subunit B (ATPsynB), mRNA	blastn	23342	547	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
14792157	14792157	PRJNA782551_P_NODE_11832_length_280_cov_1.318841_g11710_i0	PRJNA782551	11832	280	1.318841	3.6927548	Drosophila melanogaster	7227	Arthropoda	Arthropoda	488	1.6599999999999998e-133	NTclustered	gi\|18447327\|gb\|AY075409.1\|	7227	g11710	i0	98.221	7.65714285714286	281	1	100	2	1	280	417	140	Drosophila melanogaster LD33329 full length cDNA	blastn	2144	488	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
14792240	14792240	PRJNA782551_P_NODE_18512_length_248_cov_0.880000_g18390_i0	PRJNA782551	18512	248	0.88	2.1824	Aedes aegypti	7159	Arthropoda	Arthropoda	446	8.81e-121	NTclustered	gi\|20977804\|gb\|AF435023.1\|	7159	g18390	i0	99.19	9.32258064516129	247	2	99	0	2	248	3750	3504	Aedes aegypti ETS transcription factor E74A (E74A) mRNA, complete cds	blastn	2312	446	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Aedes	Aedes aegypti
15240819	15240819	PRJNA782551_P_NODE_10292_length_293_cov_1.400000_g10170_i0	PRJNA782551	10292	293	1.4	4.102	root	1	Root_unresolved	Root_unresolved	542	1.32e-149	NTclustered	gi\|13162478\|gb\|AC007475.7\|AC007475	7227	g10170	i0	100	31.9795221843003	293	0	100	0	1	293	170587	170295	Drosophila melanogaster, chromosome 2R, region 49A-49B, BAC clone BACR04E21, complete sequence	blastn	9370	542	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
15240827	15240827	PRJNA782551_P_NODE_1092_length_909_cov_4.315789_g989_i0	PRJNA782551	1092	909	4.315789	39.23052201	Anastrepha	28585	Arthropoda	Arthropoda	682	0	NTclustered	gi\|2453197034\|ref\|XM_054093020.1\|	28586	g989	i0	80.396	99.4422442244224	908	168	99	10	1	903	420	1322	PREDICTED: Anastrepha ludens actin, cytoplasmic A3a (LOC128857310), transcript variant X3, mRNA	blastn	90393	682	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Anastrepha	Anastrepha ludens
15240931	15240931	PRJNA782551_P_NODE_24492_length_241_cov_0.916667_g24370_i0	PRJNA782551	24492	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	446	8.519999999999999e-121	NTclustered	gi\|50872308\|gb\|AC099038.2\|	7227	g24370	i0	100	11.4730290456432	241	0	100	0	1	241	36444	36204	Drosophila melanogaster clone BACR28A23, complete sequence	blastn	2765	446	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
16066195	16066195	PRJNA782551_P_NODE_3393_length_517_cov_6.554054_g3271_i0	PRJNA782551	3393	517	6.554054	33.88445918	Lysiphlebia japonica	104022	Arthropoda	Arthropoda	900	0	NTclustered	gi\|1251773067\|gb\|KY809861.1\|	104022	g3271	i0	98.249	58.3655705996132	514	9	99	0	1	514	10	523	Lysiphlebia japonica ribosomal protein S18 mRNA, complete cds	blastn	30175	900	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Lysiphlebia	Lysiphlebia japonica
16066219	16066219	PRJNA782551_P_NODE_6053_length_378_cov_3.924590_g5931_i0	PRJNA782551	6053	378	3.92459	14.8349502	Lysiphlebia japonica	104022	Arthropoda	Arthropoda	494	4.98e-135	NTclustered	gi\|1251773071\|gb\|KY809863.1\|	104022	g5931	i0	98.227	25.1666666666667	282	5	75	0	97	378	409	128	Lysiphlebia japonica ribosomal protein L27 mRNA, complete cds	blastn	9513	494	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Lysiphlebia	Lysiphlebia japonica
16515366	16515366	PRJNA782551_P_NODE_11933_length_279_cov_1.495146_g11811_i0	PRJNA782551	11933	279	1.495146	4.17145734	Opisthokonta	33154	Arthropoda	Arthropoda	516	7.58e-142	NTclustered	gi\|1494774796\|ref\|XR_003394590.1\|	121845	g11811	i0	100	45.0537634408602	279	0	100	0	1	279	383	661	PREDICTED: Diaphorina citri large subunit ribosomal RNA (LOC113472154), rRNA	blastn	12570	516	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Psyllidae	Diaphorina	Diaphorina citri
16515444	16515444	PRJNA782551_P_NODE_22173_length_244_cov_0.900585_g22051_i0	PRJNA782551	22173	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	394	3.17e-105	NTclustered	gi\|1962580694\|emb\|OC914905.1\|	334625	g22051	i0	95.885	4.92622950819672	243	10	99	0	2	244	20756	20998	Oppiella nova	blastn	1202	396	0.994949494949495	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
16515461	16515461	PRJNA782551_P_NODE_23893_length_242_cov_0.911243_g23771_i0	PRJNA782551	23893	242	0.911243	2.20520806	Centruroides	6875	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|2786504856\|ref\|XM_067270659.1\|	120091	g23771	i0	100	0.578512396694215	28	0	12	0	212	239	3072	3099	PREDICTED: Centruroides vittatus zinc finger protein 280C-like (LOC136975570), transcript variant X2, mRNA	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Scorpiones	Buthidae	Centruroides	Centruroides vittatus
17341889	17341889	PRJNA782551_P_NODE_18934_length_248_cov_0.880000_g18812_i0	PRJNA782551	18934	248	0.88	2.1824	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	453	5.2600000000000005e-123	NTclustered	gi\|2306717414\|ref\|XM_050707620.1\|	7108	g18812	i0	99.597	70.1653225806452	248	1	100	0	1	248	1432	1679	PREDICTED: Spodoptera frugiperda uncharacterized LOC118264398 (LOC118264398), mRNA	blastn	17401	453	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
17790283	17790283	PRJNA782551_P_NODE_4074_length_468_cov_1.754430_g3952_i0	PRJNA782551	4074	468	1.75443	8.2107324	Eriophyidae	70320	Arthropoda	Arthropoda	721	0	NTclustered	gi\|2044620018\|gb\|MZ279739.1\|	2837795	g3952	i0	94.872	99.8397435897436	468	13	100	7	1	468	582	126	Bambusacarus longipalpis voucher AH4_4 small subunit ribosomal RNA gene, partial sequence	blastn	46725	728	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Eriophyidae	Bambusacarus	Bambusacarus longipalpis
18615333	18615333	PRJNA782551_P_NODE_23975_length_242_cov_0.911243_g23853_i0	PRJNA782551	23975	242	0.911243	2.20520806	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	448	2.3799999999999995e-121	NTclustered	gi\|1535922381\|ref\|XM_027347829.1\|	6956	g23853	i0	100	2.53719008264463	242	0	100	0	1	242	1819	2060	PREDICTED: Dermatophagoides pteronyssinus exocyst complex component 5-like (LOC113797454), transcript variant X2, mRNA	blastn	614	448	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
19064152	19064152	PRJNA782551_P_NODE_17755_length_249_cov_0.875000_g17633_i0	PRJNA782551	17755	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	460	3.16e-125	NTclustered	gi\|16769433\|gb\|AY061388.1\|	7227	g17633	i0	100	11.855421686747	249	0	100	0	1	249	948	700	Drosophila melanogaster LD31217 full length cDNA	blastn	2952	460	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
19064217	19064217	PRJNA782551_P_NODE_2955_length_558_cov_6.921649_g2834_i0	PRJNA782551	2955	558	6.921649	38.62280142	Lepidoptera	7088	Arthropoda	Arthropoda	1020	0	NTclustered	gi\|2306717695\|ref\|XR_004783997.2\|	7108	g2834	i0	99.642	185.996415770609	558	2	100	0	1	558	941	384	PREDICTED: Spodoptera frugiperda large subunit ribosomal RNA (LOC118279431), rRNA	blastn	103786	1020	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
19064282	19064282	PRJNA782551_P_NODE_6735_length_359_cov_2.153846_g6613_i0	PRJNA782551	6735	359	2.153846	7.73230714	Lepidoptera	7088	Arthropoda	Arthropoda	658	0	NTclustered	gi\|937827783\|gb\|KT343379.1\|	7102	g6613	i0	99.721	255.782729805014	359	1	100	0	1	359	14	372	Heliothis virescens voucher Hvir_SIMRU 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence	blastn	91826	658	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Heliothis	Heliothis virescens
19890407	19890407	PRJNA782551_P_NODE_12276_length_276_cov_4.551724_g12154_i0	PRJNA782551	12276	276	4.551724	12.56275824	Macdunnoughia confusa	254380	Arthropoda	Arthropoda	477	3.529999999999999e-130	NTclustered	gi\|2917930147\|emb\|OZ234927.1\|	254380	g12154	i0	97.834	138.836956521739	277	4	100	2	1	276	11585779	11585504	Macdunnoughia confusa genome assembly, chromosome: 1	blastn	38319	477	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Macdunnoughia	Macdunnoughia confusa
19890612	19890612	PRJNA782551_P_NODE_5376_length_402_cov_2.574468_g5254_i0	PRJNA782551	5376	402	2.574468	10.34936136	Phenacoccus solenopsis	483260	Arthropoda	Arthropoda	335	3.4199999999999985e-87	NTclustered	gi\|741985858\|gb\|KJ461301.1\|	483260	g5254	i0	84.636	33.0597014925373	371	19	86	19	1	345	1244	886	Phenacoccus solenopsis 18S ribosomal RNA gene, partial sequence	blastn	13290	335	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Pseudococcidae	Phenacoccus	Phenacoccus solenopsis
19890619	19890619	PRJNA782551_P_NODE_6156_length_375_cov_1.529801_g6034_i0	PRJNA782551	6156	375	1.529801	5.73675375	Sternochetus mangiferae	925794	Arthropoda	Arthropoda	693	0	NTclustered	gi\|2328386701\|ref\|NC_068213.1\|	925794	g6034	i0	100	87.5546666666667	375	0	100	0	1	375	7445	7819	Sternochetus mangiferae mitochondrion, complete genome	blastn	32833	693	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Sternochetus	Sternochetus mangiferae
21166192	21166192	PRJNA782551_P_NODE_14097_length_262_cov_1.629630_g13975_i0	PRJNA782551	14097	262	1.62963	4.2696306	Coccinella septempunctata	41139	Arthropoda	Arthropoda	69.4	2.37e-7	NTclustered	gi\|2125266636\|ref\|XR_006537940.1\|	41139	g13975	i0	85.938	1.38931297709924	64	9	24	0	1	64	140	203	PREDICTED: Coccinella septempunctata uncharacterized LOC123315318 (LOC123315318), ncRNA	blastn	364	69.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Coccinella	Coccinella septempunctata
21614732	21614732	PRJNA782551_P_NODE_24937_length_241_cov_0.916667_g24815_i0	PRJNA782551	24937	241	0.916667	2.20916747	Metazoa	33208	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|1729054392\|ref\|XM_030530474.1\|	7225	g24815	i0	100	3.19502074688797	30	0	12	0	81	110	3756	3727	PREDICTED: Scaptodrosophila lebanonensis collagen alpha-1(XVIII) chain (LOC115633094), mRNA	blastn	770	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Scaptodrosophila	Scaptodrosophila lebanonensis
22440976	22440976	PRJNA782551_P_NODE_16538_length_250_cov_0.870056_g16416_i0	PRJNA782551	16538	250	0.870056	2.17514	Drosophila melanogaster	7227	Arthropoda	Arthropoda	462	8.83e-126	NTclustered	gi\|442618323\|ref\|NM_141686.3\|	7227	g16416	i0	100	23.244	250	0	100	0	1	250	290	41	Drosophila melanogaster uncharacterized protein, transcript variant A (CG9471), mRNA	blastn	5811	462	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
22441082	22441082	PRJNA782551_P_NODE_24218_length_241_cov_2.636905_g24096_i0	PRJNA782551	24218	241	2.636905	6.35494105	Ilyocryptus agilis	435267	Arthropoda	Arthropoda	446	8.519999999999999e-121	NTclustered	gi\|2488180980\|emb\|OC986661.1\|	435267	g24096	i0	100	2	241	0	100	0	1	241	509	269	Ilyocryptus agilis EOG090X08QZ gene for EOG090X08QZ	blastn	482	446	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Macrotrichidae	Ilyocryptus	Ilyocryptus agilis
22890160	22890160	PRJNA782551_P_NODE_21618_length_244_cov_1.561404_g21496_i0	PRJNA782551	21618	244	1.561404	3.80982576	root	1	Root_unresolved	Root_unresolved	446	8.639999999999999e-121	NTclustered	gi\|442619663\|ref\|NM_142391.5\|	7227	g21496	i0	99.59	17.9426229508197	244	1	100	0	1	244	1964	1721	Drosophila melanogaster Peroxinectin-like (Pxt), mRNA	blastn	4378	446	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
24990029	24990029	PRJNA782551_P_NODE_1140_length_888_cov_9.061350_g1036_i0	PRJNA782551	1140	888	9.06135	80.464788	Sternochetus mangiferae	925794	Arthropoda	Arthropoda	1635	0	NTclustered	gi\|2328386701\|ref\|NC_068213.1\|	925794	g1036	i0	100	95.0822072072072	885	0	99	0	4	888	15216	16100	Sternochetus mangiferae mitochondrion, complete genome	blastn	84433	1635	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Sternochetus	Sternochetus mangiferae
24990261	24990261	PRJNA782551_P_NODE_5680_length_391_cov_1.638365_g5558_i0	PRJNA782551	5680	391	1.638365	6.40600715	Ferrisia virgata	223228	Arthropoda	Arthropoda	710	0	NTclustered	gi\|1967529443\|gb\|MW542090.1\|	223228	g5558	i0	99.488	101.475703324808	391	1	100	1	1	391	518	129	Ferrisia virgata voucher 160805-PHI-29(IN17) large subunit ribosomal RNA gene, partial sequence	blastn	39677	710	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Pseudococcidae	Ferrisia	Ferrisia virgata

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