metadata: contig_metadata: 16 rows where bioproject = "PRJEB81463", tax_kingdom = "Metazoa" and tax

16 rows where bioproject = "PRJEB81463", tax_kingdom = "Metazoa" 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
2690769	2690769	PRJEB81463_P_NODE_7583_length_364_cov_3.096220_g7311_i0	PRJEB81463	7583	364	3.09622	11.2702408	Strongyloides ratti	34506	Nematoda	Nematoda	270	8.76e-68	NTclustered	gi\|1376146183\|ref\|XM_024653652.1\|	34506	g7311	i0	80.737	97.7747252747253	353	62	96	6	1	350	686	1035	Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA	blastn	35590	270	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
7374850	7374850	PRJEB81463_P_NODE_10026_length_318_cov_4.114286_g9754_i0	PRJEB81463	10026	318	4.114286	13.08342948	Meloidogyne graminicola	189291	Nematoda	Nematoda	67.8	8.4e-11	NR	AVZ46778.1	189291	g9754	i0	40	0.990566037735849	105	63	99.1	0	315	1	122	226	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	315	67.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
10343725	10343725	PRJEB81463_P_NODE_9129_length_333_cov_1.453846_g8857_i0	PRJEB81463	9129	333	1.453846	4.84130718	Metazoa	33208	Nematoda	Nematoda	133	1.72e-33	NR	XP_024505069.1	34506	g8857	i0	58.2	9.73873873873874	110	43	96.4	1	6	326	588	697	XP_024505069.1 Large subunit GTPase 1 homolog [Strongyloides ratti]	diamond	3243	134	0.992537313432836	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
14168974	14168974	PRJEB81463_P_NODE_29072_length_235_cov_2.216049_g28800_i0	PRJEB81463	29072	235	2.216049	5.20771515	Aphelenchoides avenae	70226	Nematoda	Nematoda	133	3.78e-36	NR	KAH7721609.1	70226	g28800	i0	89.6	8.8468085106383	77	8	98.3	0	233	3	51	127	KAH7721609.1 Protein APS-2 [Aphelenchoides avenae]	diamond	2079	133	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides avenae
23092635	23092635	PRJEB81463_P_NODE_6999_length_379_cov_1.104575_g6727_i0	PRJEB81463	6999	379	1.104575	4.18633925	Metazoa	33208	Nematoda	Nematoda	231	3.25e-75	NR	AXS78234.1	6269	g6727	i0	92	88.0606860158311	125	10	98.9	0	377	3	25	149	AXS78234.1 ras-related protein rab-1a [Anisakis simplex]	diamond	33375	233	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
25223532	25223532	PRJEB81463_P_NODE_5440_length_429_cov_2.460674_g5168_i0	PRJEB81463	5440	429	2.460674	10.55629146	Opisthokonta	33154	Nematoda	Nematoda	217	4.27e-70	NR	CDP91858.1	6279	g5168	i0	86.7	74.4055944055944	128	17	89.5	0	429	46	17	144	CDP91858.1 Bm13651 [Brugia malayi]	diamond	31920	219	0.990867579908676	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
27445403	27445403	PRJEB81463_P_NODE_10023_length_318_cov_4.522449_g9751_i0	PRJEB81463	10023	318	4.522449	14.38138782	Meloidogyne graminicola	189291	Nematoda	Nematoda	91.3	1.34e-19	NR	AVZ46778.1	189291	g9751	i0	86.4	0.556603773584906	59	6	53.8	1	3	173	192	250	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	177	91.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
27571398	27571398	PRJEB81463_P_NODE_11164_length_304_cov_1.805195_g10892_i0	PRJEB81463	11164	304	1.805195	5.4877928	Caenorhabditis bovis	2654633	Nematoda	Nematoda	77.8	3.7e-14	NR	CAB3409702.1	2654633	g10892	i0	47.1	3.73026315789474	102	48	97.7	3	2	298	295	393	CAB3409702.1 unnamed protein product [Caenorhabditis bovis]	diamond	1134	77.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis bovis
28424057	28424057	PRJEB81463_P_NODE_21886_length_250_cov_3.186441_g21614_i0	PRJEB81463	21886	250	3.186441	7.9661025	Pristionchus pacificus	54126	Nematoda	Nematoda	69.3	1.5e-12	NR	KAF8386747.1	54126	g21614	i0	58.3	2.64	72	27	85.2	2	213	1	12	81	KAF8386747.1 rpl-25.1 [Pristionchus pacificus]	diamond	660	69.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
28543129	28543129	PRJEB81463_P_NODE_11727_length_297_cov_1.375000_g11455_i0	PRJEB81463	11727	297	1.375	4.08375	Opisthokonta	33154	Nematoda	Nematoda	77.4	4.66e-14	NR	VDO93347.1	241478	g11455	i0	40.4	5	99	54	100	1	1	297	140	233	VDO93347.1 unnamed protein product [Soboliphyme baturini]	diamond	1485	77.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini
28732406	28732406	PRJEB81463_P_NODE_25927_length_245_cov_0.906977_g25655_i0	PRJEB81463	25927	245	0.906977	2.22209365	Opisthokonta	33154	Nematoda	Nematoda	44.7	0.00813	NR	MCP9264919.1	6287	g25655	i0	33.3	6.04897959183673	90	45	91.8	2	241	17	593	682	MCP9264919.1 Importin-5 [Dirofilaria immitis]	diamond	1482	44.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Dirofilaria	Dirofilaria immitis
29181862	29181862	PRJEB81463_P_NODE_17389_length_265_cov_1.572917_g17117_i0	PRJEB81463	17389	265	1.572917	4.16823005	Ancylostoma ceylanicum	53326	Nematoda	Nematoda	120	2.49e-32	NR	EYC09444.1	53326	g17117	i0	64.4	3.93962264150943	87	31	98.5	0	3	263	69	155	EYC09444.1 hypothetical protein Y032_0060g3122 [Ancylostoma ceylanicum]	diamond	1044	120	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma ceylanicum
29181873	29181873	PRJEB81463_P_NODE_26229_length_244_cov_2.713450_g25957_i0	PRJEB81463	26229	244	2.71345	6.620818	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	91.3	2.56e-20	NR	KAE9550189.1	2598192	g25957	i0	55	2.95081967213115	80	36	98.4	0	3	242	58	137	KAE9550189.1 hypothetical protein FO519_006597 [Halicephalobus sp. NKZ332]	diamond	720	91.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
30690402	30690402	PRJEB81463_P_NODE_9133_length_333_cov_1.200000_g8861_i0	PRJEB81463	9133	333	1.2	3.996	Metazoa	33208	Nematoda	Nematoda	135	9.31e-37	NR	VDN51992.1	318479	g8861	i0	64.2	2.71171171171171	109	36	95.5	1	3	320	37	145	VDN51992.1 unnamed protein product [Dracunculus medinensis]	diamond	903	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Dracunculidae	Dracunculus	Dracunculus medinensis
32089009	32089009	PRJEB81463_P_NODE_14838_length_278_cov_1.297561_g14566_i0	PRJEB81463	14838	278	1.297561	3.60721958	Caenorhabditis elegans	6239	Nematoda	Nematoda	45.8	0.00422	NR	NP_492976.2	6239	g14566	i0	40.5	0.798561151079137	37	22	39.9	0	9	119	189	225	NP_492976.2 Phospholipid scramblase [Caenorhabditis elegans]	diamond	222	45.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
32808209	32808209	PRJEB81463_P_NODE_15740_length_273_cov_2.280000_g15468_i0	PRJEB81463	15740	273	2.28	6.2244	Opisthokonta	33154	Nematoda	Nematoda	143	3.72e-42	NR	KHJ43670.1	68888	g15468	i0	74.4	11.7362637362637	90	23	98.9	0	4	273	6	95	KHJ43670.1 ribosomal protein L7Ae [Trichuris suis]	diamond	3204	143	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis

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