metadata: contig_metadata: 60 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax

60 rows where analysis = "blastn", bioproject = "PRJNA694770" 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
673733	673733	PRJNA694770_P_NODE_15241_length_480_cov_1.292383_g14947_i0	PRJNA694770	15241	480	1.292383	6.2034384	Ostrinia furnacalis	93504	Arthropoda	Arthropoda	854	0	NTclustered	gi\|1590285363\|ref\|XM_028310768.1\|	93504	g14947	i0	98.75	1	480	6	100	0	1	480	1604	1125	PREDICTED: Ostrinia furnacalis extracellular serine protease-like (LOC114357247), mRNA	blastn	480	854	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Crambidae	Ostrinia	Ostrinia furnacalis
674220	674220	PRJNA694770_P_NODE_34021_length_347_cov_1.525547_g33727_i0	PRJNA694770	34021	347	1.525547	5.29364809	Chironomus dorsalis Auct. not Meigen, 1818	38283	Arthropoda	Arthropoda	340	6.259999999999999e-89	NTclustered	gi\|12195111\|emb\|AJ279512.1\|	38283	g33727	i0	84.571	90.0720461095101	350	46	100	7	1	347	263	607	Chironomus dorsalis Auct. not Meigen, 1818 28S rRNA gene (partial), IGS and 18S rRNA gene (partial), clone Lambda-dorR1	blastn	31255	340	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus dorsalis Auct. not Meigen, 1818
676054	676054	PRJNA694770_P_NODE_99941_length_241_cov_0.916667_g99647_i0	PRJNA694770	99941	241	0.916667	2.20916747	Culex pipiens	7175	Arthropoda	Arthropoda	191	4.41e-44	NTclustered	gi\|2415559672\|ref\|XM_039596272.2\|	42434	g99647	i0	96.552	5.25311203319502	116	3	48	1	127	241	5665	5550	PREDICTED: Culex pipiens pallens uncharacterized LOC120431117 (LOC120431117), mRNA	blastn	1266	191	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
1181469	1181469	PRJNA694770_P_NODE_95261_length_243_cov_0.905882_g94967_i0	PRJNA694770	95261	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	91.6	4.64e-14	NTclustered	gi\|76443734\|gb\|AC164954.3\|	7176	g94967	i0	94.828	2.13168724279835	58	3	24	0	1	58	82292	82349	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence	blastn	518	91.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
1951020	1951020	PRJNA694770_P_NODE_63802_length_274_cov_1.149254_g63508_i0	PRJNA694770	63802	274	1.149254	3.14895596	Amphibalanus amphitrite	1232801	Arthropoda	Arthropoda	52.8	0.025	NTclustered	gi\|2087277722\|ref\|XM_043345092.1\|	1232801	g63508	i0	100	0.102189781021898	28	0	10	0	12	39	829	802	PREDICTED: Amphibalanus amphitrite carcinoembryonic antigen-related cell adhesion molecule 1-like (LOC122369925), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Thecostraca	Balanomorpha	Balanidae	Amphibalanus	Amphibalanus amphitrite
3225607	3225607	PRJNA694770_P_NODE_4783_length_901_cov_1.929952_g4527_i0	PRJNA694770	4783	901	1.929952	17.38886752	Ostrinia furnacalis	93504	Arthropoda	Arthropoda	1365	0	NTclustered	gi\|1590285363\|ref\|XM_028310768.1\|	93504	g4527	i0	95.46	0.95338512763596	859	33	95	6	1	856	913	58	PREDICTED: Ostrinia furnacalis extracellular serine protease-like (LOC114357247), mRNA	blastn	859	1365	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Crambidae	Ostrinia	Ostrinia furnacalis
3226184	3226184	PRJNA694770_P_NODE_68743_length_266_cov_1.440415_g68449_i0	PRJNA694770	68743	266	1.440415	3.8315039	Culex pipiens	7175	Arthropoda	Arthropoda	350	7.700000000000001e-92	NTclustered	gi\|2415563374\|ref\|XM_039593377.2\|	42434	g68449	i0	90.071	89.0187969924812	282	11	100	7	1	266	2318	2038	PREDICTED: Culex pipiens pallens uncharacterized LOC120428378 (LOC120428378), mRNA	blastn	23679	350	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
3732710	3732710	PRJNA694770_P_NODE_61383_length_277_cov_2.901961_g61089_i0	PRJNA694770	61383	277	2.901961	8.03843197	Polypedilum	54968	Arthropoda	Arthropoda	459	1.29e-124	NTclustered	gi\|1061796046\|dbj\|LC164797.1\|	54969	g61089	i0	100	90.8519855595668	248	0	90	0	1	248	769	1016	Polypedilum nubifer gene for 28S ribosomal RNA, partial sequence, specimen_voucher: NIAS:Pn 2013	blastn	25166	459	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Polypedilum	Polypedilum nubifer
4502811	4502811	PRJNA694770_P_NODE_53044_length_290_cov_1.041475_g52750_i0	PRJNA694770	53044	290	1.041475	3.0202775	Darwinula stevensoni	69355	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|1937025057\|emb\|LR931445.1\|	69355	g52750	i0	96.97	0.113793103448276	33	1	11	0	133	165	330	362	Darwinula stevensoni	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
4502842	4502842	PRJNA694770_P_NODE_54164_length_288_cov_1.358140_g53870_i0	PRJNA694770	54164	288	1.35814	3.9114432	Culex pipiens	7175	Arthropoda	Arthropoda	58.4	5.73e-4	NTclustered	gi\|2415580889\|ref\|XM_039577156.2\|	42434	g53870	i0	97.059	0.354166666666667	34	1	12	0	44	77	7979	7946	PREDICTED: Culex pipiens pallens protein quiver (LOC120415576), transcript variant X1, mRNA	blastn	102	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
4503100	4503100	PRJNA694770_P_NODE_63884_length_274_cov_1.124378_g63590_i0	PRJNA694770	63884	274	1.124378	3.08079572	Culex pipiens	7175	Arthropoda	Arthropoda	320	6.25e-83	NTclustered	gi\|2415565938\|ref\|XM_039592627.2\|	42434	g63590	i0	95.098	38.7956204379562	204	8	74	2	3	206	3030	2829	PREDICTED: Culex pipiens pallens homeotic protein proboscipedia (LOC120427724), mRNA	blastn	10630	320	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
4503180	4503180	PRJNA694770_P_NODE_66844_length_269_cov_1.352041_g66550_i0	PRJNA694770	66844	269	1.352041	3.63699029	Harmonia axyridis	115357	Arthropoda	Arthropoda	63.9	1.14e-5	NTclustered	gi\|2170020163\|ref\|XM_045608544.1\|	115357	g66550	i0	91.304	0.513011152416357	46	4	17	0	185	230	1291	1246	PREDICTED: Harmonia axyridis RNA-binding protein 25 (LOC123673838), transcript variant X2, mRNA	blastn	138	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Harmonia	Harmonia axyridis
4503214	4503214	PRJNA694770_P_NODE_67944_length_267_cov_1.587629_g67650_i0	PRJNA694770	67944	267	1.587629	4.23896943	Culex pipiens	7175	Arthropoda	Arthropoda	124	5.099999999999999e-24	NTclustered	gi\|2415587309\|ref\|XM_052710243.1\|	42434	g67650	i0	100	18.4644194756554	67	0	25	0	201	267	446	380	PREDICTED: Culex pipiens pallens protein artichoke-like (LOC120427133), transcript variant X2, mRNA	blastn	4930	124	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
4503746	4503746	PRJNA694770_P_NODE_86764_length_247_cov_0.885057_g86470_i0	PRJNA694770	86764	247	0.885057	2.18609079	Culex pipiens	7175	Arthropoda	Arthropoda	86.1	2.2e-12	NTclustered	gi\|2415580551\|ref\|XM_039586546.2\|	42434	g86470	i0	83.696	0.37246963562753	92	13	36	2	114	203	7823	7732	PREDICTED: Culex pipiens pallens ceramide phosphoethanolamine synthase (LOC120422957), mRNA	blastn	92	86.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
4503853	4503853	PRJNA694770_P_NODE_91044_length_245_cov_0.895349_g90750_i0	PRJNA694770	91044	245	0.895349	2.19360505	Culex pipiens	7175	Arthropoda	Arthropoda	302	1.99e-77	NTclustered	gi\|2415571902\|ref\|XM_039580875.2\|	42434	g90750	i0	93.204	5.5265306122449	206	13	84	1	4	208	3304	3099	PREDICTED: Culex pipiens pallens SHC-transforming protein 1 (LOC120418452), mRNA	blastn	1354	302	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
4504078	4504078	PRJNA694770_P_NODE_99724_length_241_cov_0.916667_g99430_i0	PRJNA694770	99724	241	0.916667	2.20916747	Anarta stigmosa	1869462	Arthropoda	Arthropoda	58.4	4.66e-4	NTclustered	gi\|2918376400\|emb\|OZ237981.1\|	1869462	g99430	i0	100	0.883817427385892	31	0	13	0	44	74	10278174	10278204	Anarta stigmosa genome assembly, chromosome: 5	blastn	213	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Anarta	Anarta stigmosa
5777510	5777510	PRJNA694770_P_NODE_25025_length_388_cov_1.704762_g24731_i0	PRJNA694770	25025	388	1.7047620000000001	6.61447656	Notodromas monacha	399045	Arthropoda	Arthropoda	701	0	NTclustered	gi\|1938054981\|emb\|OA888662.1\|	399045	g24731	i0	99.227	44.0541237113402	388	3	100	0	1	388	9567	9954	Notodromas monacha	blastn	17093	701	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cyprididae	Notodromas	Notodromas monacha
5778472	5778472	PRJNA694770_P_NODE_60965_length_278_cov_1.502439_g60671_i0	PRJNA694770	60965	278	1.502439	4.17678042	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	497	2.73e-136	NTclustered	gi\|78097483\|gb\|AC167561.3\|	7176	g60671	i0	98.921	40.0431654676259	278	3	100	0	1	278	30781	30504	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940117D9, complete sequence	blastn	11132	497	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
7053857	7053857	PRJNA694770_P_NODE_70106_length_264_cov_1.209424_g69812_i0	PRJNA694770	70106	264	1.209424	3.19287936	Nilaparvata lugens	108931	Arthropoda	Arthropoda	477	3.359999999999999e-130	NTclustered	gi\|1096257535\|gb\|KU932381.1\|	108931	g69812	i0	99.242	3.99621212121212	264	2	100	0	1	264	62	325	Nilaparvata lugens isolate NlSFP_unconfirmed_comp26910 seminal fluid protein mRNA, complete cds	blastn	1055	477	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Delphacidae	Nilaparvata	Nilaparvata lugens
7054047	7054047	PRJNA694770_P_NODE_76506_length_253_cov_1.388889_g76212_i0	PRJNA694770	76506	253	1.388889	3.51388917	Culex pipiens	7175	Arthropoda	Arthropoda	418	1.9599999999999994e-112	NTclustered	gi\|2415562464\|ref\|XM_039594795.2\|	42434	g76212	i0	96.443	4	253	9	100	0	1	253	9370	9622	PREDICTED: Culex pipiens pallens JNK-interacting protein 3 (LOC120429738), transcript variant X3, mRNA	blastn	1012	418	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
7054575	7054575	PRJNA694770_P_NODE_96746_length_242_cov_1.721893_g96452_i0	PRJNA694770	96746	242	1.721893	4.16698106	Culex pipiens	7175	Arthropoda	Arthropoda	239	1.56e-58	NTclustered	gi\|2415558179\|ref\|XR_008212694.1\|	42434	g96452	i0	86.066	2.46694214876033	244	8	98	7	5	242	1102	879	PREDICTED: Culex pipiens pallens uncharacterized LOC120430053 (LOC120430053), ncRNA	blastn	597	239	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
7559039	7559039	PRJNA694770_P_NODE_78146_length_251_cov_0.865169_g77852_i0	PRJNA694770	78146	251	0.865169	2.17157419	Culex	7174	Arthropoda	Arthropoda	78.7	3.75e-10	NTclustered	gi\|1949574686\|ref\|XM_038256730.1\|	7176	g77852	i0	97.778	0.358565737051793	45	1	18	0	1	45	4808	4852	Culex quinquefasciatus synaptotagmin-14 (LOC6046427), mRNA	blastn	90	78.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
8327149	8327149	PRJNA694770_P_NODE_25807_length_384_cov_0.990354_g25513_i0	PRJNA694770	25807	384	0.990354	3.80295936	Notodromas monacha	399045	Arthropoda	Arthropoda	704	0	NTclustered	gi\|1938020297\|emb\|OA886007.1\|	399045	g25513	i0	99.74	23.9479166666667	384	1	100	0	1	384	24301	24684	Notodromas monacha	blastn	9196	704	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cyprididae	Notodromas	Notodromas monacha
8328266	8328266	PRJNA694770_P_NODE_66347_length_270_cov_1.172589_g66053_i0	PRJNA694770	66347	270	1.172589	3.1659903	Ostrinia furnacalis	93504	Arthropoda	Arthropoda	472	1.6e-128	NTclustered	gi\|1590285363\|ref\|XM_028310768.1\|	93504	g66053	i0	98.148	1	270	5	100	0	1	270	2473	2742	PREDICTED: Ostrinia furnacalis extracellular serine protease-like (LOC114357247), mRNA	blastn	270	472	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Crambidae	Ostrinia	Ostrinia furnacalis
8833991	8833991	PRJNA694770_P_NODE_71067_length_262_cov_1.629630_g70773_i0	PRJNA694770	71067	262	1.62963	4.2696306	Aphididae	27482	Arthropoda	Arthropoda	473	4.31e-129	NTclustered	gi\|1685532496\|ref\|XR_003840248.1\|	7029	g70773	i0	99.614	96.0496183206107	259	1	99	0	4	262	1151	893	PREDICTED: Acyrthosiphon pisum uncharacterized LOC107885124 (LOC107885124), ncRNA	blastn	25165	473	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
9603431	9603431	PRJNA694770_P_NODE_60928_length_278_cov_1.502439_g60634_i0	PRJNA694770	60928	278	1.502439	4.17678042	Pyrops clavatus	2873973	Arthropoda	Arthropoda	52.8	0.026	NTclustered	gi\|2095500870\|gb\|MW662665.1\|	2873973	g60634	i0	100	0.201438848920863	28	0	10	0	78	105	6359	6386	Pyrops clavatus mitochondrion	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Fulgoridae	Pyrops	Pyrops clavatus
9603600	9603600	PRJNA694770_P_NODE_66788_length_269_cov_1.489796_g66494_i0	PRJNA694770	66788	269	1.489796	4.00755124	Macrobrachium rosenbergii	79674	Arthropoda	Arthropoda	52.8	0.025	NTclustered	gi\|2782865114\|ref\|XM_067127101.1\|	79674	g66494	i0	100	0.312267657992565	28	0	10	0	111	138	10410	10437	PREDICTED: Macrobrachium rosenbergii uncharacterized protein (LOC136852462), transcript variant X3, mRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Macrobrachium	Macrobrachium rosenbergii
9603685	9603685	PRJNA694770_P_NODE_69928_length_264_cov_1.591623_g69634_i0	PRJNA694770	69928	264	1.591623	4.20188472	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	377	3.4999999999999996e-100	NTclustered	gi\|91176468\|gb\|AC167662.6\|	7176	g69634	i0	92.453	3.90151515151515	265	18	100	2	1	264	7726	7463	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940141D9, complete sequence	blastn	1030	377	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
9603727	9603727	PRJNA694770_P_NODE_71768_length_261_cov_1.388298_g71474_i0	PRJNA694770	71768	261	1.388298	3.62345778	Notodromas monacha	399045	Arthropoda	Arthropoda	460	3.3399999999999995e-125	NTclustered	gi\|1938102604\|emb\|OA893771.1\|	399045	g71474	i0	98.467	37.6666666666667	261	4	100	0	1	261	857	597	Notodromas monacha	blastn	9831	460	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cyprididae	Notodromas	Notodromas monacha
9603796	9603796	PRJNA694770_P_NODE_73848_length_257_cov_2.211957_g73554_i0	PRJNA694770	73848	257	2.211957	5.68472949	Polypedilum nubiferum	391807	Arthropoda	Arthropoda	470	5.45e-128	NTclustered	gi\|346681941\|gb\|HQ440655.1\|	391807	g73554	i0	99.611	100.416342412451	257	1	100	0	1	257	644	388	Polypedilum nubiferum voucher PONU 18S ribosomal RNA gene, partial sequence	blastn	25807	470	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Polypedilum	Polypedilum nubiferum
9604320	9604320	PRJNA694770_P_NODE_92608_length_244_cov_1.730994_g92314_i0	PRJNA694770	92608	244	1.730994	4.22362536	Platynothrus peltifer	128015	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|2579718317\|gb\|CP133306.1\|	128015	g92314	i0	100	0.114754098360656	28	0	11	0	58	85	13215643	13215670	Platynothrus peltifer isolate 155_3 chromosome 1	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Camisiidae	Platynothrus	Platynothrus peltifer
10877606	10877606	PRJNA694770_P_NODE_100529_length_241_cov_0.880952_g100235_i0	PRJNA694770	100529	241	0.880952	2.12309432	Culex pipiens	7175	Arthropoda	Arthropoda	333	6.919999999999998e-87	NTclustered	gi\|2415567354\|ref\|XM_052706704.1\|	42434	g100235	i0	94.444	11.3236514522822	216	12	90	0	26	241	9131	8916	PREDICTED: Culex pipiens pallens uncharacterized LOC120431010 (LOC120431010), transcript variant X2, mRNA	blastn	2729	333	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
10877697	10877697	PRJNA694770_P_NODE_12549_length_527_cov_1.515419_g12257_i0	PRJNA694770	12549	527	1.515419	7.98625813	Ostrinia furnacalis	93504	Arthropoda	Arthropoda	924	0	NTclustered	gi\|1590285363\|ref\|XM_028310768.1\|	93504	g12257	i0	98.292	1	527	9	100	0	1	527	2136	1610	PREDICTED: Ostrinia furnacalis extracellular serine protease-like (LOC114357247), mRNA	blastn	527	924	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Crambidae	Ostrinia	Ostrinia furnacalis
10878200	10878200	PRJNA694770_P_NODE_31589_length_356_cov_4.498233_g31295_i0	PRJNA694770	31589	356	4.498233	16.01370948	Chironomus tepperi	113505	Arthropoda	Arthropoda	551	2.729999999999999e-152	NTclustered	gi\|2874226696\|ref\|XR_011544950.1\|	113505	g31295	i0	94.663	93.2612359550562	356	17	99	2	2	356	16	370	PREDICTED: Chironomus tepperi large subunit ribosomal RNA (LOC139096256), rRNA	blastn	33201	551	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
10878456	10878456	PRJNA694770_P_NODE_40909_length_324_cov_0.920319_g40615_i0	PRJNA694770	40909	324	0.920319	2.98183356	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	416	9.37e-112	NTclustered	gi\|83415359\|gb\|AC167562.5\|	7176	g40615	i0	90.062	85.4907407407407	322	30	99	2	2	322	30586	30906	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940122D9, complete sequence	blastn	27699	416	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
10879576	10879576	PRJNA694770_P_NODE_82609_length_249_cov_0.875000_g82315_i0	PRJNA694770	82609	249	0.875	2.17875	Timema douglasi	61478	Arthropoda	Arthropoda	52.8	0.023	NTclustered	gi\|1936895738\|emb\|OA565395.1\|	61478	g82315	i0	100	0.112449799196787	28	0	11	0	18	45	133744	133717	1_Tdi_b3v08	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema douglasi
12153274	12153274	PRJNA694770_P_NODE_28850_length_369_cov_0.956081_g28556_i0	PRJNA694770	28850	369	0.956081	3.52793889	Culex pipiens	7175	Arthropoda	Arthropoda	433	1.0699999999999999e-116	NTclustered	gi\|2415558106\|ref\|XR_005607732.2\|	42434	g28556	i0	94.624	1.41463414634146	279	15	76	0	91	369	6500	6778	PREDICTED: Culex pipiens pallens uncharacterized LOC120430798 (LOC120430798), ncRNA	blastn	522	433	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
12153608	12153608	PRJNA694770_P_NODE_42390_length_319_cov_1.252033_g42096_i0	PRJNA694770	42390	319	1.252033	3.99398527	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	54.7	0.008	NTclustered	gi\|1963617327\|emb\|OC873114.1\|	1979941	g42096	i0	100	0.0909090909090909	29	0	9	0	155	183	1610	1638	Medioppia subpectinata	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
12154825	12154825	PRJNA694770_P_NODE_85790_length_248_cov_0.880000_g85496_i0	PRJNA694770	85790	248	0.88	2.1824	Culex pipiens	7175	Arthropoda	Arthropoda	257	4.43e-64	NTclustered	gi\|2415563907\|ref\|XR_005606935.2\|	42434	g85496	i0	96.753	10.5161290322581	154	5	62	0	5	158	197	350	PREDICTED: Culex pipiens pallens uncharacterized LOC120427649 (LOC120427649), ncRNA	blastn	2608	257	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
13428512	13428512	PRJNA694770_P_NODE_53151_length_289_cov_2.125000_g52857_i0	PRJNA694770	53151	289	2.125	6.14125	Episema korsakovi	1870626	Arthropoda	Arthropoda	52.8	0.027	NTclustered	gi\|2920003684\|emb\|OZ238898.1\|	1870626	g52857	i0	100	0.0968858131487889	28	0	10	0	8	35	9729874	9729901	Episema korsakovi genome assembly, chromosome: 22	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Episema	Episema korsakovi
13428592	13428592	PRJNA694770_P_NODE_55911_length_285_cov_2.514151_g55617_i0	PRJNA694770	55911	285	2.514151	7.16533035	Daphnia pulex	6669	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2192734159\|ref\|XM_046600325.1\|	6669	g55617	i0	94.595	0.519298245614035	37	0	12	2	179	213	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
13429025	13429025	PRJNA694770_P_NODE_71531_length_261_cov_1.638298_g71237_i0	PRJNA694770	71531	261	1.638298	4.27595778	Chironomus sp.	7152	Arthropoda	Arthropoda	396	9.539999999999997e-106	NTclustered	gi\|2485418712\|gb\|OQ813480.1\|	7152	g71237	i0	94.297	96.2681992337165	263	8	100	6	1	261	35	292	Chironomus sp. isolate OVO4158 small subunit ribosomal RNA gene, partial sequence	blastn	25126	396	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus sp.
13935379	13935379	PRJNA694770_P_NODE_93871_length_244_cov_0.900585_g93577_i0	PRJNA694770	93871	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	448	2.4e-121	NTclustered	gi\|91176468\|gb\|AC167662.6\|	7176	g93577	i0	100	9.91803278688525	242	0	99	0	3	244	33814	34055	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940141D9, complete sequence	blastn	2420	448	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
14704027	14704027	PRJNA694770_P_NODE_63832_length_274_cov_1.149254_g63538_i0	PRJNA694770	63832	274	1.149254	3.14895596	Ceriodaphnia reticulata	302197	Arthropoda	Arthropoda	296	1.05e-75	NTclustered	gi\|2488162746\|emb\|OC980216.1\|	302197	g63538	i0	86.347	1.35401459854015	271	37	99	0	1	271	3115	2845	Ceriodaphnia reticulata EOG090X03DA gene for EOG090X03DA	blastn	371	296	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Ceriodaphnia	Ceriodaphnia reticulata
14704556	14704556	PRJNA694770_P_NODE_82552_length_249_cov_0.875000_g82258_i0	PRJNA694770	82552	249	0.875	2.17875	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	187	5.919999999999998e-43	NTclustered	gi\|1949578866\|ref\|XM_001847269.2\|	7176	g82258	i0	93.6	0.502008032128514	125	8	50	0	1	125	125	1	Culex quinquefasciatus solute carrier family 52, riboflavin transporter, member 3-A (LOC6037404), mRNA	blastn	125	187	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
15977697	15977697	PRJNA694770_P_NODE_60353_length_279_cov_1.456311_g60059_i0	PRJNA694770	60353	279	1.456311	4.06310769	Timema genevievae	629358	Arthropoda	Arthropoda	52.8	0.026	NTclustered	gi\|1964503389\|emb\|OE840646.1\|	629358	g60059	i0	100	0.100358422939068	28	0	10	0	72	99	115171	115144	5_Tge_b3v08	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema genevievae
15978284	15978284	PRJNA694770_P_NODE_82053_length_249_cov_1.352273_g81759_i0	PRJNA694770	82053	249	1.352273	3.36715977	Culex pipiens	7175	Arthropoda	Arthropoda	254	5.76e-63	NTclustered	gi\|2415558943\|ref\|XM_039580203.2\|	42434	g81759	i0	95.597	1.93172690763052	159	6	64	1	1	159	1531	1374	PREDICTED: Culex pipiens pallens uncharacterized LOC120417967 (LOC120417967), mRNA	blastn	481	254	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
17252806	17252806	PRJNA694770_P_NODE_59734_length_280_cov_1.318841_g59440_i0	PRJNA694770	59734	280	1.318841	3.6927548	Macrobrachium nipponense	159736	Arthropoda	Arthropoda	58.4	5.55e-4	NTclustered	gi\|2708605526\|ref\|XM_064241695.1\|	159736	g59440	i0	97.059	0.121428571428571	34	1	12	0	114	147	202	235	PREDICTED: Macrobrachium nipponense large ribosomal subunit protein uL30-like (LOC135209095), mRNA	blastn	34	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Macrobrachium	Macrobrachium nipponense
17253847	17253847	PRJNA694770_P_NODE_98854_length_241_cov_1.511905_g98560_i0	PRJNA694770	98854	241	1.511905	3.64369105	Culex pipiens	7175	Arthropoda	Arthropoda	257	4.28e-64	NTclustered	gi\|2415575446\|ref\|XM_039585961.2\|	42434	g98560	i0	86.166	1.04979253112033	253	17	100	8	1	241	2764	2518	PREDICTED: Culex pipiens pallens uncharacterized LOC120422506 (LOC120422506), mRNA	blastn	253	257	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
18526723	18526723	PRJNA694770_P_NODE_53635_length_289_cov_1.092593_g53341_i0	PRJNA694770	53635	289	1.092593	3.15759377	Drosophila guanche	7266	Arthropoda	Arthropoda	52.8	0.027	NTclustered	gi\|1839740184\|ref\|XM_034283058.1\|	7266	g53341	i0	100	0.0968858131487889	28	0	10	0	157	184	591	618	PREDICTED: Drosophila guanche luc7-like protein 3 (LOC117590438), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila guanche
18527614	18527614	PRJNA694770_P_NODE_86995_length_247_cov_0.885057_g86701_i0	PRJNA694770	86995	247	0.885057	2.18609079	Phymastichus coffea	108790	Arthropoda	Arthropoda	54.7	0.006	NTclustered	gi\|2563724715\|ref\|XM_058949085.1\|	108790	g86701	i0	84.906	0.214574898785425	53	8	21	0	4	56	1409	1357	PREDICTED: Phymastichus coffea innexin inx1 (LOC131672111), mRNA	blastn	53	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Eulophidae	Phymastichus	Phymastichus coffea
19800941	19800941	PRJNA694770_P_NODE_26756_length_379_cov_0.895425_g26462_i0	PRJNA694770	26756	379	0.895425	3.39366075	Culex pipiens	7175	Arthropoda	Arthropoda	619	7.889999999999999e-173	NTclustered	gi\|2415562189\|ref\|XM_039594570.2\|	42434	g26462	i0	98.575	30.9498680738786	351	3	92	2	21	370	9519	9170	PREDICTED: Culex pipiens pallens serine-rich adhesin for platelets (LOC120429498), transcript variant X2, mRNA	blastn	11730	619	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
21078225	21078225	PRJNA694770_P_NODE_91037_length_245_cov_0.895349_g90743_i0	PRJNA694770	91037	245	0.895349	2.19360505	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	431	2.4299999999999996e-116	NTclustered	gi\|1949585672\|ref\|XM_038250981.1\|	7176	g90743	i0	98.367	2	245	4	100	0	1	245	341	97	Culex quinquefasciatus uncharacterized protein LOC119766433 (LOC119766433), mRNA	blastn	490	431	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
22353315	22353315	PRJNA694770_P_NODE_98498_length_242_cov_0.869822_g98204_i0	PRJNA694770	98498	242	0.869822	2.10496924	Culex pipiens	7175	Arthropoda	Arthropoda	346	8.930000000000001e-91	NTclustered	gi\|2415584843\|ref\|XR_005606577.2\|	42434	g98204	i0	92.975	6.82231404958678	242	9	100	3	1	242	932	699	PREDICTED: Culex pipiens pallens uncharacterized LOC120425709 (LOC120425709), ncRNA	blastn	1651	346	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
22858791	22858791	PRJNA694770_P_NODE_92018_length_245_cov_0.895349_g91724_i0	PRJNA694770	92018	245	0.895349	2.19360505	Culex	7174	Arthropoda	Arthropoda	363	8.989999999999999e-96	NTclustered	gi\|1949608631\|ref\|XM_038260510.1\|	7176	g91724	i0	99.497	8.12244897959184	199	1	81	0	47	245	1339	1141	Culex quinquefasciatus motile sperm domain-containing protein 2 (LOC6040993), mRNA	blastn	1990	363	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
23627189	23627189	PRJNA694770_P_NODE_42079_length_320_cov_1.174089_g41785_i0	PRJNA694770	42079	320	1.174089	3.7570848	Chironomidae sp. Cy2020 sp1	2766959	Arthropoda	Arthropoda	239	2.15e-58	NTclustered	gi\|1896444337\|gb\|MT921238.1\|	2766959	g41785	i0	97.163	45.384375	141	4	44	0	180	320	3041	3181	Chironomidae sp. Cy2020 sp1 voucher Chironomidae_Cy2020_sp1 large subunit ribosomal RNA gene, partial sequence	blastn	14523	239	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae		Chironomidae sp. Cy2020 sp1
23628175	23628175	PRJNA694770_P_NODE_78639_length_251_cov_0.865169_g78345_i0	PRJNA694770	78639	251	0.865169	2.17157419	Culex pipiens	7175	Arthropoda	Arthropoda	172	1.67e-38	NTclustered	gi\|2415591853\|ref\|XM_052711048.1\|	42434	g78345	i0	93.162	13.2749003984064	117	8	47	0	133	249	1791	1675	PREDICTED: Culex pipiens pallens allatostatin-A receptor-like (LOC128093603), mRNA	blastn	3332	172	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
23628250	23628250	PRJNA694770_P_NODE_81279_length_250_cov_0.870056_g80985_i0	PRJNA694770	81279	250	0.870056	2.17514	Culex pipiens	7175	Arthropoda	Arthropoda	237	5.82e-58	NTclustered	gi\|2415566956\|ref\|XR_008211875.1\|	42434	g80985	i0	91.111	24.18	180	9	72	5	71	250	5695	5867	PREDICTED: Culex pipiens pallens uncharacterized LOC128092562 (LOC128092562), ncRNA	blastn	6045	237	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
24900651	24900651	PRJNA694770_P_NODE_37480_length_335_cov_0.881679_g37186_i0	PRJNA694770	37480	335	0.881679	2.95362465	Polyergus mexicanus	615972	Arthropoda	Arthropoda	52.8	0.032	NTclustered	gi\|2868491166\|ref\|XM_070304589.1\|	615972	g37186	i0	100	0.0835820895522388	28	0	8	0	242	269	13001	13028	PREDICTED: Polyergus mexicanus chromodomain helicase DNA binding protein kismet (Kis), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Polyergus	Polyergus mexicanus
24901588	24901588	PRJNA694770_P_NODE_72140_length_260_cov_1.647059_g71846_i0	PRJNA694770	72140	260	1.647059	4.2823534	Culex pipiens	7175	Arthropoda	Arthropoda	252	2.18e-62	NTclustered	gi\|2415582025\|ref\|XM_039597538.2\|	42434	g71846	i0	97.931	13.1038461538462	145	3	56	0	116	260	748	604	PREDICTED: Culex pipiens pallens uncharacterized LOC120432352 (LOC120432352), mRNA	blastn	3407	252	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens

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