metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA795983" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA795983" 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
2055867	2055867	PRJNA795983_S_NODE_11562_length_369_cov_1.239865_g11437_i0	PRJNA795983	11562	369	1.239865	4.57510185	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	100	6.92e-22	NR	CAH8562660.1	57078	g11437	i0	64.7	2.84552845528455	68	24	55.3	0	93	296	24	91	CAH8562660.1 unnamed protein product [Dicrocoelium dendriticum]	diamond	1050	100	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
4608605	4608605	PRJNA795983_S_NODE_40684_length_244_cov_0.900585_g40559_i0	PRJNA795983	40684	244	0.900585	2.1974274	Metazoa	33208	Platyhelminthes	Platyhelminthes	110	2.19e-29	NR	VDM02420.1	70667	g40559	i0	70.7	8.22540983606557	75	20	92.2	1	226	2	1	73	VDM02420.1 unnamed protein product [Schistocephalus solidus]	diamond	2007	110	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Schistocephalus	Schistocephalus solidus
7158377	7158377	PRJNA795983_S_NODE_16606_length_326_cov_2.549407_g16481_i0	PRJNA795983	16606	326	2.549407	8.31106682	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	146	4.1199999999999997e-38	NR	PAA64048.1	282301	g16481	i0	69.4	8.87116564417178	108	29	97.5	3	320	3	137	242	PAA64048.1 hypothetical protein BOX15_Mlig024523g3 [Macrostomum lignano]	diamond	2892	146	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
7594624	7594624	PRJNA795983_S_NODE_24866_length_285_cov_2.919811_g24741_i0	PRJNA795983	24866	285	2.919811	8.32146135	Metazoa	33208	Platyhelminthes	Platyhelminthes	91.7	3.53e-22	NR	PAA52392.1	282301	g24741	i0	80	4.97894736842105	50	10	52.6	0	243	94	1	50	PAA52392.1 hypothetical protein BOX15_Mlig007628g1 [Macrostomum lignano]	diamond	1419	92	0.996739130434783	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
8869724	8869724	PRJNA795983_S_NODE_8887_length_405_cov_1.750000_g8762_i0	PRJNA795983	8887	405	1.75	7.0875	Opisthorchiidae	6196	Platyhelminthes	Platyhelminthes	248	1.4e-79	NR	GAA52499.1	79923	g8762	i0	85.9	25	135	19	100	0	405	1	194	328	GAA52499.1 isocitrate dehydrogenase [Clonorchis sinensis]	diamond	10125	248	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis
18631610	18631610	PRJNA795983_S_NODE_27035_length_277_cov_2.598039_g26910_i0	PRJNA795983	27035	277	2.598039	7.19656803	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	139	3.65e-36	NR	ALJ32180.1	6182	g26910	i0	75.8	219.779783393502	91	22	98.6	0	3	275	369	459	ALJ32180.1 heat shock protein 70 [Schistosoma japonicum]	diamond	60879	139	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27316023	27316023	PRJNA795983_S_NODE_43163_length_241_cov_0.916667_g43038_i0	PRJNA795983	43163	241	0.916667	2.20916747	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	73.9	3.54e-13	NR	PAA51975.1	282301	g43038	i0	47.5	7.9045643153527	80	40	97.1	1	236	3	172	251	PAA51975.1 hypothetical protein BOX15_Mlig007695g2, partial [Macrostomum lignano]	diamond	1905	73.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
27496283	27496283	PRJNA795983_S_NODE_3903_length_552_cov_1.741127_g3781_i0	PRJNA795983	3903	552	1.741127	9.61102104	Rodentolepis nana	102285	Platyhelminthes	Platyhelminthes	77.8	2.95e-14	NR	VDO01380.1	102285	g3781	i0	37.9	1.33695652173913	132	69	64.7	5	37	393	32	163	VDO01380.1 unnamed protein product [Rodentolepis nana]	diamond	738	77.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Rodentolepis	Rodentolepis nana
30116888	30116888	PRJNA795983_S_NODE_28572_length_272_cov_2.100503_g28447_i0	PRJNA795983	28572	272	2.100503	5.71336816	Hymenolepis diminuta	6216	Platyhelminthes	Platyhelminthes	137	4.33e-36	NR	VDL16193.1	6216	g28447	i0	69.7	0.981617647058823	89	27	98.2	0	4	270	266	354	VDL16193.1 unnamed protein product [Hymenolepis diminuta]	diamond	267	137	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
31065134	31065134	PRJNA795983_S_NODE_30415_length_266_cov_1.829016_g30290_i0	PRJNA795983	30415	266	1.829016	4.86518256	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	86.7	1.87e-19	NR	AAW26362.1	6182	g30290	i0	50	4.48872180451128	76	33	81.2	2	50	265	19	93	AAW26362.1 SJCHGC08585 protein [Schistosoma japonicum]	diamond	1194	86.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
31381199	31381199	PRJNA795983_S_NODE_2616_length_647_cov_4.562718_g2502_i0	PRJNA795983	2616	647	4.562718	29.52078546	Mesocestoides corti	53468	Platyhelminthes	Platyhelminthes	260	1.08e-83	NR	VDD81745.1	53468	g2502	i0	64.7	5.97217928902628	215	61	99.7	1	646	2	1	200	VDD81745.1 unnamed protein product, partial [Mesocestoides corti]	diamond	3864	260	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Mesocestoididae	Mesocestoides	Mesocestoides corti
32172092	32172092	PRJNA795983_S_NODE_36718_length_250_cov_0.864407_g36593_i0	PRJNA795983	36718	250	0.864407	2.1610175	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	67.4	6.89e-11	NR	VZI39338.1	99802	g36593	i0	41.8	0.948	79	42	94.8	2	5	241	50	124	VZI39338.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	237	67.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
32465999	32465999	PRJNA795983_S_NODE_40879_length_244_cov_0.888889_g40754_i0	PRJNA795983	40879	244	0.888889	2.16888916	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	7.519999999999999e-31	NR	OON18522.1	6198	g40754	i0	69.6	36.5655737704918	79	22	94.7	1	244	14	178	256	OON18522.1 kinase domain protein, partial [Opisthorchis viverrini]	diamond	8922	124	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
32488449	32488449	PRJNA795983_S_NODE_10299_length_385_cov_0.951923_g10174_i0	PRJNA795983	10299	385	0.951923	3.66490355	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	55.5	6.02e-6	NR	PAA93605.1	282301	g10174	i0	28.9	1.77662337662338	114	75	88.8	2	379	38	327	434	PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano]	diamond	684	55.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano

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