metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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
5412726	5412726	PRJNA1160211_S_NODE_203265_length_307_cov_2.380342_g202032_i0	PRJNA1160211	203265	307	2.380342	7.30764994	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	125	4.55e-32	NR	KRY41729.1	6334	g202032	i0	72.2	5.30618892508143	79	22	77.2	0	238	2	226	304	KRY41729.1 60S ribosomal protein L27a [Trichinella spiralis]	diamond	1629	125	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
29522820	29522820	PRJNA1160211_S_NODE_212330_length_297_cov_3.781250_g211097_i0	PRJNA1160211	212330	297	3.78125	11.2303125	Trichuris	36086	Nematoda	Nematoda	65.9	4.08e-10	NR	CDW54430.1	36087	g211097	i0	61.2	2.29292929292929	49	19	49.5	0	297	151	125	173	CDW54430.1 mitochondrial uncoupling protein 4 [Trichuris trichiura]	diamond	681	65.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
29914223	29914223	PRJNA1160211_S_NODE_128591_length_407_cov_4.497006_g127359_i0	PRJNA1160211	128591	407	4.497006	18.30281442	Oesophagostomum dentatum	61180	Nematoda	Nematoda	47	0.00601	NR	KHJ89269.1	61180	g127359	i0	63.9	0.265356265356265	36	11	25.1	2	274	173	218	253	KHJ89269.1 hypothetical protein OESDEN_10911 [Oesophagostomum dentatum]	diamond	108	47	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Oesophagostomum	Oesophagostomum dentatum
32821638	32821638	PRJNA1160211_S_NODE_271060_length_247_cov_1.327586_g269827_i0	PRJNA1160211	271060	247	1.327586	3.27913742	Diploscapter pachys	2018661	Nematoda	Nematoda	45.8	0.00325	NR	PAV80121.1	2018661	g269827	i0	34.2	0.88663967611336	73	48	88.7	0	28	246	615	687	PAV80121.1 hypothetical protein WR25_24733 [Diploscapter pachys]	diamond	219	45.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys

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