metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA1105232" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA1105232" 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
212602	212602	PRJNA1105232_S_NODE_8101_length_219_cov_1.835294_g7885_i0	PRJNA1105232	8101	219	1.835294	4.01929386	Caenorhabditis elegans	6239	Nematoda	Nematoda	405	1.29e-108	NTclustered	gi\|1879207294\|gb\|MT797802.1\|	6239	g7885	i0	100	91.2557077625571	219	0	100	0	1	219	226	8	Caenorhabditis elegans isolate KZN large subunit ribosomal RNA gene, partial sequence	blastn	19985	405	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
1487275	1487275	PRJNA1105232_S_NODE_3942_length_291_cov_2.066116_g3726_i0	PRJNA1105232	3942	291	2.066116	6.01239756	Caenorhabditis elegans	6239	Nematoda	Nematoda	538	1.6999999999999994e-148	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g3726	i0	100	95.127147766323	291	0	100	0	1	291	28198	28488	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	27682	538	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
2763265	2763265	PRJNA1105232_S_NODE_12823_length_182_cov_1.172932_g12607_i0	PRJNA1105232	12823	182	1.172932	2.13473624	Caenorhabditis elegans	6239	Nematoda	Nematoda	337	3.82e-88	NTclustered	gi\|1972310597\|ref\|NM_077585.9\|	6239	g12607	i0	100	2.92307692307692	182	0	100	0	1	182	408	227	Caenorhabditis elegans Conserved secreted protein (Y62H9A.5), mRNA	blastn	532	337	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
4039385	4039385	PRJNA1105232_S_NODE_8124_length_219_cov_1.223529_g7908_i0	PRJNA1105232	8124	219	1.223529	2.67952851	Caenorhabditis elegans	6239	Nematoda	Nematoda	405	1.29e-108	NTclustered	gi\|687866128\|emb\|LK928185.1\|	6239	g7908	i0	100	4.36986301369863	219	0	100	0	1	219	17281	17499	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000527	blastn	957	405	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
5315503	5315503	PRJNA1105232_S_NODE_9785_length_204_cov_1.341935_g9569_i0	PRJNA1105232	9785	204	1.341935	2.7375474	Caenorhabditis elegans	6239	Nematoda	Nematoda	377	2.59e-100	NTclustered	gi\|1972266499\|ref\|NM_171316.9\|	6239	g9569	i0	100	12.2647058823529	204	0	100	0	1	204	557	760	Caenorhabditis elegans Large ribosomal subunit protein eL8 (rpl-7A), mRNA	blastn	2502	377	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
6123448	6123448	PRJNA1105232_S_NODE_4365_length_279_cov_4.704348_g4149_i0	PRJNA1105232	4365	279	4.704348	13.12513092	Caenorhabditis	6237	Nematoda	Nematoda	516	7.58e-142	NTclustered	gi\|1279388950\|gb\|MG551689.1\|	6239	g4149	i0	100	100.358422939068	279	0	100	0	1	279	330	52	Caenorhabditis elegans isolate C.eleg_AM151 small subunit ribosomal RNA gene, partial sequence	blastn	28000	516	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
6590646	6590646	PRJNA1105232_S_NODE_11986_length_187_cov_1.231884_g11770_i0	PRJNA1105232	11986	187	1.231884	2.30362308	Caenorhabditis elegans	6239	Nematoda	Nematoda	346	6.56e-91	NTclustered	gi\|3217349\|emb\|Z81068.1\|	6239	g11770	i0	100	11.475935828877	187	0	100	0	1	187	11638	11824	Caenorhabditis elegans Cosmid F25H5, complete sequence	blastn	2146	346	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
6590685	6590685	PRJNA1105232_S_NODE_4386_length_279_cov_1.834783_g4170_i0	PRJNA1105232	4386	279	1.834783	5.11904457	Strongyloides papillosus	174720	Nematoda	Nematoda	174	5.26e-39	NTclustered	gi\|690018585\|emb\|LM525823.1\|	174720	g4170	i0	79.377	7.87096774193548	257	46	90	6	3	254	34608	34862	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000205	blastn	2196	174	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
6590694	6590694	PRJNA1105232_S_NODE_5566_length_254_cov_2.156098_g5350_i0	PRJNA1105232	5566	254	2.156098	5.47648892	Caenorhabditis elegans	6239	Nematoda	Nematoda	464	2.4999999999999994e-126	NTclustered	gi\|1845975117\|ref\|NM_067641.8\|	6239	g5350	i0	100	3.65354330708661	251	0	99	0	4	254	663	413	Caenorhabditis elegans Secreted protein (perm-2), mRNA	blastn	928	464	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7865283	7865283	PRJNA1105232_S_NODE_12307_length_185_cov_1.147059_g12091_i0	PRJNA1105232	12307	185	1.147059	2.12205915	Caenorhabditis elegans	6239	Nematoda	Nematoda	342	8.369999999999999e-90	NTclustered	gi\|1972266638\|ref\|NM_068494.9\|	6239	g12091	i0	100	58.6	185	0	100	0	1	185	259	75	Caenorhabditis elegans Small ribosomal subunit protein eS25 (rps-25), mRNA	blastn	10841	342	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7865357	7865357	PRJNA1105232_S_NODE_8927_length_211_cov_2.493827_g8711_i0	PRJNA1105232	8927	211	2.493827	5.26197497	Oigolaimella attenuata	669116	Nematoda	Nematoda	200	6.25e-47	NTclustered	gi\|256709322\|gb\|GQ422336.1\|	669116	g8711	i0	83.886	38.3364928909953	211	32	99	2	2	211	329	120	Oigolaimella attenuata large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	8089	200	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Oigolaimella	Oigolaimella attenuata
8673613	8673613	PRJNA1105232_S_NODE_14987_length_170_cov_1.289256_g14771_i0	PRJNA1105232	14987	170	1.289256	2.1917352	Caenorhabditis	6237	Nematoda	Nematoda	315	1.64e-81	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g14771	i0	100	68.1058823529412	170	0	100	0	1	170	28091	27922	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	11578	315	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
9140160	9140160	PRJNA1105232_S_NODE_1248_length_449_cov_1.532500_g1034_i0	PRJNA1105232	1248	449	1.5325	6.880925	Caenorhabditis elegans	6239	Nematoda	Nematoda	819	0	NTclustered	gi\|1879207294\|gb\|MT797802.1\|	6239	g1034	i0	99.555	96.0556792873051	449	2	100	0	1	449	765	317	Caenorhabditis elegans isolate KZN large subunit ribosomal RNA gene, partial sequence	blastn	43129	819	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
10415998	10415998	PRJNA1105232_S_NODE_13989_length_175_cov_1.238095_g13773_i0	PRJNA1105232	13989	175	1.238095	2.16666625	Caenorhabditis elegans	6239	Nematoda	Nematoda	324	2.83e-84	NTclustered	gi\|1972251482\|ref\|NM_063410.7\|	6239	g13773	i0	100	3	175	0	100	0	1	175	830	656	Caenorhabditis elegans Large ribosomal subunit protein uL18 (rpl-5), mRNA	blastn	525	324	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
10416037	10416037	PRJNA1105232_S_NODE_4329_length_280_cov_2.398268_g4113_i0	PRJNA1105232	4329	280	2.398268	6.7151504	Pristionchus sp. 10 RS5133	452805	Nematoda	Nematoda	235	2.3899999999999997e-57	NTclustered	gi\|150984485\|gb\|EF634885.1\|	452805	g4113	i0	81.786	21.2821428571429	280	51	100	0	1	280	149	428	Pristionchus sp. 10 RS5133 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	5959	235	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 10 RS5133
12966425	12966425	PRJNA1105232_S_NODE_16411_length_165_cov_0.896552_g16195_i0	PRJNA1105232	16411	165	0.896552	1.4793108	Caenorhabditis elegans	6239	Nematoda	Nematoda	305	9.59e-79	NTclustered	gi\|27543056\|gb\|AY171200.1\|	6239	g16195	i0	100	30.7515151515152	165	0	100	0	1	165	149	313	Caenorhabditis elegans isolate CB4857 cytochrome oxidase subunit III (COIII) gene, partial cds; tRNA-Thr gene, complete sequence; NADH dehydrogenase subunit 4 (ND4) and cytochrome oxidase subunit I (COI) genes, complete cds; tRNA-Cys, tRNA-Met, tRNA-Asp, and tRNA-Gly genes, complete sequence; cytochrome oxidase subunit II (COII) gene, complete cds; tRNA-His gene, complete sequence; and 16S ribosomal RNA gene, partial sequence; mitochondrial genes for mitochondrial products	blastn	5074	305	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
12966428	12966428	PRJNA1105232_S_NODE_16951_length_163_cov_1.368421_g16735_i0	PRJNA1105232	16951	163	1.368421	2.23052623	Caenorhabditis elegans	6239	Nematoda	Nematoda	302	1.22e-77	NTclustered	gi\|1972229135\|ref\|NM_059244.7\|	6239	g16735	i0	100	3.84049079754601	163	0	100	0	1	163	661	823	Caenorhabditis elegans CSD domain-containing protein (cey-2), mRNA	blastn	626	302	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
12966454	12966454	PRJNA1105232_S_NODE_7111_length_231_cov_1.142857_g6895_i0	PRJNA1105232	7111	231	1.142857	2.63999967	Caenorhabditis elegans	6239	Nematoda	Nematoda	427	2.9399999999999998e-115	NTclustered	gi\|27543091\|gb\|AY171207.1\|	6239	g6895	i0	100	98.5497835497836	231	0	100	0	1	231	4232	4002	Caenorhabditis elegans isolate TR403 cytochrome oxidase subunit III (COIII) gene, partial cds; tRNA-Thr gene, complete sequence; NADH dehydrogenase subunit 4 (ND4) and cytochrome oxidase subunit I (COI) genes, complete cds; tRNA-Cys, tRNA-Met, tRNA-Asp, and tRNA-Gly genes, complete sequence; cytochrome oxidase subunit II (COII) gene, complete cds; tRNA-His gene, complete sequence; and 16S ribosomal RNA gene, partial sequence; mitochondrial genes for mitochondrial products	blastn	22765	427	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
14241429	14241429	PRJNA1105232_S_NODE_5612_length_253_cov_3.504902_g5396_i0	PRJNA1105232	5612	253	3.504902	8.86740206	Caenorhabditis elegans	6239	Nematoda	Nematoda	468	1.92e-127	NTclustered	gi\|5834884\|ref\|NC_001328.1\|	6239	g5396	i0	100	94.4466403162055	253	0	100	0	1	253	2899	3151	Caenorhabditis elegans mitochondrion, complete genome	blastn	23895	468	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15515233	15515233	PRJNA1105232_S_NODE_6353_length_241_cov_2.119792_g6137_i0	PRJNA1105232	6353	241	2.119792	5.10869872	Caenorhabditis elegans	6239	Nematoda	Nematoda	399	6.729999999999998e-107	NTclustered	gi\|351059636\|emb\|FO080852.1\|	6239	g6137	i0	100	5.35269709543568	216	0	90	0	1	216	21131	21346	Caenorhabditis elegans Cosmid C44B12, complete sequence	blastn	1290	399	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
18871989	18871989	PRJNA1105232_S_NODE_2695_length_336_cov_15.261324_g2479_i0	PRJNA1105232	2695	336	15.261324	51.27804864	Caenorhabditis	6237	Nematoda	Nematoda	616	8.96e-172	NTclustered	gi\|25167357\|ref\|NR_000053.1\|	6239	g2479	i0	99.703	100.684523809524	337	0	100	1	1	336	914	578	Caenorhabditis elegans 18S ribosomal RNA (rrn-1.1), rRNA	blastn	33830	616	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19338411	19338411	PRJNA1105232_S_NODE_15736_length_167_cov_1.669492_g15520_i0	PRJNA1105232	15736	167	1.669492	2.78805164	Caenorhabditis elegans	6239	Nematoda	Nematoda	309	7.53e-80	NTclustered	gi\|1831509098\|ref\|NM_063983.6\|	6239	g15520	i0	100	7.62874251497006	167	0	100	0	1	167	288	454	Caenorhabditis elegans Small ribosomal subunit protein uS4 (rps-9), mRNA	blastn	1274	309	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19338445	19338445	PRJNA1105232_S_NODE_5196_length_261_cov_2.202830_g4980_i0	PRJNA1105232	5196	261	2.20283	5.7493863	Caenorhabditis elegans	6239	Nematoda	Nematoda	483	7.12e-132	NTclustered	gi\|152003245\|emb\|Z77659.2\|	6239	g4980	i0	100	5.86590038314176	261	0	100	0	1	261	24953	25213	Caenorhabditis elegans Cosmid F23B12, complete sequence	blastn	1531	483	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
20613714	20613714	PRJNA1105232_S_NODE_13137_length_180_cov_1.190840_g12921_i0	PRJNA1105232	13137	180	1.19084	2.143512	Pratylenchus vulnus	45931	Nematoda	Nematoda	52.8	0.015	NTclustered	gi\|1557394408\|emb\|LR031564.1\|	45931	g12921	i0	100	0.155555555555556	28	0	16	0	1	28	23	50	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
21889380	21889380	PRJNA1105232_S_NODE_16978_length_163_cov_1.368421_g16762_i0	PRJNA1105232	16978	163	1.368421	2.23052623	Caenorhabditis elegans	6239	Nematoda	Nematoda	302	1.22e-77	NTclustered	gi\|27543236\|gb\|AY171138.1\|	6239	g16762	i0	100	99.8282208588957	163	0	100	0	1	163	934	1096	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	16272	302	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
21889413	21889413	PRJNA1105232_S_NODE_5238_length_260_cov_1.260664_g5022_i0	PRJNA1105232	5238	260	1.260664	3.2777264	Caenorhabditis elegans	6239	Nematoda	Nematoda	481	2.55e-131	NTclustered	gi\|1972267516\|ref\|NM_070141.10\|	6239	g5022	i0	100	12.5038461538462	260	0	100	0	1	260	547	288	Caenorhabditis elegans Large ribosomal subunit protein uL11 (rpl-12), mRNA	blastn	3251	481	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
21889430	21889430	PRJNA1105232_S_NODE_9718_length_204_cov_2.683871_g9502_i0	PRJNA1105232	9718	204	2.683871	5.47509684	Caenorhabditis briggsae	6238	Nematoda	Nematoda	141	3.69e-29	NTclustered	gi\|2158428434\|ref\|XM_002640590.2\|	6238	g9502	i0	81.871	8.75490196078431	171	27	83	4	1	169	313	145	Caenorhabditis briggsae Protein CBR-RPS-20 (Cbr-rps-20), partial mRNA	blastn	1786	141	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
23164848	23164848	PRJNA1105232_S_NODE_14359_length_173_cov_1.258065_g14143_i0	PRJNA1105232	14359	173	1.258065	2.17645245	Caenorhabditis elegans	6239	Nematoda	Nematoda	320	3.61e-83	NTclustered	gi\|373219572\|emb\|FO081068.1\|	6239	g14143	i0	100	3	173	0	100	0	1	173	11339	11511	Caenorhabditis elegans Cosmid F02E8, complete sequence	blastn	519	320	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
24438483	24438483	PRJNA1105232_S_NODE_12640_length_183_cov_1.164179_g12424_i0	PRJNA1105232	12640	183	1.164179	2.13044757	Caenorhabditis elegans	6239	Nematoda	Nematoda	339	1.07e-88	NTclustered	gi\|1972242989\|ref\|NM_062531.8\|	6239	g12424	i0	100	13.1967213114754	183	0	100	0	1	183	333	151	Caenorhabditis elegans Large ribosomal subunit protein eL22 (rpl-22), mRNA	blastn	2415	339	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
24438537	24438537	PRJNA1105232_S_NODE_9420_length_207_cov_1.082278_g9204_i0	PRJNA1105232	9420	207	1.082278	2.24031546	Caenorhabditis elegans	6239	Nematoda	Nematoda	372	1.2199999999999997e-98	NTclustered	gi\|1972289026\|ref\|NM_072430.4\|	6239	g9204	i0	99.034	2.59420289855072	207	2	100	0	1	207	225	431	Caenorhabditis elegans KxDL domain-containing protein (kxd-1), mRNA	blastn	537	372	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans

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