metadata: contig_metadata: 69 rows where bioproject = "PRJNA1047551" and tax

69 rows where bioproject = "PRJNA1047551" 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
174503	174503	PRJNA1047551_S_NODE_10781_length_163_cov_1.867188_g10654_i0	PRJNA1047551	10781	163	1.867188	3.04351644	Aphis gossypii	80765	Arthropoda	Arthropoda	254	3.47e-63	NTclustered	gi\|2288489758\|ref\|XM_050202984.1\|	80765	g10654	i0	96.732	3.19631901840491	153	3	93	2	1	152	669	518	PREDICTED: Aphis gossypii ubiquitin-60S ribosomal protein L40 (LOC114129003), mRNA	blastn	521	254	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Aphis	Aphis gossypii
174527	174527	PRJNA1047551_S_NODE_12321_length_155_cov_4.883333_g12194_i0	PRJNA1047551	12321	155	4.883333	7.56916615	Zerynthia rumina	132710	Arthropoda	Arthropoda	52.8	0.013	NTclustered	gi\|2918382484\|emb\|OZ238062.1\|	132710	g12194	i0	100	0.361290322580645	28	0	18	0	91	118	16344218	16344191	Zerynthia rumina genome assembly, chromosome: 27	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Zerynthia	Zerynthia rumina
174536	174536	PRJNA1047551_S_NODE_12781_length_154_cov_1.201681_g12654_i0	PRJNA1047551	12781	154	1.201681	1.85058874	Orientabia sinica	2714596	Arthropoda	Arthropoda	130	5.68e-26	NTclustered	gi\|2328378919\|ref\|NC_068099.1\|	2714596	g12654	i0	84.058	7.68181818181818	138	19	89	3	10	146	5331	5466	Orientabia sinica isolate CSCS-Hym-MC0043 mitochondrion, complete genome	blastn	1183	130	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Cimbicidae	Orientabia	Orientabia sinica
174654	174654	PRJNA1047551_S_NODE_4641_length_222_cov_1.566845_g4514_i0	PRJNA1047551	4641	222	1.566845	3.4783959	Drosophila guanche	7266	Arthropoda	Arthropoda	137	5.279999999999999e-28	NTclustered	gi\|1839704704\|ref\|XM_034264104.1\|	7266	g4514	i0	78.505	12.0810810810811	214	42	95	4	2	213	444	233	PREDICTED: Drosophila guanche 40S ribosomal protein S15 (LOC117578537), mRNA	blastn	2682	137	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila guanche
174740	174740	PRJNA1047551_S_NODE_8161_length_181_cov_1.212329_g8034_i0	PRJNA1047551	8161	181	1.212329	2.19431549	Isometrus maculatus	497827	Arthropoda	Arthropoda	121	4.159999999999999e-23	NTclustered	gi\|187474736\|gb\|EU252385.1\|	497827	g8034	i0	84.874	3.04419889502762	119	18	66	0	41	159	238	120	Isometrus maculatus clone Imsingleton0104 hypothetical protein mRNA, complete cds	blastn	551	121	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Scorpiones	Buthidae	Isometrus	Isometrus maculatus
1009844	1009844	PRJNA1047551_S_NODE_6701_length_194_cov_1.490566_g6574_i0	PRJNA1047551	6701	194	1.490566	2.89169804	Aphididae	27482	Arthropoda	Arthropoda	300	5.420000000000001e-77	NTclustered	gi\|1028665414\|ref\|XM_016802429.1\|	7029	g6574	i0	96.175	19.2422680412371	183	7	94	0	1	183	346	528	PREDICTED: Acyrthosiphon pisum protein bric-a-brac 1 (LOC100163259), mRNA	blastn	3733	300	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
2725055	2725055	PRJNA1047551_S_NODE_1743_length_338_cov_2.118812_g1616_i0	PRJNA1047551	1743	338	2.118812	7.16158456	Diuraphis noxia	143948	Arthropoda	Arthropoda	383	9.96e-102	NTclustered	gi\|985386344\|ref\|XM_015513736.1\|	143948	g1616	i0	87.097	6.02366863905325	341	41	100	3	1	338	1991	1651	PREDICTED: Diuraphis noxia probable splicing factor, arginine/serine-rich 7 (LOC107165483), mRNA	blastn	2036	383	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Diuraphis	Diuraphis noxia
2725101	2725101	PRJNA1047551_S_NODE_323_length_721_cov_5.307580_g228_i0	PRJNA1047551	323	721	5.30758	38.2676518	Lissorhoptrus oryzophilus	308863	Arthropoda	Arthropoda	826	0	NTclustered	gi\|1236771285\|gb\|MF441473.1\|	308863	g228	i0	92.427	66.2371705963939	581	40	80	4	112	690	579	1	Lissorhoptrus oryzophilus ribosomal protein L20 mRNA, complete cds	blastn	47757	826	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Erirhinidae	Lissorhoptrus	Lissorhoptrus oryzophilus
2725182	2725182	PRJNA1047551_S_NODE_6343_length_198_cov_1.490798_g6216_i0	PRJNA1047551	6343	198	1.490798	2.95178004	Harmonia axyridis	115357	Arthropoda	Arthropoda	361	2.51e-95	NTclustered	gi\|2170028458\|ref\|XM_045611247.1\|	115357	g6216	i0	99.495	2	198	1	100	0	1	198	1291	1488	PREDICTED: Harmonia axyridis thioredoxin-2-like (LOC123675753), mRNA	blastn	396	361	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Harmonia	Harmonia axyridis
2725239	2725239	PRJNA1047551_S_NODE_8823_length_176_cov_1.014184_g8696_i0	PRJNA1047551	8823	176	1.014184	1.78496384	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	309	7.98e-80	NTclustered	gi\|239789248\|dbj\|AK340702.1\|	7029	g8696	i0	98.295	25.2613636363636	176	3	100	0	1	176	451	626	Acyrthosiphon pisum ACYPI000543 mRNA, clone: 651M3, complete cds, full-insert cDNA sequence based on the ESTs (5'-EST:FF319685, 3'-EST:FF320767)	blastn	4446	309	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
4001199	4001199	PRJNA1047551_S_NODE_7524_length_186_cov_1.185430_g7397_i0	PRJNA1047551	7524	186	1.18543	2.2048998	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	344	2.34e-90	NTclustered	gi\|2621251915\|ref\|XM_061018509.1\|	44670	g7397	i0	100	17.0806451612903	186	0	100	0	1	186	1289	1474	PREDICTED: Metopolophium dirhodum eukaryotic initiation factor 4A (LOC132948160), mRNA	blastn	3177	344	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum
5277355	5277355	PRJNA1047551_S_NODE_13585_length_150_cov_2.208696_g13458_i0	PRJNA1047551	13585	150	2.208696	3.313044	Harmonia axyridis	115357	Arthropoda	Arthropoda	267	4.009999999999999e-67	NTclustered	gi\|2170048789\|ref\|XM_045616461.1\|	115357	g13458	i0	98.675	1.00666666666667	151	1	100	1	1	150	606	456	PREDICTED: Harmonia axyridis endocuticle structural glycoprotein SgAbd-2-like (LOC123679089), mRNA	blastn	151	267	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Harmonia	Harmonia axyridis
5277437	5277437	PRJNA1047551_S_NODE_4265_length_230_cov_1.651282_g4138_i0	PRJNA1047551	4265	230	1.651282	3.7979486	Melanaphis sacchari	742174	Arthropoda	Arthropoda	298	2.39e-76	NTclustered	gi\|1410986845\|ref\|XM_025351862.1\|	742174	g4138	i0	91.284	30.3434782608696	218	19	95	0	13	230	451	234	PREDICTED: Melanaphis sacchari PHD finger-like domain-containing protein 5A (LOC112603342), mRNA	blastn	6979	298	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Melanaphis	Melanaphis sacchari
5277450	5277450	PRJNA1047551_S_NODE_4665_length_221_cov_11.580645_g4538_i0	PRJNA1047551	4665	221	11.580645	25.59322545	Darwinula stevensoni	69355	Arthropoda	Arthropoda	93.5	1.15e-14	NTclustered	gi\|1936503058\|emb\|LR899836.1\|	69355	g4538	i0	91.304	5.09502262443439	69	5	31	1	146	214	113378	113445	Darwinula stevensoni	blastn	1126	93.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
6552565	6552565	PRJNA1047551_S_NODE_3866_length_240_cov_1.614634_g3739_i0	PRJNA1047551	3866	240	1.614634	3.8751216	Artemia franciscana	6661	Arthropoda	Arthropoda	444	3.05e-120	NTclustered	gi\|2743066240\|ref\|XM_065702161.1\|	6661	g3739	i0	100	2	240	0	100	0	1	240	3378	3617	PREDICTED: Artemia franciscana probable chitinase 10 (LOC136026013), transcript variant X1, mRNA	blastn	480	444	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
7387645	7387645	PRJNA1047551_S_NODE_8986_length_174_cov_4.381295_g8859_i0	PRJNA1047551	8986	174	4.381295	7.6234533	Hemiptera	7524	Arthropoda	Arthropoda	322	1.01e-83	NTclustered	gi\|1685532754\|ref\|XM_029491922.1\|	7029	g8859	i0	100	100.011494252874	174	0	100	0	1	174	1043	870	PREDICTED: Acyrthosiphon pisum uncharacterized LOC115034613 (LOC115034613), transcript variant X2, mRNA	blastn	17402	322	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
7827271	7827271	PRJNA1047551_S_NODE_5227_length_213_cov_1.702247_g5100_i0	PRJNA1047551	5227	213	1.702247	3.62578611	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	52.8	0.019	NTclustered	gi\|2621239124\|ref\|XM_061012002.1\|	44670	g5100	i0	100	0.262910798122066	28	0	13	0	30	57	77	104	PREDICTED: Metopolophium dirhodum class A basic helix-loop-helix protein 15-like (LOC132943156), transcript variant X2, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum
7827376	7827376	PRJNA1047551_S_NODE_9567_length_171_cov_1.051471_g9440_i0	PRJNA1047551	9567	171	1.051471	1.79801541	Toxomerus marginatus	115329	Arthropoda	Arthropoda	311	2.14e-80	NTclustered	gi\|299561665\|gb\|HM062568.1\|	115329	g9440	i0	99.415	95.6666666666667	171	1	100	0	1	171	682	512	Toxomerus marginatus cytochrome b gene, partial cds; mitochondrial	blastn	16359	311	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Syrphidae	Toxomerus	Toxomerus marginatus
9102327	9102327	PRJNA1047551_S_NODE_8548_length_178_cov_1.258741_g8421_i0	PRJNA1047551	8548	178	1.258741	2.24055898	Timema douglasi	61478	Arthropoda	Arthropoda	294	2.27e-75	NTclustered	gi\|1936766486\|emb\|OA594500.1\|	61478	g8421	i0	97.661	0.960674157303371	171	4	96	0	8	178	1547	1377	1_Tdi_b3v08	blastn	171	294	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema douglasi
9937964	9937964	PRJNA1047551_S_NODE_5368_length_211_cov_1.664773_g5241_i0	PRJNA1047551	5368	211	1.664773	3.51267103	Aphididae	27482	Arthropoda	Arthropoda	324	3.56e-84	NTclustered	gi\|1028688092\|ref\|XM_008182099.2\|	7029	g5241	i0	94.313	27.8199052132701	211	12	100	0	1	211	178	388	PREDICTED: Acyrthosiphon pisum ribosomal protein S27-1 (Rps27-1), transcript variant X1, mRNA	blastn	5870	324	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
10377866	10377866	PRJNA1047551_S_NODE_3569_length_248_cov_1.075117_g3442_i0	PRJNA1047551	3569	248	1.075117	2.66629016	Leptotrombidium deliense	299467	Arthropoda	Arthropoda	118	9.919999999999999e-29	NR	RWS31269.1	299467	g3442	i0	85.5	0.75	62	9	75	0	248	63	562	623	RWS31269.1 alpha 1:2 mannosidase precursor-like protein [Leptotrombidium deliense]	diamond	186	118	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
10377872	10377872	PRJNA1047551_S_NODE_389_length_666_cov_18.269414_g258_i1	PRJNA1047551	389	666	18.269414	121.67429724	Demodex environmental sample	1856688	Arthropoda	Arthropoda	856	0	NTclustered	gi\|1040064834\|gb\|KU363928.1\|	1856688	g258	i1	92.537	82.8918918918919	603	36	90	7	19	617	1	598	Demodex environmental sample clone K-7-14-37 28S ribosomal RNA gene, partial sequence	blastn	55206	856	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex environmental sample
11653050	11653050	PRJNA1047551_S_NODE_12030_length_157_cov_1.491803_g11903_i0	PRJNA1047551	12030	157	1.491803	2.34213071	Harmonia axyridis	115357	Arthropoda	Arthropoda	278	1.96e-70	NTclustered	gi\|2170063126\|ref\|XM_045621171.1\|	115357	g11903	i0	99.346	2.92356687898089	153	1	97	0	1	153	592	440	PREDICTED: Harmonia axyridis uncharacterized LOC123682524 (LOC123682524), mRNA	blastn	459	278	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Harmonia	Harmonia axyridis
11653238	11653238	PRJNA1047551_S_NODE_7170_length_189_cov_1.597403_g7043_i0	PRJNA1047551	7170	189	1.597403	3.01909167	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	344	2.39e-90	NTclustered	gi\|2621257225\|ref\|XM_061021244.1\|	44670	g7043	i0	99.471	9.97354497354497	189	1	100	0	1	189	333	521	PREDICTED: Metopolophium dirhodum large ribosomal subunit protein uL15 (LOC132950049), mRNA	blastn	1885	344	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum
12928196	12928196	PRJNA1047551_S_NODE_10771_length_163_cov_1.968750_g10644_i0	PRJNA1047551	10771	163	1.96875	3.2090625	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	257	2.68e-64	NTclustered	gi\|1685563241\|ref\|XM_008186544.3\|	7029	g10644	i0	95.652	1.87730061349693	161	6	99	1	1	161	1839	1998	PREDICTED: Acyrthosiphon pisum eukaryotic initiation factor 4A (LOC100161248), transcript variant X2, mRNA	blastn	306	257	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
12928385	12928385	PRJNA1047551_S_NODE_6011_length_202_cov_1.497006_g5884_i0	PRJNA1047551	6011	202	1.497006	3.02395212	Myzus persicae	13164	Arthropoda	Arthropoda	257	3.47e-64	NTclustered	gi\|1230161904\|ref\|XM_022322894.1\|	13164	g5884	i0	89.604	3.83663366336634	202	21	100	0	1	202	2210	2411	PREDICTED: Myzus persicae serine/arginine-rich splicing factor 11 (LOC111039383), mRNA	blastn	775	257	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Myzus	Myzus persicae
12928472	12928472	PRJNA1047551_S_NODE_9491_length_171_cov_1.735294_g9364_i0	PRJNA1047551	9491	171	1.735294	2.96735274	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	255	1.02e-63	NTclustered	gi\|2621241933\|ref\|XM_061013451.1\|	44670	g9364	i0	96.154	6.47953216374269	156	6	91	0	1	156	203	48	PREDICTED: Metopolophium dirhodum small ribosomal subunit protein uS12 (LOC132944217), mRNA	blastn	1108	255	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum
12928477	12928477	PRJNA1047551_S_NODE_9631_length_170_cov_1.874074_g9504_i0	PRJNA1047551	9631	170	1.874074	3.1859258	Drosophila melanogaster	7227	Arthropoda	Arthropoda	52.8	0.014	NTclustered	gi\|2039274\|gb\|U71219.1\|DMU71219	7227	g9504	i0	100	0.164705882352941	28	0	16	0	112	139	1639	1666	Drosophila melanogaster males-absent on the first (mof) gene, complete cds	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
13763201	13763201	PRJNA1047551_S_NODE_3511_length_249_cov_2.523364_g3384_i0	PRJNA1047551	3511	249	2.523364	6.28317636	Aphididae	27482	Arthropoda	Arthropoda	449	6.840000000000001e-122	NTclustered	gi\|2577859582\|ref\|NC_081990.1\|	43146	g3384	i0	99.197	101.248995983936	249	2	100	0	1	249	13847	13599	Rhopalosiphum maidis mitochondrion, complete genome	blastn	25211	449	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Rhopalosiphum	Rhopalosiphum maidis
14203201	14203201	PRJNA1047551_S_NODE_12032_length_157_cov_1.491803_g11905_i0	PRJNA1047551	12032	157	1.491803	2.34213071	Rhopalosiphum maidis	43146	Arthropoda	Arthropoda	148	1.61e-31	NTclustered	gi\|1503167769\|ref\|XM_026961146.1\|	43146	g11905	i0	87.407	5.14649681528662	135	10	85	4	1	134	726	598	PREDICTED: Rhopalosiphum maidis cuticle protein-like (LOC113556292), mRNA	blastn	808	148	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Rhopalosiphum	Rhopalosiphum maidis
14203274	14203274	PRJNA1047551_S_NODE_2292_length_299_cov_8.007576_g2165_i0	PRJNA1047551	2292	299	8.007576	23.94265224	Ornithodoros turicata	34597	Arthropoda	Arthropoda	69.4	2.76e-7	NTclustered	gi\|2720974180\|ref\|XM_064632395.1\|	34597	g2165	i0	95.349	18.8996655518395	43	2	14	0	255	297	1497	1455	PREDICTED: Ornithodoros turicata uncharacterized LOC135400560 (LOC135400560), mRNA	blastn	5651	69.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Argasidae	Ornithodoros	Ornithodoros turicata
14203410	14203410	PRJNA1047551_S_NODE_7652_length_185_cov_1.200000_g7525_i0	PRJNA1047551	7652	185	1.2	2.22	Harmonia axyridis	115357	Arthropoda	Arthropoda	342	8.369999999999999e-90	NTclustered	gi\|2170046096\|ref\|XM_045615534.1\|	115357	g7525	i0	100	1.68108108108108	185	0	100	0	1	185	2722	2906	PREDICTED: Harmonia axyridis coatomer subunit beta' (LOC123678492), mRNA	blastn	311	342	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Harmonia	Harmonia axyridis
15037527	15037527	PRJNA1047551_S_NODE_8472_length_178_cov_2.153846_g8345_i0	PRJNA1047551	8472	178	2.153846	3.83384588	Insecta	50557	Arthropoda	Arthropoda	58.4	3.24e-4	NTclustered	gi\|1418071977\|ref\|XM_025410325.1\|	104421	g8345	i0	97.059	8.53370786516854	34	1	19	0	43	76	1647	1614	PREDICTED: Camponotus floridanus NGFI-A-binding protein homolog (LOC105252362), transcript variant X1, mRNA	blastn	1519	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Camponotus	Camponotus floridanus
15477299	15477299	PRJNA1047551_S_NODE_13753_length_150_cov_1.252174_g13626_i0	PRJNA1047551	13753	150	1.252174	1.878261	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	267	4.009999999999999e-67	NTclustered	gi\|2621240836\|ref\|XM_061012894.1\|	44670	g13626	i0	98.667	15.1933333333333	150	2	100	0	1	150	469	618	PREDICTED: Metopolophium dirhodum dnaJ homolog subfamily A member 1 (LOC132943792), mRNA	blastn	2279	267	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum
16751518	16751518	PRJNA1047551_S_NODE_3114_length_263_cov_2.171053_g2987_i0	PRJNA1047551	3114	263	2.171053	5.70986939	Artemia franciscana	6661	Arthropoda	Arthropoda	475	1.2e-129	NTclustered	gi\|2743052604\|ref\|XM_065722675.1\|	6661	g2987	i0	99.242	1.00380228136882	264	1	100	1	1	263	550	287	PREDICTED: Artemia franciscana methionine-R-sulfoxide reductase B1-like (LOC136039165), mRNA	blastn	264	475	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
16751585	16751585	PRJNA1047551_S_NODE_5534_length_208_cov_3.219653_g5407_i0	PRJNA1047551	5534	208	3.219653	6.69687824	Harmonia axyridis	115357	Arthropoda	Arthropoda	359	9.59e-95	NTclustered	gi\|854892197\|gb\|KR108208.1\|	115357	g5407	i0	100	92.0192307692308	194	0	93	0	15	208	12432	12239	Harmonia axyridis mitochondrion, partial genome	blastn	19140	359	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Harmonia	Harmonia axyridis
17587673	17587673	PRJNA1047551_S_NODE_5054_length_215_cov_5.672222_g4927_i0	PRJNA1047551	5054	215	5.672222	12.1952773	Aphididae	27482	Arthropoda	Arthropoda	381	2.1299999999999996e-101	NTclustered	gi\|2620630428\|ref\|XR_009661998.1\|	40932	g4927	i0	100	93.1441860465116	206	0	96	0	10	215	3965	3760	PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA	blastn	20026	381	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Rhopalosiphum	Rhopalosiphum padi
18026305	18026305	PRJNA1047551_S_NODE_11135_length_161_cov_2.555556_g11008_i0	PRJNA1047551	11135	161	2.555556	4.11444516	Quadratum sp. NJAUAcariEriYN304.4	1648467	Arthropoda	Arthropoda	97.1	6.09e-16	NTclustered	gi\|828276403\|gb\|KM111004.1\|	1648467	g11008	i0	91.549	2.01863354037267	71	5	43	1	21	90	107	37	Quadratum sp. NJAUAcariEriYN304.4 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	325	97.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Eriophyidae	Quadratum	Quadratum sp. NJAUAcariEriYN304.4
18026424	18026424	PRJNA1047551_S_NODE_3735_length_243_cov_2.250000_g3608_i0	PRJNA1047551	3735	243	2.25	5.4675	Aphis gossypii	80765	Arthropoda	Arthropoda	366	6.89e-97	NTclustered	gi\|2288477194\|ref\|XM_027982796.2\|	80765	g3608	i0	93.827	26.6913580246914	243	15	100	0	1	243	1170	928	PREDICTED: Aphis gossypii 26S proteasome regulatory subunit 10B (LOC114120770), transcript variant X3, mRNA	blastn	6486	366	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Aphis	Aphis gossypii
18861425	18861425	PRJNA1047551_S_NODE_10615_length_164_cov_1.713178_g10488_i0	PRJNA1047551	10615	164	1.713178	2.80961192	Aphididae	27482	Arthropoda	Arthropoda	254	3.5e-63	NTclustered	gi\|2620630428\|ref\|XR_009661998.1\|	40932	g10488	i0	94.578	93.9268292682927	166	5	100	3	1	164	3272	3109	PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA	blastn	15404	254	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Rhopalosiphum	Rhopalosiphum padi
18861429	18861429	PRJNA1047551_S_NODE_11915_length_157_cov_3.319672_g11788_i0	PRJNA1047551	11915	157	3.319672	5.21188504	Aphididae	27482	Arthropoda	Arthropoda	291	2.52e-74	NTclustered	gi\|213948225\|ref\|NC_011594.1\|	7029	g11788	i0	100	101	157	0	100	0	1	157	13138	12982	Acyrthosiphon pisum mitochondrion, complete genome	blastn	15857	291	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
19300499	19300499	PRJNA1047551_S_NODE_8456_length_178_cov_2.804196_g8329_i0	PRJNA1047551	8456	178	2.804196	4.99146888	Aphis gossypii	80765	Arthropoda	Arthropoda	257	2.97e-64	NTclustered	gi\|2288480392\|ref\|XM_027995859.2\|	80765	g8329	i0	92.697	8.46629213483146	178	13	100	0	1	178	541	364	PREDICTED: Aphis gossypii troponin C, isoallergen Bla g 6.0301 (LOC114130797), mRNA	blastn	1507	257	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Aphis	Aphis gossypii
20136275	20136275	PRJNA1047551_S_NODE_9416_length_172_cov_0.978102_g9289_i0	PRJNA1047551	9416	172	0.978102	1.68233544	Psocodea	1930602	Arthropoda	Arthropoda	97.1	6.57e-16	NTclustered	gi\|12328587\|gb\|AF270939.1\|AF270939	145266	g9289	i0	81.25	38.4418604651163	128	17	72	5	1	124	11828	11952	Heterodoxus macropus mitochondrion, complete genome	blastn	6612	97.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Boopidae	Heterodoxus	Heterodoxus macropus
21411850	21411850	PRJNA1047551_S_NODE_12137_length_156_cov_2.355372_g12010_i0	PRJNA1047551	12137	156	2.355372	3.67438032	Aphididae	27482	Arthropoda	Arthropoda	183	4.369999999999999e-42	NTclustered	gi\|1685541550\|ref\|XM_008184106.3\|	7029	g12010	i0	88.312	10.9487179487179	154	17	99	1	3	156	2804	2956	PREDICTED: Acyrthosiphon pisum neuroplastin (LOC100159597), transcript variant X5, mRNA	blastn	1708	183	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
21411858	21411858	PRJNA1047551_S_NODE_1597_length_352_cov_7.261830_g1470_i0	PRJNA1047551	1597	352	7.26183	25.5616416	Drosophila	7215	Arthropoda	Arthropoda	60.2	1.99e-4	NTclustered	gi\|1847795380\|ref\|XM_034801055.1\|	7241	g1470	i0	100	8.5625	32	0	9	0	17	48	1103	1134	PREDICTED: Drosophila subobscura 60S acidic ribosomal protein P0 (LOC117894159), mRNA	blastn	3014	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila subobscura
21851360	21851360	PRJNA1047551_S_NODE_1158_length_415_cov_10.013158_g1031_i0	PRJNA1047551	1158	415	10.013158	41.5546057	Coccinella septempunctata	41139	Arthropoda	Arthropoda	69.4	3.96e-7	NTclustered	gi\|2125266636\|ref\|XR_006537940.1\|	41139	g1031	i0	85.938	0.925301204819277	64	9	15	0	49	112	140	203	PREDICTED: Coccinella septempunctata uncharacterized LOC123315318 (LOC123315318), ncRNA	blastn	384	69.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Coccinella	Coccinella septempunctata
21851468	21851468	PRJNA1047551_S_NODE_358_length_691_cov_13.751524_g258_i0	PRJNA1047551	358	691	13.751524	95.02303084	Demodex folliculorum	481310	Arthropoda	Arthropoda	896	0	NTclustered	gi\|360047365\|gb\|HQ728000.1\|	481310	g258	i0	90.173	88.8958031837916	692	62	100	5	1	691	3016	2330	Demodex folliculorum isolate Df3 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	61427	896	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex folliculorum
21851486	21851486	PRJNA1047551_S_NODE_4178_length_231_cov_12.658163_g4051_i0	PRJNA1047551	4178	231	12.658163	29.24035653	Timema poppense	170557	Arthropoda	Arthropoda	54.7	0.006	NTclustered	gi\|1946191770\|emb\|OD091161.1\|	170557	g4051	i0	100	0.125541125541126	29	0	13	0	16	44	538	566	1_Tps_b3v08	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema poppense
21851487	21851487	PRJNA1047551_S_NODE_418_length_641_cov_5.496700_g258_i3	PRJNA1047551	418	641	5.4967	35.233847	Demodex folliculorum	481310	Arthropoda	Arthropoda	795	0	NTclustered	gi\|360047365\|gb\|HQ728000.1\|	481310	g258	i3	89.06	85.1497659906396	649	59	100	10	1	641	3016	2372	Demodex folliculorum isolate Df3 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	54581	795	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex folliculorum
21851494	21851494	PRJNA1047551_S_NODE_4418_length_226_cov_2.083770_g4291_i0	PRJNA1047551	4418	226	2.08377	4.7093202	Aphidius gifuensis	684658	Arthropoda	Arthropoda	385	1.75e-102	NTclustered	gi\|2106753649\|ref\|XM_044159962.1\|	684658	g4291	i0	97.345	2.29203539823009	226	6	100	0	1	226	379	604	PREDICTED: Aphidius gifuensis protein lethal(2)essential for life-like (LOC122857677), mRNA	blastn	518	385	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Aphidius	Aphidius gifuensis
21851508	21851508	PRJNA1047551_S_NODE_4978_length_217_cov_1.747253_g4851_i0	PRJNA1047551	4978	217	1.747253	3.79153901	Parasteatoda tepidariorum	114398	Arthropoda	Arthropoda	163	8.49e-36	NTclustered	gi\|2899217526\|ref\|XM_043043455.2\|	114398	g4851	i0	83.152	0.847926267281106	184	26	83	5	1	181	2558	2377	PREDICTED: Parasteatoda tepidariorum protein disulfide-isomerase A5 (LOC107443556), mRNA	blastn	184	163	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Theridiidae	Parasteatoda	Parasteatoda tepidariorum
22686690	22686690	PRJNA1047551_S_NODE_3558_length_248_cov_1.882629_g3431_i0	PRJNA1047551	3558	248	1.882629	4.66891992	Xanthorhoe	190368	Arthropoda	Arthropoda	145	3.6e-30	NTclustered	gi\|2697882933\|gb\|PP440555.1\|	1241361	g3431	i0	84.564	7.72177419354839	149	19	59	4	1	147	649	503	Xanthorhoe annotinata voucher E. Ounap 1483 glyceraldehyde-3-phosphate dehydrogenase (GAPDH) gene, partial cds	blastn	1915	145	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Geometridae	Xanthorhoe	Xanthorhoe annotinata
23126782	23126782	PRJNA1047551_S_NODE_11799_length_158_cov_1.626016_g11672_i0	PRJNA1047551	11799	158	1.626016	2.56910528	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	292	7.07e-75	NTclustered	gi\|1962568947\|emb\|OC902800.1\|	1979941	g11672	i0	100	2.68354430379747	158	0	100	0	1	158	516	359	Medioppia subpectinata	blastn	424	292	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
23126942	23126942	PRJNA1047551_S_NODE_5559_length_208_cov_1.728324_g5432_i0	PRJNA1047551	5559	208	1.728324	3.59491392	Timema douglasi	61478	Arthropoda	Arthropoda	339	1.25e-88	NTclustered	gi\|1936766486\|emb\|OA594500.1\|	61478	g5432	i0	98.438	0.923076923076923	192	3	92	0	1	192	1729	1538	1_Tdi_b3v08	blastn	192	339	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema douglasi
23962300	23962300	PRJNA1047551_S_NODE_4139_length_233_cov_1.424242_g4012_i0	PRJNA1047551	4139	233	1.424242	3.31848386	Aphididae	27482	Arthropoda	Arthropoda	387	5.03e-103	NTclustered	gi\|239789248\|dbj\|AK340702.1\|	7029	g4012	i0	96.567	18.4635193133047	233	8	100	0	1	233	70	302	Acyrthosiphon pisum ACYPI000543 mRNA, clone: 651M3, complete cds, full-insert cDNA sequence based on the ESTs (5'-EST:FF319685, 3'-EST:FF320767)	blastn	4302	387	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
24400669	24400669	PRJNA1047551_S_NODE_4480_length_225_cov_1.684211_g4353_i0	PRJNA1047551	4480	225	1.684211	3.78947475	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	394	2.89e-105	NTclustered	gi\|2621241933\|ref\|XM_061013451.1\|	44670	g4353	i0	98.222	98.4977777777778	225	4	100	0	1	225	290	514	PREDICTED: Metopolophium dirhodum small ribosomal subunit protein uS12 (LOC132944217), mRNA	blastn	22162	394	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum
24400779	24400779	PRJNA1047551_S_NODE_8820_length_176_cov_1.028369_g8693_i0	PRJNA1047551	8820	176	1.028369	1.80992944	Macrosiphum rosae	44659	Arthropoda	Arthropoda	298	1.73e-76	NTclustered	gi\|2258690811\|ref\|NC_064372.1\|	44659	g8693	i0	100	90.4375	161	0	91	0	1	161	1046	886	Macrosiphum rosae mitochondrion, complete genome	blastn	15917	298	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Macrosiphum	Macrosiphum rosae
26710301	26710301	PRJNA1047551_S_NODE_7221_length_188_cov_3.588235_g7094_i0	PRJNA1047551	7221	188	3.588235	6.7458818	Opisthokonta	33154	Arthropoda	Arthropoda	48.1	1.73e-4	NR	KOX78024.1	166423	g7094	i0	80	0.781914893617021	25	5	39.9	0	186	112	187	211	KOX78024.1 Proliferating cell nuclear antigen [Melipona quadrifasciata]	diamond	147	48.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Melipona	Melipona quadrifasciata
26940202	26940202	PRJNA1047551_S_NODE_9102_length_174_cov_1.287770_g8975_i0	PRJNA1047551	9102	174	1.28777	2.2407198	Ornithodoros turicata	34597	Arthropoda	Arthropoda	42	0.0279	NR	XP_064486842.1	34597	g8975	i0	67.9	0.482758620689655	28	9	48.3	0	134	51	352	379	XP_064486842.1 mucin-2-like isoform X2 [Ornithodoros turicata]	diamond	84	42	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Argasidae	Ornithodoros	Ornithodoros turicata
27572371	27572371	PRJNA1047551_S_NODE_12084_length_157_cov_1.172131_g11957_i0	PRJNA1047551	12084	157	1.172131	1.84024567	Melanaphis sacchari	742174	Arthropoda	Arthropoda	83.6	3.54e-17	NR	XP_025206579.1	742174	g11957	i0	76.9	2.98089171974522	52	12	99.4	0	1	156	295	346	XP_025206579.1 NSFL1 cofactor p47 [Melanaphis sacchari]	diamond	468	83.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Melanaphis	Melanaphis sacchari
27856505	27856505	PRJNA1047551_S_NODE_9545_length_171_cov_1.308824_g9418_i0	PRJNA1047551	9545	171	1.308824	2.23808904	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	105	6.54e-25	NR	NP_001192074.1	7029	g9418	i0	89.3	0.982456140350877	56	6	98.2	0	2	169	34	89	NP_001192074.1 sorting nexin-30-like [Acyrthosiphon pisum]	diamond	168	105	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
29119759	29119759	PRJNA1047551_S_NODE_4649_length_222_cov_1.363636_g4522_i0	PRJNA1047551	4649	222	1.363636	3.02727192	Halotydeus destructor	2874060	Arthropoda	Arthropoda	112	1.61e-30	NR	KAI1277996.1	2874060	g4522	i0	75.3	0.986486486486487	73	18	98.6	0	221	3	7	79	KAI1277996.1 hypothetical protein HDE_14508 [Halotydeus destructor]	diamond	219	112	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Penthaleidae	Halotydeus	Halotydeus destructor
29466481	29466481	PRJNA1047551_S_NODE_7750_length_184_cov_1.442953_g7623_i0	PRJNA1047551	7750	184	1.442953	2.65503352	Cinara cedri	506608	Arthropoda	Arthropoda	89	7.38e-19	NR	VVC44866.1	506608	g7623	i0	68.9	1.98913043478261	61	19	99.5	0	1	183	26	86	VVC44866.1 Sugar transporter, conserved site,Major facilitator superfamily domain,Major facilitator, sugar [Cinara cedri]	diamond	366	89	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Cinara	Cinara cedri
30003797	30003797	PRJNA1047551_S_NODE_4431_length_226_cov_1.528796_g4304_i0	PRJNA1047551	4431	226	1.528796	3.45507896	Halotydeus destructor	2874060	Arthropoda	Arthropoda	96.3	4.969999999999999e-23	NR	KAI1291096.1	2874060	g4304	i0	57.5	0.969026548672566	73	30	95.6	1	218	3	69	141	KAI1291096.1 NADH dehydrogenase [ubiquinone] 1 beta subcomplex subunit 2, mitochondrial [Halotydeus destructor]	diamond	219	96.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Penthaleidae	Halotydeus	Halotydeus destructor
30375203	30375203	PRJNA1047551_S_NODE_6992_length_191_cov_1.371795_g6865_i0	PRJNA1047551	6992	191	1.371795	2.62012845	Diptera	7147	Arthropoda	Arthropoda	104	3.54e-25	NR	KFB37578.1	74873	g6865	i0	72.1	4.82198952879581	61	17	95.8	0	2	184	17	77	KFB37578.1 AGAP011350-PA-like protein [Anopheles sinensis]	diamond	921	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Anopheles	Anopheles sinensis
30532697	30532697	PRJNA1047551_S_NODE_10673_length_164_cov_1.387597_g10546_i0	PRJNA1047551	10673	164	1.387597	2.27565908	Arthropoda	6656	Arthropoda	Arthropoda	95.1	4.350000000000001e-21	NR	KAL1436099.1	34631	g10546	i0	83	10.6646341463415	53	9	97	0	160	2	425	477	KAL1436099.1 hypothetical protein MTO96_010847 [Rhipicephalus appendiculatus]	diamond	1749	95.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus appendiculatus
31354445	31354445	PRJNA1047551_S_NODE_10536_length_165_cov_1.092308_g10409_i0	PRJNA1047551	10536	165	1.092308	1.8023082	Cecidomyiidae	33406	Arthropoda	Arthropoda	84	3.79e-17	NR	XP_055308422.1	263140	g10409	i0	70.4	3.92727272727273	54	16	98.2	0	2	163	99	152	XP_055308422.1 uncharacterized protein LOC129572485 [Sitodiplosis mosellana]	diamond	648	84	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Cecidomyiidae	Sitodiplosis	Sitodiplosis mosellana
31741878	31741878	PRJNA1047551_S_NODE_12277_length_156_cov_1.214876_g12150_i0	PRJNA1047551	12277	156	1.214876	1.89520656	Stegodyphus mimosarum	407821	Arthropoda	Arthropoda	80.5	3.4e-17	NR	KFM61320.1	407821	g12150	i0	89.1	0.884615384615385	46	4	86.5	1	21	155	52	97	KFM61320.1 Protein lethal(2)essential for life, partial [Stegodyphus mimosarum]	diamond	138	80.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Eresidae	Stegodyphus	Stegodyphus mimosarum
32343407	32343407	PRJNA1047551_S_NODE_4419_length_226_cov_2.010471_g4292_i0	PRJNA1047551	4419	226	2.010471	4.54366446	Schistocerca gregaria	7010	Arthropoda	Arthropoda	66.2	1.57e-11	NR	XP_049851313.1	7010	g4292	i0	60	0.663716814159292	50	20	66.4	0	212	63	96	145	XP_049851313.1 myosin regulatory light chain-like [Schistocerca gregaria]	diamond	150	66.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;