metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA339266" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA339266" 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
28053694	28053694	PRJNA339266_S_NODE_8185_length_189_cov_1.184211_g8174_i0	PRJNA339266	8185	189	1.184211	2.23815879	Oppia nitens	1686743	Arthropoda	Arthropoda	48.9	1.24e-4	NR	XP_054164415.1	1686743	g8174	i0	52.1	0.761904761904762	48	22	76.2	1	183	40	523	569	XP_054164415.1 kelch-like protein 13 [Oppia nitens]	diamond	144	48.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppia	Oppia nitens
28464364	28464364	PRJNA339266_P_NODE_1126_length_265_cov_5.837719_g1096_i0	PRJNA339266	1126	265	5.837719	15.46995535	Eurytemora carolleeae	1294199	Arthropoda	Arthropoda	58.2	1.86e-7	NR	XP_023319807.1	1294199	g1096	i0	43.9	0.645283018867924	57	32	64.5	0	94	264	539	595	XP_023319807.1 uncharacterized protein LOC111694953 [Eurytemora carolleeae]	diamond	171	58.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Calanoida	Temoridae	Eurytemora	Eurytemora carolleeae
28464371	28464371	PRJNA339266_S_NODE_13426_length_166_cov_3.038760_g13415_i0	PRJNA339266	13426	166	3.03876	5.0443416	Trichogramma brassicae	86971	Arthropoda	Arthropoda	54.7	7.75e-7	NR	CAB0028664.1	86971	g13415	i0	73	2.67469879518072	37	10	66.9	0	3	113	966	1002	CAB0028664.1 unnamed protein product [Trichogramma brassicae]	diamond	444	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Trichogrammatidae	Trichogramma	Trichogramma brassicae
29095869	29095869	PRJNA339266_S_NODE_1268_length_301_cov_2.359848_g1257_i0	PRJNA339266	1268	301	2.359848	7.10314248	Stegodyphus mimosarum	407821	Arthropoda	Arthropoda	71.6	2.85e-12	NR	KFM58914.1	407821	g1257	i0	73.2	0.817275747508306	41	9	38.9	1	201	85	173	213	KFM58914.1 Transposable element Tc1 transposase, partial [Stegodyphus mimosarum]	diamond	246	71.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Eresidae	Stegodyphus	Stegodyphus mimosarum
29979892	29979892	PRJNA339266_P_NODE_6691_length_170_cov_1.000000_g6661_i0	PRJNA339266	6691	170	1	1.7	Anopheles bellator	139047	Arthropoda	Arthropoda	65.9	1.82e-11	NR	XP_058059375.1	139047	g6661	i0	60	1.94117647058824	55	22	97.1	0	3	167	65	119	XP_058059375.1 ADP-ribose glycohydrolase OARD1-like [Anopheles bellator]	diamond	330	65.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Anopheles	Anopheles bellator
31165872	31165872	PRJNA339266_S_NODE_19015_length_152_cov_1.469565_g19004_i0	PRJNA339266	19015	152	1.469565	2.2337388	Trombidiformes	83136	Arthropoda	Arthropoda	75.5	3.03e-14	NR	XP_015781740.1	32264	g19004	i0	94.7	8.25	38	2	75	0	114	1	461	498	XP_015781740.1 polycystic kidney disease 2-like 1 protein isoform X1 [Tetranychus urticae]	diamond	1254	75.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
31450912	31450912	PRJNA339266_S_NODE_15156_length_161_cov_2.137097_g15145_i0	PRJNA339266	15156	161	2.137097	3.44072617	Oppiidae	229795	Arthropoda	Arthropoda	58.5	3.19e-8	NR	XP_054168793.1	1686743	g15145	i0	69.2	2.62732919254658	39	12	72.7	0	44	160	26	64	XP_054168793.1 protein Peter pan-like [Oppia nitens]	diamond	423	58.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppia	Oppia nitens
32729910	32729910	PRJNA339266_S_NODE_19600_length_151_cov_1.026316_g19589_i0	PRJNA339266	19600	151	1.026316	1.54973716	Halotydeus destructor	2874060	Arthropoda	Arthropoda	60.5	5.69e-9	NR	KAI1305279.1	2874060	g19589	i0	57.1	1.88741721854305	49	21	97.4	0	1	147	48	96	KAI1305279.1 Glucan endo-1,3-beta-glucosidase A1 [Halotydeus destructor]	diamond	285	60.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Penthaleidae	Halotydeus	Halotydeus destructor
32887109	32887109	PRJNA339266_S_NODE_16320_length_158_cov_2.214876_g16309_i0	PRJNA339266	16320	158	2.214876	3.49950408	Macrobrachium nipponense	159736	Arthropoda	Arthropoda	89.7	3.23e-19	NR	XP_064080772.1	159736	g16309	i0	78.8	4.93670886075949	52	11	98.7	0	158	3	442	493	XP_064080772.1 endoplasmic reticulum chaperone BiP-like [Macrobrachium nipponense]	diamond	780	89.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Macrobrachium	Macrobrachium nipponense

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