metadata: contig_metadata: 11 rows where bioproject = "PRJEB81463", tax_kingdom = "Metazoa" and tax

11 rows where bioproject = "PRJEB81463", 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
2690562	2690562	PRJEB81463_P_NODE_22643_length_249_cov_2.107955_g22371_i0	PRJEB81463	22643	249	2.107955	5.24880795	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	113	1.02e-20	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g22371	i0	79.888	0.718875502008032	179	17	66	13	85	248	835	1009	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	179	113	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
7792947	7792947	PRJEB81463_P_NODE_6247_length_400_cov_3.262997_g5975_i0	PRJEB81463	6247	400	3.262997	13.051988	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	204	5.79e-62	NR	XP_009171688.1	6198	g5975	i0	78	35.76	132	29	99	0	3	398	4	135	XP_009171688.1 hypothetical protein T265_14389 [Opisthorchis viverrini]	diamond	14304	204	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
12894262	12894262	PRJEB81463_P_NODE_9291_length_330_cov_2.789883_g9019_i0	PRJEB81463	9291	330	2.789883	9.2066139	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	409	1.5999999999999998e-109	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g9019	i0	89.058	0.996969696969697	329	36	99	0	2	330	21	349	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	329	409	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
15443190	15443190	PRJEB81463_P_NODE_6933_length_380_cov_2.110749_g6661_i0	PRJEB81463	6933	380	2.110749	8.0208462	Metazoa	33208	Platyhelminthes	Platyhelminthes	233	1.75e-75	NR	Q26537.1	6183	g6661	i0	95.2	3.97894736842105	126	6	99.5	0	379	2	30	155	Q26537.1 RecName: Full=14-3-3 protein homolog 2; Short=14-3-3-2 [Schistosoma mansoni]	diamond	1512	233	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
24366146	24366146	PRJEB81463_P_NODE_13260_length_286_cov_1.877934_g12988_i0	PRJEB81463	13260	286	1.877934	5.37089124	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	2.36e-33	NR	VDM17221.1	6205	g12988	i0	60.9	21.6713286713287	92	36	96.5	0	276	1	112	203	VDM17221.1 unnamed protein product [Hydatigera taeniaeformis]	diamond	6198	124	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Hydatigera	Hydatigera taeniaeformis
28132584	28132584	PRJEB81463_P_NODE_24105_length_247_cov_1.770115_g23833_i0	PRJEB81463	24105	247	1.770115	4.37218405	Metazoa	33208	Platyhelminthes	Platyhelminthes	92.4	8.36e-20	NR	BAF63024.1	6161	g23833	i0	76.5	17.8178137651822	51	12	61.9	0	1	153	372	422	BAF63024.1 adaptor-related protein complex 1 mu 1 subunit [Dugesia japonica]	diamond	4401	93.2	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
28739696	28739696	PRJEB81463_P_NODE_8327_length_348_cov_3.527273_g8055_i0	PRJEB81463	8327	348	3.527273	12.27491004	Hymenolepis diminuta	6216	Platyhelminthes	Platyhelminthes	89.4	1.31e-19	NR	VUZ41708.1	6216	g8055	i0	72.4	3.68103448275862	58	16	50	0	176	3	8	65	VUZ41708.1 unnamed protein product [Hymenolepis diminuta]	diamond	1281	89.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
28929134	28929134	PRJEB81463_P_NODE_22528_length_250_cov_0.875706_g22256_i0	PRJEB81463	22528	250	0.875706	2.189265	Taenia asiatica	60517	Platyhelminthes	Platyhelminthes	57.4	2.79e-7	NR	VDK38483.1	60517	g22256	i0	38.6	1.98	88	49	99.6	2	2	250	184	271	VDK38483.1 unnamed protein product [Taenia asiatica]	diamond	495	57.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia asiatica
32335116	32335116	PRJEB81463_P_NODE_24459_length_247_cov_0.896552_g24187_i0	PRJEB81463	24459	247	0.896552	2.21448344	Metazoa	33208	Platyhelminthes	Platyhelminthes	80.1	4.28e-17	NR	KAK4474064.1	38744	g24187	i0	48.7	4.36032388663968	76	35	87.4	1	31	246	29	104	KAK4474064.1 hypothetical protein MN116_003374 [Schistosoma mekongi]	diamond	1077	80.5	0.995031055900621	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mekongi
32595243	32595243	PRJEB81463_P_NODE_14620_length_279_cov_1.485437_g14348_i0	PRJEB81463	14620	279	1.485437	4.14436923	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	50.8	8.05e-5	NR	PAA93605.1	282301	g14348	i0	30.4	0.989247311827957	92	63	98.9	1	1	276	332	422	PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano]	diamond	276	50.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
32776663	32776663	PRJEB81463_P_NODE_27660_length_243_cov_0.911765_g27388_i0	PRJEB81463	27660	243	0.911765	2.21558895	Schistosoma	6181	Platyhelminthes	Platyhelminthes	54.3	3.08e-6	NR	XP_051071994.1	6185	g27388	i0	41	3.02469135802469	61	34	72.8	1	238	62	204	264	XP_051071994.1 Polyadenylate-binding protein 4 [Schistosoma haematobium]	diamond	735	54.7	0.992687385740402	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium

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