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

10 rows where bioproject = "PRJNA408129", 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
9346493	9346493	PRJNA408129_S_NODE_188_length_525_cov_22.018443_g175_i0	PRJNA408129	188	525	22.018443	115.59682575	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.014	NTclustered	gi\|1972295320\|ref\|NM_073736.7\|	6239	g175	i0	100	0.220952380952381	29	0	6	0	320	348	1278	1250	Caenorhabditis elegans legumain (lgmn-1), mRNA	blastn	116	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
22094867	22094867	PRJNA408129_S_NODE_28898_length_160_cov_1.845528_g28880_i0	PRJNA408129	28898	160	1.845528	2.9528448	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.013	NTclustered	gi\|373219322\|emb\|FO080824.1\|	6239	g28880	i0	100	0.35	28	0	18	0	14	41	27808	27835	Caenorhabditis elegans YAC Y48G9A, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
26695580	26695580	PRJNA408129_S_NODE_7621_length_239_cov_3.717822_g7603_i0	PRJNA408129	7621	239	3.717822	8.88559458	Wuchereria bancrofti	6293	Nematoda	Nematoda	45.4	8.77e-4	NR	VDM17700.1	6293	g7603	i0	35.9	0.803347280334728	64	38	76.6	1	238	56	41	104	VDM17700.1 unnamed protein product [Wuchereria bancrofti]	diamond	192	45.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Wuchereria	Wuchereria bancrofti
29475188	29475188	PRJNA408129_S_NODE_28290_length_161_cov_2.032258_g28272_i0	PRJNA408129	28290	161	2.032258	3.27193538	Necator americanus	51031	Nematoda	Nematoda	67.4	1.96e-11	NR	XP_064060924.1	51031	g28272	i0	54.9	0.950310559006211	51	23	95	0	9	161	31	81	XP_064060924.1 hypothetical protein RB195_014673 [Necator americanus]	diamond	153	67.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
29538548	29538548	PRJNA408129_S_NODE_14010_length_200_cov_1.920245_g13992_i0	PRJNA408129	14010	200	1.920245	3.84049	Bursaphelenchus xylophilus	6326	Nematoda	Nematoda	50.4	4.09e-5	NR	CAD5210825.1	6326	g13992	i0	45.3	1.59	53	29	79.5	0	187	29	1348	1400	CAD5210825.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	318	50.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
30012505	30012505	PRJNA408129_S_NODE_3611_length_291_cov_2.736220_g3593_i0	PRJNA408129	3611	291	2.73622	7.9624002	Caenorhabditis bovis	2654633	Nematoda	Nematoda	45.8	0.00518	NR	CAB3410521.1	2654633	g3593	i0	47.6	1.7319587628866	63	22	53.6	5	29	184	281	343	CAB3410521.1 unnamed protein product [Caenorhabditis bovis]	diamond	504	45.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis bovis
30913820	30913820	PRJNA408129_S_NODE_8394_length_233_cov_1.688776_g8376_i0	PRJNA408129	8394	233	1.688776	3.93484808	Metazoa	33208	Nematoda	Nematoda	44.7	0.00262	NR	KAF8384232.1	54126	g8376	i0	61.8	2.78111587982833	34	13	43.8	0	54	155	27	60	KAF8384232.1 hypothetical protein PRIPAC_73374, partial [Pristionchus pacificus]	diamond	648	44.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
31086621	31086621	PRJNA408129_S_NODE_295_length_484_cov_7.825503_g277_i0	PRJNA408129	295	484	7.825503	37.87543452	Toxocara canis	6265	Nematoda	Nematoda	75.5	2e-14	NR	VDM50967.1	6265	g277	i0	79.5	3.56404958677686	44	9	27.3	0	3	134	58	101	VDM50967.1 unnamed protein product [Toxocara canis]	diamond	1725	75.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
31212543	31212543	PRJNA408129_S_NODE_17015_length_188_cov_2.119205_g16997_i0	PRJNA408129	17015	188	2.119205	3.9841054	Steinernema hermaphroditum	289476	Nematoda	Nematoda	57.8	8.81e-8	NR	KAK0415319.1	289476	g16997	i0	67.7	0.49468085106383	31	10	49.5	0	93	1	439	469	KAK0415319.1 hypothetical protein QR680_011886 [Steinernema hermaphroditum]	diamond	93	57.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema hermaphroditum
31972076	31972076	PRJNA408129_S_NODE_23998_length_169_cov_2.492424_g23980_i0	PRJNA408129	23998	169	2.492424	4.21219656	Aelurostrongylus abstrusus	321389	Nematoda	Nematoda	40.8	0.0374	NR	YP_007024792.1	321389	g23980	i0	47.6	0.745562130177515	42	21	74.6	1	17	142	2	42	YP_007024792.1 NADH dehydrogenase subunit 6 [Aelurostrongylus abstrusus]	diamond	126	40.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Aelurostrongylus	Aelurostrongylus abstrusus

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