metadata: contig_metadata: 28 rows where bioproject = "PRJNA597223" and tax

28 rows where bioproject = "PRJNA597223" 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
569325	569325	PRJNA597223_P_NODE_63661_length_181_cov_5.136986_g61815_i0	PRJNA597223	63661	181	5.136986	9.29794466	Caenorhabditis elegans	6239	Nematoda	Nematoda	329	6.340000000000001e-86	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g61815	i0	99.448	100	181	1	100	0	1	181	27761	27581	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	18100	329	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
569476	569476	PRJNA597223_P_NODE_76281_length_162_cov_1.795276_g74435_i0	PRJNA597223	76281	162	1.795276	2.90834712	Rotylenchulus reniformis	239373	Nematoda	Nematoda	204	3.52e-48	NTclustered	gi\|264665165\|gb\|FJ906452.1\|	239373	g74435	i0	89.759	1.02469135802469	166	8	97	2	6	162	339	504	Rotylenchulus reniformis clone 363 microsatellite sequence	blastn	166	204	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Hoplolaimidae	Rotylenchulus	Rotylenchulus reniformis
1844942	1844942	PRJNA597223_P_NODE_57442_length_186_cov_74.900662_g55596_i0	PRJNA597223	57442	186	74.900662	139.31523132	Caenorhabditis elegans	6239	Nematoda	Nematoda	296	6.65e-76	NTclustered	gi\|1279388955\|gb\|MG551716.1\|	6239	g55596	i0	100	84.1612903225806	160	0	86	0	4	163	492	651	Caenorhabditis elegans isolate C.eleg_S1A small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence	blastn	15654	296	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
4397204	4397204	PRJNA597223_P_NODE_84644_length_153_cov_1.279661_g82798_i0	PRJNA597223	84644	153	1.279661	1.95788133	Caenorhabditis elegans	6239	Nematoda	Nematoda	278	1.9e-70	NTclustered	gi\|687865569\|emb\|LK927553.1\|	6239	g82798	i0	99.346	2.72549019607843	153	1	100	0	1	153	103071	102919	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000021	blastn	417	278	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
8222626	8222626	PRJNA597223_P_NODE_70007_length_171_cov_0.970588_g68161_i0	PRJNA597223	70007	171	0.970588	1.65970548	Caenorhabditis elegans	6239	Nematoda	Nematoda	315	1.65e-81	NTclustered	gi\|1734317839\|ref\|NM_059707.6\|	6239	g68161	i0	100	2.98245614035088	170	0	99	0	2	171	2019	1850	Caenorhabditis elegans Guanine nucleotide-binding protein G(o) subunit alpha (goa-1), mRNA	blastn	510	315	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
8222889	8222889	PRJNA597223_S_NODE_407_length_425_cov_2.945596_g350_i0	PRJNA597223	407	425	2.945596	12.518783	Caenorhabditis elegans	6239	Nematoda	Nematoda	780	0	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g350	i0	99.765	100.322352941176	425	1	100	0	1	425	28566	28142	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	42637	780	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
8793448	8793448	PRJNA597223_P_NODE_25707_length_306_cov_8.269373_g23863_i0	PRJNA597223	25707	306	8.269373	25.30428138	root	1	Root_unresolved	Root_unresolved	566	8.239999999999998e-157	NTclustered	gi\|1181702\|gb\|U45326.1\|CBU45326	6238	g23863	i0	100	3	306	0	100	0	1	306	1002	697	Caenorhabditis briggsae UNC-119 homolog (unc-119) gene, complete cds	blastn	918	566	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
9497212	9497212	PRJNA597223_P_NODE_15348_length_427_cov_41.308673_g13552_i0	PRJNA597223	15348	427	41.308673	176.38803371	Caenorhabditis elegans	6239	Nematoda	Nematoda	789	0	NTclustered	gi\|28396069\|gb\|AY204194.1\|	6239	g13552	i0	100	98.8173302107728	427	0	100	0	1	427	541	967	Caenorhabditis elegans clone yk805b2 nuclear receptor (NHR-108) pseudogene mRNA, complete sequence	blastn	42195	789	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
10069436	10069436	PRJNA597223_P_NODE_82868_length_154_cov_38.537815_g81022_i0	PRJNA597223	82868	154	38.537815	59.3482351	Caenorhabditis	6237	Nematoda	Nematoda	220	3.27e-53	NTclustered	gi\|1799637168\|gb\|MN519139.1\|	6238	g81022	i0	100	81.8051948051948	119	0	100	0	36	154	287	169	Caenorhabditis briggsae strain AF16 clone 3 5S ribosomal RNA and small nuclear RNA sls-1 snRNA genes, complete sequence	blastn	12598	220	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
10773422	10773422	PRJNA597223_P_NODE_42829_length_216_cov_13.977901_g40983_i0	PRJNA597223	42829	216	13.977901	30.19226616	Caenorhabditis elegans	6239	Nematoda	Nematoda	399	5.909999999999999e-107	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g40983	i0	100	100.634259259259	216	0	100	0	1	216	29301	29086	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	21737	399	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
10773635	10773635	PRJNA597223_P_NODE_62329_length_184_cov_1.771812_g60483_i0	PRJNA597223	62329	184	1.771812	3.26013408	Caenorhabditis elegans	6239	Nematoda	Nematoda	340	2.99e-89	NTclustered	gi\|1734330921\|ref\|NM_001028219.3\|	6239	g60483	i0	100	4	184	0	100	0	1	184	4667	4850	Caenorhabditis elegans Rap guanine nucleotide exchange factor (pxf-1), mRNA	blastn	736	340	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
12048113	12048113	PRJNA597223_P_NODE_30190_length_274_cov_3.167364_g28344_i0	PRJNA597223	30190	274	3.167364	8.67857736	Caenorhabditis elegans	6239	Nematoda	Nematoda	507	4.47e-139	NTclustered	gi\|351049782\|emb\|FO080454.1\|	6239	g28344	i0	100	3.06204379562044	274	0	100	0	1	274	18992	19265	Caenorhabditis elegans Cosmid T28H11, complete sequence	blastn	839	507	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
14597896	14597896	PRJNA597223_P_NODE_35052_length_247_cov_1.584906_g33206_i0	PRJNA597223	35052	247	1.584906	3.91471782	Caenorhabditis elegans	6239	Nematoda	Nematoda	457	4.05e-124	NTclustered	gi\|687865328\|emb\|LK927659.1\|	6239	g33206	i0	100	13.8097165991903	247	0	100	0	1	247	89134	88888	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000114	blastn	3411	457	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15871914	15871914	PRJNA597223_P_NODE_5193_length_765_cov_95.798630_g2275_i1	PRJNA597223	5193	765	95.79863	732.8595195	Caenorhabditis elegans	6239	Nematoda	Nematoda	682	0	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g2275	i1	99.467	53.1816993464052	375	2	49	0	2	376	26577	26951	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	40684	682	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15872030	15872030	PRJNA597223_P_NODE_65193_length_179_cov_1.263889_g63347_i0	PRJNA597223	65193	179	1.263889	2.26236131	Pratylenchus vulnus	45931	Nematoda	Nematoda	52.8	0.015	NTclustered	gi\|1557394408\|emb\|LR031564.1\|	45931	g63347	i0	100	0.156424581005587	28	0	16	0	1	28	26	53	Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Pratylenchidae	Pratylenchus	Pratylenchus vulnus
18420709	18420709	PRJNA597223_P_NODE_11355_length_510_cov_33.913684_g9643_i0	PRJNA597223	11355	510	33.913684	172.9597884	Caenorhabditis elegans	6239	Nematoda	Nematoda	937	0	NTclustered	gi\|1879207294\|gb\|MT797802.1\|	6239	g9643	i0	99.804	97.7058823529412	510	1	100	0	1	510	784	275	Caenorhabditis elegans isolate KZN large subunit ribosomal RNA gene, partial sequence	blastn	49830	937	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
18420876	18420876	PRJNA597223_P_NODE_28375_length_286_cov_3.645418_g26529_i0	PRJNA597223	28375	286	3.645418	10.42589548	Caenorhabditis elegans	6239	Nematoda	Nematoda	529	1e-145	NTclustered	gi\|27543236\|gb\|AY171138.1\|	6239	g26529	i0	100	100.29020979021	286	0	100	0	1	286	1110	825	Caenorhabditis elegans isolate CB4855 NADH dehydrogenase subunit 6 (ND6) gene, partial cds; NADH dehydrogenase subunit 4L (ND4L) gene, complete cds; tRNA-Trp and tRNA-Glu genes, complete sequence; 12S ribosomal RNA gene, complete sequence; tRNA-Ser, tRNA-Asn, and tRNA-Tyr genes, complete sequence; and NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial genes for mitochondrial products	blastn	28683	529	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
18421546	18421546	PRJNA597223_P_NODE_85715_length_152_cov_1.427350_g83869_i0	PRJNA597223	85715	152	1.42735	2.169572	Caenorhabditis remanei	31234	Nematoda	Nematoda	99	1.57e-16	NTclustered	gi\|2445391340\|ref\|XM_053735146.1\|	31234	g83869	i0	78.947	2.94736842105263	152	26	98	5	4	152	989	841	Caenorhabditis remanei uncharacterized protein (GCK72_022950), partial mRNA	blastn	448	99	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
19695911	19695911	PRJNA597223_P_NODE_76076_length_162_cov_2.488189_g74230_i0	PRJNA597223	76076	162	2.488189	4.03086618	Caenorhabditis elegans	6239	Nematoda	Nematoda	283	4.39e-72	NTclustered	gi\|1972267160\|ref\|NM_069458.7\|	6239	g74230	i0	100	4.4320987654321	153	0	94	0	10	162	892	1044	Caenorhabditis elegans Small ribosomal subunit protein RACK1 (rack-1), mRNA	blastn	718	283	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19696058	19696058	PRJNA597223_S_NODE_1096_length_270_cov_3.805195_g1039_i0	PRJNA597223	1096	270	3.805195	10.2740265	Caenorhabditis elegans	6239	Nematoda	Nematoda	473	4.4599999999999996e-129	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g1039	i0	99.24	80.5222222222222	263	1	97	1	1	263	28628	28889	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	21741	473	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
24795254	24795254	PRJNA597223_P_NODE_46100_length_207_cov_1.755814_g44254_i0	PRJNA597223	46100	207	1.755814	3.63453498	Caenorhabditis elegans	6239	Nematoda	Nematoda	383	5.65e-102	NTclustered	gi\|687866285\|emb\|LK928484.1\|	6239	g44254	i0	100	3.80193236714976	207	0	100	0	1	207	12304	12510	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000709	blastn	787	383	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
25367018	25367018	PRJNA597223_P_NODE_42680_length_217_cov_2.126374_g40834_i0	PRJNA597223	42680	217	2.126374	4.61423158	Caenorhabditis	6237	Nematoda	Nematoda	383	5.98e-102	NTclustered	gi\|1604722011\|gb\|CP038193.1\|	6239	g40834	i0	99.061	98.1566820276498	213	2	98	0	5	217	10715	10927	Caenorhabditis elegans strain CB4856 mitochondrion, complete genome	blastn	21300	383	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
26795045	26795045	PRJNA597223_P_NODE_19281_length_370_cov_47.859701_g17454_i0	PRJNA597223	19281	370	47.859701	177.0808937	Trichinella murrelli	144512	Nematoda	Nematoda	132	5.16e-33	NR	KRX33240.1	144512	g17454	i0	50.4	12.7378378378378	121	60	98.1	0	368	6	528	648	KRX33240.1 Retrovirus-related Pol polyprotein from transposon 17.6, partial [Trichinella murrelli]	diamond	4713	132	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella murrelli
26826823	26826823	PRJNA597223_P_NODE_64241_length_180_cov_3.717241_g62395_i0	PRJNA597223	64241	180	3.717241	6.6910338	Brugia malayi	6279	Nematoda	Nematoda	40.8	0.0189	NR	CDP90914.1	6279	g62395	i0	70	0.5	30	9	50	0	134	45	14	43	CDP90914.1 Bm13240 [Brugia malayi]	diamond	90	40.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
28595908	28595908	PRJNA597223_P_NODE_57267_length_187_cov_1.736842_g55421_i0	PRJNA597223	57267	187	1.736842	3.24789454	Trichinella patagoniensis	990121	Nematoda	Nematoda	66.6	6.7e-11	NR	KRY15368.1	990121	g55421	i0	48.3	16.7486631016043	58	30	93	0	175	2	115	172	KRY15368.1 Actin, acrosomal process isoform [Trichinella patagoniensis]	diamond	3132	66.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella patagoniensis
28609082	28609082	PRJNA597223_P_NODE_24447_length_317_cov_2.588652_g22603_i0	PRJNA597223	24447	317	2.588652	8.20602684	Trichinella	6333	Nematoda	Nematoda	78.2	3.15e-14	NR	KRY48786.1	45882	g22603	i0	46.9	12	96	44	88	3	310	32	332	423	KRY48786.1 Retrovirus-related Pol polyprotein from transposon [Trichinella britovi]	diamond	3804	78.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella britovi
31502160	31502160	PRJNA597223_P_NODE_8556_length_595_cov_6.844643_g7007_i0	PRJNA597223	8556	595	6.844643	40.72562585	Gnathostoma spinigerum	75299	Nematoda	Nematoda	58.5	3.65e-6	NR	MFH4980211.1	75299	g7007	i0	46	0.252100840336134	50	27	25.2	0	3	152	1075	1124	MFH4980211.1 hypothetical protein [Gnathostoma spinigerum]	diamond	150	58.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
32401301	32401301	PRJNA597223_P_NODE_56479_length_188_cov_1.777778_g54633_i0	PRJNA597223	56479	188	1.777778	3.34222264	Metazoa	33208	Nematoda	Nematoda	84.7	2.89e-17	NR	KFD59642.1	68888	g54633	i0	67.9	30.1117021276596	56	18	89.4	0	183	16	328	383	KFD59642.1 hypothetical protein M514_28177 [Trichuris suis]	diamond	5661	84.7	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);;