metadata: contig_metadata: 4 rows where bioproject = "PRJNA474911", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA474911", 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
26823239	26823239	PRJNA474911_P_NODE_6481_length_218_cov_2.031847_g6354_i0	PRJNA474911	6481	218	2.031847	4.42942646	Meloidogyne enterolobii	390850	Nematoda	Nematoda	49.7	9.55e-5	NR	CAD2167694.1	390850	g6354	i0	45.8	1.21100917431193	48	26	66.1	0	169	26	16	63	CAD2167694.1 unnamed protein product [Meloidogyne enterolobii]	diamond	264	49.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
28750048	28750048	PRJNA474911_P_NODE_7327_length_207_cov_0.876712_g7200_i0	PRJNA474911	7327	207	0.876712	1.81479384	Mesorhabditis belari	2138241	Nematoda	Nematoda	43.9	0.00275	NR	CAJ0962865.1	2138241	g7200	i0	42.1	1.65217391304348	57	31	81.2	2	171	4	21	76	CAJ0962865.1 unnamed protein product, partial [Mesorhabditis belari]	diamond	342	43.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Mesorhabditis	Mesorhabditis belari
28797484	28797484	PRJNA474911_P_NODE_7707_length_205_cov_0.888889_g7580_i0	PRJNA474911	7707	205	0.888889	1.82222245	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	73.2	2.47e-13	NR	KAL3117111.1	157864	g7580	i0	48.5	6.80487804878049	66	34	96.6	0	205	8	148	213	KAL3117111.1 hypothetical protein niasHT_007514 [Heterodera trifolii]	diamond	1395	73.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii
32479317	32479317	PRJNA474911_P_NODE_4999_length_256_cov_1.641026_g4872_i0	PRJNA474911	4999	256	1.641026	4.20102656	Ancylostoma ceylanicum	53326	Nematoda	Nematoda	50.8	6.3e-5	NR	EYC17923.1	53326	g4872	i0	42.7	1.79296875	82	44	94.9	3	244	2	302	381	EYC17923.1 hypothetical protein Y032_0029g1960 [Ancylostoma ceylanicum]	diamond	459	50.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma ceylanicum

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