metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1143173" and tax

17 rows where analysis = "blastn", 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

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