metadata: contig_metadata: 9 rows where bioproject = "PRJNA1041773", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA1041773", 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
2721385	2721385	PRJNA1041773_P_NODE_84403_length_248_cov_0.880000_g84070_i0	PRJNA1041773	84403	248	0.88	2.1824	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	52.8	0.022	NTclustered	gi\|687542916\|emb\|LK643079.1\|	57078	g84070	i0	100	0.112903225806452	28	0	11	0	128	155	31	58	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0226412	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
6548782	6548782	PRJNA1041773_P_NODE_72566_length_258_cov_1.275676_g72233_i0	PRJNA1041773	72566	258	1.275676	3.29124408	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	56.5	0.002	NTclustered	gi\|690868573\|emb\|LN370122.1\|	99802	g72233	i0	100	0.116279069767442	30	0	12	0	210	239	640	611	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0136321	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
9098298	9098298	PRJNA1041773_P_NODE_70788_length_261_cov_1.122340_g70455_i0	PRJNA1041773	70788	261	1.12234	2.9293074	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	54.7	0.007	NTclustered	gi\|687484592\|emb\|LK662766.1\|	57078	g70455	i0	94.444	0.137931034482759	36	0	13	2	9	43	788	754	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0243520	blastn	36	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
23960740	23960740	PRJNA1041773_P_NODE_37799_length_343_cov_2.292593_g37466_i0	PRJNA1041773	37799	343	2.292593	7.86359399	Metazoa	33208	Platyhelminthes	Platyhelminthes	606	5.519999999999998e-169	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g37466	i0	99.112	98.5481049562682	338	2	99	1	4	341	27	363	Schistosoma japonicum unknown mRNA	blastn	33802	610	0.99344262295082	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27446298	27446298	PRJNA1041773_P_NODE_101703_length_241_cov_0.916667_g101370_i0	PRJNA1041773	101703	241	0.916667	2.20916747	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	57.8	1.84e-7	NR	VZI06844.1	99802	g101370	i0	42.6	8.07883817427386	68	38	83.4	1	220	20	221	288	VZI06844.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	1947	57.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
28014569	28014569	PRJNA1041773_P_NODE_92425_length_245_cov_0.877907_g92092_i0	PRJNA1041773	92425	245	0.877907	2.15087215	Fasciolopsis buskii	27845	Platyhelminthes	Platyhelminthes	45.8	0.00315	NR	KAA0186855.1	27845	g92092	i0	55	0.489795918367347	40	17	49	1	126	245	564	602	KAA0186855.1 Phosphodiesterase [Fasciolopsis buskii]	diamond	120	45.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
30572119	30572119	PRJNA1041773_P_NODE_77373_length_251_cov_0.865169_g77040_i0	PRJNA1041773	77373	251	0.865169	2.17157419	Dibothriocephalus latus	60516	Platyhelminthes	Platyhelminthes	48.5	1.33e-4	NR	VDN24173.1	60516	g77040	i0	75.8	0.394422310756972	33	8	39.4	0	77	175	16	48	VDN24173.1 unnamed protein product [Dibothriocephalus latus]	diamond	99	48.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Dibothriocephalus	Dibothriocephalus latus
31070039	31070039	PRJNA1041773_P_NODE_85535_length_248_cov_0.880000_g85202_i0	PRJNA1041773	85535	248	0.88	2.1824	Trematoda	6178	Platyhelminthes	Platyhelminthes	62.4	4.83e-9	NR	XP_009175911.1	6198	g85202	i0	75.7	15.0725806451613	37	9	44.8	0	59	169	641	677	XP_009175911.1 hypothetical protein T265_15342, partial [Opisthorchis viverrini]	diamond	3738	62.8	0.993630573248408	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
32588264	32588264	PRJNA1041773_P_NODE_79759_length_250_cov_0.870056_g79426_i0	PRJNA1041773	79759	250	0.870056	2.17514	Metazoa	33208	Platyhelminthes	Platyhelminthes	52	2.26e-5	NR	XP_018647275.1	6183	g79426	i0	88	10.524	25	3	30	0	248	174	3307	3331	XP_018647275.1 dynein heavy chain, putative [Schistosoma mansoni]	diamond	2631	52.4	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni

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