metadata: contig_metadata: 12 rows where bioproject = "PRJNA1041773", tax_clade = "Opisthokonta" and tax

12 rows where bioproject = "PRJNA1041773", 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
2721288	2721288	PRJNA1041773_P_NODE_77583_length_251_cov_0.865169_g77250_i0	PRJNA1041773	77583	251	0.865169	2.17157419	Strongyloides papillosus	174720	Nematoda	Nematoda	54.7	0.006	NTclustered	gi\|687022649\|emb\|LM525563.1\|	174720	g77250	i0	100	0.115537848605578	29	0	12	0	76	104	561381	561353	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000008	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
7823563	7823563	PRJNA1041773_P_NODE_82327_length_249_cov_0.875000_g81994_i0	PRJNA1041773	82327	249	0.875	2.17875	Caenorhabditis remanei	31234	Nematoda	Nematoda	294	3.39e-75	NTclustered	gi\|2445366874\|ref\|XM_003111644.2\|	31234	g81994	i0	88.477	97.2449799196787	243	28	98	0	7	249	23	265	Caenorhabditis remanei uncharacterized protein (GCK72_010699), partial mRNA	blastn	24214	294	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
12924018	12924018	PRJNA1041773_P_NODE_44771_length_318_cov_1.281633_g44438_i0	PRJNA1041773	44771	318	1.281633	4.07559294	Caenorhabditis briggsae	6238	Nematoda	Nematoda	289	2.09e-73	NTclustered	gi\|11095039\|gb\|AC084589.1\|CBRG41K24	6238	g44438	i0	87.854	89.4905660377358	247	29	78	1	44	290	5795	6040	Caenorhabditis briggsae cosmid G41K24, complete sequence	blastn	28458	289	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
27161362	27161362	PRJNA1041773_P_NODE_98682_length_242_cov_0.911243_g98349_i0	PRJNA1041773	98682	242	0.911243	2.20520806	Gnathostoma spinigerum	75299	Nematoda	Nematoda	41.2	0.0477	NR	MFH4984072.1	75299	g98349	i0	41.3	0.570247933884298	46	27	57	0	138	1	25	70	MFH4984072.1 hypothetical protein [Gnathostoma spinigerum]	diamond	138	41.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
27762044	27762044	PRJNA1041773_P_NODE_75964_length_253_cov_1.022222_g75631_i0	PRJNA1041773	75964	253	1.022222	2.58622166	Caenorhabditis briggsae	6238	Nematoda	Nematoda	76.6	4.84e-14	NR	XP_002645577.2	6238	g75631	i0	52.6	3.37944664031621	57	26	67.6	1	173	3	213	268	XP_002645577.2 Protein CBG05275 [Caenorhabditis briggsae]	diamond	855	76.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
28645980	28645980	PRJNA1041773_P_NODE_101487_length_241_cov_0.916667_g101154_i0	PRJNA1041773	101487	241	0.916667	2.20916747	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	84.3	8.44e-17	NR	KAE9550296.1	2598192	g101154	i0	97.6	0.510373443983402	41	1	51	0	80	202	19	59	KAE9550296.1 hypothetical protein FO519_006486 [Halicephalobus sp. NKZ332]	diamond	123	84.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
30983239	30983239	PRJNA1041773_P_NODE_100114_length_241_cov_1.404762_g99781_i0	PRJNA1041773	100114	241	1.404762	3.38547642	Trichuris suis	68888	Nematoda	Nematoda	55.8	8.74e-7	NR	KFD48333.1	68888	g99781	i0	54.2	0.597510373443983	48	22	59.8	0	240	97	520	567	KFD48333.1 hypothetical protein M513_10825 [Trichuris suis]	diamond	144	55.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
31481208	31481208	PRJNA1041773_P_NODE_59296_length_281_cov_1.480769_g58963_i0	PRJNA1041773	59296	281	1.480769	4.16096089	Metazoa	33208	Nematoda	Nematoda	46.2	0.00354	NR	KAI1715960.1	166010	g58963	i0	60.6	4.02491103202847	33	13	35.2	0	104	202	194	226	KAI1715960.1 FAD dependent oxidoreductase domain-containing protein [Ditylenchus destructor]	diamond	1131	46.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor
31489152	31489152	PRJNA1041773_P_NODE_63276_length_274_cov_0.825871_g62943_i0	PRJNA1041773	63276	274	0.825871	2.26288654	Trichinella nativa	6335	Nematoda	Nematoda	45.8	2.3e-4	NR	KRZ47273.1	6335	g62943	i0	100	0.240875912408759	22	0	24.1	0	260	195	12	33	KRZ47273.1 hypothetical protein T02_1459 [Trichinella nativa]	diamond	66	45.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nativa
31646898	31646898	PRJNA1041773_P_NODE_95277_length_243_cov_1.482353_g94944_i0	PRJNA1041773	95277	243	1.482353	3.60211779	Caenorhabditis brenneri	135651	Nematoda	Nematoda	169	8.98e-47	NR	EGT51887.1	135651	g94944	i0	98.8	0.987654320987654	80	1	98.8	0	2	241	1521	1600	EGT51887.1 CBN-DAF-2 protein [Caenorhabditis brenneri]	diamond	240	169	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri
31773494	31773494	PRJNA1041773_P_NODE_44077_length_320_cov_1.979757_g43744_i0	PRJNA1041773	44077	320	1.979757	6.3352224	Ostertagia ostertagi	6317	Nematoda	Nematoda	136	1.7599999999999998e-37	NR	KAK6031660.1	6317	g43744	i0	58.5	0.99375	106	44	99.4	0	2	319	23	128	KAK6031660.1 DNA (cytosine-5-)-methyltransferase [Ostertagia ostertagi]	diamond	318	136	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Ostertagia	Ostertagia ostertagi
32469884	32469884	PRJNA1041773_P_NODE_94359_length_244_cov_0.900585_g94026_i0	PRJNA1041773	94359	244	0.900585	2.1974274	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	50.8	3.55e-5	NR	KAE9549335.1	2598192	g94026	i0	69	0.35655737704918	29	9	35.7	0	243	157	189	217	KAE9549335.1 hypothetical protein FO519_007451 [Halicephalobus sp. NKZ332]	diamond	87	50.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332

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