metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA797475" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA797475" 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
2057178	2057178	PRJNA797475_P_NODE_15382_length_281_cov_2.197115_g15283_i0	PRJNA797475	15382	281	2.197115	6.17389315	Caenorhabditis briggsae	6238	Nematoda	Nematoda	102	8.01e-26	NR	XP_002639762.1	6238	g15283	i0	69.4	0.768683274021352	72	22	76.9	0	217	2	16	87	XP_002639762.1 Protein CBR-RPL-30 [Caenorhabditis briggsae]	diamond	216	102	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
10985299	10985299	PRJNA797475_P_NODE_14569_length_286_cov_1.248826_g14470_i0	PRJNA797475	14569	286	1.248826	3.57164236	Steinernema carpocapsae	34508	Nematoda	Nematoda	99.4	2.28e-22	NR	TKR96790.1	34508	g14470	i0	59.1	0.692307692307692	66	27	69.2	0	3	200	119	184	TKR96790.1 hypothetical protein L596_010761 [Steinernema carpocapsae]	diamond	198	99.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
22894594	22894594	PRJNA797475_P_NODE_6078_length_409_cov_11.377976_g5980_i0	PRJNA797475	6078	409	11.377976	46.53592184	root	1	Root_unresolved	Root_unresolved	185	2.28e-57	NR	CDW60131.1	36087	g5980	i0	62.5	2.99266503667482	136	51	99.8	0	2	409	1	136	CDW60131.1 60S ribosomal protein L27a [Trichuris trichiura]	diamond	1224	186	0.99462365591397806	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
27148290	27148290	PRJNA797475_P_NODE_7442_length_374_cov_4.202658_g7343_i0	PRJNA797475	7442	374	4.202658	15.71794092	Dirofilaria immitis	6287	Nematoda	Nematoda	60.5	9.55e-8	NR	MCP9258340.1	6287	g7343	i0	42.4	2.55080213903743	66	38	52.9	0	286	89	352	417	MCP9258340.1 Acyl-CoA-binding domain-containing protein 6 [Dirofilaria immitis]	diamond	954	60.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Dirofilaria	Dirofilaria immitis
28506685	28506685	PRJNA797475_P_NODE_7187_length_380_cov_1.504886_g7088_i0	PRJNA797475	7187	380	1.504886	5.7185668	Trichuris trichiura	36087	Nematoda	Nematoda	174	3.99e-53	NR	CDW60131.1	36087	g7088	i0	61.9	6.86842105263158	126	48	99.5	0	3	380	6	131	CDW60131.1 60S ribosomal protein L27a [Trichuris trichiura]	diamond	2610	174	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
29012161	29012161	PRJNA797475_P_NODE_18328_length_266_cov_1.994819_g18229_i0	PRJNA797475	18328	266	1.994819	5.30621854	Anisakis simplex	6269	Nematoda	Nematoda	58.2	1.42e-8	NR	VDK28727.1	6269	g18229	i0	44.6	2.21052631578947	65	33	69.9	1	79	264	31	95	VDK28727.1 unnamed protein product [Anisakis simplex]	diamond	588	58.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
29052642	29052642	PRJNA797475_P_NODE_29728_length_241_cov_2.285714_g29629_i0	PRJNA797475	29728	241	2.285714	5.50857074	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	107	8.29e-25	NR	VBB30137.1	6277	g29629	i0	69	53.1908713692946	71	22	88.4	0	27	239	574	644	VBB30137.1 unnamed protein product [Acanthocheilonema viteae]	diamond	12819	108	0.990740740740741	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
30631549	30631549	PRJNA797475_P_NODE_7773_length_368_cov_1.044068_g7674_i0	PRJNA797475	7773	368	1.044068	3.84217024	Metazoa	33208	Nematoda	Nematoda	46.6	0.00486	NR	CAL2034575.1	135651	g7674	i0	47.8	1.5570652173913	46	21	35.9	2	357	226	124	168	CAL2034575.1 unnamed protein product [Caenorhabditis brenneri]	diamond	573	46.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri
32362073	32362073	PRJNA797475_P_NODE_24419_length_248_cov_0.880000_g24320_i0	PRJNA797475	24419	248	0.88	2.1824	Acanthocheilonema viteae	6277	Nematoda	Nematoda	52.4	7.83e-6	NR	VBB28430.1	6277	g24320	i0	54.7	2.56451612903226	53	24	64.1	0	2	160	140	192	VBB28430.1 unnamed protein product [Acanthocheilonema viteae]	diamond	636	52.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
32614703	32614703	PRJNA797475_P_NODE_17520_length_270_cov_2.345178_g17421_i0	PRJNA797475	17520	270	2.345178	6.3319806	Pristionchus pacificus	54126	Nematoda	Nematoda	48.9	4.17e-5	NR	KAF8374309.1	54126	g17421	i0	38.3	0.666666666666667	60	33	66.7	1	181	2	34	89	KAF8374309.1 dlc-2 [Pristionchus pacificus]	diamond	180	48.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus

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