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

5 rows where analysis = "diamond", bioproject = "PRJNA1126661" 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
1557006	1557006	PRJNA1126661_P_NODE_37462_length_301_cov_4.478070_g36933_i0	PRJNA1126661	37462	301	4.47807	13.4789907	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82.4	8.16e-16	NR	KAI6171096.1	293665	g36933	i0	72	1.99335548172757	50	14	49.8	0	152	301	388	437	KAI6171096.1 Asparaginyl-tRNA synthetase [Aphelenchoides bicaudatus]	diamond	600	83.2	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides bicaudatus
27986308	27986308	PRJNA1126661_P_NODE_72865_length_246_cov_3.346821_g72335_i0	PRJNA1126661	72865	246	3.346821	8.23317966	Ditylenchus destructor	166010	Nematoda	Nematoda	51.2	1.96e-5	NR	KAI1696154.1	166010	g72335	i0	43.8	0.585365853658537	48	27	58.5	0	77	220	5	52	KAI1696154.1 dnaJ domain-containing protein [Ditylenchus destructor]	diamond	144	51.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor
28775577	28775577	PRJNA1126661_P_NODE_73607_length_244_cov_4.023392_g73077_i0	PRJNA1126661	73607	244	4.023392	9.81707648	Strongyloides ratti	34506	Nematoda	Nematoda	46.2	0.00236	NR	XP_024507406.1	34506	g73077	i0	32.4	3.63934426229508	71	46	84.8	2	34	240	1534	1604	XP_024507406.1 Narrow abdomen [Strongyloides ratti]	diamond	888	46.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
29249125	29249125	PRJNA1126661_P_NODE_27329_length_326_cov_2.916996_g26800_i0	PRJNA1126661	27329	326	2.916996	9.50940696	Caenorhabditis bovis	2654633	Nematoda	Nematoda	48.9	6.88e-4	NR	CAB3400511.1	2654633	g26800	i0	85.2	0.248466257668712	27	4	24.8	0	256	176	689	715	CAB3400511.1 unnamed protein product [Caenorhabditis bovis]	diamond	81	48.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis bovis
32630835	32630835	PRJNA1126661_P_NODE_67380_length_260_cov_2.807487_g66850_i0	PRJNA1126661	67380	260	2.807487	7.2994662	Soboliphyme baturini	241478	Nematoda	Nematoda	50.8	6.17e-5	NR	VDP33828.1	241478	g66850	i0	38.2	0.784615384615385	68	39	78.5	1	256	53	161	225	VDP33828.1 unnamed protein product [Soboliphyme baturini]	diamond	204	50.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini

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