metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1192965" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1192965" 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
320573	320573	PRJNA1192965_P_NODE_4061_length_247_cov_0.885057_g4042_i0	PRJNA1192965	4061	247	0.885057	2.18609079	Eurytides marcellus	77245	Arthropoda	Arthropoda	169	2.1199999999999996e-37	NTclustered	gi\|2569059043\|gb\|OL120312.1\|	77245	g4042	i0	78.947	82.7449392712551	247	52	100	0	1	247	611	365	Protographium marcellus voucher MGCL:RF150001 delta-aminolevulinic acid dehydratase gene, partial cds	blastn	20438	169	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Eurytides	Eurytides marcellus
2871284	2871284	PRJNA1192965_P_NODE_3383_length_251_cov_0.865169_g3364_i0	PRJNA1192965	3383	251	0.865169	2.17157419	Drosophila arizonae	7263	Arthropoda	Arthropoda	459	1.1499999999999996e-124	NTclustered	gi\|1060148718\|ref\|XM_018017645.1\|	7263	g3364	i0	99.602	81.7808764940239	251	1	100	0	1	251	984	1234	PREDICTED: Drosophila arizonae larval serum protein 1 beta chain (LOC108620721), mRNA	blastn	20527	459	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila arizonae
2871288	2871288	PRJNA1192965_P_NODE_3883_length_248_cov_0.880000_g3864_i0	PRJNA1192965	3883	248	0.88	2.1824	Belgica antarctica	315563	Arthropoda	Arthropoda	104	6.11e-18	NTclustered	gi\|405132182\|gb\|JX462669.1\|	315563	g3864	i0	83.051	5.23387096774194	118	16	47	4	115	230	100	215	Belgica antarctica ribosomal protein 49 (rp49) mRNA, complete cds	blastn	1298	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Belgica	Belgica antarctica
6145221	6145221	PRJNA1192965_P_NODE_385_length_578_cov_1.324752_g367_i0	PRJNA1192965	385	578	1.324752	7.65706656	Insecta	50557	Arthropoda	Arthropoda	374	1.07e-98	NTclustered	gi\|269784694\|ref\|NM_001167977.1\|	7425	g367	i0	79.584	87.878892733564	529	103	91	5	9	534	1145	619	Nasonia vitripennis ATP synthase subunit alpha blw, mitochondrial (blw), mRNA; nuclear gene for mitochondrial product	blastn	50794	374	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Pteromalidae	Nasonia	Nasonia vitripennis
6698367	6698367	PRJNA1192965_P_NODE_2626_length_273_cov_1.125000_g2607_i0	PRJNA1192965	2626	273	1.125	3.07125	Praetaxila segecia	2847667	Arthropoda	Arthropoda	220	6.49e-53	NTclustered	gi\|2567321352\|gb\|OK804502.1\|	2847667	g2607	i0	82.731	90.7545787545788	249	41	91	2	3	250	898	1145	Praetaxila segecia voucher AM:Entomology:CJM-15-2380 heat shock cognate protein gene, partial cds	blastn	24776	220	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Riodinidae	Praetaxila	Praetaxila segecia
9248437	9248437	PRJNA1192965_P_NODE_4628_length_244_cov_0.900585_g4609_i0	PRJNA1192965	4628	244	0.900585	2.1974274	Pollicipes pollicipes	41117	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|1929189979\|ref\|XM_037235214.1\|	41117	g4609	i0	100	0.237704918032787	30	0	12	0	141	170	2116	2087	PREDICTED: Pollicipes pollicipes centrosomal protein of 152 kDa-like (LOC119111400), mRNA	blastn	58	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Thecostraca	Pollicipedomorpha	Pollicipedidae	Pollicipes	Pollicipes pollicipes
10524216	10524216	PRJNA1192965_P_NODE_5269_length_235_cov_2.302469_g5250_i0	PRJNA1192965	5269	235	2.302469	5.41080215	Aedes albopictus	7160	Arthropoda	Arthropoda	174	4.31e-39	NTclustered	gi\|2669928570\|ref\|XM_019707185.3\|	7160	g5250	i0	80.335	92.0468085106383	239	39	100	8	1	235	374	608	PREDICTED: Aedes albopictus small ribosomal subunit protein uS13 (LOC109431049), mRNA	blastn	21631	174	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Aedes	Aedes albopictus
13074099	13074099	PRJNA1192965_P_NODE_2691_length_270_cov_2.157360_g2672_i0	PRJNA1192965	2691	270	2.15736	5.824872	Timema tahoe	61484	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|1946338856\|emb\|OE001222.1\|	61484	g2672	i0	92.5	0.503703703703704	40	2	15	1	184	223	155441	155479	4_Tte_b3v08	blastn	136	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema tahoe
13074104	13074104	PRJNA1192965_P_NODE_3171_length_253_cov_2.855556_g3152_i0	PRJNA1192965	3171	253	2.855556	7.22455668	Daphnia pulex	6669	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2192734159\|ref\|XM_046600325.1\|	6669	g3152	i0	94.595	0.58498023715415	37	0	14	2	83	117	8498	8462	PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA	blastn	148	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
13795749	13795749	PRJNA1192965_P_NODE_4391_length_245_cov_0.895349_g4372_i0	PRJNA1192965	4391	245	0.895349	2.19360505	Insecta	50557	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|2293868663\|ref\|XM_050490340.1\|	171585	g4372	i0	100	1.57142857142857	28	0	11	0	4	31	630	657	PREDICTED: Nymphalis io uncharacterized LOC126770781 (LOC126770781), mRNA	blastn	385	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Nymphalis	Nymphalis io
14349569	14349569	PRJNA1192965_P_NODE_3792_length_248_cov_1.508571_g3773_i0	PRJNA1192965	3792	248	1.508571	3.74125608	Drosophila arizonae	7263	Arthropoda	Arthropoda	459	1.13e-124	NTclustered	gi\|1060230967\|ref\|XM_018007441.1\|	7263	g3773	i0	100	30.758064516129	248	0	100	0	1	248	3918	4165	PREDICTED: Drosophila arizonae teneurin-m (LOC108613756), transcript variant X5, mRNA	blastn	7628	459	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila arizonae
14349575	14349575	PRJNA1192965_P_NODE_4752_length_243_cov_0.905882_g4733_i0	PRJNA1192965	4752	243	0.905882	2.20129326	Ochlerotatus camptorhynchus	644619	Arthropoda	Arthropoda	178	3.4599999999999993e-40	NTclustered	gi\|2730503037\|ref\|XM_065227944.1\|	644619	g4733	i0	86.42	19.8189300411523	162	22	67	0	78	239	152	313	PREDICTED: Ochlerotatus camptorhynchus tubulin alpha-1 chain (LOC135706329), mRNA	blastn	4816	178	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Ochlerotatus	Ochlerotatus camptorhynchus
15070101	15070101	PRJNA1192965_P_NODE_492_length_522_cov_1.639198_g473_i0	PRJNA1192965	492	522	1.639198	8.55661356	root	1	Root_unresolved	Root_unresolved	905	0	NTclustered	gi\|1964807194\|emb\|OC914826.1\|	334625	g473	i0	98.084	656.111111111111	522	7	99	2	2	522	181321	180802	Oppiella nova	blastn	342490	907	0.997794928335171	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
15623282	15623282	PRJNA1192965_P_NODE_1833_length_310_cov_0.974684_g1814_i0	PRJNA1192965	1833	310	0.974684	3.0215204	Armigeres subalbatus	124917	Arthropoda	Arthropoda	195	4.5499999999999995e-45	NTclustered	gi\|2669022462\|ref\|XM_062702690.1\|	124917	g1814	i0	79.443	87.0516129032258	287	49	91	9	2	283	1024	1305	PREDICTED: Armigeres subalbatus ATP synthase subunit beta, mitochondrial-like (LOC134223521), mRNA	blastn	26986	195	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Armigeres	Armigeres subalbatus
18172123	18172123	PRJNA1192965_P_NODE_4155_length_246_cov_0.890173_g4136_i0	PRJNA1192965	4155	246	0.890173	2.18982558	Uranotaenia lowii	190385	Arthropoda	Arthropoda	143	1.28e-29	NTclustered	gi\|2499564437\|ref\|XM_055747144.1\|	190385	g4136	i0	79.048	4.65853658536585	210	42	85	2	38	246	1356	1148	PREDICTED: Uranotaenia lowii transitional endoplasmic reticulum ATPase TER94 (LOC129751562), mRNA	blastn	1146	143	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Uranotaenia	Uranotaenia lowii
20721889	20721889	PRJNA1192965_P_NODE_4917_length_242_cov_0.911243_g4898_i0	PRJNA1192965	4917	242	0.911243	2.20520806	Anopheles darlingi	43151	Arthropoda	Arthropoda	62.1	3.62e-5	NTclustered	gi\|2278014244\|ref\|XM_049686499.1\|	43151	g4898	i0	89.583	9.95454545454546	48	5	20	0	143	190	1413	1460	PREDICTED: Anopheles darlingi basic proline-rich protein-like (LOC125955365), partial mRNA	blastn	2409	62.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Anopheles	Anopheles darlingi
20721891	20721891	PRJNA1192965_P_NODE_657_length_463_cov_1.846154_g638_i0	PRJNA1192965	657	463	1.846154	8.54769302	Timema monikensis	170555	Arthropoda	Arthropoda	58.4	0.001	NTclustered	gi\|1946411097\|emb\|OB793204.1\|	170555	g638	i0	97.059	0.19438444924406	34	1	7	0	288	321	168543	168510	3_Tms_b3v08	blastn	90	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema monikensis
20721893	20721893	PRJNA1192965_P_NODE_917_length_403_cov_1.242424_g898_i0	PRJNA1192965	917	403	1.242424	5.00696872	Drosophila melanogaster	7227	Arthropoda	Arthropoda	52.8	0.039	NTclustered	gi\|364503194\|gb\|AC246503.1\|	7227	g898	i0	100	0.208436724565757	28	0	7	0	163	190	16721	16694	Drosophila melanogaster clone BACR06D22, complete sequence	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
21444327	21444327	PRJNA1192965_P_NODE_5177_length_241_cov_0.916667_g5158_i0	PRJNA1192965	5177	241	0.916667	2.20916747	Drosophila	7215	Arthropoda	Arthropoda	403	5.199999999999998e-108	NTclustered	gi\|21538991\|gb\|AC091222.3\|	7227	g5158	i0	96.721	10.1742738589212	244	5	100	1	1	241	68732	68489	Drosophila melanogaster 3L BAC RP98-11G24 (Roswell Park Cancer Institute Drosophila BAC Library) complete sequence	blastn	2452	407	0.99017199017199	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
23272679	23272679	PRJNA1192965_P_NODE_3279_length_251_cov_0.865169_g3260_i0	PRJNA1192965	3279	251	0.865169	2.17157419	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	52.8	0.023	NTclustered	gi\|2919550840\|emb\|OZ238361.1\|	1002887	g3260	i0	100	0.111553784860558	28	0	11	0	45	72	14100601	14100628	Glaucopsyche melanops genome assembly, chromosome: 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops

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