metadata: contig_metadata: 6 rows where bioproject = "PRJNA1111448", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA1111448", tax_clade = "Opisthokonta" 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
12971438	12971438	PRJNA1111448_S_NODE_131031_length_245_cov_1.343023_g130208_i0	PRJNA1111448	131031	245	1.343023	3.29040635	Rhabditida	6236	Nematoda	Nematoda	139	5.49e-38	NR	CAR63627.1	6313	g130208	i0	78.5	20.3142857142857	79	17	96.7	0	245	9	252	330	CAR63627.1 putative Elongation FacTor, partial [Angiostrongylus cantonensis]	diamond	4977	140	0.992857142857143	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Angiostrongylus	Angiostrongylus cantonensis
26656074	26656074	PRJNA1111448_S_NODE_117361_length_254_cov_1.226519_g116538_i0	PRJNA1111448	117361	254	1.226519	3.11535826	Pristionchus mayeri	1317129	Nematoda	Nematoda	42.4	0.0225	NR	GMR61264.1	1317129	g116538	i0	39.7	0.803149606299213	68	37	75.6	2	48	239	38	105	GMR61264.1 hypothetical protein PMAYCL1PPCAC_31459, partial [Pristionchus mayeri]	diamond	204	42.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus mayeri
27280393	27280393	PRJNA1111448_S_NODE_91463_length_281_cov_2.274038_g90640_i0	PRJNA1111448	91463	281	2.274038	6.39004678	Opisthokonta	33154	Nematoda	Nematoda	98.2	3.3400000000000003e-22	NR	TKR82648.1	34508	g90640	i0	47.8	3.98220640569395	92	47	97.2	1	274	2	223	314	TKR82648.1 hypothetical protein L596_016339 [Steinernema carpocapsae]	diamond	1119	99	0.991919191919192	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
28259017	28259017	PRJNA1111448_S_NODE_22166_length_451_cov_4.701058_g21344_i0	PRJNA1111448	22166	451	4.701058	21.20177158	Trichinella	6333	Nematoda	Nematoda	100	2.6e-21	NR	KRX18751.1	6336	g21344	i0	39.1	4.31707317073171	169	69	99.1	5	451	5	674	828	KRX18751.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Trichinella nelsoni]	diamond	1947	100	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nelsoni
29238112	29238112	PRJNA1111448_S_NODE_54529_length_338_cov_1.943396_g53706_i0	PRJNA1111448	54529	338	1.943396	6.56867848	Metazoa	33208	Nematoda	Nematoda	100	7.3e-23	NR	KRY05871.1	990121	g53706	i0	42.3	4.92603550295858	111	63	98.5	1	4	336	32	141	KRY05871.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94, partial [Trichinella patagoniensis]	diamond	1665	100	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella patagoniensis
29404691	29404691	PRJNA1111448_S_NODE_95509_length_277_cov_0.970588_g94686_i0	PRJNA1111448	95509	277	0.970588	2.68852876	Trichinella nelsoni	6336	Nematoda	Nematoda	43.1	0.00561	NR	KRX26394.1	6336	g94686	i0	48.6	0.40072202166065	37	19	40.1	0	116	6	13	49	KRX26394.1 hypothetical protein T07_3765 [Trichinella nelsoni]	diamond	111	43.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nelsoni

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