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

9 rows where bioproject = "PRJNA485080", 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
2372925	2372925	PRJNA485080_P_NODE_41842_length_242_cov_0.887574_g41748_i0	PRJNA485080	41842	242	0.887574	2.14792908	Metazoa	33208	Platyhelminthes	Platyhelminthes	156	1.6200000000000002e-33	NTclustered	gi\|1084315499\|ref\|XM_018792062.1\|	6183	g41748	i0	87.879	45.3181818181818	132	16	55	0	25	156	224	355	Schistosoma mansoni hypothetical protein partial mRNA	blastn	10967	156	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
5552553	5552553	PRJNA485080_P_NODE_14385_length_297_cov_1.375000_g14291_i0	PRJNA485080	14385	297	1.375	4.08375	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	56.5	0.002	NTclustered	gi\|690818188\|emb\|LN312641.1\|	99802	g14291	i0	100	0.101010101010101	30	0	10	0	148	177	243	214	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0093051	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
6826879	6826879	PRJNA485080_P_NODE_38046_length_243_cov_1.000000_g37952_i0	PRJNA485080	38046	243	1	2.43	Metazoa	33208	Platyhelminthes	Platyhelminthes	96.7	2.3e-23	NR	XP_018644101.1	6183	g37952	i0	70	3.08641975308642	70	21	86.4	0	217	8	1	70	XP_018644101.1 hypothetical protein Smp_191100 [Schistosoma mansoni]	diamond	750	96.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
9377122	9377122	PRJNA485080_P_NODE_3708_length_486_cov_2.215496_g3614_i0	PRJNA485080	3708	486	2.215496	10.76731056	Diplorchis hangzhouensis	1131906	Platyhelminthes	Platyhelminthes	54.7	0.013	NTclustered	gi\|379771686\|gb\|JQ038227.1\|	1131906	g3614	i0	100	0.0596707818930041	29	0	6	0	330	358	5361	5389	Diplorchis hangzhouensis mitochondrion sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Diplorchis	Diplorchis hangzhouensis
18300966	18300966	PRJNA485080_P_NODE_42535_length_241_cov_0.916667_g42441_i0	PRJNA485080	42535	241	0.916667	2.20916747	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	96.7	2.3e-23	NR	XP_018644101.1	6183	g42441	i0	63.3	0.983402489626556	79	27	95.9	1	2	232	7	85	XP_018644101.1 hypothetical protein Smp_191100 [Schistosoma mansoni]	diamond	237	96.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
23401582	23401582	PRJNA485080_P_NODE_37639_length_244_cov_0.900585_g37545_i0	PRJNA485080	37639	244	0.900585	2.1974274	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	52.8	0.022	NTclustered	gi\|690472687\|emb\|LN012675.1\|	99802	g37545	i0	100	0.114754098360656	28	0	11	0	30	57	1547	1574	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0012520	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
24675247	24675247	PRJNA485080_P_NODE_32220_length_246_cov_0.890173_g32126_i0	PRJNA485080	32220	246	0.890173	2.18982558	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	52.8	0.022	NTclustered	gi\|690644328\|emb\|LN191298.1\|	99802	g32126	i0	100	0.113821138211382	28	0	11	0	1	28	196	169	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0026262	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
29271114	29271114	PRJNA485080_P_NODE_8769_length_350_cov_0.855596_g8675_i0	PRJNA485080	8769	350	0.855596	2.994586	root	1	Root_unresolved	Root_unresolved	49.3	1.93e-4	NR	XP_018644101.1	6183	g8675	i0	51.1	1.62	47	21	40.3	1	67	207	3	47	XP_018644101.1 hypothetical protein Smp_191100 [Schistosoma mansoni]	diamond	567	49.7	0.991951710261569	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
32352864	32352864	PRJNA485080_P_NODE_10979_length_326_cov_1.102767_g10885_i0	PRJNA485080	10979	326	1.102767	3.59502042	Protopolystoma xenopodis	117903	Platyhelminthes	Platyhelminthes	46.6	0.0014	NR	VEL09888.1	117903	g10885	i0	39.2	0.680981595092024	74	38	65.3	4	64	276	38	107	VEL09888.1 unnamed protein product [Protopolystoma xenopodis]	diamond	222	46.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Protopolystoma	Protopolystoma xenopodis

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