metadata: contig_metadata: 5 rows where bioproject = "PRJNA546018", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA546018", tax_clade = "Opisthokonta" 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
14539787	14539787	PRJNA546018_S_NODE_35192_length_261_cov_6.290000_g34867_i0	PRJNA546018	35192	261	6.29	16.4169	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.024	NTclustered	gi\|687865350\|emb\|LK927747.1\|	6239	g34867	i0	100	0.21455938697318	28	0	11	0	86	113	86818	86791	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000191	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
17088876	17088876	PRJNA546018_S_NODE_5974_length_741_cov_12.114706_g5706_i0	PRJNA546018	5974	741	12.114706	89.76997146	Pratylenchus vulnus	45931	Nematoda	Nematoda	56.5	0.006	NTclustered	gi\|1557394408\|emb\|LR031564.1\|	45931	g5706	i0	94.595	0.0499325236167341	37	1	5	1	1	36	26	62	Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10	blastn	37	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Pratylenchidae	Pratylenchus	Pratylenchus vulnus
18362279	18362279	PRJNA546018_S_NODE_17235_length_395_cov_8.242515_g16910_i0	PRJNA546018	17235	395	8.242515	32.55793425	Pratylenchus goodeyi	344392	Nematoda	Nematoda	189	2.7599999999999998e-43	NTclustered	gi\|2437461978\|gb\|ON496985.1\|	344392	g16910	i0	90.845	31.8227848101266	142	11	36	2	164	304	5258	5118	Pratylenchus goodeyi isolate F1380-1 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	12570	189	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Pratylenchidae	Pratylenchus	Pratylenchus goodeyi
25345727	25345727	PRJNA546018_S_NODE_7620_length_642_cov_13.554217_g7317_i0	PRJNA546018	7620	642	13.554217	87.01807314	Metazoa	33208	Nematoda	Nematoda	676	0	NTclustered	gi\|158821895\|gb\|EU195959.1\|	479134	g7317	i0	97.015	47.9299065420561	402	10	62	2	10	410	2295	1895	Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence	blastn	30771	676	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter sp. JU359
29808357	29808357	PRJNA546018_S_NODE_23291_length_332_cov_1.546125_g22966_i0	PRJNA546018	23291	332	1.546125	5.133135	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	72.4	6.81e-13	NR	EGT33567.1	135651	g22966	i0	46.9	2.07831325301205	81	39	73.2	1	246	4	82	158	EGT33567.1 CBN-RHEB-1 protein [Caenorhabditis brenneri]	diamond	690	72.8	0.994505494505495	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri

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);;