metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA867519" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA867519" 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
848070	848070	PRJNA867519_P_NODE_21121_length_271_cov_1.166667_g20967_i0	PRJNA867519	21121	271	1.166667	3.16166757	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	159	1.42e-34	NTclustered	gi\|524845304\|gb\|KC819362.1\|	1355913	g20967	i0	79.556	6.38376383763838	225	44	83	2	14	237	260	37	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 35 (rpl-35) mRNA, partial cds	blastn	1730	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus
4676630	4676630	PRJNA867519_P_NODE_5844_length_448_cov_2.464000_g5690_i0	PRJNA867519	5844	448	2.464	11.03872	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.35e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g5690	i0	81.492	5.03571428571429	362	61	80	6	46	404	37	395	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
7226273	7226273	PRJNA867519_P_NODE_17066_length_289_cov_0.824074_g16912_i0	PRJNA867519	17066	289	0.824074	2.38157386	Parapristionchus giblindavisi	1187980	Nematoda	Nematoda	178	4.23e-40	NTclustered	gi\|387600364\|gb\|JQ677914.1\|	1187980	g16912	i0	79.259	72.7301038062284	270	44	91	10	22	285	638	375	Diplogastridae gen. sp. EJR-2012 large ribosomal protein 2 mRNA, partial cds	blastn	21019	178	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Parapristionchus	Parapristionchus giblindavisi
8500994	8500994	PRJNA867519_P_NODE_23567_length_260_cov_1.235294_g23413_i0	PRJNA867519	23567	260	1.235294	3.2117644	Pristionchus sp. 13 RS5231	452807	Nematoda	Nematoda	82.4	3.02e-11	NTclustered	gi\|150982219\|gb\|EF634698.1\|	452807	g23413	i0	87.324	1.53461538461538	71	9	27	0	176	246	71	1	Pristionchus sp. 13 RS5231 large subunit ribosomal protein 29 (rpl-29) mRNA, complete cds	blastn	399	82.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 13 RS5231
8501059	8501059	PRJNA867519_P_NODE_32307_length_243_cov_0.905882_g32153_i0	PRJNA867519	32307	243	0.905882	2.20129326	Pristionchus uniformis	358041	Nematoda	Nematoda	165	2.6999999999999997e-36	NTclustered	gi\|150984659\|gb\|EF634991.1\|	358041	g32153	i0	82.812	42.5925925925926	192	25	76	6	46	230	4	194	Pristionchus uniformis small subunit ribosomal protein 28 (rps-28) mRNA, complete cds	blastn	10350	165	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus uniformis
11440719	11440719	PRJNA867519_P_NODE_12229_length_331_cov_2.271318_g12075_i0	PRJNA867519	12229	331	2.271318	7.51806258	Opisthokonta	33154	Nematoda	Nematoda	189	2.2799999999999993e-43	NTclustered	gi\|150982115\|gb\|EF634646.1\|	335527	g12075	i0	89.796	42.2205438066465	147	15	44	0	129	275	173	27	Pristionchus maupasi large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds	blastn	13975	189	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus maupasi
13601908	13601908	PRJNA867519_P_NODE_7111_length_412_cov_2.648968_g6957_i0	PRJNA867519	7111	412	2.648968	10.91374816	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	254	1.01e-62	NTclustered	gi\|150982261\|gb\|EF634719.1\|	452809	g6957	i0	83.333	13.9077669902913	276	42	67	4	110	383	303	30	Pristionchus sp. 15 RS5229 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	5730	254	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
14876183	14876183	PRJNA867519_P_NODE_3832_length_537_cov_1.879310_g3680_i0	PRJNA867519	3832	537	1.87931	10.0918947	Strongyloides ratti	34506	Nematoda	Nematoda	189	3.85e-43	NTclustered	gi\|1376142591\|ref\|XM_024651617.1\|	34506	g3680	i0	77.922	3.49906890130354	308	64	57	4	231	537	429	125	Strongyloides ratti Peptidyl-prolyl cis-trans isomerase D (SRAE_2000074700), partial mRNA	blastn	1879	189	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
18699449	18699449	PRJNA867519_P_NODE_22975_length_262_cov_1.629630_g22821_i0	PRJNA867519	22975	262	1.62963	4.2696306	Strongyloides papillosus	174720	Nematoda	Nematoda	84.2	8.48e-12	NTclustered	gi\|690018452\|emb\|LM525690.1\|	174720	g22821	i0	83.516	0.347328244274809	91	13	34	2	8	97	26564	26475	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000087	blastn	91	84.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
18699572	18699572	PRJNA867519_P_NODE_6635_length_425_cov_1.889205_g6481_i0	PRJNA867519	6635	425	1.889205	8.02912125	Strongyloides papillosus	174720	Nematoda	Nematoda	315	4.73e-81	NTclustered	gi\|687022644\|emb\|LM525558.1\|	174720	g6481	i0	80.324	57.0235294117647	432	71	100	11	1	425	232420	232844	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000004	blastn	24235	315	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
22524746	22524746	PRJNA867519_P_NODE_13878_length_314_cov_2.236515_g13724_i0	PRJNA867519	13878	314	2.236515	7.0226571	Pristionchus bucculentus	1317126	Nematoda	Nematoda	320	7.29e-83	NTclustered	gi\|479330856\|gb\|KC463849.1\|	1317126	g13724	i0	85.342	88.9108280254777	307	45	98	0	1	307	329	23	Pristionchus bucculentus strain RS5596 small subunit ribosomal protein 14 (rps14) gene, partial cds	blastn	27918	320	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus bucculentus
22524895	22524895	PRJNA867519_P_NODE_3738_length_542_cov_2.298507_g3586_i0	PRJNA867519	3738	542	2.298507	12.45790794	Rhabditolaimus sp. 1 VS-2014	1538706	Nematoda	Nematoda	292	2.88e-74	NTclustered	gi\|675118995\|gb\|KJ877377.1\|	1538706	g3586	i0	79.475	65.0221402214022	419	80	77	5	1	416	3	418	Rhabditolaimus sp. 1 VS-2014 strain RSA134 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	35242	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Rhabditolaimus	Rhabditolaimus sp. 1 VS-2014
25074167	25074167	PRJNA867519_P_NODE_18780_length_281_cov_1.480769_g18626_i0	PRJNA867519	18780	281	1.480769	4.16096089	Strongyloides ratti	34506	Nematoda	Nematoda	189	1.8899999999999993e-43	NTclustered	gi\|1376143271\|ref\|XM_024652004.1\|	34506	g18626	i0	81.435	15.8434163701068	237	38	83	6	1	234	135	368	Strongyloides ratti Histone H2A.v (SRAE_2000109300), partial mRNA	blastn	4452	189	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);;