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

5 rows where analysis = "diamond", bioproject = "PRJNA429937" 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
27233777	27233777	PRJNA429937_P_NODE_39803_length_571_cov_6.658672_g11761_i1	PRJNA429937	39803	571	6.658672	38.02101712	Wuchereria bancrofti	6293	Nematoda	Nematoda	59.7	1.01e-7	NR	EJW70189.1	6293	g11761	i1	47.1	0.367775831873905	70	36	36.3	1	363	569	1	70	EJW70189.1 hypothetical protein WUBG_18903 [Wuchereria bancrofti]	diamond	210	59.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Wuchereria	Wuchereria bancrofti
27629502	27629502	PRJNA429937_P_NODE_65464_length_422_cov_2.152672_g44682_i0	PRJNA429937	65464	422	2.152672	9.08427584	Opisthokonta	33154	Nematoda	Nematoda	45.4	0.0286	NR	KHJ47703.1	68888	g44682	i0	64	2.239336492891	25	9	17.8	0	73	147	246	270	KHJ47703.1 zinc finger, C3HC4 type, partial [Trichuris suis]	diamond	945	45.8	0.991266375545852	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
28717994	28717994	PRJNA429937_P_NODE_49647_length_503_cov_3.364979_g32426_i0	PRJNA429937	49647	503	3.364979	16.92584437	Oesophagostomum dentatum	61180	Nematoda	Nematoda	53.9	5.94e-5	NR	KHJ78363.1	61180	g32426	i0	45.5	1.31809145129225	55	30	32.8	0	367	203	312	366	KHJ78363.1 reverse transcriptase, partial [Oesophagostomum dentatum]	diamond	663	53.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Oesophagostomum	Oesophagostomum dentatum
29917901	29917901	PRJNA429937_P_NODE_19911_length_824_cov_5.413836_g11761_i0	PRJNA429937	19911	824	5.413836	44.61000864	Wuchereria bancrofti	6293	Nematoda	Nematoda	112	7.18e-27	NR	EJW70189.1	6293	g11761	i0	48.2	0.49878640776699	137	67	49.2	4	478	74	1	135	EJW70189.1 hypothetical protein WUBG_18903 [Wuchereria bancrofti]	diamond	411	112	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Wuchereria	Wuchereria bancrofti
32098828	32098828	PRJNA429937_P_NODE_52518_length_486_cov_5.070022_g11761_i2	PRJNA429937	52518	486	5.070022	24.64030692	Wuchereria bancrofti	6293	Nematoda	Nematoda	80.1	8.15e-16	NR	EJW70189.1	6293	g11761	i2	45.5	0.623456790123457	101	52	61.1	3	318	22	1	100	EJW70189.1 hypothetical protein WUBG_18903 [Wuchereria bancrofti]	diamond	303	80.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Wuchereria	Wuchereria bancrofti

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