metadata: contig_metadata: 6 rows where bioproject = "PRJNA1092581", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA1092581", tax_kingdom = "Metazoa" 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
26687684	26687684	PRJNA1092581_P_NODE_49221_length_384_cov_2.951768_g48688_i0	PRJNA1092581	49221	384	2.951768	11.33478912	Meloidogyne graminicola	189291	Nematoda	Nematoda	97.4	1.4200000000000002e-21	NR	AVZ46778.1	189291	g48688	i0	50.5	0.8203125	105	52	82	0	61	375	117	221	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	315	97.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
28732791	28732791	PRJNA1092581_P_NODE_126147_length_203_cov_6.723077_g125614_i0	PRJNA1092581	126147	203	6.723077	13.64784631	Caenorhabditis	6237	Nematoda	Nematoda	64.7	4.02e-11	NR	XP_003111229.1	31234	g125614	i0	64.6	3.47290640394089	48	17	70.9	0	4	147	99	146	XP_003111229.1 hypothetical protein GCK72_000994 [Caenorhabditis remanei]	diamond	705	64.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
29846459	29846459	PRJNA1092581_P_NODE_30851_length_498_cov_4.778824_g30319_i0	PRJNA1092581	30851	498	4.778824	23.79854352	Meloidogyne graminicola	189291	Nematoda	Nematoda	63.9	1.24e-8	NR	AVZ46778.1	189291	g30319	i0	39.4	0.596385542168675	99	60	59.6	0	301	5	117	215	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	297	63.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
31299868	31299868	PRJNA1092581_P_NODE_81015_length_287_cov_2.158879_g80482_i0	PRJNA1092581	81015	287	2.158879	6.19598273	Litomosoides sigmodontis	42156	Nematoda	Nematoda	40	0.0469	NR	VDM93791.1	42156	g80482	i0	55.9	0.355400696864112	34	15	35.5	0	147	46	3	36	VDM93791.1 unnamed protein product, partial [Litomosoides sigmodontis]	diamond	102	40	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Litomosoides	Litomosoides sigmodontis
31512855	31512855	PRJNA1092581_P_NODE_110296_length_239_cov_43.668675_g109763_i0	PRJNA1092581	110296	239	43.668675	104.36813325	Rhabditida	6236	Nematoda	Nematoda	62.4	4.24e-9	NR	KAK6059781.1	27828	g109763	i0	53.4	4.39330543933054	58	26	71.5	1	216	46	1033	1090	KAK6059781.1 isoleucine--tRNA ligase [Cooperia oncophora]	diamond	1050	62.8	0.993630573248408	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Cooperia	Cooperia oncophora
31932407	31932407	PRJNA1092581_P_NODE_110457_length_239_cov_5.246988_g109924_i0	PRJNA1092581	110457	239	5.246988	12.54030132	Pristionchus pacificus	54126	Nematoda	Nematoda	43.9	0.0143	NR	KAF8362444.1	54126	g109924	i0	68	0.313807531380753	25	8	31.4	0	239	165	2036	2060	KAF8362444.1 hypothetical protein PRIPAC_89367 [Pristionchus pacificus]	diamond	75	43.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus

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