metadata: contig_metadata: 10 rows where bioproject = "PRJNA1086823", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA1086823", 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
9121339	9121339	PRJNA1086823_P_NODE_1428_length_624_cov_4.762250_g1315_i0	PRJNA1086823	1428	624	4.76225	29.71644	Basiria sp. SAN-2005	345476	Nematoda	Nematoda	174	1.27e-38	NTclustered	gi\|76560642\|gb\|DQ145667.1\|	345476	g1315	i0	94.69	19.2820512820513	113	5	35	1	486	598	794	905	Basiria sp. SAN-2005 28S ribosomal RNA gene, partial sequence	blastn	12032	174	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylenchidae	Basiria	Basiria sp. SAN-2005
11672506	11672506	PRJNA1086823_P_NODE_3610_length_409_cov_0.925595_g3493_i0	PRJNA1086823	3610	409	0.925595	3.78568355	Rhabditida	6236	Nematoda	Nematoda	196	2.65e-58	NR	VDD93579.1	51028	g3493	i0	72.9	11.3545232273839	129	35	94.6	0	3	389	314	442	VDD93579.1 unnamed protein product [Enterobius vermicularis]	diamond	4644	196	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis
14222473	14222473	PRJNA1086823_P_NODE_17132_length_245_cov_0.906977_g17015_i0	PRJNA1086823	17132	245	0.906977	2.22209365	Metazoa	33208	Nematoda	Nematoda	106	3.62e-26	NR	XP_003372739.1	6334	g17015	i0	63	18.8448979591837	81	30	99.2	0	3	245	109	189	XP_003372739.1 EF hand domain containing protein [Trichinella spiralis]	diamond	4617	106	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
18045462	18045462	PRJNA1086823_P_NODE_15715_length_247_cov_0.896552_g15598_i0	PRJNA1086823	15715	247	0.896552	2.21448344	Caenorhabditis elegans	6239	Nematoda	Nematoda	457	4.05e-124	NTclustered	gi\|1972230063\|ref\|NM_001025922.6\|	6239	g15598	i0	100	9.04858299595142	247	0	100	0	1	247	1063	817	Caenorhabditis elegans Protein unc-87 (unc-87), mRNA	blastn	2235	457	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
27058948	27058948	PRJNA1086823_P_NODE_9722_length_275_cov_1.539604_g9605_i0	PRJNA1086823	9722	275	1.539604	4.233911	Metazoa	33208	Nematoda	Nematoda	84.3	3.81e-19	NR	KAL4003849.1	6277	g9605	i0	72	9.27272727272727	50	14	54.5	0	3	152	5	54	KAL4003849.1 Ribosomal protein S14p/S29e family protein [Acanthocheilonema viteae]	diamond	2550	84.7	0.995277449822904	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
28078128	28078128	PRJNA1086823_P_NODE_13665_length_251_cov_0.876404_g13548_i0	PRJNA1086823	13665	251	0.876404	2.19977404	Mesorhabditis spiculigera	96644	Nematoda	Nematoda	56.2	6.77e-7	NR	CAJ0579977.1	96644	g13548	i0	37.7	0.920318725099602	77	43	86.1	1	25	240	64	140	CAJ0579977.1 unnamed protein product, partial [Mesorhabditis spiculigera]	diamond	231	56.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Mesorhabditis	Mesorhabditis spiculigera
29372784	29372784	PRJNA1086823_P_NODE_6169_length_327_cov_1.228346_g6052_i0	PRJNA1086823	6169	327	1.228346	4.01669142	Auanema sp. JU1783	2878363	Nematoda	Nematoda	149	8.73e-41	NR	CAI4230971.1	2878363	g6052	i0	56.5	5.94495412844037	108	47	99.1	0	3	326	85	192	CAI4230971.1 unnamed protein product [Auanema sp. JU1783]	diamond	1944	149	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Auanema	Auanema sp. JU1783
29395778	29395778	PRJNA1086823_P_NODE_8929_length_283_cov_1.485714_g8812_i0	PRJNA1086823	8929	283	1.485714	4.20457062	root	1	Root_unresolved	Root_unresolved	57.8	1.36e-7	NR	VDK19771.1	6269	g8812	i0	51.8	2.71378091872792	56	25	57.2	1	167	6	113	168	VDK19771.1 unnamed protein product [Anisakis simplex]	diamond	768	57.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
29814707	29814707	PRJNA1086823_P_NODE_8511_length_287_cov_1.822430_g8394_i0	PRJNA1086823	8511	287	1.82243	5.2303741	Anisakis simplex	6269	Nematoda	Nematoda	65.9	1.77e-11	NR	VDK28727.1	6269	g8394	i0	47.2	0.752613240418119	72	35	72.1	1	80	286	31	102	VDK28727.1 unnamed protein product [Anisakis simplex]	diamond	216	65.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
31616100	31616100	PRJNA1086823_P_NODE_13716_length_251_cov_0.876404_g13599_i0	PRJNA1086823	13716	251	0.876404	2.19977404	Meloidogyne enterolobii	390850	Nematoda	Nematoda	44.3	0.0114	NR	CAD2198191.1	390850	g13599	i0	35.1	1.76892430278884	77	46	87.3	1	244	26	300	376	CAD2198191.1 unnamed protein product [Meloidogyne enterolobii]	diamond	444	44.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);;