metadata: contig_metadata: 5 rows where bioproject = "PRJNA767802", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA767802", 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
5034391	5034391	PRJNA767802_P_NODE_2284_length_601_cov_4.769928_g2219_i0	PRJNA767802	2284	601	4.769928	28.66726728	Metazoa	33208	Platyhelminthes	Platyhelminthes	1105	0	NTclustered	gi\|60689738\|gb\|AY915254.1\|	6182	g2219	i0	100	99.9916805324459	598	0	99	0	1	598	1	598	Schistosoma japonicum clone SJCHGC03884 unknown mRNA	blastn	60095	1105	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
12224823	12224823	PRJNA767802_P_NODE_14490_length_178_cov_1.434109_g14417_i0	PRJNA767802	14490	178	1.434109	2.55271402	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	62.1	2.5e-5	NTclustered	gi\|687172112\|emb\|LN083550.1\|	99802	g14417	i0	97.222	6.7977528089887604	36	1	20	0	44	79	1841	1876	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0079971	blastn	1210	62.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
29263549	29263549	PRJNA767802_P_NODE_14129_length_181_cov_1.848485_g14056_i0	PRJNA767802	14129	181	1.848485	3.34575785	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	94	3.71e-23	NR	PAA69855.1	282301	g14056	i0	72.4	1.93922651933702	58	16	96.1	0	4	177	51	108	PAA69855.1 hypothetical protein BOX15_Mlig028979g1 [Macrostomum lignano]	diamond	351	94	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30558539	30558539	PRJNA767802_P_NODE_7673_length_273_cov_2.049107_g7600_i0	PRJNA767802	7673	273	2.049107	5.59406211	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	122	8.81e-34	NR	AAY97887.1	6182	g7600	i0	77.6	0.835164835164835	76	17	83.5	0	2	229	52	127	AAY97887.1 unknown [Schistosoma japonicum]	diamond	228	122	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30685009	30685009	PRJNA767802_P_NODE_3053_length_511_cov_3.272727_g2982_i0	PRJNA767802	3053	511	3.272727	16.72363497	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	65.9	4.73e-9	NR	PAA93605.1	282301	g2982	i0	25.8	0.727984344422701	124	91	72.8	1	101	472	322	444	PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano]	diamond	372	65.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano

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