metadata: contig_metadata: 14 rows where bioproject = "PRJNA550047", tax_clade = "Opisthokonta" and tax

14 rows where bioproject = "PRJNA550047", 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
11325595	11325595	PRJNA550047_P_NODE_88849_length_345_cov_9.584559_g86889_i0	PRJNA550047	88849	345	9.584559	33.06672855	Pristionchus pacificus	54126	Nematoda	Nematoda	67.4	2.6e-10	NR	KAF8370508.1	54126	g86889	i0	40.7	4.72173913043478	113	30	94.8	2	18	344	54	133	KAF8370508.1 hypothetical protein PRIPAC_76937 [Pristionchus pacificus]	diamond	1629	67.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
11995488	11995488	PRJNA550047_P_NODE_448370_length_247_cov_16.298851_g446398_i0	PRJNA550047	448370	247	16.298851	40.25816197	Trichinella spiralis	6334	Nematoda	Nematoda	52.8	0.022	NTclustered	gi\|109716040\|gb\|AC188121.1\|	6334	g446398	i0	96.875	0.129554655870445	32	0	13	1	194	225	103062	103092	Trichinella spiralis chromosome UNK clone TS195-46H12, complete sequence	blastn	32	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
15149799	15149799	PRJNA550047_P_NODE_473852_length_239_cov_9.265060_g471879_i0	PRJNA550047	473852	239	9.26506	22.1434934	Oscheius	42476	Nematoda	Nematoda	442	1.0899999999999994e-119	NTclustered	gi\|158827543\|gb\|EU196009.1\|	141969	g471879	i0	100	89.7824267782427	239	0	100	0	1	239	644	882	Oscheius tipulae strain CEW1 18S ribosomal RNA gene, partial sequence	blastn	21458	442	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Oscheius	Oscheius tipulae
22192792	22192792	PRJNA550047_P_NODE_398378_length_265_cov_15.958333_g396406_i0	PRJNA550047	398378	265	15.958333	42.28958245	Necator americanus	51031	Nematoda	Nematoda	90.5	5.5e-19	NR	ETN79634.1	51031	g396406	i0	100	0.486792452830189	43	0	48.7	0	264	136	388	430	ETN79634.1 hypothetical protein NECAME_18089 [Necator americanus]	diamond	129	90.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
24073730	24073730	PRJNA550047_P_NODE_4779_length_844_cov_26.974060_g3266_i0	PRJNA550047	4779	844	26.97406	227.6610664	Metazoa	33208	Nematoda	Nematoda	942	0	NTclustered	gi\|1174020828\|gb\|KY887583.1\|	6293	g3266	i0	99.805	81.4632701421801	514	0	81	1	1	514	1147	635	Wuchereria bancrofti isolate AP10 small subunit ribosomal RNA gene, partial sequence	blastn	68755	950	0.991578947368421	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Wuchereria	Wuchereria bancrofti
26666237	26666237	PRJNA550047_P_NODE_257561_length_300_cov_6.074890_g255592_i0	PRJNA550047	257561	300	6.07489	18.22467	Brugia malayi	6279	Nematoda	Nematoda	43.5	0.0382	NR	CDP96015.1	6279	g255592	i0	31.9	0.72	72	48	72	1	14	229	286	356	CDP96015.1 Bm14719, isoform b [Brugia malayi]	diamond	216	43.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
27756443	27756443	PRJNA550047_P_NODE_372944_length_275_cov_20.777228_g370972_i0	PRJNA550047	372944	275	20.777228	57.137377	Opisthokonta	33154	Nematoda	Nematoda	53.5	2e-6	NR	KIH47578.1	51022	g370972	i0	38.2	3.34909090909091	76	32	79.6	2	219	1	2	65	KIH47578.1 hypothetical protein ANCDUO_22359 [Ancylostoma duodenale]	diamond	921	53.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma duodenale
27882421	27882421	PRJNA550047_P_NODE_223985_length_301_cov_9.276316_g222016_i0	PRJNA550047	223985	301	9.276316	27.92171116	Pristionchus	54125	Nematoda	Nematoda	45.1	0.0116	NR	GMS89523.1	358040	g222016	i0	53.8	1.64451827242525	39	18	38.9	0	158	274	102	140	GMS89523.1 hypothetical protein PENTCL1PPCAC_11698, partial [Pristionchus entomophagus]	diamond	495	45.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus entomophagus
28309959	28309959	PRJNA550047_P_NODE_567166_length_208_cov_7.970370_g565193_i0	PRJNA550047	567166	208	7.97037	16.5783696	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	131	8.39e-34	NR	KAE9550692.1	2598192	g565193	i0	95.7	0.995192307692308	69	3	99.5	0	1	207	117	185	KAE9550692.1 hypothetical protein FO519_006093 [Halicephalobus sp. NKZ332]	diamond	207	131	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
28594105	28594105	PRJNA550047_P_NODE_480887_length_237_cov_3.493902_g478914_i0	PRJNA550047	480887	237	3.493902	8.28054774	Necator americanus	51031	Nematoda	Nematoda	48.9	2.15e-4	NR	XP_064060924.1	51031	g478914	i0	45.5	1.81012658227848	44	24	55.7	0	136	5	281	324	XP_064060924.1 hypothetical protein RB195_014673 [Necator americanus]	diamond	429	48.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
30472054	30472054	PRJNA550047_P_NODE_286233_length_298_cov_11.702222_g284264_i0	PRJNA550047	286233	298	11.702222	34.87262156	Metazoa	33208	Nematoda	Nematoda	59.3	1.14e-8	NR	EYB92467.1	53326	g284264	i0	58.1	2.97986577181208	43	18	43.3	0	140	268	32	74	EYB92467.1 hypothetical protein Y032_0193g1383 [Ancylostoma ceylanicum]	diamond	888	59.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma ceylanicum
30535064	30535064	PRJNA550047_P_NODE_322353_length_294_cov_5.728507_g320383_i0	PRJNA550047	322353	294	5.728507	16.84181058	Metazoa	33208	Nematoda	Nematoda	55.8	1.74e-6	NR	KAF8375090.1	54126	g320383	i0	52.4	0.908163265306122	42	20	42.9	0	258	133	91	132	KAF8375090.1 hypothetical protein PRIPAC_81519 [Pristionchus pacificus]	diamond	267	56.2	0.99288256227758	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
30851050	30851050	PRJNA550047_P_NODE_576394_length_205_cov_9.242424_g574421_i0	PRJNA550047	576394	205	9.242424	18.9469692	Nematoda	6231	Nematoda	Nematoda	42.7	0.0147	NR	MFH4983499.1	75299	g574421	i0	39.6	5.45853658536585	48	29	70.2	0	146	3	28	75	MFH4983499.1 hypothetical protein [Gnathostoma spinigerum]	diamond	1119	43.1	0.990719257540603	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
32890598	32890598	PRJNA550047_P_NODE_547900_length_214_cov_10.992908_g545927_i0	PRJNA550047	547900	214	10.992908	23.52482312	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	97.8	9.01e-23	NR	KAE9553614.1	2598192	g545927	i0	81	0.883177570093458	63	12	88.3	0	191	3	129	191	KAE9553614.1 hypothetical protein FO519_003159 [Halicephalobus sp. NKZ332]	diamond	189	97.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332

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