metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA492406" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA492406" 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
24678391	24678391	PRJNA492406_P_NODE_17360_length_299_cov_3.185841_g17061_i0	PRJNA492406	17360	299	3.185841	9.52566459	Rhabditoides inermis	96661	Nematoda	Nematoda	88.6	2.85e-20	NR	ACV21053.1	96661	g17061	i0	59.8	3.5819397993311	87	35	87.3	0	262	2	1	87	ACV21053.1 large subunit ribosomal protein 35, partial [Rhabditoides inermis]	diamond	1071	88.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Rhabditoides	Rhabditoides inermis
27503381	27503381	PRJNA492406_P_NODE_31043_length_243_cov_0.905882_g30744_i0	PRJNA492406	31043	243	0.905882	2.20129326	Opisthokonta	33154	Nematoda	Nematoda	47	0.00113	NR	KAF8372464.1	54126	g30744	i0	37.8	5.59259259259259	74	36	91.4	2	225	4	77	140	KAF8372464.1 sqd-1 [Pristionchus pacificus]	diamond	1359	47.4	0.991561181434599	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
27534797	27534797	PRJNA492406_P_NODE_18863_length_288_cov_2.553488_g18564_i0	PRJNA492406	18863	288	2.553488	7.35404544	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	123	5.06e-34	NR	KAF8363112.1	54126	g18564	i0	65.6	5.36458333333333	90	30	93.8	1	19	288	19	107	KAF8363112.1 hypothetical protein PRIPAC_90035 [Pristionchus pacificus]	diamond	1545	123	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
27566197	27566197	PRJNA492406_P_NODE_22104_length_273_cov_1.380000_g21805_i0	PRJNA492406	22104	273	1.38	3.7674	Onchocercidae	6296	Nematoda	Nematoda	94.4	3.74e-20	NR	MCP9265862.1	6287	g21805	i0	54.9	4.89010989010989	91	40	98.9	1	272	3	441	531	MCP9265862.1 Thioredoxin reductase 1, cytoplasmic [Dirofilaria immitis]	diamond	1335	94.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Dirofilaria	Dirofilaria immitis
28276434	28276434	PRJNA492406_P_NODE_3486_length_643_cov_1.021053_g3196_i0	PRJNA492406	3486	643	1.021053	6.56537079	Aphelenchoides besseyi	269767	Nematoda	Nematoda	50.8	0.00168	NR	KAI6202865.1	269767	g3196	i0	28.5	1.21306376360809	130	85	58.8	4	468	91	58	183	KAI6202865.1 Protein disulfide-isomerase [Aphelenchoides besseyi]	diamond	780	50.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
28797516	28797516	PRJNA492406_P_NODE_26007_length_253_cov_2.061111_g25708_i0	PRJNA492406	26007	253	2.061111	5.21461083	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	114	9.65e-28	NR	NP_498326.1	6239	g25708	i0	65.9	18.5691699604743	82	28	97.2	0	8	253	132	213	NP_498326.1 putative glycylpeptide N-tetradecanoyltransferase [Caenorhabditis elegans]	diamond	4698	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
28923885	28923885	PRJNA492406_P_NODE_27228_length_250_cov_0.870056_g26929_i0	PRJNA492406	27228	250	0.870056	2.17514	Rhabditida	6236	Nematoda	Nematoda	66.6	9.85e-11	NR	KHN72989.1	6265	g26929	i0	61.4	3.576	44	17	52.8	0	231	100	34	77	KHN72989.1 Serine/arginine-rich splicing factor 4 [Toxocara canis]	diamond	894	66.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
29366126	29366126	PRJNA492406_P_NODE_12749_length_350_cov_1.985560_g12450_i0	PRJNA492406	12749	350	1.98556	6.94946	Angiostrongylus	6312	Nematoda	Nematoda	99.8	5.090000000000001e-22	NR	ADQ57303.1	6313	g12450	i0	43.2	2.02285714285714	118	63	98.6	3	348	4	62	178	ADQ57303.1 cathepsin B-like cysteine proteinase 1 [Angiostrongylus cantonensis]	diamond	708	100	0.998	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Angiostrongylus	Angiostrongylus cantonensis
29428990	29428990	PRJNA492406_P_NODE_12549_length_352_cov_2.304659_g12250_i0	PRJNA492406	12549	352	2.304659	8.11239968	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	95.9	5.9e-21	NR	KAL3073343.1	157864	g12250	i0	42.2	6.83522727272727	116	67	98.9	0	348	1	143	258	KAL3073343.1 hypothetical protein niasHT_038700 [Heterodera trifolii]	diamond	2406	95.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii
29855343	29855343	PRJNA492406_P_NODE_26191_length_252_cov_1.944134_g25892_i0	PRJNA492406	26191	252	1.944134	4.89921768	Meloidogyne graminicola	189291	Nematoda	Nematoda	91.7	1.03e-19	NR	KAF7638142.1	189291	g25892	i0	68.9	2.17857142857143	61	19	72.6	0	250	68	297	357	KAF7638142.1 Pyruvate dehydrogenase E1 component subunit beta [Meloidogyne graminicola]	diamond	549	91.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
30202552	30202552	PRJNA492406_P_NODE_27472_length_249_cov_1.670455_g27173_i0	PRJNA492406	27472	249	1.670455	4.15943295	Pristionchus mayeri	1317129	Nematoda	Nematoda	44.3	0.0106	NR	GMR48503.1	1317129	g27173	i0	49.1	0.662650602409639	55	26	63.9	1	160	2	47	101	GMR48503.1 hypothetical protein PMAYCL1PPCAC_18698, partial [Pristionchus mayeri]	diamond	165	44.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus mayeri
30977229	30977229	PRJNA492406_P_NODE_16374_length_309_cov_3.372881_g16075_i0	PRJNA492406	16374	309	3.372881	10.42220229	Opisthokonta	33154	Nematoda	Nematoda	120	2.44e-30	NR	KAI6203170.1	269767	g16075	i0	59.6	23.0679611650485	99	39	96.1	1	305	9	3	100	KAI6203170.1 Ribos-L4-asso-C domain-containing protein [Aphelenchoides besseyi]	diamond	7128	121	0.991735537190083	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
31593613	31593613	PRJNA492406_P_NODE_18976_length_288_cov_1.344186_g18677_i0	PRJNA492406	18976	288	1.344186	3.87125568	Necator americanus	51031	Nematoda	Nematoda	44.3	0.0176	NR	XP_064068295.1	51031	g18677	i0	37.5	1.33333333333333	64	36	66.7	1	205	14	360	419	XP_064068295.1 hypothetical protein RB195_024584 [Necator americanus]	diamond	384	44.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
31862256	31862256	PRJNA492406_P_NODE_7657_length_438_cov_1.679452_g7358_i0	PRJNA492406	7657	438	1.679452	7.3559997600000004	Trichinella	6333	Nematoda	Nematoda	123	1.88e-29	NR	KRY45026.1	45882	g7358	i0	39.6	10.7465753424658	144	87	98.6	0	6	437	1040	1183	KRY45026.1 Transposon Ty3-I Gag-Pol polyprotein [Trichinella britovi]	diamond	4707	124	0.991935483870968	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella britovi

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