metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1082072" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1082072" 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
193174	193174	PRJNA1082072_P_NODE_141_length_785_cov_3.985955_g48_i1	PRJNA1082072	141	785	3.985955	31.28974675	Pachyrhinus yasumatsui	2071596	Arthropoda	Arthropoda	518	6.46e-142	NTclustered	gi\|2284955655\|gb\|OK105108.1\|	2071596	g48	i1	81.69	78.5312101910828	639	101	80	13	143	773	631	1	Pachyrhinus yasumatsui elongation factor 1-alpha mRNA, complete cds	blastn	61647	518	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Pachyrhinus	Pachyrhinus yasumatsui
2743895	2743895	PRJNA1082072_P_NODE_1203_length_316_cov_0.868313_g1196_i0	PRJNA1082072	1203	316	0.868313	2.74386908	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	52.8	0.03	NTclustered	gi\|2919550840\|emb\|OZ238361.1\|	1002887	g1196	i0	100	0.0886075949367089	28	0	9	0	244	271	14100628	14100601	Glaucopsyche melanops genome assembly, chromosome: 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops
2743903	2743903	PRJNA1082072_P_NODE_2123_length_251_cov_0.865169_g2116_i0	PRJNA1082072	2123	251	0.865169	2.17157419	Apis cerana	7461	Arthropoda	Arthropoda	54.7	0.006	NTclustered	gi\|2644540352\|ref\|XM_062077260.1\|	7461	g2116	i0	100	0.685258964143426	29	0	12	0	168	196	3722	3750	PREDICTED: Apis cerana rho-associated protein kinase 1 (LOC107999428), transcript variant X2, mRNA	blastn	172	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Apis	Apis cerana
3567846	3567846	PRJNA1082072_P_NODE_2963_length_241_cov_0.916667_g2956_i0	PRJNA1082072	2963	241	0.916667	2.20916747	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	4.66e-4	NTclustered	gi\|1928099498\|ref\|XM_037182450.1\|	38358	g2956	i0	100	0.385892116182573	31	0	13	0	194	224	833	803	PREDICTED: Bradysia coprophila facilitated trehalose transporter Tret1 (LOC119075876), transcript variant X2, mRNA	blastn	93	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia coprophila
10396504	10396504	PRJNA1082072_P_NODE_949_length_346_cov_1.322344_g942_i0	PRJNA1082072	949	346	1.322344	4.57531024	Contarinia nasturtii	265458	Arthropoda	Arthropoda	268	2.99e-67	NTclustered	gi\|1779648040\|ref\|XM_031774719.1\|	265458	g942	i0	82.109	8.91040462427746	313	56	90	0	26	338	222	534	PREDICTED: Contarinia nasturtii 40S ribosomal protein S23 (LOC116345403), mRNA	blastn	3083	268	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Cecidomyiidae	Contarinia	Contarinia nasturtii
12946918	12946918	PRJNA1082072_P_NODE_371_length_494_cov_1.323040_g364_i0	PRJNA1082072	371	494	1.32304	6.5358176	Tetranychus urticae	32264	Arthropoda	Arthropoda	298	5.61e-76	NTclustered	gi\|1390650316\|ref\|XM_015931159.2\|	32264	g364	i0	78.714	52.5728744939271	451	92	91	4	1	449	1345	1793	PREDICTED: Tetranychus urticae heat shock cognate 71 kDa protein (LOC107363888), mRNA	blastn	25971	298	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
14221926	14221926	PRJNA1082072_P_NODE_192_length_663_cov_2.977966_g185_i0	PRJNA1082072	192	663	2.977966	19.74391458	Oppiella nova	334625	Arthropoda	Arthropoda	54.7	0.018	NTclustered	gi\|1962580772\|emb\|OC914909.1\|	334625	g185	i0	100	0.0437405731523379	29	0	4	0	602	630	7612	7584	Oppiella nova	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
16770153	16770153	PRJNA1082072_P_NODE_2774_length_243_cov_0.905882_g2767_i0	PRJNA1082072	2774	243	0.905882	2.20129326	Limulus polyphemus	6850	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|1238878208\|ref\|XM_013928808.2\|	6850	g2767	i0	100	0.11522633744856	28	0	12	0	55	82	1779	1806	PREDICTED: Limulus polyphemus palmitoyltransferase ZDHHC23-like (LOC106468386), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Merostomata	Xiphosura	Limulidae	Limulus	Limulus polyphemus
23145362	23145362	PRJNA1082072_P_NODE_2139_length_251_cov_0.865169_g2132_i0	PRJNA1082072	2139	251	0.865169	2.17157419	Malaya genurostris	325434	Arthropoda	Arthropoda	60.2	1.36e-4	NTclustered	gi\|2557305120\|ref\|XM_058599925.1\|	325434	g2132	i0	97.222	0.143426294820717	36	0	14	1	1	35	110	145	PREDICTED: Malaya genurostris dentin sialophosphoprotein-like (LOC131433109), partial mRNA	blastn	36	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Malaya	Malaya genurostris

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