metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA982106" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA982106" 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
4791730	4791730	PRJNA982106_P_NODE_14144_length_290_cov_1.092166_g13904_i0	PRJNA982106	14144	290	1.092166	3.1672814	Rhipicephalus microplus	6941	Arthropoda	Arthropoda	190	1.27e-53	NR	KAL3221900.1	6941	g13904	i0	97.9	0.993103448275862	96	2	99.3	0	2	289	1909	2004	KAL3221900.1 hypothetical protein MRX96_029108 [Rhipicephalus microplus]	diamond	288	190	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
9892061	9892061	PRJNA982106_P_NODE_29228_length_244_cov_0.900585_g28988_i0	PRJNA982106	29228	244	0.900585	2.1974274	Blattodea	85823	Arthropoda	Arthropoda	114	1.3e-27	NR	PSN31704.1	6973	g28988	i0	63	7.9672131147541	81	30	99.6	0	244	2	316	396	PSN31704.1 hypothetical protein C0J52_23621, partial [Blattella germanica]	diamond	1944	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blattellidae	Blattella	Blattella germanica
26804715	26804715	PRJNA982106_P_NODE_32341_length_241_cov_0.916667_g32101_i0	PRJNA982106	32341	241	0.916667	2.20916747	Zophobas morio	2755281	Arthropoda	Arthropoda	114	1.78e-27	NR	XP_063933903.1	2755281	g32101	i0	66.7	3.06224066390041	81	26	99.6	1	240	1	1274	1354	XP_063933903.1 acetyl-CoA carboxylase 2-like isoform X1 [Zophobas morio]	diamond	738	114	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Zophobas	Zophobas morio
27626792	27626792	PRJNA982106_P_NODE_5784_length_391_cov_1.128931_g5544_i0	PRJNA982106	5784	391	1.128931	4.41412021	Rhipicephalus microplus	6941	Arthropoda	Arthropoda	159	5.089999999999999e-48	NR	KAL3219571.1	6941	g5544	i0	91.4	0.713554987212276	93	8	71.4	0	378	100	1	93	KAL3219571.1 hypothetical protein MRX96_030329 [Rhipicephalus microplus]	diamond	279	159	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
29773473	29773473	PRJNA982106_P_NODE_14691_length_287_cov_0.855140_g14451_i0	PRJNA982106	14691	287	0.85514	2.4542518	Lepeophtheirus salmonis	72036	Arthropoda	Arthropoda	66.2	3.58e-11	NR	ACO12385.1	72036	g14451	i0	63.5	3.26132404181185	52	19	54.4	0	262	107	43	94	ACO12385.1 60S ribosomal protein L24 [Lepeophtheirus salmonis]	diamond	936	66.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Siphonostomatoida	Caligidae	Lepeophtheirus	Lepeophtheirus salmonis
29994902	29994902	PRJNA982106_P_NODE_4271_length_435_cov_1.140884_g4032_i0	PRJNA982106	4271	435	1.140884	4.9628454	Helicoverpa zea	7113	Arthropoda	Arthropoda	130	1.36e-33	NR	XP_047024313.1	7113	g4032	i0	46.7	1.03448275862069	150	69	99.3	4	3	434	117	261	XP_047024313.1 cathepsin B-like [Helicoverpa zea]	diamond	450	130	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Helicoverpa	Helicoverpa zea
30184264	30184264	PRJNA982106_P_NODE_32992_length_236_cov_3.447853_g32752_i0	PRJNA982106	32992	236	3.447853	8.13693308	Anthophora plagiata	597819	Arthropoda	Arthropoda	43.1	0.0239	NR	CAK9813121.1	597819	g32752	i0	48.6	2.22457627118644	35	18	44.5	0	176	72	222	256	CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata]	diamond	525	43.5	0.990804597701149	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Anthophora	Anthophora plagiata
31701400	31701400	PRJNA982106_P_NODE_18837_length_260_cov_1.433155_g18597_i0	PRJNA982106	18837	260	1.433155	3.726203	Zophobas morio	2755281	Arthropoda	Arthropoda	92.8	1.12e-19	NR	XP_063901660.1	2755281	g18597	i0	57.1	0.969230769230769	84	35	96.9	1	258	7	678	760	XP_063901660.1 protein kinase C delta type-like isoform X2 [Zophobas morio]	diamond	252	92.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Zophobas	Zophobas morio

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