metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA168635" 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
1054255	1054255	PRJNA168635_P_NODE_18121_length_189_cov_1.464286_g17705_i0	PRJNA168635	18121	189	1.464286	2.76750054	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87	1.87e-18	NR	NP_001370645.1	6239	g17705	i0	87.2	422.968253968254	47	6	74.6	0	143	3	190	236	NP_001370645.1 TATA-box-binding protein [Caenorhabditis elegans]	diamond	79941	87	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
27831967	27831967	PRJNA168635_P_NODE_18064_length_189_cov_1.971429_g17648_i0	PRJNA168635	18064	189	1.971429	3.72600081	Heligmosomoides polygyrus	6339	Nematoda	Nematoda	57	7.9e-8	NR	VDP10734.1	6339	g17648	i0	58.1	5.47619047619048	43	18	68.3	0	186	58	141	183	VDP10734.1 unnamed protein product, partial [Heligmosomoides polygyrus]	diamond	1035	57	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heligmosomidae	Heligmosomoides	Heligmosomoides polygyrus
28400354	28400354	PRJNA168635_P_NODE_15566_length_203_cov_2.610390_g15150_i0	PRJNA168635	15566	203	2.61039	5.2990917	Dirofilaria immitis	6287	Nematoda	Nematoda	41.2	0.0453	NR	MCP9259332.1	6287	g15150	i0	48.8	1.30049261083744	41	21	60.6	0	11	133	102	142	MCP9259332.1 hypothetical protein [Dirofilaria immitis]	diamond	264	41.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Dirofilaria	Dirofilaria immitis
28575985	28575985	PRJNA168635_P_NODE_19727_length_183_cov_2.291045_g19311_i0	PRJNA168635	19727	183	2.291045	4.19261235	Metazoa	33208	Nematoda	Nematoda	42	0.032	NR	KAL3998346.1	6277	g19311	i0	44.4	4.45901639344262	54	25	88.5	1	165	4	176	224	KAL3998346.1 Leucine Rich Repeat family protein [Acanthocheilonema viteae]	diamond	816	42	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
29049784	29049784	PRJNA168635_P_NODE_21988_length_176_cov_2.976378_g21572_i0	PRJNA168635	21988	176	2.976378	5.23842528	root	1	Root_unresolved	Root_unresolved	91.3	5.97e-22	NR	XP_024505722.1	34506	g21572	i0	92	304.261363636364	50	4	85.2	0	172	23	74	123	XP_024505722.1 Histone H2B family and Histone core domain and Histone-fold domain-containing protein [Strongyloides ratti]	diamond	53550	92	0.992391304347826	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
29916134	29916134	PRJNA168635_P_NODE_27211_length_167_cov_0.881356_g26795_i0	PRJNA168635	27211	167	0.881356	1.47186452	Mesorhabditis belari	2138241	Nematoda	Nematoda	41.2	0.0468	NR	CAJ0934037.1	2138241	g26795	i0	41.2	0.916167664670659	51	26	91.6	2	167	15	94	140	CAJ0934037.1 unnamed protein product, partial [Mesorhabditis belari]	diamond	153	41.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Mesorhabditis	Mesorhabditis belari
29947603	29947603	PRJNA168635_P_NODE_33211_length_158_cov_9.660550_g32795_i0	PRJNA168635	33211	158	9.66055	15.263669	Thelazia callipaeda	103827	Nematoda	Nematoda	44.7	2.72e-4	NR	VDN04148.1	103827	g32795	i0	42	0.949367088607595	50	29	94.9	0	7	156	14	63	VDN04148.1 unnamed protein product [Thelazia callipaeda]	diamond	150	44.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Thelaziidae	Thelazia	Thelazia callipaeda
29965423	29965423	PRJNA168635_P_NODE_28991_length_165_cov_0.896552_g28575_i0	PRJNA168635	28991	165	0.896552	1.4793108	Metazoa	33208	Nematoda	Nematoda	84.7	4.22e-19	NR	NP_502794.1	6239	g28575	i0	73.1	37.7454545454545	52	14	94.5	0	157	2	96	147	NP_502794.1 Small ribosomal subunit protein uS13 [Caenorhabditis elegans]	diamond	6228	85.1	0.995299647473561	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
30990334	30990334	PRJNA168635_P_NODE_28954_length_165_cov_0.896552_g28538_i0	PRJNA168635	28954	165	0.896552	1.4793108	Aphelenchoides besseyi	269767	Nematoda	Nematoda	51.2	7.8e-6	NR	KAI6179539.1	269767	g28538	i0	43.1	0.927272727272727	51	29	92.7	0	160	8	15	65	KAI6179539.1 Transmembrane emp24 domain-containing protein 2-like protein [Aphelenchoides besseyi]	diamond	153	51.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
31242880	31242880	PRJNA168635_P_NODE_12395_length_231_cov_3.357143_g11979_i0	PRJNA168635	12395	231	3.357143	7.75500033	Dirofilaria immitis	6287	Nematoda	Nematoda	54.3	1.09e-6	NR	MCP9259222.1	6287	g11979	i0	47.2	0.688311688311688	53	28	68.8	0	223	65	94	146	MCP9259222.1 putative serine acetyltransferase [Dirofilaria immitis]	diamond	159	54.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Dirofilaria	Dirofilaria immitis
31861627	31861627	PRJNA168635_P_NODE_25017_length_169_cov_1.725000_g24601_i0	PRJNA168635	25017	169	1.725	2.91525	Trichinella	6333	Nematoda	Nematoda	68.9	7.66e-12	NR	KAL1233081.1	6337	g24601	i0	60	3.90532544378698	55	22	97.6	0	167	3	785	839	KAL1233081.1 Acetyl-CoA carboxylase [Trichinella pseudospiralis]	diamond	660	68.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis

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