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

10 rows where bioproject = "PRJNA1146029", 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
290101	290101	PRJNA1146029_P_NODE_19281_length_246_cov_0.890173_g19000_i0	PRJNA1146029	19281	246	0.890173	2.18982558	Strongyloides papillosus	174720	Nematoda	Nematoda	159	1.27e-34	NTclustered	gi\|687022666\|emb\|LM525580.1\|	174720	g19000	i0	78.715	43.3943089430894	249	45	99	8	1	245	237086	237330	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000007	blastn	10675	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
5393205	5393205	PRJNA1146029_P_NODE_11365_length_282_cov_1.454545_g11084_i0	PRJNA1146029	11365	282	1.454545	4.1018169	Mesorhabditis spiculigera	96644	Nematoda	Nematoda	516	7.67e-142	NTclustered	gi\|1865425464\|gb\|MT710287.1\|	96644	g11084	i0	99.645	95.9645390070922	282	1	100	0	1	282	849	1130	Mesorhabditis spiculigera strain JU3350 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	27062	516	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Mesorhabditis	Mesorhabditis spiculigera
27228528	27228528	PRJNA1146029_P_NODE_12183_length_277_cov_1.196078_g11902_i0	PRJNA1146029	12183	277	1.196078	3.31313606	Meloidogyne enterolobii	390850	Nematoda	Nematoda	43.9	0.00719	NR	CAD2139859.1	390850	g11902	i0	61.8	1.89530685920578	34	13	36.8	0	176	277	5	38	CAD2139859.1 unnamed protein product [Meloidogyne enterolobii]	diamond	525	43.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
27607801	27607801	PRJNA1146029_P_NODE_524_length_1207_cov_2.423280_g364_i0	PRJNA1146029	524	1207	2.42328	29.2489896	Meloidogyne graminicola	189291	Nematoda	Nematoda	112	2.77e-24	NR	AVZ46778.1	189291	g364	i0	51.5	0.323115161557581	130	62	32.1	1	343	729	117	246	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	390	112	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
28555043	28555043	PRJNA1146029_P_NODE_1167_length_825_cov_2.311170_g932_i0	PRJNA1146029	1167	825	2.31117	19.0671525	Meloidogyne graminicola	189291	Nematoda	Nematoda	61.6	5.73e-7	NR	AVZ46778.1	189291	g932	i0	33.1	0.472727272727273	130	87	47.3	0	739	350	117	246	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	390	61.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
29186584	29186584	PRJNA1146029_P_NODE_14589_length_260_cov_1.764706_g14308_i0	PRJNA1146029	14589	260	1.764706	4.5882356	Trichinella pseudospiralis	6337	Nematoda	Nematoda	48.5	3.67e-4	NR	KRY00128.1	6337	g14308	i0	60.5	2.97692307692308	43	17	49.6	0	131	259	148	190	KRY00128.1 Elongation factor 1-beta, partial [Trichinella pseudospiralis]	diamond	774	48.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
29238533	29238533	PRJNA1146029_P_NODE_10589_length_287_cov_1.107477_g10308_i0	PRJNA1146029	10589	287	1.107477	3.17845899	Rhabditida	6236	Nematoda	Nematoda	178	2.88e-52	NR	TKR64448.1	34508	g10308	i0	87.4	29.7909407665505	95	12	99.3	0	1	285	195	289	TKR64448.1 hypothetical protein L596_024975 [Steinernema carpocapsae]	diamond	8550	178	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
29722844	29722844	PRJNA1146029_P_NODE_20190_length_244_cov_0.900585_g19909_i0	PRJNA1146029	20190	244	0.900585	2.1974274	Toxocara canis	6265	Nematoda	Nematoda	62.4	4.65e-9	NR	KHN76607.1	6265	g19909	i0	38.8	3.84836065573771	80	49	98.4	0	5	244	526	605	KHN76607.1 Canalicular multispecific organic anion transporter 1 [Toxocara canis]	diamond	939	62.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
30090901	30090901	PRJNA1146029_P_NODE_5052_length_385_cov_2.916667_g4774_i0	PRJNA1146029	5052	385	2.916667	11.22916795	Metazoa	33208	Nematoda	Nematoda	191	2.07e-58	NR	XP_024500476.1	34506	g4774	i0	68.3	40.5584415584416	126	40	98.2	0	3	380	128	253	XP_024500476.1 40S ribosomal protein S4 [Strongyloides ratti]	diamond	15615	191	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
32851659	32851659	PRJNA1146029_P_NODE_4880_length_392_cov_1.492163_g4602_i0	PRJNA1146029	4880	392	1.492163	5.84927896	Aphelenchoides bicaudatus	293665	Nematoda	Nematoda	167	3.14e-49	NR	KAI6182696.1	293665	g4602	i0	65.6	4.88265306122449	128	44	98	0	384	1	15	142	KAI6182696.1 Ribosomal protein L1 domain containing protein [Aphelenchoides bicaudatus]	diamond	1914	167	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides bicaudatus

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