metadata: contig_metadata: 22 rows where bioproject = "PRJDB9741" and tax

22 rows where bioproject = "PRJDB9741" 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
10213752	10213752	PRJDB9741_P_NODE_33829_length_164_cov_0.886957_g33512_i0	PRJDB9741	33829	164	0.886957	1.45460948	Meloidogyne graminicola	189291	Nematoda	Nematoda	132	1.71e-26	NTclustered	gi\|2003945648\|gb\|MT259203.1\|	189291	g33512	i0	81.098	58.1768292682927	164	31	100	0	1	164	2161	2324	Meloidogyne graminicola voltage-dependent calcium channel non-L type alpha-1 mRNA, complete cds	blastn	9541	132	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
10213821	10213821	PRJDB9741_P_NODE_5789_length_261_cov_2.759434_g5473_i0	PRJDB9741	5789	261	2.759434	7.20212274	Pristionchus sp. 10 RS5133	452805	Nematoda	Nematoda	182	2.91e-41	NTclustered	gi\|150982023\|gb\|EF634600.1\|	452805	g5473	i0	90.511	12.6513409961686	137	13	52	0	124	260	392	256	Pristionchus sp. 10 RS5133 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	3302	182	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 10 RS5133
10213852	10213852	PRJDB9741_P_NODE_7889_length_224_cov_1.165714_g7572_i0	PRJDB9741	7889	224	1.165714	2.61119936	Neodiplogaster sp. WEM-2009	669148	Nematoda	Nematoda	154	5.3e-33	NTclustered	gi\|256709213\|gb\|GQ422259.1\|	669148	g7572	i0	88.06	36.9866071428571	134	11	58	4	32	161	135	3	Neodiplogaster sp. WEM-2009 small subunit ribosomal protein 28 (rps-28) mRNA, partial cds	blastn	8285	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Neodiplogaster	Neodiplogaster sp. WEM-2009
12764622	12764622	PRJDB9741_P_NODE_6691_length_242_cov_2.725389_g6374_i0	PRJDB9741	6691	242	2.725389	6.59544138	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	145	3.5e-30	NTclustered	gi\|150984457\|gb\|EF634871.1\|	452809	g6374	i0	80.203	26.4628099173554	197	35	81	3	1	195	135	329	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	6404	145	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
17862905	17862905	PRJDB9741_P_NODE_7675_length_227_cov_0.921348_g7358_i0	PRJDB9741	7675	227	0.921348	2.09145996	Pristionchus racemosae	1756234	Nematoda	Nematoda	80.5	9.27e-11	NTclustered	gi\|953064353\|gb\|KT188888.1\|	1756234	g7358	i0	85.897	10.352422907489	78	7	33	4	151	226	1923	1998	Pristionchus racemosae 28S ribosomal RNA gene, partial sequence	blastn	2350	80.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus racemosae
19136297	19136297	PRJDB9741_P_NODE_10656_length_202_cov_1.575163_g10339_i0	PRJDB9741	10656	202	1.575163	3.18182926	Caenorhabditis elegans	6239	Nematoda	Nematoda	230	7.569999999999998e-56	NTclustered	gi\|1972294218\|ref\|NM_001380754.2\|	6239	g10339	i0	89.944	86.2178217821782	179	17	89	1	24	202	1159	982	Caenorhabditis elegans Actin-3 (act-3), mRNA	blastn	17416	230	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19136496	19136496	PRJDB9741_P_NODE_3556_length_357_cov_1.581169_g3240_i0	PRJDB9741	3556	357	1.581169	5.64477333	Caenorhabditis remanei	31234	Nematoda	Nematoda	213	1.47e-50	NTclustered	gi\|2445362687\|ref\|XM_053726842.1\|	31234	g3240	i0	78.551	53.781512605042	345	58	94	11	1	337	763	427	Caenorhabditis remanei uncharacterized protein (GCK72_008464), partial mRNA	blastn	19200	213	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
21687560	21687560	PRJDB9741_P_NODE_34278_length_164_cov_0.886957_g33961_i0	PRJDB9741	34278	164	0.886957	1.45460948	Pristionchus sp. 14 RS5230	452808	Nematoda	Nematoda	139	1.02e-28	NTclustered	gi\|150984418\|gb\|EF634851.1\|	452808	g33961	i0	86.508	20.5975609756098	126	17	77	0	2	127	134	9	Pristionchus sp. 14 RS5230 small subunit ribosomal protein 1 (rps-1) mRNA, partial cds	blastn	3378	139	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 14 RS5230
26614862	26614862	PRJDB9741_P_NODE_39221_length_161_cov_1.642857_g38904_i0	PRJDB9741	39221	161	1.642857	2.64499977	Opisthokonta	33154	Nematoda	Nematoda	94	1.09e-20	NR	KAI3422602.1	36090	g38904	i0	76.9	74.6273291925466	52	12	96.9	0	160	5	285	336	KAI3422602.1 ATP-binding cassette sub- E member 1 [Globodera pallida]	diamond	12015	94	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Globodera	Globodera pallida
27064096	27064096	PRJDB9741_P_NODE_2182_length_508_cov_0.991285_g1870_i0	PRJDB9741	2182	508	0.991285	5.0357278	Meloidogyne graminicola	189291	Nematoda	Nematoda	54.3	3.51e-5	NR	AVZ46778.1	189291	g1870	i0	40.7	0.478346456692913	81	48	47.8	0	244	2	117	197	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	243	54.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
27221950	27221950	PRJDB9741_P_NODE_32243_length_165_cov_0.879310_g31926_i0	PRJDB9741	32243	165	0.87931	1.4508615	Diploscapter pachys	2018661	Nematoda	Nematoda	94	7.85e-22	NR	PAV77790.1	2018661	g31926	i0	88.9	0.981818181818182	54	6	98.2	0	2	163	176	229	PAV77790.1 hypothetical protein WR25_10987 [Diploscapter pachys]	diamond	162	94	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys
27412042	27412042	PRJDB9741_P_NODE_1023_length_854_cov_2.592547_g786_i0	PRJDB9741	1023	854	2.592547	22.14035138	Meloidogyne graminicola	189291	Nematoda	Nematoda	114	7.480000000000001e-26	NR	AVZ46778.1	189291	g786	i0	51.5	0.470725995316159	134	62	46.7	2	616	218	117	248	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	402	114	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
28295768	28295768	PRJDB9741_P_NODE_30426_length_166_cov_0.871795_g30109_i0	PRJDB9741	30426	166	0.871795	1.4471797	Prionchulus punctatus	293874	Nematoda	Nematoda	61.2	1.02e-9	NR	ADK34019.1	293874	g30109	i0	65	2.80120481927711	40	14	72.3	0	166	47	115	154	ADK34019.1 ubiquitin-Like family 1 [Prionchulus punctatus]	diamond	465	61.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Mononchida	Mononchidae	Prionchulus	Prionchulus punctatus
28321412	28321412	PRJDB9741_P_NODE_36386_length_163_cov_0.894737_g36069_i0	PRJDB9741	36386	163	0.894737	1.45842131	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	81.6	2.21e-16	NR	TMS38419.1	34508	g36069	i0	67.9	23.4110429447853	53	17	97.5	0	161	3	66	118	TMS38419.1 hypothetical protein L596_005149 [Steinernema carpocapsae]	diamond	3816	81.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
28921221	28921221	PRJDB9741_P_NODE_18188_length_181_cov_1.537879_g17871_i0	PRJDB9741	18188	181	1.537879	2.78356099	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.9	1.06e-4	NR	GMR59931.1	1317129	g17871	i0	43.2	2.1878453038674	44	25	72.9	0	29	160	275	318	GMR59931.1 hypothetical protein PMAYCL1PPCAC_30126, partial [Pristionchus mayeri]	diamond	396	49.3	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus mayeri
29022442	29022442	PRJDB9741_P_NODE_10848_length_200_cov_2.192053_g10531_i0	PRJDB9741	10848	200	2.192053	4.384106	Diploscapter pachys	2018661	Nematoda	Nematoda	52.8	1.46e-6	NR	PAV88325.1	2018661	g10531	i0	42.4	4.5	66	38	99	0	200	3	68	133	PAV88325.1 hypothetical protein WR25_07571 [Diploscapter pachys]	diamond	900	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys
29243144	29243144	PRJDB9741_P_NODE_37409_length_162_cov_1.353982_g37092_i0	PRJDB9741	37409	162	1.353982	2.19345084	Angiostrongylus cantonensis	6313	Nematoda	Nematoda	73.6	1.11e-13	NR	KAE9415342.1	6313	g37092	i0	58.5	1.96296296296296	53	20	98.1	1	161	3	159	209	KAE9415342.1 hypothetical protein Angca_010209, partial [Angiostrongylus cantonensis]	diamond	318	73.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Angiostrongylus	Angiostrongylus cantonensis
29363531	29363531	PRJDB9741_P_NODE_18969_length_180_cov_1.167939_g18652_i0	PRJDB9741	18969	180	1.167939	2.1022902	Caenorhabditis	6237	Nematoda	Nematoda	69.3	6.62e-12	NR	CAI5445746.1	860376	g18652	i0	73.3	10.2333333333333	45	12	75	0	136	2	544	588	CAI5445746.1 unnamed protein product [Caenorhabditis angaria]	diamond	1842	69.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis angaria
30121206	30121206	PRJDB9741_P_NODE_5092_length_282_cov_1.304721_g4776_i0	PRJDB9741	5092	282	1.304721	3.67931322	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	172	8.29e-51	NR	NP_001256250.1	6239	g4776	i0	80.6	143.436170212766	93	18	98.9	0	3	281	182	274	NP_001256250.1 Serine/threonine-protein phosphatase PP1-alpha [Caenorhabditis elegans]	diamond	40449	172	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
30790805	30790805	PRJDB9741_P_NODE_24574_length_171_cov_1.262295_g24257_i0	PRJDB9741	24574	171	1.262295	2.15852445	Caenorhabditis elegans	6239	Nematoda	Nematoda	67	9.13e-12	NR	NP_001379064.1	6239	g24257	i0	81.8	0.771929824561403	44	8	77.2	0	169	38	159	202	NP_001379064.1 Large ribosomal subunit protein uL13 [Caenorhabditis elegans]	diamond	132	67	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
31669985	31669985	PRJDB9741_P_NODE_17157_length_183_cov_1.231343_g16840_i0	PRJDB9741	17157	183	1.231343	2.25335769	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	111	1.97e-30	NR	CDW60316.1	36087	g16840	i0	83.1	18.5901639344262	59	10	96.7	0	3	179	10	68	CDW60316.1 Ribosomal protein L37 [Trichuris trichiura]	diamond	3402	112	0.991071428571429	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
31764891	31764891	PRJDB9741_P_NODE_897_length_917_cov_2.013825_g682_i0	PRJDB9741	897	917	2.013825	18.46677525	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	248	3.06e-77	NR	CAD5210754.1	465554	g682	i0	54.9	1.4721919302072	226	101	73.9	1	916	239	55	279	CAD5210754.1 unnamed protein product [Bursaphelenchus okinawaensis]	diamond	1350	250	0.992	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus okinawaensis

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