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

7 rows where analysis = "diamond", bioproject = "PRJNA527965" 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
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
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
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);;