metadata: contig_metadata: 5 rows where bioproject = "PRJNA716463" and tax

5 rows where bioproject = "PRJNA716463" 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
28631286	28631286	PRJNA716463_P_NODE_66767_length_279_cov_1.087379_g66350_i0	PRJNA716463	66767	279	1.087379	3.03378741	Trichinella spiralis	6334	Nematoda	Nematoda	42.4	0.0229	NR	KAL1244637.1	6334	g66350	i0	37	0.494623655913978	46	29	49.5	0	20	157	55	100	KAL1244637.1 hypothetical protein TSPI_06332 [Trichinella spiralis]	diamond	138	42.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
29136514	29136514	PRJNA716463_P_NODE_115849_length_235_cov_3.598765_g115431_i0	PRJNA716463	115849	235	3.598765	8.45709775	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	41.2	0.0256	NR	GMT17793.1	1538716	g115431	i0	52.8	0.459574468085106	36	16	46	1	69	176	31	65	GMT17793.1 hypothetical protein PFISCL1PPCAC_9090, partial [Pristionchus fissidentatus]	diamond	108	41.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus
29514935	29514935	PRJNA716463_P_NODE_31910_length_305_cov_2.767241_g31493_i0	PRJNA716463	31910	305	2.767241	8.44008505	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	41.6	0.0381	NR	GMT17793.1	1538716	g31493	i0	52.8	0.354098360655738	36	16	35.4	1	179	72	31	65	GMT17793.1 hypothetical protein PFISCL1PPCAC_9090, partial [Pristionchus fissidentatus]	diamond	108	41.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus
30368391	30368391	PRJNA716463_P_NODE_102172_length_249_cov_3.181818_g101755_i0	PRJNA716463	102172	249	3.181818	7.92272682	Meloidogyne enterolobii	390850	Nematoda	Nematoda	40.8	0.0239	NR	CAK5075337.1	390850	g101755	i0	33.3	0.397590361445783	33	22	39.8	0	241	143	26	58	CAK5075337.1 unnamed protein product [Meloidogyne enterolobii]	diamond	99	40.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
32581524	32581524	PRJNA716463_P_NODE_85219_length_264_cov_2.842932_g84802_i0	PRJNA716463	85219	264	2.842932	7.50534048	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	42	0.0184	NR	GMT17793.1	1538716	g84802	i0	54.8	0.352272727272727	31	14	35.2	0	213	121	33	63	GMT17793.1 hypothetical protein PFISCL1PPCAC_9090, partial [Pristionchus fissidentatus]	diamond	93	42	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus

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