metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA658591" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA658591" 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
1901666	1901666	PRJNA658591_S_NODE_8102_length_174_cov_1.368000_g8039_i0	PRJNA658591	8102	174	1.368	2.38032	Zischkaia pacarus	681818	Arthropoda	Arthropoda	104	3.98e-18	NTclustered	gi\|2567337862\|gb\|OK812757.1\|	681818	g8039	i0	83.333	5.07471264367816	114	17	65	2	20	132	160	272	Zischkaia pacarus voucher MGCL:LEP-53250 mitochondrial prohibitin complex protein 2 gene, partial cds; nuclear gene for mitochondrial product	blastn	883	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Zischkaia	Zischkaia pacarus
1901669	1901669	PRJNA658591_S_NODE_8542_length_170_cov_7.000000_g8479_i0	PRJNA658591	8542	170	7	11.9	Galleria mellonella	7137	Arthropoda	Arthropoda	171	3.7599999999999997e-38	NTclustered	gi\|1476366213\|gb\|MG846920.1\|	7137	g8479	i0	84.795	78.9352941176471	171	24	100	2	1	170	639	470	Galleria mellonella heat shock protein 90 (HSP90) mRNA, complete cds	blastn	13419	171	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pyralidae	Galleria	Galleria mellonella
3176344	3176344	PRJNA658591_S_NODE_10463_length_161_cov_2.473214_g10400_i0	PRJNA658591	10463	161	2.473214	3.98187454	Microplitis mediator	375433	Arthropoda	Arthropoda	54.7	0.004	NTclustered	gi\|2520960774\|ref\|XR_008989464.1\|	375433	g10400	i0	100	0.360248447204969	29	0	18	0	76	104	5389	5417	PREDICTED: Microplitis mediator calcium-transporting ATPase sarcoplasmic/endoplasmic reticulum type (LOC130664762), transcript variant X2, misc_RNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Microplitis	Microplitis mediator
3176369	3176369	PRJNA658591_S_NODE_7263_length_181_cov_0.992424_g7200_i0	PRJNA658591	7263	181	0.992424	1.79628744	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	134	5.34e-27	NTclustered	gi\|1535903816\|ref\|XM_027337872.1\|	6956	g7200	i0	83.448	1.83425414364641	145	23	80	1	35	178	1416	1560	PREDICTED: Dermatophagoides pteronyssinus endoplasmin-like (LOC113788421), mRNA	blastn	332	134	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
3176375	3176375	PRJNA658591_S_NODE_903_length_417_cov_6.345109_g840_i0	PRJNA658591	903	417	6.345109	26.45910453	Bactrocera oleae	104688	Arthropoda	Arthropoda	300	1.3e-76	NTclustered	gi\|2863719144\|ref\|XM_014247959.3\|	104688	g840	i0	83.861	50.9256594724221	316	49	76	2	1	315	468	154	PREDICTED: Bactrocera oleae alpha-Tubulin at 84B (alphaTub84B), mRNA	blastn	21236	300	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Bactrocera	Bactrocera oleae
4989705	4989705	PRJNA658591_S_NODE_724_length_453_cov_7.202970_g662_i0	PRJNA658591	724	453	7.20297	32.6294541	root	1	Root_unresolved	Root_unresolved	798	0	NTclustered	gi\|78097480\|gb\|AC167666.4\|	7176	g662	i0	98.881	236.938189845475	447	5	99	0	7	453	1322	876	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence	blastn	107333	806	0.990074441687345	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
5728913	5728913	PRJNA658591_S_NODE_10425_length_161_cov_3.892857_g10362_i0	PRJNA658591	10425	161	3.892857	6.26749977	Chelidurella thaleri	2546182	Arthropoda	Arthropoda	52.8	0.013	NTclustered	gi\|2919606661\|emb\|OZ238400.1\|	2546182	g10362	i0	100	0.173913043478261	28	0	17	0	28	55	17090596	17090623	Chelidura thaleri genome assembly, chromosome: 1	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Dermaptera	Forficulidae	Chelidurella	Chelidurella thaleri
5728928	5728928	PRJNA658591_S_NODE_4185_length_221_cov_6.732558_g4122_i0	PRJNA658591	4185	221	6.732558	14.87895318	Chelidurella thaleri	2546182	Arthropoda	Arthropoda	52.8	0.02	NTclustered	gi\|2919606661\|emb\|OZ238400.1\|	2546182	g4122	i0	100	0.253393665158371	28	0	13	0	15	42	9174318	9174291	Chelidura thaleri genome assembly, chromosome: 1	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Dermaptera	Forficulidae	Chelidurella	Chelidurella thaleri
7004071	7004071	PRJNA658591_S_NODE_10686_length_159_cov_2.163636_g10623_i0	PRJNA658591	10686	159	2.163636	3.44018124	Agapeta hamana	1100904	Arthropoda	Arthropoda	58.4	2.83e-4	NTclustered	gi\|2918370033\|emb\|OZ237961.1\|	1100904	g10623	i0	97.143	4.0377358490566	35	0	21	1	53	86	6888312	6888278	Agapeta hamana genome assembly, chromosome: 1	blastn	642	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Agapeta	Agapeta hamana
7539316	7539316	PRJNA658591_S_NODE_5726_length_197_cov_5.033784_g5663_i0	PRJNA658591	5726	197	5.033784	9.91655448	Timema	61471	Arthropoda	Arthropoda	52.8	0.017	NTclustered	gi\|1947616272\|emb\|OD657499.1\|	61472	g5663	i0	100	0.426395939086294	28	0	14	0	157	184	396	423	4_Tbi_b3v08	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema bartmani
8278723	8278723	PRJNA658591_S_NODE_247_length_706_cov_14.684932_g204_i0	PRJNA658591	247	706	14.684932	103.67561992	Oppiella nova	334625	Arthropoda	Arthropoda	54.7	0.02	NTclustered	gi\|1962580772\|emb\|OC914909.1\|	334625	g204	i0	100	0.0410764872521246	29	0	4	0	82	110	7584	7612	Oppiella nova	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
8278725	8278725	PRJNA658591_S_NODE_2607_length_266_cov_9.645161_g2544_i0	PRJNA658591	2607	266	9.645161	25.65612826	Satyrium ilicis	876074	Arthropoda	Arthropoda	52.8	0.024	NTclustered	gi\|2918386088\|emb\|OZ238121.1\|	876074	g2544	i0	100	0.105263157894737	28	0	11	0	105	132	23317818	23317845	Satyrium ilicis genome assembly, chromosome: 12	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Satyrium	Satyrium ilicis
8814383	8814383	PRJNA658591_S_NODE_9807_length_164_cov_1.417391_g9744_i0	PRJNA658591	9807	164	1.417391	2.32452124	root	1	Root_unresolved	Root_unresolved	298	1.59e-76	NTclustered	gi\|83281396\|gb\|AC167967.6\|	7176	g9744	i0	99.39	172.951219512195	164	1	100	0	1	164	6	169	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940144D9, complete sequence	blastn	28364	298	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
12104845	12104845	PRJNA658591_S_NODE_4690_length_212_cov_28.368098_g4627_i0	PRJNA658591	4690	212	28.368098	60.14036776	Papilio polytes	76194	Arthropoda	Arthropoda	233	6.2e-57	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g4627	i0	99.219	0.60377358490566	128	1	60	0	1	128	128	1	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	128	233	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
12104846	12104846	PRJNA658591_S_NODE_4770_length_211_cov_2.302469_g4707_i0	PRJNA658591	4770	211	2.302469	4.85820959	Papilio polytes	76194	Arthropoda	Arthropoda	390	3.459999999999999e-104	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g4707	i0	100	28.8293838862559	211	0	100	0	1	211	319	109	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	6083	390	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
12104864	12104864	PRJNA658591_S_NODE_8410_length_171_cov_8.163934_g8347_i0	PRJNA658591	8410	171	8.163934	13.96032714	Bombyx mori	7091	Arthropoda	Arthropoda	60.2	8.56e-5	NTclustered	gi\|2919985619\|emb\|OZ208592.1\|	7091	g8347	i0	97.143	0.204678362573099	35	1	20	0	99	133	8289332	8289298	Bombyx mori genome assembly, chromosome: 14	blastn	35	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
13915414	13915414	PRJNA658591_S_NODE_3631_length_234_cov_6.648649_g3568_i0	PRJNA658591	3631	234	6.648649	15.55783866	Timema	61471	Arthropoda	Arthropoda	52.8	0.021	NTclustered	gi\|1936895876\|emb\|OA565436.1\|	61478	g3568	i0	100	0.239316239316239	28	0	12	0	126	153	58733	58706	1_Tdi_b3v08	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema douglasi
14654435	14654435	PRJNA658591_S_NODE_712_length_456_cov_14.928747_g650_i0	PRJNA658591	712	456	14.928747	68.07508632	Timema monikensis	170555	Arthropoda	Arthropoda	58.4	0.001	NTclustered	gi\|1946411097\|emb\|OB793204.1\|	170555	g650	i0	97.059	0.197368421052632	34	1	7	0	84	117	168510	168543	3_Tms_b3v08	blastn	90	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema monikensis
17739291	17739291	PRJNA658591_S_NODE_3294_length_242_cov_25.227979_g3231_i0	PRJNA658591	3294	242	25.227979	61.05170918	Insecta	50557	Arthropoda	Arthropoda	165	2.68e-36	NTclustered	gi\|1069718934\|ref\|XM_018460340.1\|	64791	g3231	i0	84	114.578512396694	175	24	71	4	3	175	309	137	PREDICTED: Trachymyrmex zeteki polyubiquitin (LOC108730564), mRNA	blastn	27728	165	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Mycetomoellerius	Mycetomoellerius zeteki
19752493	19752493	PRJNA658591_S_NODE_536_length_516_cov_3.753747_g475_i0	PRJNA658591	536	516	3.753747	19.36933452	Bradysia coprophila	38358	Arthropoda	Arthropoda	348	5.76e-91	NTclustered	gi\|1928081288\|ref\|XM_037188404.1\|	38358	g475	i0	81.903	83.7906976744186	431	60	84	13	78	508	600	1012	PREDICTED: Bradysia coprophila ATP synthase subunit beta, mitochondrial (LOC119080178), mRNA	blastn	43236	348	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia coprophila
19752497	19752497	PRJNA658591_S_NODE_656_length_469_cov_15.407143_g594_i0	PRJNA658591	656	469	15.407143	72.25950067	Papilio polytes	76194	Arthropoda	Arthropoda	867	0	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g594	i0	100	5.65031982942431	469	0	100	0	1	469	292	760	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	2650	867	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
19752501	19752501	PRJNA658591_S_NODE_8516_length_171_cov_0.909836_g8453_i0	PRJNA658591	8516	171	0.909836	1.55581956	Rhipicephalus microplus	6941	Arthropoda	Arthropoda	93.5	8.44e-15	NTclustered	gi\|1930392650\|ref\|XM_037431523.1\|	6941	g8453	i0	83.838	3.23391812865497	99	14	57	2	61	158	204	301	PREDICTED: Rhipicephalus microplus 40S ribosomal protein S11-like (LOC119180341), mRNA	blastn	553	93.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
21028041	21028041	PRJNA658591_S_NODE_9617_length_165_cov_1.344828_g9554_i0	PRJNA658591	9617	165	1.344828	2.2189662	Rhopalosiphum padi	40932	Arthropoda	Arthropoda	300	4.46e-77	NTclustered	gi\|2017496638\|gb\|MW804916.1\|	40932	g9554	i0	99.394	98.5454545454545	165	1	100	0	1	165	313	149	Rhopalosiphum padi voucher VAITC7088 small subunit ribosomal RNA gene, partial sequence	blastn	16260	300	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Rhopalosiphum	Rhopalosiphum padi
22302766	22302766	PRJNA658591_S_NODE_6478_length_188_cov_4.719424_g6415_i0	PRJNA658591	6478	188	4.719424	8.87251712	Musca vetustissima	27455	Arthropoda	Arthropoda	189	1.1799999999999999e-43	NTclustered	gi\|2635631026\|ref\|XM_061544527.1\|	27455	g6415	i0	86.628	113.106382978723	172	21	91	2	3	173	245	75	PREDICTED: Musca vetustissima ubiquitin-ribosomal protein eL40 fusion protein (LOC133336244), mRNA	blastn	21264	189	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Muscidae	Musca	Musca vetustissima
22302768	22302768	PRJNA658591_S_NODE_7058_length_182_cov_8.075188_g6995_i0	PRJNA658591	7058	182	8.075188	14.69684216	Timema genevievae	629358	Arthropoda	Arthropoda	54.7	0.004	NTclustered	gi\|1965353221\|emb\|OE839146.1\|	629358	g6995	i0	100	0.467032967032967	29	0	16	0	1	29	497512	497484	5_Tge_b3v08	blastn	85	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema genevievae
22838811	22838811	PRJNA658591_S_NODE_10698_length_158_cov_31.155963_g10635_i0	PRJNA658591	10698	158	31.155963	49.22642154	Timema	61471	Arthropoda	Arthropoda	56.5	0.001	NTclustered	gi\|1946288829\|emb\|OD602106.1\|	61472	g10635	i0	96.97	0.626582278481013	33	1	21	0	9	41	1722	1690	4_Tbi_b3v08	blastn	99	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema bartmani
23578133	23578133	PRJNA658591_S_NODE_3919_length_227_cov_3.567416_g3856_i0	PRJNA658591	3919	227	3.567416	8.09803432	Cydia splendana	1100963	Arthropoda	Arthropoda	52.8	0.02	NTclustered	gi\|2695898591\|ref\|XM_063769561.1\|	1100963	g3856	i0	100	0.123348017621145	28	0	12	0	125	152	994	1021	PREDICTED: Cydia splendana uncharacterized LOC134797339 (LOC134797339), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Cydia	Cydia splendana
23578149	23578149	PRJNA658591_S_NODE_9119_length_167_cov_3.669492_g9056_i0	PRJNA658591	9119	167	3.669492	6.12805164	Ooceraea biroi	2015173	Arthropoda	Arthropoda	52.8	0.014	NTclustered	gi\|1510432685\|ref\|XM_011335744.3\|	2015173	g9056	i0	100	7.04191616766467	28	0	17	0	130	157	2754	2781	PREDICTED: Ooceraea biroi zinc finger BED domain-containing protein 1 (LOC105277401), mRNA	blastn	1176	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Ooceraea	Ooceraea biroi

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