metadata: contig_metadata: 9 rows where bioproject = "PRJNA1103784", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA1103784", tax_clade = "Opisthokonta" 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
212134	212134	PRJNA1103784_P_NODE_2201_length_359_cov_1.748252_g2146_i0	PRJNA1103784	2201	359	1.748252	6.27622468	Metazoa	33208	Nematoda	Nematoda	166	3.2e-46	NR	NP_001022078.1	6239	g2146	i0	66.9	16.7632311977716	118	39	98.6	0	354	1	314	431	NP_001022078.1 putative methylmalonate-semialdehyde/malonate-semialdehyde dehydrogenase [acylating], mitochondrial [Caenorhabditis elegans]	diamond	6018	167	0.994011976047904	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
212175	212175	PRJNA1103784_P_NODE_541_length_643_cov_3.017544_g487_i0	PRJNA1103784	541	643	3.017544	19.40280792	Rhabditida	6236	Nematoda	Nematoda	254	1.01e-82	NR	KAI1724111.1	166010	g487	i0	74.1	5.61275272161742	174	45	81.2	0	534	13	10	183	KAI1724111.1 ribosomal protein l5 domain-containing protein [Ditylenchus destructor]	diamond	3609	256	0.9921875	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor
23164483	23164483	PRJNA1103784_P_NODE_6339_length_248_cov_0.880000_g6284_i0	PRJNA1103784	6339	248	0.88	2.1824	Metazoa	33208	Nematoda	Nematoda	121	1.02e-30	NR	KRX94831.1	6337	g6284	i0	71.6	14.758064516129	81	23	98	0	246	4	251	331	KRX94831.1 60S ribosomal protein L5 [Trichinella pseudospiralis]	diamond	3660	121	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
28362444	28362444	PRJNA1103784_P_NODE_1726_length_395_cov_2.437888_g1671_i0	PRJNA1103784	1726	395	2.437888	9.6296576	Heterodera trifolii	157864	Nematoda	Nematoda	108	1.5e-25	NR	KAL3073343.1	157864	g1671	i0	44.4	0.956962025316456	126	70	95.7	0	394	17	141	266	KAL3073343.1 hypothetical protein niasHT_038700 [Heterodera trifolii]	diamond	378	108	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii
28732816	28732816	PRJNA1103784_P_NODE_2747_length_326_cov_1.217391_g2692_i0	PRJNA1103784	2747	326	1.217391	3.96869466	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	120	6.920000000000001e-29	NR	KRY33283.1	6334	g2692	i0	89.4	5.46625766871166	66	7	60.7	0	324	127	725	790	KRY33283.1 U3 small nucleolar RNA-associated protein 15 -like protein [Trichinella spiralis]	diamond	1782	121	0.991735537190083	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
29215281	29215281	PRJNA1103784_P_NODE_1469_length_419_cov_2.228324_g1414_i0	PRJNA1103784	1469	419	2.228324	9.33667756	Dracunculus medinensis	318479	Nematoda	Nematoda	100	1.97e-21	NR	VDN59526.1	318479	g1414	i0	50	3.94510739856802	110	54	78.8	1	80	409	11	119	VDN59526.1 unnamed protein product [Dracunculus medinensis]	diamond	1653	100	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Dracunculidae	Dracunculus	Dracunculus medinensis
29688368	29688368	PRJNA1103784_P_NODE_3390_length_300_cov_1.321586_g3335_i0	PRJNA1103784	3390	300	1.321586	3.964758	Meloidogyne graminicola	189291	Nematoda	Nematoda	51.6	4.85e-5	NR	AVZ46778.1	189291	g3335	i0	35.1	0.94	94	61	94	0	291	10	153	246	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	282	51.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
31236642	31236642	PRJNA1103784_P_NODE_5935_length_250_cov_0.870056_g5880_i0	PRJNA1103784	5935	250	0.870056	2.17514	Strongyloides ratti	34506	Nematoda	Nematoda	50.1	7.99e-5	NR	XP_024504516.1	34506	g5880	i0	40.8	1.164	49	29	58.8	0	147	1	78	126	XP_024504516.1 Transformer-2 sex-determining protein [Strongyloides ratti]	diamond	291	50.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
31616283	31616283	PRJNA1103784_P_NODE_1716_length_396_cov_1.325077_g1661_i0	PRJNA1103784	1716	396	1.325077	5.24730492	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	89.4	6.03e-20	NR	GMT18625.1	1538716	g1661	i0	41.5	0.984848484848485	130	70	97.7	3	3	389	2	126	GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus]	diamond	390	89.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus

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