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

10 rows where bioproject = "PRJNA753704", 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
16033671	16033671	PRJNA753704_P_NODE_21433_length_263_cov_3.115789_g21072_i0	PRJNA753704	21433	263	3.115789	8.19452507	Caenorhabditis elegans	6239	Nematoda	Nematoda	270	6.09e-68	NTclustered	gi\|1972235554\|ref\|NM_001025879.7\|	6239	g21072	i0	85.227	91.4182509505703	264	37	100	2	1	263	1079	1341	Caenorhabditis elegans Tubulin alpha-2 chain (tba-2), mRNA	blastn	24043	270	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
17309241	17309241	PRJNA753704_P_NODE_26934_length_245_cov_0.906977_g26573_i0	PRJNA753704	26934	245	0.906977	2.22209365	Caenorhabditis sp. 36 PRJEB53466	2970133	Nematoda	Nematoda	133	5.929999999999998e-35	NR	CAI2356785.1	2970133	g26573	i0	79	1.98367346938776	81	17	99.2	0	3	245	347	427	CAI2356785.1 unnamed protein product [Caenorhabditis sp. 36 PRJEB53466]	diamond	486	133	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis sp. 36 PRJEB53466
22408472	22408472	PRJNA753704_P_NODE_23898_length_252_cov_0.871508_g23537_i0	PRJNA753704	23898	252	0.871508	2.19620016	Caenorhabditis elegans	6239	Nematoda	Nematoda	403	5.4799999999999995e-108	NTclustered	gi\|1845979515\|ref\|NM_076129.6\|	6239	g23537	i0	99.107	2.22222222222222	224	2	89	0	29	252	2381	2158	Caenorhabditis elegans Exocyst complex component 1 (sec-3), mRNA	blastn	560	403	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
26989384	26989384	PRJNA753704_P_NODE_26662_length_246_cov_0.901734_g26301_i0	PRJNA753704	26662	246	0.901734	2.21826564	Caenorhabditis remanei	31234	Nematoda	Nematoda	80.9	1.17e-16	NR	EFP10617.1	31234	g26301	i0	48.1	2.89024390243902	79	40	95.1	1	242	9	95	173	EFP10617.1 hypothetical protein CRE_01159 [Caenorhabditis remanei]	diamond	711	80.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
27315791	27315791	PRJNA753704_P_NODE_26923_length_245_cov_0.906977_g26562_i0	PRJNA753704	26923	245	0.906977	2.22209365	Rhabditida	6236	Nematoda	Nematoda	94.4	2.67e-20	NR	KAH7731756.1	70226	g26562	i0	61.6	17.5102040816327	73	28	89.4	0	23	241	1015	1087	KAH7731756.1 adenylate cyclase type 9-like protein [Aphelenchoides avenae]	diamond	4290	95.1	0.992639327024185	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides avenae
28641955	28641955	PRJNA753704_P_NODE_18147_length_284_cov_0.938389_g17786_i0	PRJNA753704	18147	284	0.938389	2.66502476	root	1	Root_unresolved	Root_unresolved	101	1.26e-25	NR	PIO52994.1	45464	g17786	i0	69.8	2.74647887323944	63	19	66.5	0	279	91	1	63	PIO52994.1 WD domain, G-beta repeat protein [Teladorsagia circumcincta]	diamond	780	101	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Teladorsagia	Teladorsagia circumcincta
28789673	28789673	PRJNA753704_P_NODE_23227_length_254_cov_1.292818_g22866_i0	PRJNA753704	23227	254	1.292818	3.28375772	Anisakis simplex	6269	Nematoda	Nematoda	118	1e-30	NR	VDK52909.1	6269	g22866	i0	73.3	3.54330708661417	75	20	88.6	0	229	5	1	75	VDK52909.1 unnamed protein product [Anisakis simplex]	diamond	900	118	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
29494295	29494295	PRJNA753704_P_NODE_22210_length_259_cov_2.225806_g21849_i0	PRJNA753704	22210	259	2.225806	5.76483754	Rhabditida	6236	Nematoda	Nematoda	74.3	2.02e-13	NR	KAL3073343.1	157864	g21849	i0	44.2	1.99227799227799	86	48	99.6	0	258	1	157	242	KAL3073343.1 hypothetical protein niasHT_038700 [Heterodera trifolii]	diamond	516	74.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii
31822752	31822752	PRJNA753704_P_NODE_14477_length_314_cov_2.008299_g14116_i0	PRJNA753704	14477	314	2.008299	6.30605886	Trichuris trichiura	36087	Nematoda	Nematoda	63.2	3.78e-10	NR	CDW57552.1	36087	g14116	i0	49.2	1.72929936305732	61	31	58.3	0	1	183	62	122	CDW57552.1 Histone domain containing protein [Trichuris trichiura]	diamond	543	63.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
32054176	32054176	PRJNA753704_P_NODE_18218_length_283_cov_2.161905_g17857_i0	PRJNA753704	18218	283	2.161905	6.11819115	Rhabditida	6236	Nematoda	Nematoda	54.3	3.22e-6	NR	NP_001256413.1	6239	g17857	i0	100	112.484098939929	22	0	23.3	0	99	164	214	235	NP_001256413.1 Collagen triple helix repeat protein [Caenorhabditis elegans]	diamond	31833	54.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans

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