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

14 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
176762	176762	PRJNA1059246_P_NODE_1501_length_1954_cov_2.686869_g1345_i0	PRJNA1059246	1501	1954	2.686869	52.50142026	Caenorhabditis elegans	6239	Nematoda	Nematoda	56.5	0.016	NTclustered	gi\|1495011\|emb\|Z78413.1\|	6239	g1345	i0	89.362	0.0481064483111566	47	2	2	3	8	53	12152	12108	Caenorhabditis elegans Cosmid T01C3, complete sequence	blastn	94	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
176851	176851	PRJNA1059246_P_NODE_21001_length_494_cov_7.315914_g20382_i0	PRJNA1059246	21001	494	7.315914	36.14061516	Caenorhabditis briggsae	6238	Nematoda	Nematoda	193	2.72e-44	NTclustered	gi\|268558427\|ref\|XM_002637158.1\|	6238	g20382	i0	87.805	20.6032388663968	164	20	33	0	271	434	200	37	Caenorhabditis briggsae Protein CBR-EMO-1 (Cbr-emo-1), partial mRNA	blastn	10178	193	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
2727950	2727950	PRJNA1059246_P_NODE_69483_length_244_cov_0.900585_g68857_i0	PRJNA1059246	69483	244	0.900585	2.1974274	Strongyloides ratti	34506	Nematoda	Nematoda	169	2.09e-37	NTclustered	gi\|1376147725\|ref\|XM_024654528.1\|	34506	g68857	i0	82.888	52.0081967213115	187	32	77	0	57	243	770	956	Strongyloides ratti ATP synthase subunit alpha, mitochondrial (SRAE_2000334600), partial mRNA	blastn	12690	169	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
7829474	7829474	PRJNA1059246_P_NODE_23647_length_462_cov_1.367609_g23023_i0	PRJNA1059246	23647	462	1.367609	6.31835358	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.045	NTclustered	gi\|2653171\|emb\|Z82256.1\|	6239	g23023	i0	96.774	0.134199134199134	31	1	7	0	346	376	28228	28198	Caenorhabditis elegans Cosmid B0513, complete sequence	blastn	62	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7829880	7829880	PRJNA1059246_P_NODE_58047_length_263_cov_1.721053_g57421_i0	PRJNA1059246	58047	263	1.721053	4.52636939	Strongyloides ratti	34506	Nematoda	Nematoda	182	2.929999999999999e-41	NTclustered	gi\|1376146787\|ref\|XM_024653987.1\|	34506	g57421	i0	80.08	26.9961977186312	251	44	94	5	1	248	1894	2141	Strongyloides ratti C-1-tetrahydrofolate synthase, cytoplasmic (SRAE_2000286700), partial mRNA	blastn	7100	182	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
12930514	12930514	PRJNA1059246_P_NODE_18211_length_538_cov_11.421505_g17596_i0	PRJNA1059246	18211	538	11.421505	61.4476969	Pristionchus sp. 10 RS5133	452805	Nematoda	Nematoda	274	1.0399999999999999e-68	NTclustered	gi\|150984485\|gb\|EF634885.1\|	452805	g17596	i0	79.442	28.1579925650558	394	75	73	6	51	443	415	27	Pristionchus sp. 10 RS5133 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	15149	274	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 10 RS5133
14205415	14205415	PRJNA1059246_P_NODE_13632_length_638_cov_3.304425_g13044_i0	PRJNA1059246	13632	638	3.304425	21.0822315	Caenorhabditis elegans	6239	Nematoda	Nematoda	259	3.48e-64	NTclustered	gi\|1734332162\|ref\|NM_070257.4\|	6239	g13044	i0	80.403	44.2366771159875	347	62	54	5	153	496	92	435	Caenorhabditis elegans NIF system FeS cluster assembly NifU N-terminal domain-containing protein (iscu-1), mRNA	blastn	28223	259	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
14206047	14206047	PRJNA1059246_P_NODE_65872_length_247_cov_0.885057_g65246_i0	PRJNA1059246	65872	247	0.885057	2.18609079	Caenorhabditis elegans	6239	Nematoda	Nematoda	446	8.759999999999998e-121	NTclustered	gi\|687866365\|emb\|LK928804.1\|	6239	g65246	i0	99.19	7.91902834008097	247	2	100	0	1	247	8910	9156	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000418	blastn	1956	446	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15479679	15479679	PRJNA1059246_P_NODE_23673_length_461_cov_20.636598_g23049_i0	PRJNA1059246	23673	461	20.636598	95.13471678	Caenorhabditis remanei	31234	Nematoda	Nematoda	176	2.55e-39	NTclustered	gi\|2445378119\|ref\|XM_003100380.2\|	31234	g23049	i0	85.294	24.4208242950108	170	25	37	0	207	376	194	25	Caenorhabditis remanei uncharacterized protein (GCK72_016568), partial mRNA	blastn	11258	176	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
19302587	19302587	PRJNA1059246_P_NODE_22856_length_471_cov_1.391960_g22234_i0	PRJNA1059246	22856	471	1.39196	6.5561316	Necator americanus	51031	Nematoda	Nematoda	62.1	7.61e-5	NTclustered	gi\|2707607239\|ref\|XM_064207854.1\|	51031	g22234	i0	91.111	0.819532908704883	45	4	10	0	142	186	3047	3091	Necator americanus uncharacterized protein (RB195_021228), partial mRNA	blastn	386	62.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
21854110	21854110	PRJNA1059246_P_NODE_54218_length_276_cov_1.517241_g53592_i0	PRJNA1059246	54218	276	1.517241	4.18758516	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.007	NTclustered	gi\|351058242\|emb\|FO080670.1\|	6239	g53592	i0	100	0.416666666666667	29	0	11	0	165	193	5162	5134	Caenorhabditis elegans Cosmid T27E4, complete sequence	blastn	115	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
23129614	23129614	PRJNA1059246_P_NODE_58039_length_263_cov_1.868421_g57413_i0	PRJNA1059246	58039	263	1.868421	4.91394723	Loa loa	7209	Nematoda	Nematoda	56.5	0.002	NTclustered	gi\|312095098\|ref\|XM_003148200.1\|	7209	g57413	i0	100	0.547528517110266	30	0	11	0	135	164	183	154	Loa loa hypothetical protein partial mRNA	blastn	144	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Loa	Loa loa
24403340	24403340	PRJNA1059246_P_NODE_64060_length_249_cov_0.875000_g63434_i0	PRJNA1059246	64060	249	0.875	2.17875	Caenorhabditis elegans	6239	Nematoda	Nematoda	460	3.16e-125	NTclustered	gi\|1734330469\|ref\|NM_069182.4\|	6239	g63434	i0	100	4.47791164658635	249	0	100	0	1	249	8	256	Caenorhabditis elegans Small EDRK-rich factor-like N-terminal domain-containing protein (znf-706), mRNA	blastn	1115	460	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
25237660	25237660	PRJNA1059246_P_NODE_16240_length_577_cov_2.081349_g15630_i0	PRJNA1059246	16240	577	2.081349	12.00938373	Opisthokonta	33154	Nematoda	Nematoda	531	5.999999999999999e-146	NTclustered	gi\|687865697\|emb\|LK927572.1\|	6239	g15630	i0	83.598	222.837088388215	567	91	98	2	12	577	121120	120555	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000039	blastn	128577	531	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);;