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

4 rows where analysis = "diamond", bioproject = "PRJNA994052" 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
9904915	9904915	PRJNA994052_P_NODE_64848_length_219_cov_24.431507_g63592_i0	PRJNA994052	64848	219	24.431507	53.50500033	Soboliphyme baturini	241478	Nematoda	Nematoda	88.2	1e-19	NR	VDP14147.1	241478	g63592	i0	66.7	0.863013698630137	63	21	86.3	0	197	9	126	188	VDP14147.1 unnamed protein product [Soboliphyme baturini]	diamond	189	88.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini
26931582	26931582	PRJNA994052_P_NODE_55682_length_232_cov_50.761006_g54427_i0	PRJNA994052	55682	232	50.761006	117.76553392	Caenorhabditis remanei	31234	Nematoda	Nematoda	68.9	1.79e-11	NR	XP_053583521.1	31234	g54427	i0	59.6	2.41810344827586	47	19	60.8	0	231	91	354	400	XP_053583521.1 hypothetical protein GCK72_022008 [Caenorhabditis remanei]	diamond	561	68.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
27500633	27500633	PRJNA994052_P_NODE_82383_length_198_cov_20.440000_g81126_i0	PRJNA994052	82383	198	20.44	40.4712	Dictyocaulus viviparus	29172	Nematoda	Nematoda	49.3	3.09e-5	NR	KJH39900.1	29172	g81126	i0	42.9	3.18181818181818	42	24	63.6	0	127	2	9	50	KJH39900.1 hypothetical protein DICVIV_14198 [Dictyocaulus viviparus]	diamond	630	49.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Dictyocaulus	Dictyocaulus viviparus
32366205	32366205	PRJNA994052_P_NODE_30339_length_281_cov_13.360577_g29097_i0	PRJNA994052	30339	281	13.360577	37.54322137	Strongyloides ratti	34506	Nematoda	Nematoda	70.5	1.06e-11	NR	XP_024503532.1	34506	g29097	i0	42.9	4.44128113879004	84	46	88.6	2	249	1	1009	1091	XP_024503532.1 Splicing factor 3B subunit 3 [Strongyloides ratti]	diamond	1248	70.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti

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