metadata: contig_metadata: 4 rows where bioproject = "PRJNA1061474" and tax

4 rows where bioproject = "PRJNA1061474" 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
28077668	28077668	PRJNA1061474_P_NODE_11865_length_607_cov_56.234082_g11628_i0	PRJNA1061474	11865	607	56.234082	341.34087774	Trichinella sp. T6	92179	Nematoda	Nematoda	105	6.37e-26	NR	KRX29663.1	92179	g11628	i0	69	0.415156507413509	84	5	41.5	1	401	150	1	63	KRX29663.1 hypothetical protein T06_14473, partial [Trichinella sp. T6]	diamond	252	105	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella sp. T6
28425241	28425241	PRJNA1061474_P_NODE_51746_length_246_cov_0.890173_g51500_i0	PRJNA1061474	51746	246	0.890173	2.18982558	Aphelenchoides besseyi	269767	Nematoda	Nematoda	103	2.0499999999999999e-23	NR	KAI6178336.1	269767	g51500	i0	93.8	0.975609756097561	80	5	97.6	0	5	244	328	407	KAI6178336.1 Junctophilin-3 [Aphelenchoides besseyi]	diamond	240	103	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
30698890	30698890	PRJNA1061474_P_NODE_14274_length_542_cov_1.511727_g14030_i0	PRJNA1061474	14274	542	1.511727	8.19356034	Pristionchus entomophagus	358040	Nematoda	Nematoda	64.7	1.11e-8	NR	GMT02254.1	358040	g14030	i0	32.5	2.52952029520295	151	102	83.6	0	455	3	17	167	GMT02254.1 hypothetical protein PENTCL1PPCAC_24428, partial [Pristionchus entomophagus]	diamond	1371	64.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus entomophagus
32153559	32153559	PRJNA1061474_P_NODE_57038_length_241_cov_1.797619_g56792_i0	PRJNA1061474	57038	241	1.797619	4.33226179	Steinernema carpocapsae	34508	Nematoda	Nematoda	71.2	3.33e-12	NR	TMS37759.1	34508	g56792	i0	70.2	2.22821576763485	47	14	58.5	0	141	1	303	349	TMS37759.1 hypothetical protein L596_004626 [Steinernema carpocapsae]	diamond	537	71.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae

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