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

7 rows where analysis = "diamond", bioproject = "PRJNA663960" 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
26796655	26796655	PRJNA663960_S_NODE_18321_length_274_cov_4.665198_g18085_i0	PRJNA663960	18321	274	4.665198	12.78264252	Portunus trituberculatus	210409	Arthropoda	Arthropoda	41.6	0.0482	NR	MPC67581.1	210409	g18085	i0	38.9	0.591240875912409	54	32	59.1	1	253	92	31	83	MPC67581.1 hypothetical protein [Portunus trituberculatus]	diamond	162	41.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Portunus	Portunus trituberculatus
26954726	26954726	PRJNA663960_S_NODE_18282_length_275_cov_1.118421_g18046_i0	PRJNA663960	18282	275	1.118421	3.07565775	Dryococelus australis	614101	Arthropoda	Arthropoda	46.6	0.00243	NR	KAJ8891445.1	614101	g18046	i0	40.7	0.589090909090909	54	32	58.9	0	237	76	29	82	KAJ8891445.1 hypothetical protein PR048_003973 [Dryococelus australis]	diamond	162	46.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Phasmatidae	Dryococelus	Dryococelus australis
27883216	27883216	PRJNA663960_S_NODE_32105_length_214_cov_3.892216_g31869_i0	PRJNA663960	32105	214	3.892216	8.32934224	Arthropoda	6656	Arthropoda	Arthropoda	44.7	0.00546	NR	XP_016658134.1	7029	g31869	i0	32.4	5.6214953271028	68	34	78.5	1	189	22	718	785	XP_016658134.1 uncharacterized protein LOC107883144 [Acyrthosiphon pisum]	diamond	1203	45.1	0.991130820399113	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
27934346	27934346	PRJNA663960_S_NODE_7925_length_357_cov_3.103226_g7689_i0	PRJNA663960	7925	357	3.103226	11.07851682	Cryptotermes secundus	105785	Arthropoda	Arthropoda	52.8	3.98e-5	NR	XP_023720873.1	105785	g7689	i0	41.7	3.63025210084034	72	42	60.5	0	133	348	8	79	XP_023720873.1 general transcription factor II-I repeat domain-containing protein 2-like [Cryptotermes secundus]	diamond	1296	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Kalotermitidae	Cryptotermes	Cryptotermes secundus
28483218	28483218	PRJNA663960_S_NODE_11546_length_320_cov_2.802198_g11310_i0	PRJNA663960	11546	320	2.802198	8.9670336	Insecta	50557	Arthropoda	Arthropoda	48.1	6.93e-4	NR	GBP21752.1	151549	g11310	i0	42.4	3.46875	59	34	55.3	0	307	131	70	128	GBP21752.1 Zinc finger BED domain-containing protein 5 [Eumeta japonica]	diamond	1110	48.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Psychidae	Eumeta	Eumeta japonica
29355244	29355244	PRJNA663960_S_NODE_48629_length_174_cov_1.204724_g48393_i0	PRJNA663960	48629	174	1.204724	2.09621976	Zootermopsis nevadensis	136037	Arthropoda	Arthropoda	44.3	0.00392	NR	XP_021941809.1	136037	g48393	i0	59.1	0.758620689655172	44	14	72.4	2	26	151	137	178	XP_021941809.1 zinc finger BED domain-containing protein 5-like isoform X1 [Zootermopsis nevadensis]	diamond	132	44.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Termopsidae	Zootermopsis	Zootermopsis nevadensis
32243686	32243686	PRJNA663960_S_NODE_44738_length_182_cov_1.133333_g44502_i0	PRJNA663960	44738	182	1.133333	2.06266606	Arthropoda	6656	Arthropoda	Arthropoda	42.7	0.00873	NR	GBP75474.1	151549	g44502	i0	57.1	4.4010989010989	28	12	46.2	0	87	4	80	107	GBP75474.1 Zinc finger BED domain-containing protein 5 [Eumeta japonica]	diamond	801	43.1	0.990719257540603	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Psychidae	Eumeta	Eumeta japonica

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