metadata: contig_metadata: 16 rows where bioproject = "PRJNA951810", tax_kingdom = "Metazoa" and tax

16 rows where bioproject = "PRJNA951810", tax_kingdom = "Metazoa" 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
1263643	1263643	PRJNA951810_P_NODE_30121_length_365_cov_1.924658_g29779_i0	PRJNA951810	30121	365	1.924658	7.0250017	Caenorhabditis	6237	Nematoda	Nematoda	272	2.4399999999999993e-68	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g29779	i0	87.395	64.7041095890411	238	28	65	2	1	237	1071	1307	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	23617	272	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
7641226	7641226	PRJNA951810_P_NODE_150086_length_258_cov_2.227027_g149741_i0	PRJNA951810	150086	258	2.227027	5.74572966	Opisthokonta	33154	Nematoda	Nematoda	209	1.32e-49	NTclustered	gi\|2707541074\|ref\|XM_013442878.2\|	51031	g149741	i0	81.323	54.2480620155039	257	48	99	0	1	257	970	1226	Necator americanus uncharacterized protein (RB195_004942), partial mRNA	blastn	13996	209	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
8589578	8589578	PRJNA951810_P_NODE_175287_length_237_cov_4.615854_g174942_i0	PRJNA951810	175287	237	4.615854	10.93957398	Caenorhabditis briggsae	6238	Nematoda	Nematoda	167	7.279999999999999e-37	NTclustered	gi\|2158424922\|ref\|XM_045237347.1\|	6238	g174942	i0	80	9.57805907172996	235	40	98	7	5	236	1927	2157	Caenorhabditis briggsae Protein CBR-EFT-2 (Cbr-eft-2), partial mRNA	blastn	2270	167	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
11467254	11467254	PRJNA951810_P_NODE_186029_length_224_cov_5.357616_g185684_i0	PRJNA951810	186029	224	5.357616	12.00105984	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	139	6.97e-39	NR	OUC39642.1	6335	g185684	i0	85.1	14.8258928571429	74	11	99.1	0	224	3	144	217	OUC39642.1 putative isocitrate dehydrogenase, NADP-dependent [Trichinella nativa]	diamond	3321	139	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nativa
13690687	13690687	PRJNA951810_P_NODE_24511_length_406_cov_3.915916_g24171_i0	PRJNA951810	24511	406	3.915916	15.89861896	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.11e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g24171	i0	81.492	5.14285714285714	362	61	88	6	4	362	37	395	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2088	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
16238965	16238965	PRJNA951810_P_NODE_150273_length_258_cov_1.281081_g149928_i0	PRJNA951810	150273	258	1.281081	3.30518898	Caenorhabditis elegans	6239	Nematoda	Nematoda	477	3.2699999999999985e-130	NTclustered	gi\|1734336796\|ref\|NM_074105.4\|	6239	g149928	i0	100	3.0077519379845	258	0	100	0	1	258	370	113	Caenorhabditis elegans Carboxylic ester hydrolase (cest-1.1), mRNA	blastn	776	477	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
23887667	23887667	PRJNA951810_P_NODE_100059_length_293_cov_2.827273_g99715_i0	PRJNA951810	100059	293	2.827273	8.28390989	Strongyloides ratti	34506	Nematoda	Nematoda	213	1.18e-50	NTclustered	gi\|1376148845\|ref\|XM_024642710.1\|	34506	g99715	i0	80.212	10.740614334471	283	56	97	0	1	283	351	633	Strongyloides ratti Tubulin beta-2A chain (SRAE_2000390300), partial mRNA	blastn	3147	213	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
23889335	23889335	PRJNA951810_P_NODE_197319_length_198_cov_5.248000_g196974_i0	PRJNA951810	197319	198	5.248	10.39104	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	120	1.07e-29	NR	VDO92826.1	241478	g196974	i0	81.5	8.86363636363636	65	12	98.5	0	196	2	31	95	VDO92826.1 unnamed protein product [Soboliphyme baturini]	diamond	1755	121	0.991735537190083	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini
26740456	26740456	PRJNA951810_P_NODE_89801_length_297_cov_6.620536_g89457_i0	PRJNA951810	89801	297	6.620536	19.66299192	Pristionchus entomophagus	358040	Nematoda	Nematoda	43.5	0.0361	NR	GMS87734.1	358040	g89457	i0	64.5	0.313131313131313	31	11	31.3	0	200	292	12	42	GMS87734.1 hypothetical protein PENTCL1PPCAC_9909, partial [Pristionchus entomophagus]	diamond	93	43.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus entomophagus
28857196	28857196	PRJNA951810_P_NODE_171608_length_241_cov_2.744048_g171263_i0	PRJNA951810	171608	241	2.744048	6.61315568	Heligmosomoides polygyrus	6339	Nematoda	Nematoda	52.8	5.79e-6	NR	VDO29924.1	6339	g171263	i0	38.7	1.54356846473029	62	28	77.2	1	56	241	80	131	VDO29924.1 unnamed protein product [Heligmosomoides polygyrus]	diamond	372	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heligmosomidae	Heligmosomoides	Heligmosomoides polygyrus
29583307	29583307	PRJNA951810_P_NODE_64410_length_310_cov_2.919831_g64067_i0	PRJNA951810	64410	310	2.919831	9.0514761	Caenorhabditis brenneri	135651	Nematoda	Nematoda	94.4	1.71e-20	NR	EGT44071.1	135651	g64067	i0	75.5	1.40322580645161	49	12	47.4	0	161	307	285	333	EGT44071.1 hypothetical protein CAEBREN_13576 [Caenorhabditis brenneri]	diamond	435	94.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri
30342192	30342192	PRJNA951810_P_NODE_1792_length_1298_cov_23.908571_g1653_i0	PRJNA951810	1792	1298	23.908571	310.33325158	Ostertagia ostertagi	6317	Nematoda	Nematoda	126	4.42e-28	NR	KAK6031674.1	6317	g1653	i0	47.5	0.568567026194145	122	64	28.2	0	1271	906	281	402	KAK6031674.1 hypothetical protein OSTOST_02186 [Ostertagia ostertagi]	diamond	738	126	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Ostertagia	Ostertagia ostertagi
30720714	30720714	PRJNA951810_P_NODE_197034_length_199_cov_4.150794_g196689_i0	PRJNA951810	197034	199	4.150794	8.26008006	Heterodera schachtii	97005	Nematoda	Nematoda	47.4	4.62e-4	NR	KAL3083467.1	97005	g196689	i0	44.6	1.64321608040201	56	30	84.4	1	176	9	62	116	KAL3083467.1 hypothetical protein niasHS_011269 [Heterodera schachtii]	diamond	327	47.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera schachtii
31043539	31043539	PRJNA951810_P_NODE_147595_length_260_cov_1.828877_g147250_i0	PRJNA951810	147595	260	1.828877	4.7550802	Caenorhabditis	6237	Nematoda	Nematoda	95.1	9.099999999999997e-24	NR	NP_001379573.1	6239	g147250	i0	73.6	4.25769230769231	53	14	61.2	0	218	60	3	55	NP_001379573.1 Small ribosomal subunit protein uS14 [Caenorhabditis elegans]	diamond	1107	95.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
31960315	31960315	PRJNA951810_P_NODE_58497_length_310_cov_3.818565_g58154_i0	PRJNA951810	58497	310	3.818565	11.8375515	Trichinella	6333	Nematoda	Nematoda	57.4	5.8e-7	NR	XP_003375803.1	6334	g58154	i0	47.9	3.71612903225806	48	25	46.5	0	165	308	451	498	XP_003375803.1 DnaJ protein [Trichinella spiralis]	diamond	1152	57.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
32112037	32112037	PRJNA951810_P_NODE_119838_length_280_cov_3.338164_g119493_i0	PRJNA951810	119838	280	3.338164	9.3468592	Meloidogyne enterolobii	390850	Nematoda	Nematoda	49.3	2.77e-4	NR	CAD2167694.1	390850	g119493	i0	45.8	0.942857142857143	48	26	51.4	0	218	75	16	63	CAD2167694.1 unnamed protein product [Meloidogyne enterolobii]	diamond	264	49.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii

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