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

9 rows where bioproject = "PRJNA1199330", 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
11804754	11804754	PRJNA1199330_P_NODE_83250_length_269_cov_3.137755_g82551_i0	PRJNA1199330	83250	269	3.137755	8.44056095	Strongyloides papillosus	174720	Nematoda	Nematoda	52.8	0.025	NTclustered	gi\|687022758\|emb\|LM525672.1\|	174720	g82551	i0	100	0.104089219330855	28	0	10	0	83	110	13481	13454	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000070	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
17622337	17622337	PRJNA1199330_P_NODE_93954_length_259_cov_2.279570_g93255_i0	PRJNA1199330	93954	259	2.27957	5.9040863	root	1	Root_unresolved	Root_unresolved	65.1	3.2e-11	NR	KRY02015.1	6337	g93255	i0	66.7	8.97683397683398	48	15	55.6	1	9	152	71	117	KRY02015.1 Glutathione peroxidase, partial [Trichinella pseudospiralis]	diamond	2325	65.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
19451045	19451045	PRJNA1199330_P_NODE_110216_length_246_cov_1.803468_g109517_i0	PRJNA1199330	110216	246	1.803468	4.43653128	Caenorhabditis elegans	6239	Nematoda	Nematoda	71.3	6.13e-8	NTclustered	gi\|687865493\|emb\|LK927818.1\|	6239	g109517	i0	100	49.0934959349593	38	0	15	0	27	64	33796	33759	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000250	blastn	12077	71.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
27293787	27293787	PRJNA1199330_P_NODE_25863_length_404_cov_3.731118_g25167_i0	PRJNA1199330	25863	404	3.731118	15.07371672	Bursaphelenchus xylophilus	6326	Nematoda	Nematoda	45.8	0.00369	NR	CAD5209027.1	6326	g25167	i0	44.4	0.334158415841584	45	24	33.4	1	395	261	56	99	CAD5209027.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	135	45.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
27660276	27660276	PRJNA1199330_P_NODE_75724_length_276_cov_3.014778_g75025_i0	PRJNA1199330	75724	276	3.014778	8.32078728	Rhabditida	6236	Nematoda	Nematoda	43.1	0.0336	NR	KIH56863.1	51022	g75025	i0	48.8	0.880434782608696	41	21	44.6	0	121	243	135	175	KIH56863.1 tetratricopeptide repeat protein, partial [Ancylostoma duodenale]	diamond	243	43.5	0.990804597701149	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma duodenale
28146597	28146597	PRJNA1199330_P_NODE_41445_length_320_cov_2.186235_g40746_i0	PRJNA1199330	41445	320	2.186235	6.995952	Mesorhabditis spiculigera	96644	Nematoda	Nematoda	49.3	4.06e-4	NR	CAJ0573541.1	96644	g40746	i0	39.5	0.80625	43	26	40.3	0	314	186	26	68	CAJ0573541.1 unnamed protein product, partial [Mesorhabditis spiculigera]	diamond	258	49.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Mesorhabditis	Mesorhabditis spiculigera
28418113	28418113	PRJNA1199330_P_NODE_56266_length_294_cov_1.959276_g55567_i0	PRJNA1199330	56266	294	1.959276	5.76027144	Strongylidae	27830	Nematoda	Nematoda	74.3	1.45e-13	NR	VDM70366.1	40348	g55567	i0	42.2	2.56122448979592	83	41	79.6	3	286	53	123	203	VDM70366.1 unnamed protein product, partial [Strongylus vulgaris]	diamond	753	74.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Strongylus	Strongylus vulgaris
31937354	31937354	PRJNA1199330_P_NODE_69197_length_282_cov_2.641148_g68498_i0	PRJNA1199330	69197	282	2.641148	7.44803736	Auanema sp. JU1783	2878363	Nematoda	Nematoda	43.1	0.0417	NR	CAI4232656.1	2878363	g68498	i0	36.2	0.617021276595745	58	37	61.7	0	280	107	407	464	CAI4232656.1 unnamed protein product [Auanema sp. JU1783]	diamond	174	43.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Auanema	Auanema sp. JU1783
32746594	32746594	PRJNA1199330_P_NODE_41820_length_318_cov_3.457143_g41121_i0	PRJNA1199330	41820	318	3.457143	10.99371474	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	43.5	0.0229	NR	EJW88476.1	6293	g41121	i0	39.6	1	48	29	45.3	0	11	154	9	56	EJW88476.1 calcyphosin [Wuchereria bancrofti]	diamond	318	43.9	0.990888382687927	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Wuchereria	Wuchereria bancrofti

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