metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA520845" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA520845" 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
489321	489321	PRJNA520845_P_NODE_181741_length_276_cov_1.517241_g180242_i0	PRJNA520845	181741	276	1.517241	4.18758516	Diplogastrellus sp. VS-2014	1538693	Nematoda	Nematoda	158	5.23e-34	NTclustered	gi\|675119125\|gb\|KJ877442.1\|	1538693	g180242	i0	82.447	53.1159420289855	188	25	67	7	26	209	64	247	Diplogastrellus sp. VS-2014 strain RS5608 small subunit ribosomal protein 27 (rps-27) mRNA, partial cds	blastn	14660	158	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Diplogastrellus	Diplogastrellus sp. VS-2014
1765743	1765743	PRJNA520845_P_NODE_225982_length_249_cov_0.875000_g224483_i0	PRJNA520845	225982	249	0.875	2.17875	Parastrongyloides trichosuri	131310	Nematoda	Nematoda	187	5.919999999999998e-43	NTclustered	gi\|9438175\|gb\|AF278536.1\|	131310	g224483	i0	81.696	16.1244979919679	224	41	90	0	5	228	2745	2522	Parastrongyloides trichosuri heat shock 70 protein gene, complete cds	blastn	4015	187	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Parastrongyloides	Parastrongyloides trichosuri
1767212	1767212	PRJNA520845_P_NODE_39282_length_602_cov_9.922495_g37812_i0	PRJNA520845	39282	602	9.922495	59.7334199	Bunonema sp. VS-2014	1538689	Nematoda	Nematoda	283	1.9400000000000002e-71	NTclustered	gi\|675119005\|gb\|KJ877382.1\|	1538689	g37812	i0	80.654	61.485049833887	367	69	61	2	85	450	402	37	Bunonema sp. VS-2014 strain RS9014 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	37014	283	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Bunonematidae	Bunonema	Bunonema sp. VS-2014
2387517	2387517	PRJNA520845_P_NODE_70882_length_441_cov_2.402174_g69383_i0	PRJNA520845	70882	441	2.402174	10.59358734	Caenorhabditis	6237	Nematoda	Nematoda	342	2.26e-89	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g69383	i0	86.164	71.0702947845805	318	43	72	1	46	363	375	59	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	31342	342	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
3039358	3039358	PRJNA520845_P_NODE_144603_length_311_cov_0.911765_g143104_i0	PRJNA520845	144603	311	0.911765	2.83558915	Pristionchus sp. 3 CZ3975	452810	Nematoda	Nematoda	176	1.65e-39	NTclustered	gi\|150984434\|gb\|EF634859.1\|	452810	g143104	i0	82.741	2.78135048231511	197	34	63	0	115	311	323	127	Pristionchus sp. 3 CZ3975 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	865	176	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 3 CZ3975
4318654	4318654	PRJNA520845_P_NODE_270344_length_212_cov_6.093525_g268845_i0	PRJNA520845	270344	212	6.093525	12.918273	Pristionchus sp. 11 RS5228	452806	Nematoda	Nematoda	115	2.3400000000000003e-21	NTclustered	gi\|150981873\|gb\|EF634506.1\|	452806	g268845	i0	91.566	37.9481132075472	83	7	39	0	87	169	58	140	Pristionchus sp. 11 RS5228 large subunit ribosomal protein 1 (rpl-1) mRNA, partial cds	blastn	8045	115	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 11 RS5228
5591332	5591332	PRJNA520845_P_NODE_115945_length_346_cov_1.326007_g114446_i0	PRJNA520845	115945	346	1.326007	4.58798422	Strongyloides ratti	34506	Nematoda	Nematoda	311	4.89e-80	NTclustered	gi\|1376154927\|ref\|XM_024651418.1\|	34506	g114446	i0	83.186	96.5086705202312	339	57	98	0	8	346	384	46	Strongyloides ratti Histone H3 (SRAE_X000165500), partial mRNA	blastn	33392	311	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
6870901	6870901	PRJNA520845_P_NODE_88526_length_394_cov_3.766355_g87027_i0	PRJNA520845	88526	394	3.766355	14.8394387	Strongyloides ratti	34506	Nematoda	Nematoda	375	1.97e-99	NTclustered	gi\|1376142265\|ref\|XM_024651434.1\|	34506	g87027	i0	84.103	99.1040609137056	390	60	99	2	1	389	727	1115	Strongyloides ratti Elongation factor 1-alpha (SRAE_2000058600), partial mRNA	blastn	39047	375	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
8765016	8765016	PRJNA520845_P_NODE_76147_length_425_cov_2.454545_g74648_i0	PRJNA520845	76147	425	2.454545	10.43181625	Opisthokonta	33154	Nematoda	Nematoda	396	1.64e-105	NTclustered	gi\|4160166\|emb\|AJ132193.1\|	6239	g74648	i0	85.09	91.1341176470588	389	56	91	2	2	389	447	60	Caenorhabditis elegans mRNA for calmodulin	blastn	38732	399	0.992481203007519	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
13245302	13245302	PRJNA520845_P_NODE_257611_length_243_cov_0.905882_g256112_i0	PRJNA520845	257611	243	0.905882	2.20129326	Caenorhabditis briggsae	6238	Nematoda	Nematoda	54.7	0.006	NTclustered	gi\|268530641\|ref\|XM_002630401.1\|	6238	g256112	i0	96.875	0.131687242798354	32	1	13	0	72	103	1759	1790	Caenorhabditis briggsae Protein CBG11180 (CBG11180), partial mRNA	blastn	32	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
13246453	13246453	PRJNA520845_P_NODE_62691_length_470_cov_2.007557_g61192_i0	PRJNA520845	62691	470	2.007557	9.4355179	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.4699999999999993e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g61192	i0	81.492	4.8	362	61	76	6	58	416	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
14522082	14522082	PRJNA520845_P_NODE_87632_length_396_cov_3.229102_g86133_i0	PRJNA520845	87632	396	3.229102	12.78724392	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.011	NTclustered	gi\|1831517864\|ref\|NM_001136422.4\|	6239	g86133	i0	100	0.292929292929293	29	0	7	0	315	343	36	8	Caenorhabditis elegans FIP (Fungus-Induced Protein) Related (fipr-2), partial mRNA	blastn	116	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
16413916	16413916	PRJNA520845_P_NODE_13413_length_1067_cov_2.113682_g12359_i0	PRJNA520845	13413	1067	2.113682	22.55298694	Metazoa	33208	Nematoda	Nematoda	407	2.01e-108	NTclustered	gi\|268619125\|gb\|GU130146.1\|	6326	g12359	i0	87.151	37.1724461105904	358	46	34	0	1	358	1081	1438	Bursaphelenchus xylophilus ATP synthase alpha chain mRNA, complete cds	blastn	39663	411	0.990267639902676	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
19613759	19613759	PRJNA520845_P_NODE_121496_length_338_cov_3.064151_g119997_i0	PRJNA520845	121496	338	3.064151	10.35683038	Caenorhabditis remanei	31234	Nematoda	Nematoda	182	3.9e-41	NTclustered	gi\|2445378119\|ref\|XM_003100380.2\|	31234	g119997	i0	85.882	33.3491124260355	170	24	50	0	93	262	194	25	Caenorhabditis remanei uncharacterized protein (GCK72_016568), partial mRNA	blastn	11272	182	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
19619053	19619053	PRJNA520845_P_NODE_82316_length_409_cov_1.684524_g80817_i0	PRJNA520845	82316	409	1.684524	6.88970316	Caenorhabditis briggsae	6238	Nematoda	Nematoda	320	9.75e-83	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g80817	i0	83.578	80.919315403423	341	56	83	0	2	342	78	418	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	33096	320	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
22166487	22166487	PRJNA520845_P_NODE_194558_length_266_cov_1.507772_g193059_i0	PRJNA520845	194558	266	1.507772	4.01067352	Strongyloides papillosus	174720	Nematoda	Nematoda	198	2.95e-46	NTclustered	gi\|687022642\|emb\|LM525556.1\|	174720	g193059	i0	84.038	10.2406015037594	213	26	79	5	39	247	971037	971245	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000002	blastn	2724	198	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
22166490	22166490	PRJNA520845_P_NODE_194638_length_266_cov_1.373057_g193139_i0	PRJNA520845	194638	266	1.373057	3.65233162	Caenorhabditis sp. 23 AD-2012	1196373	Nematoda	Nematoda	52.8	0.024	NTclustered	gi\|389958917\|gb\|JX078734.1\|	1196373	g193139	i0	94.118	0.511278195488722	34	2	13	0	159	192	435	468	Caenorhabditis sp. 23 AD-2012 strain VX0080 DPY-8 (dpy-8) gene, partial cds	blastn	136	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis sp. 23 AD-2012
23440446	23440446	PRJNA520845_P_NODE_133099_length_324_cov_1.063745_g131600_i0	PRJNA520845	133099	324	1.063745	3.4465338	Caenorhabditis elegans	6239	Nematoda	Nematoda	211	4.74e-50	NTclustered	gi\|6828\|emb\|X68492.1\|	6239	g131600	i0	82.979	71.4969135802469	235	39	72	1	40	273	274	40	C.elegans mRNA for rac1 homologue	blastn	23165	211	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);;