metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA564013" 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
17127912	17127912	PRJNA564013_P_NODE_274594_length_242_cov_8.232044_g271742_i0	PRJNA564013	274594	242	8.232044	19.92154648	Trichinella zimbabwensis	268475	Nematoda	Nematoda	57	1.26e-8	NR	KRY80671.1	268475	g271742	i0	88.5	0.322314049586777	26	3	32.2	0	216	139	47	72	KRY80671.1 hypothetical protein T11_3193, partial [Trichinella zimbabwensis]	diamond	78	57	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella zimbabwensis
26699199	26699199	PRJNA564013_P_NODE_20041_length_821_cov_34.753947_g17783_i0	PRJNA564013	20041	821	34.753947	285.32990487	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	287	1.45e-94	NR	KAE9554603.1	2598192	g17783	i0	73	0.811205846528624	222	52	80.4	5	70	729	1	216	KAE9554603.1 hypothetical protein FO519_002163 [Halicephalobus sp. NKZ332]	diamond	666	287	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
27788114	27788114	PRJNA564013_P_NODE_367184_length_183_cov_6.483607_g364332_i0	PRJNA564013	367184	183	6.483607	11.86500081	Metazoa	33208	Nematoda	Nematoda	41.2	0.0153	NR	NP_498705.1	6239	g364332	i0	62.5	11.8524590163934	32	12	52.5	0	24	119	24	55	NP_498705.1 Ubiquitin-fold modifier 1 [Caenorhabditis elegans]	diamond	2169	41.6	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
29257959	29257959	PRJNA564013_P_NODE_264229_length_250_cov_2.682540_g261377_i0	PRJNA564013	264229	250	2.68254	6.70635	Brugia pahangi	6280	Nematoda	Nematoda	60.8	1.68e-8	NR	VDN91595.1	6280	g261377	i0	70.7	2.16	41	12	49.2	0	182	60	1049	1089	VDN91595.1 unnamed protein product [Brugia pahangi]	diamond	540	60.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia pahangi
30205337	30205337	PRJNA564013_P_NODE_136232_length_365_cov_1.717105_g133384_i0	PRJNA564013	136232	365	1.717105	6.26743325	Caenorhabditis remanei	31234	Nematoda	Nematoda	76.6	4.58e-14	NR	EFP12960.1	31234	g133384	i0	39.8	3.55068493150685	108	61	88.8	1	331	8	143	246	EFP12960.1 hypothetical protein CRE_12406 [Caenorhabditis remanei]	diamond	1296	76.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
30805980	30805980	PRJNA564013_P_NODE_247274_length_263_cov_18.955446_g244422_i0	PRJNA564013	247274	263	18.955446	49.85282298	Aphelenchoides fujianensis	1052528	Nematoda	Nematoda	53.5	7.45e-6	NR	KAI6234770.1	1052528	g244422	i0	34.9	1.893536121673	83	47	94.7	1	255	7	496	571	KAI6234770.1 MFS domain-containing protein [Aphelenchoides fujianensis]	diamond	498	53.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides fujianensis
30882861	30882861	PRJNA564013_P_NODE_258594_length_254_cov_5.984456_g255742_i0	PRJNA564013	258594	254	5.984456	15.20051824	root	1	Root_unresolved	Root_unresolved	43.5	0.022	NR	KAI1697050.1	166010	g255742	i0	38.3	1.52362204724409	47	29	55.5	0	76	216	294	340	KAI1697050.1 hypothetical protein DdX_18734 [Ditylenchus destructor]	diamond	387	43.9	0.990888382687927	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor
32797158	32797158	PRJNA564013_P_NODE_330860_length_208_cov_2.122449_g328008_i0	PRJNA564013	330860	208	2.122449	4.41469392	Bursaphelenchus xylophilus	6326	Nematoda	Nematoda	54.7	1.43e-6	NR	CAD5208455.1	6326	g328008	i0	53.7	0.591346153846154	41	19	59.1	0	71	193	355	395	CAD5208455.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	123	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus

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