metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA615351" 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
595448	595448	PRJNA615351_P_NODE_104701_length_299_cov_1.590909_g90602_i0	PRJNA615351	104701	299	1.590909	4.75681791	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	150	9.58e-32	NTclustered	gi\|150984457\|gb\|EF634871.1\|	452809	g90602	i0	80.193	25.6153846153846	207	35	68	5	83	286	329	126	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	7659	150	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
1871534	1871534	PRJNA615351_P_NODE_132242_length_221_cov_1.801075_g118142_i0	PRJNA615351	132242	221	1.801075	3.98037575	Pristionchus pauli	376545	Nematoda	Nematoda	117	6.85e-22	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g118142	i0	80.247	1.46606334841629	162	26	72	6	1	159	195	37	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	324	117	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
3146755	3146755	PRJNA615351_P_NODE_69843_length_502_cov_3.301927_g55968_i0	PRJNA615351	69843	502	3.301927	16.57567354	Trichinella spiralis	6334	Nematoda	Nematoda	54.7	0.014	NTclustered	gi\|339241046\|ref\|XM_003376401.1\|	6334	g55968	i0	100	0.113545816733068	29	0	6	0	322	350	3067	3039	Trichinella spiralis paired amphipathic helix repeat family protein (Tsp_00655) mRNA, complete cds	blastn	57	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
14624544	14624544	PRJNA615351_P_NODE_178792_length_157_cov_1.311475_g164692_i0	PRJNA615351	178792	157	1.311475	2.05901575	Eucephalobus striatus	293681	Nematoda	Nematoda	291	2.52e-74	NTclustered	gi\|308053077\|gb\|HM439769.1\|	293681	g164692	i0	100	99.8216560509554	157	0	100	0	1	157	252	96	Eucephalobus striatus isolate 5974 28S large subunit ribosomal RNA gene, partial sequence	blastn	15672	291	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Cephalobidae	Eucephalobus	Eucephalobus striatus
15898865	15898865	PRJNA615351_P_NODE_7473_length_2304_cov_3.511238_g5316_i0	PRJNA615351	7473	2304	3.511238	80.89892352	Necator americanus	51031	Nematoda	Nematoda	71.3	6.59e-7	NTclustered	gi\|2707583078\|ref\|XM_013447403.2\|	51031	g5316	i0	100	0.33203125	38	0	2	0	185	222	746	709	Necator americanus uncharacterized protein (RB195_001097), partial mRNA	blastn	765	71.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
22827375	22827375	PRJNA615351_P_NODE_173478_length_162_cov_1.259843_g159378_i0	PRJNA615351	173478	162	1.259843	2.04094566	Metazoa	33208	Nematoda	Nematoda	298	1.57e-76	NTclustered	gi\|1174020828\|gb\|KY887583.1\|	6293	g159378	i0	100	99.3888888888889	161	0	99	0	2	162	1752	1592	Wuchereria bancrofti isolate AP10 small subunit ribosomal RNA gene, partial sequence	blastn	16101	298	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Wuchereria	Wuchereria bancrofti
23547983	23547983	PRJNA615351_P_NODE_104079_length_301_cov_2.090226_g89980_i0	PRJNA615351	104079	301	2.090226	6.29158026	Caenorhabditis elegans	6239	Nematoda	Nematoda	180	1.2299999999999999e-40	NTclustered	gi\|351049668\|emb\|FO080387.1\|	6239	g89980	i0	82.915	31.6013289036545	199	34	68	0	8	206	23715	23517	Caenorhabditis elegans Cosmid C06E7, complete sequence	blastn	9512	180	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
24101733	24101733	PRJNA615351_P_NODE_115919_length_261_cov_6.460177_g101820_i0	PRJNA615351	115919	261	6.460177	16.86106197	Metazoa	33208	Nematoda	Nematoda	233	7.919999999999999e-57	NTclustered	gi\|339232973\|ref\|XM_003381556.1\|	6334	g101820	i0	82.955	196.157088122605	264	39	100	5	1	261	387	127	Trichinella spiralis ubiquitin family protein (Tsp_07290) mRNA, partial cds	blastn	51197	233	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
25376440	25376440	PRJNA615351_P_NODE_77360_length_443_cov_9.031863_g63343_i0	PRJNA615351	77360	443	9.031863	40.01115309	Caenorhabditis	6237	Nematoda	Nematoda	63.9	1.98e-5	NTclustered	gi\|1972228534\|ref\|NM_001316854.4\|	6239	g63343	i0	95	0.37020316027088	40	2	9	0	372	411	86	47	Caenorhabditis elegans 60S ribosomal protein L41 (rpl-41.2), mRNA	blastn	164	63.9	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);;