metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA1069776" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA1069776" 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
26869295	26869295	PRJNA1069776_S_NODE_51341_length_154_cov_2.162162_g51027_i0	PRJNA1069776	51341	154	2.162162	3.32972948	Insecta	50557	Arthropoda	Arthropoda	47.8	1.91e-4	NR	XP_048510256.1	37344	g51027	i0	75.8	6.48701298701299	33	8	64.3	0	2	100	694	726	XP_048510256.1 zinc finger MYM-type protein 1-like [Athalia rosae]	diamond	999	48.1	0.993762993762994	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Athaliidae	Athalia	Athalia rosae
27003928	27003928	PRJNA1069776_S_NODE_47402_length_160_cov_2.452991_g47088_i0	PRJNA1069776	47402	160	2.452991	3.9247856	Penaeus vannamei	6689	Arthropoda	Arthropoda	90.9	4.33e-21	NR	ADD10091.1	6689	g47088	i0	93.9	75.31875	49	3	91.9	0	148	2	108	156	ADD10091.1 apocytochrome-b, partial [Penaeus vannamei]	diamond	12051	90.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
27288577	27288577	PRJNA1069776_S_NODE_36723_length_180_cov_2.452555_g36409_i0	PRJNA1069776	36723	180	2.452555	4.414599	Blattella germanica	6973	Arthropoda	Arthropoda	43.9	0.00655	NR	PSN38363.1	6973	g36409	i0	78.3	1.96666666666667	23	5	38.3	0	97	165	146	168	PSN38363.1 Kinesin heavy chain [Blattella germanica]	diamond	354	43.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blattellidae	Blattella	Blattella germanica
27627751	27627751	PRJNA1069776_S_NODE_35344_length_183_cov_2.742857_g35030_i0	PRJNA1069776	35344	183	2.742857	5.01942831	Aphididae	27482	Arthropoda	Arthropoda	63.5	7.16e-10	NR	XP_026819627.1	43146	g35030	i0	48.3	5.62295081967213	58	30	95.1	0	9	182	284	341	XP_026819627.1 zinc finger BED domain-containing protein 5-like [Rhopalosiphum maidis]	diamond	1029	63.9	0.993740219092332	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Rhopalosiphum	Rhopalosiphum maidis
27699506	27699506	PRJNA1069776_S_NODE_29744_length_197_cov_12.889610_g29430_i0	PRJNA1069776	29744	197	12.88961	25.3925317	Ceratitis capitata	7213	Arthropoda	Arthropoda	104	4.13e-24	NR	CAD7015489.1	7213	g29430	i0	98.1	2.40609137055838	53	1	80.7	0	9	167	693	745	CAD7015489.1 unnamed protein product [Ceratitis capitata]	diamond	474	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Ceratitis	Ceratitis capitata
28543467	28543467	PRJNA1069776_S_NODE_30367_length_196_cov_2.196078_g30053_i0	PRJNA1069776	30367	196	2.196078	4.30431288	Metazoa	33208	Arthropoda	Arthropoda	60.8	8.26e-9	NR	XP_042213104.1	6706	g30053	i0	66.7	4.31632653061224	36	12	55.1	0	196	89	67	102	XP_042213104.1 zinc finger MYM-type protein 1-like [Homarus americanus]	diamond	846	60.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Nephropidae	Homarus	Homarus americanus
29783028	29783028	PRJNA1069776_S_NODE_25091_length_213_cov_3.211765_g24777_i0	PRJNA1069776	25091	213	3.211765	6.84105945	Petrolisthes cinctipes	88211	Arthropoda	Arthropoda	40.4	0.0448	NR	KAK3891238.1	88211	g24777	i0	40	0.774647887323944	55	29	74.6	2	169	11	32	84	KAK3891238.1 hypothetical protein Pcinc_004878 [Petrolisthes cinctipes]	diamond	165	40.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Porcellanidae	Petrolisthes	Petrolisthes cinctipes
30067282	30067282	PRJNA1069776_S_NODE_14832_length_265_cov_24.495495_g14518_i0	PRJNA1069776	14832	265	24.495495	64.91306175	Ceratitis capitata	7213	Arthropoda	Arthropoda	127	1.2199999999999999e-32	NR	CAD7015492.1	7213	g14518	i0	89.9	3.11320754716981	69	7	78.1	0	264	58	225	293	CAD7015492.1 unnamed protein product [Ceratitis capitata]	diamond	825	127	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Ceratitis	Ceratitis capitata
30532795	30532795	PRJNA1069776_S_NODE_26033_length_209_cov_7.319277_g25719_i0	PRJNA1069776	26033	209	7.319277	15.29728893	Lepidoptera	7088	Arthropoda	Arthropoda	42	0.0454	NR	CAG5047623.1	110799	g25719	i0	34.7	4.92344497607655	49	32	70.3	0	165	19	382	430	CAG5047623.1 unnamed protein product [Parnassius apollo]	diamond	1029	42.4	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Parnassius	Parnassius apollo
30541259	30541259	PRJNA1069776_S_NODE_32973_length_189_cov_2.630137_g32659_i0	PRJNA1069776	32973	189	2.630137	4.97095893	Vespula squamosa	30214	Arthropoda	Arthropoda	46.6	6.75e-4	NR	KAL2733913.1	30214	g32659	i0	35.8	0.841269841269841	53	31	84.1	1	185	27	114	163	KAL2733913.1 hypothetical protein V1478_003611, partial [Vespula squamosa]	diamond	159	46.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Vespidae	Vespula	Vespula squamosa
30762541	30762541	PRJNA1069776_S_NODE_26234_length_209_cov_2.313253_g25920_i0	PRJNA1069776	26234	209	2.313253	4.83469877	Palaemon carinicauda	392227	Arthropoda	Arthropoda	42	0.0442	NR	XP_068208538.1	392227	g25920	i0	44.7	0.674641148325359	47	26	67.5	0	147	7	59	105	XP_068208538.1 uncharacterized protein [Palaemon carinicauda]	diamond	141	42	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Palaemon	Palaemon carinicauda
31670726	31670726	PRJNA1069776_S_NODE_26157_length_209_cov_3.180723_g25843_i0	PRJNA1069776	26157	209	3.180723	6.64771107	Arthropoda	6656	Arthropoda	Arthropoda	55.8	5.71e-7	NR	KAK4025200.1	35525	g25843	i0	72.5	18.9473684210526	40	11	57.4	0	41	160	172	211	KAK4025200.1 hypothetical protein OUZ56_014274 [Daphnia magna]	diamond	3960	56.2	0.99288256227758	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna
31868909	31868909	PRJNA1069776_S_NODE_13257_length_278_cov_2.451064_g12943_i0	PRJNA1069776	13257	278	2.451064	6.81395792	Aethina tumida	116153	Arthropoda	Arthropoda	95.1	2.0499999999999999e-23	NR	XP_019865667.1	116153	g12943	i0	78.9	1.86690647482014	57	12	61.5	0	171	1	1	57	XP_019865667.1 ATP synthase subunit e, mitochondrial [Aethina tumida]	diamond	519	95.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Nitidulidae	Aethina	Aethina tumida

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