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

9 rows where analysis = "diamond", bioproject = "PRJNA527965" and tax_kingdom = "Metazoa"

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
10700865	10700865	PRJNA527965_S_NODE_3289_length_210_cov_2.788571_g3206_i0	PRJNA527965	3289	210	2.788571	5.8559991	Daphnia pulex	6669	Arthropoda	Arthropoda	136	2.77e-37	NR	EFX60189.1	6669	g3206	i0	100	0.985714285714286	69	0	98.6	0	209	3	124	192	EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex]	diamond	207	136	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
27804073	27804073	PRJNA527965_S_NODE_2624_length_237_cov_1.891089_g2541_i0	PRJNA527965	2624	237	1.891089	4.48188093	Trichonephila clavipes	2585209	Arthropoda	Arthropoda	44.7	0.00272	NR	GFX36245.1	2585209	g2541	i0	52.2	1.0379746835443	46	22	58.2	0	199	62	24	69	GFX36245.1 uncharacterized protein TNCV_2065831 [Trichonephila clavipes]	diamond	246	44.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Trichonephila	Trichonephila clavipes
27882270	27882270	PRJNA527965_S_NODE_2305_length_254_cov_4.077626_g2222_i0	PRJNA527965	2305	254	4.077626	10.35717004	Metazoa	33208	Mollusca	Mollusca	55.1	3.6e-7	NR	RUS68435.1	188477	g2222	i0	43.8	8.81102362204724	89	43	98	2	251	3	28	115	RUS68435.1 hypothetical protein EGW08_023803 [Elysia chlorotica]	diamond	2238	55.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia chlorotica
28309175	28309175	PRJNA527965_S_NODE_1226_length_342_cov_3.824104_g1143_i0	PRJNA527965	1226	342	3.824104	13.07843568	Daphnia pulex	6669	Arthropoda	Arthropoda	169	2.2e-49	NR	EFX60189.1	6669	g1143	i0	94.5	0.798245614035088	91	5	79.8	0	275	3	207	297	EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex]	diamond	273	169	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
29225025	29225025	PRJNA527965_S_NODE_2289_length_255_cov_2.836364_g2206_i0	PRJNA527965	2289	255	2.836364	7.2327282	Daphnia pulex	6669	Arthropoda	Arthropoda	144	3.78e-40	NR	EFX60189.1	6669	g2206	i0	94.9	0.917647058823529	78	4	91.8	0	3	236	136	213	EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex]	diamond	234	144	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
29666455	29666455	PRJNA527965_S_NODE_4890_length_169_cov_1.865672_g4807_i0	PRJNA527965	4890	169	1.865672	3.15298568	Daphnia pulex	6669	Arthropoda	Arthropoda	112	1.82e-28	NR	EFX60189.1	6669	g4807	i0	100	0.994082840236686	56	0	99.4	0	169	2	259	314	EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex]	diamond	168	112	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
30045641	30045641	PRJNA527965_S_NODE_4911_length_169_cov_1.350746_g4828_i0	PRJNA527965	4911	169	1.350746	2.28276074	Capitella teleta	283909	Annelida	Annelida	39.3	0.0435	NR	ELU05767.1	283909	g4828	i0	57.1	0.621301775147929	35	10	62.1	1	1	105	38	67	ELU05767.1 hypothetical protein CAPTEDRAFT_142127, partial [Capitella teleta]	diamond	105	39.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
30299015	30299015	PRJNA527965_S_NODE_4172_length_185_cov_3.400000_g4089_i0	PRJNA527965	4172	185	3.4	6.29	Zootermopsis nevadensis	136037	Arthropoda	Arthropoda	54.7	1e-7	NR	KDQ71533.1	136037	g4089	i0	69.7	1.60540540540541	33	10	53.5	0	86	184	56	88	KDQ71533.1 hypothetical protein L798_10643, partial [Zootermopsis nevadensis]	diamond	297	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Termopsidae	Zootermopsis	Zootermopsis nevadensis
32337532	32337532	PRJNA527965_S_NODE_3439_length_205_cov_1.329412_g3356_i0	PRJNA527965	3439	205	1.329412	2.7252946	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	75.5	6.32e-14	NR	CAL4098822.1	48144	g3356	i0	44.3	2.04878048780488	70	37	99.5	1	204	1	376	445	CAL4098822.1 unnamed protein product, partial [Meganyctiphanes norvegica]	diamond	420	75.9	0.994729907773386	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Euphausiacea	Euphausiidae	Meganyctiphanes	Meganyctiphanes norvegica

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