metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJEB65329" and tax

11 rows where analysis = "diamond", bioproject = "PRJEB65329" 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
129950	129950	PRJEB65329_S_NODE_10141_length_216_cov_476.470588_g9979_i0	PRJEB65329	10141	216	476.470588	1029.17647008	Daphnia magna	35525	Arthropoda	Arthropoda	97.8	1.9300000000000001e-22	NR	XP_045023975.1	35525	g9979	i0	79.3	1.61111111111111	58	12	80.6	0	176	3	233	290	XP_045023975.1 uncharacterized protein LOC116917414 [Daphnia magna]	diamond	348	97.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna
27697730	27697730	PRJEB65329_S_NODE_11544_length_199_cov_2.376471_g11382_i0	PRJEB65329	11544	199	2.376471	4.72917729	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	43.1	0.0159	NR	KAH9387798.1	59818	g11382	i0	57.1	0.422110552763819	28	12	42.2	0	1	84	1401	1428	KAH9387798.1 Lysine-specific demethylase 2A [Tyrophagus putrescentiae]	diamond	84	43.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
28550051	28550051	PRJEB65329_S_NODE_15247_length_167_cov_3.753623_g15085_i0	PRJEB65329	15247	167	3.753623	6.26855041	Daphnia magna	35525	Arthropoda	Arthropoda	117	1.29e-32	NR	KAK4026520.1	35525	g15085	i0	90.9	0.988023952095808	55	5	98.8	0	2	166	14	68	KAK4026520.1 hypothetical protein OUZ56_015515 [Daphnia magna]	diamond	165	117	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna
28637751	28637751	PRJEB65329_S_NODE_18227_length_152_cov_1.593496_g18065_i0	PRJEB65329	18227	152	1.593496	2.42211392	Daphnia	6668	Arthropoda	Arthropoda	105	7.91e-25	NR	KAK4010419.1	35525	g18065	i0	96	4.93421052631579	50	2	98.7	0	3	152	118	167	KAK4010419.1 hypothetical protein OUZ56_019561 [Daphnia magna]	diamond	750	105	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna
29433615	29433615	PRJEB65329_S_NODE_12290_length_191_cov_2.925926_g12128_i0	PRJEB65329	12290	191	2.925926	5.58851866	Daphnia magna	35525	Arthropoda	Arthropoda	58.9	1.32e-8	NR	KAK4006843.1	35525	g12128	i0	65.9	0.691099476439791	44	11	69.1	1	190	59	12	51	KAK4006843.1 hypothetical protein OUZ56_012000 [Daphnia magna]	diamond	132	58.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna
29749370	29749370	PRJEB65329_S_NODE_16571_length_160_cov_1.625954_g16409_i0	PRJEB65329	16571	160	1.625954	2.6015264	Daphnia pulex	6669	Arthropoda	Arthropoda	73.2	2.73e-14	NR	XP_046448750.1	6669	g16409	i0	69.2	1.95	52	16	97.5	0	158	3	132	183	XP_046448750.1 uncharacterized protein LOC124197367 [Daphnia pulex]	diamond	312	73.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
30128446	30128446	PRJEB65329_S_NODE_9892_length_220_cov_3.204188_g9730_i0	PRJEB65329	9892	220	3.204188	7.0492136	Daphnia magna	35525	Arthropoda	Arthropoda	102	2.8399999999999998e-25	NR	KAK4006843.1	35525	g9730	i0	92.7	0.75	55	4	75	0	218	54	141	195	KAK4006843.1 hypothetical protein OUZ56_012000 [Daphnia magna]	diamond	165	102	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna
30476427	30476427	PRJEB65329_S_NODE_6873_length_284_cov_4.247059_g6711_i0	PRJEB65329	6873	284	4.247059	12.06164756	Daphnia magna	35525	Arthropoda	Arthropoda	122	7.180000000000001e-33	NR	KAK4006595.1	35525	g6711	i0	66.7	1.90140845070423	93	31	98.2	0	279	1	104	196	KAK4006595.1 hypothetical protein OUZ56_011752 [Daphnia magna]	diamond	540	122	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna
30665793	30665793	PRJEB65329_S_NODE_7793_length_259_cov_3.686957_g7631_i0	PRJEB65329	7793	259	3.686957	9.54921863	Daphnia pulicaria	35523	Arthropoda	Arthropoda	110	4.87e-28	NR	XP_046642708.1	35523	g7631	i0	65.2	1.03088803088803	89	26	99.6	2	2	259	73	159	XP_046642708.1 uncharacterized protein LOC124327753 [Daphnia pulicaria]	diamond	267	110	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulicaria
31519410	31519410	PRJEB65329_S_NODE_9736_length_222_cov_4.481865_g9574_i0	PRJEB65329	9736	222	4.481865	9.9497403	Daphnia magna	35525	Arthropoda	Arthropoda	77.8	7.39e-15	NR	KAK4006837.1	35525	g9574	i0	76.2	0.851351351351351	63	15	85.1	0	208	20	24	86	KAK4006837.1 hypothetical protein OUZ56_011994 [Daphnia magna]	diamond	189	77.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna
32215326	32215326	PRJEB65329_S_NODE_5478_length_340_cov_4.762058_g5316_i0	PRJEB65329	5478	340	4.762058	16.1909972	Daphnia magna	35525	Arthropoda	Arthropoda	143	1.4599999999999996e-40	NR	KAK4006595.1	35525	g5316	i0	60.3	1.11176470588235	126	35	97.9	1	8	340	71	196	KAK4006595.1 hypothetical protein OUZ56_011752 [Daphnia magna]	diamond	378	143	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna

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