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

10 rows where analysis = "diamond", bioproject = "PRJNA1097627" 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
27067551	27067551	PRJNA1097627_P_NODE_10142_length_432_cov_1.749304_g9853_i0	PRJNA1097627	10142	432	1.749304	7.55699328	Trichinella pseudospiralis	6337	Nematoda	Nematoda	43.9	0.00771	NR	KRY63622.1	6337	g9853	i0	44.9	0.340277777777778	49	8	20.8	1	167	78	13	61	KRY63622.1 hypothetical protein T4D_13828 [Trichinella pseudospiralis]	diamond	147	43.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
27762890	27762890	PRJNA1097627_P_NODE_66184_length_299_cov_1.331858_g65891_i0	PRJNA1097627	66184	299	1.331858	3.98225542	Trichuris suis	68888	Nematoda	Nematoda	47.4	0.00157	NR	KFD59566.1	68888	g65891	i0	57.6	1.82608695652174	33	14	33.1	0	280	182	118	150	KFD59566.1 hypothetical protein M514_28257 [Trichuris suis]	diamond	546	47.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
27911563	27911563	PRJNA1097627_P_NODE_205125_length_240_cov_3.538922_g204832_i0	PRJNA1097627	205125	240	3.538922	8.4934128	Metazoa	33208	Nematoda	Nematoda	47.4	1.04e-4	NR	KRY06088.1	6334	g204832	i0	38.5	5.275	65	39	80	1	221	30	12	76	KRY06088.1 hypothetical protein T01_15180, partial [Trichinella spiralis]	diamond	1266	47.8	0.99163179916318	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
28101129	28101129	PRJNA1097627_P_NODE_169485_length_246_cov_0.890173_g169192_i0	PRJNA1097627	169485	246	0.890173	2.18982558	Rhabditida	6236	Nematoda	Nematoda	66.2	1.4e-11	NR	CDJ90700.1	6289	g169192	i0	73.7	3.70731707317073	38	10	46.3	0	208	95	1	38	CDJ90700.1 transposase [Haemonchus contortus]	diamond	912	66.6	0.993993993993994	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Haemonchus	Haemonchus contortus
29458632	29458632	PRJNA1097627_P_NODE_153450_length_249_cov_0.875000_g153157_i0	PRJNA1097627	153450	249	0.875	2.17875	Rhabditida	6236	Nematoda	Nematoda	50.4	1.79e-5	NR	VDK60415.1	6269	g153157	i0	54.5	1.06024096385542	44	16	48.2	1	190	71	1	44	VDK60415.1 unnamed protein product [Anisakis simplex]	diamond	264	50.8	0.992125984251969	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
31711176	31711176	PRJNA1097627_P_NODE_206657_length_234_cov_2.993789_g206364_i0	PRJNA1097627	206657	234	2.993789	7.00546626	Trichinella nativa	6335	Nematoda	Nematoda	49.3	1.55e-4	NR	KRZ59049.1	6335	g206364	i0	43.9	2.33333333333333	57	31	71.8	1	221	54	181	237	KRZ59049.1 Retrovirus-related Pol polyprotein from type-1 retrotransposable element [Trichinella nativa]	diamond	546	49.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nativa
31837482	31837482	PRJNA1097627_P_NODE_207237_length_232_cov_2.635220_g206944_i0	PRJNA1097627	207237	232	2.63522	6.1137104	Trichinella pseudospiralis	6337	Nematoda	Nematoda	40.4	0.018	NR	KRY62525.1	6337	g206944	i0	54.8	0.801724137931034	31	14	40.1	0	203	111	10	40	KRY62525.1 hypothetical protein T4D_14393 [Trichinella pseudospiralis]	diamond	186	40.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
32185804	32185804	PRJNA1097627_P_NODE_28258_length_354_cov_0.722420_g27967_i0	PRJNA1097627	28258	354	0.72242	2.5573668	Auanema sp. JU1783	2878363	Nematoda	Nematoda	51.2	1.14e-4	NR	CAI4221048.1	2878363	g27967	i0	71.9	1.13559322033898	32	9	27.1	0	9	104	117	148	CAI4221048.1 unnamed protein product [Auanema sp. JU1783]	diamond	402	51.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Auanema	Auanema sp. JU1783
32312575	32312575	PRJNA1097627_P_NODE_140079_length_251_cov_0.865169_g139786_i0	PRJNA1097627	140079	251	0.865169	2.17157419	Trichinella pseudospiralis	6337	Nematoda	Nematoda	46.2	1.98e-4	NR	KRY63622.1	6337	g139786	i0	43.4	1.26693227091633	53	30	63.3	0	43	201	10	62	KRY63622.1 hypothetical protein T4D_13828 [Trichinella pseudospiralis]	diamond	318	46.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
32533953	32533953	PRJNA1097627_P_NODE_204199_length_241_cov_0.916667_g203906_i0	PRJNA1097627	204199	241	0.916667	2.20916747	Meloidogyne enterolobii	390850	Nematoda	Nematoda	72.4	1.19e-12	NR	CAD2193769.1	390850	g203906	i0	46.9	1.00829875518672	81	40	98.3	2	2	238	126	205	CAD2193769.1 unnamed protein product [Meloidogyne enterolobii]	diamond	243	72.4	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);;