metadata: contig_metadata: 8 rows where bioproject = "PRJNA384462", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA384462", tax_kingdom = "Metazoa" and tax_phylum = "Platyhelminthes"

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
17653396	17653396	PRJNA384462_S_NODE_10874_length_178_cov_1.186047_g10758_i0	PRJNA384462	10874	178	1.186047	2.11116366	Metazoa	33208	Platyhelminthes	Platyhelminthes	104	4.1e-18	NTclustered	gi\|29690334\|gb\|AY157244.1\|	157069	g10758	i0	77.528	100.14606741573	178	36	100	3	1	178	3506	3333	Trichobilharzia regenti 28S large subunit ribosomal RNA gene, partial sequence	blastn	17826	104	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia regenti
27629335	27629335	PRJNA384462_S_NODE_9124_length_190_cov_1.446809_g9008_i0	PRJNA384462	9124	190	1.446809	2.7489371	Diphyllobothriidae	28843	Platyhelminthes	Platyhelminthes	62.8	1.05e-9	NR	VDK80226.1	60516	g9008	i0	49.2	4.78421052631579	61	30	96.3	1	6	188	112	171	VDK80226.1 unnamed protein product, partial [Dibothriocephalus latus]	diamond	909	62.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Dibothriocephalus	Dibothriocephalus latus
27787213	27787213	PRJNA384462_S_NODE_15524_length_161_cov_0.892857_g15408_i0	PRJNA384462	15524	161	0.892857	1.43749977	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	43.1	0.00907	NR	KAA0197456.1	27845	g15408	i0	48.9	3.93167701863354	47	23	87.6	1	1	141	677	722	KAA0197456.1 Ubiquitinyl hydrolase 1 [Fasciolopsis buskii]	diamond	633	43.5	0.990804597701149	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
28923546	28923546	PRJNA384462_S_NODE_14008_length_164_cov_1.200000_g13892_i0	PRJNA384462	14008	164	1.2	1.968	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	89.4	3.7e-20	NR	CAH8644034.1	6185	g13892	i0	75.9	29.6341463414634	54	13	98.8	0	2	163	27	80	CAH8644034.1 unnamed protein product [Schistosoma haematobium]	diamond	4860	90.1	0.992230854605993	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
29191073	29191073	PRJNA384462_S_NODE_7349_length_206_cov_3.222930_g7233_i0	PRJNA384462	7349	206	3.22293	6.6392358	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	50.4	4.42e-5	NR	KAL3317491.1	1844966	g7233	i0	59	1.1504854368932	39	15	56.8	1	204	88	1024	1061	KAL3317491.1 E1 ubiquitin-activating protein [Cichlidogyrus casuarinus]	diamond	237	50.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
29411897	29411897	PRJNA384462_S_NODE_4829_length_244_cov_1.364103_g4713_i0	PRJNA384462	4829	244	1.364103	3.32841132	Hymenolepis diminuta	6216	Platyhelminthes	Platyhelminthes	62.4	3.9e-10	NR	VDL64169.1	6216	g4713	i0	39.2	0.971311475409836	79	47	97.1	1	241	5	36	113	VDL64169.1 unnamed protein product [Hymenolepis diminuta]	diamond	237	62.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
32161809	32161809	PRJNA384462_S_NODE_8998_length_191_cov_1.359155_g8882_i0	PRJNA384462	8998	191	1.359155	2.59598605	Opisthorchis felineus	147828	Platyhelminthes	Platyhelminthes	43.5	0.0101	NR	TGZ36863.1	147828	g8882	i0	36.1	3.80104712041885	61	29	95.8	2	183	1	481	531	TGZ36863.1 hypothetical protein CRM22_011397 [Opisthorchis felineus]	diamond	726	43.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis felineus
32414871	32414871	PRJNA384462_S_NODE_3579_length_277_cov_1.307018_g3463_i0	PRJNA384462	3579	277	1.307018	3.62043986	Calicophoron daubneyi	300641	Platyhelminthes	Platyhelminthes	60.5	4.62e-9	NR	CAL5132835.1	300641	g3463	i0	42.2	0.693140794223827	64	37	69.3	0	275	84	16	79	CAL5132835.1 unnamed protein product [Calicophoron daubneyi]	diamond	192	60.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Paramphistomidae	Calicophoron	Calicophoron daubneyi

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