metadata: contig_metadata: 11 rows where bioproject = "PRJNA1146029", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJNA1146029", 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
4117256	4117256	PRJNA1146029_P_NODE_8164_length_316_cov_2.069959_g7884_i0	PRJNA1146029	8164	316	2.069959	6.54107044	Diplorchis hangzhouensis	1131906	Platyhelminthes	Platyhelminthes	54.7	0.008	NTclustered	gi\|379771686\|gb\|JQ038227.1\|	1131906	g7884	i0	100	0.0917721518987342	29	0	9	0	99	127	5361	5389	Diplorchis hangzhouensis mitochondrion sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Diplorchis	Diplorchis hangzhouensis
17611331	17611331	PRJNA1146029_P_NODE_5154_length_382_cov_1.721683_g4876_i0	PRJNA1146029	5154	382	1.721683	6.57682906	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	133	9.6e-37	NR	KAA0196388.1	27845	g4876	i0	67.4	5.09685863874346	92	30	72.3	0	3	278	85	176	KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii]	diamond	1947	134	0.992537313432836	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
20691738	20691738	PRJNA1146029_P_NODE_7157_length_334_cov_1.084291_g6879_i0	PRJNA1146029	7157	334	1.084291	3.62153194	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	177	1.44e-52	NR	AKN21598.1	79327	g6879	i0	83.5	9.51197604790419	103	17	92.5	0	334	26	202	304	AKN21598.1 slc25a-30 [Schmidtea mediterranea]	diamond	3177	177	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
23242434	23242434	PRJNA1146029_P_NODE_15619_length_253_cov_1.255556_g15338_i0	PRJNA1146029	15619	253	1.255556	3.17655668	Metazoa	33208	Platyhelminthes	Platyhelminthes	89	2.92e-20	NR	KAF7233074.1	59628	g15338	i0	62	9.54545454545454	71	27	84.2	0	216	4	1	71	KAF7233074.1 hypothetical protein EG68_09577 [Paragonimus skrjabini miyazakii]	diamond	2415	89.7	0.992196209587514	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus skrjabini miyazakii
26912298	26912298	PRJNA1146029_P_NODE_6442_length_349_cov_0.818841_g6164_i0	PRJNA1146029	6442	349	0.818841	2.85775509	Hymenolepis microstoma	85433	Platyhelminthes	Platyhelminthes	131	1.13e-32	NR	CDS34356.1	85433	g6164	i0	55.6	2.01146131805158	117	51	99.7	1	2	349	472	588	CDS34356.1 calpain A [Hymenolepis microstoma]	diamond	702	131	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis microstoma
28649734	28649734	PRJNA1146029_P_NODE_21747_length_242_cov_0.905325_g21466_i0	PRJNA1146029	21747	242	0.905325	2.1908865	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	68.9	6.95e-13	NR	PAA84163.1	282301	g21466	i0	58.5	0.508264462809917	41	17	50.8	0	240	118	5	45	PAA84163.1 hypothetical protein BOX15_Mlig003052g1 [Macrostomum lignano]	diamond	123	68.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
29333181	29333181	PRJNA1146029_P_NODE_15089_length_257_cov_1.255435_g14808_i0	PRJNA1146029	15089	257	1.255435	3.22646795	Metazoa	33208	Platyhelminthes	Platyhelminthes	132	1.77e-35	NR	XP_009165781.1	6198	g14808	i0	67.1	10.9027237354086	85	28	99.2	0	255	1	116	200	XP_009165781.1 hypothetical protein T265_03112 [Opisthorchis viverrini]	diamond	2802	132	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
29849541	29849541	PRJNA1146029_P_NODE_9871_length_291_cov_1.059633_g9590_i0	PRJNA1146029	9871	291	1.059633	3.08353203	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	145	1.58e-41	NR	CAX77438.1	6182	g9590	i0	79.3	4.48453608247423	87	18	89.7	0	289	29	117	203	CAX77438.1 putative ribosomal protein L15 [Schistosoma japonicum]	diamond	1305	145	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30260405	30260405	PRJNA1146029_P_NODE_15632_length_253_cov_0.744444_g15351_i0	PRJNA1146029	15632	253	0.744444	1.88344332	Fasciola hepatica	6192	Platyhelminthes	Platyhelminthes	48.5	3.78e-5	NR	THD27271.1	6192	g15351	i0	55	1.75494071146245	60	25	68.8	2	251	78	22	81	THD27271.1 putative beta thymosin [Fasciola hepatica]	diamond	444	48.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
30986970	30986970	PRJNA1146029_P_NODE_19354_length_246_cov_0.890173_g19073_i0	PRJNA1146029	19354	246	0.890173	2.18982558	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	63.9	4.46e-10	NR	KAL3319887.1	1844966	g19073	i0	75	1.75609756097561	36	9	43.9	0	3	110	181	216	KAL3319887.1 60S ribosomal protein L10A [Cichlidogyrus casuarinus]	diamond	432	63.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
31777290	31777290	PRJNA1146029_P_NODE_16317_length_251_cov_0.865169_g16036_i0	PRJNA1146029	16317	251	0.865169	2.17157419	Protopolystoma xenopodis	117903	Platyhelminthes	Platyhelminthes	63.5	3.7e-11	NR	VEL26284.1	117903	g16036	i0	63.8	0.693227091633466	58	21	69.3	0	174	1	1	58	VEL26284.1 unnamed protein product [Protopolystoma xenopodis]	diamond	174	63.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Protopolystoma	Protopolystoma xenopodis

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