metadata: contig_metadata: 26 rows where bioproject = "PRJNA1143173" and tax

26 rows where bioproject = "PRJNA1143173" 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
285853	285853	PRJNA1143173_P_NODE_11141_length_310_cov_3.329114_g11115_i0	PRJNA1143173	11141	310	3.329114	10.3202534	Halyomorpha halys	286706	Arthropoda	Arthropoda	100	1.02e-16	NTclustered	gi\|2782093048\|ref\|XM_014416035.3\|	286706	g11115	i0	80.916	0.8	131	22	42	3	2	132	3465	3338	PREDICTED: Halyomorpha halys structural maintenance of chromosomes 3 (SMC3), mRNA	blastn	248	100	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Pentatomidae	Halyomorpha	Halyomorpha halys
1560773	1560773	PRJNA1143173_P_NODE_21322_length_283_cov_3.742857_g21296_i0	PRJNA1143173	21322	283	3.742857	10.59228531	Rhopalosiphum padi	40932	Arthropoda	Arthropoda	252	2.4e-62	NTclustered	gi\|2620638104\|ref\|XM_060996787.1\|	40932	g21296	i0	99.281	5.30035335689046	139	1	49	0	1	139	5164	5302	PREDICTED: Rhopalosiphum padi NFX1-type zinc finger-containing protein 1-like (LOC132930755), mRNA	blastn	1500	252	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Rhopalosiphum	Rhopalosiphum padi
2837039	2837039	PRJNA1143173_P_NODE_28263_length_262_cov_8.306878_g28237_i0	PRJNA1143173	28263	262	8.306878	21.76402036	Aulacorthum solani	202456	Arthropoda	Arthropoda	377	3.47e-100	NTclustered	gi\|28629114\|gb\|AF487713.1\|	202456	g28237	i0	92.72	31.1908396946565	261	19	99	0	1	261	512	252	Aulacorthum solani 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	8172	377	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Aulacorthum	Aulacorthum solani
6135609	6135609	PRJNA1143173_P_NODE_29465_length_259_cov_4.462366_g29439_i0	PRJNA1143173	29465	259	4.462366	11.55752794	Insecta	50557	Arthropoda	Arthropoda	54.7	0.007	NTclustered	gi\|1946453853\|emb\|OB794262.1\|	170555	g29439	i0	96.875	1.34362934362934	32	1	12	0	96	127	151130	151161	3_Tms_b3v08	blastn	348	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema monikensis
6664365	6664365	PRJNA1143173_P_NODE_35906_length_241_cov_0.916667_g35880_i0	PRJNA1143173	35906	241	0.916667	2.20916747	Penaeus vannamei	6689	Arthropoda	Arthropoda	446	8.519999999999999e-121	NTclustered	gi\|2864115811\|ref\|XM_027358874.2\|	6689	g35880	i0	100	5.98340248962656	241	0	100	0	1	241	200	440	PREDICTED: Penaeus vannamei uncharacterized protein (LOC113807578), mRNA	blastn	1442	446	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
7410617	7410617	PRJNA1143173_P_NODE_20506_length_285_cov_8.292453_g20480_i0	PRJNA1143173	20506	285	8.292453	23.63349105	root	1	Root_unresolved	Root_unresolved	521	1.6699999999999996e-143	NTclustered	gi\|78190082\|gb\|AC168047.3\|	7176	g20480	i0	99.649	32.0526315789474	285	1	100	0	1	285	44534	44250	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence	blastn	9135	521	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
9213923	9213923	PRJNA1143173_P_NODE_12308_length_309_cov_3.538136_g12282_i0	PRJNA1143173	12308	309	3.538136	10.93284024	Notodromas monacha	399045	Arthropoda	Arthropoda	440	5.269999999999997e-119	NTclustered	gi\|1937842957\|emb\|OA907990.1\|	399045	g12282	i0	90.826	1.05825242718447	327	12	100	1	1	309	561	235	Notodromas monacha	blastn	327	440	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cyprididae	Notodromas	Notodromas monacha
11765050	11765050	PRJNA1143173_P_NODE_33350_length_248_cov_3.811429_g33324_i0	PRJNA1143173	33350	248	3.811429	9.45234392	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	202	2.0999999999999998e-47	NTclustered	gi\|146198881\|gb\|AC202216.3\|	7029	g33324	i0	81.679	16.5040322580645	262	31	100	13	1	248	18511	18769	Acyrthosiphon pisum BAC VMRC38-20-A5 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence	blastn	4093	202	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
11765157	11765157	PRJNA1143173_P_NODE_38390_length_232_cov_3.855346_g38364_i0	PRJNA1143173	38390	232	3.855346	8.94440272	Procambarus clarkii	6728	Arthropoda	Arthropoda	379	8.379999999999998e-101	NTclustered	gi\|2837517396\|ref\|XM_045753698.2\|	6728	g38364	i0	97.727	6.59051724137931	220	5	100	0	11	230	6616	6397	PREDICTED: Procambarus clarkii acyl-CoA Delta-9 desaturase (LOC123765219), mRNA	blastn	1529	379	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
15589172	15589172	PRJNA1143173_P_NODE_27073_length_266_cov_4.181347_g27047_i0	PRJNA1143173	27073	266	4.181347	11.12238302	Drosophila rhopaloa	1041015	Arthropoda	Arthropoda	52.8	0.024	NTclustered	gi\|1036873675\|ref\|XM_017123412.1\|	1041015	g27047	i0	100	0.421052631578947	28	0	11	0	56	83	8987	9014	PREDICTED: Drosophila rhopaloa uncharacterized LOC108044408 (LOC108044408), transcript variant X3, mRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila rhopaloa
17610457	17610457	PRJNA1143173_P_NODE_30714_length_255_cov_12.862637_g30688_i0	PRJNA1143173	30714	255	12.862637	32.79972435	Aphididae	27482	Arthropoda	Arthropoda	399	7.179999999999999e-107	NTclustered	gi\|2620630428\|ref\|XR_009661998.1\|	40932	g30688	i0	94.922	86.5921568627451	256	12	100	1	1	255	2284	2539	PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA	blastn	22081	399	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Rhopalosiphum	Rhopalosiphum padi
18884326	18884326	PRJNA1143173_P_NODE_28515_length_262_cov_2.708995_g28489_i0	PRJNA1143173	28515	262	2.708995	7.0975669	Limacodidae	115353	Arthropoda	Arthropoda	76.8	1.42e-9	NTclustered	gi\|2916603470\|gb\|PP022562.1\|	2834583	g28489	i0	91.228	19.706106870229	57	4	21	1	1	56	141	197	Belippa ochreata isolate LIM053 NADH dehydrogenase subunit 1 (ND1) gene, complete cds; mitochondrial	blastn	5163	76.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Limacodidae	Belippa	Belippa ochreata
18884377	18884377	PRJNA1143173_P_NODE_33475_length_248_cov_1.662857_g33449_i0	PRJNA1143173	33475	248	1.662857	4.12388536	Aphididae	27482	Arthropoda	Arthropoda	459	1.13e-124	NTclustered	gi\|2620630428\|ref\|XR_009661998.1\|	40932	g33449	i0	100	98.7338709677419	248	0	100	0	1	248	1985	2232	PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA	blastn	24486	459	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Rhopalosiphum	Rhopalosiphum padi
21963181	21963181	PRJNA1143173_P_NODE_34178_length_246_cov_1.549133_g34152_i0	PRJNA1143173	34178	246	1.549133	3.81086718	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	394	3.2e-105	NTclustered	gi\|2621257301\|ref\|XM_061021285.1\|	44670	g34152	i0	95.528	92.6056910569106	246	11	100	0	1	246	1908	2153	PREDICTED: Metopolophium dirhodum exportin-1 (LOC132950072), transcript variant X1, mRNA	blastn	22781	394	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum
22709582	22709582	PRJNA1143173_P_NODE_20838_length_284_cov_6.672986_g20812_i0	PRJNA1143173	20838	284	6.672986	18.95128024	Hymenoptera	7399	Arthropoda	Arthropoda	110	1.53e-19	NTclustered	gi\|331123671\|gb\|HM582294.1\|	1017111	g20812	i0	84.545	36.2288732394366	110	17	39	0	13	122	396	505	Sycoscapter moneres isolate SY-6 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	10289	110	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Pteromalidae	Sycoscapter	Sycoscapter moneres
24512061	24512061	PRJNA1143173_P_NODE_24020_length_275_cov_3.064356_g23994_i0	PRJNA1143173	24020	275	3.064356	8.426979	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	52.8	0.025	NTclustered	gi\|2919550840\|emb\|OZ238361.1\|	1002887	g23994	i0	100	0.101818181818182	28	0	10	0	110	137	14100628	14100601	Glaucopsyche melanops genome assembly, chromosome: 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops
24512069	24512069	PRJNA1143173_P_NODE_24580_length_273_cov_5.790000_g24554_i0	PRJNA1143173	24580	273	5.79	15.8067	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	488	1.6099999999999996e-133	NTclustered	gi\|78190082\|gb\|AC168047.3\|	7176	g24554	i0	98.901	28.1501831501831	273	3	100	0	1	273	61581	61853	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence	blastn	7685	488	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
27038748	27038748	PRJNA1143173_P_NODE_10782_length_310_cov_3.645570_g10756_i0	PRJNA1143173	10782	310	3.64557	11.301267	Timema monikensis	170555	Arthropoda	Arthropoda	62.4	9.76e-9	NR	CAD7425026.1	170555	g10756	i0	73	0.358064516129032	37	10	35.8	0	15	125	468	504	CAD7425026.1 unnamed protein product [Timema monikensis]	diamond	111	62.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema monikensis
29049063	29049063	PRJNA1143173_P_NODE_28728_length_261_cov_5.223404_g28702_i0	PRJNA1143173	28728	261	5.223404	13.63308444	Metazoa	33208	Arthropoda	Arthropoda	77.8	1.09e-14	NR	XP_018577102.1	217634	g28702	i0	49.3	2.72413793103448	75	33	86.2	1	260	36	108	177	XP_018577102.1 cathepsin L-like proteinase [Anoplophora glabripennis]	diamond	711	77.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Cerambycidae	Anoplophora	Anoplophora glabripennis
29648460	29648460	PRJNA1143173_P_NODE_29950_length_258_cov_2.713514_g29924_i0	PRJNA1143173	29950	258	2.713514	7.00086612	Opisthokonta	33154	Arthropoda	Arthropoda	79	4.05e-15	NR	KAK8736018.1	27406	g29924	i0	62.7	22.7790697674419	51	19	59.3	0	218	66	264	314	KAK8736018.1 hypothetical protein OTU49_005178, partial [Cherax quadricarinatus]	diamond	5877	79	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Parastacidae	Cherax	Cherax quadricarinatus
29711636	29711636	PRJNA1143173_P_NODE_27830_length_264_cov_2.937173_g27804_i0	PRJNA1143173	27830	264	2.937173	7.75413672	Trombidiformes	83136	Arthropoda	Arthropoda	123	1.02e-30	NR	RWS26034.1	299467	g27804	i0	69.4	2.96590909090909	85	25	96.6	1	264	10	174	257	RWS26034.1 target of rapamycin complex 2 subunit MAPKAP1-like protein [Leptotrombidium deliense]	diamond	783	124	0.991935483870968	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
31745459	31745459	PRJNA1143173_P_NODE_37337_length_236_cov_2.546012_g37311_i0	PRJNA1143173	37337	236	2.546012	6.00858832	Polyplax serrata	468196	Arthropoda	Arthropoda	43.1	0.0258	NR	KAK6616888.1	468196	g37311	i0	91.3	0.584745762711864	23	2	29.2	0	70	2	1382	1404	KAK6616888.1 Dynein heavy chain 8, axonemal [Polyplax serrata]	diamond	138	43.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Polyplacidae	Polyplax	Polyplax serrata
31892723	31892723	PRJNA1143173_P_NODE_41377_length_218_cov_7.468966_g41351_i0	PRJNA1143173	41377	218	7.468966	16.28234588	Daphnia	6668	Arthropoda	Arthropoda	64.7	4.81e-10	NR	EFX79785.1	6669	g41351	i0	48	8.10550458715596	75	34	96.3	1	4	213	187	261	EFX79785.1 hypothetical protein DAPPUDRAFT_304367 [Daphnia pulex]	diamond	1767	64.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
31966872	31966872	PRJNA1143173_P_NODE_7358_length_311_cov_3.214286_g7332_i0	PRJNA1143173	7358	311	3.214286	9.99642946	Figites sp. ZJUH 2	2995277	Arthropoda	Arthropoda	58.2	2.94e-7	NR	UZT67535.1	2995277	g7332	i0	47.4	2.60450160771704	57	30	55	0	294	124	110	166	UZT67535.1 cytochrome b [Figites sp. ZJUH 20220010]	diamond	810	58.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Figitidae	Figites	Figites sp. ZJUH 20220010
32315384	32315384	PRJNA1143173_P_NODE_15459_length_298_cov_4.724444_g15433_i0	PRJNA1143173	15459	298	4.724444	14.07884312	Clunio marinus	568069	Arthropoda	Arthropoda	159	1.1899999999999997e-42	NR	CRK93348.1	568069	g15433	i0	80.4	0.976510067114094	97	19	97.7	0	294	4	656	752	CRK93348.1 CLUMA_CG006889, isoform A [Clunio marinus]	diamond	291	159	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Clunio	Clunio marinus
32441910	32441910	PRJNA1143173_P_NODE_19959_length_287_cov_3.799065_g19933_i0	PRJNA1143173	19959	287	3.799065	10.90331655	Henosepilachna vigintioctopunctata	420089	Arthropoda	Arthropoda	60.8	2.58e-8	NR	KAK9875821.1	420089	g19933	i0	49.3	0.721254355400697	69	32	71.1	2	285	82	332	398	KAK9875821.1 hypothetical protein WA026_009608 [Henosepilachna vigintioctopunctata]	diamond	207	60.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Coccinellidae	Henosepilachna	Henosepilachna vigintioctopunctata

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