metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1093008" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1093008" 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
27983529	27983529	PRJNA1093008_S_NODE_49725_length_294_cov_2.837104_g49398_i0	PRJNA1093008	49725	294	2.837104	8.34108576	Anisakis simplex	6269	Nematoda	Nematoda	44.3	0.0207	NR	VDK51737.1	6269	g49398	i0	40	0.561224489795918	55	31	54.1	1	67	225	1063	1117	VDK51737.1 unnamed protein product [Anisakis simplex]	diamond	165	44.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
28132937	28132937	PRJNA1093008_S_NODE_17685_length_385_cov_9.711538_g17358_i0	PRJNA1093008	17685	385	9.711538	37.3894213	Metazoa	33208	Nematoda	Nematoda	158	2.83e-47	NR	VDK43645.1	6269	g17358	i0	100	167.937662337662	68	0	53	0	384	181	50	117	VDK43645.1 unnamed protein product [Anisakis simplex]	diamond	64656	158	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
28322223	28322223	PRJNA1093008_S_NODE_97346_length_237_cov_3.317073_g97019_i0	PRJNA1093008	97346	237	3.317073	7.86146301	Metazoa	33208	Nematoda	Nematoda	82	4.89e-16	NR	CAD5231976.1	6326	g97019	i0	61.4	4.86075949367089	57	22	72.2	0	237	67	425	481	CAD5231976.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	1152	82.4	0.995145631067961	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
28678375	28678375	PRJNA1093008_S_NODE_91067_length_244_cov_1.654971_g90740_i0	PRJNA1093008	91067	244	1.654971	4.03812924	Aphelenchoides besseyi	269767	Nematoda	Nematoda	45.1	0.00547	NR	KAI6186722.1	269767	g90740	i0	33.3	0.774590163934426	63	42	77.5	0	213	25	84	146	KAI6186722.1 hypothetical protein M3Y98_00163400 [Aphelenchoides besseyi]	diamond	189	45.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
31521445	31521445	PRJNA1093008_S_NODE_71676_length_262_cov_2.740741_g71349_i0	PRJNA1093008	71676	262	2.740741	7.18074142	Cylicocyclus nassatus	53992	Nematoda	Nematoda	85.1	5.88e-17	NR	CAJ0595929.1	53992	g71349	i0	44.3	0.904580152671756	79	44	90.5	0	2	238	355	433	CAJ0595929.1 unnamed protein product [Cylicocyclus nassatus]	diamond	237	85.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Cylicocyclus	Cylicocyclus nassatus

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