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

10 rows where analysis = "diamond", bioproject = "PRJEB9859" 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
6523316	6523316	PRJEB9859_P_NODE_8206_length_197_cov_21.184524_g8171_i0	PRJEB9859	8206	197	21.184524	41.73351228	Cephus cinctus	211228	Arthropoda	Arthropoda	85.9	1.21e-17	NR	XP_024939559.1	211228	g8171	i0	66.7	5.93908629441624	54	18	82.2	0	170	9	213	266	XP_024939559.1 glutathione hydrolase 1 proenzyme isoform X2 [Cephus cinctus]	diamond	1170	85.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Cephidae	Cephus	Cephus cinctus
10347984	10347984	PRJEB9859_P_NODE_2069_length_316_cov_7.156794_g2034_i0	PRJEB9859	2069	316	7.156794	22.61546904	Daphnia pulex	6669	Arthropoda	Arthropoda	139	7.73e-40	NR	EFX60013.1	6669	g2034	i0	82.3	1.57594936708861	79	14	75	0	25	261	67	145	EFX60013.1 hypothetical protein DAPPUDRAFT_73053 [Daphnia pulex]	diamond	498	139	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
14173497	14173497	PRJEB9859_P_NODE_1032_length_390_cov_3.210526_g998_i0	PRJEB9859	1032	390	3.210526	12.5210514	Metazoa	33208	Arthropoda	Arthropoda	149	3.27e-43	NR	OTF70000.1	6958	g998	i0	71.6	11.9	95	27	73.1	0	387	103	74	168	OTF70000.1 60S ribosomal protein L11-like protein [Euroglyphus maynei]	diamond	4641	150	0.993333333333333	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Euroglyphus	Euroglyphus maynei
26646870	26646870	PRJEB9859_P_NODE_3481_length_267_cov_7.344538_g3446_i0	PRJEB9859	3481	267	7.344538	19.60991646	Metazoa	33208	Arthropoda	Arthropoda	67	9.96e-12	NR	XP_055701935.1	29031	g3446	i0	48.6	9.33707865168539	72	36	80.9	1	2	217	70	140	XP_055701935.1 40S ribosomal protein S12 [Phlebotomus papatasi]	diamond	2493	67.4	0.99406528189911	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Phlebotomus	Phlebotomus papatasi
28108079	28108079	PRJEB9859_P_NODE_1385_length_359_cov_2.093939_g1350_i0	PRJEB9859	1385	359	2.093939	7.51724101	Idotea baltica	82763	Arthropoda	Arthropoda	89.7	1.11e-20	NR	MCL4170146.1	82763	g1350	i0	57.5	0.668523676880223	80	34	66.9	0	6	245	12	91	MCL4170146.1 hypothetical protein [Idotea baltica]	diamond	240	89.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
29718254	29718254	PRJEB9859_P_NODE_210_length_639_cov_7.260656_g199_i0	PRJEB9859	210	639	7.260656	46.39559184	Lepeophtheirus salmonis	72036	Arthropoda	Arthropoda	115	3.1699999999999998e-28	NR	ADD38186.1	72036	g199	i0	37.6	0.849765258215962	181	104	84	2	637	101	16	189	ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis]	diamond	543	115	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Siphonostomatoida	Caligidae	Lepeophtheirus	Lepeophtheirus salmonis
29971152	29971152	PRJEB9859_P_NODE_4771_length_247_cov_1.018349_g4736_i0	PRJEB9859	4771	247	1.018349	2.51532203	Limnephilus lunatus	1218281	Arthropoda	Arthropoda	48.9	2.52e-4	NR	WIM01487.1	1218281	g4736	i0	60.5	0.461538461538462	38	15	46.2	0	3	116	504	541	WIM01487.1 T-complex protein 1 subunit eta [Limnephilus lunatus]	diamond	114	48.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Trichoptera	Limnephilidae	Limnephilus	Limnephilus lunatus
30785263	30785263	PRJEB9859_P_NODE_1314_length_364_cov_1.907463_g1279_i0	PRJEB9859	1314	364	1.907463	6.94316532	Opisthokonta	33154	Arthropoda	Arthropoda	122	1.35e-32	NR	NP_476778.1	7227	g1279	i0	67	21.7087912087912	94	26	77.5	1	348	67	64	152	NP_476778.1 ribosomal protein S27A [Drosophila melanogaster]	diamond	7902	122	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
31449128	31449128	PRJEB9859_P_NODE_2676_length_292_cov_3.399240_g2641_i0	PRJEB9859	2676	292	3.39924	9.9257808	Insecta	50557	Arthropoda	Arthropoda	88.2	2.87e-19	NR	XP_068905359.1	7067	g2641	i0	51.9	5.49657534246575	79	38	81.2	0	257	21	63	141	XP_068905359.1 large ribosomal subunit protein eL13-like [Tenebrio molitor]	diamond	1605	89	0.991011235955056	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tenebrio	Tenebrio molitor
32588088	32588088	PRJEB9859_P_NODE_3139_length_277_cov_3.318548_g3104_i0	PRJEB9859	3139	277	3.318548	9.19237796	Arthropoda	6656	Arthropoda	Arthropoda	76.6	2e-15	NR	XP_037794350.1	6687	g3104	i0	70.7	24.4440433212996	58	17	62.8	0	257	84	82	139	XP_037794350.1 uncharacterized protein LOC119589836 isoform X1 [Penaeus monodon]	diamond	6771	76.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus monodon

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