metadata: contig_metadata: 8 rows where bioproject = "PRJNA1082072", tax_phylum = "Nematoda" and tax

8 rows where bioproject = "PRJNA1082072", tax_phylum = "Nematoda" and tax_superkingdom = "Eukaryota"

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
18044924	18044924	PRJNA1082072_P_NODE_1115_length_327_cov_1.161417_g1108_i0	PRJNA1082072	1115	327	1.161417	3.79783359	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	137	8.25e-28	NTclustered	gi\|150984457\|gb\|EF634871.1\|	452809	g1108	i0	81.395	16.0366972477064	172	28	52	3	2	171	160	329	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	5244	137	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
21419205	21419205	PRJNA1082072_P_NODE_1777_length_271_cov_1.146465_g1770_i0	PRJNA1082072	1777	271	1.146465	3.10692015	Metazoa	33208	Nematoda	Nematoda	243	1.37e-59	NTclustered	gi\|1376147859\|ref\|XM_024654603.1\|	34506	g1770	i0	83.459	159.575645756458	266	38	98	5	3	265	175	437	Strongyloides ratti Polyubiquitin-C (SRAE_2000341300), partial mRNA	blastn	43245	243	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
26718927	26718927	PRJNA1082072_P_NODE_2561_length_246_cov_0.890173_g2554_i0	PRJNA1082072	2561	246	0.890173	2.18982558	Caenorhabditis elegans	6239	Nematoda	Nematoda	47.8	5.33e-4	NR	NP_001293573.1	6239	g2554	i0	38.5	0.792682926829268	65	39	79.3	1	195	1	68	131	NP_001293573.1 Peptidase C1A papain C-terminal domain-containing protein [Caenorhabditis elegans]	diamond	195	47.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
27541529	27541529	PRJNA1082072_P_NODE_944_length_347_cov_1.065693_g937_i0	PRJNA1082072	944	347	1.065693	3.69795471	Enterobius vermicularis	51028	Nematoda	Nematoda	78.6	2.46e-14	NR	VDD90801.1	51028	g937	i0	54.5	0.570605187319885	66	30	57.1	0	328	131	236	301	VDD90801.1 unnamed protein product [Enterobius vermicularis]	diamond	198	78.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis
27604776	27604776	PRJNA1082072_P_NODE_1904_length_262_cov_1.423280_g1897_i0	PRJNA1082072	1904	262	1.42328	3.7289936	Aphelenchoides besseyi	269767	Nematoda	Nematoda	104	3.57e-24	NR	KAI6205030.1	269767	g1897	i0	77	1.48854961832061	61	14	69.8	0	80	262	21	81	KAI6205030.1 Legumain [Aphelenchoides besseyi]	diamond	390	104	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
28235801	28235801	PRJNA1082072_P_NODE_186_length_679_cov_1.268977_g179_i0	PRJNA1082072	186	679	1.268977	8.61635383	Heterodera trifolii	157864	Nematoda	Nematoda	152	5.48e-41	NR	KAL3073343.1	157864	g179	i0	42.2	3.43740795287187	192	111	84.8	0	13	588	75	266	KAL3073343.1 hypothetical protein niasHT_038700 [Heterodera trifolii]	diamond	2334	152	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii
28795651	28795651	PRJNA1082072_P_NODE_1167_length_320_cov_1.246964_g1160_i0	PRJNA1082072	1167	320	1.246964	3.9902848	root	1	Root_unresolved	Root_unresolved	146	1.62e-42	NR	CDW60131.1	36087	g1160	i0	63.2	1.9875	106	39	99.4	0	319	2	6	111	CDW60131.1 60S ribosomal protein L27a [Trichuris trichiura]	diamond	636	147	0.993197278911565	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
29562052	29562052	PRJNA1082072_P_NODE_930_length_348_cov_1.538182_g923_i0	PRJNA1082072	930	348	1.538182	5.35287336	Pristionchus mayeri	1317129	Nematoda	Nematoda	43.1	0.0297	NR	GMR59216.1	1317129	g923	i0	42	0.698275862068966	81	44	69.8	1	104	346	40	117	GMR59216.1 hypothetical protein PMAYCL1PPCAC_29411, partial [Pristionchus mayeri]	diamond	243	43.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus mayeri

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