metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA688736" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA688736" 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
668011	668011	PRJNA688736_P_NODE_42041_length_251_cov_0.876404_g41756_i0	PRJNA688736	42041	251	0.876404	2.19977404	Amphibalanus amphitrite	1232801	Arthropoda	Arthropoda	111	3.7e-20	NTclustered	gi\|2087184152\|ref\|XM_043338193.1\|	1232801	g41756	i0	95.652	27.3346613545817	69	3	27	0	8	76	626	694	PREDICTED: Amphibalanus amphitrite 60S ribosomal protein L19-like (LOC122366210), mRNA	blastn	6861	111	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Thecostraca	Balanomorpha	Balanidae	Amphibalanus	Amphibalanus amphitrite
1944159	1944159	PRJNA688736_P_NODE_48402_length_244_cov_0.912281_g48117_i0	PRJNA688736	48402	244	0.912281	2.22596564	Nilaparvata lugens	108931	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|2837364275\|gb\|PQ492453.1\|	108931	g48117	i0	100	0.114754098360656	28	0	11	0	35	62	5114	5141	Nilaparvata lugens clone Nl.chrX.1239 oviposition secretion protein mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Delphacidae	Nilaparvata	Nilaparvata lugens
3218430	3218430	PRJNA688736_P_NODE_21483_length_339_cov_0.872180_g21198_i0	PRJNA688736	21483	339	0.87218	2.9566902	Episema korsakovi	1870626	Arthropoda	Arthropoda	54.7	0.009	NTclustered	gi\|2920003685\|emb\|OZ238899.1\|	1870626	g21198	i0	100	0.0855457227138643	29	0	9	0	2	30	13326297	13326325	Episema korsakovi genome assembly, chromosome: 23	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Episema	Episema korsakovi
5771651	5771651	PRJNA688736_P_NODE_42905_length_250_cov_0.881356_g42620_i0	PRJNA688736	42905	250	0.881356	2.20339	Bombyx mori	7091	Arthropoda	Arthropoda	462	8.83e-126	NTclustered	gi\|2668798910\|ref\|XM_012695462.4\|	7091	g42620	i0	100	13.024	250	0	100	0	1	250	4074	4323	PREDICTED: Bombyx mori rho guanine nucleotide exchange factor 10 (LOC101745631), transcript variant X3, mRNA	blastn	3256	462	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
5771782	5771782	PRJNA688736_P_NODE_48105_length_245_cov_0.906977_g47820_i0	PRJNA688736	48105	245	0.906977	2.22209365	Drosophila melanogaster	7227	Arthropoda	Arthropoda	442	1.1199999999999994e-119	NTclustered	gi\|50872386\|gb\|AC008225.4\|	7227	g47820	i0	99.184	8.2530612244898	245	2	100	0	1	245	132798	133042	Drosophila melanogaster clone BACR03E11, complete sequence	blastn	2022	442	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
7046207	7046207	PRJNA688736_P_NODE_24666_length_319_cov_1.268293_g24381_i0	PRJNA688736	24666	319	1.268293	4.04585467	Bemisia tabaci	7038	Arthropoda	Arthropoda	590	5.1299999999999986e-164	NTclustered	gi\|2259165533\|emb\|OU815654.1\|	7038	g24381	i0	100	90.282131661442	319	0	100	0	1	319	9631	9949	Bemisia tabaci genome assembly, organelle: mitochondrion	blastn	28800	590	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
8320747	8320747	PRJNA688736_P_NODE_25007_length_317_cov_1.278689_g24722_i0	PRJNA688736	25007	317	1.278689	4.05344413	Daphnia pulicaria	35523	Arthropoda	Arthropoda	237	7.64e-58	NTclustered	gi\|1691110223\|emb\|LR015704.1\|	35523	g24722	i0	80.921	90.9116719242902	304	54	95	4	14	315	968	667	Daphnia pulicaria mRNA for EOG090X00V6 (EOG090X00V6 gene), isolate CZ-RIM1-1	blastn	28819	237	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulicaria
9596307	9596307	PRJNA688736_P_NODE_31408_length_286_cov_1.356808_g31123_i0	PRJNA688736	31408	286	1.356808	3.88047088	Phlebotomus papatasi	29031	Arthropoda	Arthropoda	176	1.4999999999999998e-39	NTclustered	gi\|2500682362\|ref\|XM_055842341.1\|	29031	g31123	i0	79.216	2.32867132867133	255	51	89	2	9	262	397	144	PREDICTED: Phlebotomus papatasi ubiquitin-conjugating enzyme E2-18 kDa (LOC129798880), mRNA	blastn	666	176	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Phlebotomus	Phlebotomus papatasi
9596400	9596400	PRJNA688736_P_NODE_34948_length_271_cov_1.287879_g34663_i0	PRJNA688736	34948	271	1.287879	3.49015209	Phronia biarcuata	2565953	Arthropoda	Arthropoda	193	1.3999999999999998e-44	NTclustered	gi\|1624435184\|gb\|MK190947.1\|	2565953	g34663	i0	83.333	84.6051660516605	216	28	78	6	1	212	175	386	Phronia biarcuata voucher JSPhBi elongation factor 1-alpha (EF1a) gene, partial cds	blastn	22928	193	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Mycetophilidae	Phronia	Phronia biarcuata
15970723	15970723	PRJNA688736_P_NODE_42893_length_250_cov_0.881356_g42608_i0	PRJNA688736	42893	250	0.881356	2.20339	Penaeus vannamei	6689	Arthropoda	Arthropoda	462	8.83e-126	NTclustered	gi\|2864132642\|ref\|XM_027372083.2\|	6689	g42608	i0	100	8.496	250	0	100	0	1	250	564	813	PREDICTED: Penaeus vannamei elongation factor 1-beta (LOC113819864), mRNA	blastn	2124	462	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
15970791	15970791	PRJNA688736_P_NODE_45593_length_247_cov_0.896552_g45308_i0	PRJNA688736	45593	247	0.896552	2.21448344	Penaeus vannamei	6689	Arthropoda	Arthropoda	252	2.05e-62	NTclustered	gi\|2864075582\|ref\|XM_070131292.1\|	6689	g45308	i0	96.104	2.64777327935223	154	6	62	0	12	165	173	20	PREDICTED: Penaeus vannamei sodium/calcium exchanger regulatory protein 1 (LOC113803442), mRNA	blastn	654	252	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
18519989	18519989	PRJNA688736_P_NODE_38495_length_257_cov_1.695652_g38210_i0	PRJNA688736	38495	257	1.695652	4.35782564	Cydia strobilella	1100964	Arthropoda	Arthropoda	119	2.2700000000000003e-22	NTclustered	gi\|2694271124\|ref\|XM_063683640.1\|	1100964	g38210	i0	91.765	1.58365758754864	85	7	33	0	35	119	497	581	PREDICTED: Cydia strobilella small ribosomal subunit protein eS6 (LOC134748830), mRNA	blastn	407	119	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Cydia	Cydia strobilella
19794468	19794468	PRJNA688736_P_NODE_21936_length_335_cov_6.587786_g21651_i0	PRJNA688736	21936	335	6.587786	22.0690831	Helicoverpa assulta	52344	Arthropoda	Arthropoda	52.8	0.032	NTclustered	gi\|2636206755\|emb\|OY979781.1\|	52344	g21651	i0	100	0.0835820895522388	28	0	8	0	76	103	8315242	8315215	Helicoverpa assulta genome assembly, chromosome: 7	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Helicoverpa	Helicoverpa assulta
19794797	19794797	PRJNA688736_P_NODE_36036_length_267_cov_1.092784_g35751_i0	PRJNA688736	36036	267	1.092784	2.91773328	Penaeus vannamei	6689	Arthropoda	Arthropoda	488	1.5699999999999998e-133	NTclustered	gi\|2864138440\|ref\|XM_070124566.1\|	6689	g35751	i0	99.625	5.63295880149813	267	1	100	0	1	267	5335	5069	PREDICTED: Penaeus vannamei phospholipid-transporting ATPase ABCA3 (LOC113823173), transcript variant X1, mRNA	blastn	1504	488	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
19795007	19795007	PRJNA688736_P_NODE_44676_length_248_cov_0.891429_g44391_i0	PRJNA688736	44676	248	0.891429	2.21074392	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|2919550840\|emb\|OZ238361.1\|	1002887	g44391	i0	100	0.112903225806452	28	0	11	0	115	142	14100601	14100628	Glaucopsyche melanops genome assembly, chromosome: 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops
21070327	21070327	PRJNA688736_P_NODE_37377_length_262_cov_0.941799_g37092_i0	PRJNA688736	37377	262	0.941799	2.46751338	Darwinula stevensoni	69355	Arthropoda	Arthropoda	52.8	0.024	NTclustered	gi\|1936519344\|emb\|LR901024.1\|	69355	g37092	i0	100	0.106870229007634	28	0	11	0	35	62	28858	28885	Darwinula stevensoni	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
21070548	21070548	PRJNA688736_P_NODE_46077_length_247_cov_0.896552_g45792_i0	PRJNA688736	46077	247	0.896552	2.21448344	Drosophila hydei	7224	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|1720303805\|ref\|XM_023320708.2\|	7224	g45792	i0	100	1.1336032388664	28	0	11	0	219	246	978	951	PREDICTED: Drosophila hydei uncharacterized LOC111603211 (LOC111603211), mRNA	blastn	280	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila hydei
22344635	22344635	PRJNA688736_P_NODE_11158_length_449_cov_2.859043_g10873_i0	PRJNA688736	11158	449	2.859043	12.83710307	Rhipicephalus microplus	6941	Arthropoda	Arthropoda	196	1.9e-45	NTclustered	gi\|1930415947\|ref\|XM_037422632.1\|	6941	g10873	i0	86.932	51.5077951002227	176	22	39	1	54	229	131	305	PREDICTED: Rhipicephalus microplus 40S ribosomal protein S25-like (LOC119171793), mRNA	blastn	23127	196	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
22345199	22345199	PRJNA688736_P_NODE_35938_length_267_cov_1.365979_g35653_i0	PRJNA688736	35938	267	1.365979	3.64716393	Procambarus clarkii	6728	Arthropoda	Arthropoda	488	1.5699999999999998e-133	NTclustered	gi\|1127778741\|gb\|KX268742.1\|	6728	g35653	i0	99.625	99.4681647940075	267	1	100	0	1	267	7679	7413	Procambarus clarkii isolate F10 mitochondrion, complete genome	blastn	26558	488	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
22855167	22855167	PRJNA688736_P_NODE_44538_length_248_cov_0.891429_g44253_i0	PRJNA688736	44538	248	0.891429	2.21074392	Eriocheir	95601	Arthropoda	Arthropoda	459	1.13e-124	NTclustered	gi\|2311877481\|ref\|XR_007745368.1\|	95602	g44253	i0	100	100.286290322581	248	0	100	0	1	248	1311	1064	PREDICTED: Eriocheir sinensis large subunit ribosomal RNA (LOC126991277), rRNA	blastn	24871	459	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis
23620497	23620497	PRJNA688736_P_NODE_27239_length_305_cov_1.831897_g26954_i0	PRJNA688736	27239	305	1.831897	5.58728585	Acartia pacifica	335913	Arthropoda	Arthropoda	113	1.29e-20	NTclustered	gi\|961374973\|gb\|KT754397.1\|	335913	g26954	i0	79.503	1.58032786885246	161	31	52	2	129	288	218	59	Acartia pacifica clone Apa_cDNA78-1 60S ribosomal protein L39 mRNA, complete cds	blastn	482	113	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Calanoida	Acartiidae	Acartia	Acartia pacifica

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