metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA835051" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA835051" 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
27371001	27371001	PRJNA835051_S_NODE_56203_length_209_cov_1.030120_g55907_i0	PRJNA835051	56203	209	1.03012	2.1529508	Trichuris suis	68888	Nematoda	Nematoda	58.9	4.58e-8	NR	KFD62493.1	68888	g55907	i0	50.7	0.961722488038278	67	33	96.2	0	207	7	175	241	KFD62493.1 hypothetical protein M514_25343 [Trichuris suis]	diamond	201	58.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
27749874	27749874	PRJNA835051_S_NODE_96284_length_172_cov_1.348837_g95988_i0	PRJNA835051	96284	172	1.348837	2.31999964	Trichuris suis	68888	Nematoda	Nematoda	41.6	0.0377	NR	KFD61177.1	68888	g95988	i0	57.5	2.09302325581395	40	10	69.8	1	1	120	227	259	KFD61177.1 hypothetical protein M514_26664, partial [Trichuris suis]	diamond	360	41.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
28096912	28096912	PRJNA835051_S_NODE_89185_length_177_cov_1.776119_g88889_i0	PRJNA835051	89185	177	1.776119	3.14373063	Haemonchus placei	6290	Nematoda	Nematoda	41.6	0.0389	NR	VDO27182.1	6290	g88889	i0	36.6	0.694915254237288	41	26	69.5	0	124	2	66	106	VDO27182.1 unnamed protein product [Haemonchus placei]	diamond	123	41.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Haemonchus	Haemonchus placei
29485949	29485949	PRJNA835051_S_NODE_55030_length_210_cov_1.982036_g54734_i0	PRJNA835051	55030	210	1.982036	4.1622756	Caenorhabditis brenneri	135651	Nematoda	Nematoda	43.5	0.0125	NR	EGT53486.1	135651	g54734	i0	43.1	0.728571428571429	51	28	71.4	1	3	152	238	288	EGT53486.1 hypothetical protein CAEBREN_30893 [Caenorhabditis brenneri]	diamond	153	43.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri
29896787	29896787	PRJNA835051_S_NODE_116571_length_158_cov_3.886957_g116275_i0	PRJNA835051	116571	158	3.886957	6.14139206	Ancylostoma ceylanicum	53326	Nematoda	Nematoda	39.3	0.0371	NR	EYC18236.1	53326	g116275	i0	51.5	0.626582278481013	33	16	62.7	0	23	121	6	38	EYC18236.1 hypothetical protein Y032_0028g1752 [Ancylostoma ceylanicum]	diamond	99	39.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma ceylanicum
31160074	31160074	PRJNA835051_S_NODE_29575_length_251_cov_1.639423_g29279_i0	PRJNA835051	29575	251	1.639423	4.11495173	Trichinella papuae	268474	Nematoda	Nematoda	67.8	6.78e-13	NR	KRZ64190.1	268474	g29279	i0	65.4	0.621513944223108	52	18	62.2	0	1	156	14	65	KRZ64190.1 hypothetical protein T10_11819 [Trichinella papuae]	diamond	156	67.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella papuae
32299606	32299606	PRJNA835051_S_NODE_53539_length_212_cov_1.692308_g53243_i0	PRJNA835051	53539	212	1.692308	3.58769296	Trichinella pseudospiralis	6337	Nematoda	Nematoda	40	0.0363	NR	KRY77954.1	6337	g53243	i0	45.9	0.523584905660377	37	20	52.4	0	171	61	18	54	KRY77954.1 hypothetical protein T4A_5545 [Trichinella pseudospiralis]	diamond	111	40	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis

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