metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1186363" 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
1594547	1594547	PRJNA1186363_P_NODE_7602_length_765_cov_7.060694_g4644_i1	PRJNA1186363	7602	765	7.060694	54.0143091	Caenorhabditis elegans	6239	Nematoda	Nematoda	180	3.3699999999999993e-40	NTclustered	gi\|1972261274\|ref\|NM_001384026.2\|	6239	g4644	i1	80.335	11.1660130718954	239	45	31	2	220	457	138	375	Caenorhabditis elegans ATP synthase c subunit (Y82E9BR.3), mRNA	blastn	8542	180	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
5422949	5422949	PRJNA1186363_P_NODE_43665_length_242_cov_0.923077_g42777_i0	PRJNA1186363	43665	242	0.923077	2.23384634	Caenorhabditis remanei	31234	Nematoda	Nematoda	178	3.45e-40	NTclustered	gi\|2445367962\|ref\|XM_053728326.1\|	31234	g42777	i0	80.519	11.5165289256198	231	45	95	0	11	241	1023	1253	Caenorhabditis remanei uncharacterized protein (GCK72_011264), partial mRNA	blastn	2787	178	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
7973158	7973158	PRJNA1186363_P_NODE_9827_length_662_cov_11.920204_g8954_i0	PRJNA1186363	9827	662	11.920204	78.91175048	Caenorhabditis elegans	6239	Nematoda	Nematoda	270	1.6699999999999994e-67	NTclustered	gi\|1734332162\|ref\|NM_070257.4\|	6239	g8954	i0	80.98	38.332326283987904	347	60	52	5	165	508	435	92	Caenorhabditis elegans NIF system FeS cluster assembly NifU N-terminal domain-containing protein (iscu-1), mRNA	blastn	25376	270	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
9970092	9970092	PRJNA1186363_P_NODE_26428_length_349_cov_1.130435_g25540_i0	PRJNA1186363	26428	349	1.130435	3.94521815	Metazoa	33208	Nematoda	Nematoda	58.4	7.08e-4	NTclustered	gi\|872091\|emb\|Z49912.1\|	6239	g25540	i0	100	1.73638968481375	31	0	9	0	75	105	5741	5711	Caenorhabditis elegans Cosmid T24F1, complete sequence	blastn	606	58.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11798234	11798234	PRJNA1186363_P_NODE_10010_length_655_cov_13.226804_g9133_i0	PRJNA1186363	10010	655	13.226804	86.6355662	Caenorhabditis elegans	6239	Nematoda	Nematoda	261	9.95e-65	NTclustered	gi\|1734332162\|ref\|NM_070257.4\|	6239	g9133	i0	81.62	40.7832061068702	321	53	49	5	184	501	409	92	Caenorhabditis elegans NIF system FeS cluster assembly NifU N-terminal domain-containing protein (iscu-1), mRNA	blastn	26713	261	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11798412	11798412	PRJNA1186363_P_NODE_34550_length_281_cov_0.870192_g33662_i0	PRJNA1186363	34550	281	0.870192	2.44523952	Trichinella spiralis	6334	Nematoda	Nematoda	54.7	0.007	NTclustered	gi\|339237868\|ref\|XM_003380441.1\|	6334	g33662	i0	100	0.213523131672598	29	0	10	0	150	178	1195	1223	Trichinella spiralis conserved hypothetical protein (Tsp_06171) mRNA, complete cds	blastn	60	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
11798438	11798438	PRJNA1186363_P_NODE_38490_length_253_cov_0.866667_g37602_i0	PRJNA1186363	38490	253	0.866667	2.19266751	Cylicocyclus nassatus	53992	Nematoda	Nematoda	187	6.0299999999999984e-43	NTclustered	gi\|159144810\|gb\|EU251438.1\|	53992	g37602	i0	92.969	52.2134387351779	128	9	51	0	126	253	1301	1174	Cylicocyclus nassatus isolate FBZ-S clone 10 beta-tubulin isotype 2 mRNA, complete cds	blastn	13210	187	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Cylicocyclus	Cylicocyclus nassatus
14348697	14348697	PRJNA1186363_P_NODE_17492_length_462_cov_25.868895_g16605_i0	PRJNA1186363	17492	462	25.868895	119.5142949	Caenorhabditis remanei	31234	Nematoda	Nematoda	165	5.52e-36	NTclustered	gi\|2445378119\|ref\|XM_003100380.2\|	31234	g16605	i0	84.118	21.1450216450216	170	27	37	0	207	376	194	25	Caenorhabditis remanei uncharacterized protein (GCK72_016568), partial mRNA	blastn	9769	165	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
14348849	14348849	PRJNA1186363_P_NODE_40532_length_249_cov_0.886364_g39644_i0	PRJNA1186363	40532	249	0.886364	2.20704636	Caenorhabditis elegans	6239	Nematoda	Nematoda	62.1	3.74e-5	NTclustered	gi\|351050007\|emb\|FO080488.1\|	6239	g39644	i0	97.222	0.433734939759036	36	1	14	0	154	189	8904	8939	Caenorhabditis elegans Cosmid F41E6, complete sequence	blastn	108	62.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
21996515	21996515	PRJNA1186363_P_NODE_38718_length_252_cov_1.307263_g37830_i0	PRJNA1186363	38718	252	1.307263	3.29430276	Strongyloides ratti	34506	Nematoda	Nematoda	134	7.93e-27	NTclustered	gi\|1376155559\|ref\|XM_024654984.1\|	34506	g37830	i0	88.288	8.09523809523809	111	13	44	0	139	249	2287	2397	Strongyloides ratti V-type ATPase, V0 complex, 116kDa subunit family and ATPase, V0 complex, subunit 116kDa, eukaryotic family-containing protein (SRAE_X000197400), partial mRNA	blastn	2040	134	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
23271835	23271835	PRJNA1186363_P_NODE_17779_length_458_cov_1.090909_g16891_i0	PRJNA1186363	17779	458	1.090909	4.99636322	Strongyloides papillosus	174720	Nematoda	Nematoda	99	5.63e-16	NTclustered	gi\|687022734\|emb\|LM525648.1\|	174720	g16891	i0	93.846	0.141921397379913	65	4	14	0	67	131	8174	8110	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000040	blastn	65	99	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
24545724	24545724	PRJNA1186363_P_NODE_24860_length_365_cov_1.431507_g23972_i0	PRJNA1186363	24860	365	1.431507	5.22500055	Meloidogyne incognita	6306	Nematoda	Nematoda	178	5.4799999999999986e-40	NTclustered	gi\|1120600895\|gb\|KX426061.1\|	6306	g23972	i0	78.571	4.35342465753425	280	52	76	8	89	364	25	300	Meloidogyne incognita clone 1 14-3-3 protein mRNA, complete cds	blastn	1589	178	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne incognita
24545799	24545799	PRJNA1186363_P_NODE_38000_length_254_cov_1.723757_g37112_i0	PRJNA1186363	38000	254	1.723757	4.37834278	Necator americanus	51031	Nematoda	Nematoda	56.5	0.002	NTclustered	gi\|2707568959\|ref\|XM_064195980.1\|	51031	g37112	i0	100	0.669291338582677	30	0	12	0	168	197	901	872	Necator americanus uncharacterized protein (RB195_009134), partial mRNA	blastn	170	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
24545846	24545846	PRJNA1186363_P_NODE_5320_length_920_cov_7.168831_g4644_i0	PRJNA1186363	5320	920	7.168831	65.9532452	Caenorhabditis elegans	6239	Nematoda	Nematoda	182	1.1399999999999999e-40	NTclustered	gi\|1972261274\|ref\|NM_001384026.2\|	6239	g4644	i0	80.591	9.30434782608696	237	44	26	2	466	701	373	138	Caenorhabditis elegans ATP synthase c subunit (Y82E9BR.3), mRNA	blastn	8560	182	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);;