metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA478247" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA478247" 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
447831	447831	PRJNA478247_P_NODE_3581_length_152_cov_1.804878_g3475_i0	PRJNA478247	3581	152	1.804878	2.74341456	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	52.8	0.012	NTclustered	gi\|2919550840\|emb\|OZ238361.1\|	1002887	g3475	i0	100	0.184210526315789	28	0	18	0	32	59	14100601	14100628	Glaucopsyche melanops genome assembly, chromosome: 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops
1097154	1097154	PRJNA478247_P_NODE_741_length_491_cov_5.287879_g636_i0	PRJNA478247	741	491	5.287879	25.96348589	Drosophila	7215	Arthropoda	Arthropoda	230	2.059999999999999e-55	NTclustered	gi\|1847818878\|ref\|XM_034813731.1\|	7241	g636	i0	79.341	52.5865580448065	334	63	67	6	150	480	358	28	PREDICTED: Drosophila subobscura ubiquitin-40S ribosomal protein S27a (LOC117902399), transcript variant X2, mRNA	blastn	25820	230	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila subobscura
1722524	1722524	PRJNA478247_P_NODE_2862_length_186_cov_1.859873_g2756_i0	PRJNA478247	2862	186	1.859873	3.45936378	Avatara basifusca	3117480	Arthropoda	Arthropoda	124	3.32e-24	NTclustered	gi\|2916594505\|gb\|PP018080.1\|	3117480	g2756	i0	79.651	2.54838709677419	172	35	92	0	1	172	152	323	Avatara basifusca isolate L039 ribosomal protein S5 (RpS5) gene, partial cds	blastn	474	124	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Limacodidae	Avatara	Avatara basifusca
2998492	2998492	PRJNA478247_P_NODE_1303_length_338_cov_2.666667_g1197_i0	PRJNA478247	1303	338	2.666667	9.01333446	Bombyx mori	7091	Arthropoda	Arthropoda	60.2	1.91e-4	NTclustered	gi\|2919985619\|emb\|OZ208592.1\|	7091	g1197	i0	97.143	0.103550295857988	35	1	10	0	199	233	8289298	8289332	Bombyx mori genome assembly, chromosome: 14	blastn	35	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
3648285	3648285	PRJNA478247_P_NODE_2003_length_246_cov_2.474654_g1897_i0	PRJNA478247	2003	246	2.474654	6.08764884	root	1	Root_unresolved	Root_unresolved	58.4	4.78e-4	NTclustered	gi\|2304139023\|ref\|XM_050623139.1\|	85661	g1897	i0	100	6.56910569105691	31	0	13	0	120	150	190	160	PREDICTED: Bombus huntii uncharacterized LOC126868013 (LOC126868013), transcript variant X1, mRNA	blastn	1616	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus huntii
4274745	4274745	PRJNA478247_P_NODE_2124_length_235_cov_2.373786_g2018_i0	PRJNA478247	2124	235	2.373786	5.5783971	Callophrys avis	700180	Arthropoda	Arthropoda	93.5	1.24e-14	NTclustered	gi\|2918385653\|emb\|OZ238084.1\|	700180	g2018	i0	87.059	0.361702127659574	85	8	36	3	50	133	27368461	27368379	Callophrys avis genome assembly, chromosome: 17	blastn	85	93.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Callophrys	Callophrys avis
4274746	4274746	PRJNA478247_P_NODE_2204_length_228_cov_2.577889_g2098_i0	PRJNA478247	2204	228	2.577889	5.87758692	Myanoetus sp. AD832	1111321	Arthropoda	Arthropoda	209	1.14e-49	NTclustered	gi\|386696520\|gb\|JQ000670.1\|	1111321	g2098	i0	87.363	90.4517543859649	182	23	80	0	47	228	398	217	Myanoetus sp. AD832 elongation factor 1-alpha (Ef1alpha) gene, partial cds	blastn	20623	209	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Histiostomatidae	Myanoetus	Myanoetus sp. AD832
4274747	4274747	PRJNA478247_P_NODE_2864_length_186_cov_1.490446_g2758_i0	PRJNA478247	2864	186	1.490446	2.77222956	Drosophila teissieri	7243	Arthropoda	Arthropoda	130	7.14e-26	NTclustered	gi\|2098548186\|ref\|XM_043800372.1\|	7243	g2758	i0	82.353	11.5698924731183	153	23	81	2	31	181	391	541	PREDICTED: Drosophila teissieri ras-related protein Rab-1A (LOC122622150), mRNA	blastn	2152	130	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila teissieri
6200279	6200279	PRJNA478247_P_NODE_1865_length_258_cov_2.017467_g1759_i0	PRJNA478247	1865	258	2.017467	5.20506486	Diptera	7147	Arthropoda	Arthropoda	211	3.66e-50	NTclustered	gi\|157361582\|gb\|EU045352.1\|	29031	g1759	i0	87.097	73.7170542635659	186	24	72	0	29	214	338	523	Phlebotomus papatasi 60S ribosomal protein L11-like protein mRNA, complete cds	blastn	19019	211	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Phlebotomus	Phlebotomus papatasi
7475144	7475144	PRJNA478247_P_NODE_266_length_959_cov_12.903226_g202_i0	PRJNA478247	266	959	12.903226	123.74193734	Vespula	7451	Arthropoda	Arthropoda	67.6	3.47e-6	NTclustered	gi\|2313469058\|ref\|XM_050998522.1\|	7454	g202	i0	93.333	0.815432742440042	45	3	5	0	486	530	703	659	PREDICTED: Vespula vulgaris dynein axonemal assembly factor 1 homolog (LOC127065734), mRNA	blastn	782	67.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Vespidae	Vespula	Vespula vulgaris
10025455	10025455	PRJNA478247_P_NODE_3048_length_175_cov_1.438356_g2942_i0	PRJNA478247	3048	175	1.438356	2.5171230000000002	Artemia	6660	Arthropoda	Arthropoda	324	2.83e-84	NTclustered	gi\|2743080997\|ref\|XR_010618360.1\|	6661	g2942	i0	100	64.3714285714286	175	0	100	0	1	175	352	526	PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA	blastn	11265	324	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
10651458	10651458	PRJNA478247_P_NODE_1189_length_359_cov_9.275758_g1083_i0	PRJNA478247	1189	359	9.275758	33.29997122	Apis dorsata	7462	Arthropoda	Arthropoda	217	1.14e-51	NTclustered	gi\|1772580273\|ref\|XM_031508371.1\|	7462	g1083	i0	80.132	10.2674094707521	302	51	84	8	57	356	388	94	PREDICTED: Apis dorsata histone H4 (LOC102675541), mRNA	blastn	3686	217	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Apis	Apis dorsata
15125105	15125105	PRJNA478247_P_NODE_712_length_502_cov_3.860465_g607_i0	PRJNA478247	712	502	3.860465	19.3795343	Arthropoda	6656	Arthropoda	Arthropoda	189	3.5799999999999993e-43	NTclustered	gi\|2245586771\|ref\|XM_003402262.3\|	30195	g607	i0	85.106	65.0537848605578	188	24	37	4	309	494	545	730	PREDICTED: Bombus terrestris polyubiquitin-A (LOC100648000), mRNA	blastn	32657	189	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus terrestris
18299351	18299351	PRJNA478247_P_NODE_735_length_493_cov_2.618534_g630_i0	PRJNA478247	735	493	2.618534	12.90937262	Lepisma saccharinum	50586	Arthropoda	Arthropoda	102	4.71e-17	NTclustered	gi\|170516883\|gb\|EU376048.1\|	50586	g630	i0	94.03	13.5902636916836	67	4	14	0	1	67	3445	3379	Lepisma saccharina 28S ribosomal RNA gene, partial sequence	blastn	6700	102	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Zygentoma	Lepismatidae	Lepisma	Lepisma saccharinum
19573559	19573559	PRJNA478247_P_NODE_2376_length_216_cov_1.909091_g2270_i0	PRJNA478247	2376	216	1.909091	4.12363656	Riptortus pedestris	329032	Arthropoda	Arthropoda	132	2.38e-26	NTclustered	gi\|501293323\|dbj\|AK417370.1\|	329032	g2270	i0	80.925	14.8194444444444	173	27	79	5	2	171	224	393	Riptortus pedestris mRNA for ADP-ribosylation factor, arf, complete cds, sequence id: Rped-0588	blastn	3201	132	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Alydidae	Riptortus	Riptortus pedestris
20223500	20223500	PRJNA478247_P_NODE_3396_length_159_cov_1.592308_g3290_i0	PRJNA478247	3396	159	1.592308	2.53176972	Opisthokonta	33154	Arthropoda	Arthropoda	60.2	7.87e-5	NTclustered	gi\|2311992417\|ref\|XM_050836884.1\|	95602	g3290	i0	100	6.70440251572327	32	0	20	0	1	32	192	161	PREDICTED: Eriocheir sinensis 60S ribosomal protein L32-like (LOC126983782), mRNA	blastn	1066	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis
20849380	20849380	PRJNA478247_P_NODE_3177_length_168_cov_2.251799_g3071_i0	PRJNA478247	3177	168	2.251799	3.78302232	Inbiomyia mcalpineorum	1262305	Arthropoda	Arthropoda	99	1.79e-16	NTclustered	gi\|425869918\|gb\|KC177817.1\|	1262305	g3071	i0	84.466	58.9523809523809	103	12	60	4	1	101	3500	3600	Inbiomyia mcalpineorum 28S ribosomal RNA gene, partial sequence	blastn	9904	99	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Inbiomyiidae	Inbiomyia	Inbiomyia mcalpineorum
24673863	24673863	PRJNA478247_P_NODE_3180_length_168_cov_1.812950_g3074_i0	PRJNA478247	3180	168	1.81295	3.045756	Phlebotomus papatasi	29031	Arthropoda	Arthropoda	117	4.93e-22	NTclustered	gi\|2500694446\|ref\|XM_055848916.1\|	29031	g3074	i0	83.721	14.9345238095238	129	15	75	3	17	142	868	993	PREDICTED: Phlebotomus papatasi ras-related protein Rap-2a (LOC129802817), mRNA	blastn	2509	117	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Phlebotomus	Phlebotomus papatasi
25323395	25323395	PRJNA478247_P_NODE_160_length_1173_cov_2.166958_g117_i0	PRJNA478247	160	1173	2.166958	25.41841734	root	1	Root_unresolved	Root_unresolved	56.5	0.009	NTclustered	gi\|2288491797\|ref\|XM_027995372.2\|	80765	g117	i0	96.97	0.0809889173060529	33	1	3	0	265	297	827	795	PREDICTED: Aphis gossypii ATP-dependent RNA helicase vasa-like (LOC114130394), mRNA	blastn	95	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Aphis	Aphis gossypii

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