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

10 rows where analysis = "diamond", bioproject = "PRJEB25789" 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
27475578	27475578	PRJEB25789_S_NODE_6123_length_368_cov_1.667797_g6044_i0	PRJEB25789	6123	368	1.667797	6.13749296	Trichuris trichiura	36087	Nematoda	Nematoda	81.3	4.83e-15	NR	CDW56655.1	36087	g6044	i0	49.4	1.92391304347826	83	37	65.2	3	308	69	277	357	CDW56655.1 hypothetical protein TTRE_0000493701 [Trichuris trichiura]	diamond	708	81.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
28170226	28170226	PRJEB25789_S_NODE_11366_length_291_cov_1.316514_g11287_i0	PRJEB25789	11366	291	1.316514	3.83105574	Trichuris suis	68888	Nematoda	Nematoda	77.8	3.22e-14	NR	KFD71631.1	68888	g11287	i0	44.8	0.896907216494845	87	40	89.7	1	26	286	1622	1700	KFD71631.1 hypothetical protein M514_05347 [Trichuris suis]	diamond	261	77.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
28770053	28770053	PRJEB25789_S_NODE_8147_length_329_cov_2.222656_g8068_i0	PRJEB25789	8147	329	2.222656	7.31253824	Trichuris trichiura	36087	Nematoda	Nematoda	86.7	3.36e-17	NR	CDW52980.1	36087	g8068	i0	50	1.38601823708207	90	38	81.2	3	321	55	6	89	CDW52980.1 hypothetical protein TTRE_0000124301 [Trichuris trichiura]	diamond	456	86.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
29590687	29590687	PRJEB25789_S_NODE_11470_length_290_cov_1.175115_g11391_i0	PRJEB25789	11470	290	1.175115	3.4078335	Meloidogyne enterolobii	390850	Nematoda	Nematoda	43.1	0.0482	NR	CAK5069761.1	390850	g11391	i0	31	1.8	87	54	89	3	31	288	728	809	CAK5069761.1 unnamed protein product [Meloidogyne enterolobii]	diamond	522	43.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
30152873	30152873	PRJEB25789_S_NODE_10312_length_302_cov_1.008734_g10233_i0	PRJEB25789	10312	302	1.008734	3.04637668	Trichuris	36086	Nematoda	Nematoda	85.5	7.45e-17	NR	CDW58129.1	36087	g10233	i0	38	1.98675496688742	100	62	99.3	0	302	3	1445	1544	CDW58129.1 Vitellogenin N and VWD and DUF1943 domain contain ing protein [Trichuris trichiura]	diamond	600	85.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
30595306	30595306	PRJEB25789_S_NODE_12513_length_281_cov_0.961538_g12434_i0	PRJEB25789	12513	281	0.961538	2.70192178	Opisthokonta	33154	Nematoda	Nematoda	168	2.7800000000000002e-49	NR	KAF8366168.1	54126	g12434	i0	84.9	11.914590747331	93	14	99.3	0	281	3	233	325	KAF8366168.1 hypothetical protein PRIPAC_83997, partial [Pristionchus pacificus]	diamond	3348	168	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
30823065	30823065	PRJEB25789_S_NODE_2114_length_580_cov_2.339250_g2035_i0	PRJEB25789	2114	580	2.33925	13.56765	Trichuris trichiura	36087	Nematoda	Nematoda	195	1.6699999999999998e-57	NR	CDW61263.1	36087	g2035	i0	54.4	1.96551724137931	182	62	91	5	53	580	107	273	CDW61263.1 hypothetical protein TTRE_0000971101 [Trichuris trichiura]	diamond	1140	195	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
31322198	31322198	PRJEB25789_S_NODE_8655_length_322_cov_0.927711_g8576_i0	PRJEB25789	8655	322	0.927711	2.98722942	Trichuris	36086	Nematoda	Nematoda	137	4.15e-35	NR	CDW58129.1	36087	g8576	i0	71.4	1.82608695652174	98	28	91.3	0	12	305	123	220	CDW58129.1 Vitellogenin N and VWD and DUF1943 domain contain ing protein [Trichuris trichiura]	diamond	588	137	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
31676534	31676534	PRJEB25789_S_NODE_15197_length_260_cov_1.016043_g15118_i0	PRJEB25789	15197	260	1.016043	2.6417118	Trichuris suis	68888	Nematoda	Nematoda	60.5	2.7e-8	NR	KFD71631.1	68888	g15118	i0	37.6	0.980769230769231	85	50	96.9	2	258	7	765	847	KFD71631.1 hypothetical protein M514_05347 [Trichuris suis]	diamond	255	60.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
31708266	31708266	PRJEB25789_S_NODE_15797_length_256_cov_1.262295_g15718_i0	PRJEB25789	15797	256	1.262295	3.2314752	Trichuris trichiura	36087	Nematoda	Nematoda	84	1.42e-16	NR	CDW58129.1	36087	g15718	i0	51.8	1.9921875	85	39	99.6	1	256	2	899	981	CDW58129.1 Vitellogenin N and VWD and DUF1943 domain contain ing protein [Trichuris trichiura]	diamond	510	84	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura

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