metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA773247" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA773247" 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
21151646	21151646	PRJNA773247_P_NODE_4717_length_836_cov_2.529489_g4644_i0	PRJNA773247	4717	836	2.529489	21.14652804	Metazoa	33208	Arthropoda	Arthropoda	510	2.649999999999999e-176	NR	CAI6351449.1	13131	g4644	i0	91.3	32.9569377990431	277	24	99.4	0	5	835	150	426	CAI6351449.1 unnamed protein product [Macrosiphum euphorbiae]	diamond	27552	510	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Macrosiphum	Macrosiphum euphorbiae
28758610	28758610	PRJNA773247_P_NODE_24507_length_284_cov_1.412322_g24423_i0	PRJNA773247	24507	284	1.412322	4.01099448	Schistocerca gregaria	7010	Arthropoda	Arthropoda	69.3	2.76e-11	NR	XP_049849189.1	7010	g24423	i0	38.3	1.97535211267606	94	58	99.3	0	2	283	278	371	XP_049849189.1 general transcription factor 3C polypeptide 3-like [Schistocerca gregaria]	diamond	561	69.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria
29484612	29484612	PRJNA773247_P_NODE_9310_length_522_cov_2.126949_g9227_i0	PRJNA773247	9310	522	2.126949	11.10267378	Daphnia pulex	6669	Arthropoda	Arthropoda	45.4	0.0414	NR	XP_046460839.1	6669	g9227	i0	34.2	0.419540229885057	73	48	42	0	219	1	45	117	XP_046460839.1 serine/arginine-rich splicing factor 7-like [Daphnia pulex]	diamond	219	45.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
30242997	30242997	PRJNA773247_P_NODE_16392_length_362_cov_7.238754_g16308_i0	PRJNA773247	16392	362	7.238754	26.20428948	Rhynchophorus ferrugineus	354439	Arthropoda	Arthropoda	47	0.00471	NR	KAF7287454.1	354439	g16308	i0	35.3	0.56353591160221	68	44	56.4	0	338	135	970	1037	KAF7287454.1 hypothetical protein GWI33_001423 [Rhynchophorus ferrugineus]	diamond	204	47	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Rhynchophorus	Rhynchophorus ferrugineus
31285518	31285518	PRJNA773247_P_NODE_16355_length_363_cov_2.148276_g16271_i0	PRJNA773247	16355	363	2.148276	7.79824188	Meganyctiphanes norvegica	48144	Arthropoda	Arthropoda	49.7	5.57e-4	NR	CAL4066214.1	48144	g16271	i0	42.9	2.90082644628099	49	26	40.5	1	308	162	800	846	CAL4066214.1 unnamed protein product, partial [Meganyctiphanes norvegica]	diamond	1053	49.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Euphausiacea	Euphausiidae	Meganyctiphanes	Meganyctiphanes norvegica
31349020	31349020	PRJNA773247_P_NODE_19836_length_322_cov_6.164659_g19752_i0	PRJNA773247	19836	322	6.164659	19.85020198	Dermacentor andersoni	34620	Arthropoda	Arthropoda	45.1	0.00563	NR	XP_050030331.1	34620	g19752	i0	90	0.186335403726708	20	2	18.6	0	180	239	21	40	XP_050030331.1 ubiquitin-conjugating enzyme E2-17 kDa-like [Dermacentor andersoni]	diamond	60	45.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Dermacentor	Dermacentor andersoni
32149370	32149370	PRJNA773247_P_NODE_13598_length_408_cov_14.976119_g13514_i0	PRJNA773247	13598	408	14.976119	61.10256552	root	1	Root_unresolved	Root_unresolved	109	4.32e-25	NR	KAK2701939.1	6661	g13514	i0	73.6	1.13970588235294	72	19	52.9	0	3	218	354	425	KAK2701939.1 hypothetical protein QYM36_019440 [Artemia franciscana]	diamond	465	110	0.990909090909091	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana

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