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

19 rows where analysis = "blastn", bioproject = "PRJNA554794" 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
2399000	2399000	PRJNA554794_P_NODE_24522_length_161_cov_1.053571_g20593_i0	PRJNA554794	24522	161	1.053571	1.69624931	Lucilia	7374	Arthropoda	Arthropoda	104	3.64e-18	NTclustered	gi\|2203009945\|ref\|XM_023439305.2\|	7375	g20593	i0	81.343	4.3416149068323	134	19	81	5	30	160	413	283	PREDICTED: Lucilia cuprina 40S ribosomal protein S3 (LOC111678069), mRNA	blastn	699	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Calliphoridae	Lucilia	Lucilia cuprina
4348019	4348019	PRJNA554794_P_NODE_19964_length_202_cov_1.320261_g16035_i0	PRJNA554794	19964	202	1.320261	2.66692722	Artemia franciscana	6661	Arthropoda	Arthropoda	296	7.36e-76	NTclustered	gi\|2743025003\|ref\|XR_010621486.1\|	6661	g16035	i0	93.069	21.1980198019802	202	14	100	0	1	202	489	690	PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA	blastn	4282	296	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
5624774	5624774	PRJNA554794_P_NODE_21765_length_176_cov_1.629921_g17836_i0	PRJNA554794	21765	176	1.629921	2.86866096	Tigriopus californicus	6832	Arthropoda	Arthropoda	69.4	1.47e-7	NTclustered	gi\|2571333329\|ref\|XM_059228596.1\|	6832	g17836	i0	90.385	1.47727272727273	52	5	30	0	115	166	1009	958	PREDICTED: Tigriopus californicus uncharacterized LOC131881664 (LOC131881664), transcript variant X2, mRNA	blastn	260	69.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
6898827	6898827	PRJNA554794_P_NODE_21066_length_185_cov_1.139706_g17137_i0	PRJNA554794	21066	185	1.139706	2.1084561	Orussus abietinus	222816	Arthropoda	Arthropoda	193	8.919999999999999e-45	NTclustered	gi\|1317995991\|ref\|XM_012424317.2\|	222816	g17137	i0	85.714	92.6162162162162	182	26	98	0	4	185	479	298	PREDICTED: Orussus abietinus dynein light chain 2, cytoplasmic (LOC105699386), mRNA	blastn	17134	193	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Orussidae	Orussus	Orussus abietinus
8173695	8173695	PRJNA554794_P_NODE_22847_length_166_cov_0.871795_g18918_i0	PRJNA554794	22847	166	0.871795	1.4471797	Pieris napi	78633	Arthropoda	Arthropoda	63.9	6.42e-6	NTclustered	gi\|2220890286\|ref\|XM_047666315.1\|	78633	g18918	i0	95.122	4.95783132530121	41	0	24	1	15	53	1381	1421	PREDICTED: Pieris napi putative per-hexamer repeat protein 5 (LOC125061103), transcript variant X3, mRNA	blastn	823	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pieridae	Pieris	Pieris napi
9449357	9449357	PRJNA554794_P_NODE_9748_length_416_cov_1.032698_g5892_i0	PRJNA554794	9748	416	1.032698	4.29602368	Tetranychus urticae	32264	Arthropoda	Arthropoda	63.9	1.85e-5	NTclustered	gi\|1390648244\|ref\|XM_015930162.2\|	32264	g5892	i0	89.796	1.13701923076923	49	5	12	0	48	96	451	499	PREDICTED: Tetranychus urticae cathepsin L1 (LOC107363003), mRNA	blastn	473	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
11999833	11999833	PRJNA554794_P_NODE_15470_length_210_cov_1.322981_g11541_i0	PRJNA554794	15470	210	1.322981	2.7782601	Drosophila obscura	7282	Arthropoda	Arthropoda	148	2.2799999999999997e-31	NTclustered	gi\|2038062354\|ref\|XM_022363539.2\|	7282	g11541	i0	90.909	46.1571428571429	110	10	52	0	77	186	2519	2410	PREDICTED: Drosophila obscura eukaryotic translation elongation factor 2 (LOC111071977), mRNA	blastn	9693	148	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila obscura
17098473	17098473	PRJNA554794_P_NODE_12394_length_277_cov_1.070175_g8465_i0	PRJNA554794	12394	277	1.070175	2.96438475	Hermetia illucens	343691	Arthropoda	Arthropoda	172	1.87e-38	NTclustered	gi\|1941237557\|ref\|XM_038058799.1\|	343691	g8465	i0	81.951	4.17328519855596	205	35	74	2	1	204	398	195	PREDICTED: Hermetia illucens 40S ribosomal protein S23 (LOC119653793), mRNA	blastn	1156	172	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Stratiomyidae	Hermetia	Hermetia illucens
17098532	17098532	PRJNA554794_P_NODE_24534_length_161_cov_0.919643_g20605_i0	PRJNA554794	24534	161	0.919643	1.48062523	Macrosteles quadrilineatus	74068	Arthropoda	Arthropoda	100	4.71e-17	NTclustered	gi\|2463282423\|ref\|XM_054432459.1\|	74068	g20605	i0	93.939	36.7701863354037	66	4	41	0	27	92	1603	1538	PREDICTED: Macrosteles quadrilineatus heat shock 70 kDa protein cognate 4 (LOC129004070), transcript variant X3, mRNA	blastn	5920	100	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Macrosteles	Macrosteles quadrilineatus
18372691	18372691	PRJNA554794_P_NODE_23795_length_163_cov_0.894737_g19866_i0	PRJNA554794	23795	163	0.894737	1.45842131	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	285	1.23e-72	NTclustered	gi\|78097483\|gb\|AC167561.3\|	7176	g19866	i0	98.16	42.3496932515337	163	3	100	0	1	163	53321	53159	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940117D9, complete sequence	blastn	6903	285	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
19647297	19647297	PRJNA554794_P_NODE_22996_length_166_cov_0.863248_g19067_i0	PRJNA554794	22996	166	0.863248	1.43299168	Artemia franciscana	6661	Arthropoda	Arthropoda	193	7.85e-45	NTclustered	gi\|2743025299\|ref\|XM_065727981.1\|	6661	g19067	i0	89.61	0.927710843373494	154	13	92	2	1	152	3729	3881	PREDICTED: Artemia franciscana piwi-like protein 1 (LOC136043066), transcript variant X1, mRNA	blastn	154	193	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
20923059	20923059	PRJNA554794_P_NODE_14397_length_221_cov_2.406977_g10468_i0	PRJNA554794	14397	221	2.406977	5.31941917	Helicoverpa assulta	52344	Arthropoda	Arthropoda	52.8	0.02	NTclustered	gi\|2636206755\|emb\|OY979781.1\|	52344	g10468	i0	100	0.126696832579186	28	0	13	0	129	156	8315215	8315242	Helicoverpa assulta genome assembly, chromosome: 7	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Helicoverpa	Helicoverpa assulta
20923093	20923093	PRJNA554794_P_NODE_20817_length_188_cov_2.446043_g16888_i0	PRJNA554794	20817	188	2.446043	4.59856084	Dyschiriodes sp. 63_EN	1055885	Arthropoda	Arthropoda	93.5	9.49e-15	NTclustered	gi\|340807426\|gb\|JF778824.1\|	1055885	g16888	i0	85.87	33.3244680851064	92	7	47	5	15	103	929	841	Dyschiriodes sp. 63_EN large subunit ribosomal RNA gene, partial sequence	blastn	6265	93.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Carabidae	Dyschiriodes	Dyschiriodes sp. 63_EN
20923095	20923095	PRJNA554794_P_NODE_21357_length_181_cov_1.606061_g17428_i0	PRJNA554794	21357	181	1.606061	2.90697041	Calybites phasianipennella	796989	Arthropoda	Arthropoda	141	3.19e-29	NTclustered	gi\|1049595438\|dbj\|LC127980.1\|	796989	g17428	i0	81.143	60.1823204419889	175	33	97	0	1	175	324	498	Calybites phasianipennella gene for elongation factor-1 alpha, partial cds, isolate: RN26	blastn	10893	141	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Gracillariidae	Calybites	Calybites phasianipennella
21525595	21525595	PRJNA554794_P_NODE_22517_length_167_cov_5.940678_g18588_i0	PRJNA554794	22517	167	5.940678	9.92093226	root	1	Root_unresolved	Root_unresolved	60.2	8.37e-5	NTclustered	gi\|2864127362\|ref\|XM_070117547.1\|	6689	g18588	i0	100	1.91017964071856	32	0	19	0	110	141	11	42	PREDICTED: Penaeus vannamei HECT, UBA and WWE domain containing E3 ubiquitin protein ligase 1 (HUWE1), transcript variant X6, mRNA	blastn	319	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
21525609	21525609	PRJNA554794_P_NODE_23437_length_164_cov_0.973913_g19508_i0	PRJNA554794	23437	164	0.973913	1.59721732	Anastrepha	28585	Arthropoda	Arthropoda	73.1	1.05e-8	NTclustered	gi\|2453225557\|ref\|XM_054106513.1\|	28586	g19508	i0	88.333	1.6280487804878	60	7	37	0	12	71	444	503	PREDICTED: Anastrepha ludens 40S ribosomal protein S16 (LOC128866044), mRNA	blastn	267	73.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Anastrepha	Anastrepha ludens
22197803	22197803	PRJNA554794_P_NODE_20898_length_187_cov_1.260870_g16969_i0	PRJNA554794	20898	187	1.26087	2.3578269	Bombyx mori	7091	Arthropoda	Arthropoda	60.2	9.57e-5	NTclustered	gi\|2919985619\|emb\|OZ208592.1\|	7091	g16969	i0	97.143	0.18716577540107	35	1	19	0	34	68	8289332	8289298	Bombyx mori genome assembly, chromosome: 14	blastn	35	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
23473379	23473379	PRJNA554794_P_NODE_22039_length_173_cov_1.225806_g18110_i0	PRJNA554794	22039	173	1.225806	2.12064438	Leguminivora glycinivorella	1035111	Arthropoda	Arthropoda	128	2.35e-25	NTclustered	gi\|2237301641\|ref\|XM_048145146.1\|	1035111	g18110	i0	85.484	4.15028901734104	124	16	71	2	47	169	392	514	PREDICTED: Leguminivora glycinivorella 60S ribosomal protein L7 (LOC125237910), mRNA	blastn	718	128	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Leguminivora	Leguminivora glycinivorella
24747112	24747112	PRJNA554794_P_NODE_12320_length_279_cov_1.030435_g8391_i0	PRJNA554794	12320	279	1.030435	2.87491365	Ornithodoros turicata	34597	Arthropoda	Arthropoda	183	8.73e-42	NTclustered	gi\|2720960512\|ref\|XM_064625776.1\|	34597	g8391	i0	84.127	23.6200716845878	189	30	68	0	39	227	146	334	PREDICTED: Ornithodoros turicata V-type proton ATPase 16 kDa proteolipid subunit c-like (LOC135394791), mRNA	blastn	6590	183	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Argasidae	Ornithodoros	Ornithodoros turicata

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