metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA493827" 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
469888	469888	PRJNA493827_P_NODE_116881_length_316_cov_1.267490_g114683_i0	PRJNA493827	116881	316	1.26749	4.0052684	Meloidogyne javanica	6303	Nematoda	Nematoda	364	3.3499999999999985e-96	NTclustered	gi\|18147015\|dbj\|AB047762.1\|	6303	g114683	i0	87.781	19.7056962025316	311	38	98	0	4	314	524	214	Meloidogyne javanica DNA, polymorphic marker for virulence, isolate:MJON-VI	blastn	6227	364	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne javanica
1104935	1104935	PRJNA493827_P_NODE_161941_length_269_cov_1.561224_g159743_i0	PRJNA493827	161941	269	1.561224	4.19969256	Ironus	211205	Nematoda	Nematoda	141	5.110000000000001e-29	NTclustered	gi\|68271495\|gb\|DQ086676.1\|	554024	g159743	i0	86.614	47.7843866171004	127	17	47	0	2	128	301	175	Uncultured nematode isolate NEMATD17 large subunit ribosomal RNA gene, partial sequence	blastn	12854	141	1	Eukaryota	Opisthokonta	Metazoa	Nematoda					Nematoda environmental sample
4932974	4932974	PRJNA493827_P_NODE_131624_length_298_cov_1.146667_g129426_i0	PRJNA493827	131624	298	1.146667	3.41706766	Metazoa	33208	Nematoda	Nematoda	215	3.34e-51	NTclustered	gi\|268557465\|ref\|XM_002636676.1\|	6238	g129426	i0	83.333	81.2013422818792	240	32	79	6	62	297	356	121	Caenorhabditis briggsae Protein CBG23441 (CBG23441), partial mRNA	blastn	24198	217	0.990783410138249	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
6208166	6208166	PRJNA493827_P_NODE_137925_length_291_cov_0.963303_g135727_i0	PRJNA493827	137925	291	0.963303	2.80321173	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	204	7.03e-48	NTclustered	gi\|6631\|emb\|X16800.1\|	6239	g135727	i0	79.649	42.6219931271478	285	56	98	2	2	285	247	530	C.elegans act4 gene, exons 2,3 and 4	blastn	12403	206	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
6849553	6849553	PRJNA493827_P_NODE_216506_length_244_cov_1.327485_g214308_i0	PRJNA493827	216506	244	1.327485	3.2390634	Tylopharynx sp. WEM-2009	669147	Nematoda	Nematoda	137	5.91e-28	NTclustered	gi\|256709336\|gb\|GQ422343.1\|	669147	g214308	i0	81.395	18.7786885245902	172	28	70	4	1	170	213	44	Tylopharynx sp. WEM-2009 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	4582	137	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylopharyngidae	Tylopharynx	Tylopharynx sp. WEM-2009
7483139	7483139	PRJNA493827_P_NODE_172966_length_260_cov_1.235294_g170768_i0	PRJNA493827	172966	260	1.235294	3.2117644	Caenorhabditis	6237	Nematoda	Nematoda	63.9	1.09e-5	NTclustered	gi\|1972228534\|ref\|NM_001316854.4\|	6239	g170768	i0	95	0.630769230769231	40	2	15	0	209	248	86	47	Caenorhabditis elegans 60S ribosomal protein L41 (rpl-41.2), mRNA	blastn	164	63.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
10673485	10673485	PRJNA493827_P_NODE_115129_length_318_cov_2.514286_g112931_i0	PRJNA493827	115129	318	2.514286	7.99542948	Strongyloides ratti	34506	Nematoda	Nematoda	215	3.59e-51	NTclustered	gi\|1376135693\|ref\|XM_024647883.1\|	34506	g112931	i0	81.273	77.5062893081761	267	48	84	2	22	287	266	1	Strongyloides ratti Histone H3 (SRAE_1000098500), partial mRNA	blastn	24647	215	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
10677021	10677021	PRJNA493827_P_NODE_58629_length_460_cov_1.612403_g56433_i0	PRJNA493827	58629	460	1.612403	7.4170538	Strongyloides papillosus	174720	Nematoda	Nematoda	233	1.49e-56	NTclustered	gi\|687022675\|emb\|LM525589.1\|	174720	g56433	i0	78.453	55.2239130434783	362	74	78	4	4	364	171994	172352	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000012	blastn	25403	233	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
13224757	13224757	PRJNA493827_P_NODE_168391_length_264_cov_1.089005_g166193_i0	PRJNA493827	168391	264	1.089005	2.8749732	Caenorhabditis remanei	31234	Nematoda	Nematoda	137	6.469999999999999e-28	NTclustered	gi\|2445385448\|ref\|XM_003116269.2\|	31234	g166193	i0	81.548	6.87121212121212	168	29	63	2	92	258	416	250	Caenorhabditis remanei uncharacterized protein (GCK72_020053), partial mRNA	blastn	1814	137	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
13858783	13858783	PRJNA493827_P_NODE_177611_length_256_cov_1.404372_g175413_i0	PRJNA493827	177611	256	1.404372	3.59519232	Opisthokonta	33154	Nematoda	Nematoda	172	1.71e-38	NTclustered	gi\|150982133\|gb\|EF634655.1\|	376545	g175413	i0	86.42	32.81640625	162	17	62	5	41	198	13	173	Pristionchus pauli large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds	blastn	8401	172	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
14499526	14499526	PRJNA493827_P_NODE_159072_length_271_cov_7.888889_g156874_i0	PRJNA493827	159072	271	7.888889	21.37888919	Leptojacobus dorci	1463561	Nematoda	Nematoda	150	8.569999999999998e-32	NTclustered	gi\|675118843\|gb\|KJ877301.1\|	1463561	g156874	i0	84.314	15.6309963099631	153	24	56	0	27	179	207	55	Leptojacobus dorci strain RS9005 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	4236	150	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Leptojacobus	Leptojacobus dorci
14501761	14501761	PRJNA493827_P_NODE_46492_length_527_cov_4.881057_g44303_i0	PRJNA493827	46492	527	4.881057	25.72317039	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	167	1.77e-36	NTclustered	gi\|524845312\|gb\|KC819366.1\|	1355913	g44303	i0	81.166	23.4345351043643	223	28	41	11	245	460	264	49	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds	blastn	12350	167	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus
17050559	17050559	PRJNA493827_P_NODE_54214_length_481_cov_10.149510_g52023_i0	PRJNA493827	54214	481	10.14951	48.8191431	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.54e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g52023	i0	81.492	4.69022869022869	362	61	75	6	57	415	395	37	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2256	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
18322015	18322015	PRJNA493827_P_NODE_140395_length_288_cov_1.767442_g138197_i0	PRJNA493827	140395	288	1.767442	5.09023296	Caenorhabditis elegans	6239	Nematoda	Nematoda	69.4	2.65e-7	NTclustered	gi\|687866120\|emb\|LK928125.1\|	6239	g138197	i0	95.349	15.9826388888889	43	2	15	0	165	207	16144	16102	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000487	blastn	4603	69.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19599017	19599017	PRJNA493827_P_NODE_46916_length_524_cov_7.028825_g44727_i0	PRJNA493827	46916	524	7.028825	36.831043	Strongyloides ratti	34506	Nematoda	Nematoda	163	2.28e-35	NTclustered	gi\|1376143741\|ref\|XM_024652282.1\|	34506	g44727	i0	76.562	5.79389312977099	320	61	60	13	212	524	575	887	Strongyloides ratti Serine/threonine-protein phosphatase PP1-beta catalytic subunit (SRAE_2000134100), partial mRNA	blastn	3036	163	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
20873421	20873421	PRJNA493827_P_NODE_201557_length_247_cov_2.045977_g199359_i0	PRJNA493827	201557	247	2.045977	5.05356319	Pristionchus sp. 10 RS5133	452805	Nematoda	Nematoda	152	2.1399999999999998e-32	NTclustered	gi\|150981909\|gb\|EF634543.1\|	452805	g199359	i0	81.25	81.5668016194332	192	32	77	3	58	247	474	285	Pristionchus sp. 10 RS5133 large subunit ribosomal protein 10 (rpl-10) mRNA, partial cds	blastn	20147	152	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 10 RS5133
22146957	22146957	PRJNA493827_P_NODE_142558_length_286_cov_1.694836_g140360_i0	PRJNA493827	142558	286	1.694836	4.84723096	Tylopharynx sp. WEM-2009	669147	Nematoda	Nematoda	198	3.21e-46	NTclustered	gi\|256709336\|gb\|GQ422343.1\|	669147	g140360	i0	79.359	8.68881118881119	281	58	98	0	4	284	115	395	Tylopharynx sp. WEM-2009 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2485	198	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylopharyngidae	Tylopharynx	Tylopharynx sp. WEM-2009
23422754	23422754	PRJNA493827_P_NODE_138439_length_290_cov_1.419355_g136241_i0	PRJNA493827	138439	290	1.419355	4.1161295	Diplogasteroides halleri	1538714	Nematoda	Nematoda	200	9.059999999999999e-47	NTclustered	gi\|675118825\|gb\|KJ877292.1\|	1538714	g136241	i0	80.534	4.28965517241379	262	49	90	2	8	268	486	746	Diplogasteroides halleri strain RS5531 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	1244	200	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteroididae	Diplogasteroides	Diplogasteroides halleri
23423822	23423822	PRJNA493827_P_NODE_188579_length_250_cov_1.288136_g186381_i0	PRJNA493827	188579	250	1.288136	3.22034	Caenorhabditis briggsae	6238	Nematoda	Nematoda	54.7	0.006	NTclustered	gi\|2158425669\|ref\|XM_045243700.1\|	6238	g186381	i0	100	0.116	29	0	12	0	79	107	878	906	Caenorhabditis briggsae Protein CBR-PTR-12 (Cbr-ptr-12), partial mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
23424222	23424222	PRJNA493827_P_NODE_20739_length_855_cov_2.460358_g18948_i0	PRJNA493827	20739	855	2.460358	21.0360609	Tylopharynx sp. WEM-2009	669147	Nematoda	Nematoda	459	4.34e-124	NTclustered	gi\|256709136\|gb\|GQ422220.1\|	669147	g18948	i0	78.788	27.5684210526316	693	139	81	8	102	790	711	23	Tylopharynx sp. WEM-2009 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	23571	459	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylopharyngidae	Tylopharynx	Tylopharynx sp. WEM-2009
24696760	24696760	PRJNA493827_P_NODE_159260_length_271_cov_2.202020_g157062_i0	PRJNA493827	159260	271	2.20202	5.9674742	Strongyloides papillosus	174720	Nematoda	Nematoda	185	2.3499999999999994e-42	NTclustered	gi\|690018530\|emb\|LM525768.1\|	174720	g157062	i0	82.326	6.19188191881919	215	36	79	2	14	227	1110	1323	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000157	blastn	1678	185	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus

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