metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA694557" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA694557" 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
19800356	19800356	PRJNA694557_P_NODE_3296_length_848_cov_3.718710_g3098_i0	PRJNA694557	3296	848	3.71871	31.5346608	Chironomus tepperi	113505	Arthropoda	Arthropoda	204	4.3799999999999995e-61	NR	XP_070507736.1	113505	g3098	i0	51.7	0.841981132075472	238	108	83.1	3	27	731	1	234	XP_070507736.1 large ribosomal subunit protein mL64 [Chironomus tepperi]	diamond	714	204	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
26702566	26702566	PRJNA694557_P_NODE_20781_length_272_cov_2.512563_g20561_i0	PRJNA694557	20781	272	2.512563	6.83417136	Ixodes scapularis	6945	Arthropoda	Arthropoda	61.6	1.66e-9	NR	EEC09865.1	6945	g20561	i0	71.1	1.74264705882353	38	11	41.9	0	226	113	21	58	EEC09865.1 ribosomal protein, putative [Ixodes scapularis]	diamond	474	61.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Ixodes	Ixodes scapularis
28630245	28630245	PRJNA694557_P_NODE_26307_length_235_cov_3.055556_g26087_i0	PRJNA694557	26307	235	3.055556	7.1805566	Artemia franciscana	6661	Arthropoda	Arthropoda	112	4.31e-27	NR	KAK2721442.1	6661	g26087	i0	73.3	1.91489361702128	75	20	95.7	0	226	2	226	300	KAK2721442.1 hypothetical protein QYM36_003662, partial [Artemia franciscana]	diamond	450	112	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
28724770	28724770	PRJNA694557_P_NODE_5907_length_602_cov_6.939509_g5688_i0	PRJNA694557	5907	602	6.939509	41.77584418	Varroa destructor	109461	Arthropoda	Arthropoda	84	3.96e-16	NR	XP_022644639.1	109461	g5688	i0	54.3	3.06976744186047	70	32	34.9	0	601	392	134	203	XP_022644639.1 ras-related C3 botulinum toxin substrate 1-like [Varroa destructor]	diamond	1848	84	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Mesostigmata	Varroidae	Varroa	Varroa destructor
29893224	29893224	PRJNA694557_P_NODE_18351_length_295_cov_2.936937_g18131_i0	PRJNA694557	18351	295	2.936937	8.66396415	Ceratitis capitata	7213	Arthropoda	Arthropoda	49.3	7.22e-5	NR	CAD7011254.1	7213	g18131	i0	59	0.396610169491525	39	16	39.7	0	217	101	85	123	CAD7011254.1 unnamed protein product [Ceratitis capitata]	diamond	117	49.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Ceratitis	Ceratitis capitata
30809274	30809274	PRJNA694557_P_NODE_12554_length_374_cov_1.647841_g12334_i0	PRJNA694557	12554	374	1.647841	6.16292534	Artemia franciscana	6661	Arthropoda	Arthropoda	64.7	2.92e-9	NR	KAK2725871.1	6661	g12334	i0	59.3	2.40641711229947	54	22	43.3	0	331	170	37	90	KAK2725871.1 hypothetical protein QYM36_000368 [Artemia franciscana]	diamond	900	64.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
31251590	31251590	PRJNA694557_P_NODE_7375_length_524_cov_2.252772_g7155_i0	PRJNA694557	7375	524	2.252772	11.80452528	Pseudolycoriella hygida	35572	Arthropoda	Arthropoda	101	3.24e-21	NR	KAJ6638648.1	35572	g7155	i0	52.2	1.58015267175573	92	44	52.7	0	247	522	1091	1182	KAJ6638648.1 Phospholipid-transporting ATPase ABCA3 [Pseudolycoriella hygida]	diamond	828	101	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Pseudolycoriella	Pseudolycoriella hygida
31409860	31409860	PRJNA694557_P_NODE_11696_length_392_cov_2.147335_g11476_i0	PRJNA694557	11696	392	2.147335	8.4175532	Petrolisthes cinctipes	88211	Arthropoda	Arthropoda	159	2.1699999999999998e-42	NR	KAK3882625.1	88211	g11476	i0	65.8	2.68622448979592	117	36	89.5	2	373	23	829	941	KAK3882625.1 hypothetical protein Pcinc_012994 [Petrolisthes cinctipes]	diamond	1053	159	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Porcellanidae	Petrolisthes	Petrolisthes cinctipes
31631147	31631147	PRJNA694557_P_NODE_22416_length_258_cov_3.681081_g22196_i0	PRJNA694557	22416	258	3.681081	9.49718898	Parthenolecanium corni	536013	Arthropoda	Arthropoda	75.5	1.33e-13	NR	KAK7580690.1	536013	g22196	i0	76.8	0.953488372093023	82	19	95.3	0	3	248	1036	1117	KAK7580690.1 hypothetical protein V9T40_001319 [Parthenolecanium corni]	diamond	246	75.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Coccidae	Parthenolecanium	Parthenolecanium corni
31884182	31884182	PRJNA694557_P_NODE_8517_length_477_cov_2.465347_g8297_i0	PRJNA694557	8517	477	2.465347	11.75970519	Trichonephila clavipes	2585209	Arthropoda	Arthropoda	45.8	0.0264	NR	GFX97711.1	2585209	g8297	i0	30.6	0.69811320754717	111	66	67.3	2	109	429	17	120	GFX97711.1 transposable element Tcb1 transposase [Trichonephila clavipes]	diamond	333	45.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Trichonephila	Trichonephila clavipes

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