metadata: contig_metadata: 10 rows where bioproject = "PRJNA721440", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA721440", tax_kingdom = "Metazoa" 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
9638643	9638643	PRJNA721440_S_NODE_7728_length_225_cov_1.551136_g7602_i0	PRJNA721440	7728	225	1.551136	3.490056	Opisthokonta	33154	Nematoda	Nematoda	87	6.66e-18	NR	KRZ32977.1	6337	g7602	i0	59.5	16.8133333333333	74	30	98.7	0	222	1	269	342	KRZ32977.1 putative ATP-dependent RNA helicase DDX47, partial [Trichinella pseudospiralis]	diamond	3783	87.8	0.990888382687927	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
27652489	27652489	PRJNA721440_S_NODE_4284_length_283_cov_0.888889_g4158_i0	PRJNA721440	4284	283	0.888889	2.51555587	Mesorhabditis spiculigera	96644	Nematoda	Nematoda	83.2	3.79e-16	NR	CAJ0573087.1	96644	g4158	i0	45.4	1.02826855123675	97	47	98.6	2	2	280	870	964	CAJ0573087.1 unnamed protein product, partial [Mesorhabditis spiculigera]	diamond	291	83.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Mesorhabditis	Mesorhabditis spiculigera
27810362	27810362	PRJNA721440_S_NODE_12084_length_191_cov_1.098592_g11958_i0	PRJNA721440	12084	191	1.098592	2.09831072	Gongylonema pulchrum	637853	Nematoda	Nematoda	72.4	5.64e-13	NR	VDN19521.1	637853	g11958	i0	58.3	1.8848167539267	60	21	92.7	2	12	188	69	125	VDN19521.1 unnamed protein product [Gongylonema pulchrum]	diamond	360	72.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gongylonematidae	Gongylonema	Gongylonema pulchrum
27873311	27873311	PRJNA721440_S_NODE_11625_length_194_cov_1.434483_g11499_i0	PRJNA721440	11625	194	1.434483	2.78289702	Meloidogyne enterolobii	390850	Nematoda	Nematoda	144	5.6399999999999996e-40	NR	CAD2174570.1	390850	g11499	i0	100	0.989690721649485	64	0	99	0	193	2	81	144	CAD2174570.1 unnamed protein product [Meloidogyne enterolobii]	diamond	192	144	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
27915227	27915227	PRJNA721440_S_NODE_7625_length_226_cov_2.056497_g7499_i0	PRJNA721440	7625	226	2.056497	4.64768322	Rhabditida	6236	Nematoda	Nematoda	49.7	1.05e-4	NR	CAJ0606769.1	53992	g7499	i0	33.9	1.76548672566372	59	27	78.3	2	48	224	686	732	CAJ0606769.1 unnamed protein product [Cylicocyclus nassatus]	diamond	399	49.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Cylicocyclus	Cylicocyclus nassatus
27936601	27936601	PRJNA721440_S_NODE_18085_length_166_cov_1.376068_g17959_i0	PRJNA721440	18085	166	1.376068	2.28427288	Meloidogyne enterolobii	390850	Nematoda	Nematoda	112	1.59e-29	NR	CAD2170663.1	390850	g17959	i0	98	0.921686746987952	51	1	92.2	0	13	165	2	52	CAD2170663.1 unnamed protein product [Meloidogyne enterolobii]	diamond	153	112	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
31105027	31105027	PRJNA721440_S_NODE_7875_length_223_cov_2.988506_g7749_i0	PRJNA721440	7875	223	2.988506	6.66436838	root	1	Root_unresolved	Root_unresolved	45.1	0.00429	NR	KAI1720772.1	166010	g7749	i0	57.1	1.9237668161435	35	15	47.1	0	1	105	116	150	KAI1720772.1 UAA transporter family domain-containing protein [Ditylenchus destructor]	diamond	429	45.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor
31284269	31284269	PRJNA721440_S_NODE_15815_length_173_cov_1.354839_g15689_i0	PRJNA721440	15815	173	1.354839	2.34387147	Meloidogyne enterolobii	390850	Nematoda	Nematoda	116	1.59e-32	NR	CAD2167471.1	390850	g15689	i0	98.2	0.988439306358382	57	1	98.8	0	172	2	1	57	CAD2167471.1 unnamed protein product [Meloidogyne enterolobii]	diamond	171	116	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
31389897	31389897	PRJNA721440_S_NODE_15536_length_174_cov_1.664000_g15410_i0	PRJNA721440	15536	174	1.664	2.89536	Metazoa	33208	Nematoda	Nematoda	65.9	9.68e-11	NR	XP_042929296.1	6279	g15410	i0	55.4	10.6206896551724	56	25	96.6	0	172	5	284	339	XP_042929296.1 splicing factor, CC1-like family protein [Brugia malayi]	diamond	1848	65.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
31442502	31442502	PRJNA721440_S_NODE_15296_length_175_cov_1.809524_g15170_i0	PRJNA721440	15296	175	1.809524	3.166667	Meloidogyne enterolobii	390850	Nematoda	Nematoda	116	4.5199999999999995e-30	NR	CAK5126944.1	390850	g15170	i0	96.6	0.994285714285714	58	2	99.4	0	175	2	139	196	CAK5126944.1 unnamed protein product [Meloidogyne enterolobii]	diamond	174	116	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii

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