metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1010662" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1010662" 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
5257782	5257782	PRJNA1010662_P_NODE_14725_length_165_cov_0.896552_g14666_i0	PRJNA1010662	14725	165	0.896552	1.4793108	Caenorhabditis remanei	31234	Nematoda	Nematoda	69.4	1.37e-7	NTclustered	gi\|2445363353\|ref\|XM_003107570.2\|	31234	g14666	i0	84.286	0.424242424242424	70	11	42	0	29	98	1066	1135	Caenorhabditis remanei uncharacterized protein (GCK72_008808), partial mRNA	blastn	70	69.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
6533061	6533061	PRJNA1010662_P_NODE_17006_length_161_cov_2.651786_g16947_i0	PRJNA1010662	17006	161	2.651786	4.26937546	Caenorhabditis elegans	6239	Nematoda	Nematoda	132	1.6700000000000002e-26	NTclustered	gi\|687866711\|emb\|LK928689.1\|	6239	g16947	i0	84.848	26.639751552795	132	18	81	2	31	161	2642	2512	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000353	blastn	4289	132	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7807539	7807539	PRJNA1010662_S_NODE_4867_length_158_cov_2.591304_g4822_i0	PRJNA1010662	4867	158	2.591304	4.09426032	Caenorhabditis elegans	6239	Nematoda	Nematoda	292	7.07e-75	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g4822	i0	100	99.7848101265823	158	0	100	0	1	158	28889	28732	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	15766	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
9082417	9082417	PRJNA1010662_P_NODE_5408_length_232_cov_2.551913_g5349_i0	PRJNA1010662	5408	232	2.551913	5.92043816	Cooperia oncophora	27828	Nematoda	Nematoda	231	2.48e-56	NTclustered	gi\|38491404\|gb\|AY372758.1\|	27828	g5349	i0	84.783	96.3275862068966	230	35	99	0	2	231	44	273	Cooperia oncophora actin mRNA, complete cds	blastn	22348	231	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Cooperia	Cooperia oncophora
10357978	10357978	PRJNA1010662_P_NODE_14369_length_166_cov_0.871795_g14310_i0	PRJNA1010662	14369	166	0.871795	1.4471797	Strongyloides ratti	34506	Nematoda	Nematoda	93.5	8.19e-15	NTclustered	gi\|1376143067\|ref\|XM_024651889.1\|	34506	g14310	i0	85.393	1.03012048192771	89	13	54	0	75	163	112	200	Strongyloides ratti V-type proton ATPase 16 kDa proteolipid subunit (SRAE_2000099100), partial mRNA	blastn	171	93.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
15457594	15457594	PRJNA1010662_S_NODE_4173_length_169_cov_1.269841_g4128_i0	PRJNA1010662	4173	169	1.269841	2.14603129	Caenorhabditis elegans	6239	Nematoda	Nematoda	261	2.15e-65	NTclustered	gi\|1734316330\|ref\|NM_170825.4\|	6239	g4128	i0	99.31	4.28994082840237	145	0	86	1	2	146	1341	1198	Caenorhabditis elegans Histone-lysine N-methyltransferase, H3 lysine-79 specific (dot-1.1), mRNA	blastn	725	261	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
16303988	16303988	PRJNA1010662_S_NODE_3213_length_189_cov_1.458904_g3168_i0	PRJNA1010662	3213	189	1.458904	2.75732856	Hysterothylacium	59255	Nematoda	Nematoda	350	5.14e-92	NTclustered	gi\|1072826267\|gb\|KX815306.1\|	59258	g3168	i0	100	99.7724867724868	189	0	100	0	1	189	247	59	Hysterothylacium reliquens isolate Q07 28S ribosomal RNA gene, partial sequence	blastn	18857	350	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Raphidascarididae	Hysterothylacium	Hysterothylacium reliquens
16303997	16303997	PRJNA1010662_S_NODE_4053_length_171_cov_1.187500_g4008_i0	PRJNA1010662	4053	171	1.1875	2.030625	Caenorhabditis	6237	Nematoda	Nematoda	316	4.6e-82	NTclustered	gi\|2460759835\|gb\|OQ645709.1\|	6239	g4008	i0	100	101	171	0	100	0	1	171	223	53	Caenorhabditis elegans strain H60A small subunit ribosomal RNA gene, partial sequence	blastn	17271	316	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
18006719	18006719	PRJNA1010662_P_NODE_9535_length_188_cov_1.115108_g9476_i0	PRJNA1010662	9535	188	1.115108	2.09640304	Caenorhabditis elegans	6239	Nematoda	Nematoda	115	2.03e-21	NTclustered	gi\|1972264789\|ref\|NM_066171.10\|	6239	g9476	i0	83.2	9.24468085106383	125	21	66	0	11	135	216	92	Caenorhabditis elegans Small ribosomal subunit protein uS11 (rps-14), mRNA	blastn	1738	115	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
18006752	18006752	PRJNA1010662_S_NODE_4275_length_167_cov_2.129032_g4230_i0	PRJNA1010662	4275	167	2.129032	3.55548344	Caenorhabditis elegans	6239	Nematoda	Nematoda	309	7.53e-80	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g4230	i0	100	75.4730538922156	167	0	100	0	1	167	28593	28759	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	12604	309	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
23107136	23107136	PRJNA1010662_P_NODE_10139_length_183_cov_2.305970_g10080_i0	PRJNA1010662	10139	183	2.30597	4.2199251	Caenorhabditis remanei	31234	Nematoda	Nematoda	87.9	4.27e-13	NTclustered	gi\|2445349706\|ref\|XM_003097640.2\|	31234	g10080	i0	75.706	1.91803278688525	177	42	97	1	3	179	547	722	Caenorhabditis remanei uncharacterized protein (GCK72_001558), partial mRNA	blastn	351	87.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
24380944	24380944	PRJNA1010662_P_NODE_5160_length_236_cov_3.844920_g5101_i0	PRJNA1010662	5160	236	3.84492	9.0740112	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.006	NTclustered	gi\|1831517864\|ref\|NM_001136422.4\|	6239	g5101	i0	100	0.491525423728814	29	0	12	0	24	52	8	36	Caenorhabditis elegans FIP (Fungus-Induced Protein) Related (fipr-2), partial mRNA	blastn	116	54.7	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);;