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

4 rows where analysis = "diamond", bioproject = "PRJNA404067" 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
29285799	29285799	PRJNA404067_P_NODE_17709_length_247_cov_2.596774_g17322_i0	PRJNA404067	17709	247	2.596774	6.41403178	Strongylus vulgaris	40348	Nematoda	Nematoda	49.3	1.95e-4	NR	VDM65508.1	40348	g17322	i0	58.3	0.728744939271255	60	22	72.9	1	29	208	573	629	VDM65508.1 unnamed protein product, partial [Strongylus vulgaris]	diamond	180	49.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Strongylus	Strongylus vulgaris
30012408	30012408	PRJNA404067_P_NODE_43771_length_175_cov_7.684211_g43384_i0	PRJNA404067	43771	175	7.684211	13.44736925	Caenorhabditis auriculariae	2777116	Nematoda	Nematoda	50.4	2.87e-5	NR	CAD6189548.1	2777116	g43384	i0	46.2	0.891428571428571	52	27	89.1	1	168	13	64	114	CAD6189548.1 unnamed protein product [Caenorhabditis auriculariae]	diamond	156	50.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis auriculariae
30170083	30170083	PRJNA404067_P_NODE_41272_length_191_cov_3.892308_g40885_i0	PRJNA404067	41272	191	3.892308	7.43430828	Teladorsagia circumcincta	45464	Nematoda	Nematoda	63.5	4.15e-11	NR	PIO76633.1	45464	g40885	i0	72.2	5.27748691099476	36	10	56.5	0	189	82	32	67	PIO76633.1 ribosomal protein S14p/S29e [Teladorsagia circumcincta]	diamond	1008	63.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Teladorsagia	Teladorsagia circumcincta
30802061	30802061	PRJNA404067_P_NODE_13414_length_285_cov_4.401786_g13027_i0	PRJNA404067	13414	285	4.401786	12.5450901	Auanema sp. JU1783	2878363	Nematoda	Nematoda	62.4	4.79e-9	NR	CAI4221212.1	2878363	g13027	i0	75.8	0.347368421052632	33	8	34.7	0	283	185	243	275	CAI4221212.1 unnamed protein product [Auanema sp. JU1783]	diamond	99	62.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Auanema	Auanema sp. JU1783

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