metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA315399" 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
382799	382799	PRJNA315399_P_NODE_362441_length_166_cov_208.364341_g361993_i0	PRJNA315399	362441	166	208.364341	345.88480606	Caenorhabditis elegans	6239	Nematoda	Nematoda	62.1	2.31e-5	NTclustered	gi\|3217673\|emb\|Z79603.1\|	6239	g361993	i0	100	0.397590361445783	33	0	20	0	115	147	14822	14854	Caenorhabditis elegans Cosmid M163, complete sequence	blastn	66	62.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
385295	385295	PRJNA315399_S_NODE_47061_length_218_cov_5.381215_g46860_i0	PRJNA315399	47061	218	5.381215	11.7310487	Caenorhabditis elegans	6239	Nematoda	Nematoda	396	7.729999999999997e-106	NTclustered	gi\|351058185\|emb\|FO080659.1\|	6239	g46860	i0	100	7.77064220183486	214	0	98	0	3	216	27009	27222	Caenorhabditis elegans Cosmid C42D8, complete sequence	blastn	1694	396	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
1656102	1656102	PRJNA315399_P_NODE_124442_length_193_cov_4.224359_g123994_i0	PRJNA315399	124442	193	4.224359	8.15301287	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.017	NTclustered	gi\|412984014\|emb\|FO081581.2\|	6239	g123994	i0	100	0.435233160621762	28	0	15	0	34	61	103860	103887	Caenorhabditis elegans YAC Y77E11A, complete sequence	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
1660007	1660007	PRJNA315399_S_NODE_44502_length_222_cov_1.583784_g44301_i0	PRJNA315399	44502	222	1.583784	3.51600048	Caenorhabditis elegans	6239	Nematoda	Nematoda	394	2.839999999999999e-105	NTclustered	gi\|687865614\|emb\|LK927765.1\|	6239	g44301	i0	100	2.87837837837838	213	0	96	0	1	213	98718	98506	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000029	blastn	639	394	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
1660272	1660272	PRJNA315399_S_NODE_68542_length_197_cov_4.668750_g68341_i0	PRJNA315399	68542	197	4.66875	9.1974375	Caenorhabditis elegans	6239	Nematoda	Nematoda	340	3.2499999999999995e-89	NTclustered	gi\|687865940\|emb\|LK928062.1\|	6239	g68341	i0	100	2.71573604060914	184	0	93	0	14	197	20918	20735	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000088	blastn	535	340	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
2933666	2933666	PRJNA315399_P_NODE_402023_length_161_cov_5.411290_g401575_i0	PRJNA315399	402023	161	5.41129	8.7121769	Caenorhabditis elegans	6239	Nematoda	Nematoda	137	3.59e-28	NTclustered	gi\|1627677\|emb\|Z81049.1\|	6239	g401575	i0	100	3.1055900621118	74	0	88	0	75	148	898	971	Caenorhabditis elegans Cosmid C48D1, complete sequence	blastn	500	137	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
2936402	2936402	PRJNA315399_S_NODE_93283_length_182_cov_1.524138_g93082_i0	PRJNA315399	93283	182	1.524138	2.77393116	Caenorhabditis remanei	31234	Nematoda	Nematoda	89.8	1.18e-13	NTclustered	gi\|308510043\|ref\|XM_003117157.1\|	31234	g93082	i0	85.714	1.90659340659341	84	12	46	0	5	88	208	291	Caenorhabditis remanei uncharacterized protein (GCK72_005418), partial mRNA	blastn	347	89.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
4213190	4213190	PRJNA315399_S_NODE_98564_length_179_cov_3.676056_g98363_i0	PRJNA315399	98564	179	3.676056	6.58014024	Caenorhabditis elegans	6239	Nematoda	Nematoda	303	3.79e-78	NTclustered	gi\|1879207294\|gb\|MT797802.1\|	6239	g98363	i0	100	84.7094972067039	164	0	92	0	16	179	76	239	Caenorhabditis elegans isolate KZN large subunit ribosomal RNA gene, partial sequence	blastn	15163	303	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
5485104	5485104	PRJNA315399_P_NODE_172005_length_187_cov_2.446667_g171557_i0	PRJNA315399	172005	187	2.446667	4.57526729	Strongyloides ratti	34506	Nematoda	Nematoda	54.7	0.004	NTclustered	gi\|1376143845\|ref\|XM_024652339.1\|	34506	g171557	i0	96.97	0.176470588235294	33	0	18	1	12	44	39	8	Strongyloides ratti Methionine-R-sulfoxide reductase B2, mitochondrial (SRAE_2000139300), partial mRNA	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
5488386	5488386	PRJNA315399_S_NODE_180725_length_153_cov_8.672414_g180524_i0	PRJNA315399	180725	153	8.672414	13.26879342	Caenorhabditis elegans	6239	Nematoda	Nematoda	248	1.49e-61	NTclustered	gi\|1734335165\|ref\|NM_073049.2\|	6239	g180524	i0	100	2.65359477124183	134	0	88	0	20	153	949	1082	Caenorhabditis elegans 3-hydroxyanthranilate 3,4-dioxygenase (haao-1), mRNA	blastn	406	248	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
5489254	5489254	PRJNA315399_S_NODE_79185_length_190_cov_1.503268_g78984_i0	PRJNA315399	79185	190	1.503268	2.8562092	Caenorhabditis elegans	6239	Nematoda	Nematoda	351	1.4399999999999997e-92	NTclustered	gi\|687865357\|emb\|LK927775.1\|	6239	g78984	i0	100	3.59473684210526	190	0	100	0	1	190	101634	101445	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000030	blastn	683	351	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
6759796	6759796	PRJNA315399_P_NODE_249926_length_182_cov_2.268966_g249478_i0	PRJNA315399	249926	182	2.268966	4.12951812	Strongyloides ratti	34506	Nematoda	Nematoda	52.8	0.015	NTclustered	gi\|1376140387\|ref\|XM_024650524.1\|	34506	g249478	i0	100	0.153846153846154	28	0	15	0	120	147	2367	2394	Strongyloides ratti Restin homolog (SRAE_1000334500), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
8036891	8036891	PRJNA315399_P_NODE_508507_length_150_cov_5.061947_g508059_i0	PRJNA315399	508507	150	5.061947	7.5929205	Strongyloides ratti	34506	Nematoda	Nematoda	54.7	0.003	NTclustered	gi\|1376153711\|ref\|XM_024648474.1\|	34506	g508059	i0	100	0.193333333333333	29	0	19	0	104	132	919	947	Strongyloides ratti Gamma-aminobutyric acid A receptor/Glycine receptor alpha family and Neurotransmitter-gated ion-channel transmembrane domain and Neurotransmitter-gated ion-channel family and Neurotransmitter-gated ion-channel ligand-binding domain-containing protein (SRAE_X000104100), partial mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
8037729	8037729	PRJNA315399_S_NODE_142767_length_163_cov_2.063492_g142566_i0	PRJNA315399	142767	163	2.063492	3.36349196	Caenorhabditis elegans	6239	Nematoda	Nematoda	302	1.22e-77	NTclustered	gi\|687865316\|emb\|LK927611.1\|	6239	g142566	i0	100	6.17177914110429	163	0	100	0	1	163	68618	68780	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000075	blastn	1006	302	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
10585199	10585199	PRJNA315399_P_NODE_131169_length_191_cov_19.584416_g130721_i0	PRJNA315399	131169	191	19.584416	37.40623456	Caenorhabditis elegans	6239	Nematoda	Nematoda	65.8	2.11e-6	NTclustered	gi\|351059653\|emb\|FO080855.1\|	6239	g130721	i0	100	0.366492146596859	35	0	18	0	3	37	17195	17229	Caenorhabditis elegans Cosmid F53H8, complete sequence	blastn	70	65.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
10588320	10588320	PRJNA315399_S_NODE_149669_length_161_cov_2.282258_g149468_i0	PRJNA315399	149669	161	2.282258	3.67443538	Caenorhabditis elegans	6239	Nematoda	Nematoda	270	3.389999999999999e-68	NTclustered	gi\|1972231765\|ref\|NM_060044.7\|	6239	g149468	i0	98.693	2.85093167701863	153	0	95	2	9	161	660	810	Caenorhabditis elegans putative NADH dehydrogenase [ubiquinone] iron-sulfur protein 7, mitochondrial (nduf-7), partial mRNA	blastn	459	270	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11269755	11269755	PRJNA315399_S_NODE_123109_length_169_cov_3.318182_g122908_i0	PRJNA315399	123109	169	3.318182	5.60772758	Metazoa	33208	Nematoda	Nematoda	145	2.26e-30	NTclustered	gi\|158821894\|gb\|EU195958.1\|	473172	g122908	i0	94.624	55.4674556213018	93	5	55	0	1	93	1984	1892	Protorhabditis sp. JB122 28S ribosomal RNA gene, partial sequence	blastn	9374	145	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Protorhabditis	Protorhabditis sp. JB122
13137966	13137966	PRJNA315399_S_NODE_111671_length_173_cov_5.573529_g111470_i0	PRJNA315399	111671	173	5.573529	9.64220517	Caenorhabditis elegans	6239	Nematoda	Nematoda	265	1.7099999999999998e-66	NTclustered	gi\|12232093\|gb\|AF326939.1\|AF326939	6239	g111470	i0	100	3.30057803468208	143	0	83	0	14	156	468	326	Caenorhabditis elegans mitochondrial ATPase inhibitor (4E151) mRNA, concentrated in young embryos, complete cds	blastn	571	265	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15686559	15686559	PRJNA315399_P_NODE_76013_length_213_cov_79.329545_g75565_i0	PRJNA315399	76013	213	79.329545	168.97193085	Caenorhabditis elegans	6239	Nematoda	Nematoda	67.6	6.69e-7	NTclustered	gi\|413006740\|emb\|Z83114.2\|	6239	g75565	i0	100	0.657276995305164	36	0	33	0	100	135	830	795	Caenorhabditis elegans Cosmid K09B11, complete sequence	blastn	140	67.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19510564	19510564	PRJNA315399_S_NODE_151016_length_160_cov_9.869919_g150815_i0	PRJNA315399	151016	160	9.869919	15.7918704	Pristionchus marianneae	376546	Nematoda	Nematoda	102	1.3e-17	NTclustered	gi\|150982017\|gb\|EF634597.1\|	376546	g150815	i0	90.909	17.91875	77	5	48	2	1	76	321	396	Pristionchus marianneae large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2867	102	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus marianneae
20783744	20783744	PRJNA315399_P_NODE_280417_length_180_cov_2.286713_g279969_i0	PRJNA315399	280417	180	2.286713	4.1160834	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.015	NTclustered	gi\|687865811\|emb\|LK927995.1\|	6239	g279969	i0	100	0.311111111111111	28	0	16	0	3	30	29122	29095	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000394	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
22058226	22058226	PRJNA315399_P_NODE_187918_length_185_cov_11.777027_g187470_i0	PRJNA315399	187918	185	11.777027	21.78749995	Strongyloides papillosus	174720	Nematoda	Nematoda	54.7	0.004	NTclustered	gi\|690019276\|emb\|LM526791.1\|	174720	g187470	i0	100	0.156756756756757	29	0	16	0	17	45	1125	1097	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0001131	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
22743100	22743100	PRJNA315399_P_NODE_489338_length_152_cov_3.791304_g488890_i0	PRJNA315399	489338	152	3.791304	5.76278208	Metazoa	33208	Nematoda	Nematoda	58.4	2.67e-4	NTclustered	gi\|268562310\|ref\|XM_002646594.1\|	6238	g488890	i0	100	0.631578947368421	31	0	20	0	27	57	312	282	Caenorhabditis briggsae Protein CBG11072 (CBG11072), partial mRNA	blastn	96	58.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
23335423	23335423	PRJNA315399_P_NODE_466299_length_154_cov_5.854701_g465851_i0	PRJNA315399	466299	154	5.854701	9.01623954	Caenorhabditis elegans	6239	Nematoda	Nematoda	122	9.499999999999999e-24	NTclustered	gi\|687865720\|emb\|LK927684.1\|	6239	g465851	i0	98.551	10.3311688311688	69	1	85	0	75	143	119119	119187	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000135	blastn	1591	122	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
24608356	24608356	PRJNA315399_P_NODE_265180_length_181_cov_2.173611_g264732_i0	PRJNA315399	265180	181	2.173611	3.93423591	Brugia malayi	6279	Nematoda	Nematoda	56.5	0.001	NTclustered	gi\|2082282854\|ref\|XM_043079719.1\|	6279	g264732	i0	100	4.08839779005525	30	0	17	0	30	59	585	614	Brugia malayi Uncharacterized protein (Bma-wts-1), partial mRNA	blastn	740	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
24611087	24611087	PRJNA315399_S_NODE_196700_length_150_cov_4.265487_g196499_i0	PRJNA315399	196700	150	4.265487	6.3982305	Caenorhabditis elegans	6239	Nematoda	Nematoda	122	9.18e-24	NTclustered	gi\|687867850\|emb\|LK930041.1\|	6239	g196499	i0	84.173	1.85333333333333	139	8	91	8	15	150	1870	1743	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0001540	blastn	278	122	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);;