metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax_phylum = "Nematoda"

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
14483590	14483590	PRJNA493244_P_NODE_1125492_length_355_cov_8.795918_g1102370_i0	PRJNA493244	1125492	355	8.795918	31.2255089	Acanthocheilonema viteae	6277	Nematoda	Nematoda	63.2	5.41e-9	NR	VBB26482.1	6277	g1102370	i0	45	2.47605633802817	60	33	50.7	0	269	90	124	183	VBB26482.1 unnamed protein product [Acanthocheilonema viteae]	diamond	879	63.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
26727829	26727829	PRJNA493244_P_NODE_1054601_length_383_cov_7.959627_g1031488_i0	PRJNA493244	1054601	383	7.959627	30.48537141	Ancylostoma ceylanicum	53326	Nematoda	Nematoda	55.8	3.98e-6	NR	EYB89761.1	53326	g1031488	i0	45.6	0.532637075718016	68	30	47.8	3	121	303	112	179	EYB89761.1 hypothetical protein Y032_0228g2883 [Ancylostoma ceylanicum]	diamond	204	55.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma ceylanicum
27029129	27029129	PRJNA493244_P_NODE_833122_length_488_cov_5.548009_g810333_i0	PRJNA493244	833122	488	5.548009	27.07428392	root	1	Root_unresolved	Root_unresolved	95.9	3.37e-20	NR	VDO07296.1	42155	g810333	i0	50.5	2.38524590163934	97	48	59.6	0	2	292	36	132	VDO07296.1 unnamed protein product [Brugia timori]	diamond	1164	96.7	0.991726990692865	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia timori
27076455	27076455	PRJNA493244_P_NODE_1590222_length_222_cov_4.565217_g1567097_i0	PRJNA493244	1590222	222	4.565217	10.13478174	Caenorhabditis elegans	6239	Nematoda	Nematoda	40.4	0.0337	NR	NP_872151.1	6239	g1567097	i0	60.6	0.445945945945946	33	12	43.2	1	56	151	1	33	NP_872151.1 FIP (Fungus-Induced Protein) Related [Caenorhabditis elegans]	diamond	99	40.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
28687362	28687362	PRJNA493244_P_NODE_1691607_length_205_cov_0.888889_g1668482_i0	PRJNA493244	1691607	205	0.888889	1.82222245	Meloidogyne enterolobii	390850	Nematoda	Nematoda	56.6	2.94e-7	NR	CAD2172123.1	390850	g1668482	i0	37.8	1.08292682926829	74	39	98	1	202	2	419	492	CAD2172123.1 unnamed protein product [Meloidogyne enterolobii]	diamond	222	56.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
29366135	29366135	PRJNA493244_P_NODE_1562649_length_228_cov_11.616766_g1539524_i0	PRJNA493244	1562649	228	11.616766	26.48622648	Opisthokonta	33154	Nematoda	Nematoda	76.6	3.67e-14	NR	KRZ72191.1	268474	g1539524	i0	58.5	11.9868421052632	65	17	85.5	2	25	219	2132	2186	KRZ72191.1 Mediator of RNA polymerase II transcription subunit 23 [Trichinella papuae]	diamond	2733	76.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella papuae
30487264	30487264	PRJNA493244_P_NODE_1230233_length_319_cov_1.201550_g1207109_i0	PRJNA493244	1230233	319	1.20155	3.8329445	Meloidogyne enterolobii	390850	Nematoda	Nematoda	73.6	1.08e-12	NR	CAD2194249.1	390850	g1207109	i0	51.9	3.55485893416928	54	26	50.8	0	29	190	13	66	CAD2194249.1 unnamed protein product [Meloidogyne enterolobii]	diamond	1134	73.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
30661121	30661121	PRJNA493244_P_NODE_1696993_length_204_cov_1.342657_g1673868_i0	PRJNA493244	1696993	204	1.342657	2.73902028	Opisthokonta	33154	Nematoda	Nematoda	48.1	2.88e-4	NR	KAK0417091.1	289476	g1673868	i0	43.8	4.77941176470588	64	36	94.1	0	1	192	562	625	KAK0417091.1 hypothetical protein QR680_012828 [Steinernema hermaphroditum]	diamond	975	48.5	0.991752577319588	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema hermaphroditum
31403798	31403798	PRJNA493244_P_NODE_1031596_length_393_cov_2.593373_g1008487_i0	PRJNA493244	1031596	393	2.593373	10.19195589	Steinernema carpocapsae	34508	Nematoda	Nematoda	58.2	7.13e-7	NR	TKR64027.1	34508	g1008487	i0	42.6	0.519083969465649	68	35	51.9	1	25	228	23	86	TKR64027.1 hypothetical protein L596_024624 [Steinernema carpocapsae]	diamond	204	58.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
31751467	31751467	PRJNA493244_P_NODE_1054657_length_383_cov_6.602484_g1031544_i0	PRJNA493244	1054657	383	6.602484	25.28751372	Trichinella spiralis	6334	Nematoda	Nematoda	93.2	3.99e-19	NR	KAL1246409.1	6334	g1031544	i0	53.4	2.0443864229765	88	41	68.9	0	17	280	22	109	KAL1246409.1 E3 UFM1-protein ligase [Trichinella spiralis]	diamond	783	93.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
32163087	32163087	PRJNA493244_P_NODE_888518_length_459_cov_4.716080_g865580_i0	PRJNA493244	888518	459	4.71608	21.6468072	Diploscapter pachys	2018661	Nematoda	Nematoda	176	5.22e-53	NR	PAV74583.1	2018661	g865580	i0	83.6	0.758169934640523	116	19	75.8	0	436	89	76	191	PAV74583.1 hypothetical protein WR25_26826 [Diploscapter pachys]	diamond	348	176	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys
32194607	32194607	PRJNA493244_P_NODE_426618_length_806_cov_2.954362_g407851_i0	PRJNA493244	426618	806	2.954362	23.81215772	Parelaphostrongylus tenuis	148309	Nematoda	Nematoda	58.2	1.25e-5	NR	KAJ1356600.1	148309	g407851	i0	52.9	0.387096774193548	51	24	19	0	610	458	273	323	KAJ1356600.1 hypothetical protein KIN20_014333 [Parelaphostrongylus tenuis]	diamond	312	58.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Parelaphostrongylus	Parelaphostrongylus tenuis
32778849	32778849	PRJNA493244_P_NODE_1510120_length_240_cov_5.379888_g1486995_i0	PRJNA493244	1510120	240	5.379888	12.9117312	Metazoa	33208	Nematoda	Nematoda	69.3	1.04e-12	NR	XP_003377501.1	6334	g1486995	i0	97	14.8375	33	1	41.3	0	23	121	115	147	XP_003377501.1 60S ribosomal protein L23 [Trichinella spiralis]	diamond	3561	69.7	0.994261119081779	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
32873385	32873385	PRJNA493244_P_NODE_1040600_length_389_cov_3.780488_g1017489_i0	PRJNA493244	1040600	389	3.780488	14.70609832	Rhabditida	6236	Nematoda	Nematoda	159	4.05e-42	NR	VDD92173.1	51028	g1017489	i0	91.1	14.0359897172237	79	7	60.9	0	20	256	1639	1717	VDD92173.1 unnamed protein product [Enterobius vermicularis]	diamond	5460	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis

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