metadata: contig_metadata: 21 rows where bioproject = "PRJNA994052" and tax

21 rows where bioproject = "PRJNA994052" 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
976458	976458	PRJNA994052_P_NODE_42601_length_253_cov_1112.416667_g41353_i0	PRJNA994052	42601	253	1112.416667	2814.41416751	Strongyloides ratti	34506	Nematoda	Nematoda	204	5.99e-48	NTclustered	gi\|1376141967\|ref\|XM_024651262.1\|	34506	g41353	i0	84.466	31.5928853754941	206	32	81	0	43	248	1039	1244	Strongyloides ratti Tubulin alpha-4 chain (SRAE_2000043300), partial mRNA	blastn	7993	204	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
976631	976631	PRJNA994052_P_NODE_57821_length_229_cov_33.512821_g56565_i0	PRJNA994052	57821	229	33.512821	76.74436009	Caenorhabditis elegans	6239	Nematoda	Nematoda	396	8.1899999999999985e-106	NTclustered	gi\|687865468\|emb\|LK927718.1\|	6239	g56565	i0	100	4.09170305676856	214	0	93	0	16	229	94360	94573	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000164	blastn	937	396	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
2251754	2251754	PRJNA994052_P_NODE_45542_length_248_cov_99.691429_g44292_i0	PRJNA994052	45542	248	99.691429	247.23474392	Caenorhabditis elegans	6239	Nematoda	Nematoda	418	1.9199999999999994e-112	NTclustered	gi\|1972228377\|ref\|NM_058998.8\|	6239	g44292	i0	99.563	3.66129032258065	229	1	92	0	20	248	544	316	Caenorhabditis elegans Large ribosomal subunit protein eL24 (rpl-24), mRNA	blastn	908	418	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
2251894	2251894	PRJNA994052_P_NODE_58342_length_228_cov_68.174194_g57086_i0	PRJNA994052	58342	228	68.174194	155.43716232	Caenorhabditis elegans	6239	Nematoda	Nematoda	385	1.76e-102	NTclustered	gi\|6425490\|emb\|AL132865.1\|	6239	g57086	i0	100	3.2280701754386	208	0	91	0	3	210	28323	28530	Caenorhabditis elegans YAC Y62E10A, complete sequence	blastn	736	385	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
3526843	3526843	PRJNA994052_P_NODE_25383_length_294_cov_4.986425_g24146_i0	PRJNA994052	25383	294	4.986425	14.6600895	Caenorhabditis elegans	6239	Nematoda	Nematoda	268	2.49e-67	NTclustered	gi\|1734337048\|ref\|NM_074285.4\|	6239	g24146	i0	99.324	2.36054421768708	148	1	95	0	144	291	226	79	Caenorhabditis elegans Transcription and mRNA export factor ENY2 (T01C3.2), mRNA	blastn	694	268	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
4804127	4804127	PRJNA994052_P_NODE_21884_length_304_cov_47.376623_g20656_i0	PRJNA994052	21884	304	47.376623	144.02493392	Caenorhabditis elegans	6239	Nematoda	Nematoda	446	1.11e-120	NTclustered	gi\|1359567\|emb\|Z73910.1\|	6239	g20656	i0	92.508	45.8947368421053	307	10	97	2	10	304	13113	13418	Caenorhabditis elegans Cosmid M117, complete sequence	blastn	13952	446	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7353983	7353983	PRJNA994052_P_NODE_24566_length_296_cov_9.766816_g23331_i0	PRJNA994052	24566	296	9.766816	28.90977536	Caenorhabditis elegans	6239	Nematoda	Nematoda	276	1.5e-69	NTclustered	gi\|1972288937\|ref\|NM_072391.7\|	6239	g23331	i0	100	2.91216216216216	149	0	96	0	3	151	164	312	Caenorhabditis elegans Uncharacterized protein (Y57E12AL.6), partial mRNA	blastn	862	276	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7354465	7354465	PRJNA994052_P_NODE_70266_length_212_cov_23.237410_g69010_i0	PRJNA994052	70266	212	23.23741	49.2633092	Caenorhabditis elegans	6239	Nematoda	Nematoda	148	2.3099999999999997e-31	NTclustered	gi\|687866387\|emb\|LK928740.1\|	6239	g69010	i0	97.674	3.23584905660377	86	2	81	0	127	212	15263	15178	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000377	blastn	686	148	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
9904869	9904869	PRJNA994052_P_NODE_60668_length_225_cov_16.125000_g59412_i0	PRJNA994052	60668	225	16.125	36.28125	Caenorhabditis elegans	6239	Nematoda	Nematoda	399	6.199999999999999e-107	NTclustered	gi\|1972235693\|ref\|NM_061034.9\|	6239	g59412	i0	99.543	4.43555555555556	219	1	97	0	7	225	807	589	Caenorhabditis elegans Small ribosomal subunit protein eS6 (rps-6), mRNA	blastn	998	399	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
9904915	9904915	PRJNA994052_P_NODE_64848_length_219_cov_24.431507_g63592_i0	PRJNA994052	64848	219	24.431507	53.50500033	Soboliphyme baturini	241478	Nematoda	Nematoda	88.2	1e-19	NR	VDP14147.1	241478	g63592	i0	66.7	0.863013698630137	63	21	86.3	0	197	9	126	188	VDP14147.1 unnamed protein product [Soboliphyme baturini]	diamond	189	88.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini
9905054	9905054	PRJNA994052_P_NODE_78088_length_203_cov_6.369231_g76831_i0	PRJNA994052	78088	203	6.369231	12.92953893	Caenorhabditis elegans	6239	Nematoda	Nematoda	344	2.6099999999999993e-90	NTclustered	gi\|351063832\|emb\|FO081505.1\|	6239	g76831	i0	100	2.7487684729064	186	0	92	0	18	203	10763	10578	Caenorhabditis elegans Cosmid F58F12, complete sequence	blastn	558	344	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11179573	11179573	PRJNA994052_P_NODE_24909_length_295_cov_14.162162_g23673_i0	PRJNA994052	24909	295	14.162162	41.7783779	Caenorhabditis elegans	6239	Nematoda	Nematoda	497	2.9299999999999998e-136	NTclustered	gi\|1972265037\|ref\|NM_001382918.2\|	6239	g23673	i0	99.273	6.37966101694915	275	2	93	0	18	292	626	352	Caenorhabditis elegans Large ribosomal subunit protein uL6 (rpl-9), mRNA	blastn	1882	497	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11179966	11179966	PRJNA994052_P_NODE_59109_length_227_cov_49.896104_g57853_i0	PRJNA994052	59109	227	49.896104	113.26415608	Caenorhabditis elegans	6239	Nematoda	Nematoda	387	4.88e-103	NTclustered	gi\|351061203\|emb\|FO081081.1\|	6239	g57853	i0	99.528	7.81057268722467	212	1	93	0	16	227	14749	14538	Caenorhabditis elegans Cosmid F54D7, complete sequence	blastn	1773	387	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
13729633	13729633	PRJNA994052_P_NODE_14191_length_314_cov_28.435685_g12970_i0	PRJNA994052	14191	314	28.435685	89.2880509	Caenorhabditis elegans	6239	Nematoda	Nematoda	433	8.98e-117	NTclustered	gi\|1734325763\|ref\|NM_065962.4\|	6239	g12970	i0	90.966	3.4203821656051	321	10	96	1	1	302	1048	1368	Caenorhabditis elegans putative imidazolonepropionase (amdh-1), mRNA	blastn	1074	433	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15004857	15004857	PRJNA994052_P_NODE_82932_length_197_cov_85.370968_g81675_i0	PRJNA994052	82932	197	85.370968	168.18080696	Caenorhabditis elegans	6239	Nematoda	Nematoda	355	1.16e-93	NTclustered	gi\|1972264646\|ref\|NM_066119.9\|	6239	g81675	i0	99.487	5.43654822335025	195	1	99	0	1	195	1329	1523	Caenorhabditis elegans Elongation factor 1-alpha (eef-1A.1), mRNA	blastn	1071	355	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
20102995	20102995	PRJNA994052_P_NODE_46236_length_247_cov_50.068966_g44985_i0	PRJNA994052	46236	247	50.068966	123.67034602	Caenorhabditis elegans	6239	Nematoda	Nematoda	425	1.14e-114	NTclustered	gi\|1831516917\|ref\|NM_072110.6\|	6239	g44985	i0	99.153	6.93927125506073	236	2	96	0	1	236	980	1215	Caenorhabditis elegans Phosphoglycolate phosphatase (pgph-3), mRNA	blastn	1714	425	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
21378905	21378905	PRJNA994052_P_NODE_68197_length_215_cov_4.316901_g66941_i0	PRJNA994052	68197	215	4.316901	9.28133715	Caenorhabditis elegans	6239	Nematoda	Nematoda	392	9.83e-105	NTclustered	gi\|687865716\|emb\|LK927668.1\|	6239	g66941	i0	99.537	4.02325581395349	216	0	100	1	1	215	111163	110948	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000122	blastn	865	392	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
23928979	23928979	PRJNA994052_P_NODE_41899_length_255_cov_13.719780_g40652_i0	PRJNA994052	41899	255	13.71978	34.985439	Caenorhabditis elegans	6239	Nematoda	Nematoda	460	3.25e-125	NTclustered	gi\|1972266193\|ref\|NM_067514.8\|	6239	g40652	i0	100	5.94117647058824	249	0	98	0	7	255	468	220	Caenorhabditis elegans Small ribosomal subunit protein eS24 (rps-24), mRNA	blastn	1515	460	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
26931582	26931582	PRJNA994052_P_NODE_55682_length_232_cov_50.761006_g54427_i0	PRJNA994052	55682	232	50.761006	117.76553392	Caenorhabditis remanei	31234	Nematoda	Nematoda	68.9	1.79e-11	NR	XP_053583521.1	31234	g54427	i0	59.6	2.41810344827586	47	19	60.8	0	231	91	354	400	XP_053583521.1 hypothetical protein GCK72_022008 [Caenorhabditis remanei]	diamond	561	68.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
27500633	27500633	PRJNA994052_P_NODE_82383_length_198_cov_20.440000_g81126_i0	PRJNA994052	82383	198	20.44	40.4712	Dictyocaulus viviparus	29172	Nematoda	Nematoda	49.3	3.09e-5	NR	KJH39900.1	29172	g81126	i0	42.9	3.18181818181818	42	24	63.6	0	127	2	9	50	KJH39900.1 hypothetical protein DICVIV_14198 [Dictyocaulus viviparus]	diamond	630	49.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Dictyocaulus	Dictyocaulus viviparus
32366205	32366205	PRJNA994052_P_NODE_30339_length_281_cov_13.360577_g29097_i0	PRJNA994052	30339	281	13.360577	37.54322137	Strongyloides ratti	34506	Nematoda	Nematoda	70.5	1.06e-11	NR	XP_024503532.1	34506	g29097	i0	42.9	4.44128113879004	84	46	88.6	2	249	1	1009	1091	XP_024503532.1 Splicing factor 3B subunit 3 [Strongyloides ratti]	diamond	1248	70.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti

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