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

5 rows where bioproject = "PRJNA1188114", 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
18171597	18171597	PRJNA1188114_P_NODE_1735_length_323_cov_2.879562_g1683_i0	PRJNA1188114	1735	323	2.879562	9.30098526	Caenorhabditis elegans	6239	Nematoda	Nematoda	165	3.73e-36	NTclustered	gi\|1972293941\|ref\|NM_001392601.1\|	6239	g1683	i0	84.211	27.2786377708978	171	25	53	2	77	246	202	33	Caenorhabditis elegans Protein transport protein Sec61 subunit gamma (sec-61.G), mRNA	blastn	8811	165	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
28935627	28935627	PRJNA1188114_P_NODE_2688_length_263_cov_0.953271_g2636_i0	PRJNA1188114	2688	263	0.953271	2.50710273	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	42.7	0.0485	NR	KAE9549803.1	2598192	g2636	i0	48.6	0.399239543726236	35	18	39.9	0	213	109	856	890	KAE9549803.1 hypothetical protein FO519_006984 [Halicephalobus sp. NKZ332]	diamond	105	42.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
29175791	29175791	PRJNA1188114_P_NODE_17809_length_162_cov_1.530973_g17757_i0	PRJNA1188114	17809	162	1.530973	2.48017626	Metazoa	33208	Nematoda	Nematoda	64.3	2.96e-10	NR	KAK5982062.1	6319	g17757	i0	68.9	7.64814814814815	45	14	83.3	0	27	161	468	512	KAK5982062.1 putative methylmalonyl-CoA mutase mitochondrial [Trichostrongylus colubriformis]	diamond	1239	64.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Trichostrongylus	Trichostrongylus colubriformis
31684059	31684059	PRJNA1188114_P_NODE_5757_length_195_cov_1.047945_g5705_i0	PRJNA1188114	5757	195	1.047945	2.04349275	Soboliphyme baturini	241478	Nematoda	Nematoda	43.9	0.0076	NR	VDP11971.1	241478	g5705	i0	40.6	0.984615384615385	64	37	96.9	1	193	5	288	351	VDP11971.1 unnamed protein product [Soboliphyme baturini]	diamond	192	43.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini
31797941	31797941	PRJNA1188114_P_NODE_3397_length_237_cov_1.627660_g3345_i0	PRJNA1188114	3397	237	1.62766	3.8575542	Rhabditida	6236	Nematoda	Nematoda	57	3.21e-7	NR	XGW06264.1	6289	g3345	i0	43.5	3.91139240506329	69	31	78.5	3	235	50	565	632	XGW06264.1 hypothetical protein V3C99_016516 [Haemonchus contortus]	diamond	927	57.4	0.993031358885017	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Haemonchus	Haemonchus contortus

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