metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA704949" 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
8842134	8842134	PRJNA704949_P_NODE_386527_length_437_cov_1.548969_g371449_i0	PRJNA704949	386527	437	1.548969	6.76899453	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	72.4	1.34e-11	NR	VDL98289.1	70667	g371449	i0	47.6	3.17162471395881	82	43	56.3	0	173	418	522	603	VDL98289.1 unnamed protein product [Schistocephalus solidus]	diamond	1386	72.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Schistocephalus	Schistocephalus solidus
26777640	26777640	PRJNA704949_P_NODE_103741_length_772_cov_3.702628_g91213_i0	PRJNA704949	103741	772	3.702628	28.58428816	root	1	Root_unresolved	Root_unresolved	59.3	4.78e-6	NR	VDO06853.1	102285	g91213	i0	46.3	2.62694300518135	67	36	26	0	763	563	262	328	VDO06853.1 unnamed protein product [Rodentolepis nana]	diamond	2028	59.7	0.993299832495812	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Rodentolepis	Rodentolepis nana
28220072	28220072	PRJNA704949_P_NODE_335146_length_467_cov_1.612440_g320210_i0	PRJNA704949	335146	467	1.61244	7.5300948	Paragonimus kellicotti	100269	Platyhelminthes	Platyhelminthes	45.8	0.0291	NR	KAF6778600.1	100269	g320210	i0	33.8	0.494646680942184	77	49	48.2	2	418	194	614	690	KAF6778600.1 hypothetical protein AHF37_02098 [Paragonimus kellicotti]	diamond	231	45.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus kellicotti
29546216	29546216	PRJNA704949_P_NODE_295950_length_494_cov_1.752809_g281167_i0	PRJNA704949	295950	494	1.752809	8.65887646	Echinostoma caproni	27848	Platyhelminthes	Platyhelminthes	115	1.07e-26	NR	VDP93582.1	27848	g281167	i0	38	1.96761133603239	163	98	97.2	1	4	483	191	353	VDP93582.1 unnamed protein product [Echinostoma caproni]	diamond	972	115	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Echinostomatidae	Echinostoma	Echinostoma caproni
30630951	30630951	PRJNA704949_P_NODE_1794913_length_178_cov_1.209302_g1779574_i0	PRJNA704949	1794913	178	1.209302	2.15255756	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	42.7	0.0155	NR	CAH8558113.1	1163369	g1779574	i0	41.3	2.4438202247191	46	27	77.5	0	149	12	135	180	CAH8558113.1 unnamed protein product [Schistosoma turkestanicum]	diamond	435	42.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma turkestanicum
31958946	31958946	PRJNA704949_P_NODE_2139637_length_163_cov_0.912281_g2124298_i0	PRJNA704949	2139637	163	0.912281	1.48701803	Metazoa	33208	Platyhelminthes	Platyhelminthes	60.8	1.77e-9	NR	CAH8579358.1	6184	g2124298	i0	53.7	3.82822085889571	54	25	99.4	0	1	162	20	73	CAH8579358.1 unnamed protein product, partial [Schistosoma bovis]	diamond	624	60.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma bovis
32738616	32738616	PRJNA704949_P_NODE_372860_length_444_cov_2.402532_g357813_i0	PRJNA704949	372860	444	2.402532	10.66724208	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	218	7.61e-66	NR	AAX28387.3	6182	g357813	i0	96.5	3.81081081081081	141	5	95.3	0	423	1	18	158	AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum]	diamond	1692	220	0.990909090909091	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum

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