metadata: contig_metadata: 6 rows where bioproject = "PRJNA807685", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA807685", 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
12286034	12286034	PRJNA807685_P_NODE_44910_length_182_cov_2.317241_g43837_i0	PRJNA807685	44910	182	2.317241	4.21737862	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	52.8	0.015	NTclustered	gi\|687576836\|emb\|LK582936.1\|	57078	g43837	i0	100	0.153846153846154	28	0	15	0	143	170	52	79	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0014129	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
23759239	23759239	PRJNA807685_P_NODE_47179_length_178_cov_1.092199_g46106_i0	PRJNA807685	47179	178	1.092199	1.94411422	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	52.8	0.015	NTclustered	gi\|687270827\|emb\|LK393228.1\|	57078	g46106	i0	100	0.157303370786517	28	0	16	0	45	72	7179	7152	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0000119	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
25033129	25033129	PRJNA807685_P_NODE_51880_length_169_cov_2.568182_g50807_i0	PRJNA807685	51880	169	2.568182	4.34022758	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	52.8	0.014	NTclustered	gi\|690579811\|emb\|LN130568.1\|	99802	g50807	i0	100	0.331360946745562	28	0	17	0	30	57	853	880	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0120729	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
27180378	27180378	PRJNA807685_P_NODE_61582_length_156_cov_2.327731_g60509_i0	PRJNA807685	61582	156	2.327731	3.63126036	Hymenolepis microstoma	85433	Platyhelminthes	Platyhelminthes	91.3	8.91e-20	NR	CDS33596.1	85433	g60509	i0	76.5	0.980769230769231	51	12	98.1	0	154	2	334	384	CDS33596.1 gag pol polyprotein [Hymenolepis microstoma]	diamond	153	91.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis microstoma
28159830	28159830	PRJNA807685_P_NODE_33665_length_216_cov_2.597765_g32592_i0	PRJNA807685	33665	216	2.597765	5.6111724	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	75.9	5.57e-14	NR	PAA47950.1	282301	g32592	i0	42.9	3.20833333333333	77	38	98.6	1	3	215	2414	2490	PAA47950.1 hypothetical protein BOX15_Mlig009479g4 [Macrostomum lignano]	diamond	693	75.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
29643263	29643263	PRJNA807685_P_NODE_44670_length_183_cov_1.404110_g43597_i0	PRJNA807685	44670	183	1.40411	2.5695213	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	68.9	9.91e-12	NR	XP_009169263.1	6198	g43597	i0	53.2	2.04918032786885	62	27	100	2	183	1	316	376	XP_009169263.1 hypothetical protein T265_05870 [Opisthorchis viverrini]	diamond	375	68.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini

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