metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA946307" 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
27057097	27057097	PRJNA946307_P_NODE_161062_length_162_cov_1.707965_g160188_i0	PRJNA946307	161062	162	1.707965	2.7669033	Bursaphelenchus okinawaensis	465554	Nematoda	Nematoda	41.2	0.0434	NR	CAD5215308.1	465554	g160188	i0	47.4	0.703703703703704	38	20	70.4	0	115	2	28	65	CAD5215308.1 unnamed protein product [Bursaphelenchus okinawaensis]	diamond	114	41.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus okinawaensis
27499518	27499518	PRJNA946307_P_NODE_37083_length_217_cov_3.714286_g36209_i0	PRJNA946307	37083	217	3.714286	8.06000062	Diploscapter pachys	2018661	Nematoda	Nematoda	108	2.3e-25	NR	PAV62744.1	2018661	g36209	i0	98.2	0.76036866359447	55	1	76	0	208	44	198	252	PAV62744.1 hypothetical protein WR25_22970 [Diploscapter pachys]	diamond	165	108	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys
29172965	29172965	PRJNA946307_P_NODE_112249_length_178_cov_4.162791_g111375_i0	PRJNA946307	112249	178	4.162791	7.40976798	Gongylonema pulchrum	637853	Nematoda	Nematoda	48.1	1.36e-4	NR	VDN43907.1	637853	g111375	i0	40	1.80337078651685	55	33	92.7	0	12	176	113	167	VDN43907.1 unnamed protein product, partial [Gongylonema pulchrum]	diamond	321	48.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gongylonematidae	Gongylonema	Gongylonema pulchrum
29274077	29274077	PRJNA946307_P_NODE_148529_length_165_cov_1.655172_g147655_i0	PRJNA946307	148529	165	1.655172	2.7310338	Rhabditida	6236	Nematoda	Nematoda	47.8	2.19e-4	NR	KAI3413389.1	36090	g147655	i0	55.6	4	36	16	65.5	0	45	152	125	160	KAI3413389.1 hypothetical protein GPALN_010885 [Globodera pallida]	diamond	660	47.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Globodera	Globodera pallida
29425280	29425280	PRJNA946307_P_NODE_83969_length_191_cov_3.781690_g83095_i0	PRJNA946307	83969	191	3.78169	7.2230279	Mesorhabditis belari	2138241	Nematoda	Nematoda	63.9	6.21e-10	NR	CAJ0944014.1	2138241	g83095	i0	32.5	3.94240837696335	126	16	89.5	1	172	2	52	177	CAJ0944014.1 unnamed protein product, partial [Mesorhabditis belari]	diamond	753	63.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Mesorhabditis	Mesorhabditis belari
29709225	29709225	PRJNA946307_P_NODE_67990_length_199_cov_3.746667_g67116_i0	PRJNA946307	67990	199	3.746667	7.45586733	Trichuris suis	68888	Nematoda	Nematoda	49.7	4.72e-5	NR	KFD64059.1	68888	g67116	i0	32.1	5.06532663316583	84	33	90.5	1	183	4	111	194	KFD64059.1 hypothetical protein M514_23769 [Trichuris suis]	diamond	1008	49.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
30151592	30151592	PRJNA946307_P_NODE_58012_length_210_cov_2.602484_g57138_i0	PRJNA946307	58012	210	2.602484	5.4652164	Onchocerca ochengi	42157	Nematoda	Nematoda	43.9	5.57e-4	NR	VDK81991.1	42157	g57138	i0	81.8	0.314285714285714	22	4	31.4	0	17	82	1	22	VDK81991.1 unnamed protein product, partial [Onchocerca ochengi]	diamond	66	43.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Onchocerca	Onchocerca ochengi
30499352	30499352	PRJNA946307_P_NODE_113293_length_178_cov_1.883721_g112419_i0	PRJNA946307	113293	178	1.883721	3.35302338	Enterobius vermicularis	51028	Nematoda	Nematoda	46.6	6.96e-4	NR	VDD89705.1	51028	g112419	i0	42.6	0.910112359550562	54	27	86	2	14	166	792	844	VDD89705.1 unnamed protein product [Enterobius vermicularis]	diamond	162	46.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis
30941912	30941912	PRJNA946307_P_NODE_51534_length_210_cov_3.329193_g50660_i0	PRJNA946307	51534	210	3.329193	6.9913053	Diploscapter pachys	2018661	Nematoda	Nematoda	63.2	1.51e-9	NR	PAV59715.1	2018661	g50660	i0	100	0.4	28	0	40	0	206	123	669	696	PAV59715.1 hypothetical protein WR25_23698 [Diploscapter pachys]	diamond	84	63.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys
31036840	31036840	PRJNA946307_P_NODE_69815_length_199_cov_3.133333_g68941_i0	PRJNA946307	69815	199	3.133333	6.23533267	Dictyocaulus viviparus	29172	Nematoda	Nematoda	53.9	2.39e-6	NR	KJH47222.1	29172	g68941	i0	68.8	2.35175879396985	32	7	43.7	1	198	112	114	145	KJH47222.1 Ras family protein [Dictyocaulus viviparus]	diamond	468	53.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Dictyocaulus	Dictyocaulus viviparus
31257732	31257732	PRJNA946307_P_NODE_76715_length_196_cov_3.816327_g75841_i0	PRJNA946307	76715	196	3.816327	7.48000092	Haemonchus placei	6290	Nematoda	Nematoda	44.3	0.00218	NR	VDO75969.1	6290	g75841	i0	35.6	3.62755102040816	59	24	90.3	1	190	14	49	93	VDO75969.1 unnamed protein product [Haemonchus placei]	diamond	711	44.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Haemonchus	Haemonchus placei
31896976	31896976	PRJNA946307_P_NODE_36977_length_217_cov_8.339286_g36103_i0	PRJNA946307	36977	217	8.339286	18.09625062	Rhabditida	6236	Nematoda	Nematoda	48.1	1.7e-4	NR	CAJ0609498.1	53992	g36103	i0	85.7	1.16129032258065	21	3	29	0	14	76	78	98	CAJ0609498.1 unnamed protein product [Cylicocyclus nassatus]	diamond	252	48.5	0.991752577319588	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Cylicocyclus	Cylicocyclus nassatus
31985139	31985139	PRJNA946307_P_NODE_146238_length_166_cov_0.871795_g145364_i0	PRJNA946307	146238	166	0.871795	1.4471797	Trichinella sp. T8	92180	Nematoda	Nematoda	42	0.0166	NR	KRZ82471.1	92180	g145364	i0	38	0.903614457831325	50	31	90.4	0	164	15	79	128	KRZ82471.1 hypothetical protein T08_2499 [Trichinella sp. T8]	diamond	150	42	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella sp. T8
32143444	32143444	PRJNA946307_P_NODE_113938_length_178_cov_1.496124_g113064_i0	PRJNA946307	113938	178	1.496124	2.66310072	Ancylostoma ceylanicum	53326	Nematoda	Nematoda	44.3	0.00407	NR	EYC31549.1	53326	g113064	i0	50	1.8876404494382	34	17	57.3	0	8	109	157	190	EYC31549.1 hypothetical protein Y032_0004g2213 [Ancylostoma ceylanicum]	diamond	336	44.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma ceylanicum
32333636	32333636	PRJNA946307_P_NODE_45799_length_210_cov_4.795031_g44925_i0	PRJNA946307	45799	210	4.795031	10.0695651	Auanema sp. JU1783	2878363	Nematoda	Nematoda	73.6	2.26e-13	NR	CAI4231116.1	2878363	g44925	i0	64.4	0.842857142857143	59	11	70	1	33	179	31	89	CAI4231116.1 unnamed protein product [Auanema sp. JU1783]	diamond	177	73.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Auanema	Auanema sp. JU1783

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