metadata: contig_metadata: 8 rows where bioproject = "PRJNA801875", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA801875", 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
2497297	2497297	PRJNA801875_P_NODE_4502_length_154_cov_1.336134_g4399_i0	PRJNA801875	4502	154	1.336134	2.05764636	Caenorhabditis auriculariae	2777116	Nematoda	Nematoda	67.8	8.01e-12	NR	CAD6186715.1	2777116	g4399	i0	66.7	3.52597402597403	45	15	87.7	0	151	17	215	259	CAD6186715.1 unnamed protein product [Caenorhabditis auriculariae]	diamond	543	67.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis auriculariae
5904558	5904558	PRJNA801875_P_NODE_1945_length_262_cov_2.577093_g1842_i0	PRJNA801875	1945	262	2.577093	6.75198366	Strongyloides papillosus	174720	Nematoda	Nematoda	60.2	1.43e-4	NTclustered	gi\|687022673\|emb\|LM525587.1\|	174720	g1842	i0	90.909	0.16793893129771	44	4	17	0	153	196	102446	102403	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000010	blastn	44	60.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
26904917	26904917	PRJNA801875_P_NODE_3481_length_176_cov_1.113475_g3378_i0	PRJNA801875	3481	176	1.113475	1.959716	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	70.9	1.79e-12	NR	KRZ32977.1	6337	g3378	i0	56.9	10.8409090909091	58	25	98.9	0	3	176	262	319	KRZ32977.1 putative ATP-dependent RNA helicase DDX47, partial [Trichinella pseudospiralis]	diamond	1908	70.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
28231349	28231349	PRJNA801875_P_NODE_1086_length_390_cov_2.290141_g983_i0	PRJNA801875	1086	390	2.290141	8.9315499	Metazoa	33208	Nematoda	Nematoda	194	1.01e-59	NR	XP_024500476.1	34506	g983	i0	68.2	42.9769230769231	129	41	99.2	0	390	4	125	253	XP_024500476.1 40S ribosomal protein S4 [Strongyloides ratti]	diamond	16761	194	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
28885688	28885688	PRJNA801875_P_NODE_4308_length_158_cov_0.926829_g4205_i0	PRJNA801875	4308	158	0.926829	1.46438982	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	84.3	1.87e-17	NR	GMT25232.1	1538716	g4205	i0	67.3	9.83544303797468	52	17	98.7	0	157	2	288	339	GMT25232.1 hypothetical protein PFISCL1PPCAC_16529, partial [Pristionchus fissidentatus]	diamond	1554	84.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus
29201667	29201667	PRJNA801875_P_NODE_2589_length_212_cov_0.887006_g2486_i0	PRJNA801875	2589	212	0.887006	1.88045272	Steinernema carpocapsae	34508	Nematoda	Nematoda	54.3	1.96e-6	NR	TMS38225.1	34508	g2486	i0	34.7	2.0377358490566	72	43	96.2	2	208	5	73	144	TMS38225.1 hypothetical protein L596_004995 [Steinernema carpocapsae]	diamond	432	54.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
29999990	29999990	PRJNA801875_P_NODE_4471_length_155_cov_0.975000_g4368_i0	PRJNA801875	4471	155	0.975	1.51125	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	46.2	5.1e-4	NR	CAJ0582154.1	96644	g4368	i0	58.3	2.30322580645161	36	15	69.7	0	29	136	4	39	CAJ0582154.1 unnamed protein product, partial [Mesorhabditis spiculigera]	diamond	357	46.6	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Mesorhabditis	Mesorhabditis spiculigera
30758206	30758206	PRJNA801875_P_NODE_2834_length_200_cov_1.818182_g2731_i0	PRJNA801875	2834	200	1.818182	3.636364	Metazoa	33208	Nematoda	Nematoda	41.6	0.00833	NR	MFH4980180.1	75299	g2731	i0	31	2.91	58	39	87	1	177	4	14	70	MFH4980180.1 hypothetical protein [Gnathostoma spinigerum]	diamond	582	42	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum

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