metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA704949" 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
693226	693226	PRJNA704949_P_NODE_1913681_length_170_cov_1.107438_g1898342_i0	PRJNA704949	1913681	170	1.107438	1.8826446	Rotylenchulus reniformis	239373	Nematoda	Nematoda	75	3.03e-9	NTclustered	gi\|264664697\|gb\|FJ905984.1\|	239373	g1898342	i0	97.674	0.252941176470588	43	1	25	0	128	170	523	481	Rotylenchulus reniformis clone 190 microsatellite sequence	blastn	43	75	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Hoplolaimidae	Rotylenchulus	Rotylenchulus reniformis
1967663	1967663	PRJNA704949_P_NODE_1699242_length_185_cov_1.323529_g1683903_i0	PRJNA704949	1699242	185	1.323529	2.44852865	Sudhausia aristotokia	1357959	Nematoda	Nematoda	89.8	1.2e-13	NTclustered	gi\|675118807\|gb\|KJ877278.1\|	1357959	g1683903	i0	84.375	48.7945945945946	96	10	50	5	1	92	1515	1421	Sudhausia aristotokia strain RS9011 28S ribosomal RNA gene, partial sequence	blastn	9027	89.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Sudhausia	Sudhausia aristotokia
4515949	4515949	PRJNA704949_P_NODE_1230904_length_228_cov_2.301676_g1215567_i0	PRJNA704949	1230904	228	2.301676	5.24782128	Strongyloides ratti	34506	Nematoda	Nematoda	193	1.15e-44	NTclustered	gi\|1376147859\|ref\|XM_024654603.1\|	34506	g1215567	i0	83.412	107.035087719298	211	31	92	4	3	211	1802	1594	Strongyloides ratti Polyubiquitin-C (SRAE_2000341300), partial mRNA	blastn	24404	193	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
5791648	5791648	PRJNA704949_P_NODE_1272345_length_224_cov_1.080000_g1257008_i0	PRJNA704949	1272345	224	1.08	2.4192	Rotylenchulus reniformis	239373	Nematoda	Nematoda	219	1.85e-52	NTclustered	gi\|264664993\|gb\|FJ906280.1\|	239373	g1257008	i0	84.783	1.02678571428571	230	22	100	11	1	224	36	258	Rotylenchulus reniformis clone 109 microsatellite sequence	blastn	230	219	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Hoplolaimidae	Rotylenchulus	Rotylenchulus reniformis
8347249	8347249	PRJNA704949_P_NODE_1999107_length_167_cov_0.881356_g1983768_i0	PRJNA704949	1999107	167	0.881356	1.47186452	Strongyloides ratti	34506	Nematoda	Nematoda	52.8	0.014	NTclustered	gi\|1376135035\|ref\|XM_024647515.1\|	34506	g1983768	i0	100	0.167664670658683	28	0	17	0	59	86	915	942	Strongyloides ratti Hypothetical protein (SRAE_1000065600), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
15993176	15993176	PRJNA704949_P_NODE_1573793_length_195_cov_0.917808_g1558454_i0	PRJNA704949	1573793	195	0.917808	1.7897256	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.017	NTclustered	gi\|413006427\|emb\|Z99281.2\|	6239	g1558454	i0	100	0.287179487179487	28	0	14	0	161	188	220576	220549	Caenorhabditis elegans YAC Y57G11C, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
23655384	23655384	PRJNA704949_P_NODE_966959_length_266_cov_0.958525_g951624_i0	PRJNA704949	966959	266	0.958525	2.5496765	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.024	NTclustered	gi\|687865570\|emb\|LK927557.1\|	6239	g951624	i0	100	0.210526315789474	28	0	11	0	155	182	260521	260548	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000025	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
25414645	25414645	PRJNA704949_P_NODE_2013720_length_166_cov_3.401709_g1998381_i0	PRJNA704949	2013720	166	3.401709	5.64683694	Opisthokonta	33154	Nematoda	Nematoda	56.5	0.001	NTclustered	gi\|373218635\|emb\|FO080224.1\|	6239	g1998381	i0	100	22.0120481927711	30	0	36	0	12	41	13987	14016	Caenorhabditis elegans Cosmid F53A3, complete sequence	blastn	3654	56.5	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);;