metadata: contig_metadata: 14 rows where bioproject = "PRJNA169559" and tax

14 rows where bioproject = "PRJNA169559" 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
2915532	2915532	PRJNA169559_P_NODE_15523_length_428_cov_5.591479_g13572_i0	PRJNA169559	15523	428	5.591479	23.93153012	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	161	6.569999999999998e-35	NTclustered	gi\|524845312\|gb\|KC819366.1\|	1355913	g13572	i0	80.717	27.1892523364486	223	29	50	11	67	282	49	264	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds	blastn	11637	161	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus
2915864	2915864	PRJNA169559_P_NODE_8523_length_582_cov_4.511754_g6877_i0	PRJNA169559	8523	582	4.511754	26.25840828	Opisthokonta	33154	Nematoda	Nematoda	216	7.429999999999999e-68	NR	KFD50978.1	68888	g6877	i0	71.6	18.0979381443299	148	42	76.3	0	543	100	51	198	KFD50978.1 hypothetical protein M513_08161, partial [Trichuris suis]	diamond	10533	216	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
5468246	5468246	PRJNA169559_P_NODE_21685_length_347_cov_13.185535_g19622_i0	PRJNA169559	21685	347	13.185535	45.75380645	Diplogastrellus sp. VS-2014	1538693	Nematoda	Nematoda	163	1.4499999999999998e-35	NTclustered	gi\|675119125\|gb\|KJ877442.1\|	1538693	g19622	i0	82.703	41.864553314121	185	30	53	2	98	281	64	247	Diplogastrellus sp. VS-2014 strain RS5608 small subunit ribosomal protein 27 (rps-27) mRNA, partial cds	blastn	14527	163	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Diplogastrellus	Diplogastrellus sp. VS-2014
13118721	13118721	PRJNA169559_P_NODE_2251_length_1101_cov_4.027985_g1399_i0	PRJNA169559	2251	1101	4.027985	44.34811485	Metazoa	33208	Nematoda	Nematoda	308	2.0399999999999996e-99	NR	XP_064059976.1	51031	g1399	i0	54	20.8256130790191	285	125	76.8	5	917	72	63	344	XP_064059976.1 hypothetical protein RB195_014013 [Necator americanus]	diamond	22929	310	0.993548387096774	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
24591114	24591114	PRJNA169559_P_NODE_11760_length_491_cov_4.818182_g9919_i0	PRJNA169559	11760	491	4.818182	23.65727362	Levipalatum texanum	1486449	Nematoda	Nematoda	200	1.6199999999999999e-46	NTclustered	gi\|610559467\|gb\|KJ395558.1\|	1486449	g9919	i0	82.158	2.63543788187373	241	35	48	6	196	432	148	384	Levipalatum texanum ribosomal protein (rpl-23) gene, partial cds	blastn	1294	200	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Levipalatum	Levipalatum texanum
28165629	28165629	PRJNA169559_P_NODE_4845_length_771_cov_2.498652_g3545_i0	PRJNA169559	4845	771	2.498652	19.26460692	Metazoa	33208	Nematoda	Nematoda	300	4.72e-98	NR	NP_001369965.1	6239	g3545	i0	58.7	12.1906614785992	242	98	93.4	2	769	50	109	350	NP_001369965.1 Peptidase C1A papain C-terminal domain-containing protein [Caenorhabditis elegans]	diamond	9399	300	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
28512867	28512867	PRJNA169559_P_NODE_22927_length_329_cov_2.753333_g20856_i0	PRJNA169559	22927	329	2.753333	9.05846557	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	67.8	1.23e-10	NR	CAD5208756.1	6326	g20856	i0	50	1.94224924012158	70	34	63.8	1	226	17	92	160	CAD5208756.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	639	67.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
29018394	29018394	PRJNA169559_P_NODE_23068_length_327_cov_3.204698_g20997_i0	PRJNA169559	23068	327	3.204698	10.47936246	Metazoa	33208	Nematoda	Nematoda	155	1.3899999999999999e-46	NR	ULT99372.1	6238	g20997	i0	83.9	132.009174311927	87	14	79.8	0	18	278	40	126	ULT99372.1 hypothetical protein L3Y34_000603 [Caenorhabditis briggsae]	diamond	43167	155	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
29252615	29252615	PRJNA169559_P_NODE_14709_length_438_cov_24.665037_g12772_i0	PRJNA169559	14709	438	24.665037	108.03286206	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	88.6	1.99e-19	NR	GMT18625.1	1538716	g12772	i0	40.5	1.78082191780822	131	71	89	3	438	49	2	126	GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus]	diamond	780	88.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus
29838945	29838945	PRJNA169559_P_NODE_11231_length_502_cov_4.964059_g9408_i0	PRJNA169559	11231	502	4.964059	24.91957618	Metazoa	33208	Nematoda	Nematoda	175	7.43e-53	NR	KHN76788.1	6265	g9408	i0	58.3	35.1513944223108	144	60	86.1	0	491	60	9	152	KHN76788.1 40S ribosomal protein S15 [Toxocara canis]	diamond	17646	176	0.994318181818182	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
30502503	30502503	PRJNA169559_P_NODE_29793_length_266_cov_1.354430_g27717_i0	PRJNA169559	29793	266	1.35443	3.6027838	Onchocercidae	6296	Nematoda	Nematoda	45.8	0.00404	NR	VBB28113.1	6277	g27717	i0	67.7	2.09774436090226	31	10	35	0	96	4	204	234	VBB28113.1 unnamed protein product [Acanthocheilonema viteae]	diamond	558	46.2	0.991341991341991	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
30547820	30547820	PRJNA169559_P_NODE_20773_length_361_cov_24.075301_g18719_i0	PRJNA169559	20773	361	24.075301	86.91183661	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	128	8.61e-36	NR	GMT14341.1	1538716	g18719	i0	65.6	1.53739612188366	93	31	77.3	1	335	57	7	98	GMT14341.1 hypothetical protein PFISCL1PPCAC_5638, partial [Pristionchus fissidentatus]	diamond	555	128	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus
31102635	31102635	PRJNA169559_P_NODE_32775_length_254_cov_1.768889_g30699_i0	PRJNA169559	32775	254	1.768889	4.49297806	Metazoa	33208	Nematoda	Nematoda	60.8	1.46e-8	NR	KHN86703.1	6265	g30699	i0	77.1	15.6377952755906	35	8	41.3	0	254	150	84	118	KHN86703.1 Serine/threonine-protein phosphatase 4 catalytic subunit 1 [Toxocara canis]	diamond	3972	60.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
32065379	32065379	PRJNA169559_P_NODE_34698_length_248_cov_2.223744_g32621_i0	PRJNA169559	34698	248	2.223744	5.51488512	Toxocara canis	6265	Nematoda	Nematoda	43.1	0.00317	NR	KHN86868.1	6265	g32621	i0	73.1	0.943548387096774	26	7	31.5	0	3	80	2	27	KHN86868.1 H/ACA ribonucleoprotein complex subunit 3 [Toxocara canis]	diamond	234	43.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis

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