metadata: contig_metadata: 9 rows where bioproject = "PRJNA408129", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA408129", 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
1693238	1693238	PRJNA408129_S_NODE_21782_length_174_cov_2.948905_g21764_i0	PRJNA408129	21782	174	2.948905	5.1310947	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	56.5	0.001	NTclustered	gi\|421975963\|gb\|JQ913051.1\|	99802	g21764	i0	100	0.344827586206897	30	0	17	0	31	60	713	742	Spirometra erinaceieuropaei proteasome subunit alpha type 4 Spirometra erinaceieuropaei mRNA, complete cds	blastn	60	56.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
5522148	5522148	PRJNA408129_S_NODE_17465_length_186_cov_4.979866_g17447_i0	PRJNA408129	17465	186	4.979866	9.26255076	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	52.8	0.016	NTclustered	gi\|687239408\|emb\|LK399621.1\|	57078	g17447	i0	100	0.150537634408602	28	0	15	0	115	142	214	241	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0000167	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
6796290	6796290	PRJNA408129_S_NODE_4386_length_277_cov_2.841667_g4368_i0	PRJNA408129	4386	277	2.841667	7.87141759	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	54.7	0.007	NTclustered	gi\|690453515\|emb\|LN000501.1\|	99802	g4368	i0	100	0.104693140794224	29	0	10	0	22	50	25036	25008	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0000498	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
13172114	13172114	PRJNA408129_S_NODE_20591_length_177_cov_3.485714_g20573_i0	PRJNA408129	20591	177	3.485714	6.16971378	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	65.8	1.92e-6	NTclustered	gi\|687230000\|emb\|LK396402.1\|	57078	g20573	i0	91.837	3.11299435028249	49	1	27	3	61	108	909	955	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0003209	blastn	551	65.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
15110445	15110445	PRJNA408129_S_NODE_15452_length_193_cov_8.692308_g15434_i0	PRJNA408129	15452	193	8.692308	16.77615444	Metazoa	33208	Platyhelminthes	Platyhelminthes	291	3.2399999999999994e-74	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g15434	i0	99.379	83.419689119171	161	0	83	1	14	173	722	562	Schistosoma japonicum unknown mRNA	blastn	16100	291	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
29712770	29712770	PRJNA408129_S_NODE_15530_length_193_cov_4.166667_g15512_i0	PRJNA408129	15530	193	4.166667	8.04166731	Metazoa	33208	Platyhelminthes	Platyhelminthes	49.3	9.42e-5	NR	CAH8846348.1	157069	g15512	i0	33.3	8.51813471502591	54	36	83.9	0	163	2	268	321	CAH8846348.1 unnamed protein product [Trichobilharzia regenti]	diamond	1644	49.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia regenti
30439922	30439922	PRJNA408129_S_NODE_35333_length_151_cov_1.324561_g35315_i0	PRJNA408129	35333	151	1.324561	2.00008711	Schistosoma	6181	Platyhelminthes	Platyhelminthes	41.6	0.0141	NR	VDP56863.1	6186	g35315	i0	66.7	4.2317880794702	30	10	59.6	0	118	29	94	123	VDP56863.1 unnamed protein product, partial [Schistosoma curassoni]	diamond	639	41.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma curassoni
31813919	31813919	PRJNA408129_S_NODE_11597_length_212_cov_3.645714_g11579_i0	PRJNA408129	11597	212	3.645714	7.72891368	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	43.9	0.00998	NR	XP_009169131.1	6198	g11579	i0	41.7	1.18867924528302	48	26	65.1	1	26	163	97	144	XP_009169131.1 hypothetical protein T265_13854, partial [Opisthorchis viverrini]	diamond	252	43.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
32415237	32415237	PRJNA408129_S_NODE_879_length_397_cov_3.697222_g861_i0	PRJNA408129	879	397	3.697222	14.67797134	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	73.6	1.3e-12	NR	XP_051064138.1	6185	g861	i0	38.6	1.17128463476071	83	48	62.7	1	250	2	1	80	XP_051064138.1 uncharacterized protein MS3_00008898 [Schistosoma haematobium]	diamond	465	73.6	1	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);;