metadata: contig_metadata: 13 rows where bioproject = "PRJNA608894", tax_clade = "Opisthokonta" and tax

13 rows where bioproject = "PRJNA608894", tax_clade = "Opisthokonta" 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
1861144	1861144	PRJNA608894_P_NODE_24762_length_385_cov_1.926282_g24265_i0	PRJNA608894	24762	385	1.926282	7.4161857	Fasciolopsis buskii	27845	Platyhelminthes	Platyhelminthes	164	1.09e-48	NR	KAA0196388.1	27845	g24265	i0	69.9	7.79220779220779	113	34	88.1	0	339	1	4	116	KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii]	diamond	3000	164	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
2422404	2422404	PRJNA608894_P_NODE_62082_length_223_cov_5.726667_g61583_i0	PRJNA608894	62082	223	5.726667	12.77046741	Polycladida	6163	Platyhelminthes	Platyhelminthes	95.3	3.24e-15	NTclustered	gi\|2064684137\|dbj\|LC635089.1\|	1784806	g61583	i0	82.456	51.067264573991	114	14	49	3	57	166	158	269	Prosthiostomum grande ICHUM:6032 gene for 28S rRNA, partial sequence	blastn	11388	95.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Polycladida	Prosthiostomidae	Prosthiostomum	Prosthiostomum grande
8800002	8800002	PRJNA608894_P_NODE_52587_length_248_cov_1.760000_g52088_i0	PRJNA608894	52587	248	1.76	4.3648	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	100	3.66e-24	NR	KAH9278277.1	6210	g52088	i0	70.1	14.8427419354839	67	20	81	0	246	46	162	228	KAH9278277.1 60S ribosomal protein L11 [Echinococcus granulosus]	diamond	3681	101	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
14614093	14614093	PRJNA608894_P_NODE_20392_length_449_cov_45.430851_g19896_i0	PRJNA608894	20392	449	45.430851	203.98452099	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	756	0	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g19896	i0	97.722	0.977728285077951	439	10	98	0	8	446	12	450	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	439	756	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
29322125	29322125	PRJNA608894_P_NODE_46129_length_262_cov_1.470899_g45630_i0	PRJNA608894	46129	262	1.470899	3.85375538	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	55.8	1.14e-6	NR	XP_009170819.1	6198	g45630	i0	43.8	0.549618320610687	48	27	55	0	166	23	264	311	XP_009170819.1 hypothetical protein T265_07112 [Opisthorchis viverrini]	diamond	144	55.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
30238106	30238106	PRJNA608894_P_NODE_56412_length_244_cov_2.701754_g55913_i0	PRJNA608894	56412	244	2.701754	6.59227976	Fasciolopsis buskii	27845	Platyhelminthes	Platyhelminthes	61.6	7.43e-9	NR	KAA0193157.1	27845	g55913	i0	50	0.688524590163934	56	28	68.9	0	198	31	165	220	KAA0193157.1 Cathepsin L cysteine proteinase [Fasciolopsis buskii]	diamond	168	61.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
30396533	30396533	PRJNA608894_P_NODE_62433_length_199_cov_4.873016_g61934_i0	PRJNA608894	62433	199	4.873016	9.69730184	Fasciolopsis buskii	27845	Platyhelminthes	Platyhelminthes	72	7.87e-14	NR	KAA0200284.1	27845	g61934	i0	55.8	2.35175879396985	52	23	78.4	0	179	24	114	165	KAA0200284.1 Proline synthase co-transcribed bacterial protein [Fasciolopsis buskii]	diamond	468	72	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
31153985	31153985	PRJNA608894_P_NODE_53875_length_247_cov_0.885057_g53376_i0	PRJNA608894	53875	247	0.885057	2.18609079	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	60.8	1.26e-8	NR	PAA68761.1	282301	g53376	i0	56	3.92307692307692	50	22	60.7	0	210	61	215	264	PAA68761.1 hypothetical protein BOX15_Mlig013572g1 [Macrostomum lignano]	diamond	969	60.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
31534048	31534048	PRJNA608894_P_NODE_20816_length_442_cov_3.192412_g20320_i0	PRJNA608894	20816	442	3.192412	14.11046104	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	75.1	4.77e-14	NR	PAA82696.1	282301	g20320	i0	28.9	0.868778280542986	128	88	86.9	1	432	49	5	129	PAA82696.1 hypothetical protein BOX15_Mlig024657g1, partial [Macrostomum lignano]	diamond	384	75.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
31850072	31850072	PRJNA608894_P_NODE_15877_length_546_cov_2.758985_g15383_i0	PRJNA608894	15877	546	2.758985	15.0640581	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	60.8	3.33e-7	NR	PAA93605.1	282301	g15383	i0	27.3	1.45054945054945	132	91	72.5	2	90	485	323	449	PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano]	diamond	792	60.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
32071600	32071600	PRJNA608894_P_NODE_20918_length_440_cov_32.700272_g20422_i0	PRJNA608894	20918	440	32.700272	143.8811968	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	184	5.0899999999999993e-57	NR	AAY97887.1	6182	g20422	i0	72.7	0.872727272727273	128	35	87.3	0	430	47	1	128	AAY97887.1 unknown [Schistosoma japonicum]	diamond	384	184	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
32166752	32166752	PRJNA608894_P_NODE_18358_length_487_cov_2.874396_g17862_i0	PRJNA608894	18358	487	2.874396	13.99830852	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	108	3.7e-24	NR	PAA86220.1	282301	g17862	i0	36.8	1.0041067761807	163	98	98.6	3	2	481	76	236	PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano]	diamond	489	108	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
32766675	32766675	PRJNA608894_P_NODE_27100_length_360_cov_2.027875_g26601_i0	PRJNA608894	27100	360	2.027875	7.30035	Echinostoma caproni	27848	Platyhelminthes	Platyhelminthes	68.9	2.55e-11	NR	VDP83592.1	27848	g26601	i0	34.7	1.03333333333333	124	72	98.3	2	1	354	12	132	VDP83592.1 unnamed protein product [Echinostoma caproni]	diamond	372	68.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Echinostomatidae	Echinostoma	Echinostoma caproni

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