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

21 rows where analysis = "blastn", bioproject = "PRJNA1122875" 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
277472	277472	PRJNA1122875_P_NODE_12921_length_464_cov_1.181586_g12698_i0	PRJNA1122875	12921	464	1.181586	5.48255904	Bunonema sp. VS-2014	1538689	Nematoda	Nematoda	226	2.5099999999999998e-54	NTclustered	gi\|675118911\|gb\|KJ877335.1\|	1538689	g12698	i0	78.963	6.54310344827586	347	61	73	9	4	344	512	172	Bunonema sp. VS-2014 strain RS9014 large subunit ribosomal protein 9 (rpl-9) mRNA, partial cds	blastn	3036	226	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Bunonematidae	Bunonema	Bunonema sp. VS-2014
277733	277733	PRJNA1122875_P_NODE_36141_length_276_cov_1.137931_g35917_i0	PRJNA1122875	36141	276	1.137931	3.14068956	Caenorhabditis briggsae	6238	Nematoda	Nematoda	54.7	0.007	NTclustered	gi\|268580048\|ref\|XM_002644961.1\|	6238	g35917	i0	100	0.105072463768116	29	0	11	0	149	177	482	454	Caenorhabditis briggsae Protein CBR-SYD-9 (Cbr-syd-9), partial mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
4104510	4104510	PRJNA1122875_P_NODE_16084_length_416_cov_2.448980_g15860_i0	PRJNA1122875	16084	416	2.44898	10.1877568	Rhabditolaimus sp. 1 VS-2014	1538706	Nematoda	Nematoda	294	6.02e-75	NTclustered	gi\|675118995\|gb\|KJ877377.1\|	1538706	g15860	i0	79.902	84.5	408	76	97	5	6	410	405	1	Rhabditolaimus sp. 1 VS-2014 strain RSA134 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	35152	294	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Rhabditolaimus	Rhabditolaimus sp. 1 VS-2014
4104750	4104750	PRJNA1122875_P_NODE_35064_length_279_cov_2.961165_g34840_i0	PRJNA1122875	35064	279	2.961165	8.26165035	Caenorhabditis remanei	31234	Nematoda	Nematoda	62.1	4.27e-5	NTclustered	gi\|308510043\|ref\|XM_003117157.1\|	31234	g34840	i0	86.441	0.211469534050179	59	4	20	3	213	269	282	226	Caenorhabditis remanei uncharacterized protein (GCK72_005418), partial mRNA	blastn	59	62.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
11232136	11232136	PRJNA1122875_P_NODE_4829_length_709_cov_7.916667_g4625_i0	PRJNA1122875	4829	709	7.916667	56.12916903	Opisthokonta	33154	Nematoda	Nematoda	350	2.2400000000000002e-91	NTclustered	gi\|112434095\|gb\|DQ861405.1\|	34508	g4625	i0	80.477	54.6107193229901	461	86	65	4	227	685	461	3	Steinernema carpocapsae cyclophilin mRNA, partial cds	blastn	38719	351	0.997150997150997	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
11756111	11756111	PRJNA1122875_P_NODE_26070_length_324_cov_1.533865_g25846_i0	PRJNA1122875	26070	324	1.533865	4.9697226	Caenorhabditis elegans	6239	Nematoda	Nematoda	239	2.18e-58	NTclustered	gi\|808358348\|ref\|NR_131525.1\|	6239	g25846	i0	84.426	30.9444444444444	244	36	75	2	68	310	1249	1007	Caenorhabditis elegans Non-coding transcript of protein-coding gene sams-4 (sams-4), miscRNA	blastn	10026	239	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11756142	11756142	PRJNA1122875_P_NODE_28410_length_308_cov_1.897872_g28186_i0	PRJNA1122875	28410	308	1.897872	5.84544576	Tylopharynx sp. WEM-2009	669147	Nematoda	Nematoda	161	4.58e-35	NTclustered	gi\|256709336\|gb\|GQ422343.1\|	669147	g28186	i0	80.556	2.93181818181818	216	36	69	5	1	213	186	398	Tylopharynx sp. WEM-2009 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	903	161	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylopharyngidae	Tylopharynx	Tylopharynx sp. WEM-2009
12507593	12507593	PRJNA1122875_P_NODE_52590_length_242_cov_0.911243_g52366_i0	PRJNA1122875	52590	242	0.911243	2.20520806	Opisthokonta	33154	Nematoda	Nematoda	159	1.2499999999999999e-34	NTclustered	gi\|3217630\|emb\|AL023815.1\|	6239	g52366	i0	79.221	10.5826446280992	231	46	95	2	3	232	6103	5874	Caenorhabditis elegans Fosmid H28O16, complete sequence	blastn	2561	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
13781938	13781938	PRJNA1122875_P_NODE_13511_length_453_cov_2.347368_g13287_i0	PRJNA1122875	13511	453	2.347368	10.63357704	Pristionchus	54125	Nematoda	Nematoda	193	2.48e-44	NTclustered	gi\|150982135\|gb\|EF634656.1\|	376547	g13287	i0	82.727	32.8189845474614	220	34	48	4	36	253	4	221	Pristionchus pseudaerivorus large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds	blastn	14867	193	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pseudaerivorus
13782115	13782115	PRJNA1122875_P_NODE_51191_length_243_cov_1.541176_g50967_i0	PRJNA1122875	51191	243	1.541176	3.74505768	Caenorhabditis	6237	Nematoda	Nematoda	63.9	1.01e-5	NTclustered	gi\|1972228534\|ref\|NM_001316854.4\|	6239	g50967	i0	95	0.625514403292181	40	2	16	0	4	43	47	86	Caenorhabditis elegans 60S ribosomal protein L41 (rpl-41.2), mRNA	blastn	152	63.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
14306564	14306564	PRJNA1122875_P_NODE_36512_length_274_cov_2.398010_g36288_i0	PRJNA1122875	36512	274	2.39801	6.5705474	Strongyloides ratti	34506	Nematoda	Nematoda	89.8	1.92e-13	NTclustered	gi\|1376149905\|ref\|XM_024643309.1\|	34506	g36288	i0	82.828	0.361313868613139	99	17	36	0	169	267	147	49	Strongyloides ratti 60S ribosomal protein L39 (SRAE_2000443800), partial mRNA	blastn	99	89.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
15580263	15580263	PRJNA1122875_P_NODE_13813_length_448_cov_2.533333_g13589_i0	PRJNA1122875	13813	448	2.533333	11.34933184	Pristionchus americanus	376549	Nematoda	Nematoda	224	8.689999999999999e-54	NTclustered	gi\|150982255\|gb\|EF634716.1\|	376549	g13589	i0	81.522	48.3303571428571	276	47	61	4	60	333	30	303	Pristionchus americanus large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	21652	224	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus americanus
16854772	16854772	PRJNA1122875_P_NODE_2174_length_942_cov_8.583429_g2029_i0	PRJNA1122875	2174	942	8.583429	80.85590118	Ancylostoma caninum	29170	Nematoda	Nematoda	54.7	0.026	NTclustered	gi\|334262922\|gb\|JF826240.1\|	29170	g2029	i0	100	0.0307855626326964	29	0	3	0	789	817	551	579	Ancylostoma caninum small GTPase cdc-42 mRNA, complete cds	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma caninum
16854947	16854947	PRJNA1122875_P_NODE_37374_length_271_cov_2.181818_g37150_i0	PRJNA1122875	37374	271	2.181818	5.91272678	Strongyloides ratti	34506	Nematoda	Nematoda	206	1.7999999999999998e-48	NTclustered	gi\|1376154049\|ref\|XM_024646386.1\|	34506	g37150	i0	83.796	1.61623616236162	216	35	80	0	1	216	1066	1281	Strongyloides ratti V-type proton ATPase subunit B, kidney (SRAE_X000121000), partial mRNA	blastn	438	206	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
16855179	16855179	PRJNA1122875_P_NODE_5754_length_659_cov_9.547782_g5542_i0	PRJNA1122875	5754	659	9.547782	62.91988338	Pristionchus uniformis	358041	Nematoda	Nematoda	222	4.72e-53	NTclustered	gi\|256861444\|gb\|GQ422182.1\|	358041	g5542	i0	77.72	18.2245827010622	386	70	57	14	235	612	151	528	Pristionchus uniformis large subunit ribosomal protein 9 (rpl-9) mRNA, partial cds	blastn	12010	222	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus uniformis
18129308	18129308	PRJNA1122875_P_NODE_26515_length_321_cov_1.548387_g26291_i0	PRJNA1122875	26515	321	1.548387	4.97032227	Caenorhabditis elegans	6239	Nematoda	Nematoda	215	3.63e-51	NTclustered	gi\|1972235554\|ref\|NM_001025879.7\|	6239	g26291	i0	91.613	49.3052959501558	155	13	48	0	3	157	1152	1306	Caenorhabditis elegans Tubulin alpha-2 chain (tba-2), mRNA	blastn	15827	215	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19403631	19403631	PRJNA1122875_P_NODE_42276_length_253_cov_2.138889_g42052_i0	PRJNA1122875	42276	253	2.138889	5.41138917	Pristionchus sp. 3 CZ3975	452810	Nematoda	Nematoda	139	1.71e-28	NTclustered	gi\|150982009\|gb\|EF634593.1\|	452810	g42052	i0	81.111	5.32411067193676	180	28	70	6	70	246	37	213	Pristionchus sp. 3 CZ3975 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	1347	139	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 3 CZ3975
20679294	20679294	PRJNA1122875_P_NODE_50177_length_244_cov_1.526316_g49953_i0	PRJNA1122875	50177	244	1.526316	3.72421104	Pristionchus lheritieri	70414	Nematoda	Nematoda	206	1.6e-48	NTclustered	gi\|150981851\|gb\|EF634495.1\|	70414	g49953	i0	83.796	25.016393442623	216	35	89	0	1	216	393	178	Pristionchus lheritieri large subunit ribosomal protein 1 (rpl-1) mRNA, partial cds	blastn	6104	206	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus lheritieri
20679347	20679347	PRJNA1122875_P_NODE_54117_length_240_cov_2.239521_g53893_i0	PRJNA1122875	54117	240	2.239521	5.3748504	Parapristionchus giblindavisi	1187980	Nematoda	Nematoda	154	5.75e-33	NTclustered	gi\|387600364\|gb\|JQ677914.1\|	1187980	g53893	i0	84.516	7.08333333333333	155	24	65	0	53	207	1	155	Diplogastridae gen. sp. EJR-2012 large ribosomal protein 2 mRNA, partial cds	blastn	1700	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Parapristionchus	Parapristionchus giblindavisi
21954406	21954406	PRJNA1122875_P_NODE_29938_length_299_cov_1.929204_g29714_i0	PRJNA1122875	29938	299	1.929204	5.76831996	Caenorhabditis elegans	6239	Nematoda	Nematoda	189	2.0299999999999993e-43	NTclustered	gi\|863015\|gb\|U27559.1\|CEU27559	6239	g29714	i0	81.858	11.2675585284281	226	39	75	2	66	290	70	294	Caenorhabditis elegans cyclophilin (cyp-7) mRNA, complete cds	blastn	3369	189	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
21954748	21954748	PRJNA1122875_P_NODE_8458_length_563_cov_8.038776_g8240_i0	PRJNA1122875	8458	563	8.038776	45.25830888	Pristionchus sp. 10 RS5133	452805	Nematoda	Nematoda	235	5.129999999999999e-57	NTclustered	gi\|150982251\|gb\|EF634714.1\|	452805	g8240	i0	81.851	26.9857904085258	281	49	50	2	236	515	303	24	Pristionchus sp. 10 RS5133 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	15193	235	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 10 RS5133

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