metadata: contig_metadata: 10 rows where bioproject = "PRJNA1159911", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA1159911", 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
308633	308633	PRJNA1159911_P_NODE_85241_length_253_cov_2.338889_g84699_i0	PRJNA1159911	85241	253	2.338889	5.91738917	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	120	2.6999999999999997e-31	NR	NP_507940.1	6239	g84699	i0	75.3	14.7747035573123	73	18	86.6	0	225	7	1	73	NP_507940.1 Large ribosomal subunit protein uL2 [Caenorhabditis elegans]	diamond	3738	121	0.991735537190083	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
18159685	18159685	PRJNA1159911_P_NODE_51875_length_339_cov_8.120301_g51333_i0	PRJNA1159911	51875	339	8.120301	27.52782039	Caenorhabditis briggsae	6238	Nematoda	Nematoda	199	2.6300000000000003e-58	NR	UMM19092.1	6238	g51333	i0	80.8	5.53097345132743	125	11	99.1	1	337	2	234	358	UMM19092.1 hypothetical protein L5515_014856 [Caenorhabditis briggsae]	diamond	1875	199	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
29061637	29061637	PRJNA1159911_P_NODE_69888_length_284_cov_1.322275_g69346_i0	PRJNA1159911	69888	284	1.322275	3.755261	Caenorhabditis elegans	6239	Nematoda	Nematoda	63.5	2.84e-9	NR	NP_001380015.1	6239	g69346	i0	50	0.73943661971831	70	29	73.9	2	284	75	428	491	NP_001380015.1 Pre-mRNA-processing factor 19 [Caenorhabditis elegans]	diamond	210	63.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
29806896	29806896	PRJNA1159911_P_NODE_73491_length_276_cov_1.137931_g72949_i0	PRJNA1159911	73491	276	1.137931	3.14068956	Metazoa	33208	Nematoda	Nematoda	130	1.41e-33	NR	XP_024506008.1	34506	g72949	i0	64.8	9.93478260869565	91	32	98.9	0	275	3	183	273	XP_024506008.1 Homogentisate 1,2-dioxygenase [Strongyloides ratti]	diamond	2742	131	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
30407611	30407611	PRJNA1159911_P_NODE_82373_length_258_cov_2.189189_g81831_i0	PRJNA1159911	82373	258	2.189189	5.64810762	Metazoa	33208	Nematoda	Nematoda	73.2	8.35e-13	NR	GMR45422.1	1317129	g81831	i0	59	2.38372093023256	61	25	70.9	0	69	251	9	69	GMR45422.1 hypothetical protein PMAYCL1PPCAC_15617, partial [Pristionchus mayeri]	diamond	615	73.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus mayeri
30545917	30545917	PRJNA1159911_P_NODE_68833_length_286_cov_2.192488_g68291_i0	PRJNA1159911	68833	286	2.192488	6.27051568	Gnathostoma spinigerum	75299	Nematoda	Nematoda	122	4.14e-30	NR	MFH4978078.1	75299	g68291	i0	67.9	2.54895104895105	81	26	85	0	6	248	85	165	MFH4978078.1 hypothetical protein [Gnathostoma spinigerum]	diamond	729	122	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
31608308	31608308	PRJNA1159911_P_NODE_83596_length_256_cov_2.032787_g83054_i0	PRJNA1159911	83596	256	2.032787	5.20393472	Metazoa	33208	Nematoda	Nematoda	119	4.829999999999999e-31	NR	KRZ48460.1	6335	g83054	i0	100	113.296875	52	0	60.9	0	101	256	5	56	KRZ48460.1 Casein kinase II subunit beta, partial [Trichinella nativa]	diamond	29004	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nativa
31734669	31734669	PRJNA1159911_P_NODE_19617_length_661_cov_2.312925_g19105_i0	PRJNA1159911	19617	661	2.312925	15.28843425	Rhabditida	6236	Nematoda	Nematoda	85.9	1.54e-15	NR	MCP9260166.1	6287	g19105	i0	74.6	0.962178517397882	59	13	26.8	1	179	3	196	252	MCP9260166.1 Ras-related protein Rab-10 [Dirofilaria immitis]	diamond	636	85.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Dirofilaria	Dirofilaria immitis
32821606	32821606	PRJNA1159911_P_NODE_90120_length_249_cov_0.875000_g89578_i0	PRJNA1159911	90120	249	0.875	2.17875	Pristionchus pacificus	54126	Nematoda	Nematoda	51.2	3.69e-5	NR	KAF8383409.1	54126	g89578	i0	47.5	0.710843373493976	59	28	67.5	2	220	53	234	292	KAF8383409.1 hypothetical protein PRIPAC_72551, partial [Pristionchus pacificus]	diamond	177	51.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
32840751	32840751	PRJNA1159911_P_NODE_99800_length_242_cov_0.911243_g99258_i0	PRJNA1159911	99800	242	0.911243	2.20520806	Metazoa	33208	Nematoda	Nematoda	121	1.47e-30	NR	WKX90267.1	27835	g99258	i0	63.6	11.5661157024793	77	28	95.5	0	12	242	208	284	WKX90267.1 hypothetical protein Q1695_009257 [Nippostrongylus brasiliensis]	diamond	2799	122	0.991803278688525	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heligmosomidae	Nippostrongylus	Nippostrongylus brasiliensis

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