metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA682774" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA682774" 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
3215429	3215429	PRJNA682774_P_NODE_2443_length_292_cov_1.424658_g2414_i0	PRJNA682774	2443	292	1.424658	4.16000136	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	52.8	0.027	NTclustered	gi\|2919550840\|emb\|OZ238361.1\|	1002887	g2414	i0	100	0.0958904109589041	28	0	10	0	153	180	14100628	14100601	Glaucopsyche melanops genome assembly, chromosome: 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops
3726525	3726525	PRJNA682774_P_NODE_3343_length_255_cov_1.362637_g3314_i0	PRJNA682774	3343	255	1.362637	3.47472435	Metazoa	33208	Arthropoda	Arthropoda	60.2	1.38e-4	NTclustered	gi\|2311917340\|ref\|XR_007755209.1\|	95602	g3314	i0	97.222	1.42352941176471	36	0	14	1	149	184	4343	4309	PREDICTED: Eriocheir sinensis uncharacterized LOC127001375 (LOC127001375), transcript variant X4, ncRNA	blastn	363	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis
5768282	5768282	PRJNA682774_P_NODE_3365_length_254_cov_1.723757_g3336_i0	PRJNA682774	3365	254	1.723757	4.37834278	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	84.2	8.18e-12	NTclustered	gi\|15213827\|gb\|AF400217.1\|	7108	g3336	i0	78.169	6.57086614173228	142	23	54	7	1	138	297	160	Spodoptera frugiperda ribosomal protein S20 mRNA, complete cds	blastn	1669	84.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
7043304	7043304	PRJNA682774_P_NODE_2786_length_277_cov_3.887255_g2757_i0	PRJNA682774	2786	277	3.887255	10.76769635	Paracyclopina nana	565004	Arthropoda	Arthropoda	156	1.89e-33	NTclustered	gi\|319738740\|gb\|HQ115582.1\|	565004	g2757	i0	85.811	48.0505415162455	148	19	53	2	63	209	241	95	Paracyclopina nana heat shock protein 90 mRNA, complete cds	blastn	13310	156	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Cyclopoida	Cyclopettidae	Paracyclopina	Paracyclopina nana
8317781	8317781	PRJNA682774_P_NODE_1207_length_394_cov_1.900312_g1178_i0	PRJNA682774	1207	394	1.900312	7.48722928	Polistes canadensis	91411	Arthropoda	Arthropoda	63.9	1.74e-5	NTclustered	gi\|954549845\|ref\|XM_014742781.1\|	91411	g1178	i0	97.368	6.79187817258883	38	0	9	1	109	145	408	445	PREDICTED: Polistes canadensis G protein-coupled receptor kinase 1 (LOC106783861), mRNA	blastn	2676	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Vespidae	Polistes	Polistes canadensis
8317793	8317793	PRJNA682774_P_NODE_2227_length_304_cov_1.047619_g2198_i0	PRJNA682774	2227	304	1.047619	3.18476176	Aphidius gifuensis	684658	Arthropoda	Arthropoda	226	1.58e-54	NTclustered	gi\|2106734177\|ref\|XM_044149429.1\|	684658	g2198	i0	84.889	74.7236842105263	225	32	74	2	10	233	426	203	PREDICTED: Aphidius gifuensis actin-5C (LOC122850281), transcript variant X2, mRNA	blastn	22716	226	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Aphidius	Aphidius gifuensis
9593282	9593282	PRJNA682774_P_NODE_4528_length_247_cov_0.896552_g4499_i0	PRJNA682774	4528	247	0.896552	2.21448344	Tigriopus californicus	6832	Arthropoda	Arthropoda	63.9	1.03e-5	NTclustered	gi\|2571315341\|ref\|XM_059222493.1\|	6832	g4499	i0	97.297	2.25101214574899	37	1	15	0	77	113	717	753	PREDICTED: Tigriopus californicus DNA-directed RNA polymerase II subunit RPB1-like (LOC131876947), mRNA	blastn	556	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
10868655	10868655	PRJNA682774_P_NODE_4469_length_247_cov_0.896552_g4440_i0	PRJNA682774	4469	247	0.896552	2.21448344	Ceutorhynchus obstrictus	307131	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|2918376583\|emb\|OZ238013.1\|	307131	g4440	i0	100	0.793522267206478	28	0	11	0	96	123	17885960	17885987	Ceutorhynchus obstrictus genome assembly, chromosome: 4	blastn	196	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Ceutorhynchus	Ceutorhynchus obstrictus
11378275	11378275	PRJNA682774_P_NODE_3309_length_256_cov_1.459016_g3280_i0	PRJNA682774	3309	256	1.459016	3.73508096	root	1	Root_unresolved	Root_unresolved	473	4.189999999999999e-129	NTclustered	gi\|1964807332\|emb\|OC914829.1\|	334625	g3280	i0	100	2	256	0	100	0	1	256	152145	152400	Oppiella nova	blastn	512	473	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
12144046	12144046	PRJNA682774_P_NODE_4910_length_245_cov_0.906977_g4881_i0	PRJNA682774	4910	245	0.906977	2.22209365	Timema genevievae	629358	Arthropoda	Arthropoda	60.2	1.32e-4	NTclustered	gi\|1964501331\|emb\|OE840096.1\|	629358	g4881	i0	100	10.4775510204082	32	0	13	0	184	215	98832	98801	5_Tge_b3v08	blastn	2567	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema genevievae
14693597	14693597	PRJNA682774_P_NODE_3352_length_255_cov_0.978022_g3323_i0	PRJNA682774	3352	255	0.978022	2.4939561	Pseudodiaptomus poplesia	213370	Arthropoda	Arthropoda	95.3	3.8e-15	NTclustered	gi\|961376263\|gb\|KT755042.1\|	213370	g3323	i0	88.608	11.4705882352941	79	7	31	2	15	92	53	130	Pseudodiaptomus poplesia clone PPON11-3(2) hypothetical protein mRNA, complete cds	blastn	2925	95.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Calanoida	Pseudodiaptomidae	Pseudodiaptomus	Pseudodiaptomus poplesia
15967347	15967347	PRJNA682774_P_NODE_1133_length_407_cov_1.739521_g1104_i0	PRJNA682774	1133	407	1.739521	7.07985047	Drosophila takahashii	29030	Arthropoda	Arthropoda	200	1.32e-46	NTclustered	gi\|2866458318\|ref\|XR_001770505.3\|	29030	g1104	i0	80.142	50.3415233415233	282	45	68	11	6	282	537	262	PREDICTED: Drosophila takahashii eukaryotic translation initiation factor 4A (eIF4A), transcript variant X3, misc_RNA	blastn	20489	200	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila takahashii
18516736	18516736	PRJNA682774_P_NODE_3355_length_254_cov_4.292818_g3326_i0	PRJNA682774	3355	254	4.292818	10.90375772	Chelonus insularis	460826	Arthropoda	Arthropoda	152	2.2099999999999998e-32	NTclustered	gi\|1860469933\|ref\|XM_035078699.1\|	460826	g3326	i0	85.135	44.8346456692913	148	22	58	0	48	195	447	300	PREDICTED: Chelonus insularis histone H3 (LOC118064232), mRNA	blastn	11388	152	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Chelonus	Chelonus insularis
18516751	18516751	PRJNA682774_P_NODE_4195_length_249_cov_0.886364_g4166_i0	PRJNA682774	4195	249	0.886364	2.20704636	Propertius dejongi	2839332	Arthropoda	Arthropoda	156	1.67e-33	NTclustered	gi\|2567321520\|gb\|OK804586.1\|	2839332	g4166	i0	80.392	65.1204819277108	204	40	82	0	46	249	778	981	Propertius dejongi voucher MGCL:LEP-61229 heat shock cognate protein gene, partial cds	blastn	16215	156	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Hesperiidae	Propertius	Propertius dejongi
20301157	20301157	PRJNA682774_P_NODE_3256_length_258_cov_1.654054_g3227_i0	PRJNA682774	3256	258	1.654054	4.26745932	Arthropoda	6656	Arthropoda	Arthropoda	165	2.89e-36	NTclustered	gi\|2428879746\|ref\|XM_053011734.1\|	68878	g3227	i0	83.815	7.14728682170543	173	28	67	0	7	179	317	145	PREDICTED: Anopheles cruzii 40S ribosomal protein S3 (LOC128273708), mRNA	blastn	1844	165	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Anopheles	Anopheles cruzii
22341935	22341935	PRJNA682774_P_NODE_358_length_729_cov_2.300305_g332_i0	PRJNA682774	358	729	2.300305	16.76922345	Uranotaenia lowii	190385	Arthropoda	Arthropoda	161	1.1599999999999999e-34	NTclustered	gi\|2499533873\|ref\|XM_055758468.1\|	190385	g332	i0	79.565	16.7887517146776	230	43	31	3	495	722	435	208	PREDICTED: Uranotaenia lowii 60S ribosomal protein L30 (LOC129760803), mRNA	blastn	12239	161	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Uranotaenia	Uranotaenia lowii
23617522	23617522	PRJNA682774_P_NODE_2119_length_310_cov_1.312236_g2090_i0	PRJNA682774	2119	310	1.312236	4.0679316	Samia ricini	63990	Arthropoda	Arthropoda	52.8	0.029	NTclustered	gi\|2883229819\|dbj\|AP038899.1\|	63990	g2090	i0	86	0.161290322580645	50	5	15	2	173	220	2880948	2880899	Samia ricini White GU1 DNA, chromosome 04, complete sequence	blastn	50	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Saturniidae	Samia	Samia ricini
24126685	24126685	PRJNA682774_P_NODE_4439_length_247_cov_0.896552_g4410_i0	PRJNA682774	4439	247	0.896552	2.21448344	Diorhabda	217246	Arthropoda	Arthropoda	189	1.6299999999999999e-43	NTclustered	gi\|2529469519\|ref\|XM_057814491.1\|	1163345	g4410	i0	85.635	84.4898785425101	181	24	73	2	24	203	926	747	PREDICTED: Diorhabda carinulata ADP-ribosylation factor 1 (LOC130902386), transcript variant X1, mRNA	blastn	20869	189	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Diorhabda	Diorhabda carinulata

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