metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA951810" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA951810" 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
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
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);;